How Lenders Read a CBA Workbook in Under Five Minutes
A credit committee meeting is not a leisurely reading exercise. Fifteen or twenty minutes per submission is typical, sometimes less. The senior lender in the room has usually opened the workbook the night before, knows exactly where they are going, and has formed a view before the meeting starts. What they are looking for is confirmation or contradiction, not discovery.
Any bankability workbook that requires more than five minutes to reveal its answer is a workbook that has already lost the room. This piece sits under the m2 pillar on bankability and viability. It explains the five tabs an experienced lender opens first, in what order, and why.
Tab one, the summary page
The summary page is where the answer lives. Every serious lender opens it first. What they are looking for: the headline metrics (NPV, IRR, DSCR, BCR where relevant), the sensitivities, and the covenant position in the shape the transaction proposes.
A summary page done well shows: the base-case values for each metric, the range under the sensitivity analysis, the covenant thresholds plotted alongside, and the specific request being made of the lender (facility size, tenor, security, pricing indication).
A summary page done badly shows a wall of numbers without a covenant reference, or a single point-estimate without any sensitivity, or metric names without their calculation basis. A senior lender who cannot form a view from the summary page in under sixty seconds will not usually open the workbook further; they will send the submission back for reformatting or reject it on incompleteness (Yescombe and Farquharson, 2018).
Tab two, the sensitivity or tornado chart
The second tab most credit committees open is the sensitivity analysis. A serious lender wants to know what the project is genuinely sensitive to before they invest time in understanding the base case.
The tornado chart (which I covered in the previous cluster in this series) is the standard format. What the lender is looking for is which two or three variables sit at the top of the tornado and whether those variables are ones the sponsor has convincingly nailed down.
If the project's IRR is most sensitive to construction cost overrun and the sponsor has an EPC contract with meaningful liquidated damages, the lender is reassured. If the sensitivity is to a demand forecast that comes from an internal sponsor study, the lender is not.
Tab three, the debt service schedule
The debt service schedule shows the period-by-period debt service against the project's operating cash flow. What the lender wants to see: a DSCR profile that stays above the proposed covenant threshold in every period, with a comfortable buffer in the periods that matter most (the years just after commissioning, the years where balloon payments fall due, the years just before refinancing).
The lender is not looking for the average DSCR; they are looking for the shape. A profile that dips near the threshold in specific periods is a profile that will produce covenant conversations later, and the lender wants to know now whether those conversations can be managed or will end in default (Brealey, Myers, and Allen, 2020).
The debt service schedule is where the interaction between the project's cash flow shape and the debt structure becomes visible. Where the interaction produces uncomfortable periods, the lender's usual response is to ask for a restructured debt schedule that moves payments to periods with more cushion. This is a negotiation the sponsor should be prepared for, and the workbook should support.
Tab four, the assumptions register
The assumptions register lists every material assumption used in the workbook, with the source for each. A lender opening this tab is asking: are these assumptions defensible, and can I trace each one back to a source I recognise?
A defensible register shows: the assumption (e.g., inflation escalator 5.2 percent per annum), the source (e.g., Reserve Bank inflation target midpoint plus 0.5 percent margin), and the period the assumption applies to. Where the assumption is a forecast produced by the sponsor or their consultants, the register should identify the consultant, the date of the study, and the methodology at a summary level.
A weak register lists assumptions without sources, or with sources like "internal analysis" or "sponsor projections". Lenders reading such a register form the view that the analysis is not independently verifiable. National Treasury's Budget Facility for Infrastructure guidelines (National Treasury, 2019) are explicit about the assumption-documentation standards expected of submissions; commercial lenders apply similar expectations.
Tab five, the operating cash flow build
The operating cash flow build shows how revenue and cost lines aggregate into the cash flows that drive every other metric in the workbook. A lender opening this tab is testing whether the numbers on the summary page reconcile to the underlying model.
What they check: do the revenue lines aggregate to the top of the cash flow build (or is there a plug); do the operating cost lines escalate on defensible bases (differentiated by cost category, not a single CPI proxy); do the tax and working capital treatments look right; is the timing of cash flows aligned with the operating logic of the project.
Where the operating cash flow build cannot be reconciled to the summary page, the lender's confidence in the workbook collapses regardless of how attractive the summary metrics look. Reconcilability is a hygiene requirement, not a differentiator; workbooks that fail on this basic point do not proceed to detailed review.
What lenders do NOT read first
Several sections of a typical workbook are important but not on the five-minute path. Lenders open them later, if at all.
The historical financial statements. Important for context but not decisive. Lenders assume the auditor did their job on the historical numbers; they focus their attention on the forward-looking analysis.
The market study. Important for understanding the underlying demand assumption but often too long to be useful in a first pass. Lenders typically read the executive summary and the specific demand forecast, then move on unless something surprising emerges.
The environmental and social section. Important for identifying showstoppers (a missing environmental authorisation) but again not on the fast path. Lenders check for the specific approvals required and their current status, then move on.
The technical description of the project. Assumed to be correct unless the tornado chart flags technical risk as a top-two sensitivity, in which case the lender opens the technical section to understand the specific concern.
The structural implication
The implication for anyone building a bankability workbook is that the tab order, the summary layout, and the internal consistency across tabs matter more than the total volume of analysis. A 200-slide submission that is well-structured is more effective than a 400-slide submission that is not. Lenders reward workbooks that are built for how they actually read.
The other implication is that the workbook has to survive independent inspection. Any lender who opens the operating cash flow build and finds it does not reconcile to the summary page has effectively rejected the submission on that ground alone. The parity between the summary and the underlying model is not a nice-to-have; it is the credibility floor.
Cross-border considerations
Cross-border project finance submissions add complications: multi-currency reconciliation, cross-jurisdictional tax treatment, host-country regulatory approvals. The five-tab structure still holds, but each tab needs to accommodate the additional dimensions. The summary page shows metrics in a defined convention (usually the debt currency); the sensitivity includes currency and country-risk-premium as testable variables; the assumptions register documents which shadow prices and country adjustments apply; the operating cash flow build handles the currency conversion transparently.
Submissions to multilateral lenders (World Bank, DFIs) have their own additional format expectations, often more prescriptive than commercial lenders (World Bank, 2017). Sponsors preparing for multilateral submissions should read the specific format requirements before building the workbook.
What good looks like
A well-built workbook allows a lender to form a view in under five minutes, invites a deeper look into the specific areas that warrant it, and rewards the deeper look with reconcilable, defensible, source-referenced analysis. Lenders who form a positive view in the first five minutes and confirm it in the next fifteen come to the credit committee ready to advocate; lenders who cannot form a view in the first five minutes come with reservations.
The CentraSolve Bankability and Viability module builds the workbook in this five-tab structure by default. The summary page is generated from the underlying model, so parity is enforced rather than checked. The sensitivity and assumption registers are first-class artefacts. Lenders who receive a submission generated through the platform receive it in a shape they know how to read.
References
Textbook and framework sources
Brealey, R. A., Myers, S. C., and Allen, F. (2020). Principles of corporate finance (13th ed.). New York: McGraw-Hill Education.
Yescombe, E. R., and Farquharson, E. (2018). Public-private partnerships for infrastructure: principles of policy and finance (2nd ed.). Oxford: Butterworth-Heinemann.
World Bank Group. (2017). Public-private partnerships reference guide (Version 3.0). Washington, DC: World Bank.
South African framework sources
National Treasury, Republic of South Africa. (2019). Budget Facility for Infrastructure: guidelines and templates. Pretoria: National Treasury.