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.

Open the Worksheet Studio
  1. save 200 per month at 4% for 10 years
  2. NPV of cash flows -1000, 300, 400, 500 at 8%
  3. IRR of cash flows -1000, 400, 400, 400
  4. NPV of cash flows -905, 322, 378, 526 at 8%
  5. IRR of cash flows -1001, 400, 449, 402
  6. how long to double at 2% interest
  7. how long to triple at 9% interest
  8. save 181 per month at 7% for 9 years
  9. NPV of cash flows -1066, 246, 458, 536 at 7%
  10. IRR of cash flows -954, 414, 437, 338

Answers

  1. save 200 per month at 4% for 10 years
    Show the working
    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.

    Open this question in the solver

  2. NPV of cash flows -1000, 300, 400, 500 at 8%
    Show the working
    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

    Open this question in the solver

  3. IRR of cash flows -1000, 400, 400, 400
    Show the working
    1. IRR is the rate that makes NPV = 0
      Cash flows from year 0: -1000, 400, 400, 400.
    2. Solve numerically (bisection)
      No algebra solves this in general, so we narrow the interval until NPV is zero.
    3. Check: NPV at this rate, computed another way (Horner form)

    Open this question in the solver

  4. NPV of cash flows -905, 322, 378, 526 at 8%
    Show the working
    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

    Open this question in the solver

  5. IRR of cash flows -1001, 400, 449, 402
    Show the working
    1. IRR is the rate that makes NPV = 0
      Cash flows from year 0: -1001, 400, 449, 402.
    2. Solve numerically (bisection)
      No algebra solves this in general, so we narrow the interval until NPV is zero.
    3. Check: NPV at this rate, computed another way (Horner form)

    Open this question in the solver

  6. how long to double at 2% interest
    Show the working
    1. Set up the growth equation
      Money growing by 2% a year is multiplied by 1.02 each year (compound interest, interest added yearly).
    2. Take logs
    3. Check: grow it for that long
    4. Rule of 72 comparison
      The rule of thumb 72 ÷ 2 = 36.0 years is close, but not exact.

    Open this question in the solver

  7. how long to triple at 9% interest
    Show the working
    1. Set up the growth equation
      Money growing by 9% a year is multiplied by 1.09 each year (compound interest, interest added yearly).
    2. Take logs
    3. Check: grow it for that long
    4. Rule of 72 comparison
      The rule of thumb 72 ÷ 9 = 8.0 years is close, but not exact.

    Open this question in the solver

  8. save 181 per month at 7% for 9 years
    Show the working
    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.

    Open this question in the solver

  9. NPV of cash flows -1066, 246, 458, 536 at 7%
    Show the working
    1. NPV formula
      Each cash flow is divided by (1 + r) once for every year it is away from today. r = 7%.
    2. Discounted cash flows
      Year 0 is not discounted.
    3. Add them up
      Positive NPV: the project returns more than the 7% required, so it is worth doing.
    4. Check: recompute with Horner nesting

    Open this question in the solver

  10. IRR of cash flows -954, 414, 437, 338
    Show the working
    1. IRR is the rate that makes NPV = 0
      Cash flows from year 0: -954, 414, 437, 338.
    2. Solve numerically (bisection)
      No algebra solves this in general, so we narrow the interval until NPV is zero.
    3. Check: NPV at this rate, computed another way (Horner form)

    Open this question in the solver

Learn the method: Savings, NPV and IRR calculator solver and worked examples. All worksheets: worksheet index.