Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How do I calculate the debt-to-equity ratio in Excel?

How do I calculate the debt-to-equity ratio in Excel?

Accounting Financial Reporting Financial Accounting Finance Financial Statements
user-image
Question added by Mohammad Iqbal Abubaker , Jahaca Pty Ltd - Accounts Administrator , Jahaca Pty Ltd - Accounts Administrator
Date Posted: 2017/03/26
Upvote (0) Views (11) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Mohamed Impas Abdul Jaleel
by Mohamed Impas Abdul Jaleel , Senior Accountant , Al Qamra Holding Group

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.

Write Your Answer
More Questions Like This