Table of Contents Table of Contents
Previous Page  166-167 / 208 Next Page
Information
Show Menu
Previous Page 166-167 / 208 Next Page
Page Background

ABC Company

Valuation Date: December 31, 2016

Triangulation Report

Reinsurance Recoverable:

$0

Dental

Seasonality & Margin:

1.00

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

Annual Trend:

5%

INCURRED

Members Per Subscriber Estimate

1.75

PD CLAIMS CUMMUL PD

PAID

Jan 15

Feb 15 Mar 15 Apr 15 May 15 Jun 15

Jul 15

Aug 15 Sep 15

Oct 15

Nov 15

Dec 15

Jan 16

Feb 16 Mar 16 Apr 16 May 16 Jun 16

Jul 16

Aug 16 Sep 16

Oct 16

Nov 16 Dec 16

PLAN YEAR CLAIMS PER

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

1,553

1,550

1,548

1,548

1,547

1,524

1,474

1,533

1,535

1,532

1,537

1,535

Jan-15

67,019

$67,019

$67,019

Jan 15

Feb-15

27,021

70,630

$97,651

$164,670

Feb 15

Mar-15

1,597

14,759

64,793

$81,149

$245,819

Mar 15

Apr-15

2,060

421

28,406

62,242

$93,129

$338,948

Apr 15

May-15

618

1,540

1,672

35,349

47,499

$86,678

$425,626

May 15

Jun-15

776

750

321

3,289

12,861

83,595

$101,593

$527,219

Jun 15

Jul-15

1,011

466

0

(756)

2,183

37,156

83,198

$123,259

$650,478

Jul 15

Aug-15

80

120

177

292

120

490

23,861

52,387

$77,527

$728,005

Aug 15

Sep-15

267

109

0

622

0

1,328

2,088

22,275

37,090

$63,780

$791,785

Sep 15

Oct-15

129

129

237

350

214

1,012

2,703

3,220

24,606

48,812

$81,411

$873,195

Oct 15

Nov-15

0

0

101

179

0

210

133

1,046

717

15,771

50,597

$68,755

$941,950

Nov 15

Dec-15

120

120

120

278

120

217

789

1,897

217

1,560

16,937

59,072

$81,446

$1,023,396

Dec 15

Jan-16

2

0

0

0

0

95

0

0

46

623

1,579

36,990

71,967

$111,301

$111,301

Jan 16

Feb-16

0

0

0

0

115

115

250

530

251

1,812

1,269

7,220

24,139

64,640

$100,341

$211,642

Feb 16

Mar-16

0

0

850

0

0

0

193

0

251

0

779

(264)

4,496

23,523

49,060

$78,887

$290,530

Mar 16

Apr-16

0

0

0

208

0

0

0

(130)

0

200

620

944

789

239

34,508

52,807

$90,185

$380,714

Apr 16

May-16

0

0

0

0

0

0

0

159

111

110

757

166

2,960

702

1,817

18,804

50,984

$76,570

$457,284

May 16

Jun-16

0

0

0

0

0

0

0

69

0

0

0

318

96

305

740

818

19,812

66,812

$88,970

$546,254

Jun 16

Jul-16

0

0

0

0

0

0

0

0

212

0

939

0

0

0

530

1,680

2,337

46,661

68,717

$121,075

$667,329

Jul 16

Aug-16

0

0

0

0

0

0

0

0

0

0

0

0

402

531

1,555

554

1,517

922

25,767

55,632

$86,880

$754,209

Aug 16

Sep-16

0

0

0

0

0

0

0

0

0

0

0

440

13

163

176

406

508

1,857

2,688

26,871

53,803

$86,925

$841,134

Sep 16

Oct-16

0

0

0

0

0

0

0

0

0

0

134

282

242

141

282

282

122

990

1,290

1,719

20,392

50,851

$76,727

$917,861

Oct 16

Nov-16

0

0

0

0

0

0

0

0

0

0

0

0

124

164

304

304

344

284

942

3,049

804

19,182

38,223

$63,724

$981,585

Nov 16

Dec-16

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

135

0

0

170

1,511

0

37,408

57,294

$96,518

$1,078,103

Dec 16

Total

100,700

89,044

96,678 102,053

63,112 124,218 113,215 81,453

63,501

68,887

73,611 105,168 105,228

90,407

88,972

75,655

75,758 117,526

99,404

87,441

76,510

70,033

75,631

57,294

2,101,499

$1,078,103

PSPM

$65.95

$58.24

$63.31

$66.79

$41.38

$81.94

$77.12 $53.48

$41.10

$44.56

$47.34

$67.72

$67.76

$58.33

$57.48

$48.87

$48.97

$77.12

$67.44

$57.04

$49.84

$45.71

$49.21

$37.33

ACTUAL RUNOFF CLAIM DEVELOPMENT

RunOff Thru

RunOff @

Jan 15

Feb 15

Mar 15

Apr 15

May 15

Jun 15

Jul 15

Aug 15 Sep 15

Oct 15

Nov 15

Dec 15

Jan 16

Feb 16

Mar 16

Apr 16

May 16

Jun 16

Jul 16

Aug 16

Sep 16

Oct 16

Nov 16 Dec 16

Val Date by Mos

Jan 15

33,681

33,681

Jan 15

Feb 15

6,660

18,414

25,075

Feb 15

Mar 15

5,063

3,655

31,885

40,603

Mar 15

Apr 15

3,003

3,234

3,479

39,811

49,527

Apr 15

May 15

2,385

1,694

1,807

4,462

15,613

25,961

May 15

Jun 15

1,609

944

1,485

1,173

2,752

40,623

48,586

Jun 15

Jul 15

598

478

1,485

1,929

569

3,467

30,017

38,542

Jul 15

Aug 15

518

358

1,308

1,637

449

2,977

6,156 29,066

42,469

Aug 15

Sep 15

251

249

1,308

1,014

449

1,649

4,067

6,791

26,411

42,189

Sep 15

Oct 15

122

120

1,071

665

235

637

1,365

3,572

1,805

20,075

29,666

Oct 15

Nov 15

122

120

970

486

235

427

1,232

2,525

1,088

4,304

23,013

34,522

Nov 15

Dec 15

2

0

850

208

115

210

443

628

871

2,744

6,076

46,096

58,244

Dec 15

Jan 16

0

0

850

208

115

115

443

628

826

2,121

4,497

9,106

33,261

52,172

Jan 16

Feb 16

0

0

850

208

0

0

193

98

574

309

3,228

1,886

9,122

25,767

42,237

Feb 16

Mar 16

0

0

0

208

0

0

0

98

323

309

2,450

2,151

4,626

2,245

39,912

52,322

Mar 16

Apr 16

0

0

0

0

0

0

0

228

323

110

1,829

1,206

3,838

2,006

5,404

22,848

37,792

Apr 16

May 16

0

0

0

0

0

0

0

69

212

0

1,073

1,040

877

1,304

3,587

4,044

24,774

36,981

May 16

Jun 16

0

0

0

0

0

0

0

0

212

0

1,073

722

781

999

2,847

3,226

4,963

50,714

65,537

Jun 16

Jul 16

0

0

0

0

0

0

0

0

0

0

134

722

781

999

2,317

1,546

2,626

4,053

30,687

43,866

Jul 16

Aug 16

0

0

0

0

0

0

0

0

0

0

134

722

379

468

762

992

1,109

3,131

4,920

31,809

44,426

Aug 16

Sep 16

0

0

0

0

0

0

0

0

0

0

134

282

366

305

586

586

601

1,274

2,232

4,938

22,707

34,011

Sep 16

Oct 16

0

0

0

0

0

0

0

0

0

0

0

0

124

164

304

304

479

284

942

3,219

2,315

19,182

27,317

Oct 16

Nov 16

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

135

0

0

170

1,511

0

37,408

39,224

Nov 16

Dec 16

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

Dec 16

II. CUMMULATIVE PAID BY INCURRED MONTH

Cross Check to Paid

Claim Report