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


dupont equation analysisdifference between markup and gross marginpayback period formula examplesample timesheet templaterecording adjusting entriespresent value of an annuity tablemeaning of absorption costingaccounting owners equitypayback analysis exampleexamples of period costsjournal entry for return of capitalimprest paymentdelayed perpetuity formularequisition slip sampleuses of petty cash bookperpetuity example problemjournal entry of bills receivabledifferent types of source documentsconsignment inventory sheetcalculate total fixed cost formulamanufacturing overhead formulahow to find variable cost formulaadjusting journal entries for depreciationtypes of suspenseprepaid expense t accountaccumulated depreciation trial balancecalculating face value of a bondtrial balance worksheet exampleis prepaid rent an assetfuture value lump sum formulapetty cash voucheris unearned revenue on the income statementtemplate balance sheet and income statementmanagerial accounting journal entriesfuture value discount rate calculatorquick ratio formula financewhat is a sundry expensesmall business accounts spreadsheethow to calculate retained earningformula for acid test ratioasset retirement obligation journal entrybasis of apportionment of overheadsaccount receivable normal balancemargin vs markup charthow to calculate beginning finished goods inventorybookkeeping contract agreementan example of a contra asset account isrevenue recognition consignment salespresent future value formulacredit turnover ratio formuladeclaration of cash dividendsale of fixed assets journal entrypost closing trial balance should only containsample chart of accounts for non profit organizationswhat is a pmt functionhow do you calculate mark upadjusting entry unearned revenuelump sum payment formulabookkeeping meaningbalancing of ledger accountsimprest account entryprojected balance sheet templateallocation of factory overheadpresent and future value tableswhat is the periodicity assumptionpoc revenue recognitionaccounts payable exceljournal entry voucherformula to calculate future value of annuityaverage contribution margin formulaamortization in income statementjournal accounting entries examplespv of growing annuitycost of goods manufactured templatesample accounting spreadsheets for excel