DSCR calculator for project and CRE lending
A DSCR calculator applies the debt service coverage ratio to a defined period of cash flow and scheduled debt service so a credit paper can show whether coverage clears the facility test. The DSCR compares cash available for debt service with principal and interest due in the same period. World Bank project-appraisal guidance lists the ratio among the core measures in its ratio analysis and states that where coverage stays below a level considered prudent for the risk profile over an extended period, the financing plan has to be restructured with higher equity, longer maturities or a longer grace period.
DSCR calculator formula
In World Bank DFC terms for a year:
DSCR = (net income after taxes + depreciation + interest charges) / total debt service for the year
Facility models on bank desks commonly restate the same structure as:
DSCR = CFADS / (scheduled principal + interest [+ permitted fees])
where CFADS is cash flow available for debt service after permitted taxes, operating costs and reserve top-ups defined in the facility. Periodicity may be quarterly, semi-annual or trailing twelve months. Historical and forward tests can use different CFADS definitions; the calculator must use the definition in the credit agreement, not a generic accounting proxy.
Inputs
- CFADS or earnings numerator: period cash available for debt service, or the World Bank earnings-plus-depreciation-plus-interest construct
- Scheduled principal: amortisation due in the test period
- Interest: cash interest accrued or payable in the test period under the facility definition
- Fees (if included): commitment, agency or other fees the covenant treats as debt service
- Test period: quarter, half-year, year or trailing twelve months
- Case: base, downside or historical actuals
Optional switches that change results without changing the core formula:
- whether DSRA draws count as CFADS
- whether equity cures or sponsor top-ups are included
- whether subordinated debt service sits inside or outside the senior DSCR test
Worked numerical example
Illustrative annual senior facility test (facility CFADS definition):
- CFADS: 24.0 million
- Scheduled principal: 10.0 million
- Interest: 8.0 million
- Fees included in debt service: 0.5 million
Debt service = 10.0 + 8.0 + 0.5 = 18.5 million
DSCR = 24.0 / 18.5 = 1.30x
If the same CFADS is tested against a 1.25x minimum covenant, the period clears. If CFADS falls to 22.0 million, DSCR = 22.0 / 18.5 = 1.19x and the period fails the same 1.25x floor. The arithmetic is unchanged when the desk switches from annual to semi-annual inputs; only the period boundary and cash definitions move.
A CRE permanent loan often feeds net operating income or property cash flow into a DSCR-style coverage test, while project finance models build CFADS from the cash waterfall after operating costs and senior reserve requirements. A transaction that qualifies as project finance under the OECD Arrangement is defined by footnote 7 to Article 21: the lender treats the project company's cash flows and earnings as the source of loan repayment and its assets as collateral. That Arrangement definition qualifies a transaction for project-finance treatment; it does not set or replace the facility's own DSCR covenant, which tests period coverage under the credit agreement rather than transaction eligibility.
Interpretation limits
A DSCR calculator reports period coverage. It does not replace LLCR or PLCR life-cover tests, interest-only interest coverage ratio measures, or leverage screens such as LTV and debt yield. A single strong period can mask weak later amortisation. A weak period can be cured by temporary DSRA use without repairing operating cash generation.
Numerator definitions diverge across facilities. World Bank appraisal language, CRE NOI practice and CFADS after lockbox and reserve top-ups are not interchangeable. Including a debt service reserve account draw in CFADS raises reported DSCR without raising operating cash. Excluding fees that the covenant includes understates the denominator.
The calculator does not set policy minima. Prudent cover levels depend on sector volatility, offtake quality, lease structure and completion risk. World Bank guidance frames weak coverage as a reason to restructure equity, maturity or grace, not as a fixed universal floor.