| 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 | ||
| Unit Sales | |||||||||||||
| Large resorts | 0% | 0 | 1 | 1 | 2 | 2 | 2 | 5 | 5 | 5 | 6 | 6 | 6 |
| Smaller resorts | 0% | 3 | 3 | 5 | 8 | 8 | 8 | 8 | 8 | 8 | 10 | 10 | 10 |
| Other travel destinations | 0% | 3 | 3 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 8 | 8 | 8 |
| Total Unit Sales | 6 | 7 | 11 | 16 | 16 | 16 | 19 | 19 | 19 | 24 | 24 | 24 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Large resorts | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | |
| Smaller resorts | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | |
| Other travel destinations | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | |
| Sales | |||||||||||||
| Large resorts | £0 | £8,350 | £8,350 | £16,700 | £16,700 | £16,700 | £41,750 | £41,750 | £41,750 | £50,100 | £50,100 | £50,100 | |
| Smaller resorts | £9,000 | £9,000 | £15,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £30,000 | £30,000 | £30,000 | |
| Other travel destinations | £6,000 | £6,000 | £10,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £16,000 | £16,000 | £16,000 | |
| Total Sales | £15,000 | £23,350 | £33,350 | £52,700 | £52,700 | £52,700 | £77,750 | £77,750 | £77,750 | £96,100 | £96,100 | £96,100 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Large resorts | 0.00% | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 |
| Smaller resorts | 0.00% | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 |
| Other travel destinations | 0.00% | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 |
| Direct Cost of Sales | |||||||||||||
| Large resorts | £0 | £3,000 | £3,000 | £6,000 | £6,000 | £6,000 | £15,000 | £15,000 | £15,000 | £18,000 | £18,000 | £18,000 | |
| Smaller resorts | £4,500 | £4,500 | £7,500 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £15,000 | £15,000 | £15,000 | |
| Other travel destinations | £3,000 | £3,000 | £5,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £8,000 | £8,000 | £8,000 | |
| Subtotal Direct Cost of Sales | £7,500 | £10,500 | £15,500 | £24,000 | £24,000 | £24,000 | £33,000 | £33,000 | £33,000 | £41,000 | £41,000 | £41,000 | |
| 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 | ||
| Carolyn | 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 |
| Jerry | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Office assistant | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Bookkeeper | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £3,000 | £3,000 | £3,000 |
| Account manager | 0% | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Account manager | 0% | £1,500 | £1,500 | £1,500 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Account manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 |
| Production manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £1,250 | £1,250 | £1,250 | £3,000 | £3,000 | £3,000 |
| Production assistant | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 |
| Sales and marketing manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Sales and marketing assistant | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 |
| Total People | 4 | 4 | 4 | 5 | 5 | 5 | 8 | 8 | 8 | 11 | 11 | 11 | |
| Total Payroll | £6,000 | £6,000 | £6,000 | £8,000 | £8,000 | £8,000 | £14,250 | £14,250 | £14,250 | £22,000 | £22,000 | £22,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 | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.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 | £15,000 | £23,350 | £33,350 | £52,700 | £52,700 | £52,700 | £77,750 | £77,750 | £77,750 | £96,100 | £96,100 | £96,100 | |
| Direct Cost of Sales | £7,500 | £10,500 | £15,500 | £24,000 | £24,000 | £24,000 | £33,000 | £33,000 | £33,000 | £41,000 | £41,000 | £41,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £7,500 | £10,500 | £15,500 | £24,000 | £24,000 | £24,000 | £33,000 | £33,000 | £33,000 | £41,000 | £41,000 | £41,000 | |
| Gross Margin | £7,500 | £12,850 | £17,850 | £28,700 | £28,700 | £28,700 | £44,750 | £44,750 | £44,750 | £55,100 | £55,100 | £55,100 | |
| Gross Margin % | 50.00% | 55.03% | 53.52% | 54.46% | 54.46% | 54.46% | 57.56% | 57.56% | 57.56% | 57.34% | 57.34% | 57.34% | |
| Expenses | |||||||||||||
| Payroll | £6,000 | £6,000 | £6,000 | £8,000 | £8,000 | £8,000 | £14,250 | £14,250 | £14,250 | £22,000 | £22,000 | £22,000 | |
| Sales and Marketing and Other Expenses | £14,000 | £14,000 | £14,000 | £21,000 | £21,000 | £21,000 | £15,200 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | |
| 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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Rent | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Payroll Taxes | 15% | £900 | £900 | £900 | £1,200 | £1,200 | £1,200 | £2,138 | £2,138 | £2,138 | £3,300 | £3,300 | £3,300 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £23,550 | £23,550 | £23,550 | £32,850 | £32,850 | £32,850 | £34,738 | £45,538 | £45,538 | £54,450 | £54,450 | £54,450 | |
| Profit Before Interest and Taxes | (£16,050) | (£10,700) | (£5,700) | (£4,150) | (£4,150) | (£4,150) | £10,013 | (£788) | (£788) | £650 | £650 | £650 | |
| EBITDA | (£16,050) | (£10,700) | (£5,700) | (£4,150) | (£4,150) | (£4,150) | £10,013 | (£788) | (£788) | £650 | £650 | £650 | |
| Interest Expense | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£17,050) | (£11,700) | (£6,700) | (£5,150) | (£5,150) | (£5,150) | £9,013 | (£1,788) | (£1,788) | (£350) | (£350) | (£350) | |
| Net Profit/Sales | -113.67% | -50.11% | -20.09% | -9.77% | -9.77% | -9.77% | 11.59% | -2.30% | -2.30% | -0.36% | -0.36% | -0.36% | |
| 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 | £6,000 | £9,340 | £13,340 | £21,080 | £21,080 | £21,080 | £31,100 | £31,100 | £31,100 | £38,440 | £38,440 | £38,440 | |
| Cash from Receivables | £0 | £300 | £9,167 | £14,210 | £20,397 | £31,620 | £31,620 | £32,121 | £46,650 | £46,650 | £47,017 | £57,660 | |
| Subtotal Cash from Operations | £6,000 | £9,640 | £22,507 | £35,290 | £41,477 | £52,700 | £62,720 | £63,221 | £77,750 | £85,090 | £85,457 | £96,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 | £6,000 | £9,640 | £22,507 | £35,290 | £41,477 | £52,700 | £62,720 | £63,221 | £77,750 | £85,090 | £85,457 | £96,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 | £6,000 | £6,000 | £6,000 | £8,000 | £8,000 | £8,000 | £14,250 | £14,250 | £14,250 | £22,000 | £22,000 | £22,000 | |
| Bill Payments | £50,868 | £26,150 | £29,217 | £34,577 | £49,850 | £49,850 | £50,005 | £54,848 | £65,288 | £65,593 | £74,450 | £74,450 | |
| Subtotal Spent on Operations | £56,868 | £32,150 | £35,217 | £42,577 | £57,850 | £57,850 | £64,255 | £69,098 | £79,538 | £87,593 | £96,450 | £96,450 | |
| 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 | £56,868 | £32,150 | £35,217 | £42,577 | £57,850 | £57,850 | £64,255 | £69,098 | £79,538 | £87,593 | £96,450 | £96,450 | |
| Net Cash Flow | (£50,868) | (£22,510) | (£12,710) | (£7,287) | (£16,373) | (£5,150) | (£1,535) | (£5,877) | (£1,788) | (£2,503) | (£10,993) | (£350) | |
| Cash Balance | £316,632 | £294,122 | £281,412 | £274,125 | £257,752 | £252,602 | £251,068 | £245,191 | £243,404 | £240,901 | £229,908 | £229,558 | |
| 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 | £367,500 | £316,632 | £294,122 | £281,412 | £274,125 | £257,752 | £252,602 | £251,068 | £245,191 | £243,404 | £240,901 | £229,908 | £229,558 |
| Accounts Receivable | £0 | £9,000 | £22,710 | £33,553 | £50,963 | £62,186 | £62,186 | £77,216 | £91,745 | £91,745 | £102,755 | £113,398 | £113,398 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £367,500 | £325,632 | £316,832 | £314,965 | £325,088 | £319,938 | £314,788 | £328,284 | £336,936 | £335,149 | £343,656 | £343,306 | £342,956 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Total Assets | £387,500 | £345,632 | £336,832 | £334,965 | £345,088 | £339,938 | £334,788 | £348,284 | £356,936 | £355,149 | £363,656 | £363,306 | £362,956 |
| 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 | £50,000 | £25,182 | £28,082 | £32,915 | £48,188 | £48,188 | £48,188 | £52,671 | £63,111 | £63,111 | £71,968 | £71,968 | £71,968 |
| Current Borrowing | £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 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £150,000 | £125,182 | £128,082 | £132,915 | £148,188 | £148,188 | £148,188 | £152,671 | £163,111 | £163,111 | £171,968 | £171,968 | £171,968 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £150,000 | £125,182 | £128,082 | £132,915 | £148,188 | £148,188 | £148,188 | £152,671 | £163,111 | £163,111 | £171,968 | £171,968 | £171,968 |
| Paid-in Capital | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 |
| Retained Earnings | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) |
| Earnings | £0 | (£17,050) | (£28,750) | (£35,450) | (£40,600) | (£45,750) | (£50,900) | (£41,888) | (£43,675) | (£45,463) | (£45,813) | (£46,163) | (£46,513) |
| Total Capital | £237,500 | £220,450 | £208,750 | £202,050 | £196,900 | £191,750 | £186,600 | £195,613 | £193,825 | £192,038 | £191,688 | £191,338 | £190,988 |
| Total Liabilities and Capital | £387,500 | £345,632 | £336,832 | £334,965 | £345,088 | £339,938 | £334,788 | £348,284 | £356,936 | £355,149 | £363,656 | £363,306 | £362,956 |
| Net Worth | £237,500 | £220,450 | £208,750 | £202,050 | £196,900 | £191,750 | £186,600 | £195,613 | £193,825 | £192,038 | £191,688 | £191,338 | £190,988 |
| 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 | ||
| Unit Sales | |||||||||||||
| Large resorts | 0% | 0 | 1 | 1 | 2 | 2 | 2 | 5 | 5 | 5 | 6 | 6 | 6 |
| Smaller resorts | 0% | 3 | 3 | 5 | 8 | 8 | 8 | 8 | 8 | 8 | 10 | 10 | 10 |
| Other travel destinations | 0% | 3 | 3 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 8 | 8 | 8 |
| Total Unit Sales | 6 | 7 | 11 | 16 | 16 | 16 | 19 | 19 | 19 | 24 | 24 | 24 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Large resorts | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | £8,350.00 | |
| Smaller resorts | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | |
| Other travel destinations | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | |
| Sales | |||||||||||||
| Large resorts | £0 | £8,350 | £8,350 | £16,700 | £16,700 | £16,700 | £41,750 | £41,750 | £41,750 | £50,100 | £50,100 | £50,100 | |
| Smaller resorts | £9,000 | £9,000 | £15,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £30,000 | £30,000 | £30,000 | |
| Other travel destinations | £6,000 | £6,000 | £10,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £16,000 | £16,000 | £16,000 | |
| Total Sales | £15,000 | £23,350 | £33,350 | £52,700 | £52,700 | £52,700 | £77,750 | £77,750 | £77,750 | £96,100 | £96,100 | £96,100 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Large resorts | 0.00% | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 |
| Smaller resorts | 0.00% | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 |
| Other travel destinations | 0.00% | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 |
| Direct Cost of Sales | |||||||||||||
| Large resorts | £0 | £3,000 | £3,000 | £6,000 | £6,000 | £6,000 | £15,000 | £15,000 | £15,000 | £18,000 | £18,000 | £18,000 | |
| Smaller resorts | £4,500 | £4,500 | £7,500 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £15,000 | £15,000 | £15,000 | |
| Other travel destinations | £3,000 | £3,000 | £5,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £8,000 | £8,000 | £8,000 | |
| Subtotal Direct Cost of Sales | £7,500 | £10,500 | £15,500 | £24,000 | £24,000 | £24,000 | £33,000 | £33,000 | £33,000 | £41,000 | £41,000 | £41,000 | |
| 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 | ||
| Carolyn | 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 |
| Jerry | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Office assistant | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Bookkeeper | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £3,000 | £3,000 | £3,000 |
| Account manager | 0% | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Account manager | 0% | £1,500 | £1,500 | £1,500 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Account manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 |
| Production manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £1,250 | £1,250 | £1,250 | £3,000 | £3,000 | £3,000 |
| Production assistant | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 |
| Sales and marketing manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Sales and marketing assistant | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 |
| Total People | 4 | 4 | 4 | 5 | 5 | 5 | 8 | 8 | 8 | 11 | 11 | 11 | |
| Total Payroll | £6,000 | £6,000 | £6,000 | £8,000 | £8,000 | £8,000 | £14,250 | £14,250 | £14,250 | £22,000 | £22,000 | £22,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 | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.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 | £15,000 | £23,350 | £33,350 | £52,700 | £52,700 | £52,700 | £77,750 | £77,750 | £77,750 | £96,100 | £96,100 | £96,100 | |
| Direct Cost of Sales | £7,500 | £10,500 | £15,500 | £24,000 | £24,000 | £24,000 | £33,000 | £33,000 | £33,000 | £41,000 | £41,000 | £41,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £7,500 | £10,500 | £15,500 | £24,000 | £24,000 | £24,000 | £33,000 | £33,000 | £33,000 | £41,000 | £41,000 | £41,000 | |
| Gross Margin | £7,500 | £12,850 | £17,850 | £28,700 | £28,700 | £28,700 | £44,750 | £44,750 | £44,750 | £55,100 | £55,100 | £55,100 | |
| Gross Margin % | 50.00% | 55.03% | 53.52% | 54.46% | 54.46% | 54.46% | 57.56% | 57.56% | 57.56% | 57.34% | 57.34% | 57.34% | |
| Expenses | |||||||||||||
| Payroll | £6,000 | £6,000 | £6,000 | £8,000 | £8,000 | £8,000 | £14,250 | £14,250 | £14,250 | £22,000 | £22,000 | £22,000 | |
| Sales and Marketing and Other Expenses | £14,000 | £14,000 | £14,000 | £21,000 | £21,000 | £21,000 | £15,200 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | |
| 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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Rent | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Payroll Taxes | 15% | £900 | £900 | £900 | £1,200 | £1,200 | £1,200 | £2,138 | £2,138 | £2,138 | £3,300 | £3,300 | £3,300 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £23,550 | £23,550 | £23,550 | £32,850 | £32,850 | £32,850 | £34,738 | £45,538 | £45,538 | £54,450 | £54,450 | £54,450 | |
| Profit Before Interest and Taxes | (£16,050) | (£10,700) | (£5,700) | (£4,150) | (£4,150) | (£4,150) | £10,013 | (£788) | (£788) | £650 | £650 | £650 | |
| EBITDA | (£16,050) | (£10,700) | (£5,700) | (£4,150) | (£4,150) | (£4,150) | £10,013 | (£788) | (£788) | £650 | £650 | £650 | |
| Interest Expense | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£17,050) | (£11,700) | (£6,700) | (£5,150) | (£5,150) | (£5,150) | £9,013 | (£1,788) | (£1,788) | (£350) | (£350) | (£350) | |
| Net Profit/Sales | -113.67% | -50.11% | -20.09% | -9.77% | -9.77% | -9.77% | 11.59% | -2.30% | -2.30% | -0.36% | -0.36% | -0.36% | |
| 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 | £6,000 | £9,340 | £13,340 | £21,080 | £21,080 | £21,080 | £31,100 | £31,100 | £31,100 | £38,440 | £38,440 | £38,440 | |
| Cash from Receivables | £0 | £300 | £9,167 | £14,210 | £20,397 | £31,620 | £31,620 | £32,121 | £46,650 | £46,650 | £47,017 | £57,660 | |
| Subtotal Cash from Operations | £6,000 | £9,640 | £22,507 | £35,290 | £41,477 | £52,700 | £62,720 | £63,221 | £77,750 | £85,090 | £85,457 | £96,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 | £6,000 | £9,640 | £22,507 | £35,290 | £41,477 | £52,700 | £62,720 | £63,221 | £77,750 | £85,090 | £85,457 | £96,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 | £6,000 | £6,000 | £6,000 | £8,000 | £8,000 | £8,000 | £14,250 | £14,250 | £14,250 | £22,000 | £22,000 | £22,000 | |
| Bill Payments | £50,868 | £26,150 | £29,217 | £34,577 | £49,850 | £49,850 | £50,005 | £54,848 | £65,288 | £65,593 | £74,450 | £74,450 | |
| Subtotal Spent on Operations | £56,868 | £32,150 | £35,217 | £42,577 | £57,850 | £57,850 | £64,255 | £69,098 | £79,538 | £87,593 | £96,450 | £96,450 | |
| 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 | £56,868 | £32,150 | £35,217 | £42,577 | £57,850 | £57,850 | £64,255 | £69,098 | £79,538 | £87,593 | £96,450 | £96,450 | |
| Net Cash Flow | (£50,868) | (£22,510) | (£12,710) | (£7,287) | (£16,373) | (£5,150) | (£1,535) | (£5,877) | (£1,788) | (£2,503) | (£10,993) | (£350) | |
| Cash Balance | £316,632 | £294,122 | £281,412 | £274,125 | £257,752 | £252,602 | £251,068 | £245,191 | £243,404 | £240,901 | £229,908 | £229,558 | |
| 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 | £367,500 | £316,632 | £294,122 | £281,412 | £274,125 | £257,752 | £252,602 | £251,068 | £245,191 | £243,404 | £240,901 | £229,908 | £229,558 |
| Accounts Receivable | £0 | £9,000 | £22,710 | £33,553 | £50,963 | £62,186 | £62,186 | £77,216 | £91,745 | £91,745 | £102,755 | £113,398 | £113,398 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £367,500 | £325,632 | £316,832 | £314,965 | £325,088 | £319,938 | £314,788 | £328,284 | £336,936 | £335,149 | £343,656 | £343,306 | £342,956 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Total Assets | £387,500 | £345,632 | £336,832 | £334,965 | £345,088 | £339,938 | £334,788 | £348,284 | £356,936 | £355,149 | £363,656 | £363,306 | £362,956 |
| 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 | £50,000 | £25,182 | £28,082 | £32,915 | £48,188 | £48,188 | £48,188 | £52,671 | £63,111 | £63,111 | £71,968 | £71,968 | £71,968 |
| Current Borrowing | £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 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £150,000 | £125,182 | £128,082 | £132,915 | £148,188 | £148,188 | £148,188 | £152,671 | £163,111 | £163,111 | £171,968 | £171,968 | £171,968 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £150,000 | £125,182 | £128,082 | £132,915 | £148,188 | £148,188 | £148,188 | £152,671 | £163,111 | £163,111 | £171,968 | £171,968 | £171,968 |
| Paid-in Capital | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 |
| Retained Earnings | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) | (£62,500) |
| Earnings | £0 | (£17,050) | (£28,750) | (£35,450) | (£40,600) | (£45,750) | (£50,900) | (£41,888) | (£43,675) | (£45,463) | (£45,813) | (£46,163) | (£46,513) |
| Total Capital | £237,500 | £220,450 | £208,750 | £202,050 | £196,900 | £191,750 | £186,600 | £195,613 | £193,825 | £192,038 | £191,688 | £191,338 | £190,988 |
| Total Liabilities and Capital | £387,500 | £345,632 | £336,832 | £334,965 | £345,088 | £339,938 | £334,788 | £348,284 | £356,936 | £355,149 | £363,656 | £363,306 | £362,956 |
| Net Worth | £237,500 | £220,450 | £208,750 | £202,050 | £196,900 | £191,750 | £186,600 | £195,613 | £193,825 | £192,038 | £191,688 | £191,338 | £190,988 |