Grand Canyon ACC-486 Module 3 Assignment 2016

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

P 6-11 A partial balance sheet and income statement for King Corporation follow:
Compute the following:

a. Working capital
b. Current ratio
c. Acid-test ratio
d. Cash ratio
e. Days’ sales in receivables
f. Accounts receivable turnover in days
g. Days’ sales in inventory
h. Inventory turnover in days
i. Operating cycle