| 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 |
| 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 |