Calculate the financial indicators of the firms J&J for the year 2018 and fill in the spaces marked in the table.
Company Name: |
Year 2018 |
Chemicals and Allied Products Industry Ratios |
|
………….. |
|||
Solvency or Debt Ratios |
Merck |
J&J |
2018 |
Debt ratio |
…. |
…. |
0.47 |
Debt-to-equity ratio |
…. |
…. |
0.38 |
Interest coverage ratio |
…. |
…. |
-9.43 |
|
|
|
|
|
…. |
…. |
3.47 |
Quick ratio |
…. |
…. |
2.12 |
Cash ratio |
…. |
…. |
2.24 |
Profitability Ratios |
|
|
|
Profit margin |
…. |
…. |
-93.4% |
ROE (Return on equity), after tax |
…. |
…. |
-248.5 |
ROA (Return on assets) |
…. |
…. |
-146.5 |
Gross margin |
…. |
…. |
55.3% |
Operating margin (Return on sales) |
…. |
…. |
-42.9% |
Activity or Efficiency Ratios |
|
|
|
Asset turnover |
…. |
…. |
1.08 |
Receivables turnover (days) |
…. |
…. |
16 |
Inventory turnover (days) |
…. |
…. |
36 |
Price Ratios |
|
|
|
Dividend Payout Ratio |
…. |
…. |
0.15 |
Financial Statements
Johnson & Johnson (JNJ) |
|
December 31, 2018 ($ in millions) |
|
ASSETS |
|
Current Assets |
|
Cash, cash equivalents and short-term investments |
$19,687 |
Receivables |
14,098 |
Inventory |
9,549 |
Other current assets |
2,699 |
Total Current Assets: |
46,033 |
Noncurrent Assets |
|
Property, plant and equipment, net |
17,035 |
Net Intangible assets (including |
78,064 |
Other noncurrent assets |
11,822 |
Total Noncurrent Assets: |
106,921 |
TOTAL ASSETS: |
$152,954 |
LIABILITIES AND EQUITY |
|
Liabilities |
|
Current Liabilities |
|
Accounts Payable |
7,537 |
Accrued liabilities |
11,517 |
Short term debt |
2,800 |
Other noncurrent liabilities |
9,376 |
Total current liabilities: |
31,230 |
Noncurrent Liabilities |
|
Long-term debt and lease obligation |
27,684 |
Liabilities, other than long-term debt (pension, |
34,288 |
Total noncurrent liabilities: |
61,972 |
TOTAL LIABILITIES: |
93,202 |
Stockholders’equity |
|
Common stock |
3,120 |
|
-34,362 |
Accumulated other comprehensive loss |
-15,222 |
|
106,216 |
Total stockhholders’equity |
59,752 |
Total Liabilities and Stockholders’Equity: |
$152,954 |
Johnson & Johnson (JNJ) Income Statement |
|
For period ending December 31, 2018 ($ in millions) |
|
Revenues |
|
Revenues, net |
$81,581 |
Cost of Revenue |
-27,091 |
Gross profit: |
54,490 |
Operating Expenses |
-34,692 |
Operating Income: |
19,798 |
Nonoperating income (expense) |
-794 |
Interest and debt expense |
-1,005 |
Income from continuing operations before income taxes: |
17,999 |
Income tax expense |
-2,702 |
Net Income available to stockholder |
$15,297 |
Dividends paid to Stockholders |
-9,494 |
Retained Earnings |
$5,803 |
|
Step by stepSolved in 2 steps with 2 images
- What are the firm's current ratios for 2018 and 2019? Income Statements ($ in millions) Balance Sheets ($ in millions) 2018 2019 Assets 2018 2019 $1,265 | Cash $780 Short-Term investments Sales Revenue $1,180 $35 $20 $660 $20 $5 Less: Cost of goods sold Less: Operating Expenses Less: Depreciation Earnings before interest and taxes Less: Interest paid $75 $92 | Accounts rec. 190 235 $40 $50 Inventory 250 300 $405 $343 Total Current Assets $495 $560 $170 $150 | Net fixed assets 990 1,105 Taxable Income $235 $193 Less: Taxes (40%) $77 Total assets $116 Liabilities and Owner's Equity $94 $1,485 1,665 Net income $141 Dividends (45%) Additions to Retained Earnings $63 $52 2018 2019 $64 Accounts payable Аccruals $78 $125 $100 $10 $10 Notes payable 35 40 Total Current Liabilities $170 $150 Long-term debt 598 790 Total Liabilities $768 $940 Common stock 554 498 Retained earnings Total Equity Total liab.& equity 163 $227 717 $725 $1,485 $1,665arrow_forwardCalculate the financial indicators of the firm Merck for the year 2018 and fill in the spaces marked in the table. Company Name: Year 2018 Chemicals and Allied Products Industry Ratios ………….. Solvency or Debt Ratios Merck J&J 2018 Debt ratio …. …. 0.47 Debt-to-equity ratio …. …. 0.38 Interest coverage ratio …. …. -9.43 Liquidity Ratios Current ratio …. …. 3.47 Quick ratio …. …. 2.12 Cash ratio …. …. 2.24 Profitability Ratios Profit margin …. …. -93.4% ROE (Return on equity), after tax …. …. -248.5 ROA (Return on assets) …. …. -146.5 Gross margin …. …. 55.3% Operating margin (Return on sales) …. …. -42.9% Activity or Efficiency Ratios Asset turnover …. …. 1.08 Receivables turnover (days) …. …. 16 Inventory turnover (days)…arrow_forwardAn extract from a computer company's 2021 financial statements follows: Balance sheet As of December 31, 2021 As of December 31, 2020 Total assets 57,699 54,013 Total liabilities 37,682 37,919 Total stockholders' equity 20,017 16,096 What was the company's debt-to- equity ratio for 2021? OA. 2.5 OB. 1.6 O C. 0.9 O D. 1.9arrow_forward
- Using comparative financial statements of Zayed Abu Dhabi Corporation above, prepare common size statements. Zayed Abu Dhabi Corporation Comparative Balance Sheets For the years ended December 31, 2020 and 2019 Comparative Balance Sheets For the years ended December 31, 2020 and 2019 2020 2019 Common Size 2020 Common Size 2019 Cash.................................................... 58 78 Accounts recble., net......................... 514 490 Merchandise inventory....................... 1332 1802 Plant assets, net................................. 2020 2014 Total assets........................................ 4442 4002arrow_forwardConsider this simplified balance sheet for Geomorph Trading: Current assets Long-term assets $ 245 Current liabilities Long-term debt 630 Other liabilities Equity $ 875 Required: a. What is the company's debt-equity ratio? (Hint: debt = Current liabilities, Long-term debt, and Other liabilities) Note: Round your answer to 2 decimal places. b. What is the ratio of total long-term debt to total long-term capital? Note: Round your answer to 2 decimal places. c. What is its net working capital? d. What is its current ratio? Note: Round your answer to 2 decimal places. $ 170 215 140 350 $ 875 a Debt-equity ratio b. Long-term debt-to-capital ratio c. Net working capital d. Current ratioarrow_forwardCompute DuPont Analysis Ratios Selected balance sheet and income statement information for Humana Inc., a health and well‑being company, follows. 2018 2017 2018 2018 Net 2018 2017 Stockholders’ Stockholders’ Company ($ millions) Ticker Revenue income Assets Assets Equity Equity Humana Inc HUM $66,610 $11,381 $35,111 $36,876 $19,859 $19,540 Compute the following 2018 ratios for Humana. a. Return on equity (ROE) Note: 1. Select the appropriate numerator and denominator used to compute ROE from the drop-down menu options. 2. Enter the numerator and denominator amounts to compute ROE. Numerator Denominator ROE Answer Answer Answer Answer b. Profit margin (PM) Note: 1. Select the appropriate numerator and denominator used to compute PM from the drop-down menu options. 2. Enter the numerator and denominator amounts to compute PM. Numerator Denominator PM Answer Answer Answer Answer c. Financial leverage…arrow_forward
- Campare these two company’s using financial ratiosarrow_forwardN1. Account Calculate the following ratios for Lake of Egypt Marina, Inc. as of year-end 2021. (Use sales when computing the inventory turnover and use total stockholders' equity when computing the equity multiplier. Round your answers to 2 decimal places. Use 365 days a year.)arrow_forwardCostco Financial Analysis. Perform the following ratio analysis for 2021, 2022, and 2023 for Costco using the attached financial statements. a. Profitability ratios b. Liquidity ratios c. Leverage ratios d. Activity ratios e. Price to earnings ratioarrow_forward
- For Financial year 2021: Current ratio = Current assets / Current liabilities = 43.133 / 29.613 = 1.46 (2.d.p) Debt-to-equity = Total liabilities / Total equity = (29.613 + 25.382) / 47.069 = 1.17 (2.d.p) Return on total assets = Net profit / Average total assets = (-11.195) / 101.964 = -0.11 (2.d.p) Profit margin ratio = Net profit / Net sales = (-11.195) / 81.79 = -0.14 (2.d.p) Debt-to-asset = Total liabilities / Total assets = (29.613 + 25.382) / 101.964 = 0.54 (2.d.p) Cash flow on total assets = Net cash flow from operating activities / Average total assets = 4.717 / 101.964 = 0.05 (2.d.p) For Financial year 2022: Current ratio = Current assets / Current liabilities = 49.476 / 32.754 = 1.51 (2.d.p) Debt-to-equity = Total liabilities / Total equity = (32.754 + 27.625) / 46.732 = 1.29 (2.d.p) Return on total assets = Net profit / Average total assets = (-0.336) / 107.111 = -0.003 (3.d.p) Profit margin ratio = Net profit / Net sales = (-0.336) / 115.56 = -0.003 (3.d.p) Debt-to-asset…arrow_forwardUsing the financial statements in the image, calculate the following ratios for both the FY 2017 and FY 2018: Current Ratio Quick Ratio Total Asset Turnover Average Collection Total Debt to Total Assets Times Interest Earned Net Profit Margin Return on Assets Return on Equity Modified Du Point Equation for FY 2018 PE Ratio Market to Book Ratioarrow_forwardThe following ratios for The A2 Milk Limited and Synlait Limited were calculated for 2020 and 2019: A2 Milk Ltd. Synlait Ltd. 2020 2019 2020 2019 Return on Assets 44.52% 48.54% 9.33% 12.81% Return on Equity 40.15% 42.83% 13.69% 17.93% Current Ratio 3.69 times 3.15 times 1.00 times 0.76 times Days in Inventory 61 days 54 days 72 days 68 days Debt ratio 21.97% 21.76% 59.36% 57.20% Based on the above ratios, comment on A2 Milk Ltd’s short term and long term financial riskarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education