- Before
- “By the time a draw shows me the overrun, the contingency is already gone.” Re-keys site reports, schedules and change-order logs into a spreadsheet per loan.
- Now
- Starts the week on his 31 loans ranked by how far each interest reserve falls short of its finish, each with its S-curve, its forecast, its sources and the recommended actions waiting for his decision.
One loan, from a new site report to a signed balancing notice
Harrow Yard Apartments, 248 units in Charlotte, passed its Draw 16 balancing test on 18 September. Five documents later, here is what happens on Monday 12 October, screen by screen, in the working solution.
- 01Monday morning
Thirty-one loans, ranked by how far the reserve falls short
Owen Pryce · CRE construction portfolio managerOwen opens the S-curves. The rail ranks his 31 construction loans by how far the interest reserve falls short of each project's finish, and Harrow Yard is first. Its curve has bent below plan: 61.4% built against a plan of 68.0%, 6.6 points and $3.34M of work not in place. The gap by trade puts drywall on Levels 3–5 ($1.50M) and the main switchgear ($0.74M) furthest behind.
The agents' forecast: “Interest reserve hits $0 in Aug 2027 · 4 months before the finish · 90% leased Dec 2027.”
- 021 min 12 s
Re-forecast from the five new documents
The six agentsSince Draw 16, site report 17, schedule update rev 9, pending change orders 11–13, Ashgrove's letter and Fernhill's leasing report have landed. The agents read each one, re-price the budget, project interest to 90% occupancy, run eight tests and re-score the loan from 55 to 84 — each step shown with what it found and how long it took.
“Balance and covenant tester ran 8 tests · In balance today · forecast out of balance $613,000 at completion.”
- 03To the finish
The money, burning down on the same time axis
Interest reserve forecasterUnder the S-curve, the interest reserve ($1,835,000 left) and the contingency ($1,026,000 left) run solid to today and dotted to the finish. The reserve hits $0 in August 2027; the finish — 90% leased — is December 2027. The four months between are hatched: $210,000 of interest with nothing to pay it. The contingency runs out in March 2027, $403,000 over with the delay claim.
“short $613,000 at the finish” — while today's test still passes.
- 04Try it
What moves the zero
Owen Pryce · CRE construction portfolio managerOwen sets leasing to 18 a month. The dotted line redraws: the reserve now hits $0 in July 2027, seven months before 90% leased, and the loan is short $793,000. Completion (rev 9, +30 or +60 days) and Term SOFR (3.60% forward or +50 bp) move it the same way. He sets it back to the forecast — the published numbers stay the agents'.
- 05Line by line
Cost to complete, and why the draw test cannot see it
Change order and cost watcherLeft in the loan: $25,713,000, equal to the budget remaining — so the loan is in balance today. The forecast cost to complete is $26,326,000. The bridge shows why: pending change orders +$1,148K, the contingency that absorbs them −$1,026K, the delay claim +$281K and interest to 90% occupied +$210K. PCO 11, the switchgear and copper feeders at $612,000, follows a supplier letter citing metals tariffs.
“Today’s draw test compares the left-in-loan bar with the approved budget only — the four steps in between are not in it yet.”
- 06The critical path
Baseline against rev 9, milestone by milestone
Site and schedule readerSubstantial completion moves from 15 January to 26 March 2027, 70 days late, with 96 days of margin to the 30 June outside date in §5.2. The critical path runs through the switchgear, due 9 February, then permanent power, the elevators and the TCO. The consultant's percentages stay the consultant's; every date cites its page.
Ben Arkwright, site report 17: “Rev 9’s 26 March completion is achievable only if the switchgear date holds; it shows no float on that path.”
- 07Every assumption shown
The reserve, month by month to 90% occupied
Interest reserve forecasterThe calculator shows the assumptions: completion 26 March 2027, 46 units leased at completion against a plan of 72, 22 leases a month against a plan of 26, Term SOFR 3.60% plus 2.85% = 6.45%. Net operating income starts in April; the reserve runs dry in August; the building reaches 90% occupied — 223 of 248 units — in December.
“The forecaster uses 22 a month — the three comparable buildings average 22.0; the closing plan assumed 26.”
- 08Drafted
Four actions and a balancing notice, every figure sourced
Risk and action drafterThe drafter recommends a balancing notice to Pell Street Partners for $613,000 under §7.3, a recovery schedule from Ashgrove by 23 October with the $281,000 claim held, the watch list at risk rating 4 → 5 (Special Mention), and an extension test set for 14 January 2028. The notice sets out the shortfall in three parts and says Draw 17 will be funded as usual while they talk.
“drafted by the assistant · sent only when you sign”
- 09Signed
The portfolio manager approves, with the meaning recorded
Owen Pryce · CRE construction portfolio managerOwen reviews the four actions and signs. The signature carries its meaning — “I have reviewed the forecast and its sources and approve these actions”. The rating change goes to the Chief Credit Officer, and nothing reaches the borrower until Marcus Delaney sends it.
- 1024 days before Draw 17
The CCO approves the rating, ten months early
Lydia Fernsby · Chief Credit OfficerLydia approves risk rating 5 (Special Mention), and Harrow Yard goes on the watch list. The decision panel records it: $613,000 forecast out of balance, 24 days before Draw 17 on 5 November, 10 months before the reserve runs dry. The monthly portfolio report for Thursday's credit committee picks up the new rating and the signed notice.