https://sec.report/Document/0000200406-20-000010/ Johnson and Johnson

https://www.sec.gov/Archives/edgar/data/80424/000008042416000212/fy151610-kreport.htm Proctor and Gamble.

Here are the 10-K forms for both Johnson and Johnson & Proctor and Gamble. Can someone please help me figure out the following?

IN EXCEL:

• Make a 5-year trend analysis for each company.
• Net sales.
• Net income.

• Compute forthe two most recent yearsthe:
• Debt to assets ratio.

• Compute fortwo most recent yearsthe:
• Profit margin.
• Asset turnover.
• Return on assets.

Showyour work inExcel.All computations must be in excel cells and not typed in.