Draft: not ready to send. 9 renewal checks are still open: 2 errors and 7 items still needing an answer. 3 broker requests are still open. Each is listed below.
Policy year 2027 · Effective 25 Jan 2027 · Renewal lead Maya Ortiz · Prepared 11 Nov 2026 with Carapace
Figures are copied from the records on file in Carapace. Nothing in this package has been reviewed or approved unless someone says so separately. Each figure's source file is listed in source-index.csv.
Lines renewed: Auto, General liability, Property, Umbrella.
Policy year 2026, the program being renewed.
| Line | Carrier | Policy | Per claim | Annual cap | Retention | Premium |
|---|---|---|---|---|---|---|
| Auto | Sample Casualty | AU-2026-01 | $1,000,000 | None | $10,000 | $168,000 |
| General liability | Sample Casualty | GL-2026-01 | $1,000,000 | $2,000,000 | $10,000 | $118,000 |
| Property | Sample Specialty | PR-2026-01 | $16,500,000 | None | $25,000 | $142,000 |
| Umbrella | Sample Specialty | UM-2026-01 | $10,000,000 | $10,000,000 | $10,000 | $74,000 |
| Total | $502,000 |
Claims at their latest valuation, 01 Nov 2026. Incurred is paid plus reserve.
| Year | Premium | Claims | Open | Incurred | Loss ratio |
|---|---|---|---|---|---|
| 2022 | $350,400 | 3 | 0 | $45,300 | 13% |
| 2023 | $382,900 | 4 | 0 | $42,500 | 11% |
| 2024 | $418,900 | 3 | 0 | $65,500 | 16% |
| 2025 | $458,500 | 3 | 2 | $80,400 | 18% |
| 2026 | $502,000 | 1 | 1 | $14,200 | 3% |
An estimate from the company's own loss history (2022 to 2026), with claim costs grown 5% a year. It is arithmetic on past losses, not an actuarial opinion or a prediction.
| Retention | Premium | Expected retained losses | Expected total | Expected total, with Sample claim-cost estimates |
|---|---|---|---|---|
| $10,000 | $548,000 | $26,895 | $574,895 | $574,895 |
| $25,000 | $521,000 | $48,803 | $569,803 | $572,097 |
| $50,000 | $489,000 | $62,709 | $551,709 | $554,004 |
| $100,000 (lowest) | $471,000 | $63,143 | $534,143 | $537,992 |
12 vehicles on the 2027 schedule, from 2027 vehicle schedule.xlsx. data/vehicles.csv lists each one, and source-index.csv gives the file and row each was read from.
For the broker to decide whether to show; each is from the files in this package.
| About | Finding |
|---|---|
| Whole fleet | Possible credit: the schedule lists safety technology on the fleet: 11 of 12 telematics, 5 a dash camera, 3 collision warning or automatic braking. Ask the broker whether the submission should show it. |
9 open, 1 decided. data/findings.csv lists them all.
| Severity | About | Finding |
|---|---|---|
| Error | Units 109, 111 | Check the VIN on units 109, 111: they share 1CRPCBT10TA000109, and each vehicle has its own. One is probably a copy-paste error. |
| Error | Unit 113 | Check unit 113's VIN (vehicle identification number). The VIN 1CRPCCV12TA000113 fails the check digit: its 9th character does not match what the other 16 add up to, so one of them is wrong. |
| Check | Unit 103 | Sold or missing? Unit 103 (2021 Sample Auto cargo van, VIN 1CRPCCV14MA000103 at North branch, $26,000) was on last year's schedule and is not on this year's. Confirm it was sold, or add it back. |
| Check | Unit 112 | Where is unit 112 kept? It is new this year and it has no garaging location. The garaging location is where the vehicle is usually parked overnight. |
| Check | Whole schedule | Confirm the vehicle count: this year's schedule lists 12 vehicles, 2 more than the 10 on the expiring auto policy (from Vehicle schedule.csv). Listing a vehicle twice also changes the count. |
| Check | Unit 101 | Confirm unit 101's stated value (the amount it is insured for): $48,000 last year (row 2 of last year's schedule), $72,000 now (+50.0%), a change of more than 25%. |
| Check | Unit 106 | Confirm where unit 106 is kept: the schedule gives garaging state CA and plate state NV. |
| Check | Unit 104 | Confirm unit 104's lender: last year (row 5 of last year's schedule) it listed "Sample Auto Credit", this year's schedule lists none. If the loan or lease continues, ask the broker whether the lender should still be named. |
| Check | Unit 107 | Confirm unit 107's safety technology: last year (row 8 of last year's schedule) it listed "Telematics; forward camera; collision warning", this year's schedule lists none. If it is still fitted, list it. |
Decided
| Decision | About | Finding | By | Reason |
|---|---|---|---|---|
| Corrected | Unit 105 | Fill in unit 105's stated value (the amount the vehicle is insured for). This year's schedule gives none that can be read. | Maya Ortiz | Stated value added to the schedule from the fleet list. Answer from Fleet manager. |
| Type | Item | Due | Owner |
|---|---|---|---|
| Checklist | Send exposure data and loss runs to broker | 27 Oct 2026 (past due) | Sam Whitfield |
| Broker request | Updated loss runs (5 years) | 06 Nov 2026 (past due) | Maya Ortiz |
| Broker request | Payroll by class code | 21 Nov 2026 | Priya Nand |
| Broker request | Upload: loss runs | 25 Nov 2026 | Unassigned |
| Checklist | Broker submits to markets | 26 Nov 2026 | Maya Ortiz |
| Checklist | Review quotes and decide | 26 Dec 2026 | Maya Ortiz |
| Checklist | Bind coverage and confirm in writing | 25 Jan 2027 | Maya Ortiz |
18 filed documents. source-index.csv lists 71 figures and the file each came from; 13 have no source file in this package.