Worked solution: NPV of cash flows -1000, 300, 400, 500 at 8%

Step-by-step working for this savings, npv and irr problem, produced and checked by the solver.

NPV Answer checked
Answer
NPV=£17.63NPV = \pounds17.63
  1. NPV formula
    Each cash flow is divided by (1 + r) once for every year it is away from today. r = 8%.
  2. Discounted cash flows
    Year 0 is not discounted.
  3. Add them up
    Positive NPV: the project returns more than the 8% required, so it is worth doing.
  4. Check: recompute with Horner nesting

Change the numbers and solve your own

The method in brief

  1. Regular savings: FV = P × ((1 + r)^n - 1) ÷ r, with payments at the end of each month.
  2. NPV = sum of each cash flow ÷ (1 + r)^t. Year 0 is not discounted.
  3. A positive NPV means the project beats the required rate.
  4. IRR is found numerically as the rate that gives NPV = 0.

Full guide: Regular savings, net present value, IRR and doubling time.

More A-level examples on this topic