# NPV & IRR (Excel lesson 41 of 45)

> Is this project worth doing?

Source: https://spreadsheetpractice.com/learn/npv-irr · Updated October 29, 2026

- **Course:** [Excel course](https://spreadsheetpractice.com/learn), track "Finance"
- **Time:** about 10 minutes, 2 graded exercises
- **Functions:** `NPV`, `IRR`
- **Access:** Pro (the lesson text is free; the graded exercises need Pro)
- **Key formula:** `=NPV(E2,B3:B7)+B2`: NPV with year 0 outside

## How it works

`NPV(rate, values)` discounts future cash flows back to today. Excel's NPV assumes the first value arrives one period from now, so add the year-0 investment *outside* the function.

`IRR(values)` is the discount rate that makes NPV exactly zero. If it beats your required return, the project clears the bar.

## Syntax

| Formula | What it does |
|---|---|
| `=NPV(E2,B3:B7)+B2` | NPV with year 0 outside |
| `=IRR(B2:B7)` | Internal rate of return |

## Watch out for

- =NPV(E2,B2:B7) discounts the year-0 investment by a year, which overstates the result.
- IRR needs at least one negative and one positive cash flow.

## The exercises

Solve them in the live grid at [NPV & IRR](https://spreadsheetpractice.com/learn/npv-irr). Each answer is graded, then re-checked on changed data so typed-in numbers don't pass.

1. **Net present value.** In E4, calculate the project's NPV at the discount rate in E2. Year 0 is an upfront investment.
2. **Internal rate of return.** In E5, calculate the project's IRR.

Previous: [Future & present value](https://spreadsheetpractice.com/learn/future-and-present-value) · Next: [Handling errors on purpose](https://spreadsheetpractice.com/learn/errors-iferror-ifna)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
