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.

How to Calculate Financial Ratios of Performance. Financial ratios allow you to break down your company's financial statements and see how it is performing from different angles. Whether you are ...