Savings, NPV and IRR calculator worksheet with answers
A-level: AS and A2 Tiers are typical for England, Wales and Northern Ireland specifications. Boards differ, so check your own specification.
10 practice questions on savings, npv and irr calculator. Print the questions on their own, or with the answers. Worked solutions for any question are one click away in the solver.
Name: ______________ Date: ________ Score: ____ / 10
save 200 per month at 4% for 10 yearsNPV of cash flows -1000, 300, 400, 500 at 8%IRR of cash flows -1000, 400, 400, 400NPV of cash flows -905, 322, 378, 526 at 8%IRR of cash flows -1001, 400, 449, 402how long to double at 2% interesthow long to triple at 9% interestsave 181 per month at 7% for 9 yearsNPV of cash flows -1066, 246, 458, 536 at 7%IRR of cash flows -954, 414, 437, 338
Answers
save 200 per month at 4% for 10 yearsShow the working
- 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.
NPV of cash flows -1000, 300, 400, 500 at 8%Show the working
- 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
IRR of cash flows -1000, 400, 400, 400Show the working
- IRR is the rate that makes NPV = 0Cash flows from year 0: -1000, 400, 400, 400.
- Solve numerically (bisection)No algebra solves this in general, so we narrow the interval until NPV is zero.
- Check: NPV at this rate, computed another way (Horner form)
NPV of cash flows -905, 322, 378, 526 at 8%Show the working
- 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
IRR of cash flows -1001, 400, 449, 402Show the working
- IRR is the rate that makes NPV = 0Cash flows from year 0: -1001, 400, 449, 402.
- Solve numerically (bisection)No algebra solves this in general, so we narrow the interval until NPV is zero.
- Check: NPV at this rate, computed another way (Horner form)
how long to double at 2% interestShow the working
- Set up the growth equationMoney growing by 2% a year is multiplied by 1.02 each year (compound interest, interest added yearly).
- Take logs
- Check: grow it for that long
- Rule of 72 comparisonThe rule of thumb 72 ÷ 2 = 36.0 years is close, but not exact.
how long to triple at 9% interestShow the working
- Set up the growth equationMoney growing by 9% a year is multiplied by 1.09 each year (compound interest, interest added yearly).
- Take logs
- Check: grow it for that long
- Rule of 72 comparisonThe rule of thumb 72 ÷ 9 = 8.0 years is close, but not exact.
save 181 per month at 7% for 9 yearsShow the working
- 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.
NPV of cash flows -1066, 246, 458, 536 at 7%Show the working
- NPV formulaEach cash flow is divided by (1 + r) once for every year it is away from today. r = 7%.
- Discounted cash flowsYear 0 is not discounted.
- Add them upPositive NPV: the project returns more than the 7% required, so it is worth doing.
- Check: recompute with Horner nesting
IRR of cash flows -954, 414, 437, 338Show the working
- IRR is the rate that makes NPV = 0Cash flows from year 0: -954, 414, 437, 338.
- Solve numerically (bisection)No algebra solves this in general, so we narrow the interval until NPV is zero.
- Check: NPV at this rate, computed another way (Horner form)
Learn the method: Savings, NPV and IRR calculator solver and worked examples. All worksheets: worksheet index.