https://finance.yahoo.com/quote/JNJ/balance-sheet?p=JNJ

~~In Excel~~

Get balance sheet of Johnson and Johnson (JNJ) to calculate average Debt ratio over for the recent 3 years. (Steps to get data: i) Go to Yahoo finance and type in JNJ in the Quote Lookup box, ii) Click on the Financials tab, iii) Click on Balance sheet, iv) Download data) (If you find that data is not copying correctly from your browser to Excel, you can copy this data to notepad first and then copy from notepad to Excel.)

Data download.

a. Find total debt and total assets for each of the three Balance Sheets.

b. Find debt ratios for the 3 years.

c. Comment on the trend in debt ratios.

~~In Excel~~