Real Estate Deal Analysis: The Framework Smart Buyers Use
Real estate deal analysis is how serious buyers separate a good story from a defensible cash flow. It is the discipline of moving past the broker pitch, past the rent roll PDF, and into the numbers that actually determine whether a property pays you back. Whether you are evaluating a small multifamily, a flex industrial park, or a 200,000 square foot value-add retail center, the framework is the same: verify income, normalize expenses, stress test the debt, and price the deal so the math survives the next downturn.
This guide walks through the institutional real estate deal analysis playbook that family offices, lower middle market private equity sponsors, and disciplined operating partners use every week. We will cover the metrics that actually move yes or no decisions (cap rate, NOI, DSCR, IRR), how to build a defensible pro forma, the data sources to trust, the debt stack that determines your true risk, the tax levers that change after-tax returns, and how operators and limited partners split the upside.
What Real Estate Deal Analysis Actually Means
At its core, real estate deal analysis is a process for answering four questions in order: Is the income real? Is the expense load realistic? Can the debt service ratio be carried through a downturn? And does the projected return clear the hurdle rate of the capital you intend to raise? Get those four right and most other questions answer themselves.
The opposite of disciplined real estate deal analysis is napkin math. Napkin math takes the broker pro forma at face value, slaps a market cap rate on the year one NOI, and calls it a day. That approach loses money in flat markets and detonates portfolios in down cycles. The institutional version treats the broker pro forma as a sales document and rebuilds the numbers from primary sources.
The professional version of real estate deal analysis is also iterative. The first pass kills most deals in 20 minutes using three or four ratios. The second pass takes a week and includes a site visit, lender call, and full T-12 audit. The third pass is the investment committee memo, which has to defend every assumption against an adversarial reviewer.
The Core Metrics That Decide Every Deal
Five numbers carry most of the weight in commercial real estate deal analysis. Get fluent with all of them before you put down earnest money.
Net Operating Income (NOI). Effective gross income minus operating expenses, before debt service, capital expenditures, and taxes. NOI is the engine of value. A 100 basis point error in NOI on a $5M asset moves your purchase price by roughly $1.4M at a 7 percent cap rate.
Cap Rate. NOI divided by purchase price. Cap rate is the unlevered yield in year one. Cap rates compress when buyers are optimistic and expand when capital is scarce. In Q1 2025, CBRE reported average cap rates of 5.6 percent for stabilized multifamily, 6.8 percent for industrial, and 8.1 percent for suburban office. These move quarterly, so always pull live comps before underwriting.
Debt Service Coverage Ratio (DSCR). NOI divided by annual debt service. Most agency multifamily lenders require a minimum DSCR of 1.25x. Bridge lenders may accept 1.10x at close with a path to 1.30x stabilization. Banks on commercial product typically want 1.30x to 1.40x. DSCR is the single metric most likely to kill your loan if your rent assumptions slip.
Internal Rate of Return (IRR). The annualized return that discounts all future cash flows back to zero. Institutional buyers target levered IRRs of 8 to 15 percent on core and core-plus deals, 12 to 18 percent on value-add, and 18 percent or higher on opportunistic. Watch the equity multiple alongside IRR. A 20 percent IRR with a 1.4x multiple in two years tells a very different story than a 14 percent IRR with a 2.1x multiple in seven.
Cash-on-Cash Return. Year one pre-tax cash flow divided by total equity invested. This is the LP-friendly number because it answers, “What do I get back this year?” Most LPs want 6 to 10 percent cash-on-cash in year one on stabilized assets, with growth from there.
Pro Forma Underwriting: Building Numbers That Hold Up
The pro forma is where most real estate deal analysis lives or dies. Brokers send you their version. Your job is to throw it away and build your own from primary documents.
Verify the Rent Roll Line by Line
Request the current certified rent roll, the trailing 12 months of bank deposits, and at least three years of audited financials. Match every tenant on the rent roll to a signed lease and to actual deposits hitting the operating account. Concessions, free rent, and rent steps inflate stated rents. Adjust to in-place economic rent, not contract rent.
For commercial product, read every lease abstract. Note expiration dates, escalation clauses, expense reimbursement language (gross, modified gross, NNN), tenant improvement obligations, and any termination options. A lease expiring within 24 months gets discounted to current market rent on rollover, not held flat.
Normalize Operating Expenses
Brokers love to show you the seller’s trailing 12 expenses, which often understate property management, repairs and maintenance, and reserves. Normalize to the higher of: actual T-12, market benchmark, or third party budget from a reputable property manager. The big buckets:
- Property taxes: Will likely reassess to your purchase price in jurisdictions like Texas and Florida. Do not use the seller’s current tax bill.
- Insurance: Up 30 to 100 percent in coastal markets since 2022 per Marsh McLennan. Get a fresh quote, not a renewal estimate.
- Property management: 3 to 5 percent of effective gross income for multifamily, 2 to 4 percent for industrial, higher for retail and office.
- Repairs and maintenance: 5 to 12 percent of EGI depending on asset age and condition.
- Utilities: Verify which are owner-paid versus tenant-paid. Use 24 months of actual bills, not estimates.
- Replacement reserves: $250 to $400 per unit per year for multifamily, $0.15 to $0.40 per square foot for commercial. Most pro formas understate this.
Apply Realistic Vacancy and Credit Loss
Even a fully leased building should underwrite to physical vacancy of 5 to 8 percent for multifamily and 7 to 12 percent for commercial. Add a credit loss provision of 1 to 3 percent for bad debt and concessions. Bridge lenders and CMBS originators will haircut your stabilized NOI if your vacancy assumption is more aggressive than the submarket average reported by CoStar.
Comparable Sales Analysis: Pricing the Asset Right
Cap rate underwriting is only as good as your comps. Pull at least six closed transactions within the last 12 months, same submarket, same asset class, and within 25 percent of your subject by square footage or unit count. Adjust for vintage, condition, tenant credit, and location specifics.
Three data sources sit at the top of the institutional stack. CoStar is the deepest source for office, industrial, retail, and multifamily comps, with lease and sale data, tenant rosters, and submarket statistics. Pricing starts around $1,200 per month per market for institutional licenses. RealCapitalAnalytics (now MSCI Real Assets) tracks transactions $2.5M and above globally, with cap rate trend data and buyer and seller identification. Reonomy covers off-market opportunity sourcing with ownership intelligence and stacks well for prospecting. REIS (now Moody’s Analytics CRE) is the legacy source for submarket rent and vacancy forecasts.
For smaller deals under $5M where institutional data is thin, supplement with county recorder filings, broker civic relationships, and tax assessor parcel data. Verify every comp by pulling the actual deed and any recorded loan to confirm sale price net of seller financing or assumable debt adjustments.
The Debt Stack: How Debt Shapes Your Returns
Commercial real estate is a levered asset class, and the debt stack determines whether your equity returns are great or catastrophic. Three families of debt dominate the market, and your real estate deal analysis must price each one accurately.
Agency debt (Fannie Mae, Freddie Mac, FHA). Available for multifamily only. Loan-to-value typically caps at 65 to 75 percent, rates pinned to the 10-year Treasury plus a spread, 30-year amortization, 10-year terms with prepayment penalty (yield maintenance or step-down). This is the lowest-cost debt in the market. Q1 2025 spreads ran 150 to 220 basis points over the 10-year, putting all-in coupons in the high 5 to mid 6 percent range.
CMBS (Commercial Mortgage Backed Securities). Non-recourse, fixed rate, 10-year balloon with 30-year amortization. Available for stabilized office, retail, industrial, hospitality, and multifamily. LTV typically 60 to 70 percent. Spreads widened to 250 to 350 basis points over swaps in 2024 per Trepp. CMBS is unforgiving on covenants and slow on workouts, so model the reserves required.
Bridge debt. Floating rate (typically SOFR plus 300 to 600 basis points), 1 to 3 year terms with extension options, 70 to 80 percent loan-to-cost, used for value-add and transitional assets. Bridge is fast and flexible but expensive, and a 200 basis point move in SOFR can break your DSCR. Always model a rate cap and budget the premium.
For deals above the 65 to 75 percent senior LTV, mezzanine debt or preferred equity fills the gap to 80 to 85 percent total loan to value at 10 to 14 percent coupons. Use sparingly. Most blow-ups in 2023 and 2024 traced back to floating-rate bridge plus mezz stacks that could not refinance when rates spiked.
Tax Structure: Levers That Change After-Tax Returns
Tax planning is not a footnote. It is often 200 to 400 basis points of after-tax IRR. Three tools dominate.
1031 Exchange. Defers capital gains tax when you reinvest proceeds from a sold property into a like-kind replacement within 180 days. Cost segregation studies and depreciation recapture rules apply. The 1031 is the single most powerful wealth compounder in real estate. For the rules and the timeline mechanics, see our deep dives on 1031 exchange rules and the practical walkthrough at 1031 exchange for dummies.
Cost Segregation. An engineering-based study that reclassifies portions of a building into shorter depreciation lives (5, 7, and 15 years instead of 27.5 or 39). On a $10M apartment building, a properly done cost seg can accelerate $1.5M to $2.5M of depreciation into year one. The IRS has accepted this approach since the 1997 Hospital Corporation of America case.
Bonus Depreciation. The Tax Cuts and Jobs Act allowed 100 percent bonus depreciation on qualifying short-life assets through 2022. It is now phasing down: 60 percent in 2024, 40 percent in 2025, 20 percent in 2026, and 0 percent in 2027 unless Congress acts. The One Big Beautiful Bill Act passed in 2025 made certain elements of bonus depreciation permanent for property placed in service after January 19, 2025. Confirm with your tax advisor before underwriting.
Stack 1031 with cost seg and bonus depreciation thoughtfully and a 12 percent levered pre-tax IRR can become a 16 percent after-tax IRR. That is real money compounding across a portfolio.
The GP and LP Waterfall: How Returns Get Split
Most institutional real estate deals are structured with a general partner (GP, also called the operating partner or sponsor) and limited partners (LPs, the passive capital). The split is governed by a waterfall, which is the schedule of how cash flow and sale proceeds get distributed.
A market-standard middle market waterfall looks like this:
- Return of capital. All distributions first return 100 percent of contributed capital to the LPs.
- Preferred return (the pref). LPs receive a 7 to 9 percent annual preferred return on their unreturned capital, paid before any GP promote. The 8 percent pref is the most common single point.
- Catch up. Some structures give the GP a 50/50 or 80/20 catch up until the GP has received its target share of total profit. Many small and mid-cap deals skip this and go straight to the split.
- First promote tier. Cash flow above the pref splits 70/30 or 80/20 between LPs and GP. The 70/30 split after an 8 percent pref is the most common LP-friendly market standard.
- Second promote tier (the hurdle). Once total IRR clears a higher hurdle (often 15 to 18 percent), the split widens further in favor of the GP, often 60/40 or 50/50.
The promote (the GP’s share above the pref) is how operators get rich on outsized deals. A 30 percent promote on a $5M profit pool is $1.5M to the operating partner on top of acquisition and asset management fees. Read every operating agreement carefully. The waterfall mechanics are where the real economics live.
A Worked Example: Putting Real Estate Deal Analysis Into Practice
Assume a 120-unit Class B garden-style apartment property in a Sun Belt secondary market, listed at $18M, with a broker pro forma showing 5.9 percent cap rate.
Pass one: kill it fast. Broker NOI is $1,062,000. Pull tax records: assessed value $14.2M, current tax bill $192,000. At your $18M basis, reassessed taxes climb to $244,000 (Texas, 1.36 percent effective rate). That alone strips $52,000 from NOI. Re-quote insurance: agent comes back at $128,000 versus broker pro forma of $89,000. Another $39,000 gone. Adjusted NOI: $971,000. New cap rate at $18M: 5.4 percent, below the 5.8 to 6.2 percent submarket comp range from CoStar. The deal does not pencil at ask.
Pass two: counter at $16.3M. At $16.3M, the cap rate on adjusted NOI hits 5.95 percent, within market. Stress test the debt: 65 percent agency LTV is $10.6M at 6.1 percent, 30-year amortization, annual debt service $774,000. DSCR is 1.25x, exactly at the agency minimum. No cushion. Press the lender for a 60 percent LTV at a better rate, or push pref equity into the stack at a lower cost.
Pass three: model the exit. Five-year hold, year one NOI $971,000 growing 3 percent per year, exit cap 6.25 percent (50 basis points of expansion to be conservative), sale price $19.4M. After refinance proceeds in year three and exit distribution, levered IRR pencils at 14.2 percent with a 1.78x equity multiple. That clears most value-add LP hurdles, but only because you negotiated the price down.
This is the loop. Verify, normalize, stress test, and price the deal so the math survives. Disciplined real estate deal analysis costs you the deals that should not happen and wins you the ones that do.
Common Mistakes That Wreck Real Estate Deal Analysis
- Trusting broker T-12s. They are sales documents. Rebuild from bank statements and tax bills.
- Underwriting trophy assumptions. A 4 percent rent growth assumption holds in a strong submarket. Model 2 percent and 0 percent scenarios too.
- Ignoring property tax reassessment. Florida, Texas, Tennessee, and South Carolina reassess to sale price. Underwrite the new bill, not the old one.
- Floating rate without a rate cap. A 200 basis point rate move on $10M of bridge debt is $200,000 of annual cash flow. Buy the cap and budget the premium.
- Forgetting capital expenditures. Roof replacement at year seven, HVAC turnover at year 10, parking lot reseal at year five. Build a 10-year capex schedule and reserve against it.
- Skipping the lender call early. Talk to two or three lenders in the first 72 hours of diligence. They will tell you what is financeable before you waste a month on legal.
How CT Acquisitions Helps Founder-Operators Think About Real Estate Holdings
Many of the founder-led businesses we work with on the sell side carry significant real estate alongside their operating company. A 30-truck plumbing business with a 14,000 square foot owned shop. An HVAC roll-up sitting on three regional warehouses. A multi-location auto repair business with five owned parcels. The way the real estate gets structured at exit (sale-leaseback, separate transaction, retained ownership with a long-term lease to the buyer) often adds 15 to 30 percent to the total exit proceeds for the seller.
For deeper reading on how serious investors evaluate commercial holdings, see our companion guides on commercial real estate investing and what pros focus on, the best markets to invest in right now, and the cash flow lens at best cities for real estate investors looking for cash flow. For the operator view on what drives returns, read investment property evaluation and what actually drives returns.
If you are a founder thinking about how to sequence an operating company exit alongside real estate proceeds, use our free valuation tool to benchmark your business, then schedule a confidential call. We work with 40 plus capital partners and our buyers pay us at close, not you. Learn more about our capital partners network and how we match founder-operators to the right buyer.
FAQ: Real Estate Deal Analysis
What is the most important metric in real estate deal analysis?
Net Operating Income (NOI) is the single most important number because every other metric (cap rate, DSCR, IRR, valuation) depends on it. A $50,000 error in NOI moves your purchase price by roughly $700,000 at a 7 percent cap rate. Verify income from primary sources, normalize expenses to market, and stress test before trusting any pro forma.
What IRR should I target on a commercial real estate deal?
Institutional ranges by strategy: 8 to 12 percent for core stabilized assets, 12 to 18 percent for value-add, and 18 percent and above for opportunistic development or distressed plays. Compare the levered IRR to the equity multiple to confirm the deal is not just collecting a fast return on a small profit pool.
How much debt should I put on a commercial property?
Agency multifamily caps at 65 to 75 percent LTV, CMBS at 60 to 70 percent, and bank commercial product at 60 to 70 percent depending on asset class and sponsor strength. Bridge debt can reach 80 percent loan-to-cost on value-add, but model a stressed refinance scenario. The DSCR should clear 1.25x at minimum, with 1.40x preferred for cushion.
What data sources should I use to underwrite a commercial deal?
CoStar for office, industrial, retail, and multifamily lease and sale comps. RealCapitalAnalytics (MSCI Real Assets) for cap rate trends and transaction tracking. Reonomy for off-market ownership intelligence. REIS (Moody’s Analytics CRE) for submarket forecasts. Supplement with county recorder filings and tax assessor data for smaller deals.
How does a typical GP and LP waterfall work?
Most middle market deals return 100 percent of capital first, then pay LPs a 7 to 9 percent preferred return (the pref), then split remaining cash flow 70/30 or 80/20 in favor of LPs up to a higher IRR hurdle (often 15 to 18 percent), at which point the split widens further to the GP. The 8 percent pref with a 70/30 split after is the most common market structure.
What is the difference between a cap rate and an IRR?
Cap rate is the unlevered yield in year one (NOI divided by purchase price). IRR is the annualized total return over the full hold period including debt, rent growth, capital improvements, and the exit sale. Cap rate prices the asset today. IRR measures what you actually earned over time.
How do I stress test a commercial real estate pro forma?
Run three downside scenarios: flat rents for 24 months, 200 basis point exit cap rate expansion, and a 100 basis point interest rate increase on any floating-rate debt at refinance. If the deal still clears your minimum return hurdle in all three scenarios, you have a defensible underwrite. If it breaks in any one scenario, reduce price or pass.
What tax strategies should I use on commercial real estate?
Three primary tools: a 1031 exchange to defer capital gains on disposition, cost segregation studies to accelerate depreciation on acquisition, and bonus depreciation to expense short-life components. Bonus depreciation is phasing down (20 percent in 2026, 0 percent in 2027 absent further congressional action), so confirm current treatment with your tax advisor and the One Big Beautiful Bill Act provisions.
The Bottom Line on Real Estate Deal Analysis
Disciplined real estate deal analysis is the work most buyers will not do. Verifying every line of the rent roll, re-quoting insurance, calling three lenders before legal, modeling the downside, pricing the tax wedge accurately. That work is the moat. The buyers who run this loop on every deal compound. The buyers who trust the broker pro forma get washed out in the next cycle.
If you are evaluating a deal and want a second set of eyes on the underwrite, or you are a founder-operator thinking about how owned real estate fits into a larger business exit, book a confidential conversation with our team. No retainer, no exclusivity. Our 40 plus capital partners pay us at close.