P5-1 Best Buy Co., Inc.’s consolidated balance sheets from its 2011 annual report

P5-1 Best Buy Co., Inc.’s consolidated balance sheets from its 2011 annual report

Please provideinexcel format,explanation on how you attained the solution.  Please solve all parts Thanks!

Problems5-1

P5-1 Best Buy Co., Inc.’s consolidated balance sheets from its 2011 annual report are presented in Exhibit 5-3.

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)

Thanks!