ABC Company
Valuation Date: December 31, 2015
Triangulation Report
Reinsurance Recoverable:
$300,000
with
$125,000
aggregating spec
Medical
Seasonality & Margin:
1.02
INCURRED: 1/1/14 - 12/31/15
Annual Trend:
7.8%
INCURRED
→
PAID
↓
Jan 14
Feb 14
Mar 14
Apr 14
May 14
Jun 14
Jul 14
Aug 14
Sep 14
Oct 14
Nov 14
Dec 14
Jan 15
Feb 15
Mar 15
Jan-14
461,568
Feb-14
749,509 569,641
Mar-14
232,151 781,930 497,377
Apr-14
58,623 243,739 1,045,665 624,403
May-14
100,407
19,325 246,285 1,017,059
430,521
Jun-14
5,915
73,532
71,924 398,961
879,173 672,065
Jul-14
11,010
6,592
17,127
65,996
139,936 798,596 777,287
Aug-14
9,381
31,847
13,046
5,824
180,019 355,966 900,481
633,466
Sep-14
1,353
774
48,328
9,551
6,353
9,695 298,837
754,903
645,167
Oct-14
190
12,486
5,822
3,711
2,906
5,585
29,467
75,119
921,515 724,976
Nov-14
2,482
10,462
(250)
(981)
(299)
7,274
4,707
56,876
77,588 808,070
522,967
Dec-14
2,581
1,245
1,142
3,165
1,302
521
385
5,704
86,932 185,143
786,349 904,499
Jan-15
(29)
54
195
0
1,898
773
1,927
3,141
1,036
17,003
91,164 889,813 508,147
Feb-15
57
0
14
4,904
0
586
(448)
31,591
1,020
6,783
10,898 133,941 722,218 482,138
Mar-15
(30)
823
343
2,197
(1,002)
(36)
143
2,815
1,884
6,862
42,851
22,643 158,732 603,272
845,270
Apr-15
(1,318)
60
(294)
660
438
5,540
(203)
1,403
6,794
1,370
4,987
8,454 244,708
51,576 1,092,054
May-15
0
0
443
(147)
1,381
377
(5,276)
4,335
3,006
4,584
12,892
6,147
48,520
46,606
324,442
Jun-15
0
0
90
(558)
363
385
1,655
417
17,733
4,628
8,094
772
46,279
11,931
13,254
Jul-15
0
43
0
445
50
494
2,229
(555)
1,883
1,648
1,578
9,674
(1,030)
5,469
8,178
Aug-15
0
1,917
120
640
0
(55)
915
1,439
(1,108)
(94)
(102)
(1,684)
(1,196)
12,187
13,229
Sep-15
42
0
0
0
0
(2,822)
(108)
714
451
(3,628)
75
136
(653)
613
21,491
Oct-15
2,400
(7,500)
0
0
0
1,052
30
273
2,147
1,020
222
398
549
313
2,635
Nov-15
0
0
2,500
0
0
0
(128)
11,414
330
1,984
1,227
(168)
8,843
4,702
5,580
Dec-15
0
0
0
0
(656)
0
9
(755)
152
(172)
2,676
9,027
(33)
(194)
1,024
Total
1,636,291 1,746,971 1,949,877 2,135,830 1,642,382 1,855,998 2,011,913 1,582,301 1,766,529 1,760,177 1,485,880 1,983,653 1,735,084 1,218,614
2,327,158
$859,260
Manual adjustment to remove claims above Deductible of
5