Show all work in Microsoft Excel Please. Complete work will be given a thumbs up.

PROBLEM 14.7A Basic Ratio Analysis L014-4, L014-5, 1014-7 Page 680 Best Buy is a leading provider of technology products, services, and solutions. The following selected information is adapted from the company's January 28, 2017, annual report. (Dollar amounts are stated in millions.) Total current assets Total current liabilities Total assets Total stockholders' equity Operating income Net income Beginning End of the Year of the Year $ 9,886 S 10,516 7,122 6,925 13,519 13,856 4,378 4,709 1,854 1,228 The company has long-term liabilities that bear interest at annual rates ranging from 6 percent to 8 percent. Instructions a. Compute the company's current ratio at (1) the beginning of the year and (2) the end of the year. (Carry to two decimal places.) b. Compute the company's working capital at (1) the beginning of the year and (2) the end of the year. (Express dollar amounts in thousands.) c. Is the company's short-term debt-paying ability improving or deteriorating? d. Compute the company's (1) return on average total assets and (2) return on average stockholders' equity. (Round average assets and average equity to the nearest dollar and final computations to the nearest I percent.) e. As an equity investor, do you think that Best Buy's management is utilizing the company's resources in a reasonably efficient manner? Explain