Answer the two assignment problems using Excel and show your work $($underlying formulas$)$ to demonstrate your understanding of the concepts and topics presented in Unit $1.$TaskYou have been asked to value Sonata Inc., a manufacturer of musical keyboards for computers. The company has estimated its free cash flows to equity and its cost of equity for the next $4$ years:Year$1234$EPS$$1\mathrm{.}50$$$1\mathrm{.}80$$$2\mathrm{.}16$$$2\mathrm{.}59$FCFE$-$$$2\mathrm{.}00-$$$1\mathrm{.}20$$$0\mathrm{.}34$$$0\mathrm{.}09$The earnings per share are expected to grow $6\%$ a year after year $4,$ and net capital expenditures are expected to decline $50\%$ after year $4.$ Sonata currently has a Beta of $1\mathrm{.}50$ and no debt or working capital needs but expects its Beta to drop to $1\mathrm{.}00$ after year $4.$ The debt ratio will remain at $0\%.$ The T$-$Bond rate is $4\%.$Using the above information, answer the following $($assuming a $100\%$ retention rate of earnings$)$:Estimate the terminal value of equity per shareEstimate the value per share today.You have been asked to review the valuation of Santiago Cement, a small Peruvian cement company, by an M&A analyst, for acquisition by a US cement company. The analyst has estimated a value of $1$ billion Peruvian Sol for the equity, based upon the expectation that the firm will generate $50$ million Peruvian sol in cash flows $($to equity$)$ next year, growing at $5\%($in sol$)$ a year forever; mistakenly, he used the US companys dollar cost of equity in the valuation. To correct the valuation, you have been provided with the following information:The U$.$S$.$ Treasury bond rate is $3\%$ and Peruvian dollar denominated bond rate is $5\%.$Peruvian equities are $1\mathrm{.}5$ times more volatile than the Peruvian dollar denominated bond, Perus equivalent of the U$.$S$.$ Treasury bond.The expected inflation rate in Peruvian sol is $6\%$ and the expected inflation rate in US dollars is $2\%.$The typical Peruvian company generates $80\%$ of its revenues in Peru, but Santiago Cement generates all its revenues in Peru.Using the information above, answer the following:Estimate the correct value of equity in Santiago Cement.SubmissionSubmit the answers to the above problems in an Excel document