Feasibility Studies & Pro Formas | Development Series

A client asked for a review his pro forma for a 48-unit apartment building. The internal rate of return (IRR) was 22%. The deal looked great — until the team changed two assumptions: rents grew 2% instead of 4%, and his exit cap rate went up by 50 basis points. IRR dropped to 6.8%. He hadn't run sensitivity. He wired the deposit anyway. Three years later, rents grew 1.7%, cap rates moved up 75 basis points, and his actual IRR was negative. He sold the building at a loss. The pro forma was technically correct on the day he ran it. It just told him what he wanted to hear, not what he needed to know. Today: how feasibility studies and pro formas actually work, the five return metrics you must understand, why sensitivity analysis is non-negotiable, and how to make confident go/no-go decisions before you commit capital.

Why a Pro Forma Is Either Your Best Friend or Your Biggest Lie

Financial modeling is the disciplined translation of assumptions into go/no-go decisions

A pro forma is a financial model that projects what a real estate investment will earn. A feasibility study is the broader analysis that wraps the pro forma — covering market demand, physical constraints, regulatory feasibility, and risk.

Both are only as honest as the assumptions you feed them. Garbage in, garbage out — and most pro formas are full of garbage no one bothered to question.

The Five Sections of Every Pro Forma

Every real estate pro forma — from a single-family flip to a billion-dollar tower — has the same five-part structure. What changes is the depth and number of assumptions in each section.

Figure 1 — The five sections of a pro forma. Errors anywhere in sections 1–4 propagate through every return metric in section 5.

ℹ What Each Section Actually Models

PROJECT ASSUMPTIONS: Physical scope — site area, GBA, NLA, unit mix, timeline. The foundation everything else stands on.

DEVELOPMENT COST: Land + hard costs + soft costs + financing = Total Development Cost (TDC). Most common error: under-budgeted soft costs.

REVENUE PROJECTION: Stabilized income at lease-up. The single most common source of overstated returns.

OPERATING ANALYSIS: Income minus vacancy and operating expenses = Net Operating Income (NOI).
RETURN METRICS: How investors evaluate the deal — yield-on-cost, IRR, equity multiple, cash-on-cash.

The Five Return Metrics — What Each One Actually Tells You

Different metrics, different stories — and why most investors only look at one

If you only know one return metric, you're being lied to by the other four. Each metric measures something different about a deal — and skilled investors look at all of them together.

Figure 2 — The five return metrics every investor should understand. Each tells a different story about the same deal.

Why You Need All Five — Not Just IRR

Yield on Cost (YoC) shows whether you're creating value: Compares your stabilized NOI to your total

cost. If YoC is 100–150 bps above market cap rate, you're creating real value. If YoC equals market cap rate, you're just building what you could have bought.

IRR measures time-weighted return — but can be gamed: IRR depends heavily on assumed exit timing

and price. Aggressive exit assumptions inflate IRR; long hold periods can mask weak operating performance. Always ask what assumptions drive the IRR.

Equity Multiple ignores time — but it's honest about dollars: A 2.0x equity multiple means you doubled your money. Whether it took 3 years (great) or 12 years (mediocre), you doubled your money. Use it alongside IRR to keep yourself honest.

Cash-on-Cash captures current return only: Annual cash flow divided by equity. Doesn't include

appreciation, refinancing proceeds, or future sale. Income investors live by this metric; growth investors ignore it.

Cap Rate is a market-pricing tool, not an investor return: Cap rate is unleveraged yield at market price. It's how you price properties, not how you measure your own return on equity. Don't confuse the two.

⚠ The IRR Trap — Why High IRR Can Be a Warning Sign

30%+ IRR on a development deal usually means optimistic assumptions, not a great deal
Short hold periods (<3 years) inflate IRR even on modest dollar returns
High exit cap rate compression boosts IRR — but rarely materializes in declining markets
Negative IRR years early are smoothed by huge exit proceeds — examine the cash flow shape
Side-by-side IRR comparisons are meaningless without identical exit and timing assumptions

Sensitivity Analysis: The Most Skipped, Most Important Step

Stress testing the assumptions that actually matter

If your deal works only at base case, your deal doesn't work. Real markets don't deliver base case. They deliver some combination of slightly worse rents, slightly higher costs, slightly later lease-up, and slightly worse exit cap rates.

Figure 3 — Tornado chart showing IRR sensitivity to each assumption (left); 2-way matrix showing how rents and cap rates combine (right).

How to Run Sensitivity Analysis Correctly

Identify the top 5–7 assumptions: Use a tornado chart to rank assumptions by impact on IRR. Construction cost, stabilized rent, and exit cap rate almost always top the list. Operating expenses and vacancy rate usually matter less than people think.

Set realistic stress ranges: Don't test trivial movements. Test ±10% on costs and rents, ±25–50 basis points on cap rates, and 3–6 month delays on lease-up. If you can't survive these, you can't survive the real world. © 2026 Construction Science Forensics • Page 4 of 9

Run 2-way sensitivities for the biggest pairs: Rents × cap rate is the classic 2-way matrix. Construction cost × lease-up timing is another critical pair. The matrix shows you the cliffs where your IRR collapses.

Stress the downside, not just the upside: Investors love showing what happens if cap rates compress 50 bps. The harder question is what happens if they expand 50 bps AND rent growth is half of forecast.

Identify your break-even cases: What rent decline takes your deal to break-even? What construction

overrun? What exit cap rate? Knowing these numbers tells you exactly how much headroom you have.

Build downside protection into the deal: If sensitivity shows your deal dies at -10% rents, structure the deal so you can survive that — preleasing, lower leverage, longer-term debt, or operating reserves.

⚠ Sensitivity Analysis Done Wrong

Testing ±2% changes that don't actually stress the model
Running only single-variable sensitivity, ignoring how variables move together
Treating sensitivity as a checkbox instead of a decision-making tool
Using the optimistic scenario as the 'base case' for marketing purposes
Skipping construction cost sensitivity because contracts 'lock in' the price (they often don't)
Assuming exit cap rates stay flat or compress — they more often expand

⚠ Specific Errors Forensic Review Catches

Per-unit / per-sf cost benchmarks don't reconcile to local construction market data
Soft costs assumed at 12–15% when local norms are 18–22% (especially in California, NY)
Stabilized rents 10–15% above current top-of-market comps with no clear product premium
Lease-up modeled at 6 units/month when comparable projects achieved 3–4
No reserve for capital expenditures (TI, leasing commissions, replacement reserves)
Construction interest reserve calculated on average balance, not peak balance
Exit cap rate equal to entry cap rate (assumes no spread for risk over hold period)
No accounting for lender required debt service coverage (DSCR) at refi

Commercial vs. Residential: How Pro Forma Discipline Differs

Same math, dramatically different stakes, and complexity

Both commercial developers and residential buyers do financial analysis. The difference is depth, formalization, and how much capital is at risk if the analysis is wrong. AREA

🏢🏢 COMMERCIAL

🏠🏠 RESIDENTIAL

Analysis Formality

Multi-tab Excel models, third-party review, sensitivity analysis, Monte Carlo simulation

Simple cash-on-cash calculation, mortgage

payment vs. rent, ROI estimate

Analysis Cost

$10,000–$100,000+ for full feasibility & financial modeling on major projects

$0–$2,500 (often DIY using online calculators or broker spreadsheets)

Time Horizon

5–10 year hold period with explicit exit

modeling; sometimes longer for institutional investors

Typically 3–7 year hold; less rigorous about

explicit exit assumptions

Lender Review

Pro forma scrutinized by lender's underwriters; modifications often required to secure debt

Lender focuses on borrower DTI, property cash

flow, and appraisal — not buyer's projections

Sensitivity Required

Tornado chart, 2-way matrices, downside cases

standard for investment committees

Rarely formal; sometimes 'what if rents drop

5%' check; often skipped entirely

Common Failure

Mode

Aspirational stabilized rents, under-budgeted

soft costs, optimistic lease-up, flat exit cap

Underestimated repair budget, optimistic

appreciation assumption, ignored capex reserves

Decision Process

Investment committee review with formal

go/no-go criteria and pro forma approval

Individual buyer + spouse + sometimes

mortgage broker; emotional decision-making common

Real-World Miss Rate

70% of deals miss pro forma IRR by 200+ basis

points

60–70% of residential investors realize lower

returns than projected

Key Insight: Residential Investors Need Pro Formas Too

If you're buying a property to rent out — even a single-family home — you should run a real pro forma. The math doesn't care that you're a small investor. Aspirational rents kill residential deals every bit as fast as they kill commercial ones.

The Forensic Pro Forma Due Diligence Checklist

Side-by-side verification items before you commit capital

These are the items skilled underwriters verify before — and after — any go/no-go decision. Forensic review tests every assumption against external evidence. 🏢🏢 COMMERCIAL

🏠🏠 RESIDENTIAL

☑ Hard cost benchmarked to local $/sf data (RSMeans,

☑ Comparable rents verified (3+ similar properties)

Marshall & Swift)

☑ Soft cost ratio verified against local market norms ☑ Construction contingency 5%+ of hard costs

☑ Construction interest calculated on peak balance

☑ Stabilized rents within 5% of comparable properties

☑ Lease-up curve matched to comparable project history ☑ Operating expenses within market range ($/sf)

☑ Exit cap rate >= current entry cap rate (room for expansion)

☑ Multiple sensitivity scenarios run (tornado + 2-way) ☑ Downside case: -10% rent, +10% cost, +50bps cap ☑ Debt service coverage at refi clearly modeled

☑ Capital reserves (TI, LC, replacement) included

☑ Pro forma reviewed by independent third party

☑ Vacancy assumption based on local market data

☑ All operating expenses listed (not just mortgage)

☑ Property tax based on POST-acquisition assessed value ☑ Insurance quote obtained (not estimated)

☑ Capex reserve included (1–2% of property value/yr) ☑ Property management fee budgeted (8–10%) ☑ Repair / turnover reserve included

☑ Sensitivity test: rents -10%, vacancy +5%

☑ Exit assumption based on conservative cap rate

☑ Tax implications modeled (depreciation, gain on sale) ☑ All-in return compared to alternative investments ☑ Worst-case: can you carry it if vacant 6 months?

☑ Decision based on numbers, not just enthusiasm

☑ Investment committee or partner sign-off documented

Real-World Cases: When Pro Forma Discipline Mattered Most

Composite scenarios from commercial and residential transactions 🏢🏢 COMMERCIAL

The Apartment Building That 'Couldn't Lose'

Investor's pro forma showed 22% IRR on a 48-unit apartment acquisition. Forensic review identified three issues: stabilized rents 12% above the highest comp, operating expenses 18% below local market, and a flat 5.0% exit cap rate vs. an entry of 5.0%. After correcting only the rent assumption to market comp levels, IRR fell to 11.4%. Adding realistic OpEx and 50 bps cap expansion brought it to 6.8%. OUTCOME: Investor renegotiated price down by $1.4M based on corrected pro forma. Deal closed at acceptable returns. Without forensic review: would have closed at original price; actual returns matched the corrected (not original) pro forma. 🏠🏠 RESIDENTIAL

The Out-of-State Rental That Bled Cash

Buyer purchased a $385K 'turnkey' rental in another state based on broker's pro forma showing 9.2% cash-oncash return. Forensic review (had it been done) would have caught: rent $200/mo above market, no vacancy assumption, property management fee missing, no capex reserve, and property tax based on prior owner's assessed value (which would reset on sale). OUTCOME: Actual cash-on-cash in year 1: -2.1%. Property carried negative cash flow for 4 years. Buyer eventually sold at a loss. A 2-hour pro forma forensic review would have flagged every error before purchase. 🏢🏢 COMMERCIAL

The Industrial Project That Worked Because Sensitivity Said It Would

Developer evaluated a 250,000 sq ft industrial project. Base case IRR was 16.8%. Sensitivity analysis showed: deal still produced 13.2% IRR even with rents 10% below forecast, costs 10% above budget, and 3-month leaseup delay. Combined downside case still cleared the 12% hurdle rate. Investment committee approved. OUTCOME: Project hit roughly 80% of base case assumptions in reality. Final IRR: 14.1%. The sensitivity analysis showed the deal could withstand the actual conditions before they happened. Forensic underwriting transformed risk-taking into informed risk acceptance.

Key Takeaways for Investors & Their Advisors

✓ Action Items Before You Commit Capital

Build or commission a real pro forma for any investment property — even single-family rentals

Verify every revenue assumption against at least 3 comparable properties' actual rents
Verify every cost assumption against external benchmarks (RSMeans, broker BOV, local market data)
Run sensitivity analysis on the top 5 assumptions — minimum tornado chart and 2-way matrix
Test the downside case: -10% rent, +10% cost, +50 bps cap — can the deal survive?
Look at all five return metrics together, not just IRR — they tell different parts of the story
Have a qualified third party review your pro forma before any major commercial commitment
Document your go/no-go criteria BEFORE you analyze any specific deal
When the pro forma tells you what you want to hear, ask harder questions

"What's the most surprising pro forma error you've caught — or wished you had caught? Share your story in the comments."

Back to home Request an investigation