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 formulaEach cash flow is divided by (1 + r) once for every year it is away from today. r = 8%.
- Discounted cash flowsYear 0 is not discounted.
- Add them upPositive NPV: the project returns more than the 8% required, so it is worth doing.
- Check: recompute with Horner nesting
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.