- Before
- “I can calculate any rule. What I can’t do is find 3,912 appraisals.”
- Now
- Starts from every loan already weighted twice, with the page behind each weight, and spends the week on the findings.
One September book, from core close to the capital committee
The agents walk Halstead Plains Bank’s September book at 06:12 on Monday 12 October, when the core closes. The capital committee meets on Thursday; the Q3 Call Report is due on 30 October. Here is the day, screen by screen, in the working solution.
- 0106:12 · core close
The whole book walks the tree
The agentsWhen the core closes, six agents map 74,926 loans and 2,904 commitments to exposure classes, read 11,354 documents in 8,416 loan files and weight every loan under the current rule and the proposal of 19 March 2026. Every branch of the tree carries its loan count and balance; every leaf its RWA today and proposed — 31,640 owner-occupied home loans in Table 5, 218 whose LTV cannot be calculated.
“6 agents · 11,354 documents in 8,416 files · 06:12–07:31”
- 02Morning
One loan, and the path it took
Noor Haddad · VP, Capital PlanningNoor picks AD-24-0311, Cottonwood Flats Townhomes: 64 townhomes in Derby, Kansas, $12,960,000 drawn of an $18,400,000 commitment. It walks to high-volatility commercial real estate at 150%. Beside the real path, a dashed orange branch shows where the core would have sent it — other construction, 95% — because the core codes the loan exempt.
“The core alone gets this wrong. The core codes this loan as exempt from HVCRE, so today it is reported at 100%. The memo’s own worksheet shows 10.7% — below the 15% the exemption needs.”
- 03One click
The page behind the weight
Noor Haddad · VP, Capital PlanningEach fact in the right rail names its document and page. Noor opens the credit approval memo at page 7: land contributed at $1,450,000 and $860,000 of cash equity — $2,310,000 before the first advance, against an as-completed value of $21,600,000 from Harmon Valuation Group. That is 10.7%.
Not counted: “$1,000,000 the sponsor ‘intends’ to add from Phase I sales — not contributed before the first advance.”
- 04Next loan
A 2017 appraisal the core never had
Appraisal readerRM-19-044817, 4218 Juniper Hollow Road, Lawrence — a Kettle Creek Savings loan whose value field was blank after the 2019 conversion. The appraisal reader finds the URAR 1004 effective 14 March 2017 by Carla Brandt, certified residential appraiser, at $412,000. $251,380 over $412,000 is an LTV of 61.0%: Table 5, 35% under the proposal, against 50% today.
- 05Core only
What the same loan costs without its file
Noor Haddad · VP, Capital PlanningNoor switches the values to “Core only”. Juniper Hollow falls to “LTV cannot be calculated” and takes 100% — $251,380 of RWA instead of $87,983. Across the book, 3,912 home loans have no value at origination in the core; the agents found a valid appraisal or evaluation for 3,694 of them.
“Core only: no value at origination, so the proposal gives 100% — $251,380 of RWA instead of $87,983.”
- 06The total
The capital effect, added up from the loans
Capital impact writerRisk-weighted assets fall from $30,994.2M to $28,631.7M under the proposal, and the CET1 ratio rises from 11.65% to 12.62% — 96 basis points on $3,612.0M of CET1 capital. The bridge shows where it comes from: owner-occupied home loans −$1,191.6M, commercial real estate −$398.0M, C&I −$344.0M; home loans repaid from rents +$33.2M.
“What the loan files are worth: 23 bp · $518.0M of RWA.”
- 07Before 30 October
Where the file disagrees with the core
Noor Haddad · VP, Capital PlanningSome findings change today’s reported numbers, not only the proposal’s. Seven construction loans ($104.6M) coded exempt are HVCRE: +$52.3M of RWA on the Call Report. Five coded HVCRE meet the exemption; 312 home loans coded owner-occupied are repaid from rents; 19 carry hardship modifications coded performing. Noor accepts the seven and sends them to Tom Carrick with their pages.
Any correction to Schedule RC-R is Tom Carrick’s decision.
- 08If she disagrees
An override needs a reason and a second person
Noor Haddad · VP, Capital PlanningOn any loan Noor can accept the finding or override it. An override keeps the core’s answer, needs a written reason and goes to a second person — Priya Venkataraman, credit risk analyst — before it counts. It is on the audit trail and goes to the committee with the summary.
“Sent to Priya Venkataraman · the agents’ weight stands until she approves.”
- 09Still missing
Loans the agents could not prove
Dalia Fenwick · Loan operations218 loans ($41.7M) still have no valid value at origination — 191 of them Kettle Creek loans with only a 2019 broker price opinion. They stay at 100% meanwhile; finding them would lower RWA by $27.1M. Fourteen commitments with no agreement take the 40% conversion factor, and three construction memos without the worksheet are treated as HVCRE.
The appraisal reader never accepts a broker price opinion or an automated valuation, and never estimates a value.
- 10Signed · for Thursday
Noor signs, the CRO approves
Martin Oyelaran · Chief Risk OfficerThe capital impact writer drafts the committee summary: what moves the ratio, what the loan files are worth, the corrections to today’s reporting and the method. Noor signs as capital planning lead; Martin approves it for Thursday’s capital committee.
“Agents drafted this summary. They cannot sign, approve or send it.”