A machine is expected to save €18 000, €8 000, €15 000 at the end of years 1 to 3, after which it is worthless. The required return is 6%. What is the most the company should pay for the machine today? Find PV.
NPV & IRR worksheet with answers
A project costs €60 000 today and returns €14 500, €18 500, €20 000, €13 500 at the end of years 1 to 4. Assume cash flows arrive evenly through each year. Find the payback period PB in years.
An investment of €45 000 gives these cash flows at the end of years 1 to 4: €13 000, €21 000, €13 000, €13 000. The cost of capital is 15%. Find the net present value NPV.
An investment of €45 000 gives these cash flows at the end of years 1 to 3: €13 000, €11 000, €13 000. The cost of capital is 7.000000000000001%. Find the net present value NPV.
A project costs €40 000 and returns €16 000, €27 000 at the end of years 1 to 2. Find its internal rate of return IRR in percent.
A project costs €25 000 and returns €11 000, €16 000, €15 500 at the end of years 1 to 3. Find its internal rate of return IRR in percent.
Answer key
- 1. PV = 36695 €
- 2. PB = 3.519 years
- 3. NPV = −1836 €
- 4. NPV = −12631 €
- 5. IRR = 4.558 %
- 6. IRR = 29.96 %
Full step-by-step solutions: practise this topic on examproblems.com.