Lesson 41 of 45, Finance
NPV & IRR
Quick answer
Is this project worth doing?
- Key formula
=NPV(E2,B3:B7)+B2(NPV with year 0 outside)
Watch it done
2 stepsWatch the technique worked out on sample data, then try it yourself in the exercises.
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
=NPV(E2,B3:B7)+B2NPV with year 0 outside=IRR(B2:B7)Internal rate of returnWatch 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
- Net present value. In E4, calculate the project's NPV at the discount rate in E2. Year 0 is an upfront investment.
- Internal rate of return. In E5, calculate the project's IRR.
Questions people ask about this
Updated Checked by running: every exercise answer on this page was graded by our formula engine on .
Graded practice for this lesson is part of Pro
The walkthrough and notes are open to everyone. Pro unlocks the exercises here and in the other 43 Pro lessons, Excel and Google Sheets, 125 exercises in all.
- Net present value
- Internal rate of return