Please provide the working out (prefer Microsoft excel)

The following table in the next slide provides information that enables the evaluatio of two project proposals to contribute to meeting the energy needs of a town for th next 50 years. a) Based on the financial evaluation of the two project proposals, estimate the following viability indicators: - Benefit-Cost Ratio (BCR) - Life Cycle Cost (LCC) - Equivalent Annual Cost (EAC) - INTERNAL RATE OF RETURN (IRR) b) Which project proposal will you recommend? \begin{tabular}{lrr} Parameters & ProposalA(Small-Hydro) & ProposalB(Thermal) \\ \hline Initial investment (\$Mn) & 500 & 300 \\ - Land & - & 700 \\ - Site preparation & 9,500 & 5,000 \\ - Other capital expenditure & & \\ Annual O\&M Cost (\$Mn) & 90 & 140 \\ - Salaries & 180 & 60 \\ - Repair & - & 360 \\ - Fuel & 30 & 40 \\ - Administration & 13,070 & 10,508 \\ Energy Sold (Mn. units per year) & 10 & 12 \\ Selling Price (cents/unit) & 1,900 & - \\ Salvage Value (\$Mn) & 10 & 10 \\ Real discount Rate (\%) & 50 & 25 \\ Economic Life (Year) & & \\ \hline \end{tabular}