IX. Financial Plan
This Section's Contents
You can download our Hotel Business Plan Template (including a full, customizable financial model) to your computer here.
Revenue and Cost Drivers
[Company Name]’s will come from hotel room occupancy and conference room rentals.
The major costs for the company will be salaries of the staff and cost to maintain the standard of the hotel. In the initial years, the company’s marketing spend will be high, as it establishes itself in the market.
Capital Requirements and Use of Funds
[Company Nameis seeking a total funding of $3,000,000 to launch the hotel. The capital will be used for funding capital expenditures, manpower costs, marketing expenses and working capital.
Specifically, these funds will be used as follows:
- Hotel design/build: approximately $2,500,000
- Working capital: approximately $500,000 to pay for Marketing, salaries, and lease costs until [Company Name] reaches break-even
Key Assumptions& Forecasts
Below please find the key assumptions that went into the financial forecast and a summary of the financial projections over the next five years.
| Number of available rooms | Per location |
|---|---|
| Year 1 | 20 |
| Year 2 | 20 |
| Year 3 | 20 |
| Year 4 | 20 |
| Year 5 | 20 |
| Average daily rate | $155 |
| Average Daily rate growth | 3% |
| Annual Lease ( per location) | $25,000 |
| Yearly Lease Increase % | 2.50% |
5 Year Annual Income Statement
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||
|---|---|---|---|---|---|---|
| Revenues | ||||||
| Product/Service A | $151,200 | $333,396 | $367,569 | $405,245 | $446,783 | |
| Product/Service B | $100,800 | $222,264 | $245,046 | $270,163 | $297,855 | |
| Total Revenues | $252,000 | $555,660 | $612,615 | $675,408 | $744,638 | |
| Expenses & Costs | ||||||
| Cost of goods sold | $57,960 | $122,245 | $122,523 | $128,328 | $134,035 | |
| Lease | $60,000 | $61,500 | $63,038 | $64,613 | $66,229 | |
| Marketing | $20,000 | $25,000 | $25,000 | $25,000 | $25,000 | |
| Salaries | $133,890 | $204,030 | $224,943 | $236,190 | $248,000 | |
| Other Expenses | $3,500 | $4,000 | $4,500 | $5,000 | $5,500 | |
| Total Expenses & Costs | $271,850 | $412,775 | $435,504 | $454,131 | $473,263 | |
| EBITDA | ($19,850) | $142,885 | $177,112 | $221,277 | $271,374 | |
| Depreciation | $36,960 | $36,960 | $36,960 | $36,960 | $36,960 | |
| EBIT | ($56,810) | $105,925 | $140,152 | $184,317 | $234,414 | |
| Interest | $23,621 | $20,668 | $17,716 | $14,763 | $11,810 | |
| PRETAX INCOME | ($80,431) | $85,257 | $122,436 | $169,554 | $222,604 | |
| Net Operating Loss | ($80,431) | ($80,431) | $0 | $0 | $0 | |
| Income Tax Expense | $0 | $1,689 | $42,853 | $59,344 | $77,911 | |
| NET INCOME | ($80,431) | $83,568 | $79,583 | $110,210 | $144,693 | |
| Net Profit Margin (%) | - | 15.00% | 13.00% | 16.30% | 19.40% |
5 Year Annual Balance Sheet
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||
|---|---|---|---|---|---|---|
| ASSETS | ||||||
| Cash | $16,710 | $90,188 | $158,957 | $258,570 | $392,389 | |
| Accounts receivable | $0 | $0 | $0 | $0 | $0 | |
| Inventory | $21,000 | $23,153 | $25,526 | $28,142 | $31,027 | |
| Total Current Assets | $37,710 | $113,340 | $184,482 | $286,712 | $423,416 | |
| Fixed assets | $246,450 | $246,450 | $246,450 | $246,450 | $246,450 | |
| Depreciation | $36,960 | $73,920 | $110,880 | $147,840 | $184,800 | |
| Net fixed assets | $209,490 | $172,530 | $135,570 | $98,610 | $61,650 | |
| TOTAL ASSETS | $247,200 | $285,870 | $320,052 | $385,322 | $485,066 | |
| LIABILITIES & EQUITY | ||||||
| Debt | $317,971 | $272,546 | $227,122 | $181,698 | $136,273 | |
| Accounts payable | $9,660 | $10,187 | $10,210 | $10,694 | $11,170 | |
| Total Liabilities | $327,631 | $282,733 | $237,332 | $192,391 | $147,443 | |
| Share Capital | $0 | $0 | $0 | $0 | $0 | |
| Retained earnings | ($80,431) | $3,137 | $82,720 | $192,930 | $337,623 | |
| Total Equity | ($80,431) | $3,137 | $82,720 | $192,930 | $337,623 | |
| TOTAL LIABILITIES & EQUITY | $247,200 | $285,870 | $320,052 | $385,322 | $485,066 |
5 Year Annual Cash Flow Statement
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
|---|---|---|---|---|---|
| CASH FLOW FROM OPERATIONS | |||||
| Net Income (Loss) | ($80,431) | $83,568 | $79,583 | $110,210 | $144,693 |
| Change in working capital | ($11,340) | ($1,625) | ($2,350) | ($2,133) | ($2,409) |
| Depreciation | $36,960 | $36,960 | $36,960 | $36,960 | $36,960 |
| Net Cash Flow from Operations | ($54,811) | $118,902 | $114,193 | $145,037 | $179,244 |
| CASH FLOW FROM INVESTMENTS | |||||
| Investment | ($246,450) | $0 | $0 | $0 | $0 |
| Net Cash Flow from Investments | ($246,450) | $0 | $0 | $0 | $0 |
| CASH FLOW FROM FINANCING | |||||
| Cash from equity | $0 | $0 | $0 | $0 | $0 |
| Cash from debt | $317,971 | ($45,424) | ($45,424) | ($45,424) | ($45,424) |
| Net Cash Flow from Financing | $317,971 | ($45,424) | ($45,424) | ($45,424) | ($45,424) |
| SUMMARY | |||||
| Net Cash Flow | $16,710 | $73,478 | $68,769 | $99,613 | $133,819 |
| Cash at Beginning of Period | $0 | $16,710 | $90,188 | $158,957 | $258,570 |
| Cash at End of Period | $16,710 | $90,188 | $158,957 | $258,570 | $392,389 |
