| 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 | |||||||||||||
| Customers | 0% | £10,000 | £10,000 | £15,000 | £15,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 |
| Physician membership | 0% | £10,000 | £15,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Other services | 0% | £15,000 | £20,000 | £25,000 | £40,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Total Sales | £35,000 | £45,000 | £70,000 | £85,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | |
| 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 | |
| Customers | £1,333 | £1,333 | £2,000 | £2,000 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | |
| Physician membership | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other services | £2,000 | £2,667 | £3,333 | £5,334 | £6,667 | £6,667 | £6,667 | £6,667 | £6,667 | £6,667 | £6,667 | £6,667 | |
| Subtotal Direct Cost of Sales | £3,333 | £4,000 | £5,333 | £7,334 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| All Staff | 0% | £21,375 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £21,375 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | |
| 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 | £35,000 | £45,000 | £70,000 | £85,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | |
| Direct Cost of Sales | £3,333 | £4,000 | £5,333 | £7,334 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | |
| Other | £2,500 | £2,500 | £2,500 | £2,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Total Cost of Sales | £5,833 | £6,500 | £7,833 | £9,834 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | |
| Gross Margin | £29,167 | £38,500 | £62,167 | £75,166 | £91,500 | £91,500 | £91,500 | £91,500 | £91,500 | £91,500 | £91,500 | £91,500 | |
| Gross Margin % | 83.33% | 85.56% | 88.81% | 88.43% | 87.14% | 87.14% | 87.14% | 87.14% | 87.14% | 87.14% | 87.14% | 87.14% | |
| Expenses | |||||||||||||
| Payroll | £21,375 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | |
| Sales and Marketing and Other Expenses | £38,500 | £31,000 | £29,000 | £36,500 | £29,000 | £29,000 | £36,500 | £29,000 | £29,000 | £36,500 | £29,000 | £29,000 | |
| Depreciation | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | |
| Continued education | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Payroll Taxes | 15% | £3,206 | £3,207 | £3,207 | £3,207 | £3,207 | £3,207 | £3,207 | £3,207 | £3,207 | £3,207 | £3,207 | £3,207 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £69,881 | £62,384 | £60,384 | £67,884 | £60,384 | £60,384 | £67,884 | £60,384 | £60,384 | £67,884 | £60,384 | £60,384 | |
| Profit Before Interest and Taxes | (£40,714) | (£23,884) | £1,783 | £7,282 | £31,116 | £31,116 | £23,616 | £31,116 | £31,116 | £23,616 | £31,116 | £31,116 | |
| EBITDA | (£40,014) | (£23,184) | £2,483 | £7,982 | £31,816 | £31,816 | £24,316 | £31,816 | £31,816 | £24,316 | £31,816 | £31,816 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£12,214) | (£5,971) | £446 | £1,821 | £7,779 | £7,779 | £5,904 | £7,779 | £7,779 | £5,904 | £7,779 | £7,779 | |
| Net Profit | (£28,500) | (£17,913) | £1,338 | £5,462 | £23,337 | £23,337 | £17,712 | £23,337 | £23,337 | £17,712 | £23,337 | £23,337 | |
| Net Profit/Sales | -81.43% | -39.81% | 1.91% | 6.43% | 22.23% | 22.23% | 16.87% | 22.23% | 22.23% | 16.87% | 22.23% | 22.23% | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cash from Receivables | £0 | £1,167 | £35,333 | £45,833 | £70,500 | £85,667 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | |
| Subtotal Cash from Operations | £0 | £1,167 | £35,333 | £45,833 | £70,500 | £85,667 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £500,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £1,167 | £35,333 | £545,833 | £70,500 | £85,667 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £21,375 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | |
| Bill Payments | £1,381 | £41,405 | £41,027 | £46,948 | £57,532 | £59,586 | £59,773 | £65,023 | £59,586 | £59,773 | £65,023 | £59,586 | |
| Subtotal Spent on Operations | £22,756 | £62,782 | £62,404 | £68,325 | £78,909 | £80,963 | £81,150 | £86,400 | £80,963 | £81,150 | £86,400 | £80,963 | |
| 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 | £25,000 | £25,000 | £25,000 | £25,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £47,756 | £87,782 | £87,404 | £93,325 | £128,909 | £130,963 | £131,150 | £136,400 | £130,963 | £131,150 | £136,400 | £130,963 | |
| Net Cash Flow | (£47,756) | (£86,616) | (£52,071) | £452,508 | (£58,409) | (£45,296) | (£26,150) | (£31,400) | (£25,963) | (£26,150) | (£31,400) | (£25,963) | |
| Cash Balance | £202,244 | £115,629 | £63,558 | £516,066 | £457,657 | £412,361 | £386,211 | £354,811 | £328,848 | £302,698 | £271,298 | £245,335 | |
| 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 | £250,000 | £202,244 | £115,629 | £63,558 | £516,066 | £457,657 | £412,361 | £386,211 | £354,811 | £328,848 | £302,698 | £271,298 | £245,335 |
| Accounts Receivable | £0 | £35,000 | £78,833 | £113,500 | £152,667 | £187,167 | £206,500 | £206,500 | £206,500 | £206,500 | £206,500 | £206,500 | £206,500 |
| Other Current Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Total Current Assets | £255,000 | £242,244 | £199,462 | £182,058 | £673,733 | £649,824 | £623,861 | £597,711 | £566,311 | £540,348 | £514,198 | £482,798 | £456,835 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £25,000 | £50,000 | £75,000 | £100,000 | £150,000 | £200,000 | £250,000 | £300,000 | £350,000 | £400,000 | £450,000 | £500,000 |
| Accumulated Depreciation | £0 | £700 | £1,400 | £2,100 | £2,800 | £3,500 | £4,200 | £4,900 | £5,600 | £6,300 | £7,000 | £7,700 | £8,400 |
| Total Long-term Assets | £0 | £24,300 | £48,600 | £72,900 | £97,200 | £146,500 | £195,800 | £245,100 | £294,400 | £343,700 | £393,000 | £442,300 | £491,600 |
| Total Assets | £255,000 | £266,544 | £248,062 | £254,958 | £770,933 | £796,324 | £819,661 | £842,811 | £860,711 | £884,048 | £907,198 | £925,098 | £948,435 |
| 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 | £40,044 | £39,474 | £45,033 | £55,546 | £57,599 | £57,599 | £63,037 | £57,599 | £57,599 | £63,037 | £57,599 | £57,599 |
| 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 | £40,044 | £39,474 | £45,033 | £55,546 | £57,599 | £57,599 | £63,037 | £57,599 | £57,599 | £63,037 | £57,599 | £57,599 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £40,044 | £39,474 | £45,033 | £55,546 | £57,599 | £57,599 | £63,037 | £57,599 | £57,599 | £63,037 | £57,599 | £57,599 |
| Paid-in Capital | £350,000 | £350,000 | £350,000 | £350,000 | £850,000 | £850,000 | £850,000 | £850,000 | £850,000 | £850,000 | £850,000 | £850,000 | £850,000 |
| Retained Earnings | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) |
| Earnings | £0 | (£28,500) | (£46,413) | (£45,075) | (£39,613) | (£16,276) | £7,061 | £24,774 | £48,111 | £71,448 | £89,161 | £112,498 | £135,835 |
| Total Capital | £255,000 | £226,500 | £208,587 | £209,925 | £715,387 | £738,724 | £762,061 | £779,774 | £803,111 | £826,448 | £844,161 | £867,498 | £890,835 |
| Total Liabilities and Capital | £255,000 | £266,544 | £248,062 | £254,958 | £770,933 | £796,324 | £819,661 | £842,811 | £860,711 | £884,048 | £907,198 | £925,098 | £948,435 |
| Net Worth | £255,000 | £226,500 | £208,587 | £209,925 | £715,387 | £738,724 | £762,061 | £779,774 | £803,111 | £826,448 | £844,161 | £867,498 | £890,835 |
| 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 | |||||||||||||
| Customers | 0% | £10,000 | £10,000 | £15,000 | £15,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 |
| Physician membership | 0% | £10,000 | £15,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Other services | 0% | £15,000 | £20,000 | £25,000 | £40,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Total Sales | £35,000 | £45,000 | £70,000 | £85,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | |
| 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 | |
| Customers | £1,333 | £1,333 | £2,000 | £2,000 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | |
| Physician membership | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other services | £2,000 | £2,667 | £3,333 | £5,334 | £6,667 | £6,667 | £6,667 | £6,667 | £6,667 | £6,667 | £6,667 | £6,667 | |
| Subtotal Direct Cost of Sales | £3,333 | £4,000 | £5,333 | £7,334 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| All Staff | 0% | £21,375 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £21,375 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | |
| 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 | £35,000 | £45,000 | £70,000 | £85,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | |
| Direct Cost of Sales | £3,333 | £4,000 | £5,333 | £7,334 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | |
| Other | £2,500 | £2,500 | £2,500 | £2,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Total Cost of Sales | £5,833 | £6,500 | £7,833 | £9,834 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | |
| Gross Margin | £29,167 | £38,500 | £62,167 | £75,166 | £91,500 | £91,500 | £91,500 | £91,500 | £91,500 | £91,500 | £91,500 | £91,500 | |
| Gross Margin % | 83.33% | 85.56% | 88.81% | 88.43% | 87.14% | 87.14% | 87.14% | 87.14% | 87.14% | 87.14% | 87.14% | 87.14% | |
| Expenses | |||||||||||||
| Payroll | £21,375 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | |
| Sales and Marketing and Other Expenses | £38,500 | £31,000 | £29,000 | £36,500 | £29,000 | £29,000 | £36,500 | £29,000 | £29,000 | £36,500 | £29,000 | £29,000 | |
| Depreciation | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | |
| Continued education | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Payroll Taxes | 15% | £3,206 | £3,207 | £3,207 | £3,207 | £3,207 | £3,207 | £3,207 | £3,207 | £3,207 | £3,207 | £3,207 | £3,207 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £69,881 | £62,384 | £60,384 | £67,884 | £60,384 | £60,384 | £67,884 | £60,384 | £60,384 | £67,884 | £60,384 | £60,384 | |
| Profit Before Interest and Taxes | (£40,714) | (£23,884) | £1,783 | £7,282 | £31,116 | £31,116 | £23,616 | £31,116 | £31,116 | £23,616 | £31,116 | £31,116 | |
| EBITDA | (£40,014) | (£23,184) | £2,483 | £7,982 | £31,816 | £31,816 | £24,316 | £31,816 | £31,816 | £24,316 | £31,816 | £31,816 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£12,214) | (£5,971) | £446 | £1,821 | £7,779 | £7,779 | £5,904 | £7,779 | £7,779 | £5,904 | £7,779 | £7,779 | |
| Net Profit | (£28,500) | (£17,913) | £1,338 | £5,462 | £23,337 | £23,337 | £17,712 | £23,337 | £23,337 | £17,712 | £23,337 | £23,337 | |
| Net Profit/Sales | -81.43% | -39.81% | 1.91% | 6.43% | 22.23% | 22.23% | 16.87% | 22.23% | 22.23% | 16.87% | 22.23% | 22.23% | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cash from Receivables | £0 | £1,167 | £35,333 | £45,833 | £70,500 | £85,667 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | |
| Subtotal Cash from Operations | £0 | £1,167 | £35,333 | £45,833 | £70,500 | £85,667 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £500,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £1,167 | £35,333 | £545,833 | £70,500 | £85,667 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £21,375 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | £21,377 | |
| Bill Payments | £1,381 | £41,405 | £41,027 | £46,948 | £57,532 | £59,586 | £59,773 | £65,023 | £59,586 | £59,773 | £65,023 | £59,586 | |
| Subtotal Spent on Operations | £22,756 | £62,782 | £62,404 | £68,325 | £78,909 | £80,963 | £81,150 | £86,400 | £80,963 | £81,150 | £86,400 | £80,963 | |
| 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 | £25,000 | £25,000 | £25,000 | £25,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £47,756 | £87,782 | £87,404 | £93,325 | £128,909 | £130,963 | £131,150 | £136,400 | £130,963 | £131,150 | £136,400 | £130,963 | |
| Net Cash Flow | (£47,756) | (£86,616) | (£52,071) | £452,508 | (£58,409) | (£45,296) | (£26,150) | (£31,400) | (£25,963) | (£26,150) | (£31,400) | (£25,963) | |
| Cash Balance | £202,244 | £115,629 | £63,558 | £516,066 | £457,657 | £412,361 | £386,211 | £354,811 | £328,848 | £302,698 | £271,298 | £245,335 | |
| 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 | £250,000 | £202,244 | £115,629 | £63,558 | £516,066 | £457,657 | £412,361 | £386,211 | £354,811 | £328,848 | £302,698 | £271,298 | £245,335 |
| Accounts Receivable | £0 | £35,000 | £78,833 | £113,500 | £152,667 | £187,167 | £206,500 | £206,500 | £206,500 | £206,500 | £206,500 | £206,500 | £206,500 |
| Other Current Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Total Current Assets | £255,000 | £242,244 | £199,462 | £182,058 | £673,733 | £649,824 | £623,861 | £597,711 | £566,311 | £540,348 | £514,198 | £482,798 | £456,835 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £25,000 | £50,000 | £75,000 | £100,000 | £150,000 | £200,000 | £250,000 | £300,000 | £350,000 | £400,000 | £450,000 | £500,000 |
| Accumulated Depreciation | £0 | £700 | £1,400 | £2,100 | £2,800 | £3,500 | £4,200 | £4,900 | £5,600 | £6,300 | £7,000 | £7,700 | £8,400 |
| Total Long-term Assets | £0 | £24,300 | £48,600 | £72,900 | £97,200 | £146,500 | £195,800 | £245,100 | £294,400 | £343,700 | £393,000 | £442,300 | £491,600 |
| Total Assets | £255,000 | £266,544 | £248,062 | £254,958 | £770,933 | £796,324 | £819,661 | £842,811 | £860,711 | £884,048 | £907,198 | £925,098 | £948,435 |
| 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 | £40,044 | £39,474 | £45,033 | £55,546 | £57,599 | £57,599 | £63,037 | £57,599 | £57,599 | £63,037 | £57,599 | £57,599 |
| 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 | £40,044 | £39,474 | £45,033 | £55,546 | £57,599 | £57,599 | £63,037 | £57,599 | £57,599 | £63,037 | £57,599 | £57,599 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £40,044 | £39,474 | £45,033 | £55,546 | £57,599 | £57,599 | £63,037 | £57,599 | £57,599 | £63,037 | £57,599 | £57,599 |
| Paid-in Capital | £350,000 | £350,000 | £350,000 | £350,000 | £850,000 | £850,000 | £850,000 | £850,000 | £850,000 | £850,000 | £850,000 | £850,000 | £850,000 |
| Retained Earnings | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) | (£95,000) |
| Earnings | £0 | (£28,500) | (£46,413) | (£45,075) | (£39,613) | (£16,276) | £7,061 | £24,774 | £48,111 | £71,448 | £89,161 | £112,498 | £135,835 |
| Total Capital | £255,000 | £226,500 | £208,587 | £209,925 | £715,387 | £738,724 | £762,061 | £779,774 | £803,111 | £826,448 | £844,161 | £867,498 | £890,835 |
| Total Liabilities and Capital | £255,000 | £266,544 | £248,062 | £254,958 | £770,933 | £796,324 | £819,661 | £842,811 | £860,711 | £884,048 | £907,198 | £925,098 | £948,435 |
| Net Worth | £255,000 | £226,500 | £208,587 | £209,925 | £715,387 | £738,724 | £762,061 | £779,774 | £803,111 | £826,448 | £844,161 | £867,498 | £890,835 |