Please review the following instructions to complete the Midterm Assignment. Make sure to thoroughly answer the questions presented with a strong supporting rationale. All written assignments should be formatted using APA.Assignment InstructionsGo to finance.yahoo.com and obtain the financial statements for Ford $($F$)$ and Microsoft $($M$).$What were capital expenditures and sales for each firm?What were the ratios of capital expenditure to sales for the last $3$ years for both the companies?What were the sales and net expenditures relative to total assets?What might explain the variation in these ratios for these two large corporations?Did the company make an investment or disinvestment in working capital in each of the $3$ years? Are you able to give me the excel chart for $2023-2022$ and $2021$