| 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 | |||||||||||||
| Urban departments | 0% | £0 | £0 | £2,000 | £2,500 | £3,656 | £6,987 | £7,987 | £9,695 | £11,254 | £13,655 | £16,545 | £17,474 |
| Rural departments | 0% | £0 | £0 | £1,080 | £1,350 | £1,974 | £3,773 | £4,313 | £5,235 | £6,077 | £7,374 | £8,934 | £9,436 |
| Total Sales | £0 | £0 | £3,080 | £3,850 | £5,630 | £10,760 | £12,300 | £14,930 | £17,331 | £21,029 | £25,479 | £26,910 | |
| 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 | |
| Urban departments | £0 | £0 | £780 | £975 | £1,426 | £2,725 | £3,115 | £3,781 | £4,389 | £5,325 | £6,453 | £6,815 | |
| Rural departments | £0 | £0 | £421 | £527 | £770 | £1,471 | £1,682 | £2,042 | £2,370 | £2,876 | £3,484 | £3,680 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £1,201 | £1,502 | £2,196 | £4,196 | £4,797 | £5,823 | £6,759 | £8,201 | £9,937 | £10,495 | |
| 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 | ||
| Steve | 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 |
| Sales/Procurement | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Customer service | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Customer service | 0% | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Customer service | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Administrative | 0% | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Accounting | 0% | £0 | £0 | £0 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 |
| Total People | 1 | 1 | 4 | 5 | 6 | 6 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £2,000 | £2,000 | £7,500 | £8,700 | £10,700 | £10,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,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% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | £3,080 | £3,850 | £5,630 | £10,760 | £12,300 | £14,930 | £17,331 | £21,029 | £25,479 | £26,910 | |
| Direct Cost of Sales | £0 | £0 | £1,201 | £1,502 | £2,196 | £4,196 | £4,797 | £5,823 | £6,759 | £8,201 | £9,937 | £10,495 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £1,201 | £1,502 | £2,196 | £4,196 | £4,797 | £5,823 | £6,759 | £8,201 | £9,937 | £10,495 | |
| Gross Margin | £0 | £0 | £1,879 | £2,349 | £3,434 | £6,564 | £7,503 | £9,107 | £10,572 | £12,828 | £15,542 | £16,415 | |
| Gross Margin % | 0.00% | 0.00% | 61.00% | 61.00% | 61.00% | 61.00% | 61.00% | 61.00% | 61.00% | 61.00% | 61.00% | 61.00% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £2,000 | £7,500 | £8,700 | £10,700 | £10,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | |
| Sales and Marketing and Other Expenses | £300 | £300 | £300 | £2,000 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Depreciation | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | |
| Rent | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Utilities | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Insurance | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Payroll Taxes | 15% | £300 | £300 | £1,125 | £1,305 | £1,605 | £1,605 | £1,905 | £1,905 | £1,905 | £1,905 | £1,905 | £1,905 |
| Other | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Total Operating Expenses | £4,808 | £4,808 | £11,133 | £14,213 | £14,813 | £14,813 | £17,113 | £17,113 | £17,113 | £17,113 | £17,113 | £17,113 | |
| Profit Before Interest and Taxes | (£4,808) | (£4,808) | (£9,254) | (£11,865) | (£11,379) | (£8,249) | (£9,610) | (£8,006) | (£6,541) | (£4,285) | (£1,571) | (£698) | |
| EBITDA | (£4,225) | (£4,225) | (£8,671) | (£11,282) | (£10,796) | (£7,666) | (£9,027) | (£7,423) | (£5,958) | (£3,702) | (£988) | (£115) | |
| 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,808) | (£4,808) | (£9,254) | (£11,865) | (£11,379) | (£8,249) | (£9,610) | (£8,006) | (£6,541) | (£4,285) | (£1,571) | (£698) | |
| Net Profit/Sales | 0.00% | 0.00% | -300.46% | -308.17% | -202.10% | -76.67% | -78.13% | -53.62% | -37.74% | -20.38% | -6.16% | -2.59% | |
| 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 | £3,080 | £3,850 | £5,630 | £10,760 | £12,300 | £14,930 | £17,331 | £21,029 | £25,479 | £26,910 | |
| Subtotal Cash from Operations | £0 | £0 | £3,080 | £3,850 | £5,630 | £10,760 | £12,300 | £14,930 | £17,331 | £21,029 | £25,479 | £26,910 | |
| 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 | £3,080 | £3,850 | £5,630 | £10,760 | £12,300 | £14,930 | £17,331 | £21,029 | £25,479 | £26,910 | |
| 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 | £2,000 | £2,000 | £7,500 | £8,700 | £10,700 | £10,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | |
| Bill Payments | £74 | £2,225 | £2,293 | £4,324 | £6,408 | £5,792 | £7,756 | £8,661 | £9,684 | £10,637 | £12,089 | £13,786 | |
| Subtotal Spent on Operations | £2,074 | £4,225 | £9,793 | £13,024 | £17,108 | £16,492 | £20,456 | £21,361 | £22,384 | £23,337 | £24,789 | £26,486 | |
| 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 | £2,074 | £4,225 | £9,793 | £13,024 | £17,108 | £16,492 | £20,456 | £21,361 | £22,384 | £23,337 | £24,789 | £26,486 | |
| Net Cash Flow | (£2,074) | (£4,225) | (£6,713) | (£9,174) | (£11,478) | (£5,733) | (£8,156) | (£6,431) | (£5,053) | (£2,309) | £690 | £424 | |
| Cash Balance | £69,926 | £65,701 | £58,988 | £49,814 | £38,337 | £32,604 | £24,448 | £18,017 | £12,964 | £10,655 | £11,346 | £11,770 | |
| 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 | £72,000 | £69,926 | £65,701 | £58,988 | £49,814 | £38,337 | £32,604 | £24,448 | £18,017 | £12,964 | £10,655 | £11,346 | £11,770 |
| Other Current Assets | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 |
| Total Current Assets | £78,500 | £76,426 | £72,201 | £65,488 | £56,314 | £44,837 | £39,104 | £30,948 | £24,517 | £19,464 | £17,155 | £17,846 | £18,270 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £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 |
| Accumulated Depreciation | £0 | £583 | £1,166 | £1,749 | £2,332 | £2,915 | £3,498 | £4,081 | £4,664 | £5,247 | £5,830 | £6,413 | £6,996 |
| Total Long-term Assets | £35,000 | £34,417 | £33,834 | £33,251 | £32,668 | £32,085 | £31,502 | £30,919 | £30,336 | £29,753 | £29,170 | £28,587 | £28,004 |
| Total Assets | £113,500 | £110,843 | £106,035 | £98,739 | £88,982 | £76,922 | £70,606 | £61,867 | £54,853 | £49,217 | £46,325 | £46,433 | £46,274 |
| 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 | £2,151 | £2,151 | £4,109 | £6,217 | £5,535 | £7,469 | £8,339 | £9,331 | £10,236 | £11,630 | £13,308 | £13,847 |
| 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 | £2,151 | £2,151 | £4,109 | £6,217 | £5,535 | £7,469 | £8,339 | £9,331 | £10,236 | £11,630 | £13,308 | £13,847 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £2,151 | £2,151 | £4,109 | £6,217 | £5,535 | £7,469 | £8,339 | £9,331 | £10,236 | £11,630 | £13,308 | £13,847 |
| Paid-in Capital | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 |
| Retained Earnings | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) |
| Earnings | £0 | (£4,808) | (£9,616) | (£18,870) | (£30,735) | (£42,113) | (£50,363) | (£59,973) | (£67,978) | (£74,519) | (£78,805) | (£80,375) | (£81,073) |
| Total Capital | £113,500 | £108,692 | £103,884 | £94,630 | £82,765 | £71,387 | £63,137 | £53,527 | £45,522 | £38,981 | £34,695 | £33,125 | £32,427 |
| Total Liabilities and Capital | £113,500 | £110,843 | £106,035 | £98,739 | £88,982 | £76,922 | £70,606 | £61,867 | £54,853 | £49,217 | £46,325 | £46,433 | £46,274 |
| Net Worth | £113,500 | £108,692 | £103,884 | £94,630 | £82,765 | £71,387 | £63,137 | £53,527 | £45,522 | £38,981 | £34,695 | £33,125 | £32,427 |
| 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 | |||||||||||||
| Urban departments | 0% | £0 | £0 | £2,000 | £2,500 | £3,656 | £6,987 | £7,987 | £9,695 | £11,254 | £13,655 | £16,545 | £17,474 |
| Rural departments | 0% | £0 | £0 | £1,080 | £1,350 | £1,974 | £3,773 | £4,313 | £5,235 | £6,077 | £7,374 | £8,934 | £9,436 |
| Total Sales | £0 | £0 | £3,080 | £3,850 | £5,630 | £10,760 | £12,300 | £14,930 | £17,331 | £21,029 | £25,479 | £26,910 | |
| 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 | |
| Urban departments | £0 | £0 | £780 | £975 | £1,426 | £2,725 | £3,115 | £3,781 | £4,389 | £5,325 | £6,453 | £6,815 | |
| Rural departments | £0 | £0 | £421 | £527 | £770 | £1,471 | £1,682 | £2,042 | £2,370 | £2,876 | £3,484 | £3,680 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £1,201 | £1,502 | £2,196 | £4,196 | £4,797 | £5,823 | £6,759 | £8,201 | £9,937 | £10,495 | |
| 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 | ||
| Steve | 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 |
| Sales/Procurement | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Customer service | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Customer service | 0% | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Customer service | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Administrative | 0% | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Accounting | 0% | £0 | £0 | £0 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 |
| Total People | 1 | 1 | 4 | 5 | 6 | 6 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £2,000 | £2,000 | £7,500 | £8,700 | £10,700 | £10,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,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% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | £3,080 | £3,850 | £5,630 | £10,760 | £12,300 | £14,930 | £17,331 | £21,029 | £25,479 | £26,910 | |
| Direct Cost of Sales | £0 | £0 | £1,201 | £1,502 | £2,196 | £4,196 | £4,797 | £5,823 | £6,759 | £8,201 | £9,937 | £10,495 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £1,201 | £1,502 | £2,196 | £4,196 | £4,797 | £5,823 | £6,759 | £8,201 | £9,937 | £10,495 | |
| Gross Margin | £0 | £0 | £1,879 | £2,349 | £3,434 | £6,564 | £7,503 | £9,107 | £10,572 | £12,828 | £15,542 | £16,415 | |
| Gross Margin % | 0.00% | 0.00% | 61.00% | 61.00% | 61.00% | 61.00% | 61.00% | 61.00% | 61.00% | 61.00% | 61.00% | 61.00% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £2,000 | £7,500 | £8,700 | £10,700 | £10,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | |
| Sales and Marketing and Other Expenses | £300 | £300 | £300 | £2,000 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Depreciation | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | |
| Rent | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Utilities | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Insurance | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Payroll Taxes | 15% | £300 | £300 | £1,125 | £1,305 | £1,605 | £1,605 | £1,905 | £1,905 | £1,905 | £1,905 | £1,905 | £1,905 |
| Other | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Total Operating Expenses | £4,808 | £4,808 | £11,133 | £14,213 | £14,813 | £14,813 | £17,113 | £17,113 | £17,113 | £17,113 | £17,113 | £17,113 | |
| Profit Before Interest and Taxes | (£4,808) | (£4,808) | (£9,254) | (£11,865) | (£11,379) | (£8,249) | (£9,610) | (£8,006) | (£6,541) | (£4,285) | (£1,571) | (£698) | |
| EBITDA | (£4,225) | (£4,225) | (£8,671) | (£11,282) | (£10,796) | (£7,666) | (£9,027) | (£7,423) | (£5,958) | (£3,702) | (£988) | (£115) | |
| 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,808) | (£4,808) | (£9,254) | (£11,865) | (£11,379) | (£8,249) | (£9,610) | (£8,006) | (£6,541) | (£4,285) | (£1,571) | (£698) | |
| Net Profit/Sales | 0.00% | 0.00% | -300.46% | -308.17% | -202.10% | -76.67% | -78.13% | -53.62% | -37.74% | -20.38% | -6.16% | -2.59% | |
| 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 | £3,080 | £3,850 | £5,630 | £10,760 | £12,300 | £14,930 | £17,331 | £21,029 | £25,479 | £26,910 | |
| Subtotal Cash from Operations | £0 | £0 | £3,080 | £3,850 | £5,630 | £10,760 | £12,300 | £14,930 | £17,331 | £21,029 | £25,479 | £26,910 | |
| 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 | £3,080 | £3,850 | £5,630 | £10,760 | £12,300 | £14,930 | £17,331 | £21,029 | £25,479 | £26,910 | |
| 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 | £2,000 | £2,000 | £7,500 | £8,700 | £10,700 | £10,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | |
| Bill Payments | £74 | £2,225 | £2,293 | £4,324 | £6,408 | £5,792 | £7,756 | £8,661 | £9,684 | £10,637 | £12,089 | £13,786 | |
| Subtotal Spent on Operations | £2,074 | £4,225 | £9,793 | £13,024 | £17,108 | £16,492 | £20,456 | £21,361 | £22,384 | £23,337 | £24,789 | £26,486 | |
| 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 | £2,074 | £4,225 | £9,793 | £13,024 | £17,108 | £16,492 | £20,456 | £21,361 | £22,384 | £23,337 | £24,789 | £26,486 | |
| Net Cash Flow | (£2,074) | (£4,225) | (£6,713) | (£9,174) | (£11,478) | (£5,733) | (£8,156) | (£6,431) | (£5,053) | (£2,309) | £690 | £424 | |
| Cash Balance | £69,926 | £65,701 | £58,988 | £49,814 | £38,337 | £32,604 | £24,448 | £18,017 | £12,964 | £10,655 | £11,346 | £11,770 | |
| 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 | £72,000 | £69,926 | £65,701 | £58,988 | £49,814 | £38,337 | £32,604 | £24,448 | £18,017 | £12,964 | £10,655 | £11,346 | £11,770 |
| Other Current Assets | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 |
| Total Current Assets | £78,500 | £76,426 | £72,201 | £65,488 | £56,314 | £44,837 | £39,104 | £30,948 | £24,517 | £19,464 | £17,155 | £17,846 | £18,270 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £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 |
| Accumulated Depreciation | £0 | £583 | £1,166 | £1,749 | £2,332 | £2,915 | £3,498 | £4,081 | £4,664 | £5,247 | £5,830 | £6,413 | £6,996 |
| Total Long-term Assets | £35,000 | £34,417 | £33,834 | £33,251 | £32,668 | £32,085 | £31,502 | £30,919 | £30,336 | £29,753 | £29,170 | £28,587 | £28,004 |
| Total Assets | £113,500 | £110,843 | £106,035 | £98,739 | £88,982 | £76,922 | £70,606 | £61,867 | £54,853 | £49,217 | £46,325 | £46,433 | £46,274 |
| 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 | £2,151 | £2,151 | £4,109 | £6,217 | £5,535 | £7,469 | £8,339 | £9,331 | £10,236 | £11,630 | £13,308 | £13,847 |
| 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 | £2,151 | £2,151 | £4,109 | £6,217 | £5,535 | £7,469 | £8,339 | £9,331 | £10,236 | £11,630 | £13,308 | £13,847 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £2,151 | £2,151 | £4,109 | £6,217 | £5,535 | £7,469 | £8,339 | £9,331 | £10,236 | £11,630 | £13,308 | £13,847 |
| Paid-in Capital | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 | £135,000 |
| Retained Earnings | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) | (£21,500) |
| Earnings | £0 | (£4,808) | (£9,616) | (£18,870) | (£30,735) | (£42,113) | (£50,363) | (£59,973) | (£67,978) | (£74,519) | (£78,805) | (£80,375) | (£81,073) |
| Total Capital | £113,500 | £108,692 | £103,884 | £94,630 | £82,765 | £71,387 | £63,137 | £53,527 | £45,522 | £38,981 | £34,695 | £33,125 | £32,427 |
| Total Liabilities and Capital | £113,500 | £110,843 | £106,035 | £98,739 | £88,982 | £76,922 | £70,606 | £61,867 | £54,853 | £49,217 | £46,325 | £46,433 | £46,274 |
| Net Worth | £113,500 | £108,692 | £103,884 | £94,630 | £82,765 | £71,387 | £63,137 | £53,527 | £45,522 | £38,981 | £34,695 | £33,125 | £32,427 |