• If you were a creditor, which company would you be more likely to lend money to? Why?
• Which company would you recommend as an investment?Why?
• At which company would you prefer a management position ?Why?
• Each of the above should be supported by the numbers you calculated in your excel spreadsheet .

Johnson and Johnson Procter and Gamble 2019 2018 2019 2019 a) Net Sales 82059 81581 67684 66832 b) Net income 15119 15297 3634 9485 c) Total Assets 157728 152954 115095 118310 d) Total Liabilities 98257 93202 67516 65427 Ratios :- Debt to assets (d/c) 0.62 0.61 0.59 0.55 Profit Margin (b/a) 18.42% 18.75% 5.37% 14.19% Asset Turnover (a/c) 0.52 0.53 0.59 0.56 Return on assets (b/a) 9.59% 10.00% 3.16% 8.02%Johnson and Johnson 2019 2018 2017 2016 2015 Net Sales 82059 81581 76450 71890 70074 Net Income 15119 15297 1300 16540 15409 Trend Analysis (%) 2019 2018 2017 2016 2015 Net Sales 117.10% 116.42% 109.10% 102.59% 100% Net Income 98.12% 99.27% 8.44% 107.34% 100% Procter and Gamble 2019 2018 2017 2016 2015 Net Sales 67684 66832 65058 65299 70749 Net Income 3634 9485 15079 10253 6777 Trend Analysis (%) 2019 2018 2017 2016 2015 Net Sales 95.67% 94.46% 91.96% 92.30% 100% Net Income 53.62% 139.96% 222.50% 151.29% 100% Procter and Gamble 2016 2015 2014 2013 2012 Net Sales 65299 70749 74401 80116 82006 Net Income 10253 6777 11390 11068 10500 Trend Analysis (%) 2016 2015 2014 2013 2012 Net Sales 79.63% 86.27% 90.73% 97.70% 100% Net Income 97.65% 64.54% 108.48% 105.41% 100%