Financial reporting chapter 5 problem 3

/in /by

Financial Reporting Chapter 5 Problem 3

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!