ACCT500_Finance_Module_1_Assessment_Template (1).xls - Instructions Complete a comparative financial analysis of Johnson Johnson(JNJ and Baxter

ACCT500_Finance_Module_1_Assessment_Template (1).xls -...

This preview shows page 1 - 2 out of 4 pages.

Complete a comparative financial analysis of Johnson & Johnson (JNJ) and Baxter International, Inc Use financial data reported as of December 31, 2018. After completing data entry in this first tab, move to the second tab to document your conclusions. Comparative Financial Analysis: Johnson & Johnson (JNJ) vs Baxter International, Inc. (BAX) JNJ BAX Current assets 46,033 5,919 Total assets 152,954 15,641 Average total assets 155,129 16,376 Average net receivables 13,794 1,892 Current liabilities 31,230 2,836 Total liabilities 93,202 7,847 Average total liabilities 95,173 7,917 Revenue 81,581 11,127 Cash provided by operations 22,201 2,096 81,581 11,127 Gross profit 54,595 4,816 Net income 15,297 1,624 Preferred stock dividends 0 0 Average common stockholders' equity 59,956 8,459 Liquidity Metrics Current ratio 1.47 2.09 Accounts receivable turnover (receivables turnover ratio) 5.91 5.88 Average collection period (average age of receivables) -- in days 62 62 Solvency Metrics Debt to total assets ratio 0.61 0.50 Cash debt coverage ratio 0.23 0.26 Profitability Metrics Gross profit ratio 0.67 0.43 Profit margin ratio 0.19 0.15 Return on assets ratio (ROA) 0.10 0.10
Image of page 1
Image of page 2

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture