Motel - Hunting Lodge Business Plan

Start your plan
Start my business plan

Start your own motel - hunting lodge business plan

Lowland Heights Roadhouse

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

Download link edge graphic Download this plan

Start your own motel - hunting lodge business plan

Start your own business plan

LivePlan logo Start planning

Your business plan can look as polished and professional as this sample plan. It's fast and easy, with LivePlan.

Get the Bplans newsletter:

Expert business tips and advice delivered weekly.