Question

Comparing all methods. Risky Business is looking at a project with the following estimated cash flow: 5. Risky Business wants to know the payback period, NPV, IRR, MIRR, and Pl of this project. The appropriate discount rate for the project is 9%. If the cutoff period is 6 years for major projects, determine whether the management at Risky Business will accept or reject the project under the five different decision models. What is the payback period for the new project at Risky Business? 5.20 years (Round to two decimal places.) Under the payback period, this project would be accepted . (Select from the drop-down menu.) What is the NPV for the project at Risky Business? (Round to the nearest cent.) Data Table (Click on the following icon in order to copy its contents into a spreadsheet.) Initial investment at start of project: $12,600,000 Cash flow at end of year one: $2,016,000 Cash flow at end of years two through six: $2,520,000 each year Cash flow at end of years seven through nine: $2,419,200 each year Cash flow at end of year ten: $1,728,000 Print Done Enter your answer in the answer box and the

Answer 1

1.
=1+(12600000-2016000)/2520000
=5.200000

2.
Accept as payback is less than cutoff

3.
NPV=-12600000+2016000/1.09+2520000/1.09^2+2520000/1.09^3+2520000/1.09^4+2520000/1.09^5+2520000/1.09^6+2419200/1.09^7+2419200/1.09^8+2419200/1.09^9+1728000/1.09^10
=2623422.433712

4.
Accept

5.
=IRR({-12600000;2016000;2520000;2520000;2520000;2520000;2520000;2419200;2419200;2419200;1728000})
=13.56%

6.
Accept

7.
PI=1+2623422.433712/12600000=1.208208

8.
Accept