Hotel Acquisition Financial Model
Originally published: 30/04/2020 08:50
Last version published: 27/06/2021 12:24
Publication number: ELQ-14160-4
View all versions & Certificate
certified

Hotel Acquisition Financial Model

Hotel Acquisition Real Estate Financial Model

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

This Best Practice includes
1 Unlocked Excel File

Acquire business license for $100.00

Add to cart

Add to bookmarks

Discuss

Further information

To analyze the potential acquisition of a hotel.

Acquisition of Hotel property type. Large property with food & beverage option

The model will not suit to analyze any other property type.

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review

People using this Best Practice also downloaded


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Oksana Babenka


See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Hotel Acquisition Financial Model?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...