| 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 | |||||||||||||
| Single Units | 0% | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 29 | 29 | 29 | 32 |
| Double Units | 0% | 10 | 10 | 10 | 10 | 10 | 10 | 16 | 16 | 20 | 20 | 20 | 22 |
| Quad Units | 0% | 8 | 8 | 8 | 8 | 8 | 8 | 12 | 12 | 14 | 14 | 14 | 15 |
| Luxury Suites | 0% | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 4 |
| Total Unit Sales | 44 | 44 | 44 | 44 | 44 | 44 | 54 | 54 | 66 | 66 | 66 | 73 | |
| 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 | |
| Single Units | £425.00 | £425.00 | £425.00 | £425.00 | £425.00 | £350.00 | £350.00 | £350.00 | £350.00 | £440.00 | £440.00 | £440.00 | |
| Double Units | £820.00 | £820.00 | £820.00 | £820.00 | £820.00 | £820.00 | £740.00 | £740.00 | £740.00 | £850.00 | £850.00 | £850.00 | |
| Quad Units | £1,200.00 | £1,200.00 | £1,200.00 | £1,200.00 | £1,200.00 | £1,200.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,300.00 | £1,300.00 | £1,300.00 | |
| Luxury Suites | £675.00 | £675.00 | £675.00 | £675.00 | £675.00 | £675.00 | £600.00 | £600.00 | £600.00 | £725.00 | £725.00 | £725.00 | |
| Sales | |||||||||||||
| Single Units | £10,200 | £10,200 | £10,200 | £10,200 | £10,200 | £8,400 | £8,400 | £8,400 | £10,150 | £12,760 | £12,760 | £14,080 | |
| Double Units | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £11,840 | £11,840 | £14,800 | £17,000 | £17,000 | £18,700 | |
| Quad Units | £9,600 | £9,600 | £9,600 | £9,600 | £9,600 | £9,600 | £12,000 | £12,000 | £14,000 | £18,200 | £18,200 | £19,500 | |
| Luxury Suites | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,200 | £1,200 | £1,800 | £2,175 | £2,175 | £2,900 | |
| Total Sales | £29,350 | £29,350 | £29,350 | £29,350 | £29,350 | £27,550 | £33,440 | £33,440 | £40,750 | £50,135 | £50,135 | £55,180 | |
| 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 | |
| Single Units | 0.00% | £260.00 | £260.00 | £260.00 | £260.00 | £260.00 | £260.00 | £260.00 | £260.00 | £260.00 | £260.00 | £260.00 | £260.00 |
| Double Units | 0.00% | £428.00 | £428.00 | £428.00 | £428.00 | £428.00 | £428.00 | £428.00 | £428.00 | £428.00 | £428.00 | £428.00 | £428.00 |
| Quad Units | 0.00% | £511.00 | £511.00 | £511.00 | £511.00 | £511.00 | £511.00 | £511.00 | £511.00 | £511.00 | £511.00 | £511.00 | £511.00 |
| Luxury Suites | 0.00% | £302.00 | £302.00 | £302.00 | £302.00 | £302.00 | £302.00 | £302.00 | £302.00 | £302.00 | £302.00 | £302.00 | £302.00 |
| Direct Cost of Sales | |||||||||||||
| Single Units | £6,240 | £6,240 | £6,240 | £6,240 | £6,240 | £6,240 | £6,240 | £6,240 | £7,540 | £7,540 | £7,540 | £8,320 | |
| Double Units | £4,280 | £4,280 | £4,280 | £4,280 | £4,280 | £4,280 | £6,848 | £6,848 | £8,560 | £8,560 | £8,560 | £9,416 | |
| Quad Units | £4,088 | £4,088 | £4,088 | £4,088 | £4,088 | £4,088 | £6,132 | £6,132 | £7,154 | £7,154 | £7,154 | £7,665 | |
| Luxury Suites | £604 | £604 | £604 | £604 | £604 | £604 | £604 | £604 | £906 | £906 | £906 | £1,208 | |
| Subtotal Direct Cost of Sales | £15,212 | £15,212 | £15,212 | £15,212 | £15,212 | £15,212 | £19,824 | £19,824 | £24,160 | £24,160 | £24,160 | £26,609 | |
| 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 | ||
| Nathan Koach (CFO) | 0% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Shawn Menashe (CEO) | 0% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Denise Richards (Admin. Mgr.) | 0% | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 |
| Joe Nash (Brokerage Mgr.) | 0% | £950 | £950 | £950 | £950 | £950 | £950 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Head Contractor (Development Mgr.) | 0% | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 |
| Other | 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 |
| Total People | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
| Total Payroll | £7,300 | £7,300 | £7,300 | £7,300 | £7,300 | £7,300 | £7,800 | £7,800 | £7,800 | £7,800 | £7,800 | £7,800 | |
| 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 | £29,350 | £29,350 | £29,350 | £29,350 | £29,350 | £27,550 | £33,440 | £33,440 | £40,750 | £50,135 | £50,135 | £55,180 | |
| Direct Cost of Sales | £15,212 | £15,212 | £15,212 | £15,212 | £15,212 | £15,212 | £19,824 | £19,824 | £24,160 | £24,160 | £24,160 | £26,609 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £15,212 | £15,212 | £15,212 | £15,212 | £15,212 | £15,212 | £19,824 | £19,824 | £24,160 | £24,160 | £24,160 | £26,609 | |
| Gross Margin | £14,138 | £14,138 | £14,138 | £14,138 | £14,138 | £12,338 | £13,616 | £13,616 | £16,590 | £25,975 | £25,975 | £28,571 | |
| Gross Margin % | 48.17% | 48.17% | 48.17% | 48.17% | 48.17% | 44.78% | 40.72% | 40.72% | 40.71% | 51.81% | 51.81% | 51.78% | |
| Expenses | |||||||||||||
| Payroll | £7,300 | £7,300 | £7,300 | £7,300 | £7,300 | £7,300 | £7,800 | £7,800 | £7,800 | £7,800 | £7,800 | £7,800 | |
| Marketing/Promotion | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,150 | £900 | £950 | £950 | £900 | £850 | |
| Depreciation | £0 | £1,111 | £1,111 | £1,111 | £1,111 | £1,111 | £1,111 | £1,111 | £1,111 | £1,111 | £1,111 | £1,111 | |
| Leased Equipment | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Utilities | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Insurance | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Maintenance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Payroll Taxes | 15% | £1,095 | £1,095 | £1,095 | £1,095 | £1,095 | £1,095 | £1,170 | £1,170 | £1,170 | £1,170 | £1,170 | £1,170 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £11,995 | £13,106 | £13,106 | £13,106 | £13,106 | £13,106 | £13,481 | £13,231 | £13,281 | £13,281 | £13,231 | £13,181 | |
| Profit Before Interest and Taxes | £2,143 | £1,032 | £1,032 | £1,032 | £1,032 | (£768) | £135 | £385 | £3,309 | £12,694 | £12,744 | £15,390 | |
| EBITDA | £2,143 | £2,143 | £2,143 | £2,143 | £2,143 | £343 | £1,246 | £1,496 | £4,420 | £13,805 | £13,855 | £16,501 | |
| Interest Expense | £5,440 | £5,433 | £5,427 | £5,420 | £5,413 | £5,409 | £5,400 | £5,391 | £5,382 | £5,381 | £5,379 | £5,378 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£3,297) | (£4,401) | (£4,395) | (£4,388) | (£4,381) | (£6,177) | (£5,265) | (£5,006) | (£2,073) | £7,313 | £7,365 | £10,012 | |
| Net Profit/Sales | -11.23% | -15.00% | -14.97% | -14.95% | -14.93% | -22.42% | -15.74% | -14.97% | -5.09% | 14.59% | 14.69% | 18.14% | |
| 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 | £29,350 | £29,350 | £29,350 | £29,350 | £29,350 | £27,550 | £33,440 | £33,440 | £40,750 | £50,135 | £50,135 | £55,180 | |
| Subtotal Cash from Operations | £29,350 | £29,350 | £29,350 | £29,350 | £29,350 | £27,550 | £33,440 | £33,440 | £40,750 | £50,135 | £50,135 | £55,180 | |
| 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 | £1,000 | £800 | £800 | £800 | £800 | £1,200 | £500 | £500 | £500 | £500 | £500 | £500 | |
| New Other Liabilities (interest-free) | £200 | £0 | £0 | £200 | £200 | £200 | £200 | £200 | £200 | £202 | £0 | £200 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | |
| 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 | £100 | £150 | £150 | £150 | £1,000 | £1,000 | £1,011 | £1,001 | £100 | £100 | £1,000 | £100 | |
| Subtotal Cash Received | £30,650 | £30,300 | £30,300 | £30,500 | £31,350 | £29,950 | £35,151 | £35,141 | £41,550 | £52,437 | £53,135 | £57,480 | |
| 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 | £7,300 | £7,300 | £7,300 | £7,300 | £7,300 | £7,300 | £7,800 | £7,800 | £7,800 | £7,800 | £7,800 | £7,800 | |
| Bill Payments | £4,735 | £25,347 | £25,340 | £25,333 | £25,327 | £25,320 | £25,465 | £29,785 | £29,681 | £33,912 | £33,909 | £33,939 | |
| Subtotal Spent on Operations | £12,035 | £32,647 | £32,640 | £32,633 | £32,627 | £32,620 | £33,265 | £37,585 | £37,481 | £41,712 | £41,709 | £41,739 | |
| 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 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Other Liabilities Principal Repayment | £0 | £200 | £0 | £200 | £0 | £0 | £0 | £0 | £0 | £0 | £250 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £2,075 | £2,080 | £2,085 | £2,091 | £2,096 | £2,102 | £2,107 | £2,113 | £2,118 | £2,124 | £2,130 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £1,080,000 | £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 | £1,092,035 | £35,172 | £34,970 | £35,168 | £34,968 | £34,966 | £35,617 | £39,942 | £39,844 | £44,080 | £44,333 | £44,119 | |
| Net Cash Flow | (£1,061,385) | (£4,872) | (£4,670) | (£4,668) | (£3,618) | (£5,016) | (£466) | (£4,801) | £1,706 | £8,357 | £8,802 | £13,361 | |
| Cash Balance | £49,945 | £45,073 | £40,403 | £35,735 | £32,117 | £27,101 | £26,635 | £21,834 | £23,540 | £31,897 | £40,699 | £54,059 | |
| 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,111,330 | £49,945 | £45,073 | £40,403 | £35,735 | £32,117 | £27,101 | £26,635 | £21,834 | £23,540 | £31,897 | £40,699 | £54,059 |
| Other Current Assets | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 |
| Total Current Assets | £1,123,330 | £61,945 | £57,073 | £52,403 | £47,735 | £44,117 | £39,101 | £38,635 | £33,834 | £35,540 | £43,897 | £52,699 | £66,059 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £120,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 |
| Accumulated Depreciation | £0 | £0 | £1,111 | £2,222 | £3,333 | £4,444 | £5,555 | £6,666 | £7,777 | £8,888 | £9,999 | £11,110 | £12,221 |
| Total Long-term Assets | £120,000 | £1,200,000 | £1,198,889 | £1,197,778 | £1,196,667 | £1,195,556 | £1,194,445 | £1,193,334 | £1,192,223 | £1,191,112 | £1,190,001 | £1,188,890 | £1,187,779 |
| Total Assets | £1,243,330 | £1,261,945 | £1,255,962 | £1,250,181 | £1,244,402 | £1,239,673 | £1,233,546 | £1,231,969 | £1,226,057 | £1,226,652 | £1,233,898 | £1,241,589 | £1,253,838 |
| 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 | £3,890 | £24,502 | £24,496 | £24,489 | £24,483 | £24,476 | £24,472 | £28,801 | £28,551 | £32,782 | £32,780 | £32,731 | £35,048 |
| Current Borrowing | £5,000 | £6,000 | £6,550 | £7,100 | £7,650 | £8,200 | £9,150 | £9,400 | £9,650 | £9,900 | £10,150 | £10,400 | £10,650 |
| Other Current Liabilities | £0 | £200 | £0 | £0 | £0 | £200 | £400 | £600 | £800 | £1,000 | £1,202 | £952 | £1,152 |
| Subtotal Current Liabilities | £8,890 | £30,702 | £31,046 | £31,589 | £32,133 | £32,876 | £34,022 | £38,801 | £39,001 | £43,682 | £44,132 | £44,083 | £46,850 |
| Long-term Liabilities | £1,080,000 | £1,080,000 | £1,077,925 | £1,075,845 | £1,073,760 | £1,071,669 | £1,069,573 | £1,067,471 | £1,065,364 | £1,063,251 | £1,062,633 | £1,062,009 | £1,061,379 |
| Total Liabilities | £1,088,890 | £1,110,702 | £1,108,971 | £1,107,434 | £1,105,893 | £1,104,545 | £1,103,595 | £1,106,272 | £1,104,365 | £1,106,933 | £1,106,765 | £1,106,092 | £1,108,229 |
| Paid-in Capital | £246,000 | £246,100 | £246,250 | £246,400 | £246,550 | £247,550 | £248,550 | £249,561 | £250,562 | £250,662 | £250,762 | £251,762 | £251,862 |
| Retained Earnings | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) |
| Earnings | £0 | (£3,297) | (£7,698) | (£12,093) | (£16,481) | (£20,862) | (£27,039) | (£32,304) | (£37,310) | (£39,383) | (£32,070) | (£24,705) | (£14,693) |
| Total Capital | £154,440 | £151,243 | £146,992 | £142,747 | £138,509 | £135,128 | £129,951 | £125,697 | £121,692 | £119,719 | £127,132 | £135,497 | £145,609 |
| Total Liabilities and Capital | £1,243,330 | £1,261,945 | £1,255,962 | £1,250,181 | £1,244,402 | £1,239,673 | £1,233,546 | £1,231,969 | £1,226,057 | £1,226,652 | £1,233,898 | £1,241,589 | £1,253,838 |
| Net Worth | £154,440 | £151,243 | £146,992 | £142,747 | £138,509 | £135,128 | £129,951 | £125,697 | £121,692 | £119,719 | £127,132 | £135,497 | £145,609 |
| 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 | |||||||||||||
| Single Units | 0% | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 29 | 29 | 29 | 32 |
| Double Units | 0% | 10 | 10 | 10 | 10 | 10 | 10 | 16 | 16 | 20 | 20 | 20 | 22 |
| Quad Units | 0% | 8 | 8 | 8 | 8 | 8 | 8 | 12 | 12 | 14 | 14 | 14 | 15 |
| Luxury Suites | 0% | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 4 |
| Total Unit Sales | 44 | 44 | 44 | 44 | 44 | 44 | 54 | 54 | 66 | 66 | 66 | 73 | |
| 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 | |
| Single Units | £425.00 | £425.00 | £425.00 | £425.00 | £425.00 | £350.00 | £350.00 | £350.00 | £350.00 | £440.00 | £440.00 | £440.00 | |
| Double Units | £820.00 | £820.00 | £820.00 | £820.00 | £820.00 | £820.00 | £740.00 | £740.00 | £740.00 | £850.00 | £850.00 | £850.00 | |
| Quad Units | £1,200.00 | £1,200.00 | £1,200.00 | £1,200.00 | £1,200.00 | £1,200.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,300.00 | £1,300.00 | £1,300.00 | |
| Luxury Suites | £675.00 | £675.00 | £675.00 | £675.00 | £675.00 | £675.00 | £600.00 | £600.00 | £600.00 | £725.00 | £725.00 | £725.00 | |
| Sales | |||||||||||||
| Single Units | £10,200 | £10,200 | £10,200 | £10,200 | £10,200 | £8,400 | £8,400 | £8,400 | £10,150 | £12,760 | £12,760 | £14,080 | |
| Double Units | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £8,200 | £11,840 | £11,840 | £14,800 | £17,000 | £17,000 | £18,700 | |
| Quad Units | £9,600 | £9,600 | £9,600 | £9,600 | £9,600 | £9,600 | £12,000 | £12,000 | £14,000 | £18,200 | £18,200 | £19,500 | |
| Luxury Suites | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,200 | £1,200 | £1,800 | £2,175 | £2,175 | £2,900 | |
| Total Sales | £29,350 | £29,350 | £29,350 | £29,350 | £29,350 | £27,550 | £33,440 | £33,440 | £40,750 | £50,135 | £50,135 | £55,180 | |
| 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 | |
| Single Units | 0.00% | £260.00 | £260.00 | £260.00 | £260.00 | £260.00 | £260.00 | £260.00 | £260.00 | £260.00 | £260.00 | £260.00 | £260.00 |
| Double Units | 0.00% | £428.00 | £428.00 | £428.00 | £428.00 | £428.00 | £428.00 | £428.00 | £428.00 | £428.00 | £428.00 | £428.00 | £428.00 |
| Quad Units | 0.00% | £511.00 | £511.00 | £511.00 | £511.00 | £511.00 | £511.00 | £511.00 | £511.00 | £511.00 | £511.00 | £511.00 | £511.00 |
| Luxury Suites | 0.00% | £302.00 | £302.00 | £302.00 | £302.00 | £302.00 | £302.00 | £302.00 | £302.00 | £302.00 | £302.00 | £302.00 | £302.00 |
| Direct Cost of Sales | |||||||||||||
| Single Units | £6,240 | £6,240 | £6,240 | £6,240 | £6,240 | £6,240 | £6,240 | £6,240 | £7,540 | £7,540 | £7,540 | £8,320 | |
| Double Units | £4,280 | £4,280 | £4,280 | £4,280 | £4,280 | £4,280 | £6,848 | £6,848 | £8,560 | £8,560 | £8,560 | £9,416 | |
| Quad Units | £4,088 | £4,088 | £4,088 | £4,088 | £4,088 | £4,088 | £6,132 | £6,132 | £7,154 | £7,154 | £7,154 | £7,665 | |
| Luxury Suites | £604 | £604 | £604 | £604 | £604 | £604 | £604 | £604 | £906 | £906 | £906 | £1,208 | |
| Subtotal Direct Cost of Sales | £15,212 | £15,212 | £15,212 | £15,212 | £15,212 | £15,212 | £19,824 | £19,824 | £24,160 | £24,160 | £24,160 | £26,609 | |
| 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 | ||
| Nathan Koach (CFO) | 0% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Shawn Menashe (CEO) | 0% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Denise Richards (Admin. Mgr.) | 0% | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 |
| Joe Nash (Brokerage Mgr.) | 0% | £950 | £950 | £950 | £950 | £950 | £950 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Head Contractor (Development Mgr.) | 0% | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 |
| Other | 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 |
| Total People | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
| Total Payroll | £7,300 | £7,300 | £7,300 | £7,300 | £7,300 | £7,300 | £7,800 | £7,800 | £7,800 | £7,800 | £7,800 | £7,800 | |
| 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 | £29,350 | £29,350 | £29,350 | £29,350 | £29,350 | £27,550 | £33,440 | £33,440 | £40,750 | £50,135 | £50,135 | £55,180 | |
| Direct Cost of Sales | £15,212 | £15,212 | £15,212 | £15,212 | £15,212 | £15,212 | £19,824 | £19,824 | £24,160 | £24,160 | £24,160 | £26,609 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £15,212 | £15,212 | £15,212 | £15,212 | £15,212 | £15,212 | £19,824 | £19,824 | £24,160 | £24,160 | £24,160 | £26,609 | |
| Gross Margin | £14,138 | £14,138 | £14,138 | £14,138 | £14,138 | £12,338 | £13,616 | £13,616 | £16,590 | £25,975 | £25,975 | £28,571 | |
| Gross Margin % | 48.17% | 48.17% | 48.17% | 48.17% | 48.17% | 44.78% | 40.72% | 40.72% | 40.71% | 51.81% | 51.81% | 51.78% | |
| Expenses | |||||||||||||
| Payroll | £7,300 | £7,300 | £7,300 | £7,300 | £7,300 | £7,300 | £7,800 | £7,800 | £7,800 | £7,800 | £7,800 | £7,800 | |
| Marketing/Promotion | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,150 | £900 | £950 | £950 | £900 | £850 | |
| Depreciation | £0 | £1,111 | £1,111 | £1,111 | £1,111 | £1,111 | £1,111 | £1,111 | £1,111 | £1,111 | £1,111 | £1,111 | |
| Leased Equipment | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Utilities | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Insurance | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Maintenance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Payroll Taxes | 15% | £1,095 | £1,095 | £1,095 | £1,095 | £1,095 | £1,095 | £1,170 | £1,170 | £1,170 | £1,170 | £1,170 | £1,170 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £11,995 | £13,106 | £13,106 | £13,106 | £13,106 | £13,106 | £13,481 | £13,231 | £13,281 | £13,281 | £13,231 | £13,181 | |
| Profit Before Interest and Taxes | £2,143 | £1,032 | £1,032 | £1,032 | £1,032 | (£768) | £135 | £385 | £3,309 | £12,694 | £12,744 | £15,390 | |
| EBITDA | £2,143 | £2,143 | £2,143 | £2,143 | £2,143 | £343 | £1,246 | £1,496 | £4,420 | £13,805 | £13,855 | £16,501 | |
| Interest Expense | £5,440 | £5,433 | £5,427 | £5,420 | £5,413 | £5,409 | £5,400 | £5,391 | £5,382 | £5,381 | £5,379 | £5,378 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£3,297) | (£4,401) | (£4,395) | (£4,388) | (£4,381) | (£6,177) | (£5,265) | (£5,006) | (£2,073) | £7,313 | £7,365 | £10,012 | |
| Net Profit/Sales | -11.23% | -15.00% | -14.97% | -14.95% | -14.93% | -22.42% | -15.74% | -14.97% | -5.09% | 14.59% | 14.69% | 18.14% | |
| 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 | £29,350 | £29,350 | £29,350 | £29,350 | £29,350 | £27,550 | £33,440 | £33,440 | £40,750 | £50,135 | £50,135 | £55,180 | |
| Subtotal Cash from Operations | £29,350 | £29,350 | £29,350 | £29,350 | £29,350 | £27,550 | £33,440 | £33,440 | £40,750 | £50,135 | £50,135 | £55,180 | |
| 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 | £1,000 | £800 | £800 | £800 | £800 | £1,200 | £500 | £500 | £500 | £500 | £500 | £500 | |
| New Other Liabilities (interest-free) | £200 | £0 | £0 | £200 | £200 | £200 | £200 | £200 | £200 | £202 | £0 | £200 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | |
| 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 | £100 | £150 | £150 | £150 | £1,000 | £1,000 | £1,011 | £1,001 | £100 | £100 | £1,000 | £100 | |
| Subtotal Cash Received | £30,650 | £30,300 | £30,300 | £30,500 | £31,350 | £29,950 | £35,151 | £35,141 | £41,550 | £52,437 | £53,135 | £57,480 | |
| 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 | £7,300 | £7,300 | £7,300 | £7,300 | £7,300 | £7,300 | £7,800 | £7,800 | £7,800 | £7,800 | £7,800 | £7,800 | |
| Bill Payments | £4,735 | £25,347 | £25,340 | £25,333 | £25,327 | £25,320 | £25,465 | £29,785 | £29,681 | £33,912 | £33,909 | £33,939 | |
| Subtotal Spent on Operations | £12,035 | £32,647 | £32,640 | £32,633 | £32,627 | £32,620 | £33,265 | £37,585 | £37,481 | £41,712 | £41,709 | £41,739 | |
| 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 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Other Liabilities Principal Repayment | £0 | £200 | £0 | £200 | £0 | £0 | £0 | £0 | £0 | £0 | £250 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £2,075 | £2,080 | £2,085 | £2,091 | £2,096 | £2,102 | £2,107 | £2,113 | £2,118 | £2,124 | £2,130 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £1,080,000 | £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 | £1,092,035 | £35,172 | £34,970 | £35,168 | £34,968 | £34,966 | £35,617 | £39,942 | £39,844 | £44,080 | £44,333 | £44,119 | |
| Net Cash Flow | (£1,061,385) | (£4,872) | (£4,670) | (£4,668) | (£3,618) | (£5,016) | (£466) | (£4,801) | £1,706 | £8,357 | £8,802 | £13,361 | |
| Cash Balance | £49,945 | £45,073 | £40,403 | £35,735 | £32,117 | £27,101 | £26,635 | £21,834 | £23,540 | £31,897 | £40,699 | £54,059 | |
| 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,111,330 | £49,945 | £45,073 | £40,403 | £35,735 | £32,117 | £27,101 | £26,635 | £21,834 | £23,540 | £31,897 | £40,699 | £54,059 |
| Other Current Assets | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 |
| Total Current Assets | £1,123,330 | £61,945 | £57,073 | £52,403 | £47,735 | £44,117 | £39,101 | £38,635 | £33,834 | £35,540 | £43,897 | £52,699 | £66,059 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £120,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 | £1,200,000 |
| Accumulated Depreciation | £0 | £0 | £1,111 | £2,222 | £3,333 | £4,444 | £5,555 | £6,666 | £7,777 | £8,888 | £9,999 | £11,110 | £12,221 |
| Total Long-term Assets | £120,000 | £1,200,000 | £1,198,889 | £1,197,778 | £1,196,667 | £1,195,556 | £1,194,445 | £1,193,334 | £1,192,223 | £1,191,112 | £1,190,001 | £1,188,890 | £1,187,779 |
| Total Assets | £1,243,330 | £1,261,945 | £1,255,962 | £1,250,181 | £1,244,402 | £1,239,673 | £1,233,546 | £1,231,969 | £1,226,057 | £1,226,652 | £1,233,898 | £1,241,589 | £1,253,838 |
| 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 | £3,890 | £24,502 | £24,496 | £24,489 | £24,483 | £24,476 | £24,472 | £28,801 | £28,551 | £32,782 | £32,780 | £32,731 | £35,048 |
| Current Borrowing | £5,000 | £6,000 | £6,550 | £7,100 | £7,650 | £8,200 | £9,150 | £9,400 | £9,650 | £9,900 | £10,150 | £10,400 | £10,650 |
| Other Current Liabilities | £0 | £200 | £0 | £0 | £0 | £200 | £400 | £600 | £800 | £1,000 | £1,202 | £952 | £1,152 |
| Subtotal Current Liabilities | £8,890 | £30,702 | £31,046 | £31,589 | £32,133 | £32,876 | £34,022 | £38,801 | £39,001 | £43,682 | £44,132 | £44,083 | £46,850 |
| Long-term Liabilities | £1,080,000 | £1,080,000 | £1,077,925 | £1,075,845 | £1,073,760 | £1,071,669 | £1,069,573 | £1,067,471 | £1,065,364 | £1,063,251 | £1,062,633 | £1,062,009 | £1,061,379 |
| Total Liabilities | £1,088,890 | £1,110,702 | £1,108,971 | £1,107,434 | £1,105,893 | £1,104,545 | £1,103,595 | £1,106,272 | £1,104,365 | £1,106,933 | £1,106,765 | £1,106,092 | £1,108,229 |
| Paid-in Capital | £246,000 | £246,100 | £246,250 | £246,400 | £246,550 | £247,550 | £248,550 | £249,561 | £250,562 | £250,662 | £250,762 | £251,762 | £251,862 |
| Retained Earnings | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) | (£91,560) |
| Earnings | £0 | (£3,297) | (£7,698) | (£12,093) | (£16,481) | (£20,862) | (£27,039) | (£32,304) | (£37,310) | (£39,383) | (£32,070) | (£24,705) | (£14,693) |
| Total Capital | £154,440 | £151,243 | £146,992 | £142,747 | £138,509 | £135,128 | £129,951 | £125,697 | £121,692 | £119,719 | £127,132 | £135,497 | £145,609 |
| Total Liabilities and Capital | £1,243,330 | £1,261,945 | £1,255,962 | £1,250,181 | £1,244,402 | £1,239,673 | £1,233,546 | £1,231,969 | £1,226,057 | £1,226,652 | £1,233,898 | £1,241,589 | £1,253,838 |
| Net Worth | £154,440 | £151,243 | £146,992 | £142,747 | £138,509 | £135,128 | £129,951 | £125,697 | £121,692 | £119,719 | £127,132 | £135,497 | £145,609 |