How to calculate NPV in Excel (and the year-0 mistake)
Excel's NPV discounts the first number you give it. If that number is today's investment, your answer is wrong. Here's the fix, worked through, and a sheet that grades yours.
Finance & modelling
NPV, IRR, loan schedules and the formulas behind financial models.
Reading is step one. Writing the formula is the skill.
Practise in a live grid that grades what your formula calculates, with a specific hint when it's wrong.
Runs in your browser · Graded on your result · No install