Analyze each of company ratios using

a. Trend Analysis

b. Peer Analysis

Also do a detailed comparison

 

Transcribed Image Text:

Ratios Current Ratio Quick Ratio Networking capital Debt to Equity Ratio Equity ratio Debt Ratio Gross profit Margin Operating profit Margin Net profit margin Return on assets Return on equity Interest coverage ratio Asset turnover ratio Inventory turnover ratio Receivable turnover ratio Payable turnover ratio Pepsico 2021 0.83% 0.66% -5725% 4.72 times 0.17 times 0.83 times 53.34% 14% 9.66% 8.29% 51.71% 5.121846 times. 0.857815 times 18.66025 times 9.30391 times 1.819632 times 2020 0.98% 0.8 -4776 5.85 0.14 0.85 0.54 14.32 10.20% 7.72% 52.94% 7.36 times 0.757356 times 16.86769 times 8.373632 times 1.622958 times Nestle Coca Cola 2021 2020 2021 0.98 0.86 1.29 0.67 0.59 0.926 2341 1130 241806 0.98 1 3.84 0.34 0.32 0.2 0.33 0.32 0.79 47.79 49.05 0.35 13.41% 17.54% 7.89 19.75% 14.67% 12.36% 9.98% 36.18% 31.03% 13.38% 16.93% 0.63% 0.68% 1.03 4.25 1.99 7.85 0.58 2.32 3.4 5.5 26.63 13.12 1.61 11.91 11.78 11.3 2020 1.31 0.96 204177 5.2 0.15 0.84 0.35 6.2 3.6 5.6 35.49 8.5 1.55 14.34 11.7 14.88 Ratios Current Ratio Quick Ratio Networking capital Debt to Equity Ratio Equity ratio Debt Ratio Gross profit Margin Operating profit Margin Net profit margin Return on assets Return on equity Interest coverage ratio Asset turnover ratio Inventory turnover ratio Receivable turnover ratio Payable turnover ratio Pepsico 2021 0.83% 0.66% -5725% 4.72 times 0.17 times 0.83 times 53.34% 14% 9.66% 8.29% 51.71% 5.121846 times. 0.857815 times 18.66025 times 9.30391 times 1.819632 times 2020 0.98% 0.8 -4776 5.85 0.14 0.85 0.54 14.32 10.20% 7.72% 52.94% 7.36 times 0.757356 times 16.86769 times 8.373632 times 1.622958 times Nestle Coca Cola 2021 2020 2021 0.98 0.86 1.29 0.67 0.59 0.926 2341 1130 241806 0.98 1 3.84 0.34 0.32 0.2 0.33 0.32 0.79 47.79 49.05 0.35 13.41% 17.54% 7.89 19.75% 14.67% 12.36% 9.98% 36.18% 31.03% 13.38% 16.93% 0.63% 0.68% 1.03 4.25 1.99 7.85 0.58 2.32 3.4 5.5 26.63 13.12 1.61 11.91 11.78 11.3 2020 1.31 0.96 204177 5.2 0.15 0.84 0.35 6.2 3.6 5.6 35.49 8.5 1.55 14.34 11.7 14.88