5-year Financial Projections, Break-Even, Budget, Business Valuation, Cash Flow Analysis, Cash Flow Projections, Cash on Cash Yield, Cost Calculation, Cost Projections, DCF Model, Excel, Financial Analysis, Financial Debt, Financial Feasibility, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Financial Ratios, Financial Reporting, Financial Statements, Financing, Investment Multiple, Investors, KPIs (Key Performance Indicators), NPV (Net Present Value), Post Money Valuation, Pre Money Valuation, Price Per Room, Profitability Analysis, Return on Invested Capital (ROIC), Revenue Projections, Scenario Analysis, Sensitivity Analysis, Startup Financial Models, Terminal Value, Three Statement Model | Three Financial Statements, WACC (Weighted Average Cost of Capital)

This model can be used for up to 4 types of rooms/properties and separate food & beverage segments.

This model provides a framework to forecast the next 12 years and correctly value the business in case of any investing/acquisition need arises.

Highlights of this model are:
• Forecast for the next 12 years (can be edited)
• Detailed breakdown of revenue and cost assumptions.
• Key Assumptions sheet to bring all important assumptions into one sheet
• Finsummary and Summary sheet to easily present analysis to stakeholders
• Fixed Asset schedule to accurately calculate depreciation and investment needs
• Break-even and Scenario analysis for a better understanding of different business situations
• Detailed Profit and loss statement, Balance Sheet, and Cash-flow
• Discounted cash-flow and ratio analysis for valuation
• Sensitivity Analysis for WACC

This model can be used by Owners and outsiders (Analysts, Bankers, etc.). This model will be useful to apply for loans or pitch to raise capital.

The model was developed using financial modeling best practice standards. Should you have any questions on the model, you’re welcome to contact me via the Contact Author button.

You must log in to submit a review.