Explore BrainMass

Explore BrainMass

    Financial Ratios

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com June 4, 2020, 1:38 am ad1c9bdddf
    https://brainmass.com/business/financial-accounting-bookkeeping/financial-ratio-calculations-411636

    Attachments

    Solution Summary

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

    $2.19

    ADVERTISEMENT