| 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 | |||||||||||||
| Aircraft Rental | 0% | £693 | £1,500 | £3,000 | £3,750 | £4,500 | £5,625 | £5,625 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £693 | £1,500 | £3,000 | £3,750 | £4,500 | £5,625 | £5,625 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 | |
| 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 | |
| Aircraft Rental | £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 | |
| 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 | ||
| Owner | 0% | £0 | £0 | £0 | £0 | £833 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Name or title | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Name or title | 0% | £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 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £0 | £0 | £0 | £0 | £833 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,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% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.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 | £693 | £1,500 | £3,000 | £3,750 | £4,500 | £5,625 | £5,625 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 | |
| Direct Cost of Sales | £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 Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Gross Margin | £693 | £1,500 | £3,000 | £3,750 | £4,500 | £5,625 | £5,625 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 | |
| Gross Margin % | 100.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 | £0 | £0 | £0 | £0 | £833 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Fixed Operations Costs | £0 | £1,300 | £2,623 | £2,623 | £2,623 | £2,623 | £2,623 | £2,623 | £2,623 | £2,623 | £2,623 | £2,623 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Aircraft Upgrades | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £500 | £0 | £1,000 | £0 |
| Mainenance and Repairs | £0 | £0 | £0 | £200 | £0 | £500 | £0 | £500 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £0 | £1,600 | £2,923 | £3,123 | £3,756 | £4,423 | £3,923 | £4,423 | £4,423 | £3,923 | £4,923 | £3,923 | |
| Profit Before Interest and Taxes | £693 | (£100) | £77 | £627 | £744 | £1,202 | £1,702 | £452 | £452 | £952 | (£48) | £952 | |
| EBITDA | £693 | £200 | £377 | £927 | £1,044 | £1,502 | £2,002 | £752 | £752 | £1,252 | £252 | £1,252 | |
| Interest Expense | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £265 | £260 | £255 | £248 | |
| Taxes Incurred | £127 | (£104) | (£54) | £100 | £133 | £261 | £401 | £51 | £52 | £194 | (£85) | £197 | |
| Net Profit | £296 | (£266) | (£139) | £257 | £341 | £671 | £1,031 | £131 | £135 | £498 | (£218) | £507 | |
| Net Profit/Sales | 42.73% | -17.76% | -4.63% | 6.85% | 7.58% | 11.93% | 18.33% | 2.69% | 2.76% | 10.22% | -4.48% | 10.39% | |
| 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 | £693 | £1,500 | £3,000 | £3,750 | £4,500 | £5,625 | £5,625 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 | |
| Subtotal Cash from Operations | £693 | £1,500 | £3,000 | £3,750 | £4,500 | £5,625 | £5,625 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 | |
| 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 | £693 | £1,500 | £3,000 | £3,750 | £4,500 | £5,625 | £5,625 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 | |
| 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 | £833 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Bill Payments | £13 | £433 | £1,512 | £2,851 | £3,187 | £3,047 | £3,642 | £3,299 | £3,444 | £3,428 | £3,101 | £3,769 | |
| Subtotal Spent on Operations | £13 | £433 | £1,512 | £2,851 | £4,020 | £4,047 | £4,642 | £4,299 | £4,444 | £4,428 | £4,101 | £4,769 | |
| 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 | £600 | £600 | £600 | £800 | |
| 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 | £13 | £433 | £1,512 | £2,851 | £4,020 | £4,047 | £4,642 | £4,299 | £5,044 | £5,028 | £4,701 | £5,569 | |
| Net Cash Flow | £680 | £1,067 | £1,488 | £899 | £480 | £1,578 | £983 | £576 | (£169) | (£153) | £174 | (£694) | |
| Cash Balance | £980 | £2,047 | £3,535 | £4,434 | £4,914 | £6,492 | £7,475 | £8,051 | £7,883 | £7,729 | £7,904 | £7,210 | |
| 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 | £300 | £980 | £2,047 | £3,535 | £4,434 | £4,914 | £6,492 | £7,475 | £8,051 | £7,883 | £7,729 | £7,904 | £7,210 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £300 | £980 | £2,047 | £3,535 | £4,434 | £4,914 | £6,492 | £7,475 | £8,051 | £7,883 | £7,729 | £7,904 | £7,210 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 |
| Accumulated Depreciation | £0 | £0 | £300 | £600 | £900 | £1,200 | £1,500 | £1,800 | £2,100 | £2,400 | £2,700 | £3,000 | £3,300 |
| Total Long-term Assets | £36,000 | £36,000 | £35,700 | £35,400 | £35,100 | £34,800 | £34,500 | £34,200 | £33,900 | £33,600 | £33,300 | £33,000 | £32,700 |
| Total Assets | £36,300 | £36,980 | £37,747 | £38,935 | £39,534 | £39,714 | £40,992 | £41,675 | £41,951 | £41,483 | £41,029 | £40,904 | £39,910 |
| 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 | £384 | £1,418 | £2,744 | £3,087 | £2,925 | £3,532 | £3,184 | £3,329 | £3,326 | £2,974 | £3,667 | £2,966 |
| 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 | £384 | £1,418 | £2,744 | £3,087 | £2,925 | £3,532 | £3,184 | £3,329 | £3,326 | £2,974 | £3,667 | £2,966 |
| Long-term Liabilities | £32,400 | £32,400 | £32,400 | £32,400 | £32,400 | £32,400 | £32,400 | £32,400 | £32,400 | £31,800 | £31,200 | £30,600 | £29,800 |
| Total Liabilities | £32,400 | £32,784 | £33,818 | £35,144 | £35,487 | £35,325 | £35,932 | £35,584 | £35,729 | £35,126 | £34,174 | £34,267 | £32,766 |
| Paid-in Capital | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 |
| Retained Earnings | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) |
| Earnings | £0 | £296 | £30 | (£109) | £148 | £489 | £1,160 | £2,191 | £2,322 | £2,457 | £2,955 | £2,737 | £3,244 |
| Total Capital | £3,900 | £4,196 | £3,930 | £3,791 | £4,048 | £4,389 | £5,060 | £6,091 | £6,222 | £6,357 | £6,855 | £6,637 | £7,144 |
| Total Liabilities and Capital | £36,300 | £36,980 | £37,747 | £38,935 | £39,534 | £39,714 | £40,992 | £41,675 | £41,951 | £41,483 | £41,029 | £40,904 | £39,910 |
| Net Worth | £3,900 | £4,196 | £3,930 | £3,791 | £4,048 | £4,389 | £5,060 | £6,091 | £6,222 | £6,357 | £6,855 | £6,637 | £7,144 |
| 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 | |||||||||||||
| Aircraft Rental | 0% | £693 | £1,500 | £3,000 | £3,750 | £4,500 | £5,625 | £5,625 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £693 | £1,500 | £3,000 | £3,750 | £4,500 | £5,625 | £5,625 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 | |
| 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 | |
| Aircraft Rental | £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 | |
| 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 | ||
| Owner | 0% | £0 | £0 | £0 | £0 | £833 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Name or title | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Name or title | 0% | £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 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £0 | £0 | £0 | £0 | £833 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,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% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.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 | £693 | £1,500 | £3,000 | £3,750 | £4,500 | £5,625 | £5,625 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 | |
| Direct Cost of Sales | £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 Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Gross Margin | £693 | £1,500 | £3,000 | £3,750 | £4,500 | £5,625 | £5,625 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 | |
| Gross Margin % | 100.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 | £0 | £0 | £0 | £0 | £833 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Fixed Operations Costs | £0 | £1,300 | £2,623 | £2,623 | £2,623 | £2,623 | £2,623 | £2,623 | £2,623 | £2,623 | £2,623 | £2,623 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Aircraft Upgrades | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £500 | £0 | £1,000 | £0 |
| Mainenance and Repairs | £0 | £0 | £0 | £200 | £0 | £500 | £0 | £500 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £0 | £1,600 | £2,923 | £3,123 | £3,756 | £4,423 | £3,923 | £4,423 | £4,423 | £3,923 | £4,923 | £3,923 | |
| Profit Before Interest and Taxes | £693 | (£100) | £77 | £627 | £744 | £1,202 | £1,702 | £452 | £452 | £952 | (£48) | £952 | |
| EBITDA | £693 | £200 | £377 | £927 | £1,044 | £1,502 | £2,002 | £752 | £752 | £1,252 | £252 | £1,252 | |
| Interest Expense | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £265 | £260 | £255 | £248 | |
| Taxes Incurred | £127 | (£104) | (£54) | £100 | £133 | £261 | £401 | £51 | £52 | £194 | (£85) | £197 | |
| Net Profit | £296 | (£266) | (£139) | £257 | £341 | £671 | £1,031 | £131 | £135 | £498 | (£218) | £507 | |
| Net Profit/Sales | 42.73% | -17.76% | -4.63% | 6.85% | 7.58% | 11.93% | 18.33% | 2.69% | 2.76% | 10.22% | -4.48% | 10.39% | |
| 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 | £693 | £1,500 | £3,000 | £3,750 | £4,500 | £5,625 | £5,625 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 | |
| Subtotal Cash from Operations | £693 | £1,500 | £3,000 | £3,750 | £4,500 | £5,625 | £5,625 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 | |
| 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 | £693 | £1,500 | £3,000 | £3,750 | £4,500 | £5,625 | £5,625 | £4,875 | £4,875 | £4,875 | £4,875 | £4,875 | |
| 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 | £833 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Bill Payments | £13 | £433 | £1,512 | £2,851 | £3,187 | £3,047 | £3,642 | £3,299 | £3,444 | £3,428 | £3,101 | £3,769 | |
| Subtotal Spent on Operations | £13 | £433 | £1,512 | £2,851 | £4,020 | £4,047 | £4,642 | £4,299 | £4,444 | £4,428 | £4,101 | £4,769 | |
| 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 | £600 | £600 | £600 | £800 | |
| 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 | £13 | £433 | £1,512 | £2,851 | £4,020 | £4,047 | £4,642 | £4,299 | £5,044 | £5,028 | £4,701 | £5,569 | |
| Net Cash Flow | £680 | £1,067 | £1,488 | £899 | £480 | £1,578 | £983 | £576 | (£169) | (£153) | £174 | (£694) | |
| Cash Balance | £980 | £2,047 | £3,535 | £4,434 | £4,914 | £6,492 | £7,475 | £8,051 | £7,883 | £7,729 | £7,904 | £7,210 | |
| 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 | £300 | £980 | £2,047 | £3,535 | £4,434 | £4,914 | £6,492 | £7,475 | £8,051 | £7,883 | £7,729 | £7,904 | £7,210 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £300 | £980 | £2,047 | £3,535 | £4,434 | £4,914 | £6,492 | £7,475 | £8,051 | £7,883 | £7,729 | £7,904 | £7,210 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 |
| Accumulated Depreciation | £0 | £0 | £300 | £600 | £900 | £1,200 | £1,500 | £1,800 | £2,100 | £2,400 | £2,700 | £3,000 | £3,300 |
| Total Long-term Assets | £36,000 | £36,000 | £35,700 | £35,400 | £35,100 | £34,800 | £34,500 | £34,200 | £33,900 | £33,600 | £33,300 | £33,000 | £32,700 |
| Total Assets | £36,300 | £36,980 | £37,747 | £38,935 | £39,534 | £39,714 | £40,992 | £41,675 | £41,951 | £41,483 | £41,029 | £40,904 | £39,910 |
| 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 | £384 | £1,418 | £2,744 | £3,087 | £2,925 | £3,532 | £3,184 | £3,329 | £3,326 | £2,974 | £3,667 | £2,966 |
| 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 | £384 | £1,418 | £2,744 | £3,087 | £2,925 | £3,532 | £3,184 | £3,329 | £3,326 | £2,974 | £3,667 | £2,966 |
| Long-term Liabilities | £32,400 | £32,400 | £32,400 | £32,400 | £32,400 | £32,400 | £32,400 | £32,400 | £32,400 | £31,800 | £31,200 | £30,600 | £29,800 |
| Total Liabilities | £32,400 | £32,784 | £33,818 | £35,144 | £35,487 | £35,325 | £35,932 | £35,584 | £35,729 | £35,126 | £34,174 | £34,267 | £32,766 |
| Paid-in Capital | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 | £10,450 |
| Retained Earnings | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) | (£6,550) |
| Earnings | £0 | £296 | £30 | (£109) | £148 | £489 | £1,160 | £2,191 | £2,322 | £2,457 | £2,955 | £2,737 | £3,244 |
| Total Capital | £3,900 | £4,196 | £3,930 | £3,791 | £4,048 | £4,389 | £5,060 | £6,091 | £6,222 | £6,357 | £6,855 | £6,637 | £7,144 |
| Total Liabilities and Capital | £36,300 | £36,980 | £37,747 | £38,935 | £39,534 | £39,714 | £40,992 | £41,675 | £41,951 | £41,483 | £41,029 | £40,904 | £39,910 |
| Net Worth | £3,900 | £4,196 | £3,930 | £3,791 | £4,048 | £4,389 | £5,060 | £6,091 | £6,222 | £6,357 | £6,855 | £6,637 | £7,144 |