- Before
- Spends three days after the spread pasting tables and re-describing the file, then hunts through the memo every time a figure moves.
- Now
- Reads, edits and accepts a cited draft written in front of her; a spread change rewrites what depends on it and waits for her.
One memo, from approved spread to committee
Brennick Precision Components, a CNC machining shop and a customer of Halvern Bank & Trust since 2014, asks for $19,000,000 across three facilities. Here is the memo being written and changed, screen by screen, in the working solution.
- 01Monday morning
Spread approved, file complete, memo still blank
Hannah Okafor · Senior commercial credit analystHannah approved spread v3 on Friday at 16:48; two minutes later the file reader marked the deal file complete — 38 documents, 412 pages. The memo opens in the bank’s Commercial credit memo v2026.2 template with all 12 sections waiting, and the documents each section will be written from already in the margin.
“Everything the memo needs is in.”
- 02One click
“Write the memo” — written top to bottom, in front of her
Memo writerThe sections fill in order while the run log shows each agent’s work: the file reader indexed 1,906 figures with their page; the spread and cash flow analyst took spread v3 — cash available for debt service $3,880,000, DSCR 1.60x, global 1.42x. Structure, covenants and pricing come with the cushion on each covenant and the relationship return.
- 03Drafted
Fourteen pages, every number underlined
The agentsThe recommendation reads like the bank wrote it: $19,000,000 in a renewed $8,000,000 revolving line, a $6,800,000 equipment term loan and a $4,200,000 real estate term loan, guaranteed by Daniel Brennick and Laura Brennick-Ortiz. Two policy exceptions are found and mitigated, and risk grade 5 — Acceptable — is proposed. Above the CCO’s $15,000,000 authority, so it goes to loan committee.
“Memo writer done · 14 pages · 113 numbers, each with its page.”
- 04Any number
Click a figure, see the page it came from
Hannah Okafor · Senior commercial credit analystIn the collateral table Hannah clicks the plant value. The drawer opens the Lakeshore Valuation Group appraisal of 2250 Ironwood Industrial Drive at page 2 of 86, with “Final value, as is, fee simple — $5,400,000” highlighted, and lists the sections that cite it: §2, §6 and §9. That value is why the real estate loan to value is 77.8% against a 75% maximum.
- 0508:52
Two documents disagree — she decides, with a reason
Hannah Okafor · Senior commercial credit analystDaniel Brennick’s personal financial statement lists $1,920,000 of liquid assets; his brokerage statement of 31 August shows $1,410,000, after a $520,000 withdrawal on 14 July for a house build. Hannah uses the verified figure and records why. Combined guarantor liquidity is $2,040,000 against the $1,900,000 the policy needs — 10% of guaranteed debt, §6.2.
“Two documents in the file disagree. The agents use neither until you choose.”
- 0609:05
The K-1s arrive — one cell changes, the memo follows
Hannah Okafor · Senior commercial credit analystVandermolen & Pike CPAs send the 2025 K-1s: tax distributions were $1,717,000, not the $1,050,000 the interim statements estimated. Hannah types the figure into spread row 55. Spread v4: cash available for debt service falls to $3,213,000, DSCR to 1.32x, global DSCR to 1.18x, the EBITDA −20% stress to 0.82x — and the recommendation rewrites itself with the new figures.
“12 numbers updated and 3 paragraphs rewritten in 7 sections; a new exception and its mitigant added. Nothing is final until you accept.”
- 07Same minute
A new exception, and a mitigant with its sources
Policy checker · Memo writerGlobal coverage of 1.18x is below the 1.20x minimum in policy §4.2, so exception 3 appears in §9, and §10 gains a new risk: cash flow after distributions. The mitigant suspends $480,000 of other distributions until global coverage is at least 1.25x for two consecutive quarters — business coverage 1.52x and global 1.35x without them. Both passages are marked “New · from spread v4”.
- 08Checked
Structure, cash flow and every limit against policy
Spread and cash flow analystFacilities and pro forma debt service of $2,430,581, each policy limit as a bar — global coverage 1.18x, real estate loan to value 77.8% and inventory advance rate 55% flagged as exceptions — the stress cases, and the table of every figure that depended on the change, before and after, with the section and source.
- 09Proposed
Grade 5 — Acceptable, with the reason for every factor
Risk graderThe weighted scorecard is 5.05 and rounds to 5, from 4 in the October 2024 memo. The move comes from leverage — 2.97x pro forma against 1.71x a year ago — and from coverage of 1.32x once the K-1 tax distributions are in. The grade is a proposal: Martin Asher and the committee set the final grade.
“Proposed · the approver sets the grade.”
- 1010:12
Accepted, checked, sent the same morning
Hannah Okafor · Senior commercial credit analystAt 09:08 Hannah accepts the 12 updated numbers and 3 rewritten paragraphs. All seven readiness checks pass — 130 of 130 numbers cite a page, no open conflicts, the latest figures in the spread, every change accepted, every exception mitigated — and she sends the memo to Renee Dubois for review, due today at 17:00, on its way to Thursday’s loan committee with three exceptions.