A project costs €20 000 today and returns €5 000, €8 000, €3 000, €7 000 at the end of years 1 to 4. Assume cash flows arrive evenly through each year. Find the payback period PB in years.
NPV & IRR worksheet with answers
A project costs €20 000 today and returns €6 000 at the end of each year for 5 years. The required rate of return is 8%. Find the net present value NPV.
A project costs €20 000 today and returns €7 000 at the end of each year for 6 years. The cost of capital is 8%. Assume cash flows arrive evenly through each year. Find the discounted payback period DPB in years.
A machine costs €60 000 today. It generates €10 000 at the end of each year for 8 years and can then be sold for €15 000. The cost of capital is 8%. Find the net present value NPV.
A project costs €80 000 today. Its cash flow is €19 000 at the end of year 1 and grows by 3% per year until the last cash flow at the end of year 5. The cost of capital is 10%. Find the net present value NPV.
A project costs €20 000 and returns €11 500, €14 500 at the end of years 1 to 2. Find its internal rate of return IRR in percent.
Answer key
- 1. PB = 3.571 years
- 2. NPV = 3956 €
- 3. DPB = 3.381 years
- 4. NPV = 5570 €
- 5. NPV = −3951 €
- 6. IRR = 18.62 %
Full step-by-step solutions: practise this topic on examproblems.com.