| 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 | ||
| Owners Salary/Distribution | 0% | £2,000 | £3,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Instructors Compensation | 0% | £1,250 | £1,250 | £1,250 | £2,500 | £2,500 | £2,800 | £2,800 | £2,800 | £4,000 | £4,000 | £4,000 | £4,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £3,250 | £4,250 | £7,250 | £8,500 | £8,500 | £8,800 | £8,800 | £8,800 | £10,000 | £10,000 | £10,000 | £10,000 | |
| 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 | £15,600 | £17,100 | £23,740 | £25,950 | £27,000 | £28,200 | £26,500 | £26,100 | £28,100 | £26,800 | £27,950 | £28,950 | |
| Direct Cost of Sales | £1,496 | £1,496 | £2,312 | £2,312 | £2,771 | £2,771 | £2,771 | £2,771 | £2,771 | £2,771 | £3,001 | £3,001 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £1,496 | £1,496 | £2,312 | £2,312 | £2,771 | £2,771 | £2,771 | £2,771 | £2,771 | £2,771 | £3,001 | £3,001 | |
| Gross Margin | £14,104 | £15,604 | £21,428 | £23,638 | £24,229 | £25,429 | £23,729 | £23,329 | £25,329 | £24,029 | £24,949 | £25,949 | |
| Gross Margin % | 90.41% | 91.25% | 90.26% | 91.09% | 89.74% | 90.17% | 89.54% | 89.38% | 90.14% | 89.66% | 89.26% | 89.63% | |
| Expenses | |||||||||||||
| Payroll | £3,250 | £4,250 | £7,250 | £8,500 | £8,500 | £8,800 | £8,800 | £8,800 | £10,000 | £10,000 | £10,000 | £10,000 | |
| Sales and Marketing and Other Expenses | £3,500 | £3,600 | £3,600 | £5,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | |
| Depreciation | £295 | £295 | £295 | £295 | £295 | £295 | £295 | £295 | £295 | £295 | £295 | £295 | |
| Utilities | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Telephone | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Rent | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Payroll Taxes | 10% | £325 | £425 | £725 | £850 | £850 | £880 | £880 | £880 | £1,000 | £1,000 | £1,000 | £1,000 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £14,470 | £15,670 | £18,970 | £22,345 | £20,345 | £20,675 | £20,675 | £20,675 | £21,995 | £21,995 | £21,995 | £21,995 | |
| Profit Before Interest and Taxes | (£366) | (£66) | £2,458 | £1,293 | £3,884 | £4,754 | £3,054 | £2,654 | £3,334 | £2,034 | £2,954 | £3,954 | |
| EBITDA | (£71) | £229 | £2,753 | £1,588 | £4,179 | £5,049 | £3,349 | £2,949 | £3,629 | £2,329 | £3,249 | £4,249 | |
| Interest Expense | £0 | (£8) | (£17) | (£25) | (£33) | (£42) | (£50) | (£58) | (£67) | (£75) | (£83) | (£92) | |
| Taxes Incurred | (£110) | (£17) | £742 | £395 | £1,175 | £1,439 | £931 | £814 | £1,020 | £633 | £911 | £1,214 | |
| Net Profit | (£256) | (£40) | £1,732 | £923 | £2,742 | £3,357 | £2,173 | £1,899 | £2,380 | £1,476 | £2,126 | £2,832 | |
| Net Profit/Sales | -1.64% | -0.24% | 7.30% | 3.56% | 10.16% | 11.90% | 8.20% | 7.27% | 8.47% | 5.51% | 7.61% | 9.78% | |
| 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 | £15,600 | £17,100 | £23,740 | £25,950 | £27,000 | £28,200 | £26,500 | £26,100 | £28,100 | £26,800 | £27,950 | £28,950 | |
| Subtotal Cash from Operations | £15,600 | £17,100 | £23,740 | £25,950 | £27,000 | £28,200 | £26,500 | £26,100 | £28,100 | £26,800 | £27,950 | £28,950 | |
| 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 | £15,600 | £17,100 | £23,740 | £25,950 | £27,000 | £28,200 | £26,500 | £26,100 | £28,100 | £26,800 | £27,950 | £28,950 | |
| 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,250 | £4,250 | £7,250 | £8,500 | £8,500 | £8,800 | £8,800 | £8,800 | £10,000 | £10,000 | £10,000 | £10,000 | |
| Bill Payments | £410 | £12,321 | £12,658 | £14,522 | £16,207 | £15,472 | £15,731 | £15,228 | £15,117 | £15,411 | £15,045 | £15,539 | |
| Subtotal Spent on Operations | £3,660 | £16,571 | £19,908 | £23,022 | £24,707 | £24,272 | £24,531 | £24,028 | £25,117 | £25,411 | £25,045 | £25,539 | |
| 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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £3,660 | £17,571 | £20,908 | £24,022 | £25,707 | £25,272 | £25,531 | £25,028 | £26,117 | £26,411 | £26,045 | £26,539 | |
| Net Cash Flow | £11,940 | (£471) | £2,832 | £1,928 | £1,293 | £2,928 | £969 | £1,072 | £1,983 | £389 | £1,905 | £2,411 | |
| Cash Balance | £22,690 | £22,219 | £25,051 | £26,980 | £28,273 | £31,200 | £32,170 | £33,242 | £35,225 | £35,613 | £37,518 | £39,929 | |
| 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 | £10,750 | £22,690 | £22,219 | £25,051 | £26,980 | £28,273 | £31,200 | £32,170 | £33,242 | £35,225 | £35,613 | £37,518 | £39,929 |
| Other Current Assets | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 |
| Total Current Assets | £22,750 | £34,690 | £34,219 | £37,051 | £38,980 | £40,273 | £43,200 | £44,170 | £45,242 | £47,225 | £47,613 | £49,518 | £51,929 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 |
| Accumulated Depreciation | £0 | £295 | £590 | £885 | £1,180 | £1,475 | £1,770 | £2,065 | £2,360 | £2,655 | £2,950 | £3,245 | £3,540 |
| Total Long-term Assets | £17,700 | £17,405 | £17,110 | £16,815 | £16,520 | £16,225 | £15,930 | £15,635 | £15,340 | £15,045 | £14,750 | £14,455 | £14,160 |
| Total Assets | £40,450 | £52,095 | £51,329 | £53,866 | £55,500 | £56,498 | £59,130 | £59,805 | £60,582 | £62,270 | £62,363 | £63,973 | £66,089 |
| 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 | £11,901 | £12,176 | £13,981 | £15,691 | £14,947 | £15,223 | £14,724 | £14,603 | £14,910 | £14,528 | £15,011 | £15,296 |
| 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 | £11,901 | £12,176 | £13,981 | £15,691 | £14,947 | £15,223 | £14,724 | £14,603 | £14,910 | £14,528 | £15,011 | £15,296 |
| Long-term Liabilities | £0 | £0 | (£1,000) | (£2,000) | (£3,000) | (£4,000) | (£5,000) | (£6,000) | (£7,000) | (£8,000) | (£9,000) | (£10,000) | (£11,000) |
| Total Liabilities | £0 | £11,901 | £11,176 | £11,981 | £12,691 | £10,947 | £10,223 | £8,724 | £7,603 | £6,910 | £5,528 | £5,011 | £4,296 |
| Paid-in Capital | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Retained Earnings | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) |
| Earnings | £0 | (£256) | (£297) | £1,436 | £2,358 | £5,100 | £8,457 | £10,630 | £12,529 | £14,909 | £16,386 | £18,512 | £21,344 |
| Total Capital | £40,450 | £40,194 | £40,153 | £41,886 | £42,808 | £45,550 | £48,907 | £51,080 | £52,979 | £55,359 | £56,836 | £58,962 | £61,794 |
| Total Liabilities and Capital | £40,450 | £52,095 | £51,329 | £53,866 | £55,500 | £56,498 | £59,130 | £59,805 | £60,582 | £62,270 | £62,363 | £63,973 | £66,089 |
| Net Worth | £40,450 | £40,194 | £40,153 | £41,886 | £42,808 | £45,550 | £48,907 | £51,080 | £52,979 | £55,359 | £56,836 | £58,962 | £61,794 |
| 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 | ||
| Owners Salary/Distribution | 0% | £2,000 | £3,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Instructors Compensation | 0% | £1,250 | £1,250 | £1,250 | £2,500 | £2,500 | £2,800 | £2,800 | £2,800 | £4,000 | £4,000 | £4,000 | £4,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £3,250 | £4,250 | £7,250 | £8,500 | £8,500 | £8,800 | £8,800 | £8,800 | £10,000 | £10,000 | £10,000 | £10,000 | |
| 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 | £15,600 | £17,100 | £23,740 | £25,950 | £27,000 | £28,200 | £26,500 | £26,100 | £28,100 | £26,800 | £27,950 | £28,950 | |
| Direct Cost of Sales | £1,496 | £1,496 | £2,312 | £2,312 | £2,771 | £2,771 | £2,771 | £2,771 | £2,771 | £2,771 | £3,001 | £3,001 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £1,496 | £1,496 | £2,312 | £2,312 | £2,771 | £2,771 | £2,771 | £2,771 | £2,771 | £2,771 | £3,001 | £3,001 | |
| Gross Margin | £14,104 | £15,604 | £21,428 | £23,638 | £24,229 | £25,429 | £23,729 | £23,329 | £25,329 | £24,029 | £24,949 | £25,949 | |
| Gross Margin % | 90.41% | 91.25% | 90.26% | 91.09% | 89.74% | 90.17% | 89.54% | 89.38% | 90.14% | 89.66% | 89.26% | 89.63% | |
| Expenses | |||||||||||||
| Payroll | £3,250 | £4,250 | £7,250 | £8,500 | £8,500 | £8,800 | £8,800 | £8,800 | £10,000 | £10,000 | £10,000 | £10,000 | |
| Sales and Marketing and Other Expenses | £3,500 | £3,600 | £3,600 | £5,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | |
| Depreciation | £295 | £295 | £295 | £295 | £295 | £295 | £295 | £295 | £295 | £295 | £295 | £295 | |
| Utilities | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Telephone | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Rent | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Payroll Taxes | 10% | £325 | £425 | £725 | £850 | £850 | £880 | £880 | £880 | £1,000 | £1,000 | £1,000 | £1,000 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £14,470 | £15,670 | £18,970 | £22,345 | £20,345 | £20,675 | £20,675 | £20,675 | £21,995 | £21,995 | £21,995 | £21,995 | |
| Profit Before Interest and Taxes | (£366) | (£66) | £2,458 | £1,293 | £3,884 | £4,754 | £3,054 | £2,654 | £3,334 | £2,034 | £2,954 | £3,954 | |
| EBITDA | (£71) | £229 | £2,753 | £1,588 | £4,179 | £5,049 | £3,349 | £2,949 | £3,629 | £2,329 | £3,249 | £4,249 | |
| Interest Expense | £0 | (£8) | (£17) | (£25) | (£33) | (£42) | (£50) | (£58) | (£67) | (£75) | (£83) | (£92) | |
| Taxes Incurred | (£110) | (£17) | £742 | £395 | £1,175 | £1,439 | £931 | £814 | £1,020 | £633 | £911 | £1,214 | |
| Net Profit | (£256) | (£40) | £1,732 | £923 | £2,742 | £3,357 | £2,173 | £1,899 | £2,380 | £1,476 | £2,126 | £2,832 | |
| Net Profit/Sales | -1.64% | -0.24% | 7.30% | 3.56% | 10.16% | 11.90% | 8.20% | 7.27% | 8.47% | 5.51% | 7.61% | 9.78% | |
| 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 | £15,600 | £17,100 | £23,740 | £25,950 | £27,000 | £28,200 | £26,500 | £26,100 | £28,100 | £26,800 | £27,950 | £28,950 | |
| Subtotal Cash from Operations | £15,600 | £17,100 | £23,740 | £25,950 | £27,000 | £28,200 | £26,500 | £26,100 | £28,100 | £26,800 | £27,950 | £28,950 | |
| 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 | £15,600 | £17,100 | £23,740 | £25,950 | £27,000 | £28,200 | £26,500 | £26,100 | £28,100 | £26,800 | £27,950 | £28,950 | |
| 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,250 | £4,250 | £7,250 | £8,500 | £8,500 | £8,800 | £8,800 | £8,800 | £10,000 | £10,000 | £10,000 | £10,000 | |
| Bill Payments | £410 | £12,321 | £12,658 | £14,522 | £16,207 | £15,472 | £15,731 | £15,228 | £15,117 | £15,411 | £15,045 | £15,539 | |
| Subtotal Spent on Operations | £3,660 | £16,571 | £19,908 | £23,022 | £24,707 | £24,272 | £24,531 | £24,028 | £25,117 | £25,411 | £25,045 | £25,539 | |
| 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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £3,660 | £17,571 | £20,908 | £24,022 | £25,707 | £25,272 | £25,531 | £25,028 | £26,117 | £26,411 | £26,045 | £26,539 | |
| Net Cash Flow | £11,940 | (£471) | £2,832 | £1,928 | £1,293 | £2,928 | £969 | £1,072 | £1,983 | £389 | £1,905 | £2,411 | |
| Cash Balance | £22,690 | £22,219 | £25,051 | £26,980 | £28,273 | £31,200 | £32,170 | £33,242 | £35,225 | £35,613 | £37,518 | £39,929 | |
| 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 | £10,750 | £22,690 | £22,219 | £25,051 | £26,980 | £28,273 | £31,200 | £32,170 | £33,242 | £35,225 | £35,613 | £37,518 | £39,929 |
| Other Current Assets | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 |
| Total Current Assets | £22,750 | £34,690 | £34,219 | £37,051 | £38,980 | £40,273 | £43,200 | £44,170 | £45,242 | £47,225 | £47,613 | £49,518 | £51,929 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 |
| Accumulated Depreciation | £0 | £295 | £590 | £885 | £1,180 | £1,475 | £1,770 | £2,065 | £2,360 | £2,655 | £2,950 | £3,245 | £3,540 |
| Total Long-term Assets | £17,700 | £17,405 | £17,110 | £16,815 | £16,520 | £16,225 | £15,930 | £15,635 | £15,340 | £15,045 | £14,750 | £14,455 | £14,160 |
| Total Assets | £40,450 | £52,095 | £51,329 | £53,866 | £55,500 | £56,498 | £59,130 | £59,805 | £60,582 | £62,270 | £62,363 | £63,973 | £66,089 |
| 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 | £11,901 | £12,176 | £13,981 | £15,691 | £14,947 | £15,223 | £14,724 | £14,603 | £14,910 | £14,528 | £15,011 | £15,296 |
| 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 | £11,901 | £12,176 | £13,981 | £15,691 | £14,947 | £15,223 | £14,724 | £14,603 | £14,910 | £14,528 | £15,011 | £15,296 |
| Long-term Liabilities | £0 | £0 | (£1,000) | (£2,000) | (£3,000) | (£4,000) | (£5,000) | (£6,000) | (£7,000) | (£8,000) | (£9,000) | (£10,000) | (£11,000) |
| Total Liabilities | £0 | £11,901 | £11,176 | £11,981 | £12,691 | £10,947 | £10,223 | £8,724 | £7,603 | £6,910 | £5,528 | £5,011 | £4,296 |
| Paid-in Capital | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Retained Earnings | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) | (£9,550) |
| Earnings | £0 | (£256) | (£297) | £1,436 | £2,358 | £5,100 | £8,457 | £10,630 | £12,529 | £14,909 | £16,386 | £18,512 | £21,344 |
| Total Capital | £40,450 | £40,194 | £40,153 | £41,886 | £42,808 | £45,550 | £48,907 | £51,080 | £52,979 | £55,359 | £56,836 | £58,962 | £61,794 |
| Total Liabilities and Capital | £40,450 | £52,095 | £51,329 | £53,866 | £55,500 | £56,498 | £59,130 | £59,805 | £60,582 | £62,270 | £62,363 | £63,973 | £66,089 |
| Net Worth | £40,450 | £40,194 | £40,153 | £41,886 | £42,808 | £45,550 | £48,907 | £51,080 | £52,979 | £55,359 | £56,836 | £58,962 | £61,794 |