Financial Model, Hospitality, Hotel |
DCF Model, Excel, Financial Feasibility, Financial Projections, IRR (Internal Rate of Return), Price Per Room, Sensitivity Analysis, Valuation |
This financial model has been reworked based on the feedback received on the previous hotel valuation model. This model now is an alternative version of the Hotel Valuation Model. The main focus of the analysis of this financial model lies in IRR.
The Hotel Investment Financial Model provides a framework to forecast the expected cash flows for a hotel investment and calculates the financial metrics of relevance to investors such as the IRR (levered and unlevered).
The Excel model template provides the following:
- Executive Summary with key charts, key metrics, and key assumptions. Simply change the assumptions on the right and see immediately the effect on the charts for easy to understand
- Yearly financial projections for 10 years
- Key Metrics
- Average room rate
- Average occupancy rate
- Number of rooms
- Revenue Streams
- Room rental
- Food & Beverage
- Costs
- Commission costs for affiliate marketers and transaction costs
- Cost of sales
- All other operating expenses (OPEX) costs (modeled as fixed costs)
- Financial Statements (Yearly) – Income Statement, Balance Sheet, Cash Flow Statement
- IRR analysis based on levered cash flows
- Sensitivity Analysis on IRR with Switch for levered and unlevered IRR
- Valuation comparison based on alternative methods such as Discounted Free Cash Flow (DCF), EBITDA multiple and cap rates
- Debt schedule which models two layers of financial debt (junior and senior debt) – if needed
- Fixed asset depreciation schedule with different categories of fixed assets
- Forecast of all relevant financial ratios
- Print-friendly layout including charts and graphs
The Executive Summary page provides the hotel investor with a comprehensive overview of the financial economics of the envisaged investment in a hotel.
The model is available in two versions, one with only a preview pdf file (Free Version) and all cells editable in Excel (Paid Version).
Filetype: .xlsx (Microsoft Excel 2008 for Mac) and .pdf
Similar Products
Other customers were also interested in...
Hospitality Financial Model Template Package
This is a collection of financial model templates for businesses in the hospitality industry and its... Read more
Hotel Development Financial Model (Construction, O...
Financial model presenting a development scenario for a Hotel including construction, operation, and... Read more
Boutique Hotel Financial Model Excel Template
Check Our Boutique Hotel Financial Projection. Excel - well-tested, robust, and powerful. Get you a ... Read more
Airbnb Financial Model
Air BnB Financial Model Template presents the business case of the purchase of up to 5 properties wi... Read more
Hotel Financial Model Excel Template
Download Hotel Financial Model. Creates a financial summary formatted for your Pitch Deck. Ready to ... Read more
ALL IN ONE Boutique Hotel Integrated 5-Year DCF Fi...
This is a real case-based advanced DCF model of a boutique hotel business with scenarios options and... Read more
Resort Financial Model Excel Template
Order Resort Financial Model. Excel template - robust and powerful. This is your solid foundation to... Read more
All-Inclusive Resort Financial Model – Dynam...
Moving away from the old, traditional way of operating, All-Inclusive Resorts now offer a ... Read more
Hotel/Guesthouse/Resort Development Model and Valu...
This Hotel / Holiday Resort Development Model will take you through a 20-year period of Three Statem... Read more
City Hotel Financial Model – Dynamic 10 Year For...
A City Hotel is one of the most common hotel types. It provides accommodation and meals to travelers... Read more
Reviews
The layout of the model could be improved so that all model inputs are in one area.
The model builder could also consider adding a bit more flexibility around having the ability to add additional revenue, cost of sales and opex. items.
Overall, pretty good, considering the price!
574 of 1163 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
is it possible to change the currency ? how ?
585 of 1210 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
-
Hi Maxime, thank you for leaving a review of this model template. Regarding your question, as you can see in the Assumptions Section > General Assumptions, you can change the Currency accordingly.
577 of 1166 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
It’s a nice model if you manage everything. There should be a option based on new hotel dynamics. Buying a asset and adding a management company. The management company pays a fix rent + variable rent, per room. Obviously having a deposit (6 months , etc). Hotel business are becoming more and more complex and specialization is going this way.
Thanks,
589 of 1167 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
Hi! Very clear and easy to use model. However, on the balance sheet page, how did you obtain the value of 6’569’000 for Equity under the column “Closing”. Somehow the excel formula does not show the formula. It surely cannot be Asset – liabilities. Can anybody clarify?
588 of 1196 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
-
The Closing Balance Sheet is just pro forma to set the starting point for the Balance Sheet going forward for those who like to see a proper Balance Sheet. The $6'569'000 is the amount needed so that Assets = Liabilities + Sh. Equity at the time you acquire the asset. For the model this calculation is not relevant as IRR calculation bases on future cash flows and not on the balance sheet you acquire at point of purchase. If you feel this is confusing, simply set the figures in the closing balance sheet to zero as its really not relevant for the calculation. We might change this in the next model version to avoid confusion.
586 of 1159 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
It is quite clear and useful to people who has no financial background
588 of 1175 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
hi
Thank you for your feedback.
579 of 1147 people found this review helpful.
You must log in to submit a review.