| 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 | ||
| Unit Sales | |||||||||||||
| Commercial Buildings | 0% | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 |
| Government Contracts | 0% | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 2 | 1 | 1 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 1 | 1 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Commercial Buildings | $2,000,000.00 | $2,000,000.00 | $2,000,000.00 | $2,000,000.00 | $2,000,000.00 | $2,000,000.00 | $2,000,000.00 | $2,000,000.00 | $2,000,000.00 | $2,000,000.00 | $2,000,000.00 | $2,000,000.00 | |
| Government Contracts | $500,000.00 | $500,000.00 | $500,000.00 | $500,000.00 | $500,000.00 | $500,000.00 | $500,000.00 | $500,000.00 | $500,000.00 | $500,000.00 | $500,000.00 | $500,000.00 | |
| Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | |
| Sales | |||||||||||||
| Commercial Buildings | $2,000,000 | $2,300,000 | $2,645,000 | $3,041,750 | $3,498,013 | $4,000,000 | $4,000,000 | $4,000,000 | $4,000,000 | $4,000,000 | $2,000,000 | $2,000,000 | |
| Government Contracts | $500,000 | $0 | $0 | $0 | $0 | $500,000 | $500,000 | $500,000 | $500,000 | $550,000 | $0 | $0 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Sales | $2,500,000 | $2,300,000 | $2,645,000 | $3,041,750 | $3,498,013 | $4,500,000 | $4,500,000 | $4,500,000 | $4,500,000 | $4,550,000 | $2,000,000 | $2,000,000 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Commercial Buildings | 0.00% | $900,000.00 | $900,000.00 | $900,000.00 | $900,000.00 | $900,000.00 | $900,000.00 | $900,000.00 | $900,000.00 | $900,000.00 | $900,000.00 | $900,000.00 | $900,000.00 |
| Government Contracts | 0.00% | $250,000.00 | $250,000.00 | $250,000.00 | $250,000.00 | $250,000.00 | $250,000.00 | $250,000.00 | $250,000.00 | $250,000.00 | $250,000.00 | $250,000.00 | $250,000.00 |
| Other | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Direct Cost of Sales | |||||||||||||
| Commercial Buildings | $900,000 | $1,035,000 | $1,190,250 | $1,368,788 | $1,574,106 | $1,800,000 | $1,800,000 | $1,800,000 | $1,800,000 | $1,800,000 | $900,000 | $900,000 | |
| Government Contracts | $250,000 | $0 | $0 | $0 | $0 | $250,000 | $250,000 | $250,000 | $250,000 | $275,000 | $0 | $0 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $1,150,000 | $1,035,000 | $1,190,250 | $1,368,788 | $1,574,106 | $2,050,000 | $2,050,000 | $2,050,000 | $2,050,000 | $2,075,000 | $900,000 | $900,000 | |
| 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 | ||
| Owners | 0% | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
| Office personnel | 0% | $116,650 | $116,650 | $116,650 | $116,650 | $116,650 | $116,650 | $116,650 | $116,650 | $116,650 | $116,650 | $116,650 | $116,650 |
| Foremen | 0% | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 |
| Crew Workers | 0% | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 |
| Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total People | 60 | 60 | 60 | 60 | 70 | 70 | 70 | 80 | 80 | 80 | 80 | 100 | |
| Total Payroll | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | |
| 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 | 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 | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | $2,500,000 | $2,300,000 | $2,645,000 | $3,041,750 | $3,498,013 | $4,500,000 | $4,500,000 | $4,500,000 | $4,500,000 | $4,550,000 | $2,000,000 | $2,000,000 | |
| Direct Cost of Sales | $1,150,000 | $1,035,000 | $1,190,250 | $1,368,788 | $1,574,106 | $2,050,000 | $2,050,000 | $2,050,000 | $2,050,000 | $2,075,000 | $900,000 | $900,000 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $1,150,000 | $1,035,000 | $1,190,250 | $1,368,788 | $1,574,106 | $2,050,000 | $2,050,000 | $2,050,000 | $2,050,000 | $2,075,000 | $900,000 | $900,000 | |
| Gross Margin | $1,350,000 | $1,265,000 | $1,454,750 | $1,672,963 | $1,923,907 | $2,450,000 | $2,450,000 | $2,450,000 | $2,450,000 | $2,475,000 | $1,100,000 | $1,100,000 | |
| Gross Margin % | 54.00% | 55.00% | 55.00% | 55.00% | 55.00% | 54.44% | 54.44% | 54.44% | 54.44% | 54.40% | 55.00% | 55.00% | |
| Expenses | |||||||||||||
| Payroll | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | |
| Sales and Marketing and Other Expenses | $919,950 | $919,950 | $919,950 | $919,950 | $919,950 | $919,950 | $919,950 | $919,950 | $919,950 | $69,950 | $69,950 | $69,950 | |
| Depreciation | 15% | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 |
| Utilities | 5% | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 |
| Payroll Taxes | 15% | $44,498 | $44,498 | $44,498 | $44,498 | $44,498 | $44,498 | $44,498 | $44,498 | $44,498 | $44,498 | $44,498 | $44,498 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $1,286,798 | $1,286,798 | $1,286,798 | $1,286,798 | $1,286,798 | $1,286,798 | $1,286,798 | $1,286,798 | $1,286,798 | $436,798 | $436,798 | $436,798 | |
| Profit Before Interest and Taxes | $63,203 | ($21,798) | $167,953 | $386,165 | $637,109 | $1,163,203 | $1,163,203 | $1,163,203 | $1,163,203 | $2,038,203 | $663,203 | $663,203 | |
| EBITDA | $88,203 | $3,203 | $192,953 | $411,165 | $662,109 | $1,188,203 | $1,188,203 | $1,188,203 | $1,188,203 | $2,063,203 | $688,203 | $688,203 | |
| Interest Expense | $35,277 | $35,277 | $35,277 | $35,277 | $35,277 | $35,277 | $35,277 | $35,277 | $35,277 | $35,277 | $35,277 | $35,277 | |
| Taxes Incurred | $6,981 | ($14,269) | $33,169 | $87,722 | $150,458 | $281,981 | $281,981 | $281,981 | $281,981 | $500,731 | $156,981 | $156,981 | |
| Net Profit | $20,944 | ($42,806) | $99,507 | $263,166 | $451,375 | $845,944 | $845,944 | $845,944 | $845,944 | $1,502,194 | $470,944 | $470,944 | |
| Net Profit/Sales | 0.84% | -1.86% | 3.76% | 8.65% | 12.90% | 18.80% | 18.80% | 18.80% | 18.80% | 33.02% | 23.55% | 23.55% | |
| 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 | $2,500,000 | $2,300,000 | $2,645,000 | $3,041,750 | $3,498,013 | $4,500,000 | $4,500,000 | $4,500,000 | $4,500,000 | $4,550,000 | $2,000,000 | $2,000,000 | |
| Subtotal Cash from Operations | $2,500,000 | $2,300,000 | $2,645,000 | $3,041,750 | $3,498,013 | $4,500,000 | $4,500,000 | $4,500,000 | $4,500,000 | $4,550,000 | $2,000,000 | $2,000,000 | |
| 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 | $2,500,000 | $2,300,000 | $2,645,000 | $3,041,750 | $3,498,013 | $4,500,000 | $4,500,000 | $4,500,000 | $4,500,000 | $4,550,000 | $2,000,000 | $2,000,000 | |
| 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 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | $296,650 | |
| Bill Payments | $72,914 | $2,152,864 | $2,027,912 | $2,231,613 | $2,465,869 | $2,745,235 | $3,332,406 | $3,332,406 | $3,332,406 | $3,312,197 | $2,675,531 | $1,207,406 | |
| Subtotal Spent on Operations | $369,564 | $2,449,514 | $2,324,562 | $2,528,263 | $2,762,519 | $3,041,885 | $3,629,056 | $3,629,056 | $3,629,056 | $3,608,847 | $2,972,181 | $1,504,056 | |
| 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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Purchase Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Purchase Long-term Assets | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | |
| Dividends | $55,757 | $55,757 | $55,757 | $55,757 | $55,757 | $55,757 | $55,757 | $55,757 | $55,757 | $55,757 | $55,757 | $55,757 | |
| Subtotal Cash Spent | $600,321 | $2,680,271 | $2,555,319 | $2,759,020 | $2,993,276 | $3,272,642 | $3,859,813 | $3,859,813 | $3,859,813 | $3,839,604 | $3,202,938 | $1,734,813 | |
| Net Cash Flow | $1,899,679 | ($380,271) | $89,681 | $282,730 | $504,737 | $1,227,358 | $640,187 | $640,187 | $640,187 | $710,396 | ($1,202,938) | $265,187 | |
| Cash Balance | $3,399,679 | $3,019,409 | $3,109,090 | $3,391,820 | $3,896,556 | $5,123,914 | $5,764,102 | $6,404,289 | $7,044,476 | $7,754,872 | $6,551,934 | $6,817,122 | |
| 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 | $1,500,000 | $3,399,679 | $3,019,409 | $3,109,090 | $3,391,820 | $3,896,556 | $5,123,914 | $5,764,102 | $6,404,289 | $7,044,476 | $7,754,872 | $6,551,934 | $6,817,122 |
| Other Current Assets | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 |
| Total Current Assets | $1,600,000 | $3,499,679 | $3,119,409 | $3,209,090 | $3,491,820 | $3,996,556 | $5,223,914 | $5,864,102 | $6,504,289 | $7,144,476 | $7,854,872 | $6,651,934 | $6,917,122 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $2,500,000 | $2,675,000 | $2,850,000 | $3,025,000 | $3,200,000 | $3,375,000 | $3,550,000 | $3,725,000 | $3,900,000 | $4,075,000 | $4,250,000 | $4,425,000 | $4,600,000 |
| Accumulated Depreciation | $0 | $25,000 | $50,000 | $75,000 | $100,000 | $125,000 | $150,000 | $175,000 | $200,000 | $225,000 | $250,000 | $275,000 | $300,000 |
| Total Long-term Assets | $2,500,000 | $2,650,000 | $2,800,000 | $2,950,000 | $3,100,000 | $3,250,000 | $3,400,000 | $3,550,000 | $3,700,000 | $3,850,000 | $4,000,000 | $4,150,000 | $4,300,000 |
| Total Assets | $4,100,000 | $6,149,679 | $5,919,409 | $6,159,090 | $6,591,820 | $7,246,556 | $8,623,914 | $9,414,102 | $10,204,289 | $10,994,476 | $11,854,872 | $10,801,934 | $11,217,122 |
| 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 | $1,000 | $2,085,492 | $1,953,784 | $2,149,715 | $2,375,036 | $2,634,155 | $3,221,325 | $3,221,325 | $3,221,325 | $3,221,325 | $2,635,284 | $1,167,159 | $1,167,159 |
| 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 | $1,000 | $2,085,492 | $1,953,784 | $2,149,715 | $2,375,036 | $2,634,155 | $3,221,325 | $3,221,325 | $3,221,325 | $3,221,325 | $2,635,284 | $1,167,159 | $1,167,159 |
| Long-term Liabilities | $4,233,200 | $4,233,200 | $4,233,200 | $4,233,200 | $4,233,200 | $4,233,200 | $4,233,200 | $4,233,200 | $4,233,200 | $4,233,200 | $4,233,200 | $4,233,200 | $4,233,200 |
| Total Liabilities | $4,234,200 | $6,318,692 | $6,186,984 | $6,382,915 | $6,608,236 | $6,867,355 | $7,454,525 | $7,454,525 | $7,454,525 | $7,454,525 | $6,868,484 | $5,400,359 | $5,400,359 |
| Paid-in Capital | $390,000 | $390,000 | $390,000 | $390,000 | $390,000 | $390,000 | $390,000 | $390,000 | $390,000 | $390,000 | $390,000 | $390,000 | $390,000 |
| Retained Earnings | ($524,200) | ($579,957) | ($635,714) | ($691,471) | ($747,228) | ($802,985) | ($858,742) | ($914,499) | ($970,256) | ($1,026,013) | ($1,081,770) | ($1,137,527) | ($1,193,284) |
| Earnings | $0 | $20,944 | ($21,861) | $77,646 | $340,812 | $792,186 | $1,638,131 | $2,484,075 | $3,330,020 | $4,175,964 | $5,678,158 | $6,149,103 | $6,620,047 |
| Total Capital | ($134,200) | ($169,013) | ($267,575) | ($223,825) | ($16,416) | $379,201 | $1,169,389 | $1,959,576 | $2,749,764 | $3,539,951 | $4,986,388 | $5,401,576 | $5,816,763 |
| Total Liabilities and Capital | $4,100,000 | $6,149,679 | $5,919,409 | $6,159,090 | $6,591,820 | $7,246,556 | $8,623,914 | $9,414,102 | $10,204,289 | $10,994,476 | $11,854,872 | $10,801,934 | $11,217,122 |
| Net Worth | ($134,200) | ($169,013) | ($267,575) | ($223,825) | ($16,416) | $379,201 | $1,169,389 | $1,959,576 | $2,749,764 | $3,539,951 | $4,986,388 | $5,401,576 | $5,816,763 |