Please solve part C&D using excel, showing all formulas.

yes, please show example through excel if you could.

V The following is the payoff matrix for two alternate plans. Assume the probability of the market being receptive is known to be 0.65. States of Nature Market Market Decision Alternative Receptive Unfavorable Plan a (dl) $40,000 $12,000 Plan b (42) $50,000 $6,000 a. Determine the expected monetary value (EMV) of each decision and give the best decision b. Determine the expected value of perfect information (EVPL). c. At what probabilities of the two states of nature the EMV of plan a (dl) will be $15,500? Probability of unfavorable = Probability of receptive d. At what probabilities of the two states of nature the EMV of Plan a would be the same as EMV of plan b