Pike RFP

Employer Group ABC

Incurred:

Apr 2014 thru Dec 2015

Paid:

Apr 2014 thru Mar 2016

Page

Table 5.2.5: Medical Claim Lag Report and IBNR

Paid

Incurred

Monthly Paid

Lag

0Mths

1Mths

2Mths

3Mths

4Mths

5Mths

6Mths

7Mths

8Mths

9Mths

10Mths

11Mths

12+ Mths

Total

Current

12Mths

Prior 12Mths

Mthly

Qtly

Apr-15

$1,884,779

$3,159,649

$792,377

$413,268

$133,718

$168,187

$49,344

$15,598

$17,116

$32,736

$6,052

$49,962

$37,376

$6,760,161

$1,884,779

$4,875,382

1.37

May-15

$1,840,790

$2,706,685

$680,997

$846,231

$136,053

$84,693

$14,770

$28,015

($89,536)

$13,185

$5,738

$2,084

$83,061

$6,352,765

$4,547,475

$1,805,291

1.31

Jun-15

$1,769,395

$2,935,479

$884,086

$251,494

$225,157

$77,970

($868)

$1,795

$9,024

$41,453

$24,744

$2,483

$2,085

$6,224,298

$5,588,960

$635,338

1.21

1.30

Jul-15

$1,884,466

$2,492,938

$586,604

$355,992

$107,786

$43,345

$100,496

$23,127

$36,857

$12,341

($642)

$1,961

$108,185

$5,753,454

$5,319,999

$433,455

1.37

Aug-15

$1,964,031

$2,448,305

$468,254

$410,628

$156,229

$108,293

$25,308

$8,781

$998

$4,988

$26,558

$1,079

$98,869

$5,722,321

$5,447,447

$274,873

1.31

Sep-15

$1,644,737

$2,814,703

$865,480

$202,562

$105,601

$112,010

$22,987

$306,781

($6,200)

$34,503

($52,894)

$14,477

$23,912

$6,088,659

$5,745,094

$343,565

1.41

1.37

Oct-15

$2,021,821

$2,860,470

$639,214

$230,527

$82,551

$74,435

$52,691

$21,384

$21,140

$14,436

$14,664

$2,934

($20,172)

$6,016,096

$5,961,709

$54,386

1.04

Nov-15

$1,974,759

$3,193,531

$615,814

$358,587

$71,441

$68,331

$19,585

$35,403

$82,190

$913

($612)

$2,000

$39,867

$6,461,808

$6,337,449

$124,359

1.18

Dec-15

$2,288,820

$3,082,148

$684,402

$192,436

$408,936

$61,778

$29,826

$24,460

$38,822

$9,986

$21,490

$4,990

$17,311

$6,865,404

$6,811,628

$53,776

1.19

1.14

Jan-16

$1,543,945

$2,895,397

$427,727

$290,169

$143,004

$24,436

$143,389

$21,678

$15,429

$22,271

$20,978

$11,051

($30,664)

$5,528,811

$5,527,446

$1,365

1.20

Feb-16

$1,465,364

$2,739,596

$654,486

$186,293

$37,502

$138,336

$41,617

$134,957

$17,811

$4,941

$8,610

$24,276

$29,825

$5,483,613

$5,429,511

$54,102

1.38

Mar-16

$1,793,803

$2,584,625

$823,451

$492,998

$179,302

$93,252

$76,986

($24,120)

$14,077

$2,065

$23,776

$14,456

$89,215

$6,163,887

$6,074,672

$89,215

1.43

1.34

Total

$73,421,277

$64,676,169

$8,745,108

Average Monthly Paid

$6,118,440

IBNR in Months

1.28

Projected IBNR

Based on Last Month's Lag

Projected IBNR

Based on Last Quarter's Lag

Projected IBNR

Based on Last Year's Average Lag

Incurred and Paid in Current Period

$64,676,169

Lag Factor

1.43

1.34

1.28

Incurred and Paid as a % of Total

0.88

0.89

Total Incurred

$73,393,751

$72,776,697

$72,410,326

Projected IBNR

$8,717,582

$8,100,528

$7,734,157