Infrastructure Lender Catches DSCR Error Before Financial Close
Executive Summary
Illustrative Scenario
This case study is a composite, educational scenario built from patterns commonly observed in financial model audits. It does not describe a specific, identifiable client engagement, and any resemblance to a particular transaction is coincidental.
Background¶
A mid-sized infrastructure lender was preparing to close a senior debt facility for a transport-related infrastructure asset. The borrower's financial model, built to size and sculpt the debt repayment schedule to the project's projected cash flows, was the primary basis for the facility's structuring, including the minimum debt service coverage covenant the lender intended to hold the borrower to over the loan life.
As a condition precedent to financial close, the lender commissioned an independent structural audit of the borrower's model, focused on the debt sizing and covenant calculation mechanics specifically, in addition to the general structural checks already applied.
The model itself was built along conventional lines: a monthly cash flow schedule feeding an annual debt service schedule, with a coverage ratio calculated period by period and summarised on a covenant compliance tab reviewed by the credit committee.
The Problem¶
The covenant compliance tab showed the projected debt service coverage ratio comfortably above the facility's minimum covenant level in every projected period, consistent with the borrower's own representations during structuring discussions. On its face, the projected coverage profile supported the proposed debt sizing.
Instead of accepting the ratio as displayed on the compliance tab, the audit independently recalculated the coverage ratio from the underlying cash flow and debt service schedules.
Findings¶
Recalculating the ratio period by period, the audit found that the debt service figure used in the denominator of the coverage ratio formula, in several projected periods, referenced the prior period's debt service schedule row rather than the current period's. This is a period-reference error, a category addressed in the Formula Error Types technical guide.
Because the project's debt service profile increased over time as construction-phase grace periods rolled off, referencing the prior, lower period understated the denominator in the affected periods, which in turn overstated the calculated coverage ratio relative to what the current period's actual debt service would produce. See Debt Service and Debt Sculpting for the underlying mechanics.
Root Cause¶
Tracing the formula pattern across the schedule indicated the coverage ratio formula had originally been built correctly, but a later revision inserted an additional row into the debt service schedule to separate senior and subordinate tranches. The coverage ratio formula in several periods was not updated to reference the new row layout and continued pointing at what had become the prior period's row after the insertion.
The error is mechanical rather than a matter of judgement: a formula left unreconciled after the schedule was restructured, not any disagreement over the debt sizing methodology or the target coverage level itself.
Risk¶
Undetected, the period-reference error would have led the lender to close the facility believing the project carried more covenant headroom than its cash flows would actually support in the affected periods. The facility would then have been sized against an overstated coverage profile, raising the risk of an undetected covenant breach later in the loan life once actual cash flows tracked the true, lower coverage level.
Resolution¶
Ahead of financial close, the lender's credit committee reviewed the audit findings, including the corrected period-by-period coverage ratios. The borrower's model team corrected the formula references across the affected periods and the lender's advisors re-verified the corrected coverage profile against the facility's minimum covenant level before signing. The debt sizing was adjusted marginally to preserve the intended covenant headroom under the corrected figures.
Lessons Learned¶
- Coverage ratio formulas should be independently recalculated from source schedules during audit, not reviewed as displayed on a summary tab, a distinction central to the Project Finance Model Audit pillar.
- Schedule restructuring, such as inserting a new row to separate debt tranches, is a common trigger for period-reference errors elsewhere in the same workbook.
- Pre-financial-close audit is the natural checkpoint for catching this class of error, since it is the last point before funds are committed.
- Covenant calculations warrant the same level of formula-level scrutiny as debt sizing itself, since an error in either can misstate the lender's actual protection.
- Applying the same pre-close audit checklist consistently, rather than letting its rigour vary under closing-timeline pressure, is what catches a formula reference left over from an earlier revision before it reaches the credit committee.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
Related Glossary¶
Related Industries¶
Related Checklists¶
Related Products¶
Related Case Studies¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
Is this a real client engagement?
No. This is an illustrative, composite scenario built from patterns commonly observed in financial model audits. It does not describe a specific, identifiable transaction.
What is a period-reference error and why does it matter for a coverage ratio?
A period-reference error occurs when a formula pulls a value from the wrong row or column in a time-series schedule, for example the prior period instead of the current one. In a coverage ratio calculation this misaligns the numerator and denominator, producing a ratio that does not reflect either period correctly.
How is this different from disagreeing over the debt sizing assumptions?
Debt sizing assumptions, such as the target coverage ratio itself, are a structuring decision. Whether the formula that calculates the resulting ratio references the correct period is a mechanical question. This case study addresses the latter, a formula error, not a disagreement over structuring terms.
What audit stage typically catches this kind of error?
Pre-financial-close lender audit is the typical stage, since it is the last point before funds are committed at which a coverage ratio error can still be corrected without triggering a waiver or amendment process later in the loan life.
How could this have been caught earlier?
Independently recalculating the coverage ratio from the underlying cash flow and debt service schedules, rather than reviewing the ratio as displayed, would have surfaced the period misalignment directly.
Is circularity in a project finance debt model always the cause of this kind of error?
No. This particular error was a period-reference mistake, unrelated to circularity. Circular references are a separate, and separately audited, source of risk in debt models, addressed in the Circularity in Debt Models guide linked below.
Related Articles
What Is a Project Finance Model Audit?
A project finance model audit is a financial model audit applied to the specific class of model used to finance infrastructure, energy, and long dated capital projects: debt sculpted, multi decade, cash flow driven structures with mechanics that do not appear in a typical corporate model. It is frequently a formal condition of financial close, not an optional check, and lender requirements for it exist almost entirely inside non public bank credit policy rather than any single consolidated public source. This page defines what makes project finance models structurally distinct, why lenders require independent verification of them specifically, and what the audit process looks like in this context.
What Is Model Risk?
Model risk is the risk that a decision is wrong not because the underlying business or investment case was flawed, but because the model used to evaluate it was. It is a distinct category of risk from market risk, credit risk, or operational risk, and it applies to any organisation that relies on a financial model, spreadsheet or otherwise, to support a material decision. Most published model risk content addresses statistical and regulatory capital models used inside banks. This page defines model risk specifically as it applies to Excel based financial models, the kind used every day for investment decisions, lending, and transaction evaluation, which is a related but distinct problem from the quantitative model risk literature most search results return.