Question: please answer and explanation (if you can please attach the excel sheet) You are considering opening a new plant. The plant will cost $95.6 million

 please answer and explanation (if you can please attach the excelplease answer and explanation (if you can please attach the excel sheet)

You are considering opening a new plant. The plant will cost $95.6 million upfront. After that, it is expected to produce profits of $30.5 million at the end of every year. The cash flows are expected to last forever. Calculate the NPV of this investment opportunity if your cost of capital is 7.3%. Should you make the investment? Calculate the IRR. Use the IRR to determine the maximum deviation allowable in the cost of capital estimate to leave the decision unchanged. Calculate the NPV of this investment opportunity if your cost of capital is 7.3%. The NPV of this investment opportunity is $ million. (Round to one decimal place.) Should you make the investment? (Select the best choice below.) O A. No, because the NPV is not greater than the initial costs. O B. Yes, because the project will generate cash flows forever. O C. Yes, because the NPV is positive. OD. No, because the NPV is less than zero. Calculate the IRR. The IRR of the project is %. (Round to two decimal places.) Use the IRR to determine the maximum deviation allowable in the cost of capital estimate to leave the decision unchanged. The maximum deviation allowable in the cost of capital is %. (Round to two decimal places.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!