FINAL Summit Medical Group RFP

ABC Company

ValuationDate: December31,2016

Triangulation Report

ReinsuranceRecoverable:

Medical, Vision, and Rx

Seasonality&Margin:

1.00

INCURRED: 1/1/15 - 12/31/16

AnnualTrend:

INCURRED

→

MembersPerSubscriberEstimate

1.75

PDCLAIMS CUMMULPD

PAID ↓

Jan15

Feb15

Mar 15

Apr15

May15

Jun15

Jul15

Aug15

Sep 15

Oct 15

Nov15

Dec15

Jan 16

Feb 16

Mar 16

Apr 16

May16

Jun16

Jul16

Aug 16

Sep 16

Oct16

Nov 16

Dec 16

PLANYEAR CLAIMSPER

Subscribers

1,527

1,529

1,527

1,528

1,525

1,516

1,468

1,523

1,545

1,546

1,555

1,553

1550

1548

1547

1524

1474

1533

1535

1532

1537

1535

Jan-15

649,864

$649,864

$649,864

Jan15

Feb-15

548,559

568,496

$1,117,055

$1,766,919

Feb15

Mar-15

327,328

648,445

509,571

$1,485,344

$3,252,263

Mar15

Apr-15

33,828

499,741

1,065,363

411,354

$2,010,286

$5,262,549

Apr15

May-15

23,341

55,951

341,190

778,943

689,916

$1,889,341

$7,151,890

May 15

Jun-15

5,964

197,064

55,314

267,227

663,435

900,419

$2,089,423

$9,241,313

Jun 15

Jul-15

2,922

268,245

37,949

45,226

162,686

952,825

753,992

$2,223,845

$11,465,158

Jul15

Aug-15

7,373

7,819

4,384

25,057

11,992

150,269

860,256

615,148

$1,682,298

$13,147,456

Aug 15

Sep-15

414

1,141

1,416

7,233

14,213

40,633

45,989

467,564

585,804

$1,164,407

$14,311,863

Sep15

Oct-15

199

(35,022)

4,033

26,877

12,143

64,665

59,818

130,438

406,213

425,697

$1,095,061

$15,406,925

Oct15

Nov-15

894

795

4,961

19,945

5,602

26,708

23,615

37,728

156,586

1,053,648

420,982

$1,751,464

$17,158,389

Nov 15

Dec-15

2,704

4,495

3,574

10,143

5,912

13,125

43,948

6,721

48,425

163,373

700,733

720,029

$1,723,180

$18,881,569

Dec15

Jan-16

324

4,417

363

3,988

14,066

2,502

5,214

13,018

35,392

207,759

647,618

297,714

$1,232,390

$1,232,390

Jan 16

Feb-16

(94,759)

2,195

3,164

3,317

17,706

4,957

4,593

5,088

9,275

436,079

185,231

529,751

335,685

$1,442,358

$2,674,749

Feb16

Mar-16

427

2,720

6,421

6,122

7,098

17,534

18,914

26,230

16,660

88,042

128,434

558,958

586,655

$1,464,214

$4,138,963

Mar16

Apr-16

(208)

1,528

1,854

3,314

10,907

5,290

16,295

9,415

12,790

29,430

25,819

47,319

60,426

534,540

986,392

574,220

$2,319,330

$6,458,293

Apr16

May-16

147

1,198

2,181

399

1,971

1,316

11,001

15,908

23,816

7,827

255,285

288,377

511,572 459,008

$1,580,101

$8,038,394

May 16

Jun-16

(2,159)

1,349

1,638

1,490

6,373

229

508

4,569

11,009

18,468

7,910

29,773

187,910

480,759 864,023

311,960

$1,925,811

$9,964,205

Jun 16

Jul-16

182

1,998

1,059

(315)

244

10,527

17,366

5,177

2,475

2,810

7,952

5,717

8,357

442,746

58,236 192,279

938,405 240,875

$1,936,088

$11,900,292

Jul16

Aug-16

(1,241)

(280)

(832)

(1,000)

(1,072)

(242)

(679)

311

13,646

1,688

3,563

10,017

6,269

28,140

25,345

376,708 868,789 127,655

$1,456,785

$13,357,077

Aug 16

Sep-16

222

(4)

643

2,859

988

344

2,117

6,670

5,946

19,767

17,585

94,850

69,118 349,805 1,110,170 543,552

$2,224,632

$15,581,709

Sep16

Oct-16

494

1,067

557

1,896

4,445

3,583

5,764

5,940

21,867

8,682

57,297 123,950 629,886 510,985

$1,376,503

$16,958,212

Oct 16

Nov-16

991

(5,567)

(5,271)

(6,882)

152

1,122

903

(358)

3,240

3,558

3,576

31,633

61,767

79,643 194,295 543,118 549,298

$1,455,291

$18,413,503

Nov 16

Dec-16

864

5,533

209

183

1,577

883

188

6,455

7,900

25,180

247,998 280,566

46,185 276,809 225,284 770,188 602,300

$2,498,359

$20,911,862

Dec16

Total

1,603,274

2,125,582

2,036,665

1,605,052

1,593,241

2,187,091

1,834,960

1,307,496

1,256,068

1,763,737

1,852,641

1,746,875

1,054,243

1,741,973

2,533,575

1,687,910 1,686,128 1,984,504 1,859,099 1,487,603 1,644,542 1,279,387 1,319,486 602,300 39,793,431

$20,911,862

PSPM

$1,049.95

$1,390.18

$1,333.77

$1,050.43

$1,044.75

$1,442.67

$1,249.97

$858.50

$812.99

$1,140.84

$1,191.41

$1,124.84

$678.84

$1,123.85

$1,636.68

$1,090.38 $1,089.93 $1,302.17 $1,261.26 $970.39 $1,071.36 $835.11 $858.48 $392.38

ACTUAL RUNOFF CLAIM DEVELOPMENT

RunOffThru

RunOff @

Jan15

Feb 15

Mar 15

Apr15

May15

Jun 15

Jul15

Aug15

Sep 15

Oct15

Nov 15

Dec15

Jan16

Feb 16

Mar16

Apr 16

May16

Jun 16

Jul16

Aug 16

Sep16

Oct 16

Nov 16

Dec 16

ValDatebyMos

Jan 15

953,410

953,410

Jan 15

Feb 15

404,851

1,557,086

1,961,936

Feb 15

Mar 15

77,523

908,641

1,527,095

2,513,258

Mar15

Apr 15

43,695

408,900

461,732

1,193,698

2,108,023

Apr 15

May 15

20,354

352,949

120,542

414,755

903,325

1,811,923

May 15

Jun 15

14,390

155,885

65,228

147,527

239,890

1,286,672

1,909,592

Jun 15

Jul 15

11,468

-112,360

27,279

102,301

77,204

333,847

1,080,969

1,520,707

Jul15

Aug 15

4,094

-120,180

22,895

77,244

65,212

183,578

220,713

692,347

1,145,904

Aug 15

Sep 15

3,680

-121,321

21,479

70,011

50,999

142,945

174,723

224,783

670,264

1,237,565

Sep 15

Oct 15

3,481

-86,299

17,446

43,134

38,856

78,281

114,905

94,346

264,051

1,338,040

1,906,241

Oct 15

Nov 15

2,586

-87,094

12,484

23,189

33,254

51,573

91,290

56,618

107,466

284,392

1,431,659

2,007,417

Nov15

Dec 15

-118

-91,588

8,911

13,047

27,342

38,448

47,342

49,897

59,041

121,019

730,926

1,026,846

2,031,111

Dec15

Jan 16

-132

-91,913

4,493

12,683

23,354

24,382

44,839

44,683

46,023

85,627

523,167

379,228

756,529

1,852,963

Jan 16

Feb 16

-208

2,847

2,298

9,520

20,036

6,676

39,882

40,090

40,935

76,352

87,088

193,996

226,778

1,406,289

2,152,579

Feb 16

Mar 16

-208

2,847

1,871

6,799

13,616

553

32,784

22,557

22,021

50,121

70,429

105,955

98,344

847,331

1,946,920

3,221,939

Mar16

Apr 16

1,319

3,486

2,708

-4,736

16,489

13,142

9,231

20,692

44,609

58,636

37,918

312,791

960,528

1,113,690

2,590,519

Apr 16

May 16

1,173

-1,180

3,486

527

-4,832

16,090

11,170

7,915

9,691

28,702

34,820

30,091

57,506

672,151

602,118 1,227,121

2,696,547

May 16

Jun 16

1,173

979

2,137

-1,111

-6,323

9,717

10,942

7,407

5,122

17,693

16,351

22,180

27,733

484,241

121,359 363,097 1,672,543

2,755,240

Jun 16

Jul 16

991

-1,019

1,078

-796

-6,567

-810

-6,424

2,230

2,648

14,882

8,400

16,464

19,376

41,495

63,123 170,818

734,139 1,618,224

2,678,251

Jul16

Aug 16

991

222

1,358

-5,567

262

-6,182

2,909

2,337

1,236

6,712

12,901

9,359

35,226

34,983 145,473

357,431 749,435 1,359,948

2,709,070

Aug 16

Sep 16

991

1,358

-5,567

262

-6,825

1,349

892

4,595

6,231

3,413

15,459

17,398

50,623

288,313 399,630 249,778 1,100,990

2,128,980

Sep 16

Oct 16

991

864

-5,567

262

-6,825

282

335

2,699

1,786

-170

9,695

11,458

28,756

279,631 342,333 125,828 471,104 768,402

2,031,864

Oct 16

Nov 16

864

5,533

209

183

1,577

883

188

6,455

7,900

25,180

247,998 280,566

46,185 276,809 225,284 770,188

1,896,059

Nov16

Dec 16

CrossCheck toPaidClaim

Report