# Real Estate Model Example Build a real estate model with rent roll assumptions, operating expenses, financing, and exit analysis in one investment-ready workbook. - Canonical: https://finamodel.com/examples/real-estate-model - Excel download: https://finamodel.com/templates/real-estate.xlsx - Category: Real Estate - Model type: Underwriting - Difficulty: Beginner - Audiences: Founders & operators, Investors & analysts, Developers, Equity investors, Lenders, Brokers - Tags: development, pro-forma, construction-budget, lease-up, equity-irr ## Overview Model commercial or residential real estate development from land acquisition through lease-up and stabilised operations, calculating project IRR and equity returns. This template forecasts construction cost by phase with cost per square foot, soft costs (professional fees, permits), and contingency, then models phased leasing with lease rates and tenant rollover assumptions. Operating period cash flows project NOI with escalating rents, operating expense budgets, and debt paydown from operating cash. The workbook contains land and development cost schedules, construction phase capex with timing, a phased lease-up schedule showing absorption curves (typically 12–24 months to stabilisation), an income statement for operating years, and debt amortisation post-construction. The model calculates levered returns (equity IRR and multiple) from the initial equity injection through exit assuming a terminal NOI/cap rate valuation. Key inputs include entry cost, construction duration, lease-up assumptions, operating margin targets, and exit cap rate (conservative underwriting assumes 25–50 bps expansion). Target users are real estate developers, real estate PE funds, and equity investors evaluating commercial and multifamily development projects valued at $50M to $1B+. ## What's included - Rent roll and occupancy assumptions - Operating expense schedule - Debt service and financing logic - Cash flow and returns analysis - Disposition assumptions - Land acquisition cost and site preparation - Hard construction costs by phase and cost per square foot - Soft costs including professional fees and permits - Lease schedule with lease rates and tenant rollover - Operating expense budget and operating margin - Debt schedule and equity returns by scenario ## Real Estate Model: How the Template Evaluates Property Investments This real estate model evaluates the acquisition, operation, and disposition of a commercial or multifamily property. It projects levered and unlevered returns—IRR, equity multiple, and cash-on-cash—over a specific hold period. The template connects rent roll, operating expenses, financing, and exit assumptions into a single investment-ready workbook. ### Operating and Financing Drivers The model's assumptions sheet drives the entire analysis. It captures property metrics (units or square feet), acquisition costs, financing terms such as LTV, interest rate, interest-only period, and amortisation, plus rent and operating expense growth rates, exit cap rate, selling costs, and hold period. - These inputs feed the rent roll, operating expenses, debt schedule, and exit timing. The rent roll builds gross potential rent, then applies vacancy and credit loss and adds other income to produce effective gross income. - Operating expenses cover fixed and variable items including taxes, insurance, management, utilities, and repairs and maintenance. Together these determine net operating income, the core driver of property value and debt service capacity. ### Calculation Flow from Revenue to Cash Flow The model follows a logical flow: gross potential rent is reduced by vacancy and credit loss, and other income is added to yield effective gross income. Subtracting total operating expenses gives net operating income. - Debt service is calculated from the debt schedule, which tracks loan funding, the interest-only period, principal amortisation, and the debt service coverage ratio. Unlevered cash flow combines the acquisition cost in Year 0 with NOI, capital expenditures, and gross exit sale value. - Levered cash flow starts with equity invested in Year 0, adds annual net cash flow after debt service, and includes exit sale proceeds net of loan payoff. Exit valuation uses forward NOI (Year N+1) divided by the exit cap rate, and cash-on-cash return is annual levered cash flow divided by total equity invested. ### Outputs and Return Metrics The cash flow and returns sheet aggregates the analysis to produce key metrics: levered and unlevered IRR, equity multiple, and cash-on-cash return. It also shows property valuation at exit and proceeds distribution. - The debt schedule outputs DSCR, which is typically checked against a minimum threshold such as 1.20x. Cross-sheet dependencies ensure assumptions feed all modules, while the rent roll and operating expenses flow into NOI, and the debt schedule feeds levered cash flow and loan payoff. - The cover sheet summarises property details and executive returns. Sign conventions are consistent: revenues and expenses are positive, outflows such as acquisition and equity invested are negative, and debt proceeds are positive in Year 0 with debt service and payoff negative. ### Practical Use and Common Pitfalls This model is used for evaluating property acquisitions and hold-period performance. It helps users test how changes in financing, rent growth, or exit assumptions affect returns. - The template includes validation checks: changing the hold period must shift exit proceeds correctly, DSCR should be calculated and compared to a typical minimum, remaining loan balance at exit must match the debt schedule, and levered IRR should exceed unlevered IRR when positive leverage exists. Total equity is acquisition price plus costs minus loan proceeds. - Common pitfalls to avoid include using Year N NOI instead of Year N+1 for exit valuation, failing to dynamically cut off cash flows at the hold period, incorrectly switching from interest-only to amortising, omitting closing costs from Year 0 equity, and calculating LTV on purchase price rather than current estimated value. ## Built for underwriting Use this structure for acquisitions, developments, or property investments where rent, leverage, and exit timing drive the outcome. ## Useful for levered return analysis A good real estate model should show how occupancy, rent growth, expenses, and financing terms affect investor returns over time. ## Better than a generic property spreadsheet This gives you a cleaner starting point for investment analysis instead of relying on a weak template that does not reflect real underwriting logic. ## Built for underwriting Use this structure for acquisitions, developments, or property investments where rent, leverage, and exit timing drive the outcome. ## Useful for levered return analysis A good real estate model should show how occupancy, rent growth, expenses, and financing terms affect investor returns over time. ## Better than a generic property spreadsheet This gives you a cleaner starting point for investment analysis instead of relying on a weak template that does not reflect real underwriting logic. ## Workbook structure ### Property Assumptions This sheet sets the rent, occupancy, lease, cost, and financing inputs that drive the investment case. - Rent and occupancy assumptions - Lease or unit-level inputs - Operating expense and capex drivers - Debt and financing assumptions ### Income & NOI The income sheet builds property revenue and net operating income before financing effects. - Gross rental income build - Vacancy and bad debt assumptions - Operating expense structure - NOI visibility by period ### Debt & Cash Flow This sheet layers financing on top of the property cash flow so the levered outcome is visible. - Debt service calculation - Cash flow after financing - Loan impact on returns - Liquidity profile across the hold period ### Returns & Exit The final sheet shows exit assumptions and investor return outputs so the deal can be evaluated properly. - Exit cap rate or sale assumptions - Equity proceeds at exit - IRR and MOIC style outputs where relevant - Overall investment case summary ### Property Assumptions This sheet sets the rent, occupancy, lease, cost, and financing inputs that drive the investment case. - Rent and occupancy assumptions - Lease or unit-level inputs - Operating expense and capex drivers - Debt and financing assumptions ### Income & NOI The income sheet builds property revenue and net operating income before financing effects. - Gross rental income build - Vacancy and bad debt assumptions - Operating expense structure - NOI visibility by period ### Debt & Cash Flow This sheet layers financing on top of the property cash flow so the levered outcome is visible. - Debt service calculation - Cash flow after financing - Loan impact on returns - Liquidity profile across the hold period ### Returns & Exit The final sheet shows exit assumptions and investor return outputs so the deal can be evaluated properly. - Exit cap rate or sale assumptions - Equity proceeds at exit - IRR and MOIC style outputs where relevant - Overall investment case summary ## Features - **Phased construction and lease-up:** Models stabilization timeline with construction draw schedules and phased tenant occupancy ramps. - **Lease economics and tenant mix:** Tracks lease rates, tenant type, lease term, and rollover to forecast stabilized NOI. - **Leveraged returns and refinancing:** Calculates equity IRR under varying loan assumptions including construction-to-permanent financing and stabilization refinance. ## Use cases - **Development feasibility and site evaluation:** Test land value and cost assumptions to determine whether a project generates acceptable equity returns. - **Investor capital raise and pitch materials:** Build investor-ready models showing pro forma NOI, equity IRR, and downside scenarios. - **Loan underwriting and refinancing:** Support construction and permanent lender due diligence with detailed underwriting of costs and revenues. ## Frequently asked questions ### What is a real estate financial model? It is a model used to forecast property income, costs, financing, and exit returns for an investment or development. ### Who uses real estate models? Investors, developers, acquisition teams, and advisers use them to underwrite opportunities. ### What should a real estate model include? It should include rent assumptions, operating expenses, debt service, cash flow, and exit or sale assumptions. ### Can it be used for acquisitions? Yes. Real estate models are widely used for acquisition underwriting and investment review. ### Does it cover financing? Yes. A proper real estate model should include the impact of leverage on cash flow and returns. ## Related templates - [Multifamily Residential Model](https://finamodel.com/templates/multi-family-model) - [Office Building Investment Model](https://finamodel.com/templates/office-building-model) - [Retail Centre Operating and Development Model](https://finamodel.com/templates/retail-centre-model)