INSURANCE CAPITAL FOR ASSET MANAGERS - BLANK MODEL SET: THE BOOK'S OWN INPUTS

Type these back into the blank files and the book's results come back. Cell references are sheet!cell.
Your_Fund.xlsx has no blank version: it arrives empty.

Capital_Charges_Blank.xlsx

   Charge!B5                         BB
   Charge!B6                         4.2
   Charge!B7                         150000000
   Charge!C14                        0
   Symmetric adjustment!B4           108
   Symmetric adjustment!B5           100
   Symmetric adjustment!B12          150000000

   Result: BB at 4.2 years 18.90%, €28.35 million on €150 million; symmetric adjustment zero at an index 8% above its average.

Mandate_Model_Blank.xlsx

   Mandate!B5                        150000000
   Mandate!C5                        0.072
   Mandate!B6                        150000000
   Mandate!C6                        0.115
   Mandate!B7                        150000000
   Mandate!C7                        0.068
   Mandate!B8                        150000000
   Mandate!C8                        0.089
   Mandate!E5                        0.39
   Mandate!E6                        0.49
   Mandate!E7                        0.25
   Mandate!E8                        0.189
   Mandate!B28                       0.01

   Result: returns on capital 18.46%, 23.47%, 27.20%, 47.09%; 41.80% on the credit fund after a further 1.00% fee.

Aggregation_Blank.xlsx

   Aggregation!B5                    180000000
   Aggregation!B6                    372000000
   Aggregation!B7                    132500000
   Aggregation!B8                    548350000
   Aggregation!B9                    60000000
   Aggregation!B10                   40000000

   Result: sum 1,332.85 million, aggregate 1,083.19 million, benefit 249.66 million (18.73%); upward scenario 991.86 million.

Marginal_Capital_Blank.xlsx

   Marginal!B6                       180000000
   Marginal!C6                       180000000
   Marginal!B7                       240000000
   Marginal!C7                       240000000
   Marginal!B8                       95000000
   Marginal!C8                       520000000
   Marginal!B9                       520000000
   Marginal!C9                       95000000
   Marginal!B10                      60000000
   Marginal!C10                      60000000
   Marginal!B11                      40000000
   Marginal!C11                      40000000
   Marginal!B16                      58500000
   Marginal!B17                      73500000
   Marginal!B18                      37500000
   Marginal!B19                      28350000
   Marginal!B25                      150000000
   Marginal!C25                      0.072
   Marginal!B26                      150000000
   Marginal!C26                      0.115
   Marginal!B27                      150000000
   Marginal!C27                      0.068
   Marginal!B28                      150000000
   Marginal!C28                      0.089

   Result: marginal costs 52.15, 65.63, 26.72, 26.58 million; all four together 171.94 million.

Managers_Levers_Blank.xlsx

   Levers!B4                         150000000
   Levers!B27                        0.189
   Interest rate!B4                  3200000000
   Interest rate!B5                  12
   Interest rate!B6                  0.03
   Interest rate!B27                 4.2
   Interest rate!B28                 10
   Matching adjustment!B4            0.045
   Matching adjustment!B7            0.025
   Matching adjustment!B10           Yes
   Matching adjustment!B13           4.2
   Infrastructure!B21                30000000

   Result: levers from €45.15 million (look-through, credit fund) to €4.87 million (duration); matching adjustment €11.92 million.

