أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
How do I calculate the debt-to-equity ratio 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. In cell B4, input the formula "=B2/B3" to render the D/E ratio.