Hotel Development Financial Model
Originally published: 25/04/2020 17:52
Last version published: 25/03/2021 08:51
Publication number: ELQ-56771-2
View all versions & Certificate

Hotel Development Financial Model

Download detailed Underwriting Pro Forma for Hotel Development

This model will serve for a proper analysis of a real estate hotel development opportunity.

This model is clean, professional, detailed, reliable, easy to read and modify. It is dynamic - all you have to do is to change the assumptions.

I did the modeling with a user in mind, so the model is very easy to follow through and understand. Making assumption inputs should take not more than 10 minutes.

The contents of the model are as following:

- Assumptions Tab (flexible construction budget, timing, daily rental assumptions, F&B, and debt service).
- Dashboard: Cash Flow Summary, 3 Charts Cash on Cash, IRR, Equity Multiple, Net Profit.
- Annual&Monthly Cash Flows (Rental Revenues, Sales Proceeds, Acquisition Costs, NOI, Debt Service, Net Income).
- Operations Summary, which calculates operating revenues, department expenses, department profit, EBITDA.
- F&B Tab, which shows income estimates for F&B.
- Draw Schedule
- Financing/Loan Amortization which includes the refinancing of the construction loan, mezzanine financing option
- Cost Curves, which support the cost distribution over time
- Flexible Exit Assumptions based on the assumed cap rate and the projected NOI
Shall you have any suggestions for upgrading or adjusting my models so that they suit you and my audience better, please let me know. I am always looking for improvement.

This Best Practice includes
1 Unlocked Excel File

Acquire business license for $100.00

Add to cart

Add to bookmarks


Further information

Provide a cash flow projection and full analysis for Hotel Development Opportunity

Any size of hotel development

The model will not suit any other property type


  • Be the first to review this Downloadable Best Practice

    Write a review


More Best Practices from Oksana Babenka

See all

Any questions on Hotel Development Financial Model?

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

0.0 / 5 (0 votes)

please wait...