| 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 | |||||||||||||
| Rental Revenue | 0% | £0 | £0 | £0 | £0 | £4,800 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £0 | £0 | £0 | £0 | £4,800 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | |
| 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 | |
| Rental Costs | £0 | £0 | £0 | £0 | £480 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £480 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | |
| 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 | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% |
| Long-term Interest Rate | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% |
| 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 | £0 | £0 | £4,800 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £480 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | |
| Other Production Expenses | £3,000 | £5,000 | £5,000 | £5,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £3,000 | £5,000 | £5,000 | £5,000 | £480 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | |
| Gross Margin | (£3,000) | (£5,000) | (£5,000) | (£5,000) | £4,320 | £2,160 | £2,160 | £2,160 | £2,160 | £2,160 | £2,160 | £2,160 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales and Marketing and Other Expenses | £2,100 | £2,100 | £2,100 | £2,300 | £200 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Depreciation | £0 | £0 | £0 | £0 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £400 | £400 | £400 | £300 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £300 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £2,800 | £2,500 | £2,500 | £2,600 | £700 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Profit Before Interest and Taxes | (£5,800) | (£7,500) | (£7,500) | (£7,600) | £3,620 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | |
| EBITDA | (£5,800) | (£7,500) | (£7,500) | (£7,600) | £4,020 | £1,960 | £1,960 | £1,960 | £1,960 | £1,960 | £1,960 | £1,960 | |
| Interest Expense | £900 | £898 | £896 | £894 | £892 | £890 | £888 | £886 | £884 | £882 | £880 | £878 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£6,700) | (£8,398) | (£8,396) | (£8,494) | £2,728 | £670 | £672 | £674 | £676 | £678 | £680 | £682 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 56.83% | 27.91% | 28.00% | 28.08% | 28.17% | 28.25% | 28.34% | 28.42% | |
| 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 | £4,800 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £4,800 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | |
| 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 | £0 | £0 | £4,800 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Bill Payments | £223 | £6,757 | £8,398 | £8,399 | £8,267 | £1,661 | £1,330 | £1,328 | £1,326 | £1,324 | £1,322 | £1,320 | |
| Subtotal Spent on Operations | £223 | £6,757 | £8,398 | £8,399 | £8,267 | £1,661 | £1,330 | £1,328 | £1,326 | £1,324 | £1,322 | £1,320 | |
| 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 | £348 | £350 | £352 | £354 | £356 | £358 | £360 | £362 | £364 | £366 | £368 | |
| 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 | £223 | £7,105 | £8,748 | £8,751 | £8,621 | £2,017 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | |
| Net Cash Flow | (£223) | (£7,105) | (£8,748) | (£8,751) | (£3,821) | £383 | £712 | £712 | £712 | £712 | £712 | £712 | |
| Cash Balance | £74,277 | £67,172 | £58,424 | £49,673 | £45,852 | £46,236 | £46,948 | £47,660 | £48,372 | £49,084 | £49,796 | £50,508 | |
| 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 | £74,500 | £74,277 | £67,172 | £58,424 | £49,673 | £45,852 | £46,236 | £46,948 | £47,660 | £48,372 | £49,084 | £49,796 | £50,508 |
| Other Current Assets | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Total Current Assets | £75,250 | £75,027 | £67,922 | £59,174 | £50,423 | £46,602 | £46,986 | £47,698 | £48,410 | £49,122 | £49,834 | £50,546 | £51,258 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £400 | £800 | £1,200 | £1,600 | £2,000 | £2,400 | £2,800 | £3,200 |
| Total Long-term Assets | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £143,600 | £143,200 | £142,800 | £142,400 | £142,000 | £141,600 | £141,200 | £140,800 |
| Total Assets | £219,250 | £219,027 | £211,922 | £203,174 | £194,423 | £190,202 | £190,186 | £190,498 | £190,810 | £191,122 | £191,434 | £191,746 | £192,058 |
| 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 | £6,477 | £8,118 | £8,116 | £8,211 | £1,616 | £1,286 | £1,284 | £1,282 | £1,280 | £1,278 | £1,276 | £1,274 |
| 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 | £6,477 | £8,118 | £8,116 | £8,211 | £1,616 | £1,286 | £1,284 | £1,282 | £1,280 | £1,278 | £1,276 | £1,274 |
| Long-term Liabilities | £160,000 | £160,000 | £159,652 | £159,302 | £158,950 | £158,596 | £158,240 | £157,883 | £157,523 | £157,161 | £156,797 | £156,431 | £156,062 |
| Total Liabilities | £160,000 | £166,477 | £167,770 | £167,418 | £167,161 | £160,213 | £159,526 | £159,166 | £158,804 | £158,440 | £158,074 | £157,706 | £157,336 |
| Paid-in Capital | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 |
| Retained Earnings | (£750) | (£750) | (£750) | (£750) | (£750) | (£750) | (£750) | (£750) | (£750) | (£750) | (£750) | (£750) | (£750) |
| Earnings | £0 | (£6,700) | (£15,098) | (£23,494) | (£31,988) | (£29,260) | (£28,590) | (£27,919) | (£27,245) | (£26,569) | (£25,891) | (£25,211) | (£24,528) |
| Total Capital | £59,250 | £52,550 | £44,152 | £35,756 | £27,262 | £29,990 | £30,660 | £31,331 | £32,005 | £32,681 | £33,359 | £34,039 | £34,722 |
| Total Liabilities and Capital | £219,250 | £219,027 | £211,922 | £203,174 | £194,423 | £190,202 | £190,186 | £190,498 | £190,810 | £191,122 | £191,434 | £191,746 | £192,058 |
| Net Worth | £59,250 | £52,550 | £44,152 | £35,756 | £27,262 | £29,990 | £30,660 | £31,331 | £32,005 | £32,681 | £33,359 | £34,039 | £34,722 |
| 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 | |||||||||||||
| Rental Revenue | 0% | £0 | £0 | £0 | £0 | £4,800 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £0 | £0 | £0 | £0 | £4,800 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | |
| 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 | |
| Rental Costs | £0 | £0 | £0 | £0 | £480 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £480 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | |
| 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 | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% |
| Long-term Interest Rate | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% | 6.75% |
| 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 | £0 | £0 | £4,800 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £480 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | |
| Other Production Expenses | £3,000 | £5,000 | £5,000 | £5,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £3,000 | £5,000 | £5,000 | £5,000 | £480 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | |
| Gross Margin | (£3,000) | (£5,000) | (£5,000) | (£5,000) | £4,320 | £2,160 | £2,160 | £2,160 | £2,160 | £2,160 | £2,160 | £2,160 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales and Marketing and Other Expenses | £2,100 | £2,100 | £2,100 | £2,300 | £200 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Depreciation | £0 | £0 | £0 | £0 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £400 | £400 | £400 | £300 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £300 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £2,800 | £2,500 | £2,500 | £2,600 | £700 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Profit Before Interest and Taxes | (£5,800) | (£7,500) | (£7,500) | (£7,600) | £3,620 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | |
| EBITDA | (£5,800) | (£7,500) | (£7,500) | (£7,600) | £4,020 | £1,960 | £1,960 | £1,960 | £1,960 | £1,960 | £1,960 | £1,960 | |
| Interest Expense | £900 | £898 | £896 | £894 | £892 | £890 | £888 | £886 | £884 | £882 | £880 | £878 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£6,700) | (£8,398) | (£8,396) | (£8,494) | £2,728 | £670 | £672 | £674 | £676 | £678 | £680 | £682 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 56.83% | 27.91% | 28.00% | 28.08% | 28.17% | 28.25% | 28.34% | 28.42% | |
| 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 | £4,800 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £4,800 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | |
| 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 | £0 | £0 | £4,800 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Bill Payments | £223 | £6,757 | £8,398 | £8,399 | £8,267 | £1,661 | £1,330 | £1,328 | £1,326 | £1,324 | £1,322 | £1,320 | |
| Subtotal Spent on Operations | £223 | £6,757 | £8,398 | £8,399 | £8,267 | £1,661 | £1,330 | £1,328 | £1,326 | £1,324 | £1,322 | £1,320 | |
| 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 | £348 | £350 | £352 | £354 | £356 | £358 | £360 | £362 | £364 | £366 | £368 | |
| 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 | £223 | £7,105 | £8,748 | £8,751 | £8,621 | £2,017 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | |
| Net Cash Flow | (£223) | (£7,105) | (£8,748) | (£8,751) | (£3,821) | £383 | £712 | £712 | £712 | £712 | £712 | £712 | |
| Cash Balance | £74,277 | £67,172 | £58,424 | £49,673 | £45,852 | £46,236 | £46,948 | £47,660 | £48,372 | £49,084 | £49,796 | £50,508 | |
| 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 | £74,500 | £74,277 | £67,172 | £58,424 | £49,673 | £45,852 | £46,236 | £46,948 | £47,660 | £48,372 | £49,084 | £49,796 | £50,508 |
| Other Current Assets | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Total Current Assets | £75,250 | £75,027 | £67,922 | £59,174 | £50,423 | £46,602 | £46,986 | £47,698 | £48,410 | £49,122 | £49,834 | £50,546 | £51,258 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £400 | £800 | £1,200 | £1,600 | £2,000 | £2,400 | £2,800 | £3,200 |
| Total Long-term Assets | £144,000 | £144,000 | £144,000 | £144,000 | £144,000 | £143,600 | £143,200 | £142,800 | £142,400 | £142,000 | £141,600 | £141,200 | £140,800 |
| Total Assets | £219,250 | £219,027 | £211,922 | £203,174 | £194,423 | £190,202 | £190,186 | £190,498 | £190,810 | £191,122 | £191,434 | £191,746 | £192,058 |
| 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 | £6,477 | £8,118 | £8,116 | £8,211 | £1,616 | £1,286 | £1,284 | £1,282 | £1,280 | £1,278 | £1,276 | £1,274 |
| 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 | £6,477 | £8,118 | £8,116 | £8,211 | £1,616 | £1,286 | £1,284 | £1,282 | £1,280 | £1,278 | £1,276 | £1,274 |
| Long-term Liabilities | £160,000 | £160,000 | £159,652 | £159,302 | £158,950 | £158,596 | £158,240 | £157,883 | £157,523 | £157,161 | £156,797 | £156,431 | £156,062 |
| Total Liabilities | £160,000 | £166,477 | £167,770 | £167,418 | £167,161 | £160,213 | £159,526 | £159,166 | £158,804 | £158,440 | £158,074 | £157,706 | £157,336 |
| Paid-in Capital | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 |
| Retained Earnings | (£750) | (£750) | (£750) | (£750) | (£750) | (£750) | (£750) | (£750) | (£750) | (£750) | (£750) | (£750) | (£750) |
| Earnings | £0 | (£6,700) | (£15,098) | (£23,494) | (£31,988) | (£29,260) | (£28,590) | (£27,919) | (£27,245) | (£26,569) | (£25,891) | (£25,211) | (£24,528) |
| Total Capital | £59,250 | £52,550 | £44,152 | £35,756 | £27,262 | £29,990 | £30,660 | £31,331 | £32,005 | £32,681 | £33,359 | £34,039 | £34,722 |
| Total Liabilities and Capital | £219,250 | £219,027 | £211,922 | £203,174 | £194,423 | £190,202 | £190,186 | £190,498 | £190,810 | £191,122 | £191,434 | £191,746 | £192,058 |
| Net Worth | £59,250 | £52,550 | £44,152 | £35,756 | £27,262 | £29,990 | £30,660 | £31,331 | £32,005 | £32,681 | £33,359 | £34,039 | £34,722 |