Please use excel to answer these questions. I did not know what to put for the subject but I am looking for someone who knows excel proficiently to answer these questions.

Scenario: Questions: The Greater Toronto Airports Authority is expanding again to accommodate the increasing number of flights being routed through Toronto. Plans are currently being developed to build another airport outside the city limits. Two possible locations have been identified , but a final decision on the Q1. What is the estimated payoff using the Maximax heuristic? new location is not expected to be made for another year. Response: The WelcomeStay chain of hotels intends to build a new facility near the new airport once its site is determined. Kirsten Brown is responsible for real Q2. What parcel(s) of land should be bought based on the Maximax heuristic? estate acquisition for the company, and she faces a difficult decision about where to buy land. Currently, land values around the two possible sites Response: for the new airport are increasing as investors speculate that property values will increase greatly in the vicinity of the new airport. The Cashflows- and-Payoff worksheet summarizes the current price of each parcel of land, the estimated present value of future cash flows that a hotel would generate at each site if the airport is ultimately located at the site, and the present value of the amount for which the company believes it can resell Q3. What is the estimated payoff using the Maximin heuristic? each parcel if the airport is not built at the site. Response: The company can buy either site, both sites, or neither site. Kirsten must decide which sites, if any, the company should purchase. Q4. What parcel(s) of land should be bought based on the Maximin heuristic? Response: Tasks: In the Cashflows-and-Payoff worksheet, go through the Payoff Matrix to see how the the payoff values in the shaded cells have been calculated Q5. What is the estimated payoff using the Averaging heuristic? (You are only required to verify the formulas to make sense of the process. No additional calculations are needed here). Response: Create a new worksheet titled "Decision-Heuristics", and copy the Payoff Matrix to that worksheet. Q6. What parcel(s) of land should be bought based on the Averaging heuristic? Response: - Using the Payoff Table, formulate a decision model that shows what decision Kirsten would make if she were to use the Maximax, Maximin, and Averaging heuristics to decide which pacels of land to buy. Based on your model, answer the questions in the question box on the right. Q7. What is the estimated payoff using the EMV heuristic? After interviewing some industry experts and researching municipal zoning plans, WelcomeStay now estimates that there is a 40% chance that the Response: airport will be built at location A, and a 60% chance that it will be built at location B. Q8. What parcel(s) of land should be bought based on the EMV heuristic? Based on this new information, formulate a decision model that shows what decision should be made based on the Expected Monetary Value Response: (EMV) decision heursitic. Based on your model, answer the questions in the question box on the right.Cash Flows Parcel of Land Near Location A B Current purchase price $18 $12 Present value of future cash flows if hotel and airport are built at this location $31 $23 Present value of future sales price of parcel if the airport is not built at this location $6 $4 (Note: All values are in millions of dollars.) Payoff Matrix Land Purchased at Location(s) Airport is Built at Location A B A $13.00 -$12.00 B -$8.00 $11.00 A&B $5.00 $1.00 None $0.00 50.00 $13.00 (Note: All values are in millions of dollars.)