To calculate unlevered IRR, project the unlevered free cash flow for every period of the hold, add a terminal value to the final period, and solve for the discount rate that makes the net present value of that cash flow stream equal zero. In practice, that last step is done with a spreadsheet: enter the cash flows in a column, type =IRR(range) or =XIRR(values, dates), and the function iterates to the answer. The work that matters is upstream of the formula — building cash flows that are genuinely unlevered, which means they contain no interest expense, no principal payments, and no loan proceeds.
Build the Unlevered Free Cash Flow for Each Period
Unlevered free cash flow is the cash an investment produces for all capital providers combined, equity and debt, before any debt service leaves the picture. If interest expense or principal repayments sneak into the figure, you’ve calculated levered cash flow instead and the IRR you get back will answer a different question.
The formula has four pieces:
- NOPAT (Net Operating Profit After Tax). Take operating income (EBIT) and multiply by (1 − tax rate). The federal corporate rate is a flat 21 percent, with state rates adding roughly zero to 11.5 percent depending on jurisdiction. NOPAT deliberately ignores interest expense, and the tax calculation excludes the interest tax shield for the same reason: you want to see what the business earns as if it carried no debt.1Office of the Law Revision Counsel. 26 U.S. Code 11 – Tax Imposed
- Add back depreciation and amortization. These are accounting charges that reduce reported income without any cash actually leaving the business. Adding them back moves your figure closer to real cash generation.
- Subtract changes in net working capital. If receivables or inventory grew, cash got tied up even though it doesn’t show as an expense. If payables grew, you held cash longer. The net change adjusts for these timing differences.
- Subtract capital expenditures. Money spent on equipment, buildings, or other long-lived assets is a real cash outflow. Depreciation spreads that cost across years on paper; CapEx hits when you write the check.
Written out: Unlevered Free Cash Flow = NOPAT + D&A − Change in NWC − CapEx. You need this number for every period in your projection, usually annually across a five- to ten-year hold.
Add a Terminal Value to the Final Year
The last period of the model has to capture what happens when the asset is sold or the investment is exited. Terminal value typically dwarfs any single year’s operating cash flow, so a loose assumption here can move the IRR by several percentage points.
The exit multiple method is the standard choice for real estate and private equity deals. Take the final year’s projected EBITDA (or net operating income for property) and multiply by a market-derived multiple drawn from comparable transactions or public valuations. If similar assets are trading at 12 times EBITDA, apply 12.
The alternative is a perpetuity growth model, which assumes cash flows grow at a stable rate forever and discounts that stream back to a present value. It fits mature, stable businesses better than assets you plan to sell at a defined date. Whichever method you use, add the terminal value to the final year’s operating cash flow. That combined figure is the last data point in the IRR calculation.
What the IRR Equation Is Actually Doing
IRR is the discount rate that makes NPV equal zero. Written out: 0 = Σ [CFt / (1 + IRR)t]. Period zero is the initial investment, entered as a negative number. The subsequent periods are the unlevered free cash flows, with terminal value folded into the final one.
The intuition: at what annual rate would you need to discount every future cash flow so their combined present value exactly matches what you paid upfront? A 12 percent answer means the investment compounds at 12 percent per year over its life.
You can’t solve this algebraically for most investments. A five-year hold produces a fifth-degree polynomial with no clean closed-form solution. Software handles it by iteration: test a rate, see whether NPV is above or below zero, narrow in until NPV lands at zero. That’s why the calculation lives in a spreadsheet or a financial calculator rather than on paper.
Run the Calculation in a Spreadsheet
Excel and Google Sheets both have a built-in IRR function. The setup is simple:
- Organize the cash flows in one column. Cell A1 holds the initial investment as a negative number. A2 through A6 (for a five-year hold) hold each year’s unlevered free cash flow, with the final cell including terminal value added to that year’s operating cash flow.
- Enter the formula. In a blank cell, type =IRR(A1:A6). The range needs at least one negative and one positive value or the function returns an error.2Microsoft Support. IRR Function
- Format and check. The output is a decimal (0.128), formatted as a percentage (12.8%). You can verify by discounting the same cash flows at that rate in an NPV calculation; the result should land near zero.
A #NUM! error usually means the cash flow pattern doesn’t let the algorithm converge. The optional guess argument gives it a starting point: =IRR(A1:A6, 0.05) tells the function to begin at 5 percent. For irregular cash flows, adjusting the guess can be the difference between a result and an error.
Use XIRR When Cash Flows Aren’t Evenly Spaced
The standard IRR function assumes uniform spacing between every cash flow. Real investments rarely cooperate: a deal might close in March, distribute in July and November, and sell 4.5 years later in September. For these, use XIRR.3Microsoft Support. XIRR Function
The syntax is =XIRR(values, dates, [guess]). Provide a column of cash flow amounts and a parallel column of the exact dates. The function handles the day-count math and returns an annualized rate. Dates can appear in any order, though keeping them chronological makes the model easier to audit. If cash flows don’t fall at year-end, XIRR is almost always the right choice.
On a Financial Calculator
On a BA II Plus or similar, press CF to begin entering cash flows. Enter the initial investment as a negative value in CF0, then each subsequent period in C01 through C0n. Press IRR, then CPT, to solve. The frequency setting has to match the cash flow interval — annual data run with the calculator set to monthly produces a meaningless number.
A Worked Example
Suppose you’re evaluating an office building at a $500,000 all-cash purchase price with a five-year hold. The projected unlevered free cash flows:
- Year 0: −$500,000 (acquisition)
- Year 1: $40,000
- Year 2: $45,000
- Year 3: $50,000
- Year 4: $55,000
- Year 5: $660,000 ($60,000 operating + $600,000 sale proceeds)
Enter these six values in A1 through A6, type =IRR(A1:A6) in a blank cell, and the result is approximately 12.8 percent. The investment’s operations generate the equivalent of a 12.8 percent annual return to all capital providers before any financing is layered on top.
Notice what’s absent: no mortgage payments, no interest, no loan proceeds. Every dollar is operating cash. If you had financed 70 percent of the purchase with debt, the unlevered cash flows would look identical, because debt hasn’t entered the picture. The levered cash flows, and the levered IRR, are a separate calculation that answers a separate question about return on equity.
Read the Result Against Your Cost of Capital
A percentage means nothing on its own. The primary benchmark for unlevered IRR is the weighted average cost of capital (WACC), which blends the cost of equity and the cost of debt into a single rate representing what capital providers collectively need to earn. If the unlevered IRR exceeds WACC, the investment creates value. If it falls short, the project destroys value no matter how good the revenue story sounds.
WACC varies by industry and risk profile. Real estate development, REITs, oil and gas, and renewable energy all sit at different levels, and those levels shift with interest rates. In commercial real estate, target unlevered IRRs typically range from around 6 percent for low-risk core assets to 11 percent or higher for opportunistic deals like ground-up development. Value-add strategies land in between. A “good” IRR in a low-rate environment is not the same number as a good one when rates are tight.
Limitations to Know Before You Trust the Number
IRR is widely used, and it has blind spots worth naming before you commit to a deal based on it.
The Reinvestment Assumption
The standard IRR math implicitly assumes every dollar of interim cash flow gets reinvested at the IRR itself. A 15 percent IRR assumes you can redeploy each distribution into another 15 percent opportunity. In reality, that cash might sit in a money market account earning 4 percent. The higher the IRR and the earlier the cash flows arrive, the more this assumption inflates the result.
Multiple IRRs
The IRR equation can have more than one mathematically valid answer when cash flows change signs more than once. A conventional deal has one sign change: negative upfront, positive thereafter. But if the project needs a major reinvestment in year three, the sequence might run negative-positive-negative-positive, and the polynomial can have multiple roots. When a spreadsheet returns 8 percent and another valid solution sits at 42 percent, neither number tells you much on its own.
Scale Blindness
IRR says nothing about dollar size. A $50,000 investment at 25 percent unlevered IRR generates far less wealth than a $5,000,000 investment at 14 percent. Screening purely on IRR tilts toward smaller, shorter-duration projects that flatter the percentage. NPV captures absolute value creation and is the natural companion.
Duration Sensitivity
Timing is easy to manipulate. A deal that returns capital quickly shows a higher IRR than one producing the same total profit over a longer hold, because the compounding period is shorter. Two deals can post identical equity multiples and very different IRRs if one wraps in three years and the other in seven. Look at IRR alongside the equity multiple.
When to Use MIRR Instead
If the reinvestment assumption bothers you — and for high-return deals it should — the Modified Internal Rate of Return addresses it. MIRR takes two explicit rates: a finance rate for the cost of borrowing and a reinvestment rate for what interim cash flows can realistically earn.4Microsoft Support. MIRR Function
In Excel: =MIRR(values, finance_rate, reinvest_rate). Using the office building above, with an 8 percent cost of capital and a 5 percent reinvestment assumption, =MIRR(A1:A6, 0.08, 0.05) returns a figure below the standard 12.8 percent, because interim cash is no longer presumed to compound at the deal’s own IRR. The lower number is arguably more honest.
MIRR also always returns a single answer, sidestepping the multiple-IRR problem. The trade is that you have to state your reinvestment assumption out loud instead of letting the formula hide it.