Please show all work/excel equations!

Thank you!

15. Rezoning Property. A real estate investor has the opportunity to purchase land currently zoned as residential. If the county board approves a request to rezone the property as commercial within the next year, the investor will be able to lease the land to a large discount firm that wants to open a new store on the property. However, if the zoning change is not approved, the investor will have to sell the property at a loss. Profits (in thousands of dollars) are shown in the following payoff table: State of Nature Decision Alternative Rezoning Approved, s1 Rezoning Not Approved, s2 Purchase, da 600 -200 Do not purchase, de a. If the probability that the rezoning will be approved is 0.5, what decision is recommended? What is the expected profit? 0 0 b. The investor can purchase an option to buy the land. Under the option, the investor maintains the rights to purchase the land anytime during the next three months while learning more about possible resistance to the rezoning proposal from area residents. Probabilities are as follows: Let H = high resistance to rezoning L = low resistance to rezoning P(H) = 0.55 P(31\H) = 0.18 P(52|H) = 0.82 P(L) = 0.45 P(s1|L) = 0.89 P(s2|L) = 0.11 What is the optimal decision strategy if the investor uses the option period to learn more about the resistance from area residents before making the purchase decision? c. If the option will cost the investor an additional $10,000, should the investor purchase the option? Why or why not? What is the maximum that the investor should be willing to pay for the option? 15. Rezoning Property. A real estate investor has the opportunity to purchase land currently zoned as residential. If the county board approves a request to rezone the property as commercial within the next year, the investor will be able to lease the land to a large discount firm that wants to open a new store on the property. However, if the zoning change is not approved, the investor will have to sell the property at a loss. Profits (in thousands of dollars) are shown in the following payoff table: State of Nature Decision Alternative Rezoning Approved, s1 Rezoning Not Approved, s2 Purchase, da 600 -200 Do not purchase, de a. If the probability that the rezoning will be approved is 0.5, what decision is recommended? What is the expected profit? 0 0 b. The investor can purchase an option to buy the land. Under the option, the investor maintains the rights to purchase the land anytime during the next three months while learning more about possible resistance to the rezoning proposal from area residents. Probabilities are as follows: Let H = high resistance to rezoning L = low resistance to rezoning P(H) = 0.55 P(31\H) = 0.18 P(52|H) = 0.82 P(L) = 0.45 P(s1|L) = 0.89 P(s2|L) = 0.11 What is the optimal decision strategy if the investor uses the option period to learn more about the resistance from area residents before making the purchase decision? c. If the option will cost the investor an additional $10,000, should the investor purchase the option? Why or why not? What is the maximum that the investor should be willing to pay for the option