- Before
- “I can tell you the average. I can’t tell you who the 23,000 are until tomorrow.” Rebuilds the impact workbook for every scenario.
- Now
- Moves a slider and sees the whole book re-rated, the tail and the people in it; signs a memo whose every count ties to one run.
One rate review, from indication to a signed filing
Harrow Point Mutual’s Texas Homeowners HO-3 program, 2027 rate review: 186,420 policies in force, $585.5M written premium, renewals from 1 Mar 2027, and the filing due Tue 3 Nov. Here is the review, screen by screen, in the working solution.
- 01Monday, 07:42
The whole book, re-rated as indicated
Priya Natarajan · Pricing actuaryPriya opens the Impact screen on rate plan v3. As indicated, the book moves +11.9% — $69.6M a year on $585.5M written. But the histogram shows what the average hides: 23,802 policyholders, 12.8% of the book, above +25%, the largest at +56.6%, and 88,950 Texas 10% notices.
Run log: “Book rerater — re-rated 186,420 policies under rate plan v3 · extract 30 Sep 2026 · 3.1 s”
- 02One click
Click the tail, see the people
Priya Natarajan · Pricing actuaryShe clicks the shaded +25% area and the policyholders open, largest increase first, each with a bar showing which rating factor caused it. Territory leads for 61% of them, roof age for 12%, both for 27%. More than half are in Dallas–Fort Worth north, territory T06.
- 03One policy
Why the Okafors’ premium goes from $3,960 to $6,203
Factor attributorLinda and James Okafor, 4117 Brambleton Dr, Frisco, renew on 14 Mar 2027. The waterfall shows each step: base rate +$40, territory T06 +$980, a 27-year roof +$647, the 1% wind and hail deductible +$225, protection class 9–10 +$351 — +56.6% in all. Beside it, the renewal notice that would be mailed, with the four main reasons in dollars.
“Each step applies one rating factor to the running premium, in rating order, so the steps add up to the proposed premium exactly.”
- 04One slider
Territory at 60% of the indication
Priya Natarajan · Pricing actuaryShe moves the territory slider from 100% to 60%. All 186,420 policies are re-rated again and the bars reshape against the ghost outline of the indicated shape: the tail falls from 23,802 to 9,165, the overall change to +8.6% ($50.6M), Texas notices to 72,907, the largest increase to +44.3%. The balance of the territory change goes into the 2028 review.
- 05By segment
Where the tail lives
Marcus Delgado · Product managerThe heatmap crosses 12 territories with 6 roof-age bands. Even at 60%, Dallas–Fort Worth north with roofs over 25 years averages +30.2%, and Tarrant west and Parker +26.9%. Marcus, who owns the roof eligibility rule and talks to the agents, sees which renewals will draw calls before the agents do.
- 06Capped
A +25% cap, checked against the rate-stability standards
Capping designerA +25% renewal cap catches the remaining 9,165 policies for $1.51M of premium foregone in the first year — 0.26% of written. Year-one overall is +8.4%. Every capped policy reaches its filed premium in 2 renewals, inside the 4-renewal standard. All four checks pass, and the Rule 9 text for the filing is drafted.
“The cap applies to rate changes only — not to changes in coverage, deductible or the property.”
- 07Counted
Every notice, by renewal month
Notice and nonrenewal counterTexas requires notice of a 10%+ renewal increase no later than the 30th day before it takes effect. The counter schedules 72,907 notices across twelve renewal months, first mailing 30 Jan 2027, and 1,231 nonrenewals under the new wood-shake roof rule. Then the tie-out: workbook v7 counted 71,233 notices for the same scenario.
“1,674 policies had a mid-term endorsement after the 31 Aug extract the workbook used; it rated them on the old premium, below the 10% line.”
- 08Resolved
One count goes into the filing
Elena Brooks · Rate filing analystElena uses the run’s count. The notice file and Exhibit 7 now both carry 72,907, and the change — the workbook’s 71,233 replaced by the run’s 72,907 — is recorded on the activity trail.
“Resolved. The notice file and Exhibit 7 use the run’s 72,907. Recorded on the audit trail.”
- 09Drafted
The filing exhibits, from the same run
Exhibit drafterExhibit B rate data — overall indicated +14.6%, first-year impact after Rule 9 +8.4%, written premium change $49,134,420, maximum +25.0%, minimum −17.1% — and Exhibit 7, the distribution of premium changes at first renewal. The tie-out checker confirms every number: maximum and minimum match Exhibit 7, the total matches policies in force, the memo’s notice count matches the notice file.
- 10Approved and signed
Tom approves, Priya signs
Tom Hargrove · Head of personal linesPriya recommends scenario C — territory at 60%, capped at +25% — and requests approval. Tom approves it: +8.4%, 72,907 notices. Priya signs the actuarial memorandum, which locks run v3 and sends the package to Elena to file in SERFF by Tue 3 Nov.
“The memo, Exhibit B, Exhibit 7 and Rule 9 are drafted from run v3 and every count ties. Signing locks the run and sends the package to Elena Brooks for SERFF.”