Net Present Value (NPV): Formula, Calculation & Examples

What Is Net Present Value?

Net present value (NPV) is the difference between the present value of all future cash flows a project generates and the cost of the investment required to produce them — expressed in today's money. A positive NPV means the project creates value above its cost of capital. A negative NPV means it destroys value.

NPV is considered the gold standard of investment appraisal because it accounts for the time value of money (a pound today is worth more than a pound in five years), the full project life, and the risk-adjusted cost of capital. Unlike payback period or accounting rate of return, NPV directly measures value creation in monetary terms.

NPV is used in corporate finance for capital budgeting, in investment banking for DCF business valuations, in strategic planning for major expansion decisions, and in professional certification exams including ACCA AFM, CFA, CPA, and MBA corporate finance modules.

The NPV Formula

For equal annual cash flows (annuities), use the annuity factor: (1 − (1+r)⁻ⁿ) ÷ r. For infinite level cash flows (perpetuity): CF ÷ r. For a growing perpetuity: CF₁ ÷ (r − g) — known as the Gordon Growth Model, widely used in business valuations and dividend discount models.

How to Calculate NPV — Step by Step with Example

Five steps: identify all cash flows, choose the discount rate, calculate discount factors, multiply each cash flow by its discount factor, sum and subtract the initial investment.

Inflation: Real vs Nominal Cash Flows

The rule: nominal cash flows discounted at nominal rate; real cash flows discounted at real rate. Mixing them produces an incorrect NPV.

The compounding error — the most common inflation mistake in both exams and practice: candidates apply inflation as a flat annual addition (4% × 3 years = 12%) rather than compounding. A cash flow growing at 4% for three years is Base × 1.04³ = Base × 1.1249, not Base × 1.12. The gap widens each year and flows through into every subsequent tax and net cash flow calculation. Different components often inflate at different rates — keep a separate inflation row for each.

Working Capital and Tax

Working capital — two common errors

Error 1 — timing: The initial working capital requirement is an immediate cash outflow at Year 0, not Year 1. The project needs it before it starts generating revenue.

Error 2 — level vs change: Each year's cash flow is the change in working capital, not the total balance. If the project requires $50,000 in Year 1 and $65,000 in Year 2, the Year 2 outflow is $15,000 — the increase — not $65,000. The full balance is recovered as a cash inflow at project end.

Tax timing

In most exam contexts, tax is paid one year in arrears (Year 1 profit is taxed in Year 2). Tax allowable depreciation (TAD) creates annual tax savings — calculated on the reducing balance, with a balancing allowance or charge in the disposal year when the pool balance is compared against scrap proceeds. Keep TAD workings in a separate schedule; never embed them in the main cash flow table.

Overseas NPV: Multi-Currency Projects

When a project generates cash flows in a foreign currency, those flows must be converted using forecast exchange rates — not today's spot rate — before discounting. Forecast rates are derived using Purchasing Power Parity (PPP) or Interest Rate Parity Theory (IRPT) for each individual year.

Overseas profits are typically taxed twice — first in the host country, then by the home country (which gives credit for overseas tax already paid). The home country additional tax is applied to the same base that suffered overseas tax — not to the gross pre-tax overseas profit. Extra tax payable = max(home rate × overseas taxable profit − overseas tax paid, 0).

The parent benefits only from actual remittances — not the subsidiary's full accounting profit. Withholding taxes on dividends and remittance restrictions reduce the cash flows that reach the parent and must be included in the home-currency NPV.

Choosing the Right Discount Rate

NPV in Excel: =NPV() vs =XNPV()

Excel has two NPV functions. Most finance professionals prefer =XNPV() for real-world work — here is the difference.

=NPV() — the basic function

=NPV(rate, value1, value2, value3, ...)
Example: =NPV(0.10, 180000, 200000, 210000, 230000) − 540000

Important: Excel's =NPV() assumes cash flows occur at the end of each period and starts discounting from period 1 — it does NOT include Year 0. You must subtract the initial investment separately outside the function. Failing to do this is the most common Excel NPV mistake.

=XNPV() — the professional's choice

=XNPV(rate, values, dates)
Example: =XNPV(0.10, B2:B6, A2:A6)
Where column A = actual dates, column B = cash flows including the Year 0 outflow

=XNPV() uses actual dates for each cash flow — essential when cash flows do not occur at exactly equal annual intervals, when a project starts mid-year, or when there are irregular timing patterns. It includes all cash flows (including Year 0) in the range, so no separate subtraction is needed. Finance teams building capital expenditure models, M&A valuations, and project finance analyses use =XNPV() as standard practice.

MIRR in Excel

=MIRR(values, finance_rate, reinvest_rate)
Example: =MIRR(B2:B6, 0.10, 0.08)
Where finance_rate = cost of capital, reinvest_rate = return on reinvested cash flows

MIRR (Modified Internal Rate of Return) corrects IRR's unrealistic reinvestment assumption. It is more reliable than =IRR() for projects with non-conventional cash flows and is tested in ACCA AFM.

NPV vs IRR

In practice, finance teams typically present both — NPV for the decision, IRR for communicating the return to stakeholders who find percentages more intuitive than absolute monetary figures. MIRR is increasingly used instead of standard IRR because it avoids the reinvestment and multiple solutions problems.

How Finance Professionals Use NPV

NPV is not just an exam concept — it is the primary decision framework used by finance professionals across corporate roles. The context changes by seniority; the method stays the same.

Real Questions People Ask About NPV

NPV Interview Questions — Finance Roles

These questions appear regularly in finance manager, FP&A, corporate finance, and investment banking interviews. Here is what interviewers are looking for in each answer.

• Q: Explain NPV and how you would use it in a capital allocation decision.

  Strong answer: Define NPV (PV of future cash flows minus investment cost, discounted at cost of capital). State the decision rule (accept if positive). Give a brief practical example — evaluating a £2m warehouse investment by projecting annual savings discounted at WACC. Mention sensitivity analysis on key assumptions. Avoid generic textbook definitions — anchor it to something real.

• Q: What is the difference between NPV and IRR and when would you use each?

  Strong answer: NPV gives absolute monetary value; IRR gives a percentage return. For decisions and project ranking, NPV is superior — IRR can give misleading rankings for different-sized projects and assumes reinvestment at the IRR rate. IRR is useful for communicating returns to non-technical stakeholders. For non-conventional cash flows (multiple sign changes), use NPV or MIRR — standard IRR may produce multiple solutions.

• Q: Why does WACC matter in an NPV calculation?

  Strong answer: WACC is the minimum return the project must generate to satisfy both debt and equity investors. Using too low a WACC overstates NPV and leads to approving value-destroying projects. Using too high a hurdle rejects value-creating ones. WACC should reflect the risk of the specific project — for a project riskier than the firm's existing operations, a risk-adjusted rate (higher than WACC) is appropriate. Interest is never separately deducted from cash flows when using WACC — that would double-count the cost of debt.

• Q: A project has positive NPV but management is reluctant to proceed. What might explain this?

  Strong answer: Several legitimate reasons — capital rationing (higher NPV projects compete for the same budget), strategic misalignment (the project doesn't fit the company's direction), execution risk (the model looks good but management doubts the assumptions), ESG or reputational concerns, or timing (the NPV might be even higher if delayed). A positive NPV is necessary but not sufficient — qualitative factors, real options, and portfolio considerations all matter. This answer shows commercial judgment beyond the mechanics.

• Q: How do you handle uncertainty in an NPV model?

  Strong answer: Sensitivity analysis (vary one assumption at a time — what NPV is if revenue is 10% lower?), scenario analysis (best case / base case / downside), Monte Carlo simulation for complex projects. Identify the key value drivers — which single assumption, if wrong, would turn a positive NPV negative? That is where due diligence effort should focus. Real options analysis can value the flexibility to expand, delay, or abandon — these have value not captured in a static NPV model.

Why Students Fail NPV Questions

Five errors appear consistently in ACCA AFM exam scripts, university finance exams, and CFA question banks. All are avoidable with the right habits.

• 📅
  Discounting the Year 0 investment

  Year 0 is today — it has a discount factor of 1.0. Applying any other discount factor overstates the present cost and understates NPV. C₀ is subtracted directly, never multiplied by a discount factor.

• 📈
  Flat inflation instead of compounding

  Year 3 at 4% = Base × 1.04³, not Base × 1.12. Flat addition understates inflated cash flows and therefore understates NPV. The error grows each year. Always compound.

• 💼
  Working capital: wrong timing and using level not change

  Initial working capital is a Year 0 outflow. Annual flows are the year-on-year change in requirement, not the total balance. The full balance is recovered at project end — discounted, not at face value.

• 🕐
  Tax timing errors

  Tax is usually paid one year in arrears in exam questions — Year 1 profit is taxed in Year 2. Using the same-year payment, or omitting the timing lag entirely, misplaces cash flows and changes NPV. Read the question's tax timing assumption explicitly.

• 📉
  Using the wrong discount rate

  WACC for a riskier-than-average project overstates NPV. Cost of equity when a WACC is appropriate understates it. Deducting interest from cash flows and then discounting at WACC double-counts the cost of debt. Match the rate to the cash flow type and the financing structure.

For the full list of AFM-specific NPV errors with fixes, see our ACCA AFM mistakes guide.

Related Guides on Eduyush

• ACCA AFM mistakes guide — all recurring failure patterns in AFM with fixes
• Overseas investment appraisal — full multi-currency NPV step by step
• AFM business valuation methods — DCF, FCFF, Gordon Growth Model
• AFM hedging guide — collars, futures, options, FRAs
• Browse all AFM articles on Eduyush
• All 13 ACCA subjects explained
• What is the hardest ACCA paper?

Frequently Asked Questions