| 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 | |||||||||||||
| Summer Rentals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 20 | 21 | 0 | |
| Spring/Fall Rentals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 0 | 0 | 0 | 15 | |
| Off Season Rentals | 6 | 6 | 5 | 5 | 7 | 8 | 10 | 0 | 0 | 0 | 0 | 0 | |
| Additional Fees/Services - Summer Rentals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 20 | 21 | 0 | |
| Additional Fees/Services - Spring/Fall Rentals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 0 | 0 | 0 | 15 | |
| Additional Fees/Services - Off Season Rentals | 6 | 6 | 5 | 5 | 7 | 8 | 10 | 0 | 0 | 0 | 0 | 0 | |
| Total Unit Sales | 12 | 12 | 10 | 10 | 14 | 16 | 20 | 30 | 38 | 40 | 42 | 30 | |
| 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 | |
| Summer Rentals | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | |
| Spring/Fall Rentals | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | |
| Off Season Rentals | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | |
| Additional Fees/Services - Summer Rentals | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | |
| Additional Fees/Services - Spring/Fall Rentals | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | |
| Additional Fees/Services - Off Season Rentals | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | |
| Sales | |||||||||||||
| Summer Rentals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £31,350 | £33,000 | £34,650 | £0 | |
| Spring/Fall Rentals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £21,000 | £0 | £0 | £0 | £21,000 | |
| Off Season Rentals | £6,600 | £6,600 | £5,500 | £5,500 | £7,700 | £8,800 | £11,000 | £0 | £0 | £0 | £0 | £0 | |
| Additional Fees/Services - Summer Rentals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £7,600 | £8,000 | £8,400 | £0 | |
| Additional Fees/Services - Spring/Fall Rentals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £4,500 | £0 | £0 | £0 | £4,500 | |
| Additional Fees/Services - Off Season Rentals | £1,200 | £1,200 | £1,000 | £1,000 | £1,400 | £1,600 | £2,000 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £7,800 | £7,800 | £6,500 | £6,500 | £9,100 | £10,400 | £13,000 | £25,500 | £38,950 | £41,000 | £43,050 | £25,500 | |
| 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 | |
| Summer Rentals | £100.00 | £562.00 | £562.00 | £562.00 | £562.00 | £562.00 | £562.00 | £562.00 | £562.00 | £562.00 | £562.00 | £562.00 | £562.00 |
| Spring/Fall Rentals | £100.00 | £492.00 | £492.00 | £492.00 | £492.00 | £492.00 | £492.00 | £492.00 | £492.00 | £492.00 | £492.00 | £492.00 | £492.00 |
| Off Season Rentals | £100.00 | £408.00 | £408.00 | £408.00 | £408.00 | £408.00 | £408.00 | £408.00 | £408.00 | £408.00 | £408.00 | £408.00 | £408.00 |
| Additional Fees/Services - Summer Rentals | 0.00% | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 |
| Additional Fees/Services - Spring/Fall Rentals | 0.00% | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 |
| Additional Fees/Services - Off Season Rentals | 0.00% | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 |
| Direct Cost of Sales | |||||||||||||
| Summer Rentals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £10,678 | £11,240 | £11,802 | £0 | |
| Spring/Fall Rentals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £7,380 | £0 | £0 | £0 | £7,380 | |
| Off Season Rentals | £2,448 | £2,448 | £2,040 | £2,040 | £2,856 | £3,264 | £4,080 | £0 | £0 | £0 | £0 | £0 | |
| Additional Fees/Services - Summer Rentals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,900 | £2,000 | £2,100 | £0 | |
| Additional Fees/Services - Spring/Fall Rentals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,125 | £0 | £0 | £0 | £1,125 | |
| Additional Fees/Services - Off Season Rentals | £300 | £300 | £250 | £250 | £350 | £400 | £500 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £2,748 | £2,748 | £2,290 | £2,290 | £3,206 | £3,664 | £4,580 | £8,505 | £12,578 | £13,240 | £13,902 | £8,505 | |
| 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 | ||
| Robert Hopkins | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Boat Assistants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
| Total Payroll | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| 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 | £7,800 | £7,800 | £6,500 | £6,500 | £9,100 | £10,400 | £13,000 | £25,500 | £38,950 | £41,000 | £43,050 | £25,500 | |
| Direct Cost of Sales | £2,748 | £2,748 | £2,290 | £2,290 | £3,206 | £3,664 | £4,580 | £8,505 | £12,578 | £13,240 | £13,902 | £8,505 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,748 | £2,748 | £2,290 | £2,290 | £3,206 | £3,664 | £4,580 | £8,505 | £12,578 | £13,240 | £13,902 | £8,505 | |
| Gross Margin | £5,052 | £5,052 | £4,210 | £4,210 | £5,894 | £6,736 | £8,420 | £16,995 | £26,372 | £27,760 | £29,148 | £16,995 | |
| Gross Margin % | 64.77% | 64.77% | 64.77% | 64.77% | 64.77% | 64.77% | 64.77% | 66.65% | 67.71% | 67.71% | 67.71% | 66.65% | |
| Expenses | |||||||||||||
| Payroll | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Marketing/Promotion | £1,000 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | |
| Website Marketing | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Utilities | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £10,000 | £0 | £0 | |
| Payroll Burden | 25% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| Office/Boat Maintenance/Supplies | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Operating Expenses | £12,017 | £11,517 | £11,517 | £11,517 | £11,517 | £11,517 | £11,517 | £11,517 | £11,517 | £21,517 | £11,517 | £11,517 | |
| Profit Before Interest and Taxes | (£6,965) | (£6,465) | (£7,307) | (£7,307) | (£5,623) | (£4,781) | (£3,097) | £5,478 | £14,855 | £6,243 | £17,631 | £5,478 | |
| EBITDA | (£6,548) | (£6,048) | (£6,890) | (£6,890) | (£5,206) | (£4,364) | (£2,680) | £5,895 | £15,272 | £6,660 | £18,048 | £5,895 | |
| Interest Expense | £611 | £597 | £571 | £544 | £518 | £492 | £465 | £439 | £413 | £386 | £360 | £333 | |
| Taxes Incurred | (£2,273) | (£2,119) | (£2,363) | (£2,355) | (£1,842) | (£1,582) | (£1,069) | £1,512 | £4,333 | £1,757 | £5,181 | £1,543 | |
| Net Profit | (£5,303) | (£4,943) | (£5,514) | (£5,496) | (£4,299) | (£3,691) | (£2,493) | £3,528 | £10,110 | £4,100 | £12,090 | £3,601 | |
| Net Profit/Sales | -67.99% | -63.38% | -84.83% | -84.55% | -47.24% | -35.49% | -19.18% | 13.83% | 25.96% | 10.00% | 28.08% | 14.12% | |
| 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 | £7,800 | £7,800 | £6,500 | £6,500 | £9,100 | £10,400 | £13,000 | £25,500 | £38,950 | £41,000 | £43,050 | £25,500 | |
| Subtotal Cash from Operations | £7,800 | £7,800 | £6,500 | £6,500 | £9,100 | £10,400 | £13,000 | £25,500 | £38,950 | £41,000 | £43,050 | £25,500 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 10.00% | £780 | £780 | £650 | £650 | £910 | £1,040 | £1,300 | £2,550 | £3,895 | £4,100 | £4,305 | £2,550 |
| 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 | £8,580 | £8,580 | £7,150 | £7,150 | £10,010 | £11,440 | £14,300 | £28,050 | £42,845 | £45,100 | £47,355 | £28,050 | |
| 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 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Bill Payments | £256 | £7,674 | £7,302 | £6,597 | £6,626 | £8,005 | £8,721 | £10,293 | £16,785 | £23,692 | £31,285 | £25,241 | |
| Subtotal Spent on Operations | £5,256 | £12,674 | £12,302 | £11,597 | £11,626 | £13,005 | £13,721 | £15,293 | £21,785 | £28,692 | £36,285 | £30,241 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £780 | £780 | £650 | £650 | £910 | £1,040 | £1,300 | £2,550 | £3,895 | £4,100 | £4,305 | £2,550 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | |
| 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 | £7,703 | £15,121 | £15,619 | £14,914 | £15,203 | £16,712 | £17,687 | £20,509 | £28,346 | £35,459 | £43,257 | £35,458 | |
| Net Cash Flow | £877 | (£6,541) | (£8,469) | (£7,764) | (£5,193) | (£5,272) | (£3,387) | £7,541 | £14,499 | £9,641 | £4,098 | (£7,408) | |
| Cash Balance | £69,877 | £63,336 | £54,867 | £47,103 | £41,911 | £36,639 | £33,252 | £40,793 | £55,291 | £64,933 | £69,031 | £61,623 | |
| 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 | £69,000 | £69,877 | £63,336 | £54,867 | £47,103 | £41,911 | £36,639 | £33,252 | £40,793 | £55,291 | £64,933 | £69,031 | £61,623 |
| Other Current Assets | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Total Current Assets | £75,000 | £75,877 | £69,336 | £60,867 | £53,103 | £47,911 | £42,639 | £39,252 | £46,793 | £61,291 | £70,933 | £75,031 | £67,623 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Accumulated Depreciation | £0 | £417 | £833 | £1,250 | £1,667 | £2,083 | £2,500 | £2,917 | £3,333 | £3,750 | £4,167 | £4,583 | £5,000 |
| Total Long-term Assets | £30,000 | £29,583 | £29,167 | £28,750 | £28,333 | £27,917 | £27,500 | £27,083 | £26,667 | £26,250 | £25,833 | £25,417 | £25,000 |
| Total Assets | £105,000 | £105,460 | £98,503 | £89,617 | £81,437 | £75,828 | £70,139 | £66,335 | £73,459 | £87,541 | £96,766 | £100,447 | £92,623 |
| 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 | £7,430 | £7,082 | £6,378 | £6,360 | £7,716 | £8,385 | £9,741 | £16,004 | £22,643 | £30,434 | £24,692 | £15,932 |
| Current Borrowing | £10,000 | £10,000 | £10,000 | £9,000 | £8,000 | £7,000 | £6,000 | £5,000 | £4,000 | £3,000 | £2,000 | £1,000 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £10,000 | £17,430 | £17,082 | £15,378 | £14,360 | £14,716 | £14,385 | £14,741 | £20,004 | £25,643 | £32,434 | £25,692 | £15,932 |
| Long-term Liabilities | £60,000 | £58,333 | £56,667 | £55,000 | £53,333 | £51,667 | £50,000 | £48,333 | £46,667 | £45,000 | £43,333 | £41,667 | £40,000 |
| Total Liabilities | £70,000 | £75,763 | £73,749 | £70,378 | £67,693 | £66,382 | £64,385 | £63,074 | £66,671 | £70,643 | £75,767 | £67,358 | £55,932 |
| Paid-in Capital | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 |
| Retained Earnings | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) |
| Earnings | £0 | (£5,303) | (£10,246) | (£15,761) | (£21,256) | (£25,555) | (£29,246) | (£31,739) | (£28,211) | (£18,101) | (£14,001) | (£1,911) | £1,690 |
| Total Capital | £35,000 | £29,697 | £24,754 | £19,239 | £13,744 | £9,445 | £5,754 | £3,261 | £6,789 | £16,899 | £20,999 | £33,089 | £36,690 |
| Total Liabilities and Capital | £105,000 | £105,460 | £98,503 | £89,617 | £81,437 | £75,828 | £70,139 | £66,335 | £73,459 | £87,541 | £96,766 | £100,447 | £92,623 |
| Net Worth | £35,000 | £29,697 | £24,754 | £19,239 | £13,744 | £9,445 | £5,754 | £3,261 | £6,789 | £16,899 | £20,999 | £33,089 | £36,690 |
| 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 | |||||||||||||
| Summer Rentals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 20 | 21 | 0 | |
| Spring/Fall Rentals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 0 | 0 | 0 | 15 | |
| Off Season Rentals | 6 | 6 | 5 | 5 | 7 | 8 | 10 | 0 | 0 | 0 | 0 | 0 | |
| Additional Fees/Services - Summer Rentals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 20 | 21 | 0 | |
| Additional Fees/Services - Spring/Fall Rentals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 0 | 0 | 0 | 15 | |
| Additional Fees/Services - Off Season Rentals | 6 | 6 | 5 | 5 | 7 | 8 | 10 | 0 | 0 | 0 | 0 | 0 | |
| Total Unit Sales | 12 | 12 | 10 | 10 | 14 | 16 | 20 | 30 | 38 | 40 | 42 | 30 | |
| 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 | |
| Summer Rentals | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | £1,650.00 | |
| Spring/Fall Rentals | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | £1,400.00 | |
| Off Season Rentals | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | £1,100.00 | |
| Additional Fees/Services - Summer Rentals | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | |
| Additional Fees/Services - Spring/Fall Rentals | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | |
| Additional Fees/Services - Off Season Rentals | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | |
| Sales | |||||||||||||
| Summer Rentals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £31,350 | £33,000 | £34,650 | £0 | |
| Spring/Fall Rentals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £21,000 | £0 | £0 | £0 | £21,000 | |
| Off Season Rentals | £6,600 | £6,600 | £5,500 | £5,500 | £7,700 | £8,800 | £11,000 | £0 | £0 | £0 | £0 | £0 | |
| Additional Fees/Services - Summer Rentals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £7,600 | £8,000 | £8,400 | £0 | |
| Additional Fees/Services - Spring/Fall Rentals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £4,500 | £0 | £0 | £0 | £4,500 | |
| Additional Fees/Services - Off Season Rentals | £1,200 | £1,200 | £1,000 | £1,000 | £1,400 | £1,600 | £2,000 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £7,800 | £7,800 | £6,500 | £6,500 | £9,100 | £10,400 | £13,000 | £25,500 | £38,950 | £41,000 | £43,050 | £25,500 | |
| 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 | |
| Summer Rentals | £100.00 | £562.00 | £562.00 | £562.00 | £562.00 | £562.00 | £562.00 | £562.00 | £562.00 | £562.00 | £562.00 | £562.00 | £562.00 |
| Spring/Fall Rentals | £100.00 | £492.00 | £492.00 | £492.00 | £492.00 | £492.00 | £492.00 | £492.00 | £492.00 | £492.00 | £492.00 | £492.00 | £492.00 |
| Off Season Rentals | £100.00 | £408.00 | £408.00 | £408.00 | £408.00 | £408.00 | £408.00 | £408.00 | £408.00 | £408.00 | £408.00 | £408.00 | £408.00 |
| Additional Fees/Services - Summer Rentals | 0.00% | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 |
| Additional Fees/Services - Spring/Fall Rentals | 0.00% | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 |
| Additional Fees/Services - Off Season Rentals | 0.00% | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 |
| Direct Cost of Sales | |||||||||||||
| Summer Rentals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £10,678 | £11,240 | £11,802 | £0 | |
| Spring/Fall Rentals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £7,380 | £0 | £0 | £0 | £7,380 | |
| Off Season Rentals | £2,448 | £2,448 | £2,040 | £2,040 | £2,856 | £3,264 | £4,080 | £0 | £0 | £0 | £0 | £0 | |
| Additional Fees/Services - Summer Rentals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,900 | £2,000 | £2,100 | £0 | |
| Additional Fees/Services - Spring/Fall Rentals | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,125 | £0 | £0 | £0 | £1,125 | |
| Additional Fees/Services - Off Season Rentals | £300 | £300 | £250 | £250 | £350 | £400 | £500 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £2,748 | £2,748 | £2,290 | £2,290 | £3,206 | £3,664 | £4,580 | £8,505 | £12,578 | £13,240 | £13,902 | £8,505 | |
| 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 | ||
| Robert Hopkins | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Boat Assistants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
| Total Payroll | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| 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 | £7,800 | £7,800 | £6,500 | £6,500 | £9,100 | £10,400 | £13,000 | £25,500 | £38,950 | £41,000 | £43,050 | £25,500 | |
| Direct Cost of Sales | £2,748 | £2,748 | £2,290 | £2,290 | £3,206 | £3,664 | £4,580 | £8,505 | £12,578 | £13,240 | £13,902 | £8,505 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,748 | £2,748 | £2,290 | £2,290 | £3,206 | £3,664 | £4,580 | £8,505 | £12,578 | £13,240 | £13,902 | £8,505 | |
| Gross Margin | £5,052 | £5,052 | £4,210 | £4,210 | £5,894 | £6,736 | £8,420 | £16,995 | £26,372 | £27,760 | £29,148 | £16,995 | |
| Gross Margin % | 64.77% | 64.77% | 64.77% | 64.77% | 64.77% | 64.77% | 64.77% | 66.65% | 67.71% | 67.71% | 67.71% | 66.65% | |
| Expenses | |||||||||||||
| Payroll | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Marketing/Promotion | £1,000 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | |
| Website Marketing | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Utilities | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £10,000 | £0 | £0 | |
| Payroll Burden | 25% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| Office/Boat Maintenance/Supplies | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Operating Expenses | £12,017 | £11,517 | £11,517 | £11,517 | £11,517 | £11,517 | £11,517 | £11,517 | £11,517 | £21,517 | £11,517 | £11,517 | |
| Profit Before Interest and Taxes | (£6,965) | (£6,465) | (£7,307) | (£7,307) | (£5,623) | (£4,781) | (£3,097) | £5,478 | £14,855 | £6,243 | £17,631 | £5,478 | |
| EBITDA | (£6,548) | (£6,048) | (£6,890) | (£6,890) | (£5,206) | (£4,364) | (£2,680) | £5,895 | £15,272 | £6,660 | £18,048 | £5,895 | |
| Interest Expense | £611 | £597 | £571 | £544 | £518 | £492 | £465 | £439 | £413 | £386 | £360 | £333 | |
| Taxes Incurred | (£2,273) | (£2,119) | (£2,363) | (£2,355) | (£1,842) | (£1,582) | (£1,069) | £1,512 | £4,333 | £1,757 | £5,181 | £1,543 | |
| Net Profit | (£5,303) | (£4,943) | (£5,514) | (£5,496) | (£4,299) | (£3,691) | (£2,493) | £3,528 | £10,110 | £4,100 | £12,090 | £3,601 | |
| Net Profit/Sales | -67.99% | -63.38% | -84.83% | -84.55% | -47.24% | -35.49% | -19.18% | 13.83% | 25.96% | 10.00% | 28.08% | 14.12% | |
| 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 | £7,800 | £7,800 | £6,500 | £6,500 | £9,100 | £10,400 | £13,000 | £25,500 | £38,950 | £41,000 | £43,050 | £25,500 | |
| Subtotal Cash from Operations | £7,800 | £7,800 | £6,500 | £6,500 | £9,100 | £10,400 | £13,000 | £25,500 | £38,950 | £41,000 | £43,050 | £25,500 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 10.00% | £780 | £780 | £650 | £650 | £910 | £1,040 | £1,300 | £2,550 | £3,895 | £4,100 | £4,305 | £2,550 |
| 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 | £8,580 | £8,580 | £7,150 | £7,150 | £10,010 | £11,440 | £14,300 | £28,050 | £42,845 | £45,100 | £47,355 | £28,050 | |
| 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 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Bill Payments | £256 | £7,674 | £7,302 | £6,597 | £6,626 | £8,005 | £8,721 | £10,293 | £16,785 | £23,692 | £31,285 | £25,241 | |
| Subtotal Spent on Operations | £5,256 | £12,674 | £12,302 | £11,597 | £11,626 | £13,005 | £13,721 | £15,293 | £21,785 | £28,692 | £36,285 | £30,241 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £780 | £780 | £650 | £650 | £910 | £1,040 | £1,300 | £2,550 | £3,895 | £4,100 | £4,305 | £2,550 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | |
| 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 | £7,703 | £15,121 | £15,619 | £14,914 | £15,203 | £16,712 | £17,687 | £20,509 | £28,346 | £35,459 | £43,257 | £35,458 | |
| Net Cash Flow | £877 | (£6,541) | (£8,469) | (£7,764) | (£5,193) | (£5,272) | (£3,387) | £7,541 | £14,499 | £9,641 | £4,098 | (£7,408) | |
| Cash Balance | £69,877 | £63,336 | £54,867 | £47,103 | £41,911 | £36,639 | £33,252 | £40,793 | £55,291 | £64,933 | £69,031 | £61,623 | |
| 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 | £69,000 | £69,877 | £63,336 | £54,867 | £47,103 | £41,911 | £36,639 | £33,252 | £40,793 | £55,291 | £64,933 | £69,031 | £61,623 |
| Other Current Assets | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Total Current Assets | £75,000 | £75,877 | £69,336 | £60,867 | £53,103 | £47,911 | £42,639 | £39,252 | £46,793 | £61,291 | £70,933 | £75,031 | £67,623 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Accumulated Depreciation | £0 | £417 | £833 | £1,250 | £1,667 | £2,083 | £2,500 | £2,917 | £3,333 | £3,750 | £4,167 | £4,583 | £5,000 |
| Total Long-term Assets | £30,000 | £29,583 | £29,167 | £28,750 | £28,333 | £27,917 | £27,500 | £27,083 | £26,667 | £26,250 | £25,833 | £25,417 | £25,000 |
| Total Assets | £105,000 | £105,460 | £98,503 | £89,617 | £81,437 | £75,828 | £70,139 | £66,335 | £73,459 | £87,541 | £96,766 | £100,447 | £92,623 |
| 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 | £7,430 | £7,082 | £6,378 | £6,360 | £7,716 | £8,385 | £9,741 | £16,004 | £22,643 | £30,434 | £24,692 | £15,932 |
| Current Borrowing | £10,000 | £10,000 | £10,000 | £9,000 | £8,000 | £7,000 | £6,000 | £5,000 | £4,000 | £3,000 | £2,000 | £1,000 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £10,000 | £17,430 | £17,082 | £15,378 | £14,360 | £14,716 | £14,385 | £14,741 | £20,004 | £25,643 | £32,434 | £25,692 | £15,932 |
| Long-term Liabilities | £60,000 | £58,333 | £56,667 | £55,000 | £53,333 | £51,667 | £50,000 | £48,333 | £46,667 | £45,000 | £43,333 | £41,667 | £40,000 |
| Total Liabilities | £70,000 | £75,763 | £73,749 | £70,378 | £67,693 | £66,382 | £64,385 | £63,074 | £66,671 | £70,643 | £75,767 | £67,358 | £55,932 |
| Paid-in Capital | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 |
| Retained Earnings | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) | (£45,000) |
| Earnings | £0 | (£5,303) | (£10,246) | (£15,761) | (£21,256) | (£25,555) | (£29,246) | (£31,739) | (£28,211) | (£18,101) | (£14,001) | (£1,911) | £1,690 |
| Total Capital | £35,000 | £29,697 | £24,754 | £19,239 | £13,744 | £9,445 | £5,754 | £3,261 | £6,789 | £16,899 | £20,999 | £33,089 | £36,690 |
| Total Liabilities and Capital | £105,000 | £105,460 | £98,503 | £89,617 | £81,437 | £75,828 | £70,139 | £66,335 | £73,459 | £87,541 | £96,766 | £100,447 | £92,623 |
| Net Worth | £35,000 | £29,697 | £24,754 | £19,239 | £13,744 | £9,445 | £5,754 | £3,261 | £6,789 | £16,899 | £20,999 | £33,089 | £36,690 |