Blog · Finance metrics and formulas
Project IRR measures a corporate project's cash flows before financing, while equity IRR measures the cash attributable to its owners. Compare the same project both ways, including debt draws, principal, interest and the explicitly assumed tax effects.
Equity IRR and project IRR use the same return calculation on different cash flows: project IRR measures the project before financing, while equity IRR measures cash attributable to owners after financing. A higher equity IRR can come from borrowing rather than stronger project operations. Label the boundary before comparing either rate with an approval hurdle.
IRR is the rate r for which: 0 = CF0 + CF1 / (1 + r) + CF2 / (1 + r)^2 + ... + CFn / (1 + r)^n
Equity cash flow = Project cash flow + Debt draws - Interest - Principal repayments + Financing-related cash tax benefit
The second formula assumes the project cash schedule already includes operating cash taxes calculated without interest deductions. If the starting schedule includes interest-related tax savings, do not add those savings again.
| Boundary | Project IRR | Equity IRR |
|---|---|---|
| Initial outflow | Full project investment | Owners' contribution after borrowing |
| Operating cash | Before debt service | Residual after debt service |
| Loan proceeds | Excluded | Included in the financing bridge |
| Interest and principal | Excluded | Deducted |
| Taxes in this example | Operating taxes before financing effects | Operating taxes adjusted for assumed interest deductions |
| Corporate review question | How does the project perform? | What cash remains for owners under this financing? |
This follows the cash-flow boundary in Aswath Damodaran's NYU Stern valuation notes: firm cash flows are measured before debt payments, while equity cash flows remain after interest and principal. His notes also require cash flows and discount rates to match.
The comparison here concerns a company's capital project. For how a proposal enters the approval process, see capital budget vs operating budget.
An illustrative US company proposes an equipment investment of $800,000 and an initial $100,000 investment in working capital. The project lasts four years. All operating cash arrives or leaves at year-end; the initial investment occurs at time zero.
Assume no additional capital spending, no equipment sale proceeds and full recovery of working capital in year 4. The equipment is depreciated evenly over the four years for this simplified tax calculation. The assumed combined cash tax rate is 25%, with all deductions usable in the same year. These are workbook assumptions, not a statement of tax rules.
| Cash-flow row | Year 0 (USD) | Year 1 (USD) | Year 2 (USD) | Year 3 (USD) | Year 4 (USD) |
|---|---|---|---|---|---|
| Equipment purchase | -800,000 | 0 | 0 | 0 | 0 |
| Working capital investment or release | -100,000 | 0 | 0 | 0 | 100,000 |
| Customer receipts | 0 | 700,000 | 700,000 | 700,000 | 700,000 |
| Cash operating payments | 0 | -300,000 | -300,000 | -300,000 | -300,000 |
| Operating cash taxes before financing | 0 | -50,000 | -50,000 | -50,000 | -50,000 |
| Project cash flow | -900,000 | 350,000 | 350,000 | 350,000 | 450,000 |
The tax calculation is visible: annual depreciation is $800,000 / 4 = $200,000. Annual taxable operating profit is $700,000 - $300,000 - $200,000 = $200,000; at the assumed 25%, cash tax is $50,000. Depreciation enters that tax calculation but is not another operating cash payment.
The final year's $450,000 consists of $350,000 operating cash plus $100,000 working capital recovery. In a real capital workbook, test whether that recovery and any equipment disposal taxes actually occur on the scheduled dates.
Treasury proposes a $500,000 loan drawn at time zero. It carries annual interest of 8% on opening debt and four equal year-end principal repayments of $125,000. There are no fees or reserve accounts in this example. Owner cash is assumed distributable immediately after debt service.
| Financing bridge | Year 0 (USD) | Year 1 (USD) | Year 2 (USD) | Year 3 (USD) | Year 4 (USD) |
|---|---|---|---|---|---|
| Project cash flow | -900,000 | 350,000 | 350,000 | 350,000 | 450,000 |
| Loan draw | 500,000 | 0 | 0 | 0 | 0 |
| Opening debt | 0 | 500,000 | 375,000 | 250,000 | 125,000 |
| Interest paid | 0 | -40,000 | -30,000 | -20,000 | -10,000 |
| Principal repaid | 0 | -125,000 | -125,000 | -125,000 | -125,000 |
| Interest-related cash tax benefit | 0 | 10,000 | 7,500 | 5,000 | 2,500 |
| Equity cash flow | -400,000 | 195,000 | 202,500 | 210,000 | 317,500 |
Opening debt is a balance, not a cash flow to add. Year 1 interest is $500,000 × 8% = $40,000, and its assumed tax benefit is $40,000 × 25% = $10,000. Owner cash is therefore $350,000 - $40,000 - $125,000 + $10,000 = $195,000. Apply the same bridge to each remaining year.
Two checks establish the financing totals. Principal repayments of $125,000 × 4 equal the $500,000 draw, leaving no terminal debt. Total interest is $100,000 and total tax benefits are $25,000, so financing reduces aggregate net project cash by $75,000: $600,000 project net cash becomes $525,000 equity net cash.
Place this summary in A1:C6:
| Year | Project cash flow (USD) | Equity cash flow (USD) |
|---|---|---|
| 0 | -900,000 | -400,000 |
| 1 | 350,000 | 195,000 |
| 2 | 350,000 | 202,500 |
| 3 | 350,000 | 210,000 |
| 4 | 450,000 | 317,500 |
In Excel, enter the project rate in E2 and the equity rate in E3:
=IRR(B2:B6)
=IRR(C2:C6)
Project IRR is 23.03% and equity IRR is 40.28%, rounded to two decimal places. Microsoft's IRR documentation specifies regular intervals and ordered positive and negative cash flows. These are annual rates because the example uses annual periods.
Check net present value using the full, unrounded rates:
=B2+NPV(E2,B3:B6)
=C2+NPV(E3,C3:C6)
Both residuals round to $0.00. The initial flow stays outside NPV because Excel discounts its arguments as end-of-period cash flows. For irregular dates, use XIRR and the corresponding XNPV check; Microsoft explains those timing conventions. Covirage is not affiliated with Microsoft.
Borrowing reduced the owners' initial contribution while preserving residual operating cash after scheduled repayments. That explains the higher equity rate; it does not increase the project's receipts. Compare each IRR with the finance-approved hurdle for its own boundary, and retain NPV alongside the percentage.
Use project cash flow for weekly funding gaps and project margin analysis for delivery profitability. Neither substitutes for this dated capital-return calculation.
Bring a capital workbook with separate project, financing and owner cash schedules to Covirage. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See forecast analysis for the supporting business context.
No. Debt reduces the initial equity contribution but adds required interest and principal payments. The result depends on financing costs, operating cash flows and timing. A smaller equity contribution can also make downside cash shortfalls more severe for the owners.
A project IRR defined before financing excludes loan proceeds, interest and principal repayments. It includes the project's investment and operating cash flows on its stated tax basis. Keep borrowing in a separate financing schedule that bridges project cash to owner cash.
Use IRR for cash flows spaced at equal intervals, preserving any zero periods. Use XIRR when the actual cash dates are irregular. Date conventions matter: an annual schedule and a dated schedule can produce different rates even when their dollar totals match.
Accounting profit alone is insufficient. Build cash flows that include capital spending, working capital investment, cash taxes and terminal recoveries. Depreciation may affect cash taxes, but it is not itself a cash payment and should not be deducted again from cash operating receipts.