See attachment. Question

P 5-1 Best Buy Co., Inc.'s consolidated balance sheets from its 2011 annual report are presented in Exhibit 5-3. Required a. Using the balance sheets, prepare a vertical common-size analysis for 2011 and 2010. Use total assets as a base. b. Using the balance sheets, prepare a horizontal common-size analysis for 2011 and 2010. Use 2010 as the base. c. Comment on significant trends that appear in (a) and (b). Best Buy Co,Inc Vertical Common size analysis 26-Feb-13 2011 Assets Current Assets Cash and cash equivalents Short term investments Receivables Merchandise Inventories Other current assets Total current assets 3.1 0.1 11.8 30 6.7 51.7 27-Feb 2010 11.3 0.5 4.3 36.9 4.6 57.6