Appendix C: The Underwriting File Workbook
This is your working binder for the book's progressive project — the Harbor Steel & Fabrication underwriting file. From Chapter 1 you have been adding one analytical layer at a time; these worksheets are where you write each layer down. Photocopy them, retype them into your notes app, or rebuild them in a spreadsheet — but fill them in. An underwriting file is not a feeling about a risk; it is a documented, reconstructable record that a manager can approve, an auditor can examine, and you can defend two years later when the loss arrives. The worksheets here are the skeleton of that record.
A word on the numbers before you start. Every figure in this appendix is a constructed teaching example,
labeled [constructed teaching example] or [the Underwriting File]. The illustrative rates, loads,
credits, and debits are written to show you how a worksheet works, not to tell you what Harbor Steel's
price is. Real loss costs come from your carrier's filed manual, NCCI, or ISO/Verisk; real cat loads come
from the model; real schedule-rating maxima come from the filed plan and the state. When you do the actual
arithmetic, replace the placeholders with your own supportable numbers and show your work — a price you
cannot rebuild is a price you cannot defend.
And one discipline the book has insisted on throughout: do not write the final decision until the file earns it. The last worksheet leaves the disposition blank on purpose. You assemble the evidence; you reach the verdict.
How to use this appendix. Worksheets 1–7 are reusable on any account — bring them to your first day on the desk. Worksheet 8 is the Harbor Steel master summary, keyed to the per-chapter 🗂️ The Underwriting File checkpoints so you can see the whole file on one page as it grows. Work each chapter's checkpoint first, then post the result to Worksheet 8.
C.1 The submission / intake checklist
Use at: Chapters 1, 7, 8, 39. The first question is not "is this a good risk?" but "do I have a real submission, is it mine to write, and is it complete enough to decide?"
Before a single hazard is evaluated, an underwriter clears the submission, confirms it is in appetite, and takes inventory of what is — and is not — in the file. A decision is only as good as the information behind it, and the cheapest, earliest signal of adverse selection is a thin or evasive submission (Ch.39).
SUBMISSION / INTAKE CHECKLIST [reusable worksheet]
Account name / DBA ...................... ____________________________________
Insured's business (in plain words) ..... ____________________________________
Broker / producer ....................... ____________________________________ retail / wholesale? ☐ R ☐ W
Lines requested ......................... ☐ Property ☐ GL ☐ WC ☐ Auto ☐ Umbrella ☐ Other: ______
Effective date / why now ................ ____________________ New ☐ Renewal ☐ Why on the market? ____________
CLEARANCE (is it already with us?) ...... ☐ cleared, no conflict ☐ duplicate/declined before: ____________
IN APPETITE? (vs. guidelines, Ch.7) ..... ☐ target ☐ acceptable ☐ caution/refer ☐ prohibited
Authority check (mine to write?) ........ ☐ within my letter of authority ☐ REFER — reason: ____________
Information inventory — mark R (received), O (ordered, awaited), or M (missing / to request):
| Item | R / O / M | What it tells you (and its limit) |
|---|---|---|
| Completed application / ACORD | ☐ | The insured's representations — a legal record, not verified fact (Ch.4, 8) |
| 5-year loss runs, all lines, valued recently | ☐ | Cause and trajectory of past loss; read for why, not just totals (Ch.8) |
| Statement of values (SOV) | ☐ | Building/contents/BI by location; basis for limits, coinsurance, cat (Ch.19) |
| Inspection / loss-control report | ☐ | A single-day physical snapshot; surfaces hazards the insured stopped noticing (Ch.8) |
| Financial statements | ☐ | Stability, exposure size, moral-hazard signals; severity context (Ch.8) |
| MVRs for all drivers | ☐ | The driving record behind the fleet; "cited," not necessarily "done" (Ch.8, 23) |
| Experience mod worksheet (WC) | ☐ | The X-mod and the claims driving it (Ch.22) |
| Prior carrier / declination reason | ☐ | The story behind the non-renewal — ask directly (Ch.39) |
| Other: ________ | ☐ | ________ |
📋 At the Desk — The intake checklist is not bureaucracy; it is the difference between underwriting the risk and underwriting the broker's description of the risk. Note every M explicitly. Some gaps you can price around; others must become subjectivities (Worksheet 5) or referral reasons. A file that decides a risk while pretending the missing items don't exist is the file that fails the audit.
⚠️ Underwriting Trap — "The broker's a friend; the submission's fine." Friendliness is not completeness. The lazy submission — no loss runs, a one-line description, "just need a quick indication" — is the single most reliable early sign of an account someone else already declined.
C.2 The COPE worksheet (property risk assessment)
Use at: Chapters 9, 19, 30. COPE — Construction, Occupancy, Protection, Exposure — is the standard structured survey for evaluating a property's probability and severity of loss.
COPE is where you turn the inspection and the SOV into a risk grade. Read the four fields together: Occupancy drives loss frequency (the use brings the ignition sources and the process hazards); Construction and Protection drive loss severity (how bad a fire gets once it starts); Exposure captures what the neighbors and the natural environment add — including the catastrophe peril.
COPE WORKSHEET [reusable worksheet]
Location / address ...................... ____________________________________
Total insurable value (TIV) at this loc . $__________ bldg + $__________ contents + $__________ BI
─────────────────────────────────────────────────────────────────────────────────
C — CONSTRUCTION
Construction class (ISO ladder) ...... ☐ frame ☐ joisted masonry ☐ non-combust. ☐ MNC ☐ MFR ☐ fire-resistive
Year built / major updates ........... ______ Roof: type ____________ age ______ (end of life? ☐)
Notable features / deficiencies ...... ____________________________________
O — OCCUPANCY
What they do here (process) .......... ____________________________________
Ignition / hazard sources ............ ☐ hot work/welding ☐ flammables ☐ dust ☐ electrical ☐ other: ____
Housekeeping / process controls ...... ____________________________________
P — PROTECTION
Sprinklers (type, condition, age) .... ____________________________________
Public fire protection class (1–10) .. ______ Nearest hydrant / water supply: ____________
Detection / alarm / private brigade .. ____________________________________
E — EXPOSURE
Neighboring occupancies & proximity .. ____________________________________
CATASTROPHE peril(s) ................. ☐ named wind ☐ storm surge/flood ☐ wildfire ☐ quake ☐ none material
Cat zone / distance to coast ........ ____________________________________
─────────────────────────────────────────────────────────────────────────────────
HPR or non-HPR? ......................... ☐ HPR ☐ non-HPR (which standard fails: ____________)
Loss-control recommendations (→ subjectivities?) 1) __________ 2) __________ 3) __________
RISK GRADE .............................. ☐ above avg ☐ avg ☐ below avg ☐ decline conditioned on terms? ☐
Worked illustration of the format (Construction/Protection fields only) so you can see what a filled line looks like:
FIGURE C.1 — "Reading the COPE on a fab shop" [the Underwriting File]
C joisted-masonry / metal frame; built 1994; ORIGINAL built-up roof ~30 yrs (end of life) — a severity
and a wind/water driver, not a frequency driver.
P ORIGINAL wet-pipe sprinklers; public fire protection class 4; hydrant ~600 ft — adequate, not superior.
→ Read together: the building is sound but not highly protected (non-HPR), and the aged roof is the
component most likely to fail under the named-storm peril you found in E.
🗂️ The Underwriting File — Harbor Steel's COPE is the heart of the property assessment (Ch.9, 19). The two fires live in O (occupancy/process: electrical in 2021, hot-work in 2023), the roof lives in C and reappears in E under named wind, and the non-HPR status falls out of P. Notice how one worksheet ties the loss history to the physical risk: the loss run is telling a story about management and process, and COPE is where you decide which parts of that story your controls can change.
C.3 The loss-run analysis worksheet (frequency · severity · trend)
Use at: Chapters 8, 10, 22. You pull the loss runs and you read them before you read the application. The question is whether the past predicts the future — and how much of this account's own experience you should trust.
A loss run is read for cause and trajectory, not for the dollar total at the bottom. List each claim, then step back and ask the three analytic questions: How often (frequency)? How big (severity)? And is it getting better or worse, once you account for inflation and for claims that aren't fully developed (trend & development)?
LOSS-RUN ANALYSIS [reusable worksheet]
Account ____________________ Period covered: ____ yrs Valued as of: __________ Lines: ____________
Claim register (one row per claim):
┌──────┬──────┬───────────────────────┬──────────┬──────────┬────────┬───────────────────────┐
│ Year │ Line │ Cause of loss │ Paid │ Reserve │ O/C │ Note (root cause?) │
├──────┼──────┼───────────────────────┼──────────┼──────────┼────────┼───────────────────────┤
│ ____ │ ____ │ _____________________ │ $_______ │ $_______ │ ☐ O ☐ C│ _____________________ │
│ ____ │ ____ │ _____________________ │ $_______ │ $_______ │ ☐ O ☐ C│ _____________________ │
│ ____ │ ____ │ _____________________ │ $_______ │ $_______ │ ☐ O ☐ C│ _____________________ │
│ ____ │ ____ │ _____________________ │ $_______ │ $_______ │ ☐ O ☐ C│ _____________________ │
└──────┴──────┴───────────────────────┴──────────┴──────────┴────────┴───────────────────────┘
─────────────────────────────────────────────────────────────────────────────────
FREQUENCY total claims ______ ÷ ______ yrs = ______ claims/yr (per exposure unit: ______)
SEVERITY total incurred (paid+reserve) $__________ ÷ ______ claims = $__________ average
largest single loss $__________ ← severity is decided by the MAX, not the average
TREND are recent years worse/better? ____________ open reserves likely to develop? ☐ up ☐ stable
PATTERN same cause repeating? ____________ pre-/post-management change? ____________
─────────────────────────────────────────────────────────────────────────────────
CREDIBILITY of THIS account's experience (Ch.10)
Enough claims to stand alone (full credibility)? ........ ☐ yes ☐ no → partial
Credibility weight Z (0–1), with rationale ............. Z = ______ because ____________________
Blended view = Z × (own indicated) + (1−Z) × (class) ... ____________________________________
SIGNAL vs. NOISE — in one sentence: ____________________________________________________________
A note on credibility you should write in your own words on the worksheet: a handful of claims over five years is usually partially credible at best. The classical square-root rule expresses partial credibility as $Z = \sqrt{n/N}$, where $n$ is the claims you have and $N$ is the full-credibility standard — but the number is less important than the habit. Do not let one bad year (or one quiet year) speak louder than it can. Weight this risk's own experience against the class, and say plainly which losses look like a repeating, controllable pattern and which look like random draws.
🤖 Model vs. Judgment — A scoring model sees "two fires in five years" and reaches for a decline. The loss-run worksheet sees what the model cannot: that the 2021 fire was electrical and the 2023 fire was hot-work, that they may straddle a change in management or process, and that the corrective actions may or may not have taken. Same data, different read — because you asked why and the model only counted.
🗂️ The Underwriting File — For Harbor Steel, this worksheet is where "2 fires in 5 years," the several WC claims, the two minor auto claims, and the one pending products claim stop being a list and become a diagnosis: a hot-work/process frequency signal that controls can address, an aged-roof severity exposure the cat peril will eventually find, and a products claim you flag as the long-tail watch-item (Ch.10, 21, 22).
C.4 The pricing worksheet (pure premium → loads → schedule credits/debits → indicated premium)
Use at: Chapters 10, 11, 19, 22. Price is built, not guessed. You start from the expected loss, add the loads that keep the carrier solvent, then adjust for what makes this risk different.
The build-up is the same in every line: start with the pure premium (the expected loss per exposure unit — frequency × severity, or total losses ÷ exposures), add an expense load and a profit & contingency load to reach an indicated manual rate, then move that rate for the individual risk through experience rating (its own losses) and schedule rating (documented credits and debits for what the class rate misses). Rate adequacy is the discipline that makes the whole exercise honest: the price must cover the risk accepted even when the soft market and the broker are pushing the other way.
PREMIUM BUILD-UP ($ per exposure unit) [constructed teaching example]
pure premium (expected loss) ████████████████ $4.00
+ expense load (~30%) ███████ $1.85
+ profit & contingency (~5%) ██ $0.40
──────────────────────────────────────────────
= indicated MANUAL rate $6.25 (before risk-specific adjustment)
Now fill the worksheet for one coverage part at a time (do property, then GL, WC, auto separately, then sum):
PRICING WORKSHEET — coverage part: ____________ [reusable worksheet]
Exposure base & amount .............. ____________ × ________ units (e.g., per $1,000 TIV; per $100 payroll)
(1) Pure premium / loss cost ........ $________ per unit source: ☐ manual ☐ bureau (ISO/NCCI) ☐ own data
(2) + Expense load .................. ____ % → $________
(3) + Profit & contingency load ..... ____ % → $________
(4) = Indicated MANUAL rate ......... $________ per unit
(5) × Rating factors / relativities . ____________________ (×____ ×____ ×____) = combined ×________
(6) Experience modification (if any) X-mod / exp-rating factor = ________ (debit >1.00 / credit <1.00)
─────────────────────────────────────────────────────────────────────────────────
(7) SCHEDULE RATING — documented credits (−) and debits (+):
Management / financial ........ ____ % reason: ____________________
Premises / protection ......... ____ % reason: ____________________
Equipment / process controls .. ____ % reason: ____________________
Loss-control program / cooperation ____ % reason: ____________________
Location / cat exposure ....... ____ % reason: ____________________
── net schedule mod (within filed ±____% cap) = ________ %
(8) Risk-adjusted rate = (4)×(5)×(6)×(1+sched) = $________ per unit
(9) PREMIUM this part = (8) × exposure amount = $____________
─────────────────────────────────────────────────────────────────────────────────
ADEQUACY CHECK
Implied loss ratio at this price .. ________ % vs. target ________ %
Would I write this price in a HARD market? ☐ yes In a SOFT market with pushback? ☐ still yes
What I will NOT give back to win it: ____________________________________
📋 At the Desk — Two rules keep this worksheet honest. First, every schedule credit and debit needs a written reason tied to something in the COPE or loss-run worksheet — "−5% for the hot-work permit program," not "−5% to hit the broker's number." Schedule rating exists to capture what the class rate misses, not to launder a price cut. Second, the filed plan and the state cap how far the schedule mod can swing; stay inside it, and document that you did.
⚠️ Underwriting Trap — The soft-market giveaway. The losses from an inadequate rate don't show up this quarter; they show up in two or three years, after the growth has been celebrated and the underwriter has moved on. Line (8) is where the combined ratio is won or lost. If you can't defend the price at line (8) against the implied loss ratio, the answer to the broker is no — or a modify, not a discount.
🗂️ The Underwriting File — For Harbor Steel's property part, expect debits for the aged roof, the named-storm exposure, and the fire history, partly offset by credits for the controls you require as subjectivities (Ch.11). The WC part runs through the X-mod with a return-to-work credit (Ch.22). Build each part on its own worksheet, then total them — and keep the cat load (Worksheet 6 / Ch.30) visible, because it is a real cost of this account even though it isn't a "loss" in any given year.
C.5 The terms-and-conditions checklist (deductibles · limits · sublimits · subjectivities)
Use at: Chapters 12, 13, 19. Price is only half the deal. Structure is how you make a marginal risk acceptable and align the insured's incentives with yours.
When the bare price won't do it, the underwriter reaches for structure: a higher or percentage deductible to shed small and catastrophe losses, limits and sublimits to cap exposure to particular perils, a coinsurance/agreed-value decision on valuation, restricting or broadening endorsements, and subjectivities — the conditions that must be met before coverage binds. A binder grants exactly the terms it states, so anything you intend to require must appear on it.
TERMS & CONDITIONS CHECKLIST [reusable worksheet]
DEDUCTIBLES / RETENTIONS
All-other-perils (AOP) deductible ... $____________ per: ☐ occurrence ☐ claim
CAT / named-windstorm deductible .... ______ % of value (percentage cat deductible? ☐)
Self-insured retention (SIR) / large ded? ☐ n/a ☐ $__________ collateral: ____________
LIMITS
Per-occurrence limit(s) by line ..... ____________________________________
Aggregate limit(s) .................. ____________________ (could multiple losses exhaust it? ☐)
Umbrella / excess limit ............. $__________ over underlying: ____________
SUBLIMITS (a cap INSIDE the limit)
Flood / surge ....................... $__________ Transit / inland marine ... $__________
Equipment breakdown ................. $__________ Cyber (if added) .......... $__________
Other: ____________________________ $__________
VALUATION
Building basis ...................... ☐ replacement cost ☐ agreed value ☐ ACV ☐ roof on ACV/schedule
Coinsurance % (or agreed value suspends it?) ______ % ☐ agreed value
Business income: period of indemnity / waiting period ____________________
ENDORSEMENTS that restrict or broaden .... ____________________________________
─────────────────────────────────────────────────────────────────────────────────
SUBJECTIVITIES (conditions precedent — each needs an OWNER, a DEADLINE, a STATUS)
┌────────────────────────────────────────────┬──────────────┬──────────┬───────────┐
│ Condition required before/at bind │ Owner │ Deadline │ Status │
├────────────────────────────────────────────┼──────────────┼──────────┼───────────┤
│ ________________________________________ │ ____________ │ ________ │ ☐ open │
│ ________________________________________ │ ____________ │ ________ │ ☐ open │
│ ________________________________________ │ ____________ │ ________ │ ☐ open │
└────────────────────────────────────────────┴──────────────┴──────────┴───────────┘
Is every subjectivity reflected on the BINDER/quote letter? ☐ yes (if not, the broader coverage is granted)
⚠️ Underwriting Trap — The subjectivity that never gets tracked. A condition you require but don't track to closure is a condition you didn't require. Every subjectivity needs an owner, a deadline, and a status, and the file needs to show whether it was met before the policy issued. "I assumed the broker handled it" is not a defense at the claim.
🗂️ The Underwriting File — Harbor Steel is the textbook case for structuring a marginal risk into an acceptable one (Ch.12, 19): a percentage named-windstorm deductible, an ACV/roof endorsement until a warranted replacement, an agreed-value basis with the right coinsurance, sensible sublimits, and a short list of subjectivities (roof-replacement warranty, hot-work permit program, sprinkler certification, IR scan of the electrical panel). Fill the subjectivity table now; you will reconcile it against what the broker actually delivers in Ch.39.
C.6 The reinsurance and portfolio-fit check
Use at: Chapters 27, 28, 29, 30. A risk that is sound on its own can still be wrong for the book. Before you bind, ask what the account does to your net retention, your capital, your concentrations, and your catastrophe aggregate.
No carrier holds all of its risk, and no account is underwritten in isolation. This worksheet steps outside the single file to the portfolio: what reinsurance does to your net vs. gross position, how much capital and cat-charge the account consumes, and whether it deepens a concentration you should be managing down. Diversification reduces volatility without lowering any single risk's expected loss; the job here is to make sure this risk isn't one more correlated bet on the same storm.
REINSURANCE & PORTFOLIO-FIT CHECK [reusable worksheet]
REINSURANCE
Gross line we'd put up .............. $__________
Treaty applies? ..................... ☐ quota share ☐ surplus share ☐ XOL ☐ cat XOL retention: $________
Net line we actually keep ........... $__________ within our per-risk retention? ☐ yes ☐ no → fac?
Facultative needed? ................. ☐ no ☐ yes, for $________ excess of $________
CAPITAL / COST OF RISK
Capital / cat-charge this account ties up $__________ (approx.)
Does the indicated price earn its cost of capital? ☐ yes ☐ marginal ☐ no
PORTFOLIO FIT (concentration & accumulation)
Geographic / peril-zone concentration ☐ adds to a crowded cat zone ☐ room in the aggregate
Industry / class concentration ...... ____________________________________
Distribution concentration (broker) . ____________________________________
Marginal contribution to zone PML ... $__________ within zone aggregate? ☐ yes ☐ no
VERDICT ON FIT .......................... ☐ fits appetite ☐ fits ONLY IF cat-aggregate has room ☐ does not fit
⚖️ Compliance Corner — Accumulation management is not optional good manners; it is part of how a carrier demonstrates solvency to its regulator and its rating agency (RBC, ORSA, AM Best — Ch.28). An account can be perfectly priced on its own and still be a governance problem if it pushes a peril zone past the aggregate the company has told its board and its reinsurers it would hold. Read fit at the book level, then document it.
🗂️ The Underwriting File — Harbor Steel's coastal property is exactly where this worksheet bites (Ch.27, 29, 30): the named-storm exposure is ceded to the cat XOL treaty, the net line needs to sit within your per-risk retention (is facultative needed for the \$20M line?), and the portfolio question is whether Port Hadley's accumulation still has room. The honest running disposition the book reaches is "fits appetite — if the cat aggregate has room." Make that conditional explicit on your worksheet, because it is the kind of condition that protects the whole book, not just this file.
C.7 The coverage-recommendation memo (the decision skeleton)
Use at: Chapters 13, 40. The memo is the verdict page of the file — the decision, the price, the terms, the subjectivities, and the residual risks, in your own words, stated at their true strength.
Everything in Worksheets 1–6 exists to support this one page. The coverage-recommendation memo is what a manager approves, an auditor examines, and you defend to the broker. Three rules: state the decision at its real strength (a modify is a modify, not a soft yes); name the residual risks (a memo with no residual-risk line is a sales document, not an underwriting memo); and write it so a reader who never met you can reconstruct why.
COVERAGE RECOMMENDATION MEMO [decision skeleton]
To: ____________ (manager / committee) From: ____________ (underwriter) Date: __________
Account: ____________________ Broker: ____________ Lines: ____________ Effective: __________
1. THE RECOMMENDATION (one line)
☐ Accept ☐ Decline ☐ MODIFY (quote with conditions)
In one sentence: ____________________________________________________________
2. THE RISK IN BRIEF (what we're insuring, and the 2–3 things that decide it)
____________________________________________________________________________
3. THE PRICE & RATIONALE (from Worksheet C.4 — indicated premium and the key debits/credits)
Total indicated premium $____________ Key adjustments: ____________________
Why this price is ADEQUATE for the risk: ____________________________________
4. THE TERMS (from Worksheet C.5 — deductibles, limits, sublimits, valuation, endorsements)
____________________________________________________________________________
5. THE SUBJECTIVITIES (conditions precedent — owner, deadline, status)
____________________________________________________________________________
6. REINSURANCE / PORTFOLIO SIGN-OFF (from Worksheet C.6 — net line, cat fit, capital)
____________________________________________________________________________
7. RESIDUAL RISKS & WHAT WOULD CHANGE MY MIND (state them plainly — do NOT omit)
____________________________________________________________________________
8. AUTHORITY / REFERRAL (within my authority? peer review? referral to: ____________)
____________________________________________________________________________
9. DECISION OF RECORD ........................ ____________________ (signed/dated)
📋 At the Desk — Write section 7 first. If you cannot articulate the residual risks and the conditions under which you'd change your mind, you do not yet understand the account well enough to commit the carrier's capital to it. The strongest files are not the ones with no uncertainties; they are the ones that name their uncertainties and price and structure around them.
🗂️ The Underwriting File — At Ch.13 your memo records a modify: a quote with subjectivities, referred upward because the account exceeds the line underwriter's authority. The capstone (Ch.40) rebuilds this same memo as the top page of the complete assembled file. The skeleton is identical; only the depth of evidence behind each line changes.
C.8 Harbor Steel master-summary template
Use throughout. This is the one-page picture of the whole file, keyed to the per-chapter 🗂️ The Underwriting File checkpoints. After you work each chapter's checkpoint, post the result here. By the capstone, this page is your file's table of contents.
Account header (frozen facts — [the Underwriting File]; all figures constructed for teaching):
HARBOR STEEL & FABRICATION, INC. — MASTER SUMMARY [the Underwriting File]
Insured ....... Harbor Steel & Fabrication, Inc. ("Harbor Steel"), custom metal fab / structural steel
Location ...... Port Hadley (Gulf Coast, hurricane-exposed county; state unspecified)
Premises ...... one 50,000 sq ft plant, built 1994 (joisted-masonry/metal frame)
Size .......... ~180 employees; ~$45M revenue; ~$11M payroll
Broker ........ Meridian Risk Partners Status: NEW business (expiring carrier non-renewing: cat + losses)
Carrier ....... your mid-size regional carrier
Program ....... Property ($20M bldg / $8M equip / $10M BI) · GL (incl. products) · WC (~$11M payroll)
· Commercial Auto (12-unit flatbed/delivery fleet) · $10M Umbrella
Key facts ..... original built-up roof (~30 yrs, end of life); original wet-pipe sprinklers; fire prot.
class 4; named-windstorm + surge exposed; NOT HPR
Losses (5 yr).. 2021 electrical fire ~$180K; 2023 hot-work/welding fire ~$1.2M; several WC claims;
two minor auto claims; one pending products-liability claim (alleged failed bracket)
File-build tracker — record what each checkpoint settles (and what it leaves open). The right-hand column is for your one-line note; do not just copy the prompt. (Chapters marked aside advance a teaching contrast rather than the core file — note them briefly.)
| Ch | Layer this checkpoint adds | Your note: what it settles / what's still open |
|---|---|---|
| 1 | The account arrives; open the file | __________ |
| 2 | (aside) how it'd be placed at Lloyd's / early fire insurance | __________ |
| 3 | Where it fits the market; carrier type; combined-ratio stakes | __________ |
| 4 | Legal frame: utmost good faith; representations; admitted vs. surplus-lines | __________ |
| 5 | The policy that covers it: DICE per line; which ISO forms | __________ |
| 6 | Exposure & hazard inventory across all lines | __________ |
| 7 | Run the process: in appetite? whose authority? referral? | __________ |
| 8 | Order the information; flag the gaps (→ Worksheet C.1) | __________ |
| 9 | COPE + loss-control read of the two fires (→ Worksheet C.2) | __________ |
| 10 | The math: frequency/severity/credibility of the losses (→ Worksheet C.3) | __________ |
| 11 | Price it: build-up + experience + schedule rating (→ Worksheet C.4) | __________ |
| 12 | Structure terms: deductibles, BI period, roof endt, sublimits (→ Worksheet C.5) | __________ |
| 13 | The decision: modify — quote with subjectivities; refer up (→ Worksheet C.7) | __________ |
| 14 | (aside) owner's personal auto/umbrella; personal vs. commercial rating | __________ |
| 15 | (aside) owner's coastal home — the cat problem in miniature | __________ |
| 16 | The \$10M umbrella's underlying-limit requirements | __________ |
| 17 | (aside) key-person/buy-sell life; David Okafor classification contrast | __________ |
| 18 | (aside) group health / self-funded stop-loss adjacency | __________ |
| 19 | Property deep-dive: valuation, BI + period of indemnity, equipment breakdown | __________ |
| 20 | (aside) why it's a package, not a BOP/STP risk | __________ |
| 21 | GL: the products exposure (pending bracket claim); occurrence trigger; AIs | __________ |
| 22 | WC: the X-mod, governing class, premium-audit exposure, RTW credit | __________ |
| 23 | Commercial auto: fleet, MVRs (one poor record), nuclear-verdict, telematics | __________ |
| 24 | Cyber/E&O? a modest cyber add-on recommended | __________ |
| 25 | (aside) performance/payment bonds if it bids public work — surety is credit | __________ |
| 26 | The inland-marine piece (steel in transit, contractors' equipment) | __________ |
| 27 | Reinsurance: cat XOL cession; net vs. gross; fac for the \$20M line? (→ Worksheet C.6) | __________ |
| 28 | Capital: cat-charge consumed; does it earn its cost of capital? | __________ |
| 29 | Portfolio fit: coastal / industry / broker concentration (→ Worksheet C.6) | __________ |
| 30 | Cat modeling: PML/AAL contribution; return-period loss; Port Hadley accumulation | __________ |
| 31 | Data-driven: pre-fill; satellite roof imagery corroborates the read; real-time score | __________ |
| 32 | The model scored it 7/10; the underwriter overrides to a 6 — log the reasons | __________ |
| 33 | Disclosure check: the application understated the 2023 fire's cause; SIU review (no rescission issue) | __________ |
| 34 | (aside) could a digital MGA quote it faster? a parametric wind supplement | __________ |
| 35 | Ethics: is the pricing fair (no protected-class proxy)? the protection-gap angle | __________ |
| 36 | The future: continuous/IoT + climate repricing for Harbor Steel in 2035 | __________ |
| 37 | (aside) which underwriter writes this; the authority needed | __________ |
| 38 | Leadership: exceeds authority → referral, peer review, audit trail, CUO appetite call | __________ |
| 39 | Broker negotiation: roof contract + hot-work program delivered; renewal strategy | __________ |
| 40 | Capstone assembly: the complete file + the recommendation memo | __________ |
The final disposition — for you to reach. The whole point of the project is that you render the verdict from the evidence you assembled, not that the book renders it for you. Complete this block only after the file supports every line of it:
FINAL DISPOSITION (complete at the capstone — Ch.40) [the Underwriting File]
Decision ........... ☐ Accept ☐ Decline ☐ Modify / quote-with-conditions → __________________
Indicated premium .. $____________ (total program; from your Worksheet C.4 parts, summed)
Key terms .......... ____________________________________________________________
Subjectivities ..... ____________________________________________________________
Reinsurance/portfolio sign-off .... ____________________________________________
Residual risks ..... ____________________________________________________________
How I would DEFEND this in a review or an interview (3 sentences):
____________________________________________________________________________
____________________________________________________________________________
🗂️ The Underwriting File — Resist the urge to fill in the disposition early. The book builds toward it deliberately, one chapter at a time, and an underwriter who has decided the answer before doing the work is exactly the underwriter this book exists to un-train. When you finally complete the block above, the test is simple and it is the same test your manager will apply: can you defend every line of it from the file behind it? If yes, you have done the job. If not, the file isn't finished — and that, too, is a finding worth writing down.
A closing note on using these worksheets
The worksheets are a scaffold, not a substitute for judgment. They make sure you gather the right information, show your arithmetic, name your assumptions, and track your conditions — the four habits that turn an opinion into a defensible decision. But the decision itself, the override of the model when the loss runs are quietly telling you something the score can't see, the courage to hold an adequate price against a broker you like — that is the craft, and no worksheet writes it for you. Fill these in by hand the first dozen times. After that, the structure lives in your head, and the file you build will read like the work of someone who knows exactly what they're doing — because you will.