Overview

This template is a very detailed financial model that takes into account the specifics of the real-estate niche that is the hotel industry.

This is a tool for modeling a new hotel, including the development costs, refinance, operational projections and eventual sale. The template is monthly in nature), and it is a 100% unlocked Excel file with fully transparent formulas that can be further tailored to suit your particular needs.

The development expenses are modeled following an s-curve (normal distribution), meaning that construction expenses are projected in a way that you have few expenses in the beginning, and then they quickly ramp up to your full project costs, which is closer to the reality of a construction project.

Taking into account key assumptions as occupancy rates, the average check per different room types, and the combination of fixed and variable costs, this tool provides a framework to project a monthly and annual hotel cash flow pro-forma, and thus reckoning the unique attributes of the segment. The model also forecasts the expected Income, Balance sheet and Cash Flow statement on a monthly and annual basis; however for financial modeling, valuation, and investment analysis, the users should focus on the pro-forma CF.

The template also contains a standard 4-tier IRR hurdle waterfall model to distribute proceeds between the general partner and limited partner. The user has the ability to adjust the equity share for GP and LP as well as the hurdle rate in each tier.

The model also allows the user to develop scenarios based on the variation of key metrics, namely occupancy rate, COGS, supplies costs, and changing in average check per guest. After modeling the scenarios, the user can make the comparison between them side-by-side.

Reviews Add a review
No reviews yet

More From Jair

Browse our top rated business templates. See All
Hotel Acquisition and Renovation Pro-forma
60
0
 The Hotel Acquisition & Renovation Pro-form is an excel-based tool for accessing the viability of acquiring an existing hotel and…
Single Family Development Model Pro-Forma Template
763
0
  This is a fully functional, institutional quality and dynamic real estate financial model for calculating the return of the…
Fast Food Franchise - Financial Model
1,077
2
 The Franchise Fast Food Excel Financial Model is tailored to evaluate the feasibility of a Fast Food Franchise, and will…
Convenience Store Gas Station Financial Plan
2,678
1
This Financial Plan Model is a perfect tool for a financial feasibility study on launching a Convenience Store Gas Station. The model can be used to create 5 years’ projections.   The model…
Bakery Financial Plan
2,644
1
This financial model can be utilized to evaluate a bakery business feasibility. This template is detailed, robust and very user-friendly.…
Mobile App Business Case Financial Model
2,483
5
The mobile app financial model provides a comprehensive financial plan template for a mobile app business such as a startup…
See All