1] Calculate ratio in Excel by using the GCD function GCD stands for Greatest Common Divisor. It is also called HCF (Highest Common Factor).

Similarly, the inventory turnover ratio of General Motors Company is calculated by entering the formula =C4/C3 into cell C5. The resulting inventory turnover ratio is 11.78.

Learn how to use Microsoft Excel to calculate the Sharpe ratio, an investing tool used to assess the relationship between risk and return for an asset.