Explore BrainMass
Share

Payback period, NPV, IRR

Strategic decision makers are required to be able to evaluate projects based on the long-term objectives of the firm as well as the project's ability to earn the company additional compensation. The 3 main tools used to make this evaluation are the pay-back period, net present value (NPV), and internal rate of return (IRR).
Year Project #1 Project #2 Project #3
0 ($30,000) ($32,000) ($35,000)
1 $11,000 $15,000 $11,000
2 $11,000 $14,000 $11,000
3 $11,000 $11,000 $11,000
4 $11,000 $2,000 $11,000
5 $11,000 $500 $11,000
Scenario NPV Rate
1 5%
2 5.5%
3 6%
Using the data in the tables above, answer the following questions:
- Calculate the NPV for each project using each scenario's NPV rate. Show your work.
- Calculate the pay-back period for each project. Show your work.
- Calculate the IRR for each project. Show your work.
- Which project would the company select using the NPV method in scenario 1? Explain your answer.
- Which project would the company select using the NPV method in scenario 2? Explain your answer.
- Which project would the company select using the NPV method in scenario 3? Explain your answer.
- Which project would the company select using the pay-back period? Explain your answer.
- Which project would the company select using the IRR method? Explain your answer.

© BrainMass Inc. brainmass.com July 22, 2018, 1:16 am ad1c9bdddf

Attachments

Solution Summary

Strategic decision makers are required to be able to evaluate projects based on the long-term objectives of the firm as well as the project's ability to earn the company additional compensation. The 3 main tools used to make this evaluation are the pay-back period, net present value (NPV), and internal rate of return (IRR).
Year Project #1 Project #2 Project #3
0 ($30,000) ($32,000) ($35,000)
1 $11,000 $15,000 $11,000
2 $11,000 $14,000 $11,000
3 $11,000 $11,000 $11,000
4 $11,000 $2,000 $11,000
5 $11,000 $500 $11,000
Scenario NPV Rate
1 5%
2 5.5%
3 6%
Using the data in the tables above, answer the following questions:
- Calculate the NPV for each project using each scenario's NPV rate. Show your work.
- Calculate the pay-back period for each project. Show your work.
- Calculate the IRR for each project. Show your work.
- Which project would the company select using the NPV method in scenario 1? Explain your answer.
- Which project would the company select using the NPV method in scenario 2? Explain your answer.
- Which project would the company select using the NPV method in scenario 3? Explain your answer.
- Which project would the company select using the pay-back period? Explain your answer.
- Which project would the company select using the IRR method? Explain your answer.

$2.19