| 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 |