- Before
- Reads about 60 files a year end to end, and spends four hours building a file for twenty minutes of judging it.
- Now
- Opens a loan with the file built, the statements spread, the covenants recomputed and every factor cited — and spends her time on the grade.
One loan, from the matrix to the board report
Monday 12 October, ten days before the board risk committee. The agents finished reading Northmere Bank & Trust’s whole commercial book on Sunday morning. Here is what Nora Lindqvist does with it, screen by screen, in the working solution.
- 01Monday morning
The whole book on one screen
Nora Lindqvist · Senior loan review officerThe grade migration matrix puts each loan’s Q2 grade of record against the grade its file supports in Q3. 1,327 loans sit on the diagonal: the agents agree with the lender. 91 loans, $518.7M, sit off it — 68 graded too generously, 23 too harshly, and 20 pass loans that cross the dashed line into criticized.
How this matrix was made: “1,418 loans re-graded on 8 factors, every reason cited to a page · 1,327 agree with the grade of record · 91 do not.”
- 02One toggle
The same matrix, through last year’s sample plan
Nora Lindqvist · Senior loan review officerSwitched to “Last year’s sample plan”, the matrix shows what the old method would have seen this quarter: about 78 loans read — the large ones, the watch list and a slice of the rest. It would have reached 27 of the 91 by the committee. The other 64, $329.1M, keep the lender’s grade until their annual review.
“The other 64 ($329.1M) keep the lender’s grade until their annual review, including all 6 in Pass 4 → Substandard 7.”
- 03One click
Pass 4 → Substandard 7: six loans, $53.2M
Nora Lindqvist · Senior loan review officerThe only three-notch jump in the book. The cell opens to its loans with the reason for each move and the page behind it. Brennick Cold Storage, $17.6M, heads the list: debt service coverage 0.84x on the agreement’s terms against a 1.25x covenant — the certificate says 1.31x — and its largest customer moves 40% of its volume in April 2027.
- 041 min 12 s
“Start review” — the case rebuilt from 34 documents
The six agentsNora starts the review. The file assembler gathers the credit file and flags an appraisal 40 months old. The financial spreader finds the $680,000 add-back has no written approval under §1.1 and $710,000 paid to the members is missing from the certificate. The covenant tester recomputes 8 covenants and finds two breaches. The risk rating assessor reads the memo and call reports and suggests 7 · Substandard.
“Why not 8 · Doubtful: payments are current, the buildings cover the loan at 67% loan-to-value and the guarantor holds $2.9M of cash — full collection is not improbable.”
- 05Factor by factor
Eight rating factors, each with its evidence
Risk rating assessorRepayment capacity moves from 4 to 7, customer concentration and liquidity to 6, leverage and management to 5. Collateral, the guarantor and payment performance hold. Each row shows what the file says now against renewal, with links to the certificate, the agreement, the Fernvale letter, the call report and the borrowing base — 16 citations in all.
“No better than repayment capacity unless the collateral alone repays the loan (policy 3.2.4).”
- 06Spread
Coverage on the agreement’s definition, not the borrower’s
Financial spreaderEBITDA was $4.715M as reported. Take out the $680,000 compressor add-back the bank never approved, the $850,000 of unfinanced capital spending and the $710,000 of distributions, and $2,475,000 is left against $2,950,000 of debt service: 0.84x, down from 1.48x at renewal. Funded debt to EBITDA is 4.11x against a 4.25x maximum.
Credit agreement §1.1: add-backs only for charges “approved in writing by the Bank in its sole discretion” — no approval in 34 documents.
- 07Recomputed
Every covenant, certificate against recomputed
Covenant testerEight financial and reporting covenants for the quarter to 30 June. Two breached: debt service coverage (§7.1) and distributions (§7.5), which are allowed only while coverage stays at or above 1.35x. Two tight: leverage and the revolver at 94% of its borrowing base. The signed certificate sits beside the table with the add-back highlighted.
- 08Agreed
She agrees with 7, and the challenge is drafted
Nora Lindqvist · Senior loan review officerThe challenge drafter writes it in the bank’s format: three reasons with six citations, why not Doubtful, and four conditions — a new appraisal of both buildings within 60 days, a reservation-of-rights letter and no further distributions, the borrower’s plan to replace the Fernvale volume, and a monthly borrowing base. Nora can edit every line before she sends it.
The challenge drafter never sends a challenge — the reviewer does.
- 09Same morning
The lender answers
Marcus Hale · SVP commercial bankingMarcus has until Mon 26 Oct, 10 business days, to agree or answer with his reasons. He agrees with 7, tells the borrower there will be no more distributions, asks legal for the reservation-of-rights letter and orders the appraisal. Had he disagreed, both write-ups would go to Warren Pike, the Chief Credit Officer.
“I knew about Fernvale but expected Owen to backfill the space — he hasn’t signed anyone yet. I didn’t know about the distributions.”
- 10Recorded
Final grade 7, in the board report
Nora Lindqvist · Senior loan review officerNora records the final grade 7. The grade of record changes from 4, and the allowance team and the watch list are told. In Adaeze Okafor’s Q3 loan review report for the board risk committee, Brennick is one of the 20 pass loans newly criticized, $152.7M, next to the review status of all 91 and each lender’s grade accuracy.