| 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 | |||||||||||||
| Individuals/families | 0% | £0 | £1,578 | £1,874 | £3,958 | £6,645 | £7,345 | £8,287 | £9,258 | £9,985 | £12,455 | £14,822 | £17,854 |
| Business travelers | 0% | £0 | £1,114 | £1,358 | £3,225 | £4,754 | £5,514 | £6,958 | £8,125 | £9,125 | £10,458 | £11,587 | £12,545 |
| Total Sales | £0 | £2,692 | £3,232 | £7,183 | £11,399 | £12,859 | £15,245 | £17,383 | £19,110 | £22,913 | £26,409 | £30,399 | |
| 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 | |
| Individuals/families | £0 | £316 | £375 | £792 | £1,329 | £1,469 | £1,657 | £1,852 | £1,997 | £2,491 | £2,964 | £3,571 | |
| Business travelers | £0 | £223 | £272 | £645 | £951 | £1,103 | £1,392 | £1,625 | £1,825 | £2,092 | £2,317 | £2,509 | |
| Subtotal Direct Cost of Sales | £0 | £538 | £646 | £1,437 | £2,280 | £2,572 | £3,049 | £3,477 | £3,822 | £4,583 | £5,282 | £6,080 | |
| 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 | ||
| Sam | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Part-time employee | 0% | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Driver | 0% | £0 | £2,200 | £2,200 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Driver | 0% | £0 | £2,200 | £2,200 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Driver | 0% | £0 | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Driver | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,800 | £1,800 |
| Total People | 1 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 6 | 6 | |
| Total Payroll | £3,000 | £8,900 | £8,900 | £8,100 | £9,900 | £9,900 | £9,900 | £9,900 | £9,900 | £9,900 | £11,700 | £11,700 | |
| 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 | 30.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 | £0 | £2,692 | £3,232 | £7,183 | £11,399 | £12,859 | £15,245 | £17,383 | £19,110 | £22,913 | £26,409 | £30,399 | |
| Direct Cost of Sales | £0 | £538 | £646 | £1,437 | £2,280 | £2,572 | £3,049 | £3,477 | £3,822 | £4,583 | £5,282 | £6,080 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £538 | £646 | £1,437 | £2,280 | £2,572 | £3,049 | £3,477 | £3,822 | £4,583 | £5,282 | £6,080 | |
| Gross Margin | £0 | £2,154 | £2,586 | £5,746 | £9,119 | £10,287 | £12,196 | £13,906 | £15,288 | £18,330 | £21,127 | £24,319 | |
| Gross Margin % | 0.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | |
| Expenses | |||||||||||||
| Payroll | £3,000 | £8,900 | £8,900 | £8,100 | £9,900 | £9,900 | £9,900 | £9,900 | £9,900 | £9,900 | £11,700 | £11,700 | |
| Sales and Marketing and Other Expenses | £150 | £175 | £200 | £225 | £250 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Depreciation | £42 | £42 | £42 | £42 | £42 | £42 | £42 | £42 | £42 | £42 | £42 | £42 | |
| Web site maintenance | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Utilities | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | |
| Rent | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Payroll Taxes | 15% | £450 | £1,335 | £1,335 | £1,215 | £1,485 | £1,485 | £1,485 | £1,485 | £1,485 | £1,485 | £1,755 | £1,755 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £4,742 | £11,552 | £11,577 | £10,682 | £12,777 | £12,827 | £12,827 | £12,827 | £12,827 | £12,827 | £14,897 | £14,897 | |
| Profit Before Interest and Taxes | (£4,742) | (£9,398) | (£8,991) | (£4,936) | (£3,658) | (£2,540) | (£631) | £1,079 | £2,461 | £5,503 | £6,230 | £9,422 | |
| EBITDA | (£4,700) | (£9,356) | (£8,949) | (£4,894) | (£3,616) | (£2,498) | (£589) | £1,121 | £2,503 | £5,545 | £6,272 | £9,464 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£4,742) | (£9,398) | (£8,991) | (£4,936) | (£3,658) | (£2,540) | (£631) | £1,079 | £2,461 | £5,503 | £6,230 | £9,422 | |
| Net Profit/Sales | 0.00% | -349.12% | -278.20% | -68.71% | -32.09% | -19.75% | -4.14% | 6.21% | 12.88% | 24.02% | 23.59% | 31.00% | |
| 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 | £2,692 | £3,232 | £7,183 | £11,399 | £12,859 | £15,245 | £17,383 | £19,110 | £22,913 | £26,409 | £30,399 | |
| Subtotal Cash from Operations | £0 | £2,692 | £3,232 | £7,183 | £11,399 | £12,859 | £15,245 | £17,383 | £19,110 | £22,913 | £26,409 | £30,399 | |
| 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 | £2,692 | £3,232 | £7,183 | £11,399 | £12,859 | £15,245 | £17,383 | £19,110 | £22,913 | £26,409 | £30,399 | |
| 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 | £3,000 | £8,900 | £8,900 | £8,100 | £9,900 | £9,900 | £9,900 | £9,900 | £9,900 | £9,900 | £11,700 | £11,700 | |
| Bill Payments | £57 | £1,748 | £3,153 | £3,305 | £4,015 | £5,126 | £5,473 | £5,948 | £6,373 | £6,732 | £7,500 | £8,463 | |
| Subtotal Spent on Operations | £3,057 | £10,648 | £12,053 | £11,405 | £13,915 | £15,026 | £15,373 | £15,848 | £16,273 | £16,632 | £19,200 | £20,163 | |
| 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 | £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 | £3,057 | £10,648 | £12,053 | £11,405 | £13,915 | £15,026 | £15,373 | £15,848 | £16,273 | £16,632 | £19,200 | £20,163 | |
| Net Cash Flow | (£3,057) | (£7,956) | (£8,821) | (£4,222) | (£2,516) | (£2,167) | (£128) | £1,535 | £2,837 | £6,281 | £7,209 | £10,236 | |
| Cash Balance | £27,918 | £19,962 | £11,141 | £6,920 | £4,404 | £2,237 | £2,109 | £3,644 | £6,481 | £12,761 | £19,971 | £30,206 | |
| 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 | £30,975 | £27,918 | £19,962 | £11,141 | £6,920 | £4,404 | £2,237 | £2,109 | £3,644 | £6,481 | £12,761 | £19,971 | £30,206 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £30,975 | £27,918 | £19,962 | £11,141 | £6,920 | £4,404 | £2,237 | £2,109 | £3,644 | £6,481 | £12,761 | £19,971 | £30,206 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Accumulated Depreciation | £0 | £42 | £84 | £126 | £168 | £210 | £252 | £294 | £336 | £378 | £420 | £462 | £504 |
| Total Long-term Assets | £1,500 | £1,458 | £1,416 | £1,374 | £1,332 | £1,290 | £1,248 | £1,206 | £1,164 | £1,122 | £1,080 | £1,038 | £996 |
| Total Assets | £32,475 | £29,376 | £21,378 | £12,515 | £8,252 | £5,694 | £3,485 | £3,315 | £4,808 | £7,603 | £13,841 | £21,009 | £31,202 |
| 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 | £1,643 | £3,043 | £3,172 | £3,844 | £4,944 | £5,275 | £5,736 | £6,150 | £6,483 | £7,219 | £8,156 | £8,927 |
| 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 | £1,643 | £3,043 | £3,172 | £3,844 | £4,944 | £5,275 | £5,736 | £6,150 | £6,483 | £7,219 | £8,156 | £8,927 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £1,643 | £3,043 | £3,172 | £3,844 | £4,944 | £5,275 | £5,736 | £6,150 | £6,483 | £7,219 | £8,156 | £8,927 |
| Paid-in Capital | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 |
| Retained Earnings | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) |
| Earnings | £0 | (£4,742) | (£14,140) | (£23,132) | (£28,067) | (£31,725) | (£34,265) | (£34,896) | (£33,817) | (£31,356) | (£25,852) | (£19,622) | (£10,200) |
| Total Capital | £32,475 | £27,733 | £18,335 | £9,343 | £4,408 | £750 | (£1,790) | (£2,421) | (£1,342) | £1,119 | £6,623 | £12,853 | £22,275 |
| Total Liabilities and Capital | £32,475 | £29,376 | £21,378 | £12,515 | £8,252 | £5,694 | £3,485 | £3,315 | £4,808 | £7,603 | £13,841 | £21,009 | £31,202 |
| Net Worth | £32,475 | £27,733 | £18,335 | £9,343 | £4,408 | £750 | (£1,790) | (£2,421) | (£1,342) | £1,119 | £6,623 | £12,853 | £22,275 |
| 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 | |||||||||||||
| Individuals/families | 0% | £0 | £1,578 | £1,874 | £3,958 | £6,645 | £7,345 | £8,287 | £9,258 | £9,985 | £12,455 | £14,822 | £17,854 |
| Business travelers | 0% | £0 | £1,114 | £1,358 | £3,225 | £4,754 | £5,514 | £6,958 | £8,125 | £9,125 | £10,458 | £11,587 | £12,545 |
| Total Sales | £0 | £2,692 | £3,232 | £7,183 | £11,399 | £12,859 | £15,245 | £17,383 | £19,110 | £22,913 | £26,409 | £30,399 | |
| 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 | |
| Individuals/families | £0 | £316 | £375 | £792 | £1,329 | £1,469 | £1,657 | £1,852 | £1,997 | £2,491 | £2,964 | £3,571 | |
| Business travelers | £0 | £223 | £272 | £645 | £951 | £1,103 | £1,392 | £1,625 | £1,825 | £2,092 | £2,317 | £2,509 | |
| Subtotal Direct Cost of Sales | £0 | £538 | £646 | £1,437 | £2,280 | £2,572 | £3,049 | £3,477 | £3,822 | £4,583 | £5,282 | £6,080 | |
| 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 | ||
| Sam | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Part-time employee | 0% | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Driver | 0% | £0 | £2,200 | £2,200 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Driver | 0% | £0 | £2,200 | £2,200 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Driver | 0% | £0 | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Driver | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,800 | £1,800 |
| Total People | 1 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 6 | 6 | |
| Total Payroll | £3,000 | £8,900 | £8,900 | £8,100 | £9,900 | £9,900 | £9,900 | £9,900 | £9,900 | £9,900 | £11,700 | £11,700 | |
| 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 | 30.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 | £0 | £2,692 | £3,232 | £7,183 | £11,399 | £12,859 | £15,245 | £17,383 | £19,110 | £22,913 | £26,409 | £30,399 | |
| Direct Cost of Sales | £0 | £538 | £646 | £1,437 | £2,280 | £2,572 | £3,049 | £3,477 | £3,822 | £4,583 | £5,282 | £6,080 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £538 | £646 | £1,437 | £2,280 | £2,572 | £3,049 | £3,477 | £3,822 | £4,583 | £5,282 | £6,080 | |
| Gross Margin | £0 | £2,154 | £2,586 | £5,746 | £9,119 | £10,287 | £12,196 | £13,906 | £15,288 | £18,330 | £21,127 | £24,319 | |
| Gross Margin % | 0.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | |
| Expenses | |||||||||||||
| Payroll | £3,000 | £8,900 | £8,900 | £8,100 | £9,900 | £9,900 | £9,900 | £9,900 | £9,900 | £9,900 | £11,700 | £11,700 | |
| Sales and Marketing and Other Expenses | £150 | £175 | £200 | £225 | £250 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Depreciation | £42 | £42 | £42 | £42 | £42 | £42 | £42 | £42 | £42 | £42 | £42 | £42 | |
| Web site maintenance | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Utilities | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | |
| Rent | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Payroll Taxes | 15% | £450 | £1,335 | £1,335 | £1,215 | £1,485 | £1,485 | £1,485 | £1,485 | £1,485 | £1,485 | £1,755 | £1,755 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £4,742 | £11,552 | £11,577 | £10,682 | £12,777 | £12,827 | £12,827 | £12,827 | £12,827 | £12,827 | £14,897 | £14,897 | |
| Profit Before Interest and Taxes | (£4,742) | (£9,398) | (£8,991) | (£4,936) | (£3,658) | (£2,540) | (£631) | £1,079 | £2,461 | £5,503 | £6,230 | £9,422 | |
| EBITDA | (£4,700) | (£9,356) | (£8,949) | (£4,894) | (£3,616) | (£2,498) | (£589) | £1,121 | £2,503 | £5,545 | £6,272 | £9,464 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£4,742) | (£9,398) | (£8,991) | (£4,936) | (£3,658) | (£2,540) | (£631) | £1,079 | £2,461 | £5,503 | £6,230 | £9,422 | |
| Net Profit/Sales | 0.00% | -349.12% | -278.20% | -68.71% | -32.09% | -19.75% | -4.14% | 6.21% | 12.88% | 24.02% | 23.59% | 31.00% | |
| 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 | £2,692 | £3,232 | £7,183 | £11,399 | £12,859 | £15,245 | £17,383 | £19,110 | £22,913 | £26,409 | £30,399 | |
| Subtotal Cash from Operations | £0 | £2,692 | £3,232 | £7,183 | £11,399 | £12,859 | £15,245 | £17,383 | £19,110 | £22,913 | £26,409 | £30,399 | |
| 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 | £2,692 | £3,232 | £7,183 | £11,399 | £12,859 | £15,245 | £17,383 | £19,110 | £22,913 | £26,409 | £30,399 | |
| 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 | £3,000 | £8,900 | £8,900 | £8,100 | £9,900 | £9,900 | £9,900 | £9,900 | £9,900 | £9,900 | £11,700 | £11,700 | |
| Bill Payments | £57 | £1,748 | £3,153 | £3,305 | £4,015 | £5,126 | £5,473 | £5,948 | £6,373 | £6,732 | £7,500 | £8,463 | |
| Subtotal Spent on Operations | £3,057 | £10,648 | £12,053 | £11,405 | £13,915 | £15,026 | £15,373 | £15,848 | £16,273 | £16,632 | £19,200 | £20,163 | |
| 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 | £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 | £3,057 | £10,648 | £12,053 | £11,405 | £13,915 | £15,026 | £15,373 | £15,848 | £16,273 | £16,632 | £19,200 | £20,163 | |
| Net Cash Flow | (£3,057) | (£7,956) | (£8,821) | (£4,222) | (£2,516) | (£2,167) | (£128) | £1,535 | £2,837 | £6,281 | £7,209 | £10,236 | |
| Cash Balance | £27,918 | £19,962 | £11,141 | £6,920 | £4,404 | £2,237 | £2,109 | £3,644 | £6,481 | £12,761 | £19,971 | £30,206 | |
| 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 | £30,975 | £27,918 | £19,962 | £11,141 | £6,920 | £4,404 | £2,237 | £2,109 | £3,644 | £6,481 | £12,761 | £19,971 | £30,206 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £30,975 | £27,918 | £19,962 | £11,141 | £6,920 | £4,404 | £2,237 | £2,109 | £3,644 | £6,481 | £12,761 | £19,971 | £30,206 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Accumulated Depreciation | £0 | £42 | £84 | £126 | £168 | £210 | £252 | £294 | £336 | £378 | £420 | £462 | £504 |
| Total Long-term Assets | £1,500 | £1,458 | £1,416 | £1,374 | £1,332 | £1,290 | £1,248 | £1,206 | £1,164 | £1,122 | £1,080 | £1,038 | £996 |
| Total Assets | £32,475 | £29,376 | £21,378 | £12,515 | £8,252 | £5,694 | £3,485 | £3,315 | £4,808 | £7,603 | £13,841 | £21,009 | £31,202 |
| 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 | £1,643 | £3,043 | £3,172 | £3,844 | £4,944 | £5,275 | £5,736 | £6,150 | £6,483 | £7,219 | £8,156 | £8,927 |
| 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 | £1,643 | £3,043 | £3,172 | £3,844 | £4,944 | £5,275 | £5,736 | £6,150 | £6,483 | £7,219 | £8,156 | £8,927 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £1,643 | £3,043 | £3,172 | £3,844 | £4,944 | £5,275 | £5,736 | £6,150 | £6,483 | £7,219 | £8,156 | £8,927 |
| Paid-in Capital | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 |
| Retained Earnings | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) | (£2,525) |
| Earnings | £0 | (£4,742) | (£14,140) | (£23,132) | (£28,067) | (£31,725) | (£34,265) | (£34,896) | (£33,817) | (£31,356) | (£25,852) | (£19,622) | (£10,200) |
| Total Capital | £32,475 | £27,733 | £18,335 | £9,343 | £4,408 | £750 | (£1,790) | (£2,421) | (£1,342) | £1,119 | £6,623 | £12,853 | £22,275 |
| Total Liabilities and Capital | £32,475 | £29,376 | £21,378 | £12,515 | £8,252 | £5,694 | £3,485 | £3,315 | £4,808 | £7,603 | £13,841 | £21,009 | £31,202 |
| Net Worth | £32,475 | £27,733 | £18,335 | £9,343 | £4,408 | £750 | (£1,790) | (£2,421) | (£1,342) | £1,119 | £6,623 | £12,853 | £22,275 |