United Kingdom version. Set to the UK: pounds, and the Green Book's 3.00% real discount rate (HM Treasury, October 2026) as the starting rate for public-sector appraisal. US version
NPV and IRR Calculator (Green Book)
Net present value and IRR for a UK project or business case, with the Green Book discount rate of 3.00% real for years 1 to 30 and the result in pounds.
The interactive tool loads here when JavaScript runs.
About this toolWhat is the NPV and IRR Calculator?
For a UK public-sector business case the discount rate is not a choice. HM Treasury's Green Book sets it as the Social Time Preference Rate, and its October 2026 guidance cut it from 3.50% to 3.00% in real terms for the first 30 years of a proposal, falling to 2.50% for years 31 to 75 and 2.25% for years 76 to 125. This version starts at 3.00% with a 10-year example in pounds.
The calculator discounts each year's net flow at one constant rate, with year 0 undiscounted, which matches the Green Book's Annex A discount factors exactly for anything up to 30 years. For a longer horizon the Green Book rates are forward rates that step down, so a single rate will understate the later years' value; split the appraisal or apply the published factors.
Private firms use their own cost of capital instead, which reflects what their investors require rather than society's time preference. Enter that rate for a commercial decision; the IRR, MIRR and payback figures work the same way.
- NPV with period 0 undiscounted, as in finance textbooks
- Every IRR found by grid scan plus safeguarded Newton and bisection
- Clear messages for no IRR and multiple IRRs
- MIRR with separate finance and reinvestment rates
- Simple and discounted payback, profitability index
- NPV profile chart and a table of discounted and cumulative flows
Updated
How to use the NPV and IRR Calculator
- Type the cash flows one per line, starting with the period 0 amount (usually the negative investment). Commas, semicolons and brackets for negatives also work.
- Enter the discount rate, which is your required return or cost of capital, and choose whether each period is a year, a quarter or a month.
- Optionally set separate finance and reinvestment rates for MIRR; blank uses the discount rate.
- Read NPV, IRR, MIRR, payback, discounted payback and the profitability index, and any note about multiple or missing IRRs.
- Use the NPV profile chart and the cash flow table to see how sensitive the decision is to the rate.
Worked examples
A case that the rate change tips into positive
Input
-£2,000,000 now, then £240,000 a year for 10 years, in real terms
Output
NPV £47,248.68 at 3.00%; -£4,014.72 at the old 3.50%; IRR 3.460%
The same option fails at the pre-October 2026 rate and passes at the new one. When an NPV is this close to zero, the Green Book result depends on the rate more than on the scheme, so show the sensitivity alongside it.
A clearer case
Input
-£2,000,000, then £250,000 a year for 10 years
Output
NPV £132,550.71 at 3.00%; IRR 4.277%; profitability index 1.066
Each year of benefit is multiplied by the Green Book factor: 0.9709 for year 1 down to 0.7441 for year 10. The profitability index is the present value of the inflows per pound of the upfront cost.
Background and insight
Net present value discounts every cash flow back to period 0 at the discount rate r and adds them: NPV = Σ CFₜ ÷ (1 + r)ᵗ. A positive NPV means the project returns more than r after paying back the investment, in present-day money. Note that the NPV function in Excel and Google Sheets discounts its first argument by one period, so the period 0 investment must be added outside it. This calculator does not discount period 0, which matches the textbook definition.
The internal rate of return is the discount rate that makes NPV exactly zero. There is no closed formula, so it has to be found numerically. Simple solvers start from a guess and apply Newton's method, which can wander off or converge to only one of several answers. This tool first evaluates NPV across a fine grid of rates to find every interval where it changes sign, then narrows each one with Newton steps that fall back to bisection whenever a step would leave the interval. Descartes' rule of signs says the number of IRRs is at most the number of sign changes in the cash flows, which is why mining, nuclear and other projects with closing costs can have two.
MIRR fixes two weaknesses of IRR. It discounts the outflows at a finance rate and compounds the inflows to the final period at a reinvestment rate, then finds the single rate that links the two: MIRR = (FV of inflows ÷ PV of outflows)^(1/n) − 1. It always has exactly one answer, and it does not assume interim cash is reinvested at the IRR itself. Payback period counts how long until cumulative cash flow turns positive; discounted payback does the same with present values, and both interpolate within the period.
Common use cases
Capital budgeting
Decide whether equipment, a new product line or an expansion earns more than the cost of capital.
Comparing projects
Rank mutually exclusive options by NPV and see on the profile chart where their ranking would flip.
Real estate and private deals
Evaluate a property or private investment from its purchase, yearly net income and sale proceeds.
Corporate finance coursework
Check NPV, IRR, MIRR and payback answers, including the tricky multiple-IRR textbook cases.
Tips and limitations
- The Green Book rate is real. Strip general inflation out of your costs and benefits first; never add inflation to 3.00% and discount nominal figures.
- Do not discount costs and benefits that have already happened. The Green Book says past values are not increased just because they were in the past.
- For proposals over 30 years, use 3.00% to year 30, then 2.50% from year 31, as forward rates, not 2.50% for every year.
- Official Development Assistance appraisals may need different rates; the Green Book points practitioners to the FCDO.
Sources and further reading
- Green Book supplementary guidance: discounting (October 2026), HM Treasury. STPR of 3.00% real for years 1 to 30, the declining schedule and the Annex A discount factors
- Green Book Discount Rate Review 2026: HM Treasury response, HM Treasury. The decision to reduce the rate from 3.50% to 3.00%
Frequently asked questions
What discount rate does the Green Book use?
The Social Time Preference Rate. HM Treasury's October 2026 supplementary guidance sets it at 3.00% in real terms for years 1 to 30, 2.50% for years 31 to 75 and 2.25% for years 76 to 125. Before that change the rate was 3.50% for the first 30 years.
Should I use nominal or real cash flows in a Green Book NPV?
Real. The guidance says the rate must be applied only to values in real terms, with general inflation removed first, and that adding inflation to the discount rate gives a mathematically incorrect result. Enter real costs and benefits and a 3.00% rate.
How do I discount a project longer than 30 years?
The Green Book rates step down as forward rates: 3.00% until year 30, then 2.50% from year 31 to 75. This calculator applies one rate throughout, so for a 40-year scheme either use the Annex A discount factors directly or run years 1 to 30 here and discount the later years separately.
Is the Green Book rate the right one for a private company?
Usually not. It reflects society's time preference, not the return investors require. A company deciding on its own investment would use its weighted average cost of capital or a hurdle rate, and the IRR shows how much room the project has.
Why does my old business case now show a higher NPV?
Because benefits further out are discounted less at 3.00% than at 3.50%. In the 10-year example above, the NPV moves from -£4,014.72 to £47,248.68 on the rate change alone. Re-run old appraisals at the current rate before comparing options.
Is there an in-depth guide to the NPV and IRR Calculator?
Yes. “Time Value of Money: PV, FV, NPV, IRR, CAGR and ROI Explained” covers the background, how it works, common pitfalls and worked examples. Read the full guide.
Related Tools You May Like
Free, in-browser tools that pair well with this one.