Skip to main content

NPV profile

An NPV profile is a graph plotting a project's net present value against a range of discount rates, showing the IRR where the line crosses zero and how project rankings can shift across rates.

ByHoang TruongUpdated

See it move

Loading infographic...

A project costing €10,000 with €4,000 a year for three years has an NPV of €2,000 at a 0% discount rate, falling to about −€53 at 10%. Because the line crosses from positive to negative between those rates, the project's internal rate of return sits just under 10%, close to 9.7%.

Where it fits
TopicCapital Budgeting & Investment AppraisalCoreSubjectCorporate FinanceCore

The formula

LaTeX
NPV(r)=C0+t=1nCFt(1+r)tNPV(r) = -C_0 + \sum_{t=1}^{n} \frac{CF_t}{(1+r)^t}

Variables

Initial outlay ()
Cash flow in year t ()
Discount rate (decimal)
Final year of the project (years)
Year index (year)

Evaluating this expression at many discount rates r and plotting the resulting NPV values produces the project's NPV profile.

Check yourself

PracticeCORE

GreenPeak Ltd is evaluating a project with an initial outlay of €15,000 and expected inflows of €6,000 a year for three years. Its NPV profile shows an NPV of €1,339 at a 5% discount rate and an NPV of −€1,301 at a 15% discount rate. Reading the NPV profile, which of the following is the best estimate of the project's IRR?

Select an answer to check your understanding.
NPV profile — Edlintics Glossary