Repurposed Hotel Financial Model with 5-Year P&L, Cash Flow, and Three Scenarios

What are the core revenue assumptions?

Revenue is generated exclusively from the sale of six repurposed hotel properties between September 2028 and March 2030. The model is driven by the acquisition timing, cost, construction budget, and eventual exit for each property. For example, 'The Apex' is acquired for $10.5 million with a $7.0 million construction budget, while 'Parkview' is acquired for $7.9 million with a $5.0 million budget, showcasing a range of project scales.

Key Revenue Streams

• Sale of 'The Apex' and 'Urban Loft' properties
• Sale of 'Metro Place' and 'Riverwalk' properties
• Sale of 'Central Hub' and 'Parkview' properties

What is the project's profitability trajectory?

The business is not profitable in the initial years due to heavy capital outlay for acquisitions and construction, with EBITDA at -$33.6M in Year 1 and -$44.4M in Year 2. Profitability begins in Year 3 as the first properties are sold, with EBITDA jumping to $51.3M. The project remains profitable through Year 5, indicating that returns are concentrated in the back half of the 5-year plan.

Improving Profitability

• Accelerate construction timelines to bring sales forward
• Negotiate lower acquisition prices or closing costs
• Implement value engineering to reduce construction budgets

How much total capital is required?

The initial, direct startup CAPEX for corporate setup is $235,000, covering items like office setup, IT, and legal fees. However, the primary capital requirement is for the property acquisitions and redevelopment, which is substantial. The model shows a minimum cash position of -$69.4 million in August 2028, which represents the peak funding needed to cover all project costs before sales proceeds are realized.

Major Capital Expenses

• Property Acquisitions: $7.9M to $12.8M per property
• Construction Budgets: $5.0M to $8.5M per property
• Initial Corporate CAPEX: $235,000

What are the project's cash flow dynamics?

Cash flow is deeply negative for the first 32 months as capital is deployed for acquisitions and construction without any offsetting revenue. Our real estate financial model for hotel property repurposing pinpoints the maximum cash deficit at -$69.4 million in August 2028. This occurs just before the first property sale in September 2028, which begins to reverse the negative cash flow trend.

Managing Cash Flow

• Structure financing with phased construction draws
• Negotiate seller financing or deferred acquisition payments
• Presell units or secure a forward-funding partner

What is the expected return on investment?

Based on the current assumptions, the investment returns are modest. The project shows an Internal Rate of Return (IRR), a metric for profitability over time, of just 0.02% and a Return on Equity (ROE) of 7.09%. The payback period is 43 months from the start of the project. These figures suggest the deal structure or exit assumptions may need to be optimized to deliver more attractive returns to investors.

Key Investor Metrics

• Internal Rate of Return (IRR)
• Return on Equity (ROE) & Equity Multiple
• Months to Payback

When does the business hit its break-even point?

The project reaches its break-even point in September 2028. Here’s the quick math: it takes 33 months from the project start date in January 2026 to cover the accumulated costs with the initial sales revenue. This long timeline is typical for development projects and underscores the importance of having sufficient long-term capital.

Accelerating Break-Even

• Phase projects to generate earlier, smaller sales
• Focus on converting properties with shorter construction cycles first
• Reduce corporate overhead during the pre-construction phase

How does the model handle different scenarios?

This adaptive reuse proforma template is built for scenario planning, allowing you to model Low, Base, and High cases. You can create different versions by adjusting key drivers like acquisition costs, construction budgets, and final sale prices. This helps you understand the potential range of outcomes for revenue, profit margins, and cash flow, providing a robust risk assessment for your hotel to apartment conversion finance strategy.

Utilizing Scenarios

• Model a 'Low' case with higher costs and lower sale prices
• Create a 'High' case with faster sales and higher margins
• Use scenarios to define financing needs and contingency budgets

You need a model that fits your exact project, not a rigid spreadsheet. This adaptive reuse proforma template is 100% editable, so you can tailor every assumption, from acquisition costs to sale timing. This flexibility saves you from building a complex real estate development excel model from scratch, letting you focus on strategy.

Adjust all key drivers for your specific deal

Modify timelines for acquisition and construction

Input unique financing and cost structures

Model any property repurposing financial analysis

A short-term view won't cut it for development projects. Our hotel conversion financial model provides a complete 5-year forecast, covering the full cycle from acquisition and construction to stabilization and sale. This long-range view is essental for securing financing and making informed capital allocation decisions.

See the full project lifecycle unfold

Track key metrics like IRR and ROE over time

Plan for cash needs during development

Present a credible long-term vision to investors

You have to get the costs right or the deal fails. This template provides a clear breakdown of all potential expenses, from initial acquisition and hard costs to soft costs and ongoing corporate overhead. Understanding the full picture of commercial property conversion costs helps you build a realistic budget and avoid surprises that kill profitability.

Separate initial CAPEX from operating expenses

Forecast both project-specific and corporate costs

Model variable expenses tied to sales activity

Get a clear view of your total capital requirement

How do you know if your assumptions are realistic? We've embedded key performance indicators (KPIs) and structures used in the real estate development industry. This helps you pressure-test your numbers against market standards and speak the same language as lenders and equity partners when discussing your hotel redevelopment feasibility study.

Track project margin and equity multiple

Calculate project and equity IRR automatically

Compare your projections to industry norms

Build confidence in your financial assumptions

Your team works across different platforms, and your tools should too. This financial model is built to work perfectly in both Microsoft Excel and Google Sheets. This ensures you can collaborate in real-time, share with partners easily, and work from any device without worrying about compatibility issues or broken formulas.

Use natively in your preferred spreadsheet app

Collaborate with your team in real-time on Sheets

Share securely with investors and lenders

Works on both Windows and Mac operating systems

You need to see the big picture without digging through tabs. The model includes a dynamic dashboard that visualizes your most important metrics. Charts and graphs for cash flow, profitability, and key returns give you an instant, high-level understanding of your project's financial health, perfect for quick reviews and presentations.

Visualize key financial performance indicators

Track cash balance and project profitability

Simplify complex data for stakeholders

Make faster decisions with clear insights

First impressions matter, especially with investors. This template is formatted with a clean, professional, and intuitive layout that meets the high standards of institutional investors, lenders, and partners. The clear structure makes your financial story easy to follow, building credibility and trust from the moment you share it.

Present a polished and credible financial plan

Meet the expectations of sophisticated investors

Clearly document all key assumptions

Save time on formatting and focus on the deal