For Nestle for years 2018, 2017 and 2016

In the Ratios tab of the FSAR Excel Spreadsheet, complete the Short-Term Debt Paying Ratios, Asset Utilization or Turnover Ratios, and the Long-Term Solvency or Financial Leverage sections.

1. Calculate of the short-term debt paying ratios.
2. Calculate the long-term debt paying or financial leverage ratios.
3. Calculate the five significant asset utilization or turnover ratios.

Profitability Ratios
Net Profit Margin Ratio
Total Asset Turnover
Return on Assets
Operating Income Margin
Sales to Fixed Assets
ROE
Return on Common Equity
Gross Profit Margin
Investor Ratios
Degree of Financial Leverage
Earnings per Share
Diluted Earnings per Share
Price/Earnings Ratio
Percentage of Earnings Retained
Dividend Payout
Dividend Yield