IRR in Feasibility Studies: The Complete Guide for Developers, Investors, and Lenders

IRR in Feasibility Studies: The Complete Guide for Developers, Investors, and Lenders

The Internal Rate of Return is the discount rate that makes the Net Present Value of all cash flows, inflows and outflows, equal to zero. It answers the question every equity investor asks: what annualized growth rate will this investment generate over its entire life? IRR accounts for the time value of money, making a dollar received today worth more than a dollar received in five years. It is the preferred metric for developers and equity investors because it weaves acquisition cost, operating cash flows, capital improvements, financing structure, and exit proceeds into a single time-weighted annual return figure. This guide explains how IRR works in feasibility studies, current target benchmarks by strategy and property type, and the critical limitations every analyst should understand.

How IRR Differs from Other CRE Metrics

While the Debt Service Coverage Ratio measures a property's ability to pay its mortgage, IRR takes a fundamentally different perspective. Cap rate is a static, single-year yield snapshot that ignores debt, growth, and exit proceeds. Cash-on-cash return measures annual equity yield but ignores total returns and timing. ROI captures total profit but treats a dollar in Year 1 the same as a dollar in Year 10. Equity multiple shows total cash returned relative to invested equity but does not annualize or time-weight. Only IRR weaves all of these dimensions into a single comprehensive metric. That is why institutional investors, private equity firms, and lenders reviewing feasibility studies rely on IRR as the standard measure of investment performance.

Step-by-Step IRR Calculation

Consider a multifamily acquisition: $1M purchase price, $300K equity (70% LTV), Year 1 NOI of $68,000 growing at 2% annually, $42,000 annual debt service, and a Year 5 sale at $1.2M with 6% selling costs. Annual levered cash flows run from $26,000 in Year 1 to $30,765 in Year 5. Net sale proceeds after selling costs and loan payoff yield $495,976 in Year 5, making total Year 5 cash flow $526,741. Using Excel's IRR function on the series {-300000, 26000, 27360, 28747, 30162, 526741} produces a levered IRR of 18.45%. The same deal purchased all-cash produces an unlevered IRR of just 9.18%, demonstrating how 70% leverage nearly doubled the return to equity.

Current Target IRRs by Strategy and Risk Profile

Target IRRs in 2024 to 2025 align along the risk spectrum. Core strategies (stabilized, Class A assets in primary markets) target 7% to 10% levered IRR with less than 50% leverage and 1.3x to 1.5x equity multiples. Core-plus pushes to 8% to 12% with moderate leverage of 35% to 60% LTV. Value-add, the dominant institutional strategy, targets 13% to 18% levered IRR with 60% to 80% leverage and 1.7x to 2.2x equity multiples. Opportunistic strategies including ground-up development target 18% to 25% or higher with equity multiples of 2.0x to 3.0x or higher.

By property type, industry consensus levered target IRRs for 2024 to 2025 run approximately: industrial/logistics 16% to 20%, multifamily 12% to 18%, retail 14% to 18%, and office 12% to 16% (with wider risk premiums reflecting work-from-home uncertainty). Data center developments illustrate the highest IRR potential in CRE, with stabilized yields on construction exceeding 12% in major markets. Express car wash developments have attracted institutional capital precisely because membership-driven revenue produces predictable cash flows that improve IRR visibility. Cold storage facilities command premium IRRs due to construction costs that exceed $150 per square foot and correspondingly higher lease rates. Actual market returns have been challenging since 2022. The NCREIF NPI (tracking 12,767 institutional properties worth approximately $900 billion) returned just 0.59% total for full year 2024, though by Q2 2025, trailing four-quarter returns improved to 4.3%, led by data centers (12.8%), manufactured housing (11.9%), and retail (7.6%).

Levered vs. Unlevered IRR

Unlevered IRR isolates the property's intrinsic performance without financing influence. It uses the full purchase price as the initial outlay and NOI as annual cash flow, with no debt service or loan payoff. Appraisers and institutional investors prefer it for comparing properties on equal footing. Levered IRR measures return on equity actually invested, deducting debt service from cash flows and loan payoff from exit proceeds. It is more relevant for most investors and is used in waterfall calculations and deal marketing.

The spread between levered and unlevered IRR has compressed significantly in the current rate environment. During the cheap-debt era of the 2010s, levered IRR commonly ran approximately 2 times the all-cash return. With interest rates over 2 times higher in 2024 to 2025 and leverage levels lower, a realistic multiplier is 1.3x to 1.5x. When levered and unlevered IRRs show little separation, it signals that debt is barely accretive, a red flag that the financing cost is consuming most of the leverage benefit.

Exit Cap Rate: The Most Powerful IRR Driver

Terminal value typically constitutes 60% to 80% of total value in a DCF model, making exit cap rate the most powerful IRR driver. On a $20M acquisition at a 5.25% entry cap with 3% NOI growth over 5 years, exiting at the same 5.25% cap yields approximately 15% IRR. Shifting the exit cap just 50 basis points higher to 5.75% drops the sale price by $2M (8.7%) and collapses IRR to below 5%, a devastating 10-plus percentage point decline from a seemingly modest assumption change. As a rule of thumb, a 50-basis-point change in exit cap rate moves IRR by roughly 3 percentage points. Conservative underwriting adds 50 to 100 basis points above entry cap rate to account for cycle risk and asset aging.

Modified IRR: Solving the Reinvestment Assumption Problem

Traditional IRR assumes that all interim cash flows are reinvested at the IRR itself. If a project shows 18% IRR, the formula assumes every distribution earns 18% when reinvested, which is rarely realistic. Modified IRR (MIRR) addresses this by using explicit reinvestment and finance rates. The formula compounds positive cash flows forward at a specified reinvestment rate and discounts negative cash flows at a finance rate, then solves for the single rate connecting them.

In practice, MIRR typically produces lower returns than IRR because the reinvestment rate (often the cost of capital, around 8% to 10%) sits below the project's IRR. An investment producing 18.0% traditional IRR yields only 15.98% MIRR using a 10% reinvestment rate. MIRR also eliminates the multiple IRR problem, where traditional IRR can produce several mathematically valid solutions when cash flows change signs multiple times, common in development deals with mid-project capital expenditures. MIRR always produces a single answer.

IRR Limitations Every Analyst Should Understand

Beyond the reinvestment assumption, IRR suffers from scale independence: it provides a return rate without factoring investment size. A $7M investment yielding $21M has a higher IRR than $70M yielding $140M, but the latter generates far more absolute profit. An investment with 19.71% IRR and 1.85x equity multiple versus one with 16.37% IRR and 1.90x multiple may favor the lower-IRR deal due to higher absolute return.

IRR is also highly sensitive to timing manipulation. Sponsors can engineer higher IRRs by projecting shorter hold periods or front-loading distributions. A deal showing 20% IRR over 2 years might produce only 1.25x equity multiple, representing just $25,000 profit on a $100,000 investment. The antidote is always pairing IRR with equity multiple. Sophisticated investors evaluate both metrics together, understanding that short holds can inflate IRR while delivering modest absolute returns, and that longer holds produce lower IRR but much higher equity multiples of 1.8x to 2.5x.

How Lenders Use IRR in Feasibility Study Review

Lenders primarily rely on DSCR and LTV for underwriting decisions. IRR plays a secondary but meaningful role: it helps lenders assess project viability, evaluate whether sponsor return expectations are realistic, and stress-test profitability under downside scenarios. For SBA and USDA loans, feasibility studies must include DCF, IRR, NPV, DSCR, and break-even analysis. While neither agency publishes a specific minimum IRR threshold, projects must demonstrate positive IRR exceeding the cost of capital (currently approximately 7% to 9% for SBA loans), suggesting minimum viable IRRs in the 10% to 15% range for adequate feasibility demonstration.

Development Feasibility Demands a Premium

Development deals target 15% to 20% or higher levered IRR (unlevered 10% to 12%) to compensate for construction risk, entitlement uncertainty, lease-up risk, and the J-curve effect of negative cash flows during the 1 to 3 year construction period. Return on cost (yield on cost) must exceed going-in cap rate by 100 to 200 or more basis points to justify development risk. By contrast, core acquisitions target 7% to 10% with immediate positive cash flow from Day 1. The key metric alongside IRR for development is return on cost; for acquisitions, it is cap rate and cash-on-cash return.

Waterfall Structures and IRR Hurdles in Equity Partnerships

Real estate equity waterfalls distribute cash through tiered hurdles that reward sponsors for outperformance. The dominant industry standard is an 8% preferred return paid to LPs before GPs receive any promoted interest. Approximately 85% of all real estate waterfall hurdles use IRR as the trigger metric.

A typical four-tier structure operates as follows: Tier 1 returns capital plus 8% preferred return at a 90/10 LP/GP split. Tier 2, up to approximately 10% to 12% IRR, splits 80/20. Tier 3, up to approximately 15% IRR, splits 70/30. Tier 4, above approximately 20% IRR, splits 60/40.

The promote dramatically amplifies GP returns: in documented cases, LPs achieve 15.4% IRR while GP's effective IRR reaches 46.2% after promote. Most deals (approximately 75%) use two equity split tiers rather than four. Catch-up provisions allow 50/50 splits above the pref until the GP catches up to target allocation, while clawback provisions protect LPs by requiring GPs to return excess distributions if the fund ultimately underperforms.

Shorter Hold Periods Amplify IRR Through Mathematical Compression

Because IRR is time-weighted, receiving the same total profit over a shorter period produces a higher annualized rate of return. Two investments producing identical $250M total cash flows but different timing can show materially different IRRs: the one with larger early distributions yields 13.82% IRR versus 12.63% for the later-weighted alternative, a 119-basis-point difference despite identical equity multiples. This creates the IRR-equity multiple trade-off that every feasibility study must transparently present: short holds can show 20% or higher IRR but modest 1.3x to 1.5x multiples, while longer holds produce lower 8% to 12% IRR but much higher 1.8x to 2.5x multiples.

IRR calculations depend on the DCF framework detailed in our income approach guide. The cost approach establishes the total investment against which IRR is measured.

For lenders and investors evaluating projects in this sector, UnionMetric provides independent SBA feasibility study services that meet SBA and USDA requirements.

Sources

1. J.P. Morgan, What is Internal Rate of Return in Commercial Real Estate
2. RealData, Levered vs. Unlevered IRR: What Real Estate Investors Need to Know
3. NCREIF, NPI Q4 2024 Press Release and RCLCO Q2 2025 ODCE Summary
4. PropertyMetrics, How to Use the Modified Internal Rate of Return (MIRR)
5. Bonfire Capital, Understanding Cap Rates and Why [Sensitivity Analysis](/insights/sensitivity-analysis-feasibility-studies-guide) is Critical
6. GowerCrowd, Your Ultimate Guide to Real Estate Waterfalls
7. Syndicationattorneys.com, What Returns Do Real Estate Investors Want in 2025
8. FNRP, Equity Multiple vs. IRR: Private Equity Real Estate Returns
9. Break Into CRE, Real Estate Investment Return Targets to Shoot For