| 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 | |||||||||||||
| Journeys | 0% | £0 | £0 | £0 | £0 | £0 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £30,000 | £30,000 |
| Services | 0% | £0 | £0 | £0 | £0 | £0 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £20,000 | £20,000 |
| Total Sales | £0 | £0 | £0 | £0 | £0 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £50,000 | £50,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 | |
| Journeys | £0 | £0 | £0 | £0 | £0 | £0 | £39,000 | £39,000 | £39,000 | £39,000 | £23,400 | £23,400 | |
| Services | £0 | £0 | £0 | £0 | £0 | £0 | £27,000 | £27,000 | £27,000 | £27,000 | £18,000 | £18,000 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £66,000 | £66,000 | £66,000 | £66,000 | £41,400 | £41,400 | |
| 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 | ||
| President and Development Dir. * | 0% | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Marketing & Advertising Dir. * | 0% | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Office Manager * | 0% | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Accounting | 0% | £0 | £0 | £0 | £0 | £0 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Travel Dir. * | 0% | £0 | £0 | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Travel Agent | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Sales Reps. | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Tour Guides | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Additional Office Support | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 10 | 10 | 10 | 10 | 12 | 14 | 14 | 14 | 12 | 10 | 10 | 10 | |
| Total Payroll | £0 | £0 | £0 | £0 | £0 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | |
| 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% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £0 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £50,000 | £50,000 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £66,000 | £66,000 | £66,000 | £66,000 | £41,400 | £41,400 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £66,000 | £66,000 | £66,000 | £66,000 | £41,400 | £41,400 | |
| Gross Margin | £0 | £0 | £0 | £0 | £0 | £80,000 | £14,000 | £14,000 | £14,000 | £14,000 | £8,600 | £8,600 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 100.00% | 17.50% | 17.50% | 17.50% | 17.50% | 17.20% | 17.20% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £0 | £0 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £2,100 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Payroll Taxes | 5% | £0 | £0 | £0 | £0 | £0 | £375 | £375 | £375 | £375 | £375 | £375 | £375 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £0 | £0 | £0 | £0 | £0 | £10,500 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | |
| Profit Before Interest and Taxes | £0 | £0 | £0 | £0 | £0 | £69,500 | £4,000 | £4,000 | £4,000 | £4,000 | (£1,400) | (£1,400) | |
| EBITDA | £0 | £0 | £0 | £0 | £0 | £69,500 | £4,000 | £4,000 | £4,000 | £4,000 | (£1,400) | (£1,400) | |
| Interest Expense | £9 | £9 | £9 | £9 | £9 | £9 | £9 | £9 | £9 | £9 | £9 | £9 | |
| Taxes Incurred | (£3) | (£2) | (£2) | (£2) | (£2) | £17,373 | £998 | £998 | £998 | £998 | (£352) | (£352) | |
| Net Profit | (£6) | (£7) | (£7) | (£7) | (£7) | £52,118 | £2,993 | £2,993 | £2,993 | £2,993 | (£1,057) | (£1,057) | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 65.15% | 3.74% | 3.74% | 3.74% | 3.74% | -2.11% | -2.11% | |
| 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 | £0 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £50,000 | £50,000 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £0 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £50,000 | £50,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 | £0 | £0 | £0 | £0 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £50,000 | £50,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 | £0 | £0 | £0 | £0 | £0 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | |
| Bill Payments | £0 | £6 | £7 | £7 | £7 | £686 | £22,019 | £69,507 | £69,507 | £69,507 | £68,642 | £43,557 | |
| Subtotal Spent on Operations | £0 | £6 | £7 | £7 | £7 | £8,186 | £29,519 | £77,007 | £77,007 | £77,007 | £76,142 | £51,057 | |
| 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 | £0 | £0 | £0 | £0 | |
| 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 | £0 | £6 | £7 | £7 | £7 | £8,186 | £29,519 | £77,007 | £77,007 | £77,007 | £76,142 | £51,057 | |
| Net Cash Flow | (£0) | (£6) | (£7) | (£7) | (£7) | £71,814 | £50,481 | £2,993 | £2,993 | £2,993 | (£26,142) | (£1,057) | |
| Cash Balance | £100,000 | £99,993 | £99,986 | £99,980 | £99,973 | £171,787 | £222,267 | £225,260 | £228,254 | £231,247 | £205,105 | £204,048 | |
| 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 | £100,000 | £100,000 | £99,993 | £99,986 | £99,980 | £99,973 | £171,787 | £222,267 | £225,260 | £228,254 | £231,247 | £205,105 | £204,048 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £100,000 | £100,000 | £99,993 | £99,986 | £99,980 | £99,973 | £171,787 | £222,267 | £225,260 | £228,254 | £231,247 | £205,105 | £204,048 |
| 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 | £100,000 | £100,000 | £99,993 | £99,986 | £99,980 | £99,973 | £171,787 | £222,267 | £225,260 | £228,254 | £231,247 | £205,105 | £204,048 |
| 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 | £7 | £7 | £7 | £7 | £19,702 | £67,190 | £67,190 | £67,190 | £67,190 | £42,105 | £42,105 |
| Current Borrowing | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £1,100 | £1,106 | £1,107 | £1,107 | £1,107 | £1,107 | £20,802 | £68,290 | £68,290 | £68,290 | £68,290 | £43,205 | £43,205 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £1,100 | £1,106 | £1,107 | £1,107 | £1,107 | £1,107 | £20,802 | £68,290 | £68,290 | £68,290 | £68,290 | £43,205 | £43,205 |
| 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 | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) |
| Earnings | £0 | (£6) | (£13) | (£20) | (£27) | (£34) | £52,084 | £55,077 | £58,070 | £61,064 | £64,057 | £63,000 | £61,943 |
| Total Capital | £98,900 | £98,894 | £98,887 | £98,880 | £98,873 | £98,866 | £150,984 | £153,977 | £156,970 | £159,964 | £162,957 | £161,900 | £160,843 |
| Total Liabilities and Capital | £100,000 | £100,000 | £99,993 | £99,986 | £99,980 | £99,973 | £171,787 | £222,267 | £225,260 | £228,254 | £231,247 | £205,105 | £204,048 |
| Net Worth | £98,900 | £98,894 | £98,887 | £98,880 | £98,873 | £98,866 | £150,984 | £153,977 | £156,970 | £159,964 | £162,957 | £161,900 | £160,843 |
| 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 | |||||||||||||
| Journeys | 0% | £0 | £0 | £0 | £0 | £0 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £30,000 | £30,000 |
| Services | 0% | £0 | £0 | £0 | £0 | £0 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £20,000 | £20,000 |
| Total Sales | £0 | £0 | £0 | £0 | £0 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £50,000 | £50,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 | |
| Journeys | £0 | £0 | £0 | £0 | £0 | £0 | £39,000 | £39,000 | £39,000 | £39,000 | £23,400 | £23,400 | |
| Services | £0 | £0 | £0 | £0 | £0 | £0 | £27,000 | £27,000 | £27,000 | £27,000 | £18,000 | £18,000 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £66,000 | £66,000 | £66,000 | £66,000 | £41,400 | £41,400 | |
| 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 | ||
| President and Development Dir. * | 0% | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Marketing & Advertising Dir. * | 0% | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Office Manager * | 0% | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Accounting | 0% | £0 | £0 | £0 | £0 | £0 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Travel Dir. * | 0% | £0 | £0 | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Travel Agent | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Sales Reps. | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Tour Guides | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Additional Office Support | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 10 | 10 | 10 | 10 | 12 | 14 | 14 | 14 | 12 | 10 | 10 | 10 | |
| Total Payroll | £0 | £0 | £0 | £0 | £0 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | |
| 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% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £0 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £50,000 | £50,000 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £66,000 | £66,000 | £66,000 | £66,000 | £41,400 | £41,400 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £66,000 | £66,000 | £66,000 | £66,000 | £41,400 | £41,400 | |
| Gross Margin | £0 | £0 | £0 | £0 | £0 | £80,000 | £14,000 | £14,000 | £14,000 | £14,000 | £8,600 | £8,600 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 100.00% | 17.50% | 17.50% | 17.50% | 17.50% | 17.20% | 17.20% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £0 | £0 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £2,100 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Payroll Taxes | 5% | £0 | £0 | £0 | £0 | £0 | £375 | £375 | £375 | £375 | £375 | £375 | £375 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £0 | £0 | £0 | £0 | £0 | £10,500 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | |
| Profit Before Interest and Taxes | £0 | £0 | £0 | £0 | £0 | £69,500 | £4,000 | £4,000 | £4,000 | £4,000 | (£1,400) | (£1,400) | |
| EBITDA | £0 | £0 | £0 | £0 | £0 | £69,500 | £4,000 | £4,000 | £4,000 | £4,000 | (£1,400) | (£1,400) | |
| Interest Expense | £9 | £9 | £9 | £9 | £9 | £9 | £9 | £9 | £9 | £9 | £9 | £9 | |
| Taxes Incurred | (£3) | (£2) | (£2) | (£2) | (£2) | £17,373 | £998 | £998 | £998 | £998 | (£352) | (£352) | |
| Net Profit | (£6) | (£7) | (£7) | (£7) | (£7) | £52,118 | £2,993 | £2,993 | £2,993 | £2,993 | (£1,057) | (£1,057) | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 65.15% | 3.74% | 3.74% | 3.74% | 3.74% | -2.11% | -2.11% | |
| 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 | £0 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £50,000 | £50,000 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £0 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £50,000 | £50,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 | £0 | £0 | £0 | £0 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £50,000 | £50,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 | £0 | £0 | £0 | £0 | £0 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | |
| Bill Payments | £0 | £6 | £7 | £7 | £7 | £686 | £22,019 | £69,507 | £69,507 | £69,507 | £68,642 | £43,557 | |
| Subtotal Spent on Operations | £0 | £6 | £7 | £7 | £7 | £8,186 | £29,519 | £77,007 | £77,007 | £77,007 | £76,142 | £51,057 | |
| 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 | £0 | £0 | £0 | £0 | |
| 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 | £0 | £6 | £7 | £7 | £7 | £8,186 | £29,519 | £77,007 | £77,007 | £77,007 | £76,142 | £51,057 | |
| Net Cash Flow | (£0) | (£6) | (£7) | (£7) | (£7) | £71,814 | £50,481 | £2,993 | £2,993 | £2,993 | (£26,142) | (£1,057) | |
| Cash Balance | £100,000 | £99,993 | £99,986 | £99,980 | £99,973 | £171,787 | £222,267 | £225,260 | £228,254 | £231,247 | £205,105 | £204,048 | |
| 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 | £100,000 | £100,000 | £99,993 | £99,986 | £99,980 | £99,973 | £171,787 | £222,267 | £225,260 | £228,254 | £231,247 | £205,105 | £204,048 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £100,000 | £100,000 | £99,993 | £99,986 | £99,980 | £99,973 | £171,787 | £222,267 | £225,260 | £228,254 | £231,247 | £205,105 | £204,048 |
| 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 | £100,000 | £100,000 | £99,993 | £99,986 | £99,980 | £99,973 | £171,787 | £222,267 | £225,260 | £228,254 | £231,247 | £205,105 | £204,048 |
| 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 | £7 | £7 | £7 | £7 | £19,702 | £67,190 | £67,190 | £67,190 | £67,190 | £42,105 | £42,105 |
| Current Borrowing | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £1,100 | £1,106 | £1,107 | £1,107 | £1,107 | £1,107 | £20,802 | £68,290 | £68,290 | £68,290 | £68,290 | £43,205 | £43,205 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £1,100 | £1,106 | £1,107 | £1,107 | £1,107 | £1,107 | £20,802 | £68,290 | £68,290 | £68,290 | £68,290 | £43,205 | £43,205 |
| 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 | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) | (£1,100) |
| Earnings | £0 | (£6) | (£13) | (£20) | (£27) | (£34) | £52,084 | £55,077 | £58,070 | £61,064 | £64,057 | £63,000 | £61,943 |
| Total Capital | £98,900 | £98,894 | £98,887 | £98,880 | £98,873 | £98,866 | £150,984 | £153,977 | £156,970 | £159,964 | £162,957 | £161,900 | £160,843 |
| Total Liabilities and Capital | £100,000 | £100,000 | £99,993 | £99,986 | £99,980 | £99,973 | £171,787 | £222,267 | £225,260 | £228,254 | £231,247 | £205,105 | £204,048 |
| Net Worth | £98,900 | £98,894 | £98,887 | £98,880 | £98,873 | £98,866 | £150,984 | £153,977 | £156,970 | £159,964 | £162,957 | £161,900 | £160,843 |