1. Obtain industry averages for Ford (F) , Microsoft (MSFT) " for the last 4 years 2016,2017,2018,2019. A) Compare each firms ratios to the available industry ratios for the most recent year. (Ignore the Company column as your calculations will be different.) B) Analyze the performance of each firm versus the industry and comment on any trends in each individual firms performance. Identify any strengths or weaknesses you find in each firm. 2.Examine the Market-to-Book ratios you calculated for each firm. Which, if any, of the two firms can be considered growth firms and which, if any, can be considered value firms? 3.Compare the valuation ratios across the two firms. How do you interpret the difference between them? 4.Consider the enterprise value of each firm for each of the four years. How have the values of each firm changed over the time period?

please need answer in excel file , thank you

sorry not for the last 4 years , but the recent year which is 2019 , thank you