Why Geographic Accumulation Mapping Matters
A portfolio can have a manageable total insured value and still be vulnerable to a severe event concentrated in one area. Geographic accumulation mapping makes that concentration visible: it assigns insured locations to defined zones, aggregates their exposures, and connects those aggregates to modeled event losses. A zone view is useful only when the geographic boundaries, exposure measure, loss basis, and valuation date are clear.
Zones may be based on a standardized geographic classification such as CRESTA regions or on another defined regional scheme. A zone is a grouping for exposure measurement; it is not itself a catastrophe model or a statement that all locations within it will experience identical damage. The map provides the grouping, while the model estimates losses under specified assumptions.
The terms must be kept distinct. Insured value measures the covered value at risk under a stated valuation convention; it is not the amount expected to be lost. A modeled loss is an estimate for a defined model output, such as a scenario event, and may reflect vulnerability, policy terms, and other stated assumptions. A limit can be expressed in insured value or in modeled loss, but its measured quantity must match the quantity being compared with it.
Building a Reliable Zone View
Start with a location-level exposure file that has a stable location identifier, coordinates or an address suitable for geocoding, insured value, peril scope, and the relevant policy terms. Assign each in-scope location to exactly one zone under the selected geographic definition. Then aggregate values by zone, using a consistent date, currency, valuation basis, and gross-or-net view. For modeled losses, use outputs for the same event definition and peril across the locations being aggregated.
Specify the valuation date, insured-value measure, peril, event or model output, and whether losses are gross or net of the relevant risk transfer.
Use the chosen zone boundaries and a consistent geocoding rule. Resolve missing or ambiguous locations rather than silently dropping them.
Sum each location once, compare zone totals with the portfolio total, and investigate any difference.
Calculate shares and utilization using the correct denominator and the same measure as the applicable zone limit.
If \(I_{iz}\) equals 1 when location \(i\) is assigned to zone \(z\), and 0 otherwise, then the zone insured value is \(V_z=\sum_i I_{iz}V_i\), where \(V_i\) is the selected insured value at location \(i\). For a modeled event with location losses \(L_i\), the corresponding zone loss is \(L_z=\sum_i I_{iz}L_i\). When every in-scope location belongs to exactly one zone, the zone totals reconcile to the portfolio totals.
These aggregation identities follow because the zone assignment indicators sum to 1 for each in-scope location. For example, \(\sum_z V_z=\sum_z\sum_i I_{iz}V_i=\sum_i V_i\sum_z I_{iz}=\sum_i V_i\). The same argument applies to losses. The identity is an important data check; it does not establish that the modeled losses are accurate.
Worked Example: Comparing Exposure and Loss Concentration
A hypothetical insurer maps six property locations to three zones. Values and modeled gross losses for one specified event are in millions of dollars. Determine each zone’s total insured value and event loss, each zone’s share of the portfolio totals, and the zone event-loss ratio.
| Location | Zone | Insured value ($m) | Modeled event loss ($m) |
|---|---|---|---|
| A | North | 18 | 2.7 |
| B | North | 12 | 1.8 |
| C | Central | 25 | 5.0 |
| D | Central | 15 | 3.0 |
| E | Coast | 10 | 4.0 |
| F | Coast | 20 | 8.0 |
Method. Sum location values and event losses within each assigned zone, then divide by the corresponding portfolio total to obtain shares.
North. Insured value is \(18+12=30\) million, and event loss is \(2.7+1.8=4.5\) million. Its insured-value share is \(30/100=30\%\); its event-loss share is \(4.5/24=18.75\%\). Its event-loss ratio is \(4.5/30=15\%\).
Central. Insured value is \(25+15=40\) million, and event loss is \(5+3=8\) million. Its insured-value share is \(40/100=40\%\); its event-loss share is \(8/24=33.33\%\), rounded to two decimal places. Its event-loss ratio is \(8/40=20\%\).
Coast. Insured value is \(10+20=30\) million, and event loss is \(4+8=12\) million. Its insured-value share is \(30/100=30\%\); its event-loss share is \(12/24=50\%\). Its event-loss ratio is \(12/30=40\%\).
Check. Zone insured values sum to \(30+40+30=100\) million, and zone event losses sum to \(4.5+8+12=24\) million. Coast has 30% of the insured value but 50% of this event loss, a signal to examine the event and the exposures in that zone. It is not, by itself, a claim about the zone’s annual expected loss or the probability of an event.
Common mistake avoided: using the wrong denominator for a concentration share. Coast’s event-loss share is \(12/24=50\%\), not \(12/100=12\%\); the latter divides a loss by an insured-value total and does not represent either defined share.
Zone Limits and Utilization
A zone-level accumulation limit is a stated cap on an identified measure for a defined zone and scope. For example, a limit may cap total insured value in a zone, or it may cap modeled loss for a specified event or loss metric. A utilization ratio is the measured accumulation divided by its matching limit. Headroom is the limit less the measured accumulation; a negative result indicates an excess.
A loss-based capacity can sometimes be converted to an insured-value limit. Suppose a planning assumption is that modeled loss in zone \(z\) is proportional to insured value, \(L_z=r_zV_z\), with a fixed loss factor \(r_z\) for the applicable scope. If the permitted modeled loss is \(C_z\), then the corresponding exposure cap is \(V_z=C_z/r_z\). This is an algebraic conversion, not a general catastrophe-model law. It may be unsuitable when losses vary nonlinearly with exposure, policy terms, event footprints, or the portfolio mix.
Worked Example: Converting a Zone Loss Capacity to an Exposure Limit
A hypothetical portfolio has zone insured values of 30 million dollars in North, 40 million in Central, and 30 million on the Coast. For a specified planning event, the assumed zone loss factors are 15%, 20%, and 40%, respectively. Each zone has a modeled-loss capacity of 7 million dollars. Calculate the implied insured-value limit and current utilization for each zone, then identify any excess. Assume the loss factors are fixed and proportional over the range being assessed.
Method. For each zone, divide the 7 million dollar loss capacity by its loss factor to obtain the implied exposure limit. Compare current insured value with that limit.
North. The exposure limit is \(7/0.15=46.6667\) million dollars. Current modeled loss is \(30(0.15)=4.5\) million dollars. Utilization is \(4.5/7=64.29\%\), rounded to two decimal places. Exposure headroom is \(46.6667-30=16.6667\) million dollars.
Central. The exposure limit is \(7/0.20=35\) million dollars. Current modeled loss is \(40(0.20)=8\) million dollars. Utilization is \(8/7=114.29\%\), rounded to two decimal places. The zone exceeds the loss capacity by \(8-7=1\) million dollars, equivalent under the stated assumption to \(40-35=5\) million dollars of exposure.
Coast. The exposure limit is \(7/0.40=17.5\) million dollars. Current modeled loss is \(30(0.40)=12\) million dollars. Utilization is \(12/7=171.43\%\), rounded to two decimal places. The loss excess is \(12-7=5\) million dollars; the implied exposure excess is \(30-17.5=12.5\) million dollars.
Check. Multiplying each implied exposure limit by its loss factor returns the 7 million dollar capacity: \(46.6667(0.15)\approx7\), \(35(0.20)=7\), and \(17.5(0.40)=7\). The approximation in North reflects displaying the exposure limit to four decimal places.
Common mistake avoided: multiplying the loss capacity by the loss factor. For Central that would give \(7(0.20)=1.4\) million dollars, which is not an exposure limit. The correct rearrangement of \(7=0.20V_z\) is \(V_z=7/0.20=35\) million dollars.
Mapping Decisions and Model Boundaries
Geographic assignment is a substantive modeling input. A coordinate error, outdated address, inconsistent boundary version, or unresolved location can put value in the wrong zone. A sound process records the zone definition and mapping date, flags low-quality geocodes, and reconciles assigned and unassigned values. If a location lies near a boundary, apply the stated geographic rule consistently; do not split or move its exposure merely to make a limit appear satisfied.
A zone total also hides variation within the zone. Two portfolios with the same zone insured value may have different building characteristics, policy terms, event footprints, and modeled losses. Accordingly, an exposure-based limit is a useful accumulation control but cannot substitute for the loss view. Conversely, a modeled event loss is conditional on the selected event and modeling assumptions; it is not automatically a complete measure of all risk in that zone.
Gross and net measures should not be mixed. If the chosen limit applies to gross modeled losses, compare it with gross losses. If the limit is defined on a net basis, apply the relevant risk-transfer treatment consistently before comparing. Also make sure all locations use the same currency and valuation date. A difference in any of these conventions can look like a geographic concentration change when it is actually a measurement-basis change.
Exam trap: denominator and rounding. Utilization is measured accumulation divided by its limit, not the reverse. If a zone has 35 million dollars of exposure against a 32 million dollar exposure limit, utilization is \(35/32=109.375\%\), reported as 109.38% when rounding to two decimal places. The excess is 3 million dollars, not 9.375 million dollars; the latter is a percentage-point comparison incorrectly treated as a dollar amount.
Worked Example: Applying the Mapping Rule Before Testing a Limit
A hypothetical zone view has North insured value of 30 million dollars and modeled event loss of 4.5 million dollars; Central has 40 million and 8 million; Coast has 30 million and 12 million. A newly underwritten location has 8 million dollars of insured value and a modeled loss of 1.6 million dollars for the same event. Its verified coordinates place it in Central under the chosen zone definition. Central has an exposure limit of 45 million dollars and a modeled-loss capacity of 9 million dollars. Update the Central totals and test both limits.
Method. Assign the new location once to its verified zone, add its insured value and event loss to that zone, and compare each updated measure with its matching limit.
Updated Central view. Insured value is \(40+8=48\) million dollars. Modeled event loss is \(8+1.6=9.6\) million dollars. The updated portfolio insured value is \(30+48+30=108\) million dollars, and total modeled event loss is \(4.5+9.6+12=26.1\) million dollars.
Exposure-limit test. Utilization is \(48/45=106.67\%\), rounded to two decimal places. Exposure exceeds the limit by \(48-45=3\) million dollars.
Loss-capacity test. Utilization is \(9.6/9=106.67\%\), rounded to two decimal places. Modeled loss exceeds the capacity by \(9.6-9=0.6\) million dollars.
Check. The updated zone totals reconcile: \(30+48+30=108\) million dollars of insured value and \(4.5+9.6+12=26.1\) million dollars of event loss. The new location is included once, in Central, rather than assigned to both neighboring zones.
Common mistake avoided: assigning a boundary location to a zone based on whichever assignment avoids a breach. The verified mapping rule determines the zone first; the limit comparison follows from that assignment.
Check Your Understanding
Work through each problem using the stated zone and measurement basis.
- A hypothetical portfolio has two locations in Zone A with insured values of 14 and 6 million dollars and modeled event losses of 2 and 1 million dollars. Zone B has two locations with insured values of 20 and 10 million dollars and losses of 4 and 1 million dollars. Find each zone’s insured value and loss, plus its share of total insured value and total loss. (Answer: Zone A: $20m insured value, $3m loss, 40.00% of insured value and 37.50% of loss; Zone B: $30m, $5m, 60.00% and 62.50%; portfolio totals: $50m and $8m.)
- A zone has a modeled-loss capacity of 6 million dollars. Under a stated proportional planning assumption, its loss factor is 25% and current insured value is 21 million dollars. Find the implied exposure limit and exposure headroom. (Answer: $24m exposure limit and $3m headroom.)
- A zone contains 32 million dollars of insured value against a 40 million dollar exposure limit. Calculate utilization and headroom. (Answer: 80.00% utilization and $8m headroom.)
- Zone West contains two locations with insured values of 12 and 8 million dollars and modeled losses of 1.2 and 0.8 million dollars. Zone East contains one location with insured value of 15 million dollars and modeled loss of 4.5 million dollars. Find zone totals, portfolio totals, and each zone’s share of total modeled loss. (Answer: West: $20m insured value and $2m loss, or 30.77% of portfolio loss; East: $15m and $4.5m, or 69.23%; portfolio totals: $35m and $6.5m.)
- Zones X and Y each have a modeled-loss capacity of 5.4 million dollars. Under fixed proportional loss factors of 18% for X and 30% for Y, current insured values are 26 million dollars in X and 16 million dollars in Y. Calculate each implied exposure limit and exposure utilization, and state whether either limit is exceeded. (Answer: X limit $30m, utilization 86.67%, no breach; Y limit $18m, utilization 88.89%, no breach.)