| 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 | |||||||||||||
| Memberships | 0% | £0 | £5,000 | £6,000 | £10,000 | £11,000 | £12,000 | £12,000 | £13,000 | £14,000 | £14,000 | £14,000 | £13,000 |
| Personal Trainers | 0% | £0 | £4,000 | £7,000 | £10,000 | £10,000 | £12,000 | £12,000 | £12,000 | £12,000 | £13,000 | £14,000 | £14,000 |
| Total Sales | £0 | £9,000 | £13,000 | £20,000 | £21,000 | £24,000 | £24,000 | £25,000 | £26,000 | £27,000 | £28,000 | £27,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 | |
| Memberships | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Personal Trainers | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | ||
| Operations Manager/Lead Trainer | 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 |
| Personal Trainers | 0% | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 |
| Childcare Staff | 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 |
| Receptionist/Clerk | 0% | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 9 | 9 | 9 | 9 | 9 | 9 | |
| Total Payroll | £13,600 | £13,600 | £13,600 | £13,600 | £13,600 | £13,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | |
| 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 | £9,000 | £13,000 | £20,000 | £21,000 | £24,000 | £24,000 | £25,000 | £26,000 | £27,000 | £28,000 | £27,000 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Gross Margin | £0 | £9,000 | £13,000 | £20,000 | £21,000 | £24,000 | £24,000 | £25,000 | £26,000 | £27,000 | £28,000 | £27,000 | |
| Gross Margin % | 0.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | £13,600 | £13,600 | £13,600 | £13,600 | £13,600 | £13,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | |
| Sales and Marketing and Other Expenses | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| 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% | £2,040 | £2,040 | £2,040 | £2,040 | £2,040 | £2,040 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £18,740 | £18,740 | £18,740 | £18,740 | £18,740 | £18,740 | £22,190 | £22,190 | £22,190 | £22,190 | £22,190 | £22,190 | |
| Profit Before Interest and Taxes | (£18,740) | (£9,740) | (£5,740) | £1,260 | £2,260 | £5,260 | £1,810 | £2,810 | £3,810 | £4,810 | £5,810 | £4,810 | |
| EBITDA | (£18,740) | (£9,740) | (£5,740) | £1,260 | £2,260 | £5,260 | £1,810 | £2,810 | £3,810 | £4,810 | £5,810 | £4,810 | |
| Interest Expense | £495 | £489 | £484 | £478 | £473 | £468 | £462 | £457 | £451 | £446 | £440 | £435 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£19,235) | (£10,229) | (£6,224) | £782 | £1,787 | £4,793 | £1,348 | £2,353 | £3,359 | £4,364 | £5,370 | £4,375 | |
| Net Profit/Sales | 0.00% | -113.66% | -47.88% | 3.91% | 8.51% | 19.97% | 5.62% | 9.41% | 12.92% | 16.16% | 19.18% | 16.20% | |
| 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 | £9,000 | £13,000 | £20,000 | £21,000 | £24,000 | £24,000 | £25,000 | £26,000 | £27,000 | £28,000 | £27,000 | |
| Subtotal Cash from Operations | £0 | £9,000 | £13,000 | £20,000 | £21,000 | £24,000 | £24,000 | £25,000 | £26,000 | £27,000 | £28,000 | £27,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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £9,000 | £13,000 | £20,000 | £21,000 | £24,000 | £24,000 | £25,000 | £26,000 | £27,000 | £28,000 | £27,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 | £13,600 | £13,600 | £13,600 | £13,600 | £13,600 | £13,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | |
| Bill Payments | £188 | £5,634 | £5,629 | £5,624 | £5,618 | £5,613 | £5,622 | £6,052 | £6,046 | £6,041 | £6,036 | £6,030 | |
| Subtotal Spent on Operations | £13,788 | £19,234 | £19,229 | £19,224 | £19,218 | £19,213 | £22,222 | £22,652 | £22,646 | £22,641 | £22,636 | £22,630 | |
| 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 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | |
| 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 | £14,438 | £19,884 | £19,879 | £19,874 | £19,868 | £19,863 | £22,872 | £23,302 | £23,296 | £23,291 | £23,286 | £23,280 | |
| Net Cash Flow | (£14,438) | (£10,884) | (£6,879) | £126 | £1,132 | £4,137 | £1,128 | £1,698 | £2,704 | £3,709 | £4,714 | £3,720 | |
| Cash Balance | £51,362 | £40,478 | £33,599 | £33,725 | £34,857 | £38,994 | £40,122 | £41,820 | £44,524 | £48,233 | £52,947 | £56,667 | |
| 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 | £65,800 | £51,362 | £40,478 | £33,599 | £33,725 | £34,857 | £38,994 | £40,122 | £41,820 | £44,524 | £48,233 | £52,947 | £56,667 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £65,800 | £51,362 | £40,478 | £33,599 | £33,725 | £34,857 | £38,994 | £40,122 | £41,820 | £44,524 | £48,233 | £52,947 | £56,667 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £65,800 | £51,362 | £40,478 | £33,599 | £33,725 | £34,857 | £38,994 | £40,122 | £41,820 | £44,524 | £48,233 | £52,947 | £56,667 |
| 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 | £5,447 | £5,442 | £5,436 | £5,431 | £5,426 | £5,421 | £5,850 | £5,845 | £5,840 | £5,835 | £5,829 | £5,824 |
| 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 | £5,447 | £5,442 | £5,436 | £5,431 | £5,426 | £5,421 | £5,850 | £5,845 | £5,840 | £5,835 | £5,829 | £5,824 |
| Long-term Liabilities | £60,000 | £59,350 | £58,700 | £58,050 | £57,400 | £56,750 | £56,100 | £55,450 | £54,800 | £54,150 | £53,500 | £52,850 | £52,200 |
| Total Liabilities | £60,000 | £64,797 | £64,142 | £63,486 | £62,831 | £62,176 | £61,521 | £61,300 | £60,645 | £59,990 | £59,335 | £58,679 | £58,024 |
| Paid-in Capital | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 |
| Retained Earnings | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) |
| Earnings | £0 | (£19,235) | (£29,464) | (£35,688) | (£34,906) | (£33,119) | (£28,326) | (£26,978) | (£24,625) | (£21,266) | (£16,902) | (£11,533) | (£7,158) |
| Total Capital | £5,800 | (£13,435) | (£23,664) | (£29,888) | (£29,106) | (£27,319) | (£22,526) | (£21,178) | (£18,825) | (£15,466) | (£11,102) | (£5,733) | (£1,358) |
| Total Liabilities and Capital | £65,800 | £51,362 | £40,478 | £33,599 | £33,725 | £34,857 | £38,994 | £40,122 | £41,820 | £44,524 | £48,233 | £52,947 | £56,667 |
| Net Worth | £5,800 | (£13,435) | (£23,664) | (£29,887) | (£29,106) | (£27,319) | (£22,526) | (£21,178) | (£18,825) | (£15,466) | (£11,102) | (£5,732) | (£1,357) |
| 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 | |||||||||||||
| Memberships | 0% | £0 | £5,000 | £6,000 | £10,000 | £11,000 | £12,000 | £12,000 | £13,000 | £14,000 | £14,000 | £14,000 | £13,000 |
| Personal Trainers | 0% | £0 | £4,000 | £7,000 | £10,000 | £10,000 | £12,000 | £12,000 | £12,000 | £12,000 | £13,000 | £14,000 | £14,000 |
| Total Sales | £0 | £9,000 | £13,000 | £20,000 | £21,000 | £24,000 | £24,000 | £25,000 | £26,000 | £27,000 | £28,000 | £27,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 | |
| Memberships | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Personal Trainers | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | ||
| Operations Manager/Lead Trainer | 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 |
| Personal Trainers | 0% | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 |
| Childcare Staff | 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 |
| Receptionist/Clerk | 0% | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 9 | 9 | 9 | 9 | 9 | 9 | |
| Total Payroll | £13,600 | £13,600 | £13,600 | £13,600 | £13,600 | £13,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | |
| 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 | £9,000 | £13,000 | £20,000 | £21,000 | £24,000 | £24,000 | £25,000 | £26,000 | £27,000 | £28,000 | £27,000 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Gross Margin | £0 | £9,000 | £13,000 | £20,000 | £21,000 | £24,000 | £24,000 | £25,000 | £26,000 | £27,000 | £28,000 | £27,000 | |
| Gross Margin % | 0.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | £13,600 | £13,600 | £13,600 | £13,600 | £13,600 | £13,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | |
| Sales and Marketing and Other Expenses | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| 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% | £2,040 | £2,040 | £2,040 | £2,040 | £2,040 | £2,040 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £18,740 | £18,740 | £18,740 | £18,740 | £18,740 | £18,740 | £22,190 | £22,190 | £22,190 | £22,190 | £22,190 | £22,190 | |
| Profit Before Interest and Taxes | (£18,740) | (£9,740) | (£5,740) | £1,260 | £2,260 | £5,260 | £1,810 | £2,810 | £3,810 | £4,810 | £5,810 | £4,810 | |
| EBITDA | (£18,740) | (£9,740) | (£5,740) | £1,260 | £2,260 | £5,260 | £1,810 | £2,810 | £3,810 | £4,810 | £5,810 | £4,810 | |
| Interest Expense | £495 | £489 | £484 | £478 | £473 | £468 | £462 | £457 | £451 | £446 | £440 | £435 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£19,235) | (£10,229) | (£6,224) | £782 | £1,787 | £4,793 | £1,348 | £2,353 | £3,359 | £4,364 | £5,370 | £4,375 | |
| Net Profit/Sales | 0.00% | -113.66% | -47.88% | 3.91% | 8.51% | 19.97% | 5.62% | 9.41% | 12.92% | 16.16% | 19.18% | 16.20% | |
| 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 | £9,000 | £13,000 | £20,000 | £21,000 | £24,000 | £24,000 | £25,000 | £26,000 | £27,000 | £28,000 | £27,000 | |
| Subtotal Cash from Operations | £0 | £9,000 | £13,000 | £20,000 | £21,000 | £24,000 | £24,000 | £25,000 | £26,000 | £27,000 | £28,000 | £27,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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £9,000 | £13,000 | £20,000 | £21,000 | £24,000 | £24,000 | £25,000 | £26,000 | £27,000 | £28,000 | £27,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 | £13,600 | £13,600 | £13,600 | £13,600 | £13,600 | £13,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | |
| Bill Payments | £188 | £5,634 | £5,629 | £5,624 | £5,618 | £5,613 | £5,622 | £6,052 | £6,046 | £6,041 | £6,036 | £6,030 | |
| Subtotal Spent on Operations | £13,788 | £19,234 | £19,229 | £19,224 | £19,218 | £19,213 | £22,222 | £22,652 | £22,646 | £22,641 | £22,636 | £22,630 | |
| 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 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | |
| 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 | £14,438 | £19,884 | £19,879 | £19,874 | £19,868 | £19,863 | £22,872 | £23,302 | £23,296 | £23,291 | £23,286 | £23,280 | |
| Net Cash Flow | (£14,438) | (£10,884) | (£6,879) | £126 | £1,132 | £4,137 | £1,128 | £1,698 | £2,704 | £3,709 | £4,714 | £3,720 | |
| Cash Balance | £51,362 | £40,478 | £33,599 | £33,725 | £34,857 | £38,994 | £40,122 | £41,820 | £44,524 | £48,233 | £52,947 | £56,667 | |
| 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 | £65,800 | £51,362 | £40,478 | £33,599 | £33,725 | £34,857 | £38,994 | £40,122 | £41,820 | £44,524 | £48,233 | £52,947 | £56,667 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £65,800 | £51,362 | £40,478 | £33,599 | £33,725 | £34,857 | £38,994 | £40,122 | £41,820 | £44,524 | £48,233 | £52,947 | £56,667 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £65,800 | £51,362 | £40,478 | £33,599 | £33,725 | £34,857 | £38,994 | £40,122 | £41,820 | £44,524 | £48,233 | £52,947 | £56,667 |
| 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 | £5,447 | £5,442 | £5,436 | £5,431 | £5,426 | £5,421 | £5,850 | £5,845 | £5,840 | £5,835 | £5,829 | £5,824 |
| 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 | £5,447 | £5,442 | £5,436 | £5,431 | £5,426 | £5,421 | £5,850 | £5,845 | £5,840 | £5,835 | £5,829 | £5,824 |
| Long-term Liabilities | £60,000 | £59,350 | £58,700 | £58,050 | £57,400 | £56,750 | £56,100 | £55,450 | £54,800 | £54,150 | £53,500 | £52,850 | £52,200 |
| Total Liabilities | £60,000 | £64,797 | £64,142 | £63,486 | £62,831 | £62,176 | £61,521 | £61,300 | £60,645 | £59,990 | £59,335 | £58,679 | £58,024 |
| Paid-in Capital | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 |
| Retained Earnings | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) | (£94,200) |
| Earnings | £0 | (£19,235) | (£29,464) | (£35,688) | (£34,906) | (£33,119) | (£28,326) | (£26,978) | (£24,625) | (£21,266) | (£16,902) | (£11,533) | (£7,158) |
| Total Capital | £5,800 | (£13,435) | (£23,664) | (£29,888) | (£29,106) | (£27,319) | (£22,526) | (£21,178) | (£18,825) | (£15,466) | (£11,102) | (£5,733) | (£1,358) |
| Total Liabilities and Capital | £65,800 | £51,362 | £40,478 | £33,599 | £33,725 | £34,857 | £38,994 | £40,122 | £41,820 | £44,524 | £48,233 | £52,947 | £56,667 |
| Net Worth | £5,800 | (£13,435) | (£23,664) | (£29,887) | (£29,106) | (£27,319) | (£22,526) | (£21,178) | (£18,825) | (£15,466) | (£11,102) | (£5,732) | (£1,357) |