- Before
- Runs 9 officers and 1,184 farm borrowers, and finds out about the drought when the file comes up for renewal.
- Now
- Sees the book on this week’s drought map every Monday, opens a drafted review, and decides on rating and watch list months ahead.
One farm, flagged in October with renewal in March
Willowmere State Bank lends to 1,184 farms in 32 counties of Nebraska and Kansas. On Thursday 8 October the drought map moved again. Here is what happens next, screen by screen, in the working solution.
- 01Monday morning
The whole ag book, on this week’s drought map
Ruth Engel · Ag Lending ManagerRuth opens the book map: every farm a dot in its county, coloured by its early warning score, over the Drought Monitor map of 8 October. Perkins County has been in D3 extreme for 11 weeks. Under the map sit the three counts that matter: 27 alerts, 9 of them high; 38 on the watch list, $96.4M; $286M in D2 or worse, up $20M on the week.
Thursday’s scan: 6 agents · 1,184 borrowers · 4,318 parcels · 8 Oct 10:00–10:41.
- 02Thursday, replayed
Drought spread into Kansas — and twelve farms turned amber
The agentsRuth replays Thursday’s scan. D3 reaches Rawlins, Decatur and Norton counties, and drought alone pushes 12 farms there into watch range. The agents then check each one against crop insurance, prices, payments and line use. Nine settle back. Three stay: Sutter Creek Farms (premium $18,400 unpaid, deposits −44%), Rasmussen Land Co. ($88,000 wheat claim with no assignment to the bank) and Wagoner Farms (2 overdrafts in September, line 79%).
“9 cleared — insured and paying on time · 3 need a call: Sutter Creek 67 · Rasmussen 53 · Wagoner 49”
- 03One click
Why a farm in extreme drought was not flagged
Early warning scorerHerl Wheat Farms, Rawlins County, scored 54 on drought alone. With insurance, prices and payments it scores 24: drought +30 and wheat under its $5.92 median breakeven +4, but Revenue Protection at 80% assigned to the bank −20, and 12 of 12 payments on time with the line at 49% −14. No alert is raised; the agents keep watching every week.
“Cleared: Revenue Protection at 80% covers the wheat; line 49% drawn against a 52% norm; every payment on time.”
- 04Another layer
Yields and prices under the same farms
Ruth Engel · Ag Lending ManagerThe map has three layers: drought with a 14-week slider, the yield outlook against the 5-year average, and the price move of each county’s main commodity. In Hitchcock County the outlook for pasture and hay is −42%; the county rail lists its farms most exposed, each with crop mix, insurance, the last 12 payments and line use.
- 05Ranked
Every alert, ranked, with the reasons on the row
Ruth Engel · Ag Lending ManagerThe alert feed ranks 27 borrowers by score: $75.0M of exposure on alert, 15 waiting for Ruth, 25 farms renewing within six months. At the top is Voss Land & Cattle LLC, Perkins County, cow-calf: score 81, up 9 — D3 drought 11 weeks, 212 bred cows sold, line 96% drawn. Officer Cody Harms; the line renews 1 March, 140 days away.
- 06Opened
Seven signals, two mitigants, every one with its source
Ruth Engel · Ag Lending ManagerVoss is rated 4, Acceptable, since renewal in March, with $5,124,000 outstanding on four loans. The score shows why: $356,160 of sale-barn proceeds deposited 1 October for 212 bred cows, with the $868,000 cattle note unchanged (+18); the line at 96% against a five-year October norm of 55% (+15); working capital down from $612,000 to $188,400 on the 30 June balance sheet (+13). Weighing against it: the $214,000 wheat claim is assigned to the bank (−6), and calf prices are strong (−4).
Each signal names what it rests on: “Sale settlement · 1 Oct”, “Balance sheet · 30 Jun”, “Drought Monitor · 8 Oct”.
- 0747 seconds
“Build the watch-list review” — six agents at work
The agentsRuth presses one button. The agents map 7 parcels to the 8 October map, price 418 calves and the corn against the farm’s $4.38 breakeven, read 14 months of accounts, read the 30 June balance sheet and the wheat claim, and re-project 2026: term debt coverage 0.86x against 1.31x in 2025, on $498,000 of scheduled term payments.
“Watch-list review drafter drafted the review — rating 4 → 6 special mention · 6 actions · talking points for Cody Harms”
- 08Drafted
The review, with repayment capacity and collateral re-done
Watch-list review drafterSummary, repayment capacity, collateral, what weighs against it and a recommendation — every figure linked to its source. Available for term debt falls from $652,400 to $428,280. The herd on the cattle note is down to 428 head, so cattle loan to value rises from 85% to 121%; real estate loan to value is 41%, from 43%. The action plan has six steps with owners and dates, from counting the herd by 23 October to applying future cattle proceeds to the note under the security agreement.
The draft says what it did not check: “Land value from the 2026 appraisal; not re-checked by this review.”
- 09Signed · 140 days before renewal
Ruth moves Voss to special mention
Ruth Engel · Ag Lending ManagerRuth can return the review to Cody or approve. She approves rating 6 and the watch-list addition, and signs: her name and role and the meaning — “Approved as reviewed” — recorded together. The watch list goes from 38 farms to 39, $101.5M, and the committee chaired by Douglas Fenn sees Voss on Tuesday 20 October.
- 10Same week
The book, against its limits and a price shock
Megan Tran · Portfolio risk analystExposure by commodity sits against each concentration limit and drought category: cow-calf has $97M, 49%, in D2 or worse; dryland wheat and row crops $88M, 62%. On the stress test, December corn down another 10% re-projects every farm’s cash flow: 110 farms below 1.0x term debt coverage, 14 more than today, with $61.2M more exposure. The result goes to the Chief Credit Officer.
“Each farm’s own cash flow is re-projected; ratings are not changed.”