Computing ratios in Excel
Compute the following ratios for two years. You may use Excel to compute your ratios.
Debt ratio
Gross profit margin
Free cash flow
Times interest earned
Accounts receivable turnover
Inventory turnover
Compute the following ratios for two years. You may use Excel to compute your ratios.
Debt ratio
Gross profit margin
Free cash flow
Times interest earned
Accounts receivable turnover
Inventory turnover