Hotel Financial Model in Excel
Originally published: 16/02/2021 14:19
Publication number: ELQ-34132-1
View all versions & Certificate

Hotel Financial Model in Excel

Download in Microsoft Excel of a Hotel Financial Model.

Modeling real estate in Excel is not easy. In real estate, you will have to forecast the cash flow for long investment periods. In most models, you will have to forecast loan payments, maintenance costs, operational costs, and potential revenues from operating the real estate. On top of that, in real estate, we have different business models that will have different business drivers. To make your work easier, I will show you how to model in Excel fast and efficiently hotel businesses.
You will find attached the following things
1. Presentation showing Essential concepts related to real estate and modeling them in Excel and the main drivers of the profits in hotel business model for different business models
2. Hotel financial model in Excel. We will start by modeling 1 Hotel, Based on that we will be able to model the development of the whole chain. In the Excel file, you will also find the modeling of Loans that we have to take to build the whole chain, Head Office Cost modeling. Based on that we will create the Cash flow forecast and valuation of the whole business.
When it comes to drivers we will look at standard metrics used in the industry such as Average Daily Rate (ADR), # of nights sold, % Occupancy rate.

This Best Practice includes
1 Excel, 1 Presentation

Asen Gyczew offers you this Best Practice for free!

download for free

Add to bookmarks



  • Be the first to review this Downloadable Best Practice

    Write a review


More Best Practices from Asen Gyczew

See all

Any questions on Hotel Financial Model In Excel?

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

0.0 / 5 (0 votes)

please wait...