Calculating Debt-to-Equity Ratio in Excel

Debt-to-equity ratio shows much of assets are financed with shareholders equity and how much with external financing. To calculate debt-to-equity ratio open your balance sheet and divide liabilities with shareholder's equity