Dell INC. Balance Sheet

February 3, 2012- January 28, 2011

Assets

Current assets:

Cash and cash equivalents 13,852 – 13,913

Short-term investments 966 – 452

Accounts recievable, net 6,476 – 6,493

Short-term financing recievables, net 3,327 – 3,643

Inventories, net 1,404 – 1,301

Other current assets 3,423 – 3,219

Total current assets 29,448 – 29,021

Property, plant and equipment, net 2,124 – 1,953

Long term investments 3,404 – 704

Long term financing receivables, net 1,372 – 799

Goodwill 5,838 – 4,365

Purchased intangible assets, net 1,857 – 1,495

Other non-current assets 490 – 262

Total assets 44,533 – 38,599

Liabilities and Stockholders Equity

Current liabilities:

Short-term debt 2,867 – 851

Accounts payable 11,656 – 11,293

Accrued and other 3,934 – 4,181

Short-term deferred services revenue 3,544 – 3,158

Total current liabilities 22,001 – 19,483

Long-term debt 6,387 – 5,146

Long-term deferred services revenue 3,836 – 3,518

Other non-current liabilities 3,392 – 2,686

Total Liabilities 35,616 – 30,833

Stockholders equity:

Common stock and capital in excess of $.01 par value 12,187 – 11,797

Treasury stock at cost: 1,154 and 976 shares, respectively (31,445) – (28,704)

Retained earnings 28,236 – 24,744

Accumulated other comprehensive loss (61) – (71)

Total stockholders equity 8,917 – 7,766

Total liabilities and stockholders equity 44,533 – 38,599

Answer the following:

Income statement horizontal analysis and vertical analysis.

Balance sheet horixontal analysis and vertical analysis

Liquidity ratios: Current Ratio and Quick Ratio

Profitability Ratios: Gross profit percentage, net profit margin, return on assets, return on equity, and earnings per share.

Activity Ratios: Inventory turnover, days inventory on hand, accounts receivable turnover, das sales uncollected, accounts payable turnover, days payable, and
asset turnover.

Debt Ratio: Total debt ratio, times interest earned.

Mark Ratios: Earning Ratio and dividened yeild (Assume that the average market price per share 2010 is 15.00 and the company paid dividends of $4)

Round percentages