The ratio data in Excel is the comparison of two values. For example, value 1 is how many times value 2. There are different ways to calculate and show ratios in Excel.

To calculate this ratio in Excel, locate the total debt and total shareholder equity on the company's balance sheet. Input both figures into two adjacent cells, say B2 and B3.

Using Microsoft Excel is one of the easiest ways to do so, as long as you have some key information from your financial statements. In this article, we explore the current ratio, how to determine ...

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.