What Is Unlevered IRR? (Valuation Formula)
Unlevered IRR is the annual rate that makes the present value of a project’s operating and investment cash flows, including its initial cost and resale proceeds, equal zero. It excludes borrowing and debt payments, so it measures the project rather than an investor’s financing choices. Use it with a suitable hurdle rate, an NPV check, and clear cash-flow assumptions.
A project’s resale value can make a large difference to its return. If you buy or develop an asset, earn income, then sell it, the sale proceeds are part of the investment’s cash flow. Leaving them out may understate the return; assuming too high a resale value may overstate it.
Unlevered internal rate of return, or unlevered IRR, helps summarize that full cash-flow pattern as a rate. It is useful for comparing projects before debt financing enters the picture. But it is not a dollar valuation, and it cannot tell you on its own whether an investment is worthwhile.
Unlevered IRR: Definition, Formula, and Valuation Purpose
Unlevered IRR is the discount rate that makes the net present value of a project’s unlevered cash flows equal zero. Those cash flows include the project’s initial cost, later operating cash flows, and any final sale proceeds, but exclude borrowing and debt payments.
The formula is:
[ 0=\sum_{t=0}^{n}\frac{UCF_t}{(1+r)^t} ]
Here, (UCF_t) is the project’s unlevered cash flow in period (t), (r) is the unlevered IRR, and (n) is the final period. The initial investment is usually a negative amount at (t=0). A later operating inflow or sale proceeds are usually positive.
The formula says that, at the IRR, the present value of the expected inflows equals the present value of the outflows. In practice, analysts usually solve for (r) with a spreadsheet or financial calculator. A cash-flow pattern with several positive and negative amounts may not have a simple algebraic solution.
What makes the return “unlevered”?
The term unlevered means the cash flows are measured before the effects of debt financing. Include the project’s operating and investment cash flows, but leave out loan proceeds, interest, principal payments, and distributions to equity investors.
This distinction matters because debt changes the timing and size of cash flows to an owner. If you include loan proceeds at the start and loan payments later, you are measuring a return to equity, often called levered IRR, not unlevered IRR.
What does IRR have to do with valuation?
IRR is a rate, not a property value, business value, or valuation multiple. For a given set of cash flows, it is the rate at which unlevered NPV equals zero. To estimate value, analysts generally discount forecast cash flows at a chosen discount rate; that rate is not automatically the project’s IRR.
For example, if you discount project cash flows at a risk-appropriate hurdle rate and get a positive NPV, the projected return exceeds that rate under the model’s assumptions. If NPV is negative, it falls short. The IRR helps summarize the cash flows, while NPV at the hurdle rate helps assess the value created at that rate.
Cash-Flow Construction, Timing, and Calculation
A reliable unlevered IRR begins with a complete timeline of project cash flows. List the initial outlay, expected operating cash flows, later investment costs, and terminal proceeds by period. Then check that each amount is recorded in the period when it is expected to occur.
Build the project cash-flow timeline
A real estate or business-project forecast may include purchase or development costs, operating income and costs, further capital spending, applicable taxes, and proceeds from a sale. The exact items depend on the asset and the purpose of the analysis. State the assumptions so another reader can follow the calculation.
Resale proceeds should reflect the value expected at exit and any modeled selling costs or other applicable amounts. Do not count the same value twice. For instance, if an operating cash flow already includes a receipt, do not also add that receipt to the terminal sale amount.
A useful check is to label every cash flow by source and date:
- Initial purchase, development, or investment outlay
- Operating cash flow before financing
- Additional project costs or capital spending
- Taxes included under the model’s stated tax method
- Net proceeds expected at sale or other exit
Keep debt and equity flows out
Remove loan proceeds, interest, principal repayments, and equity distributions from the unlevered project cash flows. These items describe how the project is financed or how money is divided among investors, rather than the project’s performance before financing.
Tax treatment also needs care. If the model is after tax, apply a consistent method and avoid including tax savings caused by interest deductions in a measure intended to be unlevered. Tax rules vary by situation, so document the method and seek qualified tax advice when needed.
Match the timing method to the data
If cash flows occur at regular annual intervals, use annual periods consistently. If the forecast uses monthly periods, use monthly cash flows and interpret the result on the matching basis. Do not mix annual cash flows with monthly periods without converting the amounts and timing.
For cash flows that occur on irregular dates, use a date-based method such as Excel’s XIRR or an equivalent tool. XIRR uses the actual dates to estimate an annualized return. It can differ from a standard IRR calculation, which assumes equal time between periods.
Calculate the rate and check the result
Enter the initial outflow first, followed by each later period’s net cash flow, including final sale proceeds. Use a spreadsheet’s IRR function for equal periods or XIRR for dated cash flows. Then calculate NPV using the reported rate; it should be near zero, subject to rounding and software conventions.
That check catches common input errors. Confirm the sign of each amount, the period order, the sale proceeds, and the exclusion of debt flows. Also inspect the cash-flow sequence for more than one change between negative and positive amounts, because that can create more than one IRR solution.
Illustrative Project and Scenario Comparisons
An illustrative project shows how cash flows translate into an unlevered return. The figures below are invented for explanation, not market benchmarks. They assume annual periods, no interim financing flows, and a sale at the end of year three.
| Period | Unlevered cash flow | Example items |
|---|---|---|
| Year 0 | -$1,000,000 | Purchase or development cost |
| Year 1 | $100,000 | Operating cash flow |
| Year 2 | $110,000 | Operating cash flow |
| Year 3 | $1,320,000 | $120,000 operating cash flow plus $1,200,000 net sale proceeds |
The IRR solves:
[ 0=-1{,}000{,}000+\frac{100{,}000}{1+r}+ \frac{110{,}000}{(1+r)^2}+ \frac{1{,}320{,}000}{(1+r)^3} ]
The result is about 16.5% per year. The terminal cash flow combines year-three operations and sale proceeds. If the sale proceeds were excluded, the calculation would describe a different and incomplete cash-flow forecast.
How a resale assumption changes the return
Holding the first three cash flows constant, a higher or lower sale price changes the final cash flow and therefore the IRR. The table shows rounded illustrative outcomes using the same $1 million initial investment and operating cash flows above.
| Net sale proceeds in Year 3 | Year 3 total cash flow | Approximate unlevered IRR |
|---|---|---|
| $1,000,000 | $1,120,000 | 11.1% |
| $1,200,000 | $1,320,000 | 16.5% |
| $1,400,000 | $1,520,000 | 21.3% |
These figures show why an exit assumption deserves scrutiny. They do not prove that any of the sale prices is likely. Test a reasonable range based on the project’s evidence and explain how sensitive the result is to that assumption.
Why leverage changes the answer
Suppose the project is partly funded with a loan. Adding the loan proceeds to the initial cash flow and subtracting later interest and principal payments produces cash flows to equity, not unlevered project cash flows. The resulting levered IRR may be higher or lower, depending on the project, borrowing cost, repayment schedule, and risk.
| Cash flow item | Include in unlevered IRR? | Reason |
|---|---|---|
| Project purchase or development cost | Yes | It is an investment outflow |
| Operating cash flow before financing | Yes | It comes from project operations |
| Net proceeds from a project sale | Yes | They are terminal project proceeds |
| Loan proceeds | No | They are a financing source |
| Interest and principal payments | No | They are debt service |
| Equity distributions | No | They are allocations to investors |
Model Validation, Assumptions, and Interpretation
A calculated IRR is only as useful as the cash flows behind it. Validate the dates, signs, financing treatment, and exit assumptions before interpreting the percentage. Then compare it with an appropriate benchmark and review NPV, since IRR alone can hide important differences between projects.
Compare against a risk-appropriate hurdle rate
A hurdle rate is the minimum return used to assess an investment. For unlevered cash flows, a relevant comparison may be the project’s unlevered cost of capital or another risk-adjusted required return. There is no universal IRR cutoff that makes every project acceptable.
Compare the unlevered IRR with a benchmark that fits the project’s risk, cash-flow timing, and analysis method. Also calculate NPV at that hurdle rate. A positive NPV means the modeled cash flows exceed the value required at that rate; a negative NPV means they do not.
Check for misleading comparisons
IRR can rank projects in a way that differs from NPV, especially when projects vary in size, duration, or cash-flow timing. A small project may show a higher percentage return while creating fewer dollars of value. Reinvestment assumptions and the timing of cash flows can also affect how an IRR comparison should be read.
Multiple sign changes in the cash-flow sequence may produce multiple IRRs or make the result hard to interpret. In those cases, do not present one IRR as a complete decision answer. Review the NPV profile or use other measures suited to the decision.
Test the assumptions that matter most
I would focus first on the assumptions with the greatest effect on the result: operating performance, additional costs, timing, taxes, and terminal value. Run scenarios that change one or more assumptions, then report the range rather than relying on a single forecast.
A concise validation list is:
- Confirm every amount belongs to the project, not its financing.
- Confirm the period dates and units match the IRR method.
- Reconcile terminal proceeds with the sale assumption and costs.
- Confirm NPV at the reported IRR is approximately zero.
- Look for multiple cash-flow sign changes.
- Compare IRR and NPV with a suitable hurdle rate.
- Show how key assumptions affect the result.
Investment Decisions and Valuation Applications
Unlevered IRR is useful when you want to compare project returns without letting different debt plans drive the result. It supports investment screening and valuation analysis, but it should sit beside NPV, risk review, and scenario testing rather than replace them.
Analysts may use it to compare development plans, acquisitions, or other projects on a pre-financing basis. That makes the metric helpful when the capital structure is not yet set or when projects use different financing plans. The comparison is meaningful only if the cash-flow definitions, time periods, and risk assumptions are consistent.
In practice, I would report the unlevered IRR with its forecast period, the treatment of taxes, the terminal value assumption, and the hurdle rate used for NPV. That makes clear what the percentage means and what it leaves out. The next step is to review the project’s evidence and test whether the result holds under less favorable assumptions.
Frequently Asked Questions
These answers clarify how unlevered IRR is calculated and used. The key distinction is that it measures project cash flows before financing, while NPV expresses value at a selected discount rate. Always state the timing method and assumptions when presenting either result.
Is unlevered IRR the same as project IRR?
Often, “project IRR” refers to the return on project cash flows before financing. Check the model’s definition, because labels can vary. If debt proceeds or debt payments are included, the calculation is not unlevered.
What is the unlevered IRR formula?
Solve (0=\sum_{t=0}^{n} UCF_t/(1+r)^t). (UCF_t) is the project’s cash flow in period (t), and (r) is the rate that makes NPV equal zero.
Does unlevered IRR include loan proceeds?
No. Loan proceeds, interest, and principal repayments are financing flows. Including them changes the cash-flow basis and generally produces a levered, or equity, IRR.
Does unlevered IRR include resale value?
Yes, if the project is expected to be sold or have terminal proceeds. Include the appropriate net proceeds in the final period, along with any operating cash flow due in that period.
Is unlevered IRR a valuation?
No. It is a return rate, not a dollar value. A valuation usually discounts expected cash flows at a selected rate to estimate their present value.
How is unlevered IRR different from NPV?
IRR is the rate that makes NPV zero. NPV is the dollar value of cash flows discounted at a chosen rate. Use both to assess a project.
Can unlevered IRR be negative?
Yes. If the project’s cash flows do not recover the initial outlay under the modeled timing, the IRR may be negative. Review the cash flows and NPV before drawing conclusions.
What if a project has more than one IRR?
Multiple changes between negative and positive cash flows can produce multiple IRR solutions. Report the issue and examine NPV at relevant discount rates rather than relying on one result.
Should I use IRR or XIRR?
Use IRR when periods are equally spaced and consistent. Use XIRR, or an equivalent date-based method, when cash flows occur on irregular dates.
What is a good unlevered IRR?
There is no universal threshold. Compare the result with a risk-appropriate unlevered hurdle rate and consider NPV, project duration, timing, and the reliability of the assumptions.
(This article was written by one of our staff writers, Nathan Sterling. Visit our Meet the Team page.)
