Note: Please provide complete solution with the full explanation including all the formulas in Excel.

BP has three potential sites where it can build a drilling rig. Due to its past experience, the CEO has instructed his management team to choose no more than one site. The costs, the revenues and the estimated outcomes for each site are given in the table below. Probabilities for the different outcomes Site Costs El (Overflowing) E2 (Wet) E3 (Dry) (in million $) Expected revenue: Expected revenue: Expected revenue: $30M $5M $0 A 2 0 0.2 B 8 0.3 0.5 0.2 6 0.2 0.4 0.4 0.8 For example, it costs $8M to build a drilling rig in site B. There's a 30% chance for E1 with potential revenue of $30M; 50% chance for E2 with potential revenue of $5M; and a 20% chance for E3 with zero revenue. 1. Calculate the EMV (10 points). 2. How much would the company be willing to pay for perfect information on all three sites (together)? Note that after finding out the true nature of each site, the company can still choose no more than one site. (15 points) 3. After a close vote, the company decided not to drill in sites A and B. It was also decided that site C would be chosen only if it were profitable to drill there. In addition, the company's CEO determined that site C could not be overflowing (state E1). Assuming that is true, how much would the company be willing to pay for perfect information on site C now? (10 points)