From Narrative to Quantitative Schedule
A scenario often begins as a sentence rather than a model input: “growth is faster than expected,” “claims are more severe,” or “collections are delayed.” Each phrase can refer to different quantities and dates. Before calculating a capital impact, specify what changes, how much it changes, when it takes effect, and which financial measure receives the change.
This tutorial focuses on that translation. It takes the scenario description as given; it does not assess how severe or plausible the scenario is. The objective is a traceable set of timed inputs that can be reviewed, challenged, and used consistently in later calculations.
Words such as “increase,” “delay,” and “deteriorate” are not yet model inputs. For example, “claims increase” could mean more claims, a larger average payment per claim, or both. “Receipts are delayed” could mean that the amount is unchanged but arrives later, or that some receipts are never collected. A useful translation makes the intended interpretation explicit rather than silently choosing one.
Specify the Change Before Calculating
For each statement in a scenario, record the affected quantity, its baseline value, the size and form of the change, and its timing. Keep the units visible: a percentage change in a count is not the same as a percentage-point change in a rate, and an amount per policy is not a portfolio total.
| Question | What to record | Example of a precise input |
|---|---|---|
| What changes? | The model quantity affected | Number of active contracts |
| Relative to what? | The baseline and its date | 10,000 contracts at the start of year 1 |
| By how much? | Absolute or relative change | 8% increase, giving 10,800 contracts |
| When? | Effective date and period affected | Increase effective at the start of year 2 |
| Where does it flow? | Loss, asset, cash flow, reserve, or capital input | Year 2 expected claims and year-end capital |
Use a timeline when a narrative has more than one date. A change applied at the beginning of a year affects that year’s exposure; the same change applied at year-end may not. Likewise, a loss recognized immediately and a cash payment made in a later year are separate events. Keeping their dates distinct prevents a scenario from becoming an undated list of adjustments.
When multiple drivers affect a quantity, calculate each at the level the model requires. For instance, an expected aggregate loss may depend on exposure count, claim frequency, and average claim size. If each changes, applying only one of those changes understates the translated scenario. If percentage changes are applied sequentially to the same base, make the order and base explicit; do not add percentages automatically.
Worked Example: Translating Exposure and Loss Assumptions
Worked Example: Translating Exposure and Loss Assumptions
A hypothetical insurer has 10,000 active service contracts at the start of year 1. Its baseline annual claim frequency is 0.040 claims per contract, and its baseline mean claim payment is $12,000. A scenario states that contract count is 8% higher from the start of year 2, annual frequency is 0.045 in year 2, and mean payment is 10% higher in year 2. Calculate baseline and stressed expected claim payments for one year, and identify the year 2 change.
Method and assumptions. Treat the frequency as the expected number of claims per contract for the year. Assume the stated mean payment applies to each claim, and calculate gross expected payments without expenses, reinsurance, or discounting. The scenario inputs apply to year 2; they do not change year 1.
Step 1: Calculate the baseline. Expected claims are \(10{,}000(0.040)=400\). Expected aggregate claim payments are \(400(\$12{,}000)=\$4{,}800{,}000\).
Step 2: Translate the year 2 exposure. The stressed contract count is \(10{,}000(1.08)=10{,}800\).
Step 3: Translate frequency and payment size. Expected year 2 claims are \(10{,}800(0.045)=486\). The stressed mean payment is \(\$12{,}000(1.10)=\$13{,}200\).
Step 4: Calculate stressed expected payments. The year 2 expected total is \(486(\$13{,}200)=\$6{,}415{,}200\). The increase relative to the baseline is \(\$6{,}415{,}200-\$4{,}800{,}000=\$1{,}615{,}200\), or \(1{,}615{,}200/4{,}800{,}000=0.3365\), which is 33.65% when expressed as a percentage.
Check. The three year 2 multipliers are \(1.08\), \(0.045/0.040=1.125\), and \(1.10\). Their product is \(1.3365\), and \(\$4{,}800{,}000(1.3365)=\$6{,}415{,}200\). The direct and multiplier calculations agree. A common mistake is to apply the 8% exposure increase but leave frequency and claim size at baseline; that would produce only \(\$5{,}184{,}000\), not the stressed total.
Why the Expected-Loss Calculation Works
The calculation above follows from the expectation of a sum. Let \(N\) be the number of claims in the period and let \(X_j\) be the payment on claim \(j\). Aggregate payments are \(L=\sum_{j=1}^{N}X_j\). If claim payments have mean \(m\), and their expected total conditional on \(N\) is \(Nm\), then taking expectations gives \(E[L]=E[N]m\). If there are \(n\) contracts, each with expected claim count \(q\), then \(E[N]=nq\), so \(E[L]=nqm\).
This identity needs a consistent definition of the claim count and mean payment. It does not require the claim count to be fixed. It does require that the conditional mean payment per claim is \(m\) for the claims being counted. If the scenario changes the claim mix so that the mean payment depends on the number or type of claims, the model must represent that dependence rather than use an unchanged \(m\).
Translate Asset Values and Cash Flows on Their Own Dates
An asset-value shock and a cash-flow shock are different inputs. A percentage decline in a portfolio changes its value on the stated valuation date. A reduced receipt or additional payment changes a cash flow on its stated payment date. Record each once, and state whether the resulting capital calculation includes both. If a future cash flow is already reflected in a valuation, adding its full amount again as a separate capital loss can double count it.
Worked Example: Separating an Asset Shock from a Cash Outflow
A hypothetical company has assets of $40 million and liabilities of $32 million at time 0, so its starting surplus is $8 million. A scenario imposes an immediate 6% decline in the asset value and an additional operating cash outflow of $400,000 at the end of year 1. Assume liabilities are unchanged, there are no taxes or offsets, and the year 1 outflow reduces surplus dollar for dollar when paid. Calculate the stressed asset value and surplus after both impacts.
Method. Apply the percentage shock to the asset value at time 0. Treat the year 1 outflow as a separate dated cash flow, not as another percentage reduction in assets.
Step 1: Calculate the asset loss. The loss is \(0.06(\$40{,}000{,}000)=\$2{,}400{,}000\). The stressed asset value immediately after the shock is \(\$40{,}000{,}000-\$2{,}400{,}000=\$37{,}600{,}000\).
Step 2: Calculate surplus after the immediate shock. With liabilities unchanged at $32 million, surplus is \(\$37{,}600{,}000-\$32{,}000{,}000=\$5{,}600{,}000\).
Step 3: Apply the year 1 cash outflow. Surplus after payment is \(\$5{,}600{,}000-\$400{,}000=\$5{,}200{,}000\). The total reduction from the starting surplus is \(\$8{,}000{,}000-\$5{,}200{,}000=\$2{,}800{,}000\).
Check. The asset-value shock and outflow sum to \(\$2{,}400{,}000+\$400{,}000=\$2{,}800{,}000\), matching the surplus reduction. A common mistake is to apply the 6% shock to surplus rather than to the specified $40 million asset base; that would incorrectly produce a $480,000 asset shock.
Link Reserve Changes, Payment Timing, and Capital Inputs
A scenario can increase an estimated liability while also specifying when the additional amount is paid. Keep three quantities separate: the reserve change recognized at the valuation date, the cash payments by period, and any additional expenses. Their relationship depends on the accounting and valuation basis. In the simple undiscounted case below, the incremental payments add to the incremental reserve; they are not a second independent loss to subtract from capital after that reserve has already been recognized.
Worked Example: Translating a Reserve Narrative into Dated Inputs
A hypothetical insurer holds an $20 million claims reserve at time 0. A scenario increases the ultimate claims estimate by 8%. It specifies that 40% of the incremental amount is paid during year 1 and 60% during year 2, and that a separate $250,000 claims-handling expense is paid in year 1. Assume the reserve is undiscounted, the full reserve increase is recognized at time 0, and there are no tax, reinsurance, or other offsets. Calculate the reserve and capital input at time 0, and the additional cash outflows by year.
Method. First calculate the change in the ultimate estimate. Then allocate that change to the stated payment dates. Treat the separate handling expense as a cash-flow input, not as part of the incremental claims reserve.
Step 1: Calculate the incremental reserve. The increase is \(0.08(\$20{,}000{,}000)=\$1{,}600{,}000\). The stressed reserve is \(\$20{,}000{,}000+\$1{,}600{,}000=\$21{,}600{,}000\). Under the stated assumptions, the time 0 capital input is a $1.6 million reduction in surplus.
Step 2: Allocate incremental claims payments. The year 1 claims payment is \(0.40(\$1{,}600{,}000)=\$640{,}000\). The year 2 claims payment is \(0.60(\$1{,}600{,}000)=\$960{,}000\). They sum to \(\$640{,}000+\$960{,}000=\$1{,}600{,}000\), the full incremental reserve.
Step 3: Add the separate expense to the correct period. Total additional year 1 cash outflow is \(\$640{,}000+\$250{,}000=\$890{,}000\). Total additional year 2 cash outflow is $960,000.
Check. The dated claims payments reconcile to the reserve increase, while the $250,000 expense is separately identified. A common mistake is to reduce capital by the $1.6 million reserve increase and then subtract the same $1.6 million of future claims payments from capital again. That double counts the claims deterioration under the assumptions in this example. The payments remain important for cash-flow projections, but they are not an additional ultimate claims loss.
Build a Traceable Scenario Bridge
A concise bridge makes it possible to see how a narrative becomes a set of model inputs. The bridge should show the starting value, the translated stressed value, the date, and the destination of the change. For a capital input, also state which offsets or existing provisions have been excluded or included.
Rewrite each narrative phrase as a change to a named quantity. Split statements that could mean more than one thing, such as “higher claims,” into explicit frequency, severity, or exposure changes.
Record the starting amount, measurement unit, and period. Specify whether the input is a percentage, percentage-point change, dollar amount, rate per exposure, or timing shift.
Identify when it becomes effective, how long it persists, and when any resulting loss or cash flow is recognized or paid.
Apply the change to the stated base, calculate the financial quantity, and check totals, units, and dates. Confirm that a reserve change and its future payments have not been treated as two separate ultimate losses.
State which translated quantities feed the capital calculation and which assumptions, such as taxes or recoveries, have been excluded. Preserve the distinction between a capital impact and a liquidity timing input.
Common Translation Traps
- Applying a shock to the wrong base. A 6% asset decline applies to the specified asset value, not automatically to surplus, premium, or another convenient total.
- Confusing percentage and percentage points. A rate rising from 2% by 1 percentage point becomes 3%; a 1% relative increase becomes 2.02%.
- Ignoring the effective date. A year 2 exposure increase should not silently affect year 1 results.
- Applying only one of several linked changes. If exposure, frequency, and mean payment all change, calculate the aggregate quantity using all three inputs.
- Counting a reserve deterioration twice. If the reserve increase already recognizes the ultimate loss, its later settlement is normally a cash-flow timing input, not a second ultimate loss.
- Leaving the basis unstated. Gross versus net, undiscounted versus discounted, and before-tax versus after-tax amounts can produce different capital inputs. State the chosen basis before calculating.
Check Your Understanding
For each problem, state the timing and basis of the inputs before calculating. Amounts are hypothetical.
- A portfolio has 15,000 active contracts, frequency 0.020 per contract per year, and mean payment $9,000. From the start of year 2, contract count rises by 6%, frequency becomes 0.021, and mean payment becomes $9,500. Calculate baseline and year 2 expected payments and the increase. (Answer: baseline $2,700,000; year 2 $3,172,050; increase $472,050.)
- A company has $12 million of assets and $9.5 million of liabilities at time 0. Assets immediately decline by 3%; liabilities do not change. A separate $180,000 expense is paid at the end of year 1. Assuming no offsets, calculate surplus immediately after the asset shock and after the expense. (Answer: $2,140,000 immediately after the shock; $1,960,000 after the year 1 expense.)
- An $8.5 million undiscounted reserve increases by 12% at time 0. The incremental claims amount is paid 25% in year 1 and 75% in year 2. A separate $40,000 expense is paid in year 1. Calculate the reserve increase, additional cash outflow in each year, and time 0 capital reduction if the reserve increase is recognized immediately. (Answer: reserve increase and time 0 capital reduction $1,020,000; year 1 cash outflow $295,000; year 2 cash outflow $765,000.)
- A $1.2 million receipt is expected at the end of year 1 but is delayed to the end of year 2, with no change in amount. At an effective annual interest rate of 5%, calculate the reduction in present value at time 0. (Answer: \(\$1{,}200{,}000/1.05-\$1{,}200{,}000/1.05^2=\$54{,}421.77\), or $54,421.77 to the cent.)
- A portfolio has 4,000 exposures, annual frequency 0.030 per exposure, and mean payment $5,000. In year 2, exposures increase by 10% and mean payment increases by 20%, while frequency is unchanged. A separate $100,000 year 2 expense is recognized. Calculate the increase in expected claim payments and the total year 2 deterioration including the expense. (Answer: baseline expected claims $600,000; stressed expected claims $792,000; increase $192,000; total deterioration including the expense $292,000.)