Lowland Heights Roadhouse

Start your own business plan »

Motel - Hunting Lodge 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
Sales
Rooms 0% $2,042 $3,354 $4,682 $16,500 $8,250 $3,245 $2,565 $2,650 $2,650 $3,850 $4,200 $4,850
Food 0% $278 $838 $1,540 $5,350 $4,950 $2,850 $2,850 $2,850 $3,150 $3,250 $3,250 $5,400
RV Park 0% $163 $142 $492 $3,250 $2,250 $1,675 $850 $500 $300 $175 $100 $250
Bar 0% $3,501 $2,849 $2,808 $6,250 $5,245 $3,450 $3,400 $3,400 $3,400 $3,400 $3,400 $4,750
Total Sales $5,984 $7,183 $9,522 $31,350 $20,695 $11,220 $9,665 $9,400 $9,500 $10,675 $10,950 $15,250
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
Rooms $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25
Food $75 $65 $125 $1,050 $900 $625 $625 $625 $675 $675 $675 $750
RV Park $15 $15 $15 $15 $15 $15 $15 $15 $15 $15 $15 $15
Bar $1,250 $150 $175 $476 $375 $200 $200 $200 $200 $200 $200 $300
Subtotal Direct Cost of Sales $1,365 $255 $340 $1,566 $1,315 $865 $865 $865 $915 $915 $915 $1,090
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
Manager 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Assistant Manager 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cook 0% $0 $0 $0 $0 $0 $0 $0 $0 $300 $300 $300 $300
Maintenance Staff 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cleaning Staff 0% $0 $0 $0 $0 $0 $0 $0 $0 $300 $300 $300 $300
Total People 2 2 2 2 2 2 2 2 5 5 50 5
Total Payroll $0 $0 $0 $0 $0 $0 $0 $0 $600 $600 $600 $600
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 $5,984 $7,183 $9,522 $31,350 $20,695 $11,220 $9,665 $9,400 $9,500 $10,675 $10,950 $15,250
Direct Cost of Sales $1,365 $255 $340 $1,566 $1,315 $865 $865 $865 $915 $915 $915 $1,090
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $1,365 $255 $340 $1,566 $1,315 $865 $865 $865 $915 $915 $915 $1,090
Gross Margin $4,619 $6,928 $9,182 $29,784 $19,380 $10,355 $8,800 $8,535 $8,585 $9,760 $10,035 $14,160
Gross Margin % 77.19% 96.45% 96.43% 95.00% 93.65% 92.29% 91.05% 90.80% 90.37% 91.43% 91.64% 92.85%
Expenses
Payroll $0 $0 $0 $0 $0 $0 $0 $0 $600 $600 $600 $600
Sales and Marketing and Other Expenses $0 $0 $0 $210 $85 $100 $100 $100 $125 $145 $145 $150
Depreciation $1,190 $1,190 $1,190 $1,190 $1,190 $1,190 $1,190 $1,190 $1,190 $1,190 $1,190 $1,190
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $187 $168 $410 $260 $250 $350 $350 $350 $350 $350 $350 $350
Insurance $225 $225 $225 $225 $225 $225 $225 $225 $225 $225 $225 $225
Lease $1,300 $1,500 $1,500 $1,500 $1,500 $0 $0 $0 $0 $0 $0 $0
Mortgage Payment 15% $0 $0 $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $2,902 $3,083 $3,325 $3,385 $3,250 $3,865 $3,865 $3,865 $4,490 $4,510 $4,510 $4,515
Profit Before Interest and Taxes $1,717 $3,845 $5,857 $26,399 $16,130 $6,490 $4,935 $4,670 $4,095 $5,250 $5,525 $9,645
EBITDA $2,907 $5,035 $7,047 $27,589 $17,320 $7,680 $6,125 $5,860 $5,285 $6,440 $6,715 $10,835
Interest Expense $1,933 $1,933 $1,933 $1,933 $1,933 $1,933 $1,917 $1,900 $1,883 $1,867 $1,850 $1,833
Taxes Incurred ($65) $574 $1,177 $7,340 $4,259 $1,367 $905 $831 $664 $1,015 $1,103 $2,344
Net Profit ($152) $1,338 $2,746 $17,126 $9,938 $3,190 $2,113 $1,939 $1,548 $2,368 $2,573 $5,468
Net Profit/Sales -2.53% 18.63% 28.84% 54.63% 48.02% 28.43% 21.86% 20.63% 16.30% 22.19% 23.49% 35.86%
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 $5,984 $7,183 $9,522 $31,350 $20,695 $11,220 $9,665 $9,400 $9,500 $10,675 $10,950 $15,250
Subtotal Cash from Operations $5,984 $7,183 $9,522 $31,350 $20,695 $11,220 $9,665 $9,400 $9,500 $10,675 $10,950 $15,250
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 $5,984 $7,183 $9,522 $31,350 $20,695 $11,220 $9,665 $9,400 $9,500 $10,675 $10,950 $15,250
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 $0 $0 $0 $600 $600 $600 $600
Bill Payments $1,262 $6,379 $4,428 $5,532 $13,698 $9,214 $6,959 $6,494 $6,401 $6,225 $5,637 $6,720
Subtotal Spent on Operations $1,262 $6,379 $4,428 $5,532 $13,698 $9,214 $6,959 $6,494 $7,001 $6,825 $6,237 $7,320
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 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
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 $1,262 $6,379 $4,428 $5,532 $13,698 $9,214 $8,959 $8,494 $9,001 $8,825 $8,237 $9,320
Net Cash Flow $4,722 $805 $5,093 $25,818 $6,997 $2,006 $706 $906 $499 $1,850 $2,713 $5,930
Cash Balance $228,304 $229,109 $234,203 $260,020 $267,017 $269,023 $269,729 $270,635 $271,134 $272,984 $275,696 $281,627
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 $223,582 $228,304 $229,109 $234,203 $260,020 $267,017 $269,023 $269,729 $270,635 $271,134 $272,984 $275,696 $281,627
Inventory $0 $1,502 $1,247 $907 $1,723 $1,447 $1,582 $1,717 $1,852 $1,937 $1,022 $1,107 $1,199
Other Current Assets $9,827 $9,827 $9,827 $9,827 $9,827 $9,827 $9,827 $9,827 $9,827 $9,827 $9,827 $9,827 $9,827
Total Current Assets $233,409 $239,633 $240,183 $244,936 $271,570 $278,291 $280,432 $281,272 $282,313 $282,897 $283,832 $286,630 $292,653
Long-term Assets
Long-term Assets $15,206 $15,206 $15,206 $15,206 $15,206 $15,206 $15,206 $15,206 $15,206 $15,206 $15,206 $15,206 $15,206
Accumulated Depreciation $0 $1,190 $2,380 $3,570 $4,760 $5,950 $7,140 $8,330 $9,520 $10,710 $11,900 $13,090 $14,280
Total Long-term Assets $15,206 $14,016 $12,826 $11,636 $10,446 $9,256 $8,066 $6,876 $5,686 $4,496 $3,306 $2,116 $926
Total Assets $248,616 $253,649 $253,009 $256,572 $282,016 $287,547 $288,498 $288,149 $288,000 $287,394 $287,139 $288,746 $293,579
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 $1,047 $6,232 $4,253 $5,070 $13,388 $8,982 $6,743 $6,281 $6,192 $6,039 $5,415 $6,450 $7,815
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $744 $744 $744 $744 $744 $744 $744 $744 $744 $744 $744 $744 $744
Subtotal Current Liabilities $1,791 $6,976 $4,997 $5,814 $14,132 $9,725 $7,487 $7,024 $6,936 $6,782 $6,159 $7,194 $8,559
Long-term Liabilities $232,000 $232,000 $232,000 $232,000 $232,000 $232,000 $232,000 $230,000 $228,000 $226,000 $224,000 $222,000 $220,000
Total Liabilities $233,791 $238,976 $236,997 $237,814 $246,132 $241,725 $239,487 $237,024 $234,936 $232,782 $230,159 $229,194 $228,559
Paid-in Capital $78,000 $78,000 $78,000 $78,000 $78,000 $78,000 $78,000 $78,000 $78,000 $78,000 $78,000 $78,000 $78,000
Retained Earnings ($63,175) ($63,175) ($63,175) ($63,175) ($63,175) ($63,175) ($63,175) ($63,175) ($63,175) ($63,175) ($63,175) ($63,175) ($63,175)
Earnings $0 ($152) $1,187 $3,933 $21,059 $30,997 $34,186 $36,299 $38,238 $39,786 $42,155 $44,727 $50,195
Total Capital $14,825 $14,673 $16,012 $18,758 $35,884 $45,822 $49,011 $51,124 $53,063 $54,611 $56,980 $59,552 $65,020
Total Liabilities and Capital $248,616 $253,649 $253,009 $256,572 $282,016 $287,547 $288,498 $288,149 $288,000 $287,394 $287,139 $288,746 $293,579
Net Worth $14,825 $14,673 $16,012 $18,758 $35,884 $45,822 $49,011 $51,124 $53,063 $54,611 $56,980 $59,552 $65,020