Debt to Equity Ratio Calculator

The debt to equity ratio is the ratio of how much a business owes (debt) compared to how much the owners have invested (equity).

This Excel debt to equity ratio calculator, available for download below, is used to compute debt to equity by entering details relating to the debt and owners equity.

The debt to equity ratio calculation is carried out by dividing the total debt of the business by the owners equity using the debt to equity formula as follows:

Debt to equity ratio = Debt / Owners equity

Both debt and equity are found on the balance sheet of the business.

There is no correct value for the debt to equity ratio as it depends on the industry in which the business operates. It is useful to compare the calculated figure with other businesses in your industry using figures available from published financial statements.

debt to equity ratio calculator v 1.1
Debt to Equity Ratio Calculator Preview
Using the Debt to Equity Ratio Calculator

The Excel debt to equity ratio calculator, available for download below, is used as follows:

  • The value of debt is entered. Debt is found on the balance sheet of the business, and includes all borrowings, loans and overdrafts from banks and financial institutions less any cash.
  • The value of owners equity is entered. The owners equity value is found on the balance sheet. Owners equity includes any capital plus retained earnings of the business. The debt to equity ratio calculator calculates the debt to equity ratio.
Debt to Equity Ratio Calculator Download

The debt to equity ratio spreadsheet is available for download in Excel format by following the link below.

Provided cash and profits are managed correctly, a high debt to equity ratio business will give greater returns to the equity holders. However, when losses are incurred, the people who lent money to the business see a high debt to equity ratio as an indicator of a highly geared and therefore more risky business.

A lending institution would not normally lend more than the owners of a business, so the maximum debt to equity ratio is normally 1 and usually the lender would seek a lower figure in the region of 0.5 – 0.6.

Notes and major health warnings
Users use this debt to equity calculator at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of an accounting tool that you might use to calculate debt to equity ratio. It is purely illustrative. This is not intended to reflect general standards or targets for any particular business, company or sector. If you do spot a mistake in this debt ratio calculator, please let us know and we will try to fix it.
Debt to Equity Ratio Calculator November 6th, 2016Team

You May Also Like


Related pages


capital gearing ratio formulaformula of accounting equationcompounded continuously meanswhen is the unearned revenue recognized in the financial statementspresent value of coupon bondadjusting entries merchandise inventoryaccounting debits and credits chartterm loan double entrymargin or markupaccounts payable normal balanceformula for rocejournal entry for dividend incomenotes payable exampleshow to calculate bank reconciliation statementinventory turnover ratio formulaannuity present valueasset test ratio formulaformula of debtors turnover ratiohow to record depreciation expense in journal entryexample of journalizing in accountinghow to calculate present value of lease paymentsdebits and credits examplesprofit margin ratio formula accountingpv of annuity tabletime sheet formatasset register sampledifference between margin and markupaccounting ledgers examplesamortization expense journal entryhow to find retained earninggl reconciliation templatebookkeeping definition accountingaccounts payable journal entrytransposition errorsannuity calculator exceldeclining balance method of depreciationdebts and creditsaccounts payable receivable interview questions answerscommon size income statementexample of liquidation and distribution accountmarkup calculator excelhow to calculate an annuity in excelgross margin excel formulaaccounts receivable debitwhat does single entry accounting meandays sales in inventory formulavertical analysis in accountingactivity based costingsbills payable bookfixed liabilities examplesstraight line method for calculating depreciationwhat is meant by payback periodjournal entry for allowance for doubtful accountsdividends in arrears on cumulative preferred stockstock turnover ratio formulasales tax converteradjusting entry in accountingcalculation of cost of goods manufacturedjournal entry worksheetpurchased goods on credit journal entriesbond calculator excelocf calculatoroffice supplies expense accountingexpanded accounting equation calculatorhow to identify debit and credit in accountingis bonds payable a current liabilityreversing journal entries examplegross profit margin percentage formulaaccounting prepaymenthow to calculate the npv in excelbookkeeping terms and principlesaccruals and prepayments journal entriescontribution to sales ratio formulaacceptable gearing ratiocalculate double declining depreciationsteps to prepare bank reconciliation statementface value of a bond calculatorjournal entry for provision of income taxsingle step income statement template