This template is a 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, supply costs, and changes in average check per guest. After modeling the scenarios, the user can make comparisons between them side-by-side.
Model Structure:
Intermediate Sheets:
• Revenue & COGS Projections: Sales Breakdown by different menu items and by department and group of sales (room rents, Food, Beverage and others);
• Expenses & WKC: Projection for Wages, COGS, Overhead expenses and the working capital requirement;
• Financing: Modeling of the construction and permanent loans, taking into account factors as capitalized interest period, interest-only period, term, refinance and loan payoff;
• Depreciation: Calculation of the depreciation, according to the Capex for each year.
• Working Capital: Calculation of the working capital requirement by using the collection, payment, and duration of storage period assumptions.
Outputs:
• Executive Summary: Summary of the main KPIs, main drivers and Dynamic Charts
• Cases Overview: In this sheet, the user can analyze all the scenarios side-by-side (the user must run the macro to update the scenarios)
• Hotel pro forma annual cash flow
• Hotel pro forma monthly cash flow
• Yearly Financial Statements: Yearly profit and loss account, Balance sheet and cash flow
• Monthly Financial Statements: Monthly profit and loss account, Balance sheet and cash flow
• Equity waterfall
• Cases Overview: In this sheet, the user can analyze all the scenarios side-by-side (the user must run the macro to update the scenarios
Should you have any questions, please feel free to contact us through: [email protected].
Similar Products
Other customers were also interested in...
Hotel Development Financial Model (Construction, O...
Financial model presenting a development scenario for a Hotel including construction, operation, and... Read more
Hotel/Guesthouse/Resort Development Model and Valu...
This Hotel / Holiday Resort Development Model will take you through a 20-year period of Three Statem... Read more
Theme Park & Hotel Financial Model (Construct...
Financial model presenting a development scenario for a Theme Park & Hotel project including con... Read more
Hotel Development REIT Financial Model Excel Templ...
Get the Best Hotel Development REIT Financial Model. Excel Template for your pitch deck to convince ... Read more
Student Hostel Development – Dynamic 10 Year Fin...
A hostel is a lower-priced inn of sorts that offers basic, shared accommodations. Typically, a hoste... Read more
Real Estate Development Bundle
This Real Estate Development Bundle is a collection of real estate calculators or tools in MS Excel ... Read more
Condo Hotel Financial Model Excel Template
Check Condo Hotel Financial Projection. Spend less time on Cash Flow forecasting and more time on yo... Read more
Real Estate Acquisition Financial Models Bundle
A collection of six Real Estate Development Financial Models offered at a discounted price you can�... Read more
Real Estate Development Financial Models Bundle
A collection of seven Real Estate Development Financial Models offered at a discounted price you can... Read more
Airbnb Financial Model
Air BnB Financial Model Template presents the business case of the purchase of up to 5 properties wi... Read more
Reviews
Thanks!!!
Thank you for your feedback.
60 of 129 people found this review helpful.
You must log in to submit a review.