| 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 | |||||||||||||
| Individual Consumers | 0% | £0 | £0 | £0 | £2,956 | £3,354 | £3,789 | £3,458 | £3,687 | £2,847 | £2,063 | £1,000 | £0 |
| Restaurants | 0% | £0 | £0 | £0 | £2,974 | £3,654 | £4,545 | £5,588 | £6,245 | £7,258 | £7,987 | £9,412 | £10,895 |
| Total Sales | £0 | £0 | £0 | £5,930 | £7,008 | £8,334 | £9,046 | £9,932 | £10,105 | £10,050 | £10,412 | £10,895 | |
| 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 | |
| Individual Consumers | £0 | £0 | £0 | £355 | £402 | £455 | £415 | £442 | £342 | £248 | £120 | £0 | |
| Restaurants | £0 | £0 | £0 | £357 | £438 | £545 | £671 | £749 | £871 | £958 | £1,129 | £1,307 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £712 | £841 | £1,000 | £1,086 | £1,192 | £1,213 | £1,206 | £1,249 | £1,307 | |
| 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 | ||
| Heidi | 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 |
| Gardener | 0% | £700 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 |
| Gardener | 0% | £700 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 |
| Part-time Helper | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Part-time Helper | 0% | £0 | £0 | £0 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Total People | 0 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £3,400 | £4,900 | £4,900 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,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 | 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 | £0 | £0 | £5,930 | £7,008 | £8,334 | £9,046 | £9,932 | £10,105 | £10,050 | £10,412 | £10,895 | |
| Direct Cost of Sales | £0 | £0 | £0 | £712 | £841 | £1,000 | £1,086 | £1,192 | £1,213 | £1,206 | £1,249 | £1,307 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £712 | £841 | £1,000 | £1,086 | £1,192 | £1,213 | £1,206 | £1,249 | £1,307 | |
| Gross Margin | £0 | £0 | £0 | £5,218 | £6,167 | £7,334 | £7,960 | £8,740 | £8,892 | £8,844 | £9,163 | £9,588 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 88.00% | 88.00% | 88.00% | 88.00% | 88.00% | 88.00% | 88.00% | 88.00% | 88.00% | |
| Expenses | |||||||||||||
| Payroll | £3,400 | £4,900 | £4,900 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £211 | £211 | £211 | £211 | £211 | £211 | £211 | £211 | £211 | £211 | £211 | £211 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Rent | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Payroll Taxes | 15% | £510 | £735 | £735 | £848 | £848 | £848 | £848 | £848 | £848 | £848 | £848 | £848 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £5,071 | £6,796 | £6,796 | £7,659 | £7,659 | £7,659 | £7,659 | £7,659 | £7,659 | £7,659 | £7,659 | £7,659 | |
| Profit Before Interest and Taxes | (£5,071) | (£6,796) | (£6,796) | (£2,440) | (£1,491) | (£325) | £302 | £1,082 | £1,234 | £1,186 | £1,504 | £1,929 | |
| EBITDA | (£4,860) | (£6,585) | (£6,585) | (£2,229) | (£1,280) | (£114) | £513 | £1,293 | £1,445 | £1,397 | £1,715 | £2,140 | |
| Interest Expense | £40 | £38 | £37 | £35 | £33 | £32 | £30 | £28 | £27 | £25 | £23 | £22 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£5,111) | (£6,834) | (£6,833) | (£2,475) | (£1,525) | (£356) | £272 | £1,053 | £1,207 | £1,161 | £1,481 | £1,907 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | -41.75% | -21.76% | -4.27% | 3.01% | 10.61% | 11.95% | 11.55% | 14.22% | 17.51% | |
| 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 | £0 | £0 | £2,372 | £2,803 | £3,334 | £3,618 | £3,973 | £4,042 | £4,020 | £4,165 | £4,358 | |
| Cash from Receivables | £0 | £0 | £0 | £0 | £119 | £3,579 | £4,231 | £5,015 | £5,445 | £5,963 | £6,062 | £6,037 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £2,372 | £2,922 | £6,913 | £7,850 | £8,987 | £9,487 | £9,983 | £10,227 | £10,395 | |
| 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 | £0 | £0 | £2,372 | £2,922 | £6,913 | £7,850 | £8,987 | £9,487 | £9,983 | £10,227 | £10,395 | |
| 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,400 | £4,900 | £4,900 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | |
| Bill Payments | £50 | £1,507 | £1,723 | £1,775 | £3,310 | £2,836 | £2,988 | £3,011 | £3,132 | £3,058 | £3,024 | £3,120 | |
| Subtotal Spent on Operations | £3,450 | £6,407 | £6,623 | £7,425 | £8,960 | £8,486 | £8,638 | £8,661 | £8,782 | £8,708 | £8,674 | £8,770 | |
| 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 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| 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,650 | £6,607 | £6,823 | £7,625 | £9,160 | £8,686 | £8,838 | £8,861 | £8,982 | £8,908 | £8,874 | £8,970 | |
| Net Cash Flow | (£3,650) | (£6,607) | (£6,823) | (£5,253) | (£6,238) | (£1,773) | (£989) | £126 | £505 | £1,074 | £1,352 | £1,425 | |
| Cash Balance | £31,050 | £24,443 | £17,619 | £12,366 | £6,128 | £4,354 | £3,366 | £3,492 | £3,997 | £5,072 | £6,424 | £7,849 | |
| 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 | £34,700 | £31,050 | £24,443 | £17,619 | £12,366 | £6,128 | £4,354 | £3,366 | £3,492 | £3,997 | £5,072 | £6,424 | £7,849 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £3,558 | £7,644 | £9,065 | £10,261 | £11,206 | £11,824 | £11,891 | £12,076 | £12,576 |
| Inventory | £0 | £0 | £0 | £0 | £783 | £942 | £1,100 | £1,194 | £1,311 | £1,334 | £1,327 | £1,374 | £1,438 |
| Other Current Assets | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Total Current Assets | £35,200 | £31,550 | £24,943 | £18,119 | £17,207 | £15,213 | £15,020 | £15,321 | £16,509 | £17,655 | £18,789 | £20,374 | £22,363 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 |
| Accumulated Depreciation | £0 | £211 | £422 | £633 | £844 | £1,055 | £1,266 | £1,477 | £1,688 | £1,899 | £2,110 | £2,321 | £2,532 |
| Total Long-term Assets | £25,300 | £25,089 | £24,878 | £24,667 | £24,456 | £24,245 | £24,034 | £23,823 | £23,612 | £23,401 | £23,190 | £22,979 | £22,768 |
| Total Assets | £60,500 | £56,639 | £49,821 | £42,786 | £41,663 | £39,458 | £39,054 | £39,144 | £40,121 | £41,056 | £41,979 | £43,353 | £45,131 |
| 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,450 | £1,666 | £1,664 | £3,216 | £2,736 | £2,888 | £2,907 | £3,030 | £2,958 | £2,921 | £3,014 | £3,084 |
| Current Borrowing | £5,000 | £4,800 | £4,600 | £4,400 | £4,200 | £4,000 | £3,800 | £3,600 | £3,400 | £3,200 | £3,000 | £2,800 | £2,600 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £5,000 | £6,250 | £6,266 | £6,064 | £7,416 | £6,736 | £6,688 | £6,507 | £6,430 | £6,158 | £5,921 | £5,814 | £5,684 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £5,000 | £6,250 | £6,266 | £6,064 | £7,416 | £6,736 | £6,688 | £6,507 | £6,430 | £6,158 | £5,921 | £5,814 | £5,684 |
| Paid-in Capital | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 |
| Retained Earnings | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) |
| Earnings | £0 | (£5,111) | (£11,945) | (£18,778) | (£21,253) | (£22,778) | (£23,134) | (£22,862) | (£21,809) | (£20,602) | (£19,441) | (£17,961) | (£16,053) |
| Total Capital | £55,500 | £50,389 | £43,555 | £36,722 | £34,247 | £32,722 | £32,366 | £32,638 | £33,691 | £34,898 | £36,059 | £37,539 | £39,447 |
| Total Liabilities and Capital | £60,500 | £56,639 | £49,821 | £42,786 | £41,663 | £39,458 | £39,054 | £39,144 | £40,121 | £41,056 | £41,979 | £43,353 | £45,131 |
| Net Worth | £55,500 | £50,389 | £43,555 | £36,722 | £34,247 | £32,722 | £32,366 | £32,638 | £33,691 | £34,898 | £36,059 | £37,539 | £39,447 |
| 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 | |||||||||||||
| Individual Consumers | 0% | £0 | £0 | £0 | £2,956 | £3,354 | £3,789 | £3,458 | £3,687 | £2,847 | £2,063 | £1,000 | £0 |
| Restaurants | 0% | £0 | £0 | £0 | £2,974 | £3,654 | £4,545 | £5,588 | £6,245 | £7,258 | £7,987 | £9,412 | £10,895 |
| Total Sales | £0 | £0 | £0 | £5,930 | £7,008 | £8,334 | £9,046 | £9,932 | £10,105 | £10,050 | £10,412 | £10,895 | |
| 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 | |
| Individual Consumers | £0 | £0 | £0 | £355 | £402 | £455 | £415 | £442 | £342 | £248 | £120 | £0 | |
| Restaurants | £0 | £0 | £0 | £357 | £438 | £545 | £671 | £749 | £871 | £958 | £1,129 | £1,307 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £712 | £841 | £1,000 | £1,086 | £1,192 | £1,213 | £1,206 | £1,249 | £1,307 | |
| 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 | ||
| Heidi | 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 |
| Gardener | 0% | £700 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 |
| Gardener | 0% | £700 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 | £1,450 |
| Part-time Helper | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Part-time Helper | 0% | £0 | £0 | £0 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Total People | 0 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £3,400 | £4,900 | £4,900 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,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 | 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 | £0 | £0 | £5,930 | £7,008 | £8,334 | £9,046 | £9,932 | £10,105 | £10,050 | £10,412 | £10,895 | |
| Direct Cost of Sales | £0 | £0 | £0 | £712 | £841 | £1,000 | £1,086 | £1,192 | £1,213 | £1,206 | £1,249 | £1,307 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £712 | £841 | £1,000 | £1,086 | £1,192 | £1,213 | £1,206 | £1,249 | £1,307 | |
| Gross Margin | £0 | £0 | £0 | £5,218 | £6,167 | £7,334 | £7,960 | £8,740 | £8,892 | £8,844 | £9,163 | £9,588 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 88.00% | 88.00% | 88.00% | 88.00% | 88.00% | 88.00% | 88.00% | 88.00% | 88.00% | |
| Expenses | |||||||||||||
| Payroll | £3,400 | £4,900 | £4,900 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £211 | £211 | £211 | £211 | £211 | £211 | £211 | £211 | £211 | £211 | £211 | £211 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Rent | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Payroll Taxes | 15% | £510 | £735 | £735 | £848 | £848 | £848 | £848 | £848 | £848 | £848 | £848 | £848 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £5,071 | £6,796 | £6,796 | £7,659 | £7,659 | £7,659 | £7,659 | £7,659 | £7,659 | £7,659 | £7,659 | £7,659 | |
| Profit Before Interest and Taxes | (£5,071) | (£6,796) | (£6,796) | (£2,440) | (£1,491) | (£325) | £302 | £1,082 | £1,234 | £1,186 | £1,504 | £1,929 | |
| EBITDA | (£4,860) | (£6,585) | (£6,585) | (£2,229) | (£1,280) | (£114) | £513 | £1,293 | £1,445 | £1,397 | £1,715 | £2,140 | |
| Interest Expense | £40 | £38 | £37 | £35 | £33 | £32 | £30 | £28 | £27 | £25 | £23 | £22 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£5,111) | (£6,834) | (£6,833) | (£2,475) | (£1,525) | (£356) | £272 | £1,053 | £1,207 | £1,161 | £1,481 | £1,907 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | -41.75% | -21.76% | -4.27% | 3.01% | 10.61% | 11.95% | 11.55% | 14.22% | 17.51% | |
| 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 | £0 | £0 | £2,372 | £2,803 | £3,334 | £3,618 | £3,973 | £4,042 | £4,020 | £4,165 | £4,358 | |
| Cash from Receivables | £0 | £0 | £0 | £0 | £119 | £3,579 | £4,231 | £5,015 | £5,445 | £5,963 | £6,062 | £6,037 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £2,372 | £2,922 | £6,913 | £7,850 | £8,987 | £9,487 | £9,983 | £10,227 | £10,395 | |
| 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 | £0 | £0 | £2,372 | £2,922 | £6,913 | £7,850 | £8,987 | £9,487 | £9,983 | £10,227 | £10,395 | |
| 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,400 | £4,900 | £4,900 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | £5,650 | |
| Bill Payments | £50 | £1,507 | £1,723 | £1,775 | £3,310 | £2,836 | £2,988 | £3,011 | £3,132 | £3,058 | £3,024 | £3,120 | |
| Subtotal Spent on Operations | £3,450 | £6,407 | £6,623 | £7,425 | £8,960 | £8,486 | £8,638 | £8,661 | £8,782 | £8,708 | £8,674 | £8,770 | |
| 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 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| 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,650 | £6,607 | £6,823 | £7,625 | £9,160 | £8,686 | £8,838 | £8,861 | £8,982 | £8,908 | £8,874 | £8,970 | |
| Net Cash Flow | (£3,650) | (£6,607) | (£6,823) | (£5,253) | (£6,238) | (£1,773) | (£989) | £126 | £505 | £1,074 | £1,352 | £1,425 | |
| Cash Balance | £31,050 | £24,443 | £17,619 | £12,366 | £6,128 | £4,354 | £3,366 | £3,492 | £3,997 | £5,072 | £6,424 | £7,849 | |
| 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 | £34,700 | £31,050 | £24,443 | £17,619 | £12,366 | £6,128 | £4,354 | £3,366 | £3,492 | £3,997 | £5,072 | £6,424 | £7,849 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £3,558 | £7,644 | £9,065 | £10,261 | £11,206 | £11,824 | £11,891 | £12,076 | £12,576 |
| Inventory | £0 | £0 | £0 | £0 | £783 | £942 | £1,100 | £1,194 | £1,311 | £1,334 | £1,327 | £1,374 | £1,438 |
| Other Current Assets | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Total Current Assets | £35,200 | £31,550 | £24,943 | £18,119 | £17,207 | £15,213 | £15,020 | £15,321 | £16,509 | £17,655 | £18,789 | £20,374 | £22,363 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 | £25,300 |
| Accumulated Depreciation | £0 | £211 | £422 | £633 | £844 | £1,055 | £1,266 | £1,477 | £1,688 | £1,899 | £2,110 | £2,321 | £2,532 |
| Total Long-term Assets | £25,300 | £25,089 | £24,878 | £24,667 | £24,456 | £24,245 | £24,034 | £23,823 | £23,612 | £23,401 | £23,190 | £22,979 | £22,768 |
| Total Assets | £60,500 | £56,639 | £49,821 | £42,786 | £41,663 | £39,458 | £39,054 | £39,144 | £40,121 | £41,056 | £41,979 | £43,353 | £45,131 |
| 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,450 | £1,666 | £1,664 | £3,216 | £2,736 | £2,888 | £2,907 | £3,030 | £2,958 | £2,921 | £3,014 | £3,084 |
| Current Borrowing | £5,000 | £4,800 | £4,600 | £4,400 | £4,200 | £4,000 | £3,800 | £3,600 | £3,400 | £3,200 | £3,000 | £2,800 | £2,600 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £5,000 | £6,250 | £6,266 | £6,064 | £7,416 | £6,736 | £6,688 | £6,507 | £6,430 | £6,158 | £5,921 | £5,814 | £5,684 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £5,000 | £6,250 | £6,266 | £6,064 | £7,416 | £6,736 | £6,688 | £6,507 | £6,430 | £6,158 | £5,921 | £5,814 | £5,684 |
| Paid-in Capital | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 | £60,600 |
| Retained Earnings | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) | (£5,100) |
| Earnings | £0 | (£5,111) | (£11,945) | (£18,778) | (£21,253) | (£22,778) | (£23,134) | (£22,862) | (£21,809) | (£20,602) | (£19,441) | (£17,961) | (£16,053) |
| Total Capital | £55,500 | £50,389 | £43,555 | £36,722 | £34,247 | £32,722 | £32,366 | £32,638 | £33,691 | £34,898 | £36,059 | £37,539 | £39,447 |
| Total Liabilities and Capital | £60,500 | £56,639 | £49,821 | £42,786 | £41,663 | £39,458 | £39,054 | £39,144 | £40,121 | £41,056 | £41,979 | £43,353 | £45,131 |
| Net Worth | £55,500 | £50,389 | £43,555 | £36,722 | £34,247 | £32,722 | £32,366 | £32,638 | £33,691 | £34,898 | £36,059 | £37,539 | £39,447 |