Hotel Acquisition Financial Model
![Hotel Acquisition Financial Model - Templarket - Business Templates Marketplace]()
![Hotel Acquisition Financial Model - Templarket - Business Templates Marketplace]()
![Hotel Acquisition Financial Model - Templarket - Business Templates Marketplace]()
![Hotel Acquisition Financial Model - Templarket - Business Templates Marketplace]()
![Hotel Acquisition Financial Model - Templarket - Business Templates Marketplace]()
![Hotel Acquisition Financial Model - Templarket - Business Templates Marketplace]()
![Hotel Acquisition Financial Model - Templarket - Business Templates Marketplace]()
![Hotel Acquisition Financial Model - Templarket - Business Templates Marketplace]()
![Hotel Acquisition Financial Model - Templarket - Business Templates Marketplace]()
![Hotel Acquisition Financial Model - Templarket - Business Templates Marketplace]()
![Hotel Acquisition Financial Model - Templarket - Business Templates Marketplace]()
This model is suitable for investors looking at hotel acquisition projects. Or it might also serve analysts or prospective analysts looking to improve their modeling skills.
The model is fully dynamic and allows for a full analysis of a potential hotel acquisition. Filling in all the dynamic inputs for the analysis takes less than 10 minutes.
The best feature of this model is its polished presentable dashboard. The model is very detailed and suits professional hotel acquisition analysis. The model allows for a flexible number of rooms as well as multiple income streams from Food and Beverage.
The contents are as follows:
- Assumptions Tab: flexible acquisition and exit dates, mortgage financing assumptions, re-financing assumptions, acquisition costs, and sale costs assumptions, F&B assumptions, average vacancy, ADR, RevPAR. Exit value for the property is calculated automatically based on NOI for a period and cap rate you assume in your projection.
- Dashboard Tab: Includes 10 years of monthly cash flow, a summary of costs and revenues, 2 charts and main metrics summary: IRR, Equity Multiple, Profit Margin, Net Profit, DSCR, Debt Yield, Operating Margin, Cash on Cash, Revenue per SQFT, NOI per SQFT.
- Annual Cash Flow: includes operating revenues, operating costs, NOI, capital costs, debt service, and net income.
- Monthly Cash Flow.
- Operating Income with a breakdown of Departamental Profit, Undistributed Expenses, SBE Fees, Property Tax, Fixed Charges, EBITDA, NOI.
- Project Financing with senior debt amortization and re-financing option.
- Waterfall; Partnership splits based on annual cash flow.
Shall you have any suggestions for upgrading or adjusting my models so that they suit you and my audience better, please let me know.
The model is fully dynamic and allows for a full analysis of a potential hotel acquisition. Filling in all the dynamic inputs for the analysis takes less than 10 minutes.
The best feature of this model is its polished presentable dashboard. The model is very detailed and suits professional hotel acquisition analysis. The model allows for a flexible number of rooms as well as multiple income streams from Food and Beverage.
The contents are as follows:
- Assumptions Tab: flexible acquisition and exit dates, mortgage financing assumptions, re-financing assumptions, acquisition costs, and sale costs assumptions, F&B assumptions, average vacancy, ADR, RevPAR. Exit value for the property is calculated automatically based on NOI for a period and cap rate you assume in your projection.
- Dashboard Tab: Includes 10 years of monthly cash flow, a summary of costs and revenues, 2 charts and main metrics summary: IRR, Equity Multiple, Profit Margin, Net Profit, DSCR, Debt Yield, Operating Margin, Cash on Cash, Revenue per SQFT, NOI per SQFT.
- Annual Cash Flow: includes operating revenues, operating costs, NOI, capital costs, debt service, and net income.
- Monthly Cash Flow.
- Operating Income with a breakdown of Departamental Profit, Undistributed Expenses, SBE Fees, Property Tax, Fixed Charges, EBITDA, NOI.
- Project Financing with senior debt amortization and re-financing option.
- Waterfall; Partnership splits based on annual cash flow.
Shall you have any suggestions for upgrading or adjusting my models so that they suit you and my audience better, please let me know.
