ReHabiliments
Appendix
Sales Forecast | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Sales | |||||||||||||
Men’s Apparel | 0% | $0 | $0 | $100,000 | $102,000 | $104,040 | $106,121 | $108,243 | $110,408 | $112,616 | $114,869 | $117,166 | $119,509 |
Women’s Apparel | 0% | $0 | $0 | $150,000 | $154,500 | $159,135 | $163,909 | $168,826 | $173,891 | $179,108 | $184,481 | $190,016 | $195,716 |
Boy’s Apparel | 0% | $0 | $0 | $20,000 | $20,800 | $21,632 | $22,497 | $23,397 | $24,333 | $25,306 | $26,319 | $27,371 | $28,466 |
Girl’s Apparel | 0% | $0 | $0 | $21,000 | $21,420 | $21,848 | $22,285 | $22,731 | $23,186 | $23,649 | $24,122 | $24,605 | $25,097 |
Infants’/Toddlers’ Apparel | 0% | $0 | $0 | $28,000 | $28,560 | $29,131 | $29,714 | $30,308 | $30,914 | $31,533 | $32,163 | $32,806 | $33,463 |
Internet Sales | 0% | $0 | $0 | $180,000 | $183,600 | $187,272 | $191,017 | $194,838 | $198,735 | $202,709 | $206,763 | $210,899 | $215,117 |
Total Sales | $0 | $0 | $499,000 | $510,880 | $523,059 | $535,544 | $548,344 | $561,467 | $574,922 | $588,717 | $602,863 | $617,368 | |
Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
All Product Lines | $0 | $0 | $99,800 | $102,176 | $104,612 | $107,109 | $109,669 | $112,293 | $114,984 | $117,743 | $120,573 | $123,474 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $0 | $99,800 | $102,176 | $104,612 | $107,109 | $109,669 | $112,293 | $114,984 | $117,743 | $120,573 | $123,474 |
Personnel Plan | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
President/CEO | 0% | $0 | $8,554 | $8,554 | $8,554 | $8,554 | $8,554 | $8,554 | $8,554 | $8,554 | $8,554 | $8,554 | $8,554 |
Chief Financial Officer | 0% | $0 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 |
VP of Product Development | 0% | $3,189 | $3,189 | $3,189 | $3,189 | $3,189 | $3,189 | $3,189 | $3,189 | $3,189 | $3,189 | $3,189 | $3,189 |
VP of Business Development | 0% | $0 | $0 | $3,815 | $3,815 | $3,815 | $3,815 | $3,815 | $3,815 | $3,815 | $3,815 | $3,815 | $3,815 |
VP of Supply Chain Management | 0% | $0 | $0 | $3,944 | $3,944 | $3,944 | $3,944 | $3,944 | $3,944 | $3,944 | $3,944 | $3,944 | $3,944 |
VP of Sales and Marketing | 0% | $0 | $0 | $4,379 | $4,379 | $4,379 | $4,379 | $4,379 | $4,379 | $4,379 | $4,379 | $4,379 | $4,379 |
Executive Assistant | 0% | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 |
Senior Fashion Designer | 0% | $4,750 | $4,750 | $4,750 | $4,750 | $4,750 | $4,750 | $4,750 | $4,750 | $4,750 | $4,750 | $4,750 | $4,750 |
Design Assistant | 0% | $0 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 |
Seamstress | 0% | $0 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 |
Assistant Seamstress | 0% | $0 | $1,760 | $1,760 | $1,760 | $1,760 | $1,760 | $1,760 | $1,760 | $1,760 | $1,760 | $1,760 | $1,760 |
Pattern Cutter 1 | 0% | $0 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 |
Pattern Cutter 2 | 0% | $0 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 |
Warehouse Manager | 0% | $2,115 | $4,229 | $4,229 | $4,229 | $4,229 | $4,229 | $4,229 | $4,229 | $4,229 | $4,229 | $4,229 | $4,229 |
Heavy Truck Driver/Warehouse Assistant | 0% | $0 | $0 | $0 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 |
Packer/Shipping & Receiving Clerk 1 | 0% | $0 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 |
Packer/Shipping & Receiving Clerk 2 | 0% | $0 | $0 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 |
Packer/Shipping & Receiving Clerk 3 | 0% | $0 | $0 | $0 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 |
Packer/Shipping & Receiving Clerk 4 | 0% | $0 | $0 | $0 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 | $1,520 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 4 | 12 | 16 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | |
Total Payroll | $12,454 | $40,422 | $54,080 | $59,040 | $59,040 | $59,040 | $59,040 | $59,040 | $59,040 | $59,040 | $59,040 | $59,040 |
General Assumptions | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
Current Interest Rate | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | |
Long-term Interest Rate | 3.50% | 3.50% | 3.50% | 3.50% | 3.50% | 3.50% | 3.50% | 3.50% | 3.50% | 3.50% | 3.50% | 3.50% | |
Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Pro Forma Profit and Loss | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Sales | $0 | $0 | $499,000 | $510,880 | $523,059 | $535,544 | $548,344 | $561,467 | $574,922 | $588,717 | $602,863 | $617,368 | |
Direct Cost of Sales | $0 | $0 | $99,800 | $102,176 | $104,612 | $107,109 | $109,669 | $112,293 | $114,984 | $117,743 | $120,573 | $123,474 | |
Shipping/Postage | $0 | $0 | $12,475 | $12,772 | $13,076 | $13,389 | $13,709 | $14,037 | $14,373 | $14,718 | $15,072 | $15,434 | |
Total Cost of Sales | $0 | $0 | $112,275 | $114,948 | $117,688 | $120,497 | $123,377 | $126,330 | $129,357 | $132,461 | $135,644 | $138,908 | |
Gross Margin | $0 | $0 | $386,725 | $395,932 | $405,370 | $415,046 | $424,966 | $435,137 | $445,564 | $456,256 | $467,219 | $478,460 | |
Gross Margin % | 0.00% | 0.00% | 77.50% | 77.50% | 77.50% | 77.50% | 77.50% | 77.50% | 77.50% | 77.50% | 77.50% | 77.50% | |
Expenses | |||||||||||||
Payroll | $12,454 | $40,422 | $54,080 | $59,040 | $59,040 | $59,040 | $59,040 | $59,040 | $59,040 | $59,040 | $59,040 | $59,040 | |
Temporary Staff | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $3,120 | $3,120 | $29,634 | |
Depreciation | $359 | $359 | $359 | $359 | $359 | $359 | $359 | $359 | $359 | $359 | $359 | $359 | |
Office Supplies | $200 | $202 | $204 | $206 | $208 | $210 | $212 | $214 | $217 | $219 | $221 | $223 | |
Travel/Entertainment | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
Marketing/Promotion | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | |
Maintenance | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Dues/Subscriptions | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Photocopies | $1,000 | $1,010 | $1,020 | $1,030 | $1,041 | $1,051 | $1,062 | $1,072 | $1,083 | $1,094 | $1,105 | $1,116 | |
Cellular Phone | $300 | $303 | $306 | $309 | $312 | $315 | $318 | $322 | $325 | $328 | $331 | $335 | |
Telephone | $400 | $404 | $408 | $412 | $416 | $420 | $425 | $429 | $433 | $437 | $442 | $446 | |
Vehicle Expenses | $1,000 | $1,010 | $1,020 | $1,030 | $1,041 | $1,051 | $1,062 | $1,072 | $1,083 | $1,094 | $1,105 | $1,116 | |
Internet Fees | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Rent | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | |
Utilities | $600 | $600 | $800 | $800 | $800 | $800 | $800 | $800 | $1,100 | $1,100 | $1,100 | $1,100 | |
Insurance | $127 | $127 | $127 | $127 | $127 | $127 | $127 | $127 | $127 | $127 | $127 | $127 | |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Consulting Accountant | $1,500 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Consulting Attorney | 15% | $1,500 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Charitable Donations | 15% | $0 | $0 | $0 | $24,950 | $25,544 | $26,153 | $26,777 | $27,417 | $28,073 | $28,746 | $29,436 | $30,143 |
Bad Debt Expense | $0 | $0 | $7,984 | $8,174 | $8,369 | $8,569 | $8,773 | $8,983 | $9,199 | $9,419 | $9,646 | $9,878 | |
Total Operating Expenses | $34,190 | $59,187 | $81,058 | $111,188 | $112,006 | $112,845 | $113,705 | $114,586 | $115,788 | $119,833 | $120,781 | $148,266 | |
Profit Before Interest and Taxes | ($34,190) | ($59,187) | $305,667 | $284,744 | $293,364 | $302,201 | $311,262 | $320,551 | $329,776 | $336,423 | $346,438 | $330,194 | |
EBITDA | ($33,831) | ($58,828) | $306,026 | $285,104 | $293,723 | $302,560 | $311,621 | $320,910 | $330,135 | $336,782 | $346,797 | $330,553 | |
Interest Expense | $1,448 | $1,438 | $1,428 | $1,418 | $1,408 | $1,398 | $1,387 | $1,377 | $1,366 | $1,356 | $1,345 | $1,334 | |
Taxes Incurred | ($10,692) | ($18,188) | $91,272 | $84,998 | $87,587 | $90,241 | $92,962 | $95,752 | $98,523 | $100,520 | $103,528 | $98,658 | |
Net Profit | ($24,947) | ($42,438) | $212,967 | $198,328 | $204,369 | $210,562 | $216,912 | $223,422 | $229,887 | $234,547 | $241,565 | $230,202 | |
Net Profit/Sales | 0.00% | 0.00% | 42.68% | 38.82% | 39.07% | 39.32% | 39.56% | 39.79% | 39.99% | 39.84% | 40.07% | 37.29% |
Pro Forma Cash Flow | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $0 | $0 | $249,500 | $255,440 | $261,529 | $267,772 | $274,172 | $280,733 | $287,461 | $294,359 | $301,431 | $308,684 | |
Cash from Receivables | $0 | $0 | $0 | $8,317 | $249,698 | $255,643 | $261,737 | $267,985 | $274,391 | $280,958 | $287,691 | $294,594 | |
Subtotal Cash from Operations | $0 | $0 | $249,500 | $263,757 | $511,227 | $523,415 | $535,909 | $548,719 | $561,851 | $575,316 | $589,122 | $603,278 | |
Additional Cash Received | |||||||||||||
Sales Tax, VAT, HST/GST Received | 0.00% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
New Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Other Liabilities (interest-free) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales of Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales of Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Investment Received | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $0 | $0 | $249,500 | $263,757 | $511,227 | $523,415 | $535,909 | $548,719 | $561,851 | $575,316 | $589,122 | $603,278 | |
Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Expenditures from Operations | |||||||||||||
Cash Spending | $12,454 | $40,422 | $54,080 | $59,040 | $59,040 | $59,040 | $59,040 | $59,040 | $59,040 | $59,040 | $59,040 | $59,040 | |
Bill Payments | $404 | $11,784 | $11,314 | $290,187 | $255,973 | $262,181 | $268,546 | $275,071 | $281,768 | $288,903 | $298,046 | $305,875 | |
Subtotal Spent on Operations | $12,859 | $52,206 | $65,394 | $349,227 | $315,013 | $321,221 | $327,586 | $334,111 | $340,808 | $347,943 | $357,086 | $364,915 | |
Additional Cash Spent | |||||||||||||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Principal Repayment of Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $3,396 | $3,423 | $3,451 | $3,478 | $3,506 | $3,534 | $3,562 | $3,591 | $3,620 | $3,648 | $3,678 | $3,707 | |
Purchase Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Purchase Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Spent | $16,255 | $55,629 | $68,844 | $352,705 | $318,519 | $324,755 | $331,148 | $337,702 | $344,428 | $351,591 | $360,764 | $368,623 | |
Net Cash Flow | ($16,255) | ($55,629) | $180,656 | ($88,948) | $192,708 | $198,659 | $204,761 | $211,017 | $217,424 | $223,725 | $228,358 | $234,656 | |
Cash Balance | $372,528 | $316,899 | $497,555 | $408,606 | $601,315 | $799,974 | $1,004,735 | $1,215,751 | $1,433,175 | $1,656,901 | $1,885,259 | $2,119,915 |
Pro Forma Balance Sheet | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $388,783 | $372,528 | $316,899 | $497,555 | $408,606 | $601,315 | $799,974 | $1,004,735 | $1,215,751 | $1,433,175 | $1,656,901 | $1,885,259 | $2,119,915 |
Accounts Receivable | $0 | $0 | $0 | $249,500 | $496,623 | $508,455 | $520,584 | $533,018 | $545,766 | $558,836 | $572,237 | $585,978 | $600,068 |
Inventory | $50,000 | $50,000 | $50,000 | $109,780 | $112,394 | $115,073 | $117,820 | $120,636 | $123,523 | $126,483 | $129,518 | $132,630 | $135,821 |
Other Current Assets | $24,950 | $24,950 | $24,950 | $24,950 | $24,950 | $24,950 | $24,950 | $24,950 | $24,950 | $24,950 | $24,950 | $24,950 | $24,950 |
Total Current Assets | $463,733 | $447,478 | $391,849 | $881,785 | $1,042,573 | $1,249,792 | $1,463,327 | $1,683,339 | $1,909,990 | $2,143,445 | $2,383,606 | $2,628,817 | $2,880,753 |
Long-term Assets | |||||||||||||
Long-term Assets | $34,485 | $34,485 | $34,485 | $34,485 | $34,485 | $34,485 | $34,485 | $34,485 | $34,485 | $34,485 | $34,485 | $34,485 | $34,485 |
Accumulated Depreciation | $0 | $359 | $718 | $1,078 | $1,437 | $1,796 | $2,155 | $2,515 | $2,874 | $3,233 | $3,592 | $3,951 | $4,311 |
Total Long-term Assets | $34,485 | $34,126 | $33,767 | $33,407 | $33,048 | $32,689 | $32,330 | $31,970 | $31,611 | $31,252 | $30,893 | $30,534 | $30,174 |
Total Assets | $498,218 | $481,604 | $425,616 | $915,192 | $1,075,622 | $1,282,481 | $1,495,657 | $1,715,309 | $1,941,602 | $2,174,697 | $2,414,499 | $2,659,350 | $2,910,927 |
Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Current Liabilities | |||||||||||||
Accounts Payable | $0 | $11,729 | $1,601 | $281,661 | $247,241 | $253,237 | $259,385 | $265,687 | $272,148 | $278,976 | $287,879 | $294,844 | $319,926 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $0 | $11,729 | $1,601 | $281,661 | $247,241 | $253,237 | $259,385 | $265,687 | $272,148 | $278,976 | $287,879 | $294,844 | $319,926 |
Long-term Liabilities | $500,000 | $496,604 | $493,181 | $489,730 | $486,252 | $482,746 | $479,212 | $475,650 | $472,059 | $468,439 | $464,791 | $461,113 | $457,406 |
Total Liabilities | $500,000 | $508,333 | $494,782 | $771,392 | $733,493 | $735,983 | $738,597 | $741,337 | $744,207 | $747,415 | $752,670 | $755,957 | $777,332 |
Paid-in Capital | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 |
Retained Earnings | ($24,782) | ($24,782) | ($24,782) | ($24,782) | ($24,782) | ($24,782) | ($24,782) | ($24,782) | ($24,782) | ($24,782) | ($24,782) | ($24,782) | ($24,782) |
Earnings | $0 | ($24,947) | ($67,385) | $145,582 | $343,911 | $548,280 | $758,842 | $975,754 | $1,199,176 | $1,429,063 | $1,663,610 | $1,905,175 | $2,135,377 |
Total Capital | ($1,782) | ($26,729) | ($69,166) | $143,801 | $342,129 | $546,498 | $757,060 | $973,972 | $1,197,394 | $1,427,281 | $1,661,828 | $1,903,394 | $2,133,596 |
Total Liabilities and Capital | $498,218 | $481,604 | $425,616 | $915,192 | $1,075,622 | $1,282,481 | $1,495,657 | $1,715,309 | $1,941,602 | $2,174,697 | $2,414,499 | $2,659,350 | $2,910,927 |
Net Worth | ($1,782) | ($26,729) | ($69,166) | $143,801 | $342,129 | $546,498 | $757,060 | $973,972 | $1,197,394 | $1,427,281 | $1,661,828 | $1,903,394 | $2,133,596 |