NPV Function
Calculates what a series of future cash flows is worth today.
Category
Financial
Available in
All versions, Microsoft 365
Returns
A net present value
Overview
NPV discounts future cash flows back to today at a chosen rate (your cost of capital). A positive result after subtracting the up-front cost means the project earns more than that rate.
The catch: NPV assumes the first value arrives one period from now. An investment made today must be added outside the function, not included in it.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| rate | Yes | The discount rate per period. |
| value1, value2, … | Yes | Cash flows, one per period, in order — as ranges or values. |
Examples
Example 1 — Should Northstar open the new store?
The fit-out costs $150,000 today and is expected to return four years of cash. Northstar's cost of capital is 8%.
| A | B | |
|---|---|---|
| 1 | Year | Cash flow |
| 2 | 0 (today) | -$150,000 |
| 3 | 1 | $40,000 |
| 4 | 2 | $50,000 |
| 5 | 3 | $60,000 |
| 6 | 4 | $55,000 |
| 7 | NPV | $17,960.55 |
Positive, so the store beats an 8% return by about $18,000 in today's money.
Example 2 — The classic mistake
Including today's $150,000 inside NPV discounts it by a year, as if it were spent in year 1.
| A | B | |
|---|---|---|
| 1 | Formula | Result |
| 2 | Wrong: cost inside NPV | $16,630.14 |
| 3 | Right: cost added after | $17,960.55 |
Common mistakes
- NPV is understated. The time-0 investment was put inside the function. Add it separately.
- Irregular dates. NPV assumes equal spacing. Use XNPV when cash arrives on specific dates.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.