Grand Canyon ACC 486 Module 3 Homework - Analysis Basics and Liquidity Ratios

Analysis Basics and Liquidity Ratios

Details:

Complete Problems 5-1 and Problems 6-11 in the Gibson text using Excel. (Label all work.)

APA format is not required, but solid academic writing is expected.

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

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).