Please give details of Formula used and excel functions. Kindly upload excel file if possible.

Question 1 [based on Chapter 10) A city in the Midwest has made a decision to expand the electricity production in its area by building a new power plant. The city government must decide whether the plant will be powered by coal or whether the plant will be built on a river and use hydropower. The planning horizon is 40 years, and the assumed cost of capital is 7%. Compute a conventional BIC ratio, using Aw, with disbenefits in the numerator for each of the two alternatives, determine which one should be chosen, and explain why. The coal alternative would require a 550 million capital investment, a $500,000 annual operating expense, and bring about $2 million in annual operating revenue. In addition, the environmental harm and pollution impact caused by the plant is estimated to amount to $1 million annually. The plant is estimated to have a $400,000 worth of positive annual impact on the economic development of the city. The hydroelectric alternative would require a $90 million capital investment, a $200,000 annual operating expense, and bring $1.5 million in annual operating revenue. The plant is expected to have no signicant negative impact on the environment. The benets of improved flood protection, water management, as well as shing and recreation are expected to total 56 million annually