Financial Model, Hospitality, Hotel |
DCF Model, Excel, Financial Projections, NPV (Net Present Value), Sensitivity Analysis, Valuation |
The Hotel Valuation Financial Model provides the framework to value a hotel via the Discounted Cash Flow (DCF) method.
Based on user’s feedback we have reworked this model to focus on the DCF value and also have added the Sensitivity Analysis to it. The previous IRR analysis part now is included only in a separate Hotel Investment Model.
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 Assumptions
- Average room rate
- Average occupancy rate
- Number of rooms
- Commission costs for affiliate marketers and transaction costs
- Cost of sales
- All other operating expenses (OPEX) costs (modeled as fixed costs)
- Discount Rate (WACC)
- Exit EV/EBITDA Multiple
- Revenue Streams
- Room rental
- Food & Beverage
- Financial Statements (Yearly) – Income Statement, Balance Sheet, Cash Flow Statement
- DCF Valuation Analysis
- Sensitivity Tables
- Show the results what happens when key assumptions such as the average room rates or occupancy rates will be changed
- Switch for Enterprise Value / Equity Value
- 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 provides an instant overview of a Hotel’s valuation based on DCF analysis and the related assumptions.
The model is available in two versions, a FREE PDF Demo Version and an Excel version where all cells are editable.
Filetypes:
.pdf PDF Acrobat Reader
.xlsx Microsoft Excel
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
Airbnb Financial Model
Air BnB Financial Model Template presents the business case of the purchase of up to 5 properties wi... 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
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
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
Bed And Breakfast Financial Model Excel Template
Buy Bed And Breakfast Financial Projection Template. This well-tested, robust, and powerful template... Read more
Resort/Hotel Project Valuation – Constructio...
Hotel - Construction and Operations FM is a project finance model for Investment appraisal of buildi... Read more
Hotel Acquisition Financial Model
General Overview Advanced financial model presenting an acquisition scenario for a Hotel. The ma... Read more
Reviews
Excellent
91 of 183 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
You must log in to submit a review.