Examine the financial statements from Johnson and Johnson that I have provided in the Excel workbook that accompanies this document. Note that numbers in parentheses are negative values, and this is how Excel displays them. Then, once you have examined them, please provide the financial ratios listed below for J&J for both 2017 and 2016 and place these ratios in the table provided. Then answer the questions that follow. Please complete all work in this Word document, and submit your completed file to PLATO by the deadline. Ratios: Net Profit Margin Quick Ratio Total Asset Turnover Accounts Receivable Days Accounts Payable Days Times Interest Earned Debt to Capital Price to Earnings Return on Equity (Using EBIT) (Treat all Liabilities as debt) (Use the shares outstanding figure for both 2017 and 2016) 2017 2016 Ratio Net Profit Margin Quick Ratio Total Asset Turnover Accounts Receivable Days Accounts Payable Days Time Interest Earned Debt to Capital Price to Earnings Return on Equity B Revenue Total Revenue (Sales) Cost of Revenue (COGS) Gross Profit 2017 2016 $76,450,000.00 $71,890,000.00 $24,766,000.00 $21,640.000.00 $10,554,000.00 $ 9,095,000.00 $21,420,000.00 $19,945,000.00 Operating Expenses Research Development Selling General and Administrative Non Recurring Others Operating Income or Loss Income from Continuing Operations Earnings Before Interest and Taxes (EBIT) Interest Expense Income Before Tax Income Tax Expense Minority Interest Net Income From Continuing Ops $19.710,000.00 $21,210,000.00 $ 934.000.00 $ 726,000.00 $ 17,673,000.00 $19,803,000.00 $16,373,000.00 $ 3,263,000.00 $1,300,000.00 Non-recurring Events Discontinued Operations Extraordinary Items Effect of Accounting Changes Other items Net Income Net Income 1,300,000.00 Questions 1. Has net profit margin increased or decreased? 2. What would you say about J&J's liquidity? Has it improved or worsened? 3. Is J&J collecting money faster than it has to pay it out? How can you tell? 4. Does the company have enough money to cover its interest expenses more than 5 times over? 5. What percentage of the firm is financed through debt? 6. How much does a dollar of current earnings cost? Which ratio tells us this? 7. Based on all the ratios, would you say the health of J&J has improved or worsened from 2016 to 2017? Examine the financial statements from Johnson and Johnson that I have provided in the Excel workbook that accompanies this document. Note that numbers in parentheses are negative values, and this is how Excel displays them. Then, once you have examined them, please provide the financial ratios listed below for J&J for both 2017 and 2016 and place these ratios in the table provided. Then answer the questions that follow. Please complete all work in this Word document, and submit your completed file to PLATO by the deadline. Ratios: Net Profit Margin Quick Ratio Total Asset Turnover Accounts Receivable Days Accounts Payable Days Times Interest Earned Debt to Capital Price to Earnings Return on Equity (Using EBIT) (Treat all Liabilities as debt) (Use the shares outstanding figure for both 2017 and 2016) 2017 2016 Ratio Net Profit Margin Quick Ratio Total Asset Turnover Accounts Receivable Days Accounts Payable Days Time Interest Earned Debt to Capital Price to Earnings Return on Equity B Revenue Total Revenue (Sales) Cost of Revenue (COGS) Gross Profit 2017 2016 $76,450,000.00 $71,890,000.00 $24,766,000.00 $21,640.000.00 $10,554,000.00 $ 9,095,000.00 $21,420,000.00 $19,945,000.00 Operating Expenses Research Development Selling General and Administrative Non Recurring Others Operating Income or Loss Income from Continuing Operations Earnings Before Interest and Taxes (EBIT) Interest Expense Income Before Tax Income Tax Expense Minority Interest Net Income From Continuing Ops $19.710,000.00 $21,210,000.00 $ 934.000.00 $ 726,000.00 $ 17,673,000.00 $19,803,000.00 $16,373,000.00 $ 3,263,000.00 $1,300,000.00 Non-recurring Events Discontinued Operations Extraordinary Items Effect of Accounting Changes Other items Net Income Net Income 1,300,000.00 Questions 1. Has net profit margin increased or decreased? 2. What would you say about J&J's liquidity? Has it improved or worsened? 3. Is J&J collecting money faster than it has to pay it out? How can you tell? 4. Does the company have enough money to cover its interest expenses more than 5 times over? 5. What percentage of the firm is financed through debt? 6. How much does a dollar of current earnings cost? Which ratio tells us this? 7. Based on all the ratios, would you say the health of J&J has improved or worsened from 2016 to 2017