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
- Monthly rate and number of paymentsAssuming each payment is made at the end of the month and interest is added monthly.
- Future value of regular paymentsThis is the sum of a geometric series: each payment grows for a different number of months.
- Substitute and evaluate
- Paid in and interest earned
- Check: add the money month by monthEach month: balance × (1 + r) + payment.
Change the numbers and solve your own
The method in brief
- Regular savings: FV = P × ((1 + r)^n - 1) ÷ r, with payments at the end of each month.
- NPV = sum of each cash flow ÷ (1 + r)^t. Year 0 is not discounted.
- A positive NPV means the project beats the required rate.
- IRR is found numerically as the rate that gives NPV = 0.
Full guide: Regular savings, net present value, IRR and doubling time.