Lender Model Review Checklist
Executive Summary
Key Takeaways
- ✓ A lender-facing model review is organised around covenant protection, since DSCR, LLCR, and cash waterfall mechanics are the primary basis on which the lender's exposure is priced and structured.
- ✓ DSCR and LLCR must be independently recalculated from the underlying cash flow and debt schedule, not accepted as reported, since these figures directly determine covenant compliance and pricing.
- ✓ Debt sculpting formulas should be tested as live calculations, not confirmed as complete based on a hardcoded schedule that happens to produce the target ratio.
- ✓ Cash waterfall priority must be tested under stressed as well as base-case conditions, since waterfall errors often only surface when cash is insufficient to service every tier in sequence.
Objective¶
This checklist verifies the debt and covenant mechanics a lender relies on when reviewing a borrower's financial model: DSCR and LLCR calculation integrity, debt sculpting logic, and cash waterfall priority. It exists as a distinct checklist because a lender's exposure is concentrated in a specific subset of a model's mechanics — the general structural checks in the Financial Model Audit Checklist still apply but do not, by themselves, verify the debt-specific calculations a credit decision depends on.
A lender extending capital against a model's projected cash flows is taking on direct exposure to that model's debt mechanics, not just the underlying asset's commercial prospects. This checklist is built around the failure modes most likely to misstate a lender's actual coverage and pricing position. See Project Finance Model Audit for the broader methodology this checklist draws from.
Applicability¶
Applicable when a lender, credit committee, or independent reviewer is assessing a borrower's or sponsor's financial model as part of credit approval, financial close, or an ongoing covenant compliance review during the loan life. Most directly relevant to project finance, infrastructure, and other structured debt transactions where repayment is sculpted to cash flow, though the covenant recalculation items apply to corporate lending as well.
Checklist¶
| # | Check Item | Why It Matters | Evidence to Collect |
|---|---|---|---|
| 1 | DSCR is independently recalculated from the underlying cash flow and debt service schedule for every period | DSCR is the primary lender protection metric and the figure most directly tied to covenant compliance and pricing | Independent DSCR recalculation, period by period |
| 2 | LLCR is independently recalculated where used, covering the full remaining loan life, not a single period | A model can show acceptable single-period DSCR while concealing a weaker coverage profile later in the loan term | Independent LLCR recalculation |
| 3 | Debt sculpting is confirmed as a live, formula-driven calculation targeting the stated coverage ratio, not a hardcoded schedule | A hardcoded repayment schedule that happens to produce the target ratio will not correctly respond to any change in underlying assumptions | Debt sculpting formula trace and sensitivity test |
| 4 | Cash waterfall priority is tested under both base-case and stressed cash flow conditions | Waterfall errors frequently only surface when cash is insufficient to fund every tier in the defined sequence | Waterfall stress test results |
| 5 | Reserve account funding and release mechanics (DSRA, maintenance reserve) operate correctly against their defined trigger conditions | Reserve mechanics that do not respond correctly to trigger conditions can misstate available cash for debt service | Reserve account mechanics test |
| 6 | Circular references between debt sizing, cash flow, and interest during construction resolve correctly and stably | Debt models are structurally prone to circularity; an unresolved or unstable circular reference can misstate the debt sizing itself | Circularity resolution test |
| 7 | Covenant compliance calculations (minimum DSCR, gearing, distribution lock-up triggers) tie exactly to the facility agreement's defined terms | A covenant calculated inconsistently with the legal definition in the facility agreement is not a valid basis for compliance certification | Covenant definition cross-check against facility agreement |
| 8 | Interest rate and hedging assumptions (fixed, floating, swap) are modelled consistently with the actual facility terms | Mismatched interest rate assumptions distort projected debt service and therefore every downstream coverage ratio | Interest rate/hedge assumption cross-check |
| 9 | Amortisation profile and tail period (post-repayment cash flow buffer) are correctly reflected against the facility's tenor | An overstated tail understates repayment risk; the tail ratio is itself a lender risk metric in project finance | Tail period calculation review |
| 10 | Sensitivity and downside scenarios flow through to DSCR and LLCR, not just to project-level cash flow | A lender needs to see coverage ratio impact directly, not infer it from an operating-level sensitivity table | Scenario-to-covenant flow-through test |
| 11 | Distribution and lock-up mechanics correctly restrict equity distributions when covenant tests are not met | A model that allows distributions to flow regardless of covenant status misrepresents the lender's actual protection | Distribution lock-up mechanism test |
| 12 | Refinancing or balloon repayment assumptions, where present, are clearly flagged and separately stress-tested | Balloon repayment risk is a distinct exposure from ongoing debt service coverage and warrants separate scrutiny | Balloon/refinancing risk flag and stress test |
| 13 | Model currency and interest rate basis match the facility agreement's stated currency and rate basis | A currency or rate basis mismatch between model and facility agreement invalidates the coverage calculation | Currency/rate basis cross-check |
Common Failures¶
- DSCR reported at the target level without a working formula trace back to the underlying cash flow and debt service schedule, making the figure unverifiable.
- Debt sculpting schedule hardcoded to produce the required coverage ratio rather than calculated live, so the checklist item is marked complete without the underlying mechanism actually being tested.
- Cash waterfall tested only in the base case, with priority errors surfacing only once a downside scenario is applied and cash becomes insufficient to fund every tier.
- Reserve account release conditions modelled loosely, releasing reserve cash to distributions before the defined trigger condition is actually satisfied.
- Covenant definitions in the model diverging subtly from the legal definitions in the facility agreement, producing a compliance certificate based on the wrong calculation.
- Circularity between debt sizing and cash flow resolved through a fragile manual iteration setting rather than a documented, stable calculation method.
Recommended Evidence¶
A completed lender model review should be accompanied by an independent DSCR/LLCR recalculation, a covenant definition cross-check against the facility agreement, and a red flag report documenting any structural issue found. The table above is structured for direct use in model governance documentation, a credit committee paper, or an audit working-paper file supporting a financial close condition precedent.
How to Use This Checklist¶
Apply the general Financial Model Audit Checklist first to confirm baseline structural soundness, then work through this checklist with direct reference to the facility agreement's defined terms for each covenant. Recalculate DSCR and LLCR independently rather than accepting the model's own reported figures, and test the cash waterfall under a stressed scenario, not only the base case. See Infrastructure Lender Catches DSCR Error Before Financial Close for an applied example, and the GCC Lender Requirements Reference Guide for regional context.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
Related Glossary¶
Related Checklists¶
- Pre-Financial-Close Audit Checklist
- Renewable Energy Model Checklist
- PPP Model Checklist
- Model Reviewer Checklist — the role-neutral internal peer-review checklist to apply alongside this audience-specific one
Related Case Studies¶
- Infrastructure Lender Catches DSCR Error Before Financial Close
- Bank Syndicate Standardises Model Audit Across a Loan Portfolio
Related Resources¶
Related Products¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What is a lender model review checklist used for?
Verifying that a borrower's financial model correctly calculates the debt service and covenant metrics a lender relies on to price, size, and structure a facility, before that model is relied on for a credit or financial close decision.
Why is DSCR recalculated independently rather than checked against the reported figure?
Because DSCR is a formula-driven output that can be manipulated or miscalculated in ways not visible from the reported number alone; independent recalculation from the underlying cash flow and debt service schedule is the only reliable verification method.
What is debt sculpting, and what does this checklist check about it?
The process of shaping a debt repayment schedule to a target coverage ratio based on projected cash flows. This checklist verifies the sculpting is a live formula-driven calculation, not a hardcoded schedule that has been reverse-engineered to show a passing ratio.
What is a cash waterfall, and why is it tested under stress?
The defined priority order in which project or borrower cash is applied to costs, debt service, reserves, and distributions. Waterfall errors frequently only appear when cash is insufficient to fund every tier, which a base-case-only review will not reveal.
How does LLCR differ from DSCR in this checklist?
DSCR measures coverage in a single period; LLCR measures coverage across the full remaining loan life. Both are checked because a model can show acceptable DSCR while concealing a weaker LLCR profile later in the loan term.
Who uses this checklist?
Bank credit teams, project finance lenders, and advisors conducting an independent structural review of a borrower's model ahead of a credit committee decision or financial close.
Does this checklist apply to corporate lending as well as project finance?
The covenant recalculation and circularity checks apply broadly. The debt sculpting and cash waterfall items are most directly relevant to project finance and structured lending, where debt is shaped to cash flow rather than fixed-amortised.
How does this checklist relate to the pre-financial-close audit checklist?
This checklist focuses specifically on debt and covenant mechanics from the lender's perspective. The pre-financial-close checklist covers the broader set of conditions precedent and documentation items required before funds are released, of which model review is one component.
References
Related Articles
What Is a Financial Model Audit?
A financial model audit is an independent, structured examination of an Excel based financial model to confirm that its mechanics, logic, and outputs are reliable enough to support a decision. It is not a check of whether the assumptions are optimistic or conservative. It is a check of whether the model actually calculates what its author believes it calculates. Every year, lenders extend debt, investment committees approve capital, and boards sign off on transactions using numbers that came out of a spreadsheet nobody outside the immediate deal team has independently verified. A financial model audit exists to close that gap before it becomes expensive.
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.
Audit vs Validation — What's the Difference?
Financial model audit and model validation are frequently used as interchangeable terms, and specifying the wrong one in a lender requirement or an internal policy leads to real confusion about what has actually been checked. They test different things. An audit tests whether a model's mechanics are correct. Validation tests whether the model's methodology and assumptions are appropriate for its intended purpose. Both are legitimate, useful exercises. They are not substitutes for each other.
Model Reviewer Checklist
This checklist structures the independent peer-review stage of a modelling team's internal quality-assurance workflow. It is role-neutral and standard-agnostic — written for whoever is acting as the second, independent reviewer of a model, rather than for a specific external audience such as a lender or investment committee. It complements, rather than duplicates, the audience-specific review checklists elsewhere in this section and the Financial Modelling Best-Practice Checklist used at the construction stage that precedes peer review.