Overview

 The Hotel Acquisition &
Renovation Pro-form is an excel-based tool for accessing the viability of
acquiring an existing hotel and subsequent renovation. The model is monthly in
nature, and it is 100% unlocked with transparent and easy-to-understand formulas
that can be customized to the user's needs.

It bases the expense of the
renovation on monthly multi-room renovation with the option to stop activities
during the renovation period.

The operating Cash flow is
projected by considering key metrics, such as occupancy rates, the average
daily rate (ADR), revenue per room occupied/sold for the different departments,
and the combination of fixed and variable costs, making the template perfectly
fitted to this type of real estate.

The user only needs to input
information into the cells formatted in the dark blue font in the input sheet.
Any other formats are formulas or labels. 

The Model is
provided the template with information from a hypothetical business model for a
Fast Food Franchise for demonstration.


Functionalities:

• Revenue & COGS Projections:
Sales Breakdown and distribution costs by different Departments, allowing the
assessment of the profit for the different departments,

• Undistributed Expenses: modeled
as Fixed and Variable

Financing: Modeling of the
acquisition and permanent Loan

Sale valuation of the hotel based
on forwarding Net Operating Income (NOI)


Tabs:

Assumptions: Input of operating
metrics such as ADR, RevPAR, RevPOR, Department, etc.

Summary: Summary of the main KPIs,
key drivers, and Dynamic Charts and sensitivity analysis

Hotel pro forma annual cash flow

Hotel pro forma monthly cash flow

Operational Overview: Snapshot of
the leading Operating KPI

Equity waterfall 4 Tier waterfall
structure

Reviews Add a review
No reviews yet

More From Jair

Browse our top rated business templates. See All
Hotel Acquisition and Renovation Pro-forma
401
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
1,067
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,389
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,932
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,884
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,692
5
The mobile app financial model provides a comprehensive financial plan template for a mobile app business such as a startup…
See All