Perform the calculations listed on the Excel spreadsheet .

Your Name: Use the additional worksheets as reference for the Financial Statements of Johnson & Johnson as well as your assigned Publicly Trad 1. Calculate the following financial ratios : a. Current ratio Current assets Current liabilities Current ratio b. Profit Margin Ratio Net income Net sales Profit Margin Ratio c. Return on common stockholders' equity Net income Preferred dividends Average common stockholder's equity Return on common stockholders' equity d. Debt-to-equity ratio Total liabilities Total equity Debt-to-equity ratio e. Number of days' sales in receivables or uncollected (Consider 365 days in a year) Current receivable Net sales Number of days f. Inventory turnover ratio (Assume that all purchases are on credit unless other information is given.) Cost of goods sold Average inventory Inventory turnover ratio g. Number of days' sales in inventory (Consider 365 days in a year) Merchandise Inventory Cost of good sold Number of days nson as well as your assigned Publicly Traded Company Johnson & Johnson Publicly Traded Company $ $ $ $ Formula Formula $ $ $ $ Formula Formula $ $ $ $ $ $ Formula Formula $ $ $ $ Formula Formula $ $ $ $ Formula Formula $ $ $ $ Formula Formula sider 365 days in a year) $ $ $ $ Formula Formula 2015 Assets Current Assets Cash and short-term investments $ 6,460 Receivables - trade and other (use for ratio) 6,695 Receivables - finance 8,991 Deferred and refundable income taxes 1,526 Prepaid expenses and other current assets 1,046 Inventories 9,700 Total current assets Property, plant and equipment - net Long-term receivables - trade and other Long-term receivables - finance Investments in unconsolidated affiliated companies $ 34,418 16,090 1,170 13,651 246 Noncurrent deferred and refundable income taxes 1,654 Intangible assets 2,821 Goodwill 6,615 Other assets 1,832 Total assets $ 78,497 Liabilities and Shareholders' Equity Current Liabilities Short-term borrowings: Machinery, Energy & Transportation $ 9 Financial Products 6,958 Accounts payable 5,023 Accrued expenses 3,116 Accrued wages, salaries and employee benefits 1,994 Customer advances 1,146 Dividends payable Other current liabilities 448 1,730 Long-term debt due within one year: Machinery, Energy & Transportation Financial Products Total current liabilities 517 5,362 26,303 Long-term debt due after one year: Machinery, Energy & Transportation 9,004 Financial Products 16,243 Liability for postemployment benefits 8,843 Other liabilities 3,219 Total liabilities $ 63,612 $ - Shareholders' equity Common stock of $1.00 par value: Authorized shares: 2,000,000,000 Issued shares: (2015 and 2014 - 814,894,624 shares) at paid-in amount Treasury stock: (2015 - 232,572,734 shares and 2014 - 208,728,065 shares) at cost Profit employed in the business 5,238 -17,640 34,208 Accumulated other comprehensive income (loss) -6,997 Noncontrolling interests 76 Total shareholders' equity Total liabilities and shareholders' equity 14,885 $ 78,497 2014 7,341 7,737 9,027 1,739 818 12,205 38,867 16,577 1,364 14,644 257 1,404 3,076 6,694 1,798 84,681 9 4,699 6,515 3,548 2,438 1,697 424 1,754 510 6,283 27,877 9,493 18,291 8,963 3,231 67,855 - 5,016 -15,726 33,887 -6,431 80 16,826 84,681 Sales and revenues: $ Sales of Machinery, Energy & Transportation 44,147 Revenues of Financial Products 2,864 Total net sales and revenues 47,011 Operating costs: Cost of goods sold 33,742 Selling, general and administrative expenses 5,199 Research and development expenses 2,165 Interest expense of Financial Products 587 Other operating (income) expenses 2,062 Total operating costs 43,755 Operating profit 3,256 Interest expense excluding Financial Products 507 Other income (expense) 106 Consolidated profit before taxes 2,855 Provision (benefit) for income taxes 742 Profit of consolidated companies 2,113 Equity in profit (loss) of unconsolidated affiliated companies - Profit of consolidated and affiliated companies 2,113 Less: Profit (loss) attributable to noncontrolling interests Net income 11 $ 2,102 22,746 51,585 21,954 178 -67 533 -70 0 20,563 4,240 16,323