Valuing an Insurance Enterprise and Reserve Estimates Using Bootstrapped Statutory Loss Information

1. Valuing an Insurance Enterprise and Reserve Estimates Using Bootstrapped Statutory Loss Information William C. Scheel DFA Technologies, LLC scheel@mindspring.com CAS 2001 DFA Seminar

2. Concepts • Target sufficiency level • Minimum sufficiency level • Capital release

3. Techniques • Bootstrapping loss triangles • Simulation of ultimate loss links, payment patterns and asset returns • Non-Linear optimization using proxy assets and target sufficiency levels • Programming with COM in Visual Basic for Applications (Excel VBA)

4. Target Sufficiency Level • Fair value of future cash flows • Present value of deferred annuity valued at riskless rate of return • Net amount necessary to transfer future claims payments

5. Minimum Sufficiency Level • Amount needed to fund future claims within confidence levels that adjust for uncertainty in amount and timing of payments and for uncertainty in investment returns • Chance-constrained valuation of claims • More than a reserve • Basis for the expectation of capital release • Basis of enterprise solidity

6. Capital Release • Initial excess sufficiency plus present value of expected capital release is the value of the enterprise • Amount of capital held in excess of expected sufficiency. It is expected to be released to shareholders rather than to be used to pay obligations. • Capital release occurs when minimum sufficiency levels decrease over time • Like reserves, capital release can only be measured probabilistically

7. Sources of Expected Capital Release • Target sufficiency level is higher than expected present value of claims • Value of assets is higher than expected value needed to achieve this deferred target sufficiency level

8. Sources of Insurance Enterprise Value • Assets exceeding minimum sufficiency level • Expectation of capital release in the future

9. Relationship Among Sufficiency Levels and Capital Release EOP Target sufficiency level High probably area and source of capital release expectation Investment return and claims experience expected to produce operating result in this area BOP Minimum sufficiency level Time

10. Capital Release where: = Capital released at the end of period t, = Minimum sufficiency level at the beginning of period t, = Portfolio return during period t, = Claims payments during period t.

11. Current Excess Value

12. Distribution of Capital Release

13. Bootstrapping Loss Triangles • Would rather use individual claims information • Multivariate sampling of lines of business yields covariance matrix • Ultimate link ratios • Paid/Ultimate ratios

14. Feasible Region for Bootstrap Sampling of a Link Ratio

15. Portions of a Bootstrap Sample in Shaded Regions

16. Statistics for Link1

17. Steps in Valuation of Target Sufficiency • Perform a bootstrap of link ratios for ultimate loss. • Use bootstrapped ultimate link ratios to derive correlation matrix and other statistics. • Using the correlation matrices and statistics, simulate ultimate links for each line of business using multinormal methods. • Apply the simulated ultimate link ratios to the latest ultimate loss triangle diagonal. • Perform a second-stage simulation using the probability distribution of paid-to-ultimate ratios (payment patterns). • Use the cash flows to calculate annuity-equivalent values for future loss cash flow. Do this at each forward calendar period.

18. Target Sufficiency Statistics

19. Moving from Targets to Minimum Sufficiency Levels • Targets risk-adjust only for uncertainty in amount of payments and timing of payments • What asset levels are required to meet sufficiency targets? • What portfolio allocation? • Technique: use non-linear optimization

20. Optimization Techniques • Objective: Minimize level of assets necessary to meet sufficiency targets • Subject to: Portfolio constraints for proxy assets and minimum sufficiency probability constraint What BOP assets should be held to met EOP sufficiency levels within acceptable levels of risk?

21. Techniques Using Microsoft Excel and Frontline Premium Solver • Workbook A: Non-linear version of Solver posits trial solution (portfolio allocation) • Workbook B (COM object instantiated by A): Has 2,500 simulated asset returns, target sufficiency level and chance-constrained probability (all provided by A). Gets trial portfolio allocation from A. • B determines BOP value of target for each asset simulation using trail solution weights. • Using this BOP distribution, B returns chance-constrained minimum sufficiency level to A as objective value. • Workbook A repeats trial solution tests until it finds the minimum value returned by workbook B

22. Minimum Sufficiency Levels and Optimal Investment Portfolios

23. Capital Release Measurement Technique • Randomly generate investment scenario. Using portfolio allocation, determine period’s return and apply to minimum sufficiency value for period 1 (MSL1). • Generate liabilities and subtract from (1) • Compare (2) with MSL2 to get observation on capital release distribution • Repeat steps (1) to (3) many times to obtain distribution for capital release

24. Expected Capital Release

25. Summary • Target sufficiency measured from bootstrapped ultimate links and paid/ultimate ratios. Risk adjustment for amount and timing of losses. • Minimum sufficiency levels derived from (1) using non-linear optimization applied to simulated asset returns and required targets. Risk adjustment for uncertainty in investment returns. • Release of capital measured from simulations of assets and liabilities using minimum sufficiency levels.

26. Questions? William C. Scheel, Ph.D. DFA Technologies, LLC 93 Silkey Road North Granby, CT 06060-1419 (860) 653-7169 scheel@mindspring.com