Finxora Logo
Sign In
DSCR Calculation in a CMA Report: Practical Example
Back to Blog

DSCR Calculation in a CMA Report: Practical Example

FINXORA
5 min read
DSCR
CMA Report
Financial Analysis
Debt Service
Ratio Analysis

Calculate DSCR with an Indian bank-loan example. Check profit, depreciation, interest and principal, then test annual repayment capacity and downside risk.

What DSCR measures in a CMA report

DSCR stands for Debt Service Coverage Ratio. It compares a defined measure of earnings available for debt service with the relevant principal and interest obligations. In a CMA report, meaning Credit Monitoring Arrangement report, it helps a lender examine whether projected operations can support repayment. It should be read with the operating statement, loan schedule, balance sheet and cash flow.

A ratio above 1 indicates coverage under the chosen calculation, while a ratio below 1 indicates a shortfall. Neither result is a complete lending decision. Collection timing, working capital needs, capital expenditure and the quality of assumptions can change the actual cash position. Confirm the lender's definition, debt scope and required reporting period before preparing the calculation.

State the formula before using figures

A common term-loan appraisal convention is:

DSCR = (Profit after tax + Depreciation + Term-loan interest) / (Term-loan principal due + Term-loan interest)

This formula starts with profit after tax that already includes the relevant interest expense. Depreciation is added back because it is a non-cash charge. Term-loan interest is added back because the denominator includes it as part of debt service. Using profit before interest and then adding the same interest again would overstate the numerator.

Banks may prescribe adjustments or use another cash-based definition. Identify which loans are included and apply that scope consistently to both sides. If the numerator starts with profit before tax, EBITDA or operating cash flow, do not label it as the formula above without a reconciliation. Differences in definitions must be disclosed rather than hidden by similar ratio labels.

Worked annual example

Assume an Indian manufacturing borrower has the following projected figures for a complete year. All amounts are in Rs lakh. Profit after tax is after charging depreciation and the term-loan interest shown below. There are no additional adjustments in this illustration. Principal means the amount contractually due during the year, not the closing loan balance.

ItemRs lakhSource to check
Profit after tax12.00Projected operating statement
Depreciation4.00Fixed-asset depreciation schedule
Term-loan interest3.00Loan schedule and interest expense
Term-loan principal due8.00Repayment schedule
  1. Numerator = 12 + 4 + 3 = Rs 19 lakh.
  2. Denominator = 8 + 3 = Rs 11 lakh.
  3. DSCR = 19 / 11 = 1.73, rounded to two decimals.
  4. Coverage surplus under this calculation = 19 - 11 = Rs 8 lakh.

The borrower therefore has Rs 1.73 of the defined earnings measure for each rupee of scheduled debt service. The Rs 8 lakh difference is not automatically freely available cash. Inventory growth, delayed collections, drawings and other commitments can absorb it. Review the cash flow before deciding how much headroom actually exists.

Connect the ratio to the repayment schedule

Extract principal and interest for the same reporting year used in the profit projection. If the loan starts part-way through the year, the schedule should reflect the actual disbursement and repayment dates. A full-year profit forecast compared with only a few months of debt service can mislead unless the mismatch is explained and the operating assumptions are appropriate.

Review moratorium terms carefully. A principal moratorium does not necessarily suspend interest, and interest may be payable or capitalised according to the loan terms. A year with no principal payment can show a relatively high ratio without demonstrating long-term repayment strength. Show later years when regular instalments begin, including any balloon payment.

Present annual ratios and the aggregate working

Annual DSCR reveals weak periods that an overall figure can conceal. Extend the example to a second year with a numerator of Rs 24 lakh and debt service of Rs 16 lakh. The second year's DSCR is 1.50. For an aggregate coverage measure across both years, divide total numerators by total denominators: (19 + 24) / (11 + 16) = 43 / 27 = 1.59.

A simple arithmetic average of 1.73 and 1.50 is approximately 1.62 and differs from aggregate coverage. State which method is used when a report asks for average DSCR, and follow the lender's format. Do not switch methods to obtain a higher figure. Keep unrounded values in the calculation and round only the displayed result.

Test a weaker operating result

Suppose profit after tax in the first year falls from Rs 12 lakh to Rs 7 lakh while depreciation, interest and principal remain unchanged. The revised numerator is 7 + 4 + 3 = Rs 14 lakh. Revised DSCR is 14 / 11 = 1.27. This isolated test shows reduced coverage, but a full downside forecast must recalculate tax, interest and working capital where those items change.

A second test can examine a delayed start, higher input cost or slower customer collections. Collection delays may weaken cash without immediately changing accounting profit, which is why DSCR alone is insufficient. Present the assumption, recalculated financial statements and management response together. An unsupported increase in sales is not evidence of improved repayment capacity.

Avoid common calculation errors

  • Using loan outstanding: The denominator needs scheduled principal due, not the entire closing balance unless it is due.
  • Counting interest twice: Confirm whether the starting profit has already deducted it.
  • Mixing debt scope: Include the same relevant facilities consistently and disclose exclusions.
  • Ignoring overdue amounts: Show arrears and their treatment separately from the regular schedule.
  • Dividing by zero: A period with no debt service needs an explanatory label rather than a fabricated ratio.
  • Relying on one benchmark: Acceptable coverage varies by lender, sector and proposal.

For the related preparation guidance, see DSCR worksheet in Excel.

Keep the wider CMA assessment in view

DSCR addresses repayment coverage, while working capital assessment considers how operations are financed. Current ratio, TOL/TNW, receivable and stock holding levels, and cash flow provide different perspectives. MPBF and turnover-method calculations do not replace a debt-service working. A borrower can have adequate annual coverage yet face a monthly liquidity gap.

Finxora's CMA report software includes DSCR analysis, cash flow, repayment schedules and 20+ financial ratios. Use the sample reports to assess the presentation, then reconcile your own inputs to the lender's requested definition. A transparent calculation with traceable schedules is more defensible than a ratio entered solely to meet a target.

Frequently Asked Questions

Published on February 24, 2026

Updated on November 18, 2026

Back to Blog

Need bank-ready financials? Create a CMA report or a project report with Finxora in minutes.