Please answer both and show work/provide excel calculations.

Alcindor Climate Control is evaluating a proposal to move some manufacturing operations from an obsolete plant in Kentucky to a new facility in Mexico. The new facility will cost $68 million to open and is expected to result in savings of $18 million per year for the first 5 years. At the end of 5 years, Alcindor will decide either to close the plant in Mexico or to keep it indefinitely. If Alcindor closes the plant, it believes the building and equipment can be sold for $28 million. If the plant is kept, assume that the $18 million annual cost savings would tum into a perpetuity. There is a 81% chance the plant will remain in operation after 5 years. What is the expected NPV (in \$ millions, rounded to one decimal place, e.g. 12.3) of the project, given a weighted average cost of capital of 996 ? Question 2 An alternative energy project will cost $320 million, Depending on the price of electricity, the project will create after-tax savings of either $110 million per year for 3 years or $76 million per year for 3 years. There is a 59% likelihood of the higher outcome occurring. If first year savings are only $76 million, the project can be sold at the end of the first year for $240 million. What is the expected NPV of the project (in s millions, rounded to one decimal place, e.g., 12.3) if the option to abandon the project after the first year is considered, given a discount rate of 12%