Share
Explore BrainMass

Financial Ratios

Please calculate the financial ratios for 2010, 2009, and 2008.

See attached file for better formatting.

Assets Dec 2010 Dec 2009 Dec 2008 Dec 2007 Dec 2006
Current Assets
Cash 1,735.00 1,978.00 2,122.00 3,406.00 1,827.00
Net Receivables 15,079.00 15,840.00 9,782.00 10,460.00 9,906.00
Inventories Assets 8,405.00 12,403.00 4,381.00 5,302.00 6,111.00
Other Current Assets 35,249.00 31,449.00 26,791.00 27,681.00 29,105.00
Total Current Assets 60,468.00 61,670.00 43,076.00 46,849.00 46,949.00
Net Fixed Assets 19,123.00 22,780.00 13,287.00 15,734.00 16,632.00
Other Noncurrent Assets 115,423.00 128,499.00 54,785.00 52,685.00 51,256.00
Total Assets ($ Million) 195,014.00 212,949.00 111,148.00 115,268.00 114,837.00
Liabilities Dec 2010 Dec 2009 Dec 2008 Dec 2007 Dec 2006
Current Liabilities
Accounts Payable 4,026.00 4,370.00 1,751.00 2,270.00 2,019.00
Short-Term Debt 5,623.00 5,469.00 9,320.00 5,825.00 2,434.00
Other Current Liabilities 18,960.00 27,386.00 15,938.00 13,740.00 16,936.00
Total Current Liabilities 28,609.00 37,225.00 27,009.00 21,835.00 21,389.00
Long-Term Debt 38,410.00 52,193.00 7,963.00 7,314.00 5,546.00
Other Noncurrent Liabilities 40,182.00 33,517.00 18,620.00 21,109.00 16,544.00
Total Liabilities 107,201.00 122,935.00 53,592.00 50,258.00 43,479.00
Shareholder's Equity Dec 2010 Dec 2009 Dec 2008 Dec 2007 Dec 2006
Preferred Stock Equity 52.00 61.00 73.00 93.00 141.00
Common Stock Equity 87,761.00 89,953.00 57,483.00 64,917.00 71,217.00
Total Equity 87,813.00 90,014.00 57,556.00 65,010.00 71,358.00
Shares Outstanding 8,012.00 8,070.00 6,742.94 6,829.81 7,210.44

Dec 2010 Dec 2009 Dec 2008 Dec 2007 Dec 2006
Revenue 67,809.00 50,009.00 48,296.00 48,418.00 48,371.00
Cost of Goods Sold 16,279.00 8,888.00 8,112.00 11,239.00 7,640.00
Gross Profit 51,530.00 41,121.00 40,184.00 37,179.00 40,731.00
Gross Profit Margin (%) 76.00% 82.00% 83.00% 77.00% 84.00%
SG&A Expense 19,614.00 14,875.00 14,537.00 15,626.00 15,589.00
Depreciation & Amortization 5,404.00 2,877.00 2,668.00 3,128.00 3,261.00
Operating Income 13,760.00 11,119.00 11,726.00 7,519.00 12,124.00
Operating Margin (%) 20.00% 22.00% 24.00% 16.00% 25.00%
Nonoperating Income (2,941.00) 195.00 (2,804.00) 660.00 467.00
Nonoperating Expenses (1,397.00) (487.00) -- -- --
Income Before Taxes 9,422.00 10,827.00 9,694.00 9,278.00 13,028.00
Income Taxes 1,124.00 2,197.00 1,645.00 1,023.00 1,992.00
Net Income After Taxes 8,298.00 8,630.00 8,049.00 8,255.00 11,036.00
Continuing Operations 8,298.00 8,630.00 8,026.00 8,213.00 11,024.00
Discontinuing Operations (9.00) 14.00 78.00 (69.00) 8,313.00
Total Operations 8,257.00 8,635.00 8,104.00 8,144.00 19,337.00
Total Net Income 8,257.00 8,635.00 8,104.00 8,144.00 19,337.00
Net Profit Margin (%) 12.00% 17.00% 17.00% 17.00% 40.00%
Diluted EPS from Continuing Operations 1.02 1.23 1.19 1.18 1.52
Diluted EPS from Total Operations 1.02 1.23 1.20 1.17 2.66
Diluted EPS from Total Net Income 1.02 1.23 1.20 1.17 2.66
Dividends Per Share 0.72 0.80 1.28 1.16 0.96

Dec 2010 Dec 2009 Dec 2008
Cash and Cash Equivalents at the Beginning of the Year 1,978.00 2,122.00 3,406.00
Net Cash Provided in Operating Activities 11,454.00 16,587.00 18,238.00
Net Cash Provided by Investing Activities (492.00) (31,272.00) (12,835.00)
Net Cash Provided by Financing Activities (11,174.00) 14,481.00 (6,560.00)
Net Increase/Decrease in Cash and Cash Equivalents (243.00) (144.00) (1,284.00)
Cash and Cash Equivalents at the End of the Year 1,735.00 1,978.00 2,122.00

Attachments

Solution Summary

The solution explains Financial Ratios. Formatting current assets is provided.

$2.19