Worked solution: save 200 per month at 4% for 10 years

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

Regular savings Answer checked
Answer
FV=£29,449.96FV = \pounds29,449.96
  1. Monthly rate and number of payments
    Assuming each payment is made at the end of the month and interest is added monthly.
  2. Future value of regular payments
    This is the sum of a geometric series: each payment grows for a different number of months.
  3. Substitute and evaluate
  4. Paid in and interest earned
  5. Check: add the money month by month
    Each month: balance × (1 + r) + payment.

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