If you are learning how to calculate DSCR for a bank loan project report with an example, start from the version of the formula used in term-loan appraisals. It adds back the non-cash and interest items to profit, then compares the result with what the loan demands that year. Below are the formula, a one-year numerical and a five-year schedule with an average DSCR, all computed with our DSCR calculator engine.

What DSCR measures

The debt service coverage ratio compares the money a business has available to repay a loan with the repayment due. A DSCR of 1.00 means everything earned for debt service goes straight to the lender. Below 1.00, the business must find cash elsewhere. Above 1.00, there is a cushion.

In corporate finance the numerator is often net operating income or EBITDA. Project reports for term loans usually build it from the profit and loss account instead, which is the version used here. For lender benchmarks and covenant tests, see our guide to DSCR for business loans.

DSCR formula for a term-loan project report

Calculate each year separately, because principal, interest and profit all change over the life of the loan.

Debt service coverage ratio

DSCR = (Net profit after tax + Depreciation + Interest on term loan) ÷ (Principal instalment + Interest on term loan)

Use the same interest figure in the numerator and the denominator. Only include instalments and interest on the loans being serviced, and leave out working-capital interest unless the lender’s format asks for it.

Solved examples

Example 1: DSCR for a single year

Question: A manufacturing unit’s projected figures for Year 1 are: net profit after tax ₹6,00,000, depreciation ₹2,00,000, interest on term loan ₹4,00,000 and principal instalment due ₹6,00,000. Calculate DSCR.

Solution:

  1. Income available for debt service = ₹6,00,000 + ₹2,00,000 + ₹4,00,000 = ₹12,00,000.
  2. Debt service = ₹6,00,000 + ₹4,00,000 = ₹10,00,000.
  3. DSCR = ₹12,00,000 ÷ ₹10,00,000 = 1.20.

Answer: DSCR = 1.20 times. The unit earns ₹2,00,000 more than it needs to service the loan in Year 1.

Example 2: five-year term loan with average DSCR

Question: A business borrows ₹50,00,000 as a term loan at 10% per annum. Principal is repaid in five equal annual instalments of ₹10,00,000, and interest is charged on the opening balance each year. Depreciation is ₹3,00,000 a year. Projected net profit after tax is ₹6,00,000, ₹8,00,000, ₹10,00,000, ₹11,00,000, ₹12,00,000 for Years 1 to 5. Calculate the DSCR for each year and the average DSCR.

Solution:

  1. Interest each year = 10% of the opening loan balance: ₹5,00,000, ₹4,00,000, ₹3,00,000, ₹2,00,000, ₹1,00,000.
  2. Income available each year = PAT + ₹3,00,000 + interest: ₹14,00,000, ₹15,00,000, ₹16,00,000, ₹16,00,000, ₹16,00,000.
  3. Debt service each year = ₹10,00,000 + interest: ₹15,00,000, ₹14,00,000, ₹13,00,000, ₹12,00,000, ₹11,00,000.
  4. Yearly DSCR = available ÷ debt service: 0.93, 1.07, 1.23, 1.33, 1.45.
  5. Average DSCR = Total available ÷ Total debt service = ₹77,00,000 ÷ ₹65,00,000 = 1.18.

Answer: Average DSCR = 1.18. The lowest year is Year 1 at 0.93, below 1.00, so the projections show a cash shortfall in that year.

Example 2 — ₹50,00,000 term loan, 10% interest, equal principal instalments
YearPATDepreciationInterestAvailablePrincipalDebt serviceDSCR
Year 1₹6,00,000₹3,00,000₹5,00,000₹14,00,000₹10,00,000₹15,00,0000.93
Year 2₹8,00,000₹3,00,000₹4,00,000₹15,00,000₹10,00,000₹14,00,0001.07
Year 3₹10,00,000₹3,00,000₹3,00,000₹16,00,000₹10,00,000₹13,00,0001.23
Year 4₹11,00,000₹3,00,000₹2,00,000₹16,00,000₹10,00,000₹12,00,0001.33
Year 5₹12,00,000₹3,00,000₹1,00,000₹16,00,000₹10,00,000₹11,00,0001.45

Example 2 shows why the yearly figures matter more than the average. The average of 1.18 looks comfortable, but Year 1 does not cover its own repayment. A lender reading this report would ask how the Year 1 gap is funded, for example through a moratorium on principal, promoter contribution or a longer repayment period. Interest falls each year as principal is repaid, which is why DSCR improves even after profit stops growing.

What a principal moratorium does to Year 1

Lenders sometimes defer principal repayment in the first year of a new project, so only interest is paid. Rework Year 1 of Example 2 on that basis: income available stays ₹14,00,000, but debt service falls to the interest of ₹5,00,000. DSCR becomes 2.80. The deferred principal does not disappear, though. It is added to later instalments, so recalculate every later year with the revised repayment schedule before quoting an average.

Also check which profit figure the projections use. DSCR should be built from projected profit after tax for the same year as the repayment, not from the previous year’s audited profit, and depreciation should match the fixed-asset schedule in the same report.

Preparing DSCR for an Indian bank project report

In a project report for an Indian bank, show DSCR year by year next to the projected balance sheet and profit and loss account, with the average below the table. Each bank sets its own minimum DSCR and its own method for the average, so ask the branch or credit officer for the figure and format that apply to your loan, and keep the assumptions behind each year’s profit in the report so they can be checked.

If the first-year DSCR is below 1.00 because the project is still ramping up, say so plainly and show how the gap will be met. Hiding the problem inside an average will not get past an appraisal.

Common mistakes students make

  • Using profit before tax in the numerator while also adding interest back, which double counts the tax that has to be paid.
  • Leaving interest out of the denominator and dividing only by the principal instalment.
  • Taking the simple average of yearly ratios when the question asks for total available divided by total debt service.
  • Using the same interest figure every year even though the loan balance falls after each instalment.
  • Adding back depreciation in the denominator as well as the numerator.

Run your own numbers

In the DSCR calculator, enter income available for debt service (PAT + depreciation + interest) and total debt service (principal + interest) for each year. If the loan is repaid by equal EMIs instead of equal principal instalments, split each year’s EMIs into principal and interest with the loan amortization calculator first.

Last updated: 23 October 2026