NPV & IRR worksheet with answers

Free printable NPV & IRR worksheet: 6 problems from easy to exam level, with an answer key. Print it or save it as a PDF.

For teachers: free to print, copy and use in class. Every new worksheet has new values and its own answer key. A link to ExamProblems on your course page is appreciated.

Name: ____________________   Date: ____________

1.Easy
years01234? 5 0008 0008 0006 000

A machine is expected to save €5 000, €8 000, €8 000, €6 000 at the end of years 1 to 4, after which it is worthless. The required return is 8%. What is the most the company should pay for the machine today? Find PV.

r = 8%CF1 = 5 000CF2 = 8 000CF3 = 8 000CF4 = 6 000
PV = €
2.Easy
years01234−80 00033 00033 00033 00033 000

A project costs €80 000 today and returns €33 000 at the end of each year for 4 years. The required rate of return is 8%. Find the net present value NPV.

r = 8%CF0 = −80 000CF1 = 33 000CF2 = 33 000CF3 = 33 000CF4 = 33 000
NPV = €
3.Medium
years0123…9−400 00032 000+1%+1%…r = 11%, NPV = ?

A project costs €400 000 today. It generates €32 000 at the end of the first year, and the cash flow then grows by 1% per year forever. The cost of capital is 11%. Find the net present value NPV.

C0 = €400 000CF1 = €32 000g = 1%r = 11%
NPV = €
4.Medium
years0123456−50 0008 5008 5008 5008 5008 50016 000

A machine costs €50 000 today. It generates €8 500 at the end of each year for 6 years and can then be sold for €7 500. The cost of capital is 12%. Find the net present value NPV.

C0 = €50 000CF = €8 500S = €7 500n = 6r = 12%
NPV = €
5.Hard
years012−40 00017 50027 500

A project costs €40 000 and returns €17 500, €27 500 at the end of years 1 to 2. Find its internal rate of return IRR in percent.

CF0 = −40 000CF1 = 17 500CF2 = 27 500
IRR = %
6.Hard
r (%)NPVABr* = ?0

Project A costs €10 000 and returns €5 500, €4 000, €2 500 at the end of years 1 to 3. Project B costs €15 000 and returns €4 500, €6 000, €8 000. Find the crossover rate r* at which both projects have the same NPV, in percent.

A: −10 000, 5 500, 4 000, 2 500B: −15 000, 4 500, 6 000, 8 000
r* = %

Answer key

  1. 1. PV = 22249 €
  2. 2. NPV = 29300 €
  3. 3. NPV = −80000 €
  4. 4. NPV = −11253 €
  5. 5. IRR = 7.628 %
  6. 6. r* = 9.093 %

Full step-by-step solutions: practise this topic on examproblems.com.