| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| New Construction | 0% | $12,170 | $13,170 | $17,909 | $19,539 | $21,777 | $21,410 | $27,615 | $28,966 | $28,366 | $23,163 | $18,842 | $14,635 |
| Repair work | 0% | $12,777 | $14,555 | $16,909 | $19,539 | $20,285 | $21,410 | $25,615 | $33,111 | $28,366 | $23,163 | $18,842 | $15,842 |
| Alteration work | 0% | $14,222 | $12,170 | $16,909 | $19,539 | $20,285 | $21,410 | $25,615 | $30,861 | $28,366 | $23,163 | $18,842 | $14,378 |
| Total Sales | $39,169 | $39,895 | $51,727 | $58,617 | $62,347 | $64,230 | $78,845 | $92,938 | $85,098 | $69,489 | $56,526 | $44,855 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| New Construction | $8,580 | $9,285 | $12,626 | $13,775 | $15,353 | $15,094 | $19,469 | $20,421 | $19,998 | $17,372 | $13,849 | $10,976 | |
| Repair work | $9,008 | $10,261 | $11,921 | $15,338 | $15,924 | $15,094 | $18,059 | $23,343 | $21,275 | $16,330 | $13,284 | $11,169 | |
| Alteration work | $10,027 | $8,580 | $11,921 | $15,338 | $15,924 | $15,094 | $18,059 | $21,757 | $21,275 | $16,330 | $13,284 | $10,136 | |
| Subtotal Direct Cost of Sales | $27,614 | $28,126 | $36,468 | $44,451 | $47,200 | $45,282 | $55,586 | $65,521 | $62,547 | $50,032 | $40,416 | $32,281 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Mr. Robert Fosse, CEO | 0% | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 |
| Mr. David West, General Project Manager | 0% | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 |
| Mrs. Janet Fosse, Office Manager | 0% | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
| Job Supervisor | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Temporary employees | 0% | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 |
| Total People | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | |
| Total Payroll | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | |
| General Assumptions | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| 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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | $39,169 | $39,895 | $51,727 | $58,617 | $62,347 | $64,230 | $78,845 | $92,938 | $85,098 | $69,489 | $56,526 | $44,855 | |
| Direct Cost of Sales | $27,614 | $28,126 | $36,468 | $44,451 | $47,200 | $45,282 | $55,586 | $65,521 | $62,547 | $50,032 | $40,416 | $32,281 | |
| Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $27,614 | $28,126 | $36,468 | $44,451 | $47,200 | $45,282 | $55,586 | $65,521 | $62,547 | $50,032 | $40,416 | $32,281 | |
| Gross Margin | $11,555 | $11,769 | $15,259 | $14,166 | $15,147 | $18,948 | $23,259 | $27,417 | $22,551 | $19,457 | $16,110 | $12,574 | |
| Gross Margin % | 29.50% | 29.50% | 29.50% | 24.17% | 24.29% | 29.50% | 29.50% | 29.50% | 26.50% | 28.00% | 28.50% | 28.03% | |
| Expenses | |||||||||||||
| Payroll | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | |
| Sales and Marketing and Other Expenses | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Rent | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Utilities | $110 | $110 | $110 | $110 | $110 | $110 | $110 | $110 | $110 | $110 | $110 | $110 | |
| Insurance | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
| Payroll Taxes | 15% | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 |
| Other | $0 | $200 | $500 | $0 | $500 | $0 | $0 | $500 | $500 | $0 | $0 | $0 | |
| Total Operating Expenses | $17,860 | $18,060 | $18,360 | $17,860 | $18,360 | $17,860 | $17,860 | $18,360 | $18,360 | $17,860 | $17,860 | $17,860 | |
| Profit Before Interest and Taxes | ($6,305) | ($6,291) | ($3,101) | ($3,694) | ($3,213) | $1,088 | $5,399 | $9,057 | $4,191 | $1,597 | ($1,750) | ($5,286) | |
| EBITDA | ($6,305) | ($6,291) | ($3,101) | ($3,694) | ($3,213) | $1,088 | $5,399 | $9,057 | $4,191 | $1,597 | ($1,750) | ($5,286) | |
| Interest Expense | $320 | $314 | $309 | $304 | $299 | $294 | $289 | $284 | $279 | $274 | $269 | $264 | |
| Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Net Profit | ($6,625) | ($6,605) | ($3,410) | ($3,999) | ($3,512) | $794 | $5,111 | $8,773 | $3,912 | $1,323 | ($2,019) | ($5,550) | |
| Net Profit/Sales | -16.92% | -16.56% | -6.59% | -6.82% | -5.63% | 1.24% | 6.48% | 9.44% | 4.60% | 1.90% | -3.57% | -12.37% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | $25,460 | $25,932 | $33,623 | $38,101 | $40,526 | $41,750 | $51,249 | $60,410 | $55,314 | $45,168 | $36,742 | $29,156 | |
| Cash from Receivables | $11,579 | $12,035 | $13,718 | $14,101 | $18,185 | $20,559 | $21,843 | $22,651 | $27,760 | $32,437 | $29,602 | $24,170 | |
| Subtotal Cash from Operations | $37,038 | $37,967 | $47,340 | $52,202 | $58,710 | $62,309 | $73,093 | $83,061 | $83,074 | $77,605 | $66,344 | $53,326 | |
| 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 | $37,038 | $37,967 | $47,340 | $52,202 | $58,710 | $62,309 | $73,093 | $83,061 | $83,074 | $77,605 | $66,344 | $53,326 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | |
| Bill Payments | $25,998 | $18,420 | $32,638 | $49,549 | $56,314 | $53,631 | $47,117 | $70,403 | $79,521 | $62,130 | $39,185 | $32,750 | |
| Subtotal Spent on Operations | $40,998 | $33,420 | $47,638 | $64,549 | $71,314 | $68,631 | $62,117 | $85,403 | $94,521 | $77,130 | $54,185 | $47,750 | |
| 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 | $400 | $500 | $400 | $400 | $500 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
| Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Long-term Liabilities Principal Repayment | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| 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 | $41,598 | $34,120 | $48,238 | $65,149 | $72,014 | $69,231 | $62,717 | $86,003 | $95,121 | $77,730 | $54,785 | $48,350 | |
| Net Cash Flow | ($4,560) | $3,847 | ($898) | ($12,947) | ($13,304) | ($6,922) | $10,375 | ($2,942) | ($12,048) | ($125) | $11,559 | $4,976 | |
| Cash Balance | $35,868 | $39,715 | $38,816 | $25,870 | $12,566 | $5,644 | $16,020 | $13,078 | $1,030 | $905 | $12,464 | $17,440 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | $40,428 | $35,868 | $39,715 | $38,816 | $25,870 | $12,566 | $5,644 | $16,020 | $13,078 | $1,030 | $905 | $12,464 | $17,440 |
| Accounts Receivable | $23,157 | $25,288 | $27,215 | $31,602 | $38,017 | $41,654 | $43,575 | $49,327 | $59,204 | $61,228 | $53,113 | $43,295 | $34,824 |
| Inventory | $43,220 | $30,376 | $30,939 | $40,114 | $48,896 | $51,920 | $49,810 | $61,144 | $72,073 | $68,802 | $55,035 | $44,458 | $35,509 |
| Other Current Assets | $37,991 | $37,991 | $37,991 | $37,991 | $37,991 | $37,991 | $37,991 | $37,991 | $37,991 | $37,991 | $37,991 | $37,991 | $37,991 |
| Total Current Assets | $144,796 | $129,522 | $135,860 | $148,524 | $150,774 | $144,131 | $137,020 | $164,482 | $182,347 | $169,051 | $147,044 | $138,207 | $125,764 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $20,421 | $20,421 | $20,421 | $20,421 | $20,421 | $20,421 | $20,421 | $20,421 | $20,421 | $20,421 | $20,421 | $20,421 | $20,421 |
| Accumulated Depreciation | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 |
| Total Long-term Assets | $12,421 | $12,421 | $12,421 | $12,421 | $12,421 | $12,421 | $12,421 | $12,421 | $12,421 | $12,421 | $12,421 | $12,421 | $12,421 |
| Total Assets | $157,217 | $141,943 | $148,281 | $160,945 | $163,195 | $156,552 | $149,441 | $176,903 | $194,768 | $181,472 | $159,465 | $150,628 | $138,185 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | $25,400 | $17,352 | $30,995 | $47,669 | $54,518 | $52,087 | $44,782 | $67,733 | $77,424 | $60,817 | $38,086 | $31,868 | $25,575 |
| Current Borrowing | $20,000 | $19,600 | $19,100 | $18,700 | $18,300 | $17,800 | $17,400 | $17,000 | $16,600 | $16,200 | $15,800 | $15,400 | $15,000 |
| Other Current Liabilities | $21,677 | $21,677 | $21,677 | $21,677 | $21,677 | $21,677 | $21,677 | $21,677 | $21,677 | $21,677 | $21,677 | $21,677 | $21,677 |
| Subtotal Current Liabilities | $67,077 | $58,629 | $71,772 | $88,046 | $94,495 | $91,564 | $83,859 | $106,410 | $115,701 | $98,694 | $75,563 | $68,945 | $62,252 |
| Long-term Liabilities | $19,039 | $18,839 | $18,639 | $18,439 | $18,239 | $18,039 | $17,839 | $17,639 | $17,439 | $17,239 | $17,039 | $16,839 | $16,639 |
| Total Liabilities | $86,116 | $77,468 | $90,411 | $106,485 | $112,734 | $109,603 | $101,698 | $124,049 | $133,140 | $115,933 | $92,602 | $85,784 | $78,891 |
| Paid-in Capital | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Retained Earnings | $71,101 | $71,101 | $71,101 | $71,101 | $71,101 | $71,101 | $71,101 | $71,101 | $71,101 | $71,101 | $71,101 | $71,101 | $71,101 |
| Earnings | $0 | ($6,625) | ($13,231) | ($16,641) | ($20,640) | ($24,152) | ($23,357) | ($18,247) | ($9,474) | ($5,561) | ($4,238) | ($6,257) | ($11,807) |
| Total Capital | $71,101 | $64,476 | $57,870 | $54,460 | $50,461 | $46,949 | $47,744 | $52,854 | $61,627 | $65,540 | $66,863 | $64,844 | $59,294 |
| Total Liabilities and Capital | $157,217 | $141,943 | $148,281 | $160,945 | $163,195 | $156,552 | $149,441 | $176,903 | $194,768 | $181,472 | $159,465 | $150,628 | $138,185 |
| Net Worth | $71,101 | $64,476 | $57,870 | $54,460 | $50,461 | $46,949 | $47,744 | $52,854 | $61,627 | $65,540 | $66,863 | $64,844 | $59,294 |