DSCR in project finance: period coverage and stress tests

A DSCR project finance review tests whether a project's cash available for debt service covers principal and interest in each required period. Calculate coverage on the financing agreement's basis, then report the weakest period as well as the aggregate result. A satisfactory annual total can conceal a repayment date with too little cash.

Start with the project's cash definition

Period DSCR = Cash flow available for debt service / Required debt service in the same period

Cash flow available for debt service, or CFADS, is the cash measure specified for the project. It is not automatically revenue, accounting profit or EBITDA. The Texas Energy Fund program manual illustrates a CFADS calculation with working-capital adjustments, capital expenditures and cash taxes, and defines debt service as principal plus interest due in the measurement period.

Use that as an illustration of the bridge, rather than a substitute for your agreement. Confirm the treatment of reserve funding, lifecycle spending, cash taxes, fees and any other adjustments. Identify which debt ranks are included. A senior-debt ratio and an all-debt ratio need different denominators and potentially different available-cash amounts.

The broader debt service coverage ratio guide covers the core ratio and contractual thresholds. Here the job is to make a project's period schedule, cash bridge and downside cases agree.

Assemble the export rows before calculating

Bring the project's operating forecast or actual cash-flow workbook, working-capital bridge, capital-spending schedule and lender repayment schedule. Retain project ID, scenario, reporting version, period start, period end and currency. Treasury should confirm required payment dates; accounting should reconcile the operating inputs; project finance should confirm the coverage definition.

Keep actual periods distinct from forecast periods. A construction delay should change the supplied operating start date and the affected cash rows, rather than merely changing a note beside an unchanged ratio. The project finance workbook layout explains how construction funding, operating cash and debt schedules connect.

Do not add loan draws or equity contributions to operating CFADS. Keep a separate liquidity bridge for funding and restricted balances. The Federal Highway Administration's project-finance overview shows a typical waterfall in which project revenues pass through operating and rehabilitation uses before debt service and equity distributions. The project's own waterfall determines the actual sequence.

Build a quarterly cash bridge

Consider a fictional US solar project in its first operating year after construction. The following amounts are supplied planning inputs for the quarters ending March 31, June 30, September 30 and December 31, 2026. This simplified example has no additional reserve deductions; a real project's required deductions must be included.

Revenue and operating costs are accrual-based amounts with depreciation and financing costs excluded. The working-capital adjustment converts their timing into cash; a positive amount absorbs cash and a negative amount releases it. Taxes and maintenance capital are cash payments.

On a worksheet named Cash, put period in A, revenue in B, operating costs in C, cash taxes in D, working-capital cash use in E and maintenance capital in F. CFADS in G2 is:

=B2-SUM(C2:F2)

Fill down through row 5. No noncash expense is deducted here, so there is no depreciation addback.

The annual bridge proves the numerator: $1,220,000 plus the four deduction totals returns $2,300,000. Reconcile each deduction to its supporting schedule before treating that arithmetic identity as evidence of completeness.

Match the debt schedule to those periods

On a separate worksheet, use A for period, B for CFADS, C for required principal, D for required interest, E for total debt service and F for DSCR. Link B2 to Cash!G2. These are required payments, so an unpaid installment remains visible rather than dropping out of the schedule.

In E2, total the scheduled payments:

=SUM(C2:D2)

In F2, calculate coverage, labeling periods without debt service explicitly:

=IF(E2=0,"No debt service",B2/E2)

Ratios are displayed to two decimal places; retain unrounded values in calculations. Principal of $750,000 plus interest of $170,000 proves debt service of $920,000. Annual CFADS less that debt service leaves $300,000 before any other waterfall uses or distributions.

Principal belongs in this denominator even though it is not an operating expense. For that distinction, use DSCR versus interest coverage.

Report minimum and aggregate coverage separately

The quarterly minimum is 1.10x. Aggregate annual coverage is $1,220,000 / $920,000 = 1.33x, rounded. The arithmetic average of the four unrounded quarterly ratios is 1.32x; it is a different statistic and cannot replace either measure.

For this schedule, calculate the minimum and aggregate ratio as follows:

=MIN(F2:F5)
=SUM(B2:B5)/SUM(E2:E5)

Label each output explicitly. Aggregate coverage is debt-service weighted; the minimum identifies the weakest period. An agreement might require rolling annual tests or another window, so add its actual windows rather than treating these illustrative quarters as contractual tests. A maximum annual debt service coverage calculation uses another denominator convention and should remain separately labeled.

Stress timing and cost as distinct cases

First delay $80,000 of Q1 receipts into Q2 without changing recognized revenue. Working-capital cash use becomes $130,000 in Q1 and negative $60,000 in Q2. All other inputs stay unchanged, so annual CFADS is unchanged.

Next, as a separate case, increase operating costs by $20,000 in every quarter. Hold taxes and other inputs constant to isolate the cost sensitivity. The annual cost increase is $80,000.

The receipt delay creates a Q1 operating cash shortfall against debt service of $200,000 - $140,000 = $60,000. Unchanged annual coverage conceals it. Review opening unrestricted cash, permitted reserve draws and exact due dates in the liquidity schedule; do not silently add those sources to CFADS.

If a balloon repayment depends on refinancing, show that dependency separately. The OCC's refinance-risk guidance identifies principal remaining at maturity and reliance on replacement borrowing as sources of refinance risk. Strong coverage before maturity does not prove the maturity payment is funded.

Where it goes wrong

• Mixing cash definitions. EBITDA, CFADS before reserves and cash after reserve funding can produce different results. Preserve the agreed bridge.
• Averaging away the weak quarter. Annual aggregation and simple averages conceal different information. Report the actual contractual tests and the minimum.
• Treating borrowed money as operating performance. Funding can support liquidity without improving project cash generation.
• Losing payment dates. A quarterly surplus does not prove cash exists before an installment falls due. Keep a dated cash schedule alongside coverage.
• Overwriting the base case. Keep scenario adjustments separate so receipt delays cannot quietly become permanent revenue losses or appear in both working capital and revenue.

Review your project cash and repayment files in Covirage

Bring your project cash-flow workbook, debt schedule and supplied scenario assumptions to Covirage, with the coverage definition identified. Covirage maps the columns; its tools compute and check period coverage, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See project cost control for analysis from the project files your team already maintains.