ABC Company
Valuation Date: December 31, 2015
Triangulation Report
Reinsurance Recoverable:
$0
Pharmacy
Seasonality & Margin:
1.02
INCURRED: 1/1/14 - 12/31/15
Annual Trend:
11.3%
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
176,508
Feb-14
283,614 204,030
Mar-14
3,101 212,786 271,180
Apr-14
173
7,626 243,209 197,309
May-14
508
0
15,721 282,953
244,990
Jun-14
0
0
167
292
261,726 218,145
Jul-14
127
0
619
687
670 322,194 207,521
Aug-14
0
0
0
0
6,978
389 358,001
279,568
Sep-14
0
0
0
0
0
0
6,242
200,359
198,512
Oct-14
(1,048)
(1,048)
0
0
0
(327)
(74)
38
291,761 169,219
Nov-14
0
0
0
0
0
0
1,381
1,501
(67)
346,915
260,156
Dec-14
(396)
0
0
0
0
0
0
0
0
3,608
255,594 220,459
Jan-15
0
0
0
0
0
0
0
0
163
140
17,312 331,637 246,462
Feb-15
0
0
0
0
0
0
0
0
0
0
163
15,724 244,845 198,394
Mar-15
0
0
0
0
0
0
0
0
0
0
0
35
13,717 216,581
234,201
Apr-15
0
0
0
0
0
0
0
0
0
0
0
0
0
118
233,698
May-15
17
0
0
0
0
0
0
0
0
0
0
0
0
15
8,842
Jun-15
0
0
0
0
0
0
0
0
0
0
0
0
0
0
26
Jul-15
(97)
0
0
0
0
0
0
0
0
0
0
0
0
0
4,768
Aug-15
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Sep-15
0
0
0
0
0
0
0
0
0
0
0
1,089
0
32
760
Oct-15
0
0
0
0
(7)
0
0
0
0
0
0
60
0
0
0
Nov-15
0
0
0
0
181
0
0
0
0
0
0
121
0
0
0
Dec-15
143
0
0
0
0
4
0
0
0
0
0
0
0
0
0
Total
462,651
423,394
530,896
481,242
514,537
540,405
573,071
481,465
490,369
519,882
533,225
569,125
505,024
415,139
482,294
7