Question: Show work in excel please Question 2: Consider the project whose cash flows are given below: begin{tabular}{|c|c|c|c|c|c|c|c|} hline & & & & 169 & &

Show work in excel please
Question 2: Consider the project whose cash flows are given below: \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & & & & 169 & & State prices & \\ \hline & & 130 & & & & qu & 0.3000 \\ \hline & & & & 91 & & qd & 0.5000 \\ \hline-100 & & & & & & & \\ \hline & & & & 91 & & & \\ \hline & & 70 & & & & & \\ \hline & & & & -90 & & & \\ \hline & & & & & & & \\ \hline \end{tabular} a. (30 points) Using the state prices, value the project. b. (25 points) Suppose that at date 2 the project can be abandoned at no cost. What does this do to its value? c. (15 points) Suppose that at any time the project can be sold for 100 . Show the tree of cash flows and value the project. (Put your answers in Sheet "Answer_Q2")
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
