| 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 | |||||||||||||
| Child Admission | 0% | £8,550 | £9,894 | £10,986 | £12,456 | £13,296 | £12,944 | £11,532 | £9,908 | £9,740 | £9,880 | £7,962 | £8,074 |
| Additional Parent Spending | 0% | £2,160 | £2,711 | £3,244 | £3,574 | £3,840 | £3,498 | £2,442 | £2,410 | £2,646 | £2,659 | £1,962 | £2,026 |
| Total Sales | £10,710 | £12,605 | £14,230 | £16,030 | £17,136 | £16,442 | £13,974 | £12,318 | £12,386 | £12,539 | £9,924 | £10,100 | |
| 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 | |
| Child Admission | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Additional Parent Spending | £432 | £542 | £649 | £715 | £768 | £700 | £488 | £482 | £529 | £532 | £392 | £405 | |
| Subtotal Direct Cost of Sales | £432 | £542 | £649 | £715 | £768 | £700 | £488 | £482 | £529 | £532 | £392 | £405 | |
| 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 | ||
| Owner/Manager | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| FT Employee | 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 |
| PT Employee | 0% | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 |
| PT Employee | 0% | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £3,200 | £3,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | |
| 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 | £10,710 | £12,605 | £14,230 | £16,030 | £17,136 | £16,442 | £13,974 | £12,318 | £12,386 | £12,539 | £9,924 | £10,100 | |
| Direct Cost of Sales | £432 | £542 | £649 | £715 | £768 | £700 | £488 | £482 | £529 | £532 | £392 | £405 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £432 | £542 | £649 | £715 | £768 | £700 | £488 | £482 | £529 | £532 | £392 | £405 | |
| Gross Margin | £10,278 | £12,063 | £13,581 | £15,315 | £16,368 | £15,742 | £13,485 | £11,836 | £11,857 | £12,007 | £9,531 | £9,694 | |
| Gross Margin % | 95.97% | 95.70% | 95.44% | 95.54% | 95.52% | 95.75% | 96.51% | 96.09% | 95.73% | 95.76% | 96.05% | 95.99% | |
| Expenses | |||||||||||||
| Payroll | £3,200 | £3,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | |
| Marketing/Promotion | 8% | £857 | £1,008 | £1,138 | £1,282 | £1,370 | £1,315 | £1,118 | £985 | £990 | £1,003 | £794 | £808 |
| Depreciation | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | |
| 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 / Phone / Internet | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | |
| Insurance | £1,200 | £0 | £0 | £1,200 | £0 | £0 | £1,200 | £0 | £0 | £1,200 | £0 | £0 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| CPA | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Website hosting | 15% | £0 | £0 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 |
| Office Expenses | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Total Operating Expenses | £7,852 | £6,803 | £8,958 | £10,302 | £9,190 | £9,135 | £10,138 | £8,805 | £8,810 | £10,023 | £8,614 | £8,628 | |
| Profit Before Interest and Taxes | £2,426 | £5,260 | £4,623 | £5,013 | £7,178 | £6,607 | £3,347 | £3,031 | £3,047 | £1,984 | £917 | £1,066 | |
| EBITDA | £3,006 | £5,840 | £5,203 | £5,593 | £7,758 | £7,187 | £3,927 | £3,611 | £3,627 | £2,564 | £1,497 | £1,646 | |
| Interest Expense | £628 | £622 | £615 | £608 | £602 | £595 | £589 | £582 | £576 | £569 | £563 | £556 | |
| Taxes Incurred | £539 | £1,392 | £1,202 | £1,321 | £1,973 | £1,804 | £828 | £735 | £741 | £425 | £106 | £153 | |
| Net Profit | £1,259 | £3,247 | £2,805 | £3,083 | £4,603 | £4,208 | £1,931 | £1,714 | £1,730 | £991 | £248 | £357 | |
| Net Profit/Sales | 11.75% | 25.76% | 19.72% | 19.23% | 26.86% | 25.59% | 13.82% | 13.91% | 13.97% | 7.90% | 2.50% | 3.54% | |
| 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 | £10,710 | £12,605 | £14,230 | £16,030 | £17,136 | £16,442 | £13,974 | £12,318 | £12,386 | £12,539 | £9,924 | £10,100 | |
| Subtotal Cash from Operations | £10,710 | £12,605 | £14,230 | £16,030 | £17,136 | £16,442 | £13,974 | £12,318 | £12,386 | £12,539 | £9,924 | £10,100 | |
| 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 | £10,710 | £12,605 | £14,230 | £16,030 | £17,136 | £16,442 | £13,974 | £12,318 | £12,386 | £12,539 | £9,924 | £10,100 | |
| 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,200 | £3,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | |
| Bill Payments | £189 | £5,668 | £5,581 | £5,695 | £7,153 | £6,743 | £6,447 | £6,215 | £4,825 | £4,906 | £5,706 | £3,898 | |
| Subtotal Spent on Operations | £3,389 | £8,868 | £10,781 | £10,895 | £12,353 | £11,943 | £11,647 | £11,415 | £10,025 | £10,106 | £10,906 | £9,098 | |
| 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 | £222 | £222 | £222 | £222 | £222 | £222 | £222 | £222 | £222 | £222 | £222 | £223 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | |
| 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 | £4,511 | £9,990 | £11,903 | £12,017 | £13,475 | £13,065 | £12,769 | £12,537 | £11,147 | £11,228 | £12,028 | £10,221 | |
| Net Cash Flow | £6,199 | £2,615 | £2,327 | £4,013 | £3,661 | £3,377 | £1,205 | (£219) | £1,239 | £1,311 | (£2,105) | (£121) | |
| Cash Balance | £14,199 | £16,814 | £19,141 | £23,154 | £26,815 | £30,192 | £31,396 | £31,177 | £32,416 | £33,727 | £31,622 | £31,501 | |
| 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 | £8,000 | £14,199 | £16,814 | £19,141 | £23,154 | £26,815 | £30,192 | £31,396 | £31,177 | £32,416 | £33,727 | £31,622 | £31,501 |
| Other Current Assets | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 |
| Total Current Assets | £33,000 | £39,199 | £41,814 | £44,141 | £48,154 | £51,815 | £55,192 | £56,396 | £56,177 | £57,416 | £58,727 | £56,622 | £56,501 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 |
| Accumulated Depreciation | £0 | £580 | £1,160 | £1,740 | £2,320 | £2,900 | £3,480 | £4,060 | £4,640 | £5,220 | £5,800 | £6,380 | £6,960 |
| Total Long-term Assets | £90,000 | £89,420 | £88,840 | £88,260 | £87,680 | £87,100 | £86,520 | £85,940 | £85,360 | £84,780 | £84,200 | £83,620 | £83,040 |
| Total Assets | £123,000 | £128,619 | £130,654 | £132,401 | £135,834 | £138,915 | £141,712 | £142,336 | £141,537 | £142,196 | £142,927 | £140,242 | £139,541 |
| 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,482 | £5,392 | £5,456 | £6,928 | £6,528 | £6,238 | £6,054 | £4,663 | £4,714 | £5,576 | £3,766 | £3,830 |
| Current Borrowing | £8,000 | £7,778 | £7,556 | £7,334 | £7,112 | £6,890 | £6,668 | £6,446 | £6,224 | £6,002 | £5,780 | £5,558 | £5,335 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £8,000 | £13,260 | £12,948 | £12,790 | £14,040 | £13,418 | £12,906 | £12,500 | £10,887 | £10,716 | £11,356 | £9,324 | £9,165 |
| Long-term Liabilities | £100,800 | £99,900 | £99,000 | £98,100 | £97,200 | £96,300 | £95,400 | £94,500 | £93,600 | £92,700 | £91,800 | £90,900 | £90,000 |
| Total Liabilities | £108,800 | £113,160 | £111,948 | £110,890 | £111,240 | £109,718 | £108,306 | £107,000 | £104,487 | £103,416 | £103,156 | £100,224 | £99,165 |
| Paid-in Capital | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 |
| Retained Earnings | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) |
| Earnings | £0 | £1,259 | £4,505 | £7,311 | £10,394 | £14,997 | £19,205 | £21,136 | £22,850 | £24,580 | £25,571 | £25,819 | £26,176 |
| Total Capital | £14,200 | £15,459 | £18,705 | £21,511 | £24,594 | £29,197 | £33,405 | £35,336 | £37,050 | £38,780 | £39,771 | £40,019 | £40,376 |
| Total Liabilities and Capital | £123,000 | £128,619 | £130,654 | £132,401 | £135,834 | £138,915 | £141,712 | £142,336 | £141,537 | £142,196 | £142,927 | £140,242 | £139,541 |
| Net Worth | £14,200 | £15,459 | £18,705 | £21,511 | £24,594 | £29,197 | £33,405 | £35,336 | £37,050 | £38,780 | £39,771 | £40,019 | £40,376 |
| 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 | |||||||||||||
| Child Admission | 0% | £8,550 | £9,894 | £10,986 | £12,456 | £13,296 | £12,944 | £11,532 | £9,908 | £9,740 | £9,880 | £7,962 | £8,074 |
| Additional Parent Spending | 0% | £2,160 | £2,711 | £3,244 | £3,574 | £3,840 | £3,498 | £2,442 | £2,410 | £2,646 | £2,659 | £1,962 | £2,026 |
| Total Sales | £10,710 | £12,605 | £14,230 | £16,030 | £17,136 | £16,442 | £13,974 | £12,318 | £12,386 | £12,539 | £9,924 | £10,100 | |
| 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 | |
| Child Admission | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Additional Parent Spending | £432 | £542 | £649 | £715 | £768 | £700 | £488 | £482 | £529 | £532 | £392 | £405 | |
| Subtotal Direct Cost of Sales | £432 | £542 | £649 | £715 | £768 | £700 | £488 | £482 | £529 | £532 | £392 | £405 | |
| 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 | ||
| Owner/Manager | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| FT Employee | 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 |
| PT Employee | 0% | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 |
| PT Employee | 0% | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £3,200 | £3,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | |
| 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 | £10,710 | £12,605 | £14,230 | £16,030 | £17,136 | £16,442 | £13,974 | £12,318 | £12,386 | £12,539 | £9,924 | £10,100 | |
| Direct Cost of Sales | £432 | £542 | £649 | £715 | £768 | £700 | £488 | £482 | £529 | £532 | £392 | £405 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £432 | £542 | £649 | £715 | £768 | £700 | £488 | £482 | £529 | £532 | £392 | £405 | |
| Gross Margin | £10,278 | £12,063 | £13,581 | £15,315 | £16,368 | £15,742 | £13,485 | £11,836 | £11,857 | £12,007 | £9,531 | £9,694 | |
| Gross Margin % | 95.97% | 95.70% | 95.44% | 95.54% | 95.52% | 95.75% | 96.51% | 96.09% | 95.73% | 95.76% | 96.05% | 95.99% | |
| Expenses | |||||||||||||
| Payroll | £3,200 | £3,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | |
| Marketing/Promotion | 8% | £857 | £1,008 | £1,138 | £1,282 | £1,370 | £1,315 | £1,118 | £985 | £990 | £1,003 | £794 | £808 |
| Depreciation | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | |
| 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 / Phone / Internet | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | |
| Insurance | £1,200 | £0 | £0 | £1,200 | £0 | £0 | £1,200 | £0 | £0 | £1,200 | £0 | £0 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| CPA | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Website hosting | 15% | £0 | £0 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 |
| Office Expenses | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Total Operating Expenses | £7,852 | £6,803 | £8,958 | £10,302 | £9,190 | £9,135 | £10,138 | £8,805 | £8,810 | £10,023 | £8,614 | £8,628 | |
| Profit Before Interest and Taxes | £2,426 | £5,260 | £4,623 | £5,013 | £7,178 | £6,607 | £3,347 | £3,031 | £3,047 | £1,984 | £917 | £1,066 | |
| EBITDA | £3,006 | £5,840 | £5,203 | £5,593 | £7,758 | £7,187 | £3,927 | £3,611 | £3,627 | £2,564 | £1,497 | £1,646 | |
| Interest Expense | £628 | £622 | £615 | £608 | £602 | £595 | £589 | £582 | £576 | £569 | £563 | £556 | |
| Taxes Incurred | £539 | £1,392 | £1,202 | £1,321 | £1,973 | £1,804 | £828 | £735 | £741 | £425 | £106 | £153 | |
| Net Profit | £1,259 | £3,247 | £2,805 | £3,083 | £4,603 | £4,208 | £1,931 | £1,714 | £1,730 | £991 | £248 | £357 | |
| Net Profit/Sales | 11.75% | 25.76% | 19.72% | 19.23% | 26.86% | 25.59% | 13.82% | 13.91% | 13.97% | 7.90% | 2.50% | 3.54% | |
| 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 | £10,710 | £12,605 | £14,230 | £16,030 | £17,136 | £16,442 | £13,974 | £12,318 | £12,386 | £12,539 | £9,924 | £10,100 | |
| Subtotal Cash from Operations | £10,710 | £12,605 | £14,230 | £16,030 | £17,136 | £16,442 | £13,974 | £12,318 | £12,386 | £12,539 | £9,924 | £10,100 | |
| 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 | £10,710 | £12,605 | £14,230 | £16,030 | £17,136 | £16,442 | £13,974 | £12,318 | £12,386 | £12,539 | £9,924 | £10,100 | |
| 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,200 | £3,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | £5,200 | |
| Bill Payments | £189 | £5,668 | £5,581 | £5,695 | £7,153 | £6,743 | £6,447 | £6,215 | £4,825 | £4,906 | £5,706 | £3,898 | |
| Subtotal Spent on Operations | £3,389 | £8,868 | £10,781 | £10,895 | £12,353 | £11,943 | £11,647 | £11,415 | £10,025 | £10,106 | £10,906 | £9,098 | |
| 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 | £222 | £222 | £222 | £222 | £222 | £222 | £222 | £222 | £222 | £222 | £222 | £223 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | |
| 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 | £4,511 | £9,990 | £11,903 | £12,017 | £13,475 | £13,065 | £12,769 | £12,537 | £11,147 | £11,228 | £12,028 | £10,221 | |
| Net Cash Flow | £6,199 | £2,615 | £2,327 | £4,013 | £3,661 | £3,377 | £1,205 | (£219) | £1,239 | £1,311 | (£2,105) | (£121) | |
| Cash Balance | £14,199 | £16,814 | £19,141 | £23,154 | £26,815 | £30,192 | £31,396 | £31,177 | £32,416 | £33,727 | £31,622 | £31,501 | |
| 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 | £8,000 | £14,199 | £16,814 | £19,141 | £23,154 | £26,815 | £30,192 | £31,396 | £31,177 | £32,416 | £33,727 | £31,622 | £31,501 |
| Other Current Assets | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 |
| Total Current Assets | £33,000 | £39,199 | £41,814 | £44,141 | £48,154 | £51,815 | £55,192 | £56,396 | £56,177 | £57,416 | £58,727 | £56,622 | £56,501 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 | £90,000 |
| Accumulated Depreciation | £0 | £580 | £1,160 | £1,740 | £2,320 | £2,900 | £3,480 | £4,060 | £4,640 | £5,220 | £5,800 | £6,380 | £6,960 |
| Total Long-term Assets | £90,000 | £89,420 | £88,840 | £88,260 | £87,680 | £87,100 | £86,520 | £85,940 | £85,360 | £84,780 | £84,200 | £83,620 | £83,040 |
| Total Assets | £123,000 | £128,619 | £130,654 | £132,401 | £135,834 | £138,915 | £141,712 | £142,336 | £141,537 | £142,196 | £142,927 | £140,242 | £139,541 |
| 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,482 | £5,392 | £5,456 | £6,928 | £6,528 | £6,238 | £6,054 | £4,663 | £4,714 | £5,576 | £3,766 | £3,830 |
| Current Borrowing | £8,000 | £7,778 | £7,556 | £7,334 | £7,112 | £6,890 | £6,668 | £6,446 | £6,224 | £6,002 | £5,780 | £5,558 | £5,335 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £8,000 | £13,260 | £12,948 | £12,790 | £14,040 | £13,418 | £12,906 | £12,500 | £10,887 | £10,716 | £11,356 | £9,324 | £9,165 |
| Long-term Liabilities | £100,800 | £99,900 | £99,000 | £98,100 | £97,200 | £96,300 | £95,400 | £94,500 | £93,600 | £92,700 | £91,800 | £90,900 | £90,000 |
| Total Liabilities | £108,800 | £113,160 | £111,948 | £110,890 | £111,240 | £109,718 | £108,306 | £107,000 | £104,487 | £103,416 | £103,156 | £100,224 | £99,165 |
| Paid-in Capital | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 |
| Retained Earnings | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) | (£17,800) |
| Earnings | £0 | £1,259 | £4,505 | £7,311 | £10,394 | £14,997 | £19,205 | £21,136 | £22,850 | £24,580 | £25,571 | £25,819 | £26,176 |
| Total Capital | £14,200 | £15,459 | £18,705 | £21,511 | £24,594 | £29,197 | £33,405 | £35,336 | £37,050 | £38,780 | £39,771 | £40,019 | £40,376 |
| Total Liabilities and Capital | £123,000 | £128,619 | £130,654 | £132,401 | £135,834 | £138,915 | £141,712 | £142,336 | £141,537 | £142,196 | £142,927 | £140,242 | £139,541 |
| Net Worth | £14,200 | £15,459 | £18,705 | £21,511 | £24,594 | £29,197 | £33,405 | £35,336 | £37,050 | £38,780 | £39,771 | £40,019 | £40,376 |