Question: Please solve in excel. 5. Consider the cash flows below: . D E 180 130 B 6 Project cash flows 7 8 9 10 -50

Please solve in excel.
5. Consider the cash flows below: . D E 180 130 B 6 Project cash flows 7 8 9 10 -50 11 12 13 90 . 60 -50 -100 a. If the cost of capital is 30% and the risk-free rate is 5%, find the state prices which match the project's NPV. b. If there exists an abandonment option so that we can change all negative cash flows to zero, value the project. 5. Consider the cash flows below: . D E 180 130 B 6 Project cash flows 7 8 9 10 -50 11 12 13 90 . 60 -50 -100 a. If the cost of capital is 30% and the risk-free rate is 5%, find the state prices which match the project's NPV. b. If there exists an abandonment option so that we can change all negative cash flows to zero, value the project
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
