Houses on the Lake

Start your own business plan »

Houseboat Rental Business Plan

Appendix

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