Houses on the Lake
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 |