Finance Tool

IRR Calculator for Capital Budgeting and IC Decks

Calculate internal rate of return, MIRR, NPV, MOIC, and discounted payback from project cash flows, then turn the output into a cleaner investment committee memo, capex approval slide, or board-ready business case.

Live calculator

Keep the cash-flow case explicit so finance reviewers can trace the investment logic fast.

Preset

Business context

Capital-allocation review for a product and GTM expansion where management needs to prove the investment clears the software company hurdle rate and can be defended in a board pack.

Audience

CFO, board, growth investor

Initial InvestmentUse a positive number for the upfront cash outflow. The calculator treats it as Year 0 negative cash flow.Hurdle Rate %Use WACC or the approval hurdle rate expected by the board, IC, or capex committee.Reinvestment Rate %Used for MIRR. Many teams use a reinvestment rate at or below WACC.

Annual cash flows

Add exit or salvage value to the final year if relevant

Year 1 Cash FlowUse post-tax project cash flow for this year.Year 2 Cash FlowUse post-tax project cash flow for this year.Year 3 Cash FlowUse post-tax project cash flow for this year.Year 4 Cash FlowUse post-tax project cash flow for this year.Year 5 Cash FlowInclude steady-state cash flow plus any exit proceeds or residual value.

Result

37.3%

IRR clears the stated hurdle rate by 25.3% and NPV is positive. That usually supports an approval recommendation if the exit and timing assumptions are credible.

MIRR

26.5%

NPV

$2.7M

Discounted payback

3.09 years

MOIC

2.80x

IC-ready takeaway

Project IRR is 37.3% against a hurdle rate of 12.0%. MIRR is 26.5%, NPV at the hurdle rate is $2,690,843, simple payback is 2.59 years, discounted payback is 3.09 years, and undiscounted MOIC is 2.80x.

Formula and decision logic

Use this as a review-ready bridge from raw cash flows to the approval recommendation.

IRR = rate where NPV = sum(CF_t / (1 + r)^t) = 0
MIRR = (FV of positive cash flows at reinvestment rate / PV of negative cash flows at finance rate)^(1 / n) - 1

Capital deployed

Year 0 investment = $3,000,000

Total invested capital = $3,000,000

Total positive cash flow = $8,400,000

Return verdict

IRR = 37.3%

Hurdle spread = 25.3%

MIRR = 26.5%

Value creation

NPV at hurdle = $2,690,843

Simple payback = 2.59 years

Discounted payback = 3.09 years

Reliability check

Cash-flow sign changes = 1

IRR roots found = 1

Primary use case = IRR + hurdle-led

Year	Cash flow	Discounted cash flow	Cumulative	Discounted cumulative
Year 0	-$3,000,000	-$3,000,000	-$3,000,000	-$3,000,000
Year 1	$800,000	$714,286	-$2,200,000	-$2,285,714
Year 2	$1,200,000	$956,633	-$1,000,000	-$1,329,082
Year 3	$1,700,000	$1,210,026	$700,000	-$119,055
Year 4	$2,100,000	$1,334,588	$2,800,000	$1,215,533
Year 5	$2,600,000	$1,475,310	$5,400,000	$2,690,843

Worked example

This example uses the default SaaS platform expansion case.

Year 0 investment is $3,000,000.

Five-year positive cash flows sum to $8,400,000, which implies an undiscounted MOIC of 2.80x.

At a 12.0% hurdle rate, NPV is $2,690,843 and discounted payback is 3.09 years.

IRR is 37.3% and MIRR is 26.5%, which gives the board both a traditional return metric and a reinvestment-adjusted cross-check.

Deck storyline

37.3% IRR frames the approval headline

Lead with whether the project clears the hurdle, not with the raw cash-flow table. Executives want the recommendation before the mechanics.

Headline metric strip with IRR, hurdle, and approval verdict

Deck storyline

$2.7M NPV shows absolute value creation

IRR is a percentage; NPV makes clear how much value the project creates after applying the company hurdle rate.

NPV callout with a cumulative cash-flow bridge

Deck storyline

3.09 years discounted payback keeps timing honest

Payback helps the committee see how long capital stays at risk before the project recovers itself on a discounted basis.

Payback timeline or cumulative discounted cash curve

Sensitivity view

This is where the IC or board discussion usually goes after the headline return looks attractive.

Scenario	IRR	NPV	Discounted payback
Base case	37.3%	$2,690,843	3.09 years
Cash flows -10%	32.5%	$2,121,758	3.34 years
Hurdle rate +2 pts	37.3%	$2,366,294	3.18 years
Final-year value -15%	36.0%	$2,469,546	3.09 years

How business teams use this output

Capex approval packs

Use IRR, NPV, and discounted payback together when operations wants a fast go / no-go answer tied to a finance hurdle rate.

Investment committee memos

Keep the deal case concrete: entry outlay, operating cash generation, exit assumption, hurdle spread, and downside sensitivity.

Board capital allocation

Compare multiple projects on return and recovery speed before leadership decides where scarce capital goes first.

Corp dev and PE screens

Use MIRR when the cash-flow pattern is more complex and you want a cleaner return metric than a fragile multi-root IRR.

WACC Calculator

Pressure-test the hurdle rate before comparing it against project IRR.

DCF Valuation Calculator

Use DCF when the committee needs absolute valuation, not just a return percentage.

ROI and Payback Period Calculator

Translate the same investment case into ROI, NPV, and discounted payback language.

Investment Committee Memo to Deck Generator

Turn the return case into an IC recommendation, risk slide, and approval storyline.

Valuation Presentation Guide

See how to present IRR, NPV, and hurdle-rate logic without losing the executive audience.

Business Case Presentation Guide

Useful when the project return needs to sit inside a broader business-case narrative.

Common mistakes

Presenting IRR alone without showing whether NPV is positive at the company hurdle rate.

Ignoring multiple sign changes in the cash-flow pattern and treating the first IRR output as automatically reliable.

Using optimistic terminal proceeds in the final year without pressure-testing the no-exit or lower-exit case.

Using a project IRR in a board deck without stating the hurdle rate, payback, and execution assumptions behind it.

Limitations

This page assumes annual periods and keeps the model intentionally lightweight. It does not handle monthly timing, taxes, debt amortization, or full scenario trees. Use it for fast screening and presentation logic, then reconcile the output back to the full financial model before making a final approval decision.

Frequently asked questions

What is the difference between IRR and MIRR?

IRR is the discount rate that sets NPV to zero. MIRR adjusts the reinvestment assumption by using an explicit finance rate and reinvestment rate, which usually makes the output easier to defend in CFO or investment committee discussions.

When should I compare IRR to WACC or a hurdle rate?

Compare IRR to the discount rate the company uses for projects with similar risk. If IRR is above the hurdle rate and NPV is positive, the investment is usually creating value under the stated assumptions.

Why can a project have more than one IRR?

If the cash-flow pattern switches sign more than once, the project can produce multiple mathematically valid IRRs. That is why this page also shows MIRR and explicitly flags multi-sign-change cases.

Does this replace a full IC or capex model?

No. This is a fast decision-support tool for board packs, capex reviews, and IC memos. Detailed models still need taxes, debt schedules, working capital, scenario detail, and source-level operating assumptions.

Should the final-year cash flow include exit proceeds or salvage value?

Yes, if the investment case depends on a terminal sale, asset recovery, or contract residual. Put that value into the final-year cash flow so the IRR and MIRR reflect the full economics.

Turn the return case into an executive-ready slide

Use the calculator first, then generate an IC or board slide that explains the hurdle rate, return case, cash recovery timing, and the assumptions that a CFO or sponsor will challenge first.

Browse more free tools