Debt Service Coverage Ratio Calculator

The Debt Service Coverage Ratio determines the repayment capacity of the borrowing party. The higher this ratio, the better the debt-paying capacity of the borrower. It shows the quantum of surplus cash available with the organization for meeting its debt requirements, such as interest and principal amount. Organizations having higher DSCR can ask for better terms of the loan, such as lower interest rates, less collateral security, and more.

To calculate DSCR, the formula is:

DSCR = Net Operating Income/Debt services

Where, calculation of Net Operating Income & Debt Services is done as:

Net Operating Income = PAT + Interest + Depreciation + Non-cash expenses

& Debt Services = Installment amount (Interest + Principal repayment during the year)

Debt Service Coverage Ratio Calculator

How to Calculate using a Calculator?

You simply have to provide the following data to the calculator.

Net Operating Income – The amount of net operating income can be derived from the financial statements of the organization.

Debt Services – The amount of debt services of the organization, i.e., the borrowings of the organization, can easily be obtained from the Income & Expenditure Statement and Balance Sheet of the organization.

Excel Calculator – Debt Service Coverage Ratio

You can also download our excel based calculator for Debt Service Coverage Ratio.

Excel Calculator for Debt Service Coverage Ratio (73 downloads )

Sanjay Borad

Sanjay Bulaki Borad

MBA-Finance, CMA, CS, Insolvency Professional, B'Com

Sanjay Borad, Founder of eFinanceManagement, is a Management Consultant with 7 years of MNC experience and 11 years in Consultancy. He caters to clients with turnovers from 200 Million to 12,000 Million, including listed entities, and has vast industry experience in over 20 sectors. Additionally, he serves as a visiting faculty for Finance and Costing in MBA Colleges and CA, CMA Coaching Classes.

Leave a Comment