Real Estate Financial Model Example: What's In It and How It Works

A real estate financial model has one job: tell you whether a deal is worth doing at the price you're considering — and what returns you can realistically expect.

The mechanics are straightforward. You project the property's income and expenses to get net operating income, layer in debt service, calculate returns over the hold period, and run scenarios to understand what happens if things go wrong. The analysis only gets complicated when the inputs are wrong or the model is built sloppily.

This post walks through a real example with the components that matter and the benchmarks that give the numbers context.

The Building Blocks

Every real estate financial model starts with the same four layers:

1. Revenue

Revenue modeling begins with Gross Potential Rent (GPR) — the maximum income if every unit were occupied at market rate. From there, you subtract vacancy and credit loss (the percentage you expect from turnover and non-payment) to get Effective Gross Income.

Most stabilized multifamily assets model vacancy at 5–7%. Class B and C assets in secondary markets often model 8–10%. If you're modeling a lease-up scenario, vacancy starts high (30–50%) and steps down to stabilized rates over 12–24 months.

Below EGI, add other income: parking fees, laundry, storage, pet fees, and any ancillary revenue. On a 100-unit multifamily property, other income can add $30,000–$60,000 per year to the top line.

2. Operating Expenses

Standard operating expenses for a commercial or multifamily property:

• Property management fee (typically 4–6% of collected revenue)
• Property taxes
• Insurance
• Utilities (if owner-paid)
• Maintenance and repairs
• CapEx reserve (commonly $250–$500/unit/year for multifamily)
• Leasing commissions and tenant improvement allowances (for commercial leases)
• Administrative costs

One mistake many first-time modelers make: accepting the seller's operating expense figures. Sellers have incentive to minimize reported expenses. Insurance costs and payroll in particular often come in higher than shown on the offering memorandum. Build your own expense assumptions from comparable properties and local cost data. The real estate income statement example shows OER benchmarks by property type to cross-check your assumptions.

3. Net Operating Income

NOI = Effective Gross Income − Operating Expenses

NOI excludes debt service, depreciation, and income taxes. It represents what the property earns independent of how it's financed — which is why cap rates and valuations are based on NOI rather than cash flow after debt.

4. Debt Service

The model then layers in financing:

• Loan amount (based on LTV): conventional commercial mortgages typically require 65–75% LTV; Fannie Mae multifamily goes up to 75–80%
• Interest rate and amortization period
• Annual debt service (principal + interest)
• DSCR check: NOI / annual debt service. Lenders require a minimum of 1.20x–1.25x for most commercial properties, meaning NOI must be at least 20–25% above the debt payment

Worked Example: 24-Unit Multifamily Acquisition

Here's a simplified acquisition model for a 24-unit apartment building:

Property Assumptions

Operating Expenses

NOI and Returns

This deal produces a 9.9% cash-on-cash return on the $1,080,000 equity invested — solidly in the "good" range for most markets. The DSCR at 1.56x exceeds the typical lender minimum, providing buffer if occupancy drops.

The IRR calculation would factor in rent growth assumptions, CapEx spend over the hold period, and a terminal value based on an exit cap rate (typically 25–50 basis points above entry to reflect asset aging and market risk). For a step-by-step acquisition underwriting walkthrough, the real estate pro forma example builds out a 10-unit deal with full return calculations.

Return Metrics and What They Mean

Real estate models produce multiple return metrics for good reason — each one tells you something different:

Cap rate benchmarks (CBRE, 2025):

IRR targets by strategy:

Cash-on-cash benchmarks: 5–7% is acceptable in high-demand markets; 8–12% is considered solid; above 12% typically signals higher risk or an emerging market.

Types of Real Estate Financial Models

The model structure varies depending on the deal type:

Acquisition Model Used to evaluate purchasing an existing, stabilized property. The purchase price is derived by applying a market cap rate to in-place NOI. Debt and equity fund upfront. The model projects cash flows over a 5–10 year hold and models an exit at a terminal cap rate. The core question: does this deal clear the return hurdle?

Development Model (Ground-Up) Significantly more complex. Land, hard costs, and soft costs replace a purchase price. Debt and equity are drawn down in phases over the construction period. There's no revenue during construction. Returns are measured from the first dollar in to the last dollar distributed — often 3–7 years later. IRR hurdles are higher to compensate for entitlement, construction, and lease-up risk.

Value-Add Model A hybrid: acquire an existing property, spend on improvements, increase NOI, and sell at a lower cap rate (higher valuation). The model needs to account for acquisition cost, renovation/CapEx budget, a transitional period with disrupted income, and the improved cash flows post-renovation. Underwriting the renovation costs and timing is where most value-add deals get into trouble.

Rental Property / Cash Flow Model Used for ongoing portfolio management and refinancing analysis. Focus is on the rent roll — tracking individual leases, renewal probabilities, rent bumps, and occupancy over time. Less about investment returns, more about understanding what the property earns and when leases expire.

The Real Estate Financial Model Template is built around the acquisition and value-add use cases — the most common starting point for investors evaluating deals.

Common Modeling Mistakes

Aggressive exit cap rate. The most common error that turns bad deals into apparent good deals. Many models assume you'll sell at the same cap rate you bought — or lower. In practice, older assets in a higher-rate environment often transact at higher cap rates. Adding even 50 basis points to your exit cap rate can flip a deal from 15% IRR to marginal. Model a range.

No stress test. A single-scenario base case isn't analysis — it's a pitch deck. Build a downside case with higher vacancy, flat rent growth, and a 75bps higher exit cap rate. If the deal still works in the downside case, you have conviction. If it only works in the upside, you're speculating. Use the real estate break-even calculator to find the minimum occupancy threshold where the deal still covers debt service.

Ignoring property tax reassessment. In many jurisdictions, a sale triggers reassessment to the purchase price. If you're buying a property that was last assessed at $1.8M and you're paying $3.6M, your year-one tax bill could double from what the current owner shows. Model year-one taxes based on your purchase price, not the seller's current bill.

Accepting broker proforma income figures. A broker's offering memorandum shows rent potential and often understates vacancy, maintenance, and management costs. Underwrite using your own market rent research and expense assumptions from comparable properties.

Circular references in debt/waterfall calculations. This is a mechanics problem, not a judgment problem — but it produces unreliable outputs. If your model needs to calculate debt draws based on costs that depend on financing, or waterfall distributions that reference each other, build the structure carefully. Errors here are hard to spot and easy to miss.

Building the Model

For most acquisition analyses, a well-structured Excel model covers:

1. Assumptions tab — all inputs in one place (purchase price, rent, vacancy, expenses, loan terms, hold period, exit cap rate)
2. Pro forma tab — annual projections of income, expenses, NOI, and cash flow over the hold period
3. Returns tab — cap rate, cash-on-cash, IRR, and equity multiple calculations
4. Sensitivity analysis — IRR and CoC returns across a matrix of exit cap rates and rent growth scenarios
5. Debt schedule — amortization table with DSCR check

For deals with equity partners or fund structures, add a waterfall tab showing LP/GP distributions at different return hurdles.

The Real Estate Financial Model Template includes all five components. If you're also looking at the property's ongoing income performance, the Real Estate Income Statement Template and Real Estate Cash Flow Template handle the operational reporting side.

The financial model tells you whether to buy. The income statement and cash flow reports tell you how the asset is performing once you own it. Turn your model into a presentation-ready deck with Deckary.