Study guide
4.1 Internal Rate of Return (IRR) Mechanics, Limitations & MIRR
Certified Commercial Investment Member CCIM
Track your progress as you read
Finished sections get a check mark.
1 Getting Started: The CCIM Designation & Comprehensive Exam
About the CCIM Comprehensive Exam
2 Chapter 1: Time Value of Money & Cash Flow Modeling
1.1 Core Time Value of Money Principles & Compounding Dynamics 1.2 Annuity Mechanics, Sinking Funds & Loan Amortization Mathematics 1.3 The CCIM Cash Flow Model: From Gross Potential Income to BTCF
3 Chapter 2: Debt Financing, Cash-on-Cash Return & Direct Capitalization
2.1 Debt Financing Metrics: DCR, LTV & Maximum Loan Sizing 2.2 Cash-on-Cash Return & First-Year Equity Dividend Rates 2.3 Direct Capitalization & Capitalization Rate Derivation
4 Chapter 3: Advanced Capitalization & Mortgage-Equity Valuation
3.1 Band of Investment Technique (Debt & Equity Components) 3.2 Mortgage-Equity Analysis & The Ellwood Formulation 3.3 Discounted Cash Flow (DCF) Modeling & Net Present Value (NPV)
5 Chapter 4: Yield Metrics & After-Tax Investment Analysis
4.1 Internal Rate of Return (IRR) Mechanics, Limitations & MIRR 4.2 Commercial Real Estate Tax Fundamentals & MACRS Cost Recovery 4.3 After-Tax Cash Flow (ATCF) & After-Tax Equity Reversion (ATER) 4.4 Capital Accumulation & the Annual Growth Rate of Capital (AGRC)
6 Chapter 5: Market Fundamentals & Economic Base Analysis
5.1 The CCIM Strategic Analysis Model & Market Delineation 5.2 Economic Base Theory: Basic vs. Non-Basic Employment Dynamics 5.3 Location Quotient (LQ) & Economic Base Multipliers
7 Chapter 6: Supply, Demand & Trade Area Dynamics
6.1 Supply Analysis: Inventory, Pipeline & Competitor Benchmarking 6.2 Demand Modeling, Absorption Metrics & Market Slack 6.3 Trade Area Delineation: Primary, Secondary & Tertiary Zones
8 Chapter 7: Demographics, Site Evaluation, Regulatory Due Diligence & Geospatial Analysis
7.1 Psychographic & Demographic Profiling with Esri Tapestry Segmentation 7.2 Physical Site Evaluation, Ingress/Egress & Accessibility 7.3 Zoning, Land-Use Entitlements & Environmental Screening 7.4 Geospatial Analysis: Intellisite, Drive-Time Trade Areas & Retail Gap Modeling
9 Chapter 8: Commercial Sector Market Analysis: Office, Industrial, Retail & Multifamily
8.1 Office Sector Dynamics: Space Utilization, Classes & Submarket Drivers 8.2 Industrial & Logistics Facilities: E-Commerce, Clear Heights & Intermodal Hubs 8.3 Retail Trade Analysis: Reilly's Law, Huff Gravity Model & Sales Thresholds 8.4 Multifamily Analytics: Demographics, Household Formation & Concession Impact
10 Chapter 9: User Foundations, Space Measurement & Commercial Lease Types
9.1 The User Perspective vs. The Investor Perspective 9.2 Space Measurement Standards: BOMA Usable vs. Rentable Area & Load Factors 9.3 Commercial Lease Types: Gross, Modified Gross, Single, Double & Triple Net
11 Chapter 10: Expense Allocations, Percentage Rent & Comparative Lease Analysis
10.1 Expense Stops, Base Year Adjustments & Operating Expense Escalations 10.2 Retail Percentage Rent, Natural & Unnatural Breakpoints 10.3 Comparative Lease Analysis: Effective Rent & Net Present Cost Modeling
12 Chapter 11: Lease vs. Purchase Analysis & Sale-Leaseback Transactions
11.1 Cost of Capital & Appropriate Discount Rates for User Decisions 11.2 Structuring the Lease vs. Purchase Decision Framework 11.3 Sale-Leaseback Mechanics, Underwriting & Capital Optimization
13 Chapter 12: Lease Buyouts, Accounting Standards (ASC 842) & Interest-Based Negotiations
12.1 Early Lease Buyout Valuation & Surrender Premium Formulas 12.2 Corporate Lease Accounting (ASC 842 / IFRS 16) & Balance Sheet Impact 12.3 Interest-Based Negotiations in Commercial Leasing
14 Chapter 13: The Investment Lifecycle, Annual Review & Capital Decisions
13.1 The Real Estate Investment Lifecycle & Holding Period Optimization 13.2 Annual Property Performance Auditing & Variance Analysis 13.3 Refinancing Decisions & Capital Extraction Analysis
15 Chapter 14: Renovations, Disposition Timing & Leverage Dynamics
14.1 Value-Add Renovation Underwriting & Incremental Yield 14.2 Optimal Disposition Timing & Marginal Rate of Return (MRR) Analysis 14.3 Leverage Dynamics: Positive, Neutral & Negative Leverage
16 Chapter 15: Risk Quantification, Sensitivity Analysis & 1031 Exchange Fundamentals
15.1 Risk Analysis Frameworks: Sensitivity, Scenario & Monte Carlo Modeling 15.2 IRC Section 1031 Tax-Deferred Exchange Rules, Deadlines & Boot 15.3 Advanced 1031 Structures: Reverse, Construction & Delaware Statutory Trusts
17 Chapter 16: Syndication Waterfalls, Portfolio Strategy & Investment Committee Due Diligence
16.1 Real Estate Syndication, Promote Structures & Waterfall Distributions 16.2 Modern Portfolio Theory (MPT) & Diversification in Commercial Real Estate 16.3 Investment Committee Due Diligence, Underwriting Packages & Synthesis
4.1 Internal Rate of Return (IRR) Mechanics, Limitations & MIRR
Key Takeaways Explain This Topic AI
The Internal Rate of Return (IRR) is the exact discount rate that sets the Net Present Value (NPV) of all cumulative project cash flows and net terminal reversion equal to zero, equating present value directly to initial equity outlay.
Unlevered Property IRR evaluates property-level operational performance against total asset cost, whereas Levered Equity IRR ( Y e Y_e Y e ) evaluates distributions and equity reversion against initial equity invested.
The fundamental theoretical flaw of standard IRR is the Reinvestment Rate Fallacy: the mathematical algorithm implicitly assumes that all interim cash distributions are continually reinvested throughout the remaining holding period at the project's own IRR rather than the investor's actual cost of capital.
Non-normal cash flow profiles characterized by multiple sign changes (such as negative cash flows mid-holding period for major tenant improvements or capital replacements) can generate multiple internal rates of return under Descartes' Rule of Signs, or yield no real mathematical solution.
The Modified Internal Rate of Return (MIRR) resolves both the reinvestment rate fallacy and the multiple-IRR anomaly by discounting negative cash outflows to Year 0 at a financing rate ( r f r_f r f ) and compounding positive cash inflows to Year n n n at an explicit reinvestment rate ( r r r_r r r ).
Last updated: September 2026
4.1 Internal Rate of Return (IRR) Mechanics, Limitations & MIRR
Note
The Benchmark Multi-Period Yield : The Internal Rate of Return (IRR) serves as the universal performance benchmark in institutional commercial real estate. While direct capitalization rates capture single-year snapshot yields, the IRR synthesizes multi-year interim operating cash flows and terminal capital appreciation into a single annualized compound return. However, uncritical reliance on IRR without understanding its mathematical assumptions exposes underwriters to severe capital allocation errors.
In institutional commercial investment underwriting, capital allocations are evaluated on a multi-period discounted cash flow (DCF) basis. While single-period metrics such as overall capitalization rates ( R o R_o R o ) and equity dividend rates ( R e R_e R e ) provide rapid initial screening, they cannot capture lease expirations, capital improvement programs, debt amortizations, or exit cap rate expansions over a 5-to-10-year investment lifecycle. The Internal Rate of Return (IRR) quantifies total investment yield across time, combining annual operational yields with capital appreciation upon eventual disposition.
The Mathematical Definition of IRR
Mathematically, the Internal Rate of Return is the specific discount rate ( Y Y Y or r r r ) that equates the sum of the present values of all anticipated future cash inflows—interim cash flows and net disposition reversion—to the initial equity outlay. Equivalently, the IRR is the discount rate at which the project's Net Present Value (NPV) equals exactly zero : N P V = ∑ t = 1 n C F t ( 1 + I R R ) t + R E V n ( 1 + I R R ) n − C F 0 = 0 NPV = \sum_{t=1}^{n} \frac{CF_t}{(1 + IRR)^t} + \frac{REV_n}{(1 + IRR)^n} - CF_0 = 0 NP V = t = 1 ∑ n ( 1 + I RR ) t C F t + ( 1 + I RR ) n RE V n − C F 0 = 0
Where:
- C F 0 CF_0 C F 0 = Initial equity outlay at acquisition ( t = 0 t = 0 t = 0 )
- C F t CF_t C F t = Net operational cash flow received at the end of period t t t
- R E V n REV_n RE V n = Net terminal cash reversion realized upon property disposition at year n n n
- n n n = Total duration of the investment holding period in years
- I R R IRR I RR = The internal discount rate solving the equality
Rearranging the equation demonstrates that the initial investment equals the present value of future benefits discounted at the IRR: C F 0 = ∑ t = 1 n C F t ( 1 + I R R ) t + R E V n ( 1 + I R R ) n CF_0 = \sum_{t=1}^{n} \frac{CF_t}{(1 + IRR)^t} + \frac{REV_n}{(1 + IRR)^n} C F 0 = t = 1 ∑ n ( 1 + I RR ) t C F t + ( 1 + I RR ) n RE V n
If an investor's required hurdle rate (opportunity cost of capital, k k k ) is lower than the computed IRR ( k < I R R k < IRR k < I RR ), the project generates an N P V > 0 NPV > 0 NP V > 0 , indicating that the investment adds economic wealth. If k > I R R k > IRR k > I RR , the project generates an N P V < 0 NPV < 0 NP V < 0 , failing to meet the investor's minimum yield threshold.
Unlevered Property IRR vs. Levered Equity IRR
Commercial investment analysts evaluate two distinct tiers of return across the capital structure: Unlevered Property IRR ( I R R p IRR_p I R R p ) and Levered Equity IRR ( Y e Y_e Y e or I R R e IRR_e I R R e ):
Feature Unlevered Property IRR ( I R R p IRR_p I R R p ) Levered Equity IRR ( Y e Y_e Y e / I R R e IRR_e I R R e )
Capital Base ( C F 0 CF_0 C F 0 ) Total Acquisition Cost (Purchase Price + Capitalized Closing Costs) Initial Equity Deployed (Total Acquisition Cost minus Debt Proceeds)
Interim Cash Flows ( C F t CF_t C F t ) Cash Flow Before Debt Service ( C F B D S CFBDS CFB D S ), equivalent to Net Operating Income ( N O I NOI NO I ) minus recurring CapEx Cash Flow Before Taxes ( C F B T CFBT CFBT ), equivalent to C F B D S CFBDS CFB D S minus Annual Debt Service ( A D S ADS A D S )
Terminal Reversion ( R E V n REV_n RE V n ) Net Sales Proceeds ( N S P NSP NSP ), defined as Gross Sales Price minus selling expenses Before-Tax Equity Reversion ( B T E R BTER BTER ), defined as N S P NSP NSP minus Unpaid Mortgage Balance
Analytical Objective Measures intrinsic asset-level economic performance independent of financing structure Measures actual financial return achieved by the equity investor after servicing debt obligations
The Impact of Financial Leverage on Multi-Year Yield
The relationship between unlevered property return and borrowing cost dictates the levered equity return: I R R e = I R R p + ( V M V E ) × ( I R R p − K d ) IRR_e = IRR_p + \left(\frac{V_M}{V_E}\right) \times (IRR_p - K_d) I R R e = I R R p + ( V E V M ) × ( I R R p − K d )
Where V M / V E V_M / V_E V M / V E is the debt-to-equity ratio and K d K_d K d is the effective cost of debt capital over the holding period:
Positive Financial Leverage ( I R R p > K d IRR_p > K_d I R R p > K d ) : Debt capital costs less than the underlying asset yields. Borrowing elevates the equity yield ( I R R e > I R R p IRR_e > IRR_p I R R e > I R R p ). Increasing the loan-to-value ratio amplifies the equity return.
Neutral Financial Leverage ( I R R p = K d IRR_p = K_d I R R p = K d ) : Debt financing costs exactly equal property yield. Leverage neither helps nor harms the equity return ( I R R e = I R R p IRR_e = IRR_p I R R e = I R R p ).
Negative Financial Leverage ( I R R p < K d IRR_p < K_d I R R p < K d ) : Debt costs exceed property yield. Debt service drains property cash flow faster than the asset generates income, diluting equity returns ( I R R e < I R R p IRR_e < IRR_p I R R e < I R R p ).
Iterative Polynomial Solving & Numerical Approximation
Unlike direct capitalization formulas that can be solved algebraically in a single step ( R o = N O I / V R_o = NOI / V R o = NO I / V ), the IRR equation is an n n n -th degree polynomial equation. Under the Abel-Ruffini Theorem , general polynomial equations of degree five or higher cannot be solved in closed form through standard algebraic operations.
Consequently, financial calculators (such as the HP-12C and TI BA II Plus) and spreadsheet software utilize numerical algorithms—predominantly the Newton-Raphson method —to solve for IRR iteratively. The algorithm starts with an initial seed guess ( r 0 r_0 r 0 ), evaluates the slope of the NPV function ( f ′ ( r ) f'(r) f ′ ( r ) ), and recalculates successive approximations until the change in rate is smaller than a pre-set tolerance: r k + 1 = r k − f ( r k ) f ′ ( r k ) r_{k+1} = r_k - \frac{f(r_k)}{f'(r_k)} r k + 1 = r k − f ′ ( r k ) f ( r k )
When a calculator displays a momentary delay or running indicator, it is executing dozens of iterative loops. If the cash flow series is highly irregular, the algorithm may fail to converge, triggering calculator error messages such as Error 5 on the HP-12C.
The Critical Limitations of Standard IRR
Despite its ubiquitous use, standard IRR possesses four severe theoretical and practical vulnerabilities that can lead to flawed investment decisions:
1. The Reinvestment Rate Fallacy
The most significant flaw of standard IRR is its built-in reinvestment assumption. The mathematical formulation of IRR implicitly assumes that all interim cash distributions are immediately and continuously reinvested across the remainder of the holding period at the project's own internal rate of return .
Consider an opportunistic repositioning project generating an IRR of 28.0% . The mathematical model assumes that operational cash distributions received at the end of Year 1 can immediately be redeployed into another asset earning exactly 28.0% compound annual yield through Year 5. In reality, investors reinvest operational dividends into safe liquid reserves, money market funds, or core acquisitions yielding 5.0% to 8.0%. Assuming reinvestment at 28.0% drastically overstates the true wealth accumulation of the investor.
In contrast, Net Present Value (NPV) assumes that interim cash flows are reinvested at the investor's opportunity cost of capital (the discount rate), which is a far more realistic assumption for capital budgeting.
2. Project Scale / Capital Commitment Disparity
IRR is an intensive percentage rate of return; it measures yield efficiency per dollar invested, but completely ignores absolute dollar magnitude. Comparing mutually exclusive investments solely by IRR produces misleading conclusions:
Project Alpha : Requires $1,000,000 equity; generates a 25.0% IRR ; produces $350,000 NPV at a 10% discount rate.
Project Beta : Requires $20,000,000 equity; generates a 16.0% IRR ; produces $3,200,000 NPV at a 10% discount rate.
Ranking by IRR selects Project Alpha because 25.0% exceeds 16.0%. However, Project Beta creates $3,200,000 in net dollar wealth above the firm's opportunity cost of capital—nearly ten times the dollar profit of Alpha. Investors cannot spend percentage rates; they distribute dollar wealth.
3. Timing and Front-Loading Sensitivity
IRR is disproportionately sensitive to early cash receipts due to compounding discount factors. A project that generates large distributions in Years 1 and 2 followed by modest terminal appreciation can produce a higher IRR than an asset that compounds equity steadily to deliver massive terminal gains in Year 5, even when the latter produces significantly greater total dollar profit.
4. Multiple IRRs and Non-Normal Cash Flows
A standard or "normal" cash flow pattern begins with an initial outflow (negative) followed exclusively by positive cash inflows: ( − , + , + , + , + ) (-, +, +, +, +) ( − , + , + , + , + ) . For normal cash flows, there is exactly one unique, positive real root solving the IRR equation.
However, commercial real estate frequently exhibits non-normal cash flows ( − , + , + , − , + , + ) (-, +, +, -, +, +) ( − , + , + , − , + , + ) . Significant mid-holding period capital outlays—such as major roof replacements, chiller plant overhauls, environmental remediation, anchor tenant lease buyout buybacks, or extensive tenant improvement (TI) packages—can cause annual net cash flow to turn negative.
Under Descartes' Rule of Signs , a polynomial equation can possess as many positive real roots as there are sign changes in the sequence of its coefficients. If cash flow signs reverse multiple times, the equation can yield multiple different IRRs that each mathematically set NPV to zero, or it can yield no real mathematical solution at all.
Loading diagram...
Figure 4.1: Non-Normal Cash Flow Profile with Multiple Sign Changes (- to +, + to -, - to +), triggering multiple mathematical IRR roots.
The Modified Internal Rate of Return (MIRR)
To overcome both the reinvestment rate fallacy and the multiple-IRR dilemma, institutional analysts utilize the Modified Internal Rate of Return (MIRR) . MIRR resolves these deficiencies by establishing two explicit, realistic external interest rates:
Financing Rate ( r f r_f r f ) : The cost of borrowing or safe liquid rate used to discount negative future cash flows back to Year 0.
Reinvestment Rate ( r r r_r r r ) : The realistic opportunity cost of capital or money market yield used to compound positive interim cash flows forward to the terminal year ( n n n ).
The Three-Step MIRR Procedure
Step 1: Discount Negative Cash Flows to Year 0 :
All negative cash flows across the holding period are discounted back to present value at the financing rate ( r f r_f r f ) and added to the initial equity outlay to form the total present investment outlay: P V outflows = C F 0 + ∑ t = 1 n max ( 0 , − C F t ) ( 1 + r f ) t PV_{\text{outflows}} = CF_0 + \sum_{t=1}^{n} \frac{\max(0, -CF_t)}{(1 + r_f)^t} P V outflows = C F 0 + t = 1 ∑ n ( 1 + r f ) t max ( 0 , − C F t )
Step 2: Compound Positive Cash Flows to Year n n n :
All positive cash inflows are compounded forward to the terminal year ( n n n ) at the explicit reinvestment rate ( r r r_r r r ) to calculate the terminal accumulated value ( F V inflows FV_{\text{inflows}} F V inflows ): F V inflows = ∑ t = 1 n max ( 0 , C F t ) × ( 1 + r r ) n − t FV_{\text{inflows}} = \sum_{t=1}^{n} \max(0, CF_t) \times (1 + r_r)^{n - t} F V inflows = t = 1 ∑ n max ( 0 , C F t ) × ( 1 + r r ) n − t
Step 3: Solve for the Single Compound Growth Rate (MIRR) :
MIRR is the unique discount rate that equates P V outflows PV_{\text{outflows}} P V outflows to F V inflows FV_{\text{inflows}} F V inflows over n n n periods: P V outflows = F V inflows ( 1 + M I R R ) n PV_{\text{outflows}} = \frac{FV_{\text{inflows}}}{(1 + MIRR)^n} P V outflows = ( 1 + M I RR ) n F V inflows M I R R = ( F V inflows P V outflows ) 1 n − 1 MIRR = \left( \frac{FV_{\text{inflows}}}{PV_{\text{outflows}}} \right)^{\frac{1}{n}} - 1 M I RR = ( P V outflows F V inflows ) n 1 − 1
Because all negative flows are pulled to Year 0 and all positive flows are pushed to Year n n n , the cash flow series is reduced to exactly one outflow followed by one terminal inflow. Consequently, MIRR always produces a single, unique, mathematically stable rate of return , completely eliminating multi-root anomalies.
Comprehensive Worked Example: Value-Add Retail Center
An investment sponsor underwrites a 5-year value-add retail acquisition requiring an initial equity outlay of $2,500,000 . Due to scheduled anchor tenant lease turnover and major box demising in Year 3, projected levered net cash flows are as follows:
- Year 0 : -$2,500,000 (Initial Equity)
- Year 1 : +$180,000
- Year 2 : +$220,000
- Year 3 : -$350,000 (Demising costs, tenant improvement allowance, and leasing commissions)
- Year 4 : +$340,000
- Year 5 : +$400,000 (Operations) + $3,800,000 (BTER from sale) = +$4,200,000
The fund's investment committee mandates the following underwriting parameters:
- Financing Rate ( r f r_f r f ) : 6.00% annual rate to fund capital deficits
- Reinvestment Rate ( r r r_r r r ) : 7.50% annual institutional cost of capital
- Step 1: Calculate Total Present Value of Outflows ( P V outflows PV_{\text{outflows}} P V outflows )
The Year 3 deficit of $350,000 is discounted to Year 0 at the 6.00% financing rate: P V ( Year 3 Deficit ) = $ 350 , 000 ( 1 + 0.06 ) 3 = $ 350 , 000 1.191016 = $ 293 , 867 PV(\text{Year 3 Deficit}) = \frac{\$350,000}{(1 + 0.06)^3} = \frac{\$350,000}{1.191016} = \$293,867 P V ( Year 3 Deficit ) = ( 1 + 0.06 ) 3 $350 , 000 = 1.191016 $350 , 000 = $293 , 867 P V outflows = $ 2 , 500 , 000 + $ 293 , 867 = $ 2 , 793 , 867 PV_{\text{outflows}} = \$2,500,000 + \$293,867 = \$2,793,867 P V outflows = $2 , 500 , 000 + $293 , 867 = $2 , 793 , 867
Step 2: Calculate Total Future Value of Inflows ( F V inflows FV_{\text{inflows}} F V inflows )
Each positive cash inflow is compounded forward to the end of Year 5 at the 7.50% reinvestment rate:
Year 1 ( n − t = 4 n - t = 4 n − t = 4 years): $ 180 , 000 × ( 1 + 0.075 ) 4 = $ 180 , 000 × 1.335469 = $ 240 , 384 \text{\textdollar}180,000 \times (1 + 0.075)^4 = \text{\textdollar}180,000 \times 1.335469 = \text{\textdollar}240,384 $ 180 , 000 × ( 1 + 0.075 ) 4 = $ 180 , 000 × 1.335469 = $ 240 , 384
Year 2 ( n − t = 3 n - t = 3 n − t = 3 years): $ 220 , 000 × ( 1 + 0.075 ) 3 = $ 220 , 000 × 1.242297 = $ 273 , 305 \text{\textdollar}220,000 \times (1 + 0.075)^3 = \text{\textdollar}220,000 \times 1.242297 = \text{\textdollar}273,305 $ 220 , 000 × ( 1 + 0.075 ) 3 = $ 220 , 000 × 1.242297 = $ 273 , 305
Year 3 : $0 (handled in Step 1)
Year 4 ( n − t = 1 n - t = 1 n − t = 1 year): $ 340 , 000 × ( 1 + 0.075 ) 1 = $ 340 , 000 × 1.075000 = $ 365 , 500 \text{\textdollar}340,000 \times (1 + 0.075)^1 = \text{\textdollar}340,000 \times 1.075000 = \text{\textdollar}365,500 $ 340 , 000 × ( 1 + 0.075 ) 1 = $ 340 , 000 × 1.075000 = $ 365 , 500
Year 5 ( n − t = 0 n - t = 0 n − t = 0 years): $ 4 , 200 , 000 × 1.000000 = $ 4 , 200 , 000 \text{\textdollar}4,200,000 \times 1.000000 = \text{\textdollar}4,200,000 $ 4 , 200 , 000 × 1.000000 = $ 4 , 200 , 000
Summing the compounded terminal inflows: F V inflows = $ 240 , 384 + $ 273 , 305 + $ 365 , 500 + $ 4 , 200 , 000 = $ 5 , 079 , 189 FV_{\text{inflows}} = \$240,384 + \$273,305 + \$365,500 + \$4,200,000 = \$5,079,189 F V inflows = $240 , 384 + $273 , 305 + $365 , 500 + $4 , 200 , 000 = $5 , 079 , 189
Step 3: Compute the Modified Internal Rate of Return (MIRR) M I R R = ( $ 5 , 079 , 189 $ 2 , 793 , 867 ) 1 5 − 1 = ( 1.8180 ) 0.20 − 1 = 1.1269 − 1 = 0.1269 (or 12.69 % MIRR = \left( \frac{\$5,079,189}{\$2,793,867} \right)^{\frac{1}{5}} - 1 = (1.8180) ^{0.20} - 1 = 1.1269 - 1 = 0.1269 \text{ (or } 12.69\% M I RR = ( $2 , 793 , 867 $5 , 079 , 189 ) 5 1 − 1 = ( 1.8180 ) 0.20 − 1 = 1.1269 − 1 = 0.1269 (or 12.69%
Comparison with Standard IRR
If the analyst inputs this cash flow stream into a financial calculator ignoring the mid-cycle deficit, standard IRR calculates approximately 14.85% . The standard IRR overstates expected annual yield by 216 basis points because it assumes Year 1, 2, and 4 proceeds are reinvested at 14.85% rather than the realistic 7.50% reinvestment rate.
Financial Calculator Execution (MIRR Calculation)
HP-12C :
Find P V outflows PV_{\text{outflows}} P V outflows : 3 [n] , 6 [i] , 350000 [FV] , [PV] → \rightarrow → 293,867 . Add 2500000 → \rightarrow → 2,793,867 (Enter into [PV] as negative: 2793867 [CHS] [PV] ).
Find F V inflows FV_{\text{inflows}} F V inflows : Accumulate compounded sums to 5,079,189 → \rightarrow → enter 5079189 [FV] .
Solve MIRR: 5 [n] , 0 [PMT] , [i] → \rightarrow → Displays 12.69% .
TI BA II Plus : 5 [N] , -2793867 [PV] , 0 [PMT] , 5079189 [FV] , [CPT] [I/Y] → \rightarrow → Displays 12.69% .
Critical CCIM Exam Traps & Underwriting Rules
Warning
Exam Trap 1: The IRR Reinvestment Rate Assumption : CCIM exam questions frequently probe whether IRR assumes cash flows are reinvested at the discount rate. It does NOT. IRR assumes reinvestment at the calculated IRR itself . Net Present Value (NPV) assumes reinvestment at the discount rate / hurdle rate. Conflating these two assumptions is one of the most common errors on the CI 101 exam.
Important
Exam Trap 2: Recognizing Descartes' Rule of Signs : Whenever a cash flow stream displays more than one change of sign (e.g., initial outflow, interim inflows, mid-cycle capital call outflow, terminal inflow), the standard IRR equation can produce multiple mathematical solutions. Look for the sign change count to identify when standard IRR becomes unreliable and MIRR must be used.
Caution
Exam Trap 3: Selecting Mutually Exclusive Projects : When choosing between mutually exclusive projects of differing capital size, never select the asset based solely on the higher IRR. Always select the project that maximizes Net Present Value (NPV) , as NPV directly measures absolute dollar wealth creation.