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 |