471F0983-EB69-959C-3B62A289547CA11E.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
Cancer Concierge/Navigation Services
Solicitation number
RFP 2026-06-04
Issued by
Franklin County, Ohio

About this file

This is a Paid & Incurred (P&I) Limited Exhibit document for Franklin County Cooperative Health Improvement Program (GovTribe ID: 157775), detailing long-term disability (LTD) claims and financial performance data as of July 31, 2025. The exhibit spans a six-year experience period from January 1, 2020, through August 1, 2025, tracking claims activity, reserves, premiums, and incurred losses across the covered population. The document provides comprehensive claims-level detail for 80 individual claimants, including claim identification numbers, claimant demographics, disability dates, monthly benefit amounts, total benefits paid to date, Social Security status, and claim reserves. The program covered an average of 2,050 lives across the experience period, with membership ranging from 1,779 to 2,460 employees annually.

The financial summary reveals total paid claims of $1,516,944 against adjusted premiums of $3,418,299, generating an incurred loss ratio of 0.788. The program accumulated case reserves of $1,331,916 and Incurred But Not Reported (IBNR) reserves of $15,294, resulting in total incurred claims of $2,693,725. The annual adjusted premium per employee averaged $334, with rates declining from 0.665 in the 2020 period to 0.526 in the 2025 period. As of the valuation date, 18 claims were open with 51 total open and closed claims, 2 pending claims, and 34 denied claims. The claim incidence rate averaged 5.13 per 1,000 employees, with an average cost per claim of $50,989. Current active claimants receive monthly indemnity benefits ranging from $100 to $5,446, with most claims reflecting Social Security integration and survival of spouse/COLA provisions.

View the file

Other files

File Type Posted
C4A97C2F-E431-1D38-75E6D603401030C8.pdf PDF
441CA1BC-A59E-E520-9F472E421C5515A7.pdf PDF
48FFE6B8-C249-DC8C-BA6A621BAD5FF49F.xlsx XLSX spreadsheet
47039A14-CC1D-3979-F8226F8E1E768343.pdf PDF
8F33C1D9-B606-E1D0-F77CFF24E442EF1B.pdf PDF
441CC2FC-B00B-E914-728A3B9F6E284C71.pdf PDF
7D243EA3-FAAD-CF0C-AFFD3FFE55D5912C.pdf PDF
455CA489-AF8F-CF71-6FFA3A68482AEF22.pdf PDF
39A8A9E3-F569-C6B6-B9E7BF50CFDC4F51.pdf PDF
47ADF7AD-983F-9719-2E5C720D20F03E5A.xlsx XLSX spreadsheet
1FF70774-E56E-EAC8-88A7694DAF5EB82C.pdf PDF
D19B3093-A699-8107-EE175100DAB2A969.pdf PDF
48FFA356-A619-FDBE-4B4D833D8E7B2589.pdf PDF
8F3A405E-0241-7E43-C0DC0A6106AC42BB.pdf PDF
1FF7330C-CAC3-999B-9E6EF28469A04621.pdf PDF
47413282-9830-5BA4-96685E7F9A28C371.xlsx XLSX spreadsheet
E13134B7-AC80-2A6B-17903505A1365FE4.pdf PDF
600B382B-92C2-EE01-36E3171A1CE23381.pdf PDF
9AEA49E5-D258-E830-CAAB03DD9BBE7883.pdf PDF
451DAC14-D169-2A9F-1266443CD504A357.xlsx XLSX spreadsheet
44F2A935-093F-1234-3F0F06EFB73CE154.xlsx XLSX spreadsheet
455CC78D-B78A-EC66-F7D6D71B8AF36042.pdf PDF
F388F0B8-095B-81FD-4AB0A90CB30AE31F.pdf PDF
1FF834AF-CB60-B607-A9DD3103FF766EDA.pdf PDF
260F9701-94BA-EFEA-FCAED968AC730EE0.docx DOCX document
DE522D80-FE3B-40B1-1C32D6110AF0CD6F.pdf PDF
4ADB9154-92D0-FA39-8C51818579A9E699.pdf PDF
A3F924CA-A2E1-A38A-2E6F296BD4EAE5D4.pdf PDF
4ADC54F2-C74F-3F02-B4900398FFBEE5A5.xlsx XLSX spreadsheet
1FF76D77-0146-31BD-B70AC2B9310C078F.pdf PDF
44F28715-E1AF-A884-828CBEAF47CBA5D7.xlsx XLSX spreadsheet
6AB6D002-9E6C-0CCC-A56790941F2BE704.pdf PDF
600B193E-A6DE-E459-0374B7046DEB49BE.xlsx XLSX spreadsheet
ED338BF8-FCF8-7E6B-4327CDB3236D9A0A.pdf PDF
BEA8D216-B719-D18D-2A1EF07B83D22C78.xlsx XLSX spreadsheet
490005E7-0009-0FD7-0E92BD0F4BF1B987.xlsx XLSX spreadsheet
48C544C3-FCC4-F4ED-99FB5E91E5744B30.pdf PDF
8BE999EA-C1F3-6CAA-1ED2B57E621612FB.pdf PDF
703BE31F-F23C-B5C9-5B251B984014267B.pdf PDF
E990A518-E8F3-4318-3125803AC770B0DD.pdf PDF
4ADBBFB5-F75A-53E0-AE23AAE483992AC8.pdf PDF
DDA0BDC2-FA19-ADB6-FAD2DEA5AE6B4AEE.pdf PDF
96EE5830-0F4F-104B-FF1246192320CF51.pdf PDF
45745F40-E0BA-1577-1AE1A9CC2179CA13.pdf PDF
4ADC0CC3-B76B-A18D-C62DDED0F769FB5E.xlsx XLSX spreadsheet
56D1C126-97D3-4C35-9D201EE3F38956EA.pdf PDF
BCDA75E7-EC2E-694E-CB30EC7B8D89F683.pdf PDF
E99102BF-B146-146D-35DFAF9763C1170B.pdf PDF
44F2E64B-E391-5EAC-DD33927813E7BE98.xlsx XLSX spreadsheet
56D21EF1-090E-9236-DC87D4ABB226948A.pdf PDF
Show 40 more

Latest 50 of 145 listed here. See the rest on GovTribe.

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

P&I

LTD Paid & Incurred Exhibit
as of 7/31/2025
157775 - FRANKLIN COUNTY COOPERATIVE HEALTH IMPROVEMENT PRO
Experience Period *12345Claim LagTotal *
Experience Period From1/1/201/1/211/1/221/1/231/1/241/1/251/1/20
Experience Period To1/1/211/1/221/1/231/1/241/1/258/1/251/1/25
Months in period1212121212760

Average Lives 1,779 2,040 1,909 2,195 2,326 2,460 2,050

Paid Claims$306,511$628,842$112,625$242,854$226,112$0$1,516,944
Case Reserve$138,976$0$0$112,906$1,080,033$118,446$1,331,916
IBNR Reserve$0$0$0$0$15,294$263,482$15,294
Investment Credit($49,344)($55,432)($7,728)($19,244)($38,681)($4,518)($170,429)
Incurred Claims$396,143$573,410$104,897$336,516$1,282,759$377,411$2,693,725
Premium(Paid)$646,348$703,967$604,185$773,107$857,981$542,258$3,585,589
Rate0.6650.5320.5320.5320.5320.526
Premium (Adjusted)$511,391$696,223$597,539$764,603$848,543$542,258$3,418,299
Ann Adj Prm per E'ee$287$341$313$348$365$378$334

I.L.R. (Adjusted) 0.775 0.824 0.176 0.440 1.512 0.696 0.788

Open Claims100413118
Open/Closed Claims61561014151
Pending Claims0000212
Denied Claims89692034
Claim Incidence (per 1,000)3.377.353.144.566.703.335.13
Average Cost Per Claim$66,024$38,095$17,437$33,652$84,962$74,928$50,989
Average Reserve Per Claim$138,976$0$0$28,227$77,079$79,446$69,662
Monthly Indemnity$1,252$0$0$7,793$33,658$2,010$42,702
% Claims Still Open - Actual17%0%0%40%93%
* The Claim Lag period is incomplete for incidence and claim development. This period is excluded from the Total.

Claim List

LTD Claim Listing
as of 7/31/2025
157775 - FRANKLIN COUNTY COOPERATIVE HEALTH IMPROVEMENT PRO
Experience NumberReport NumberSubcodePaypointClaim NumberSocial Security StatusBirth DateAge of Claimant at Valuation DateGenderStatusDate of DisabilityMonthly Gross BenefitRegular Monthly BenefitTotal Benefit Paid To DateLBCSURVCOLACNC_CDReserve
0157775015777528000002742006040727SSP9/16/7550M031/3/20$ 1,922$ - 0$ 46,126NYN8000$ - 0Key
0157775015777596010001712007270901SSA1/1/7452F032/23/20$ 1,948$ - 0$ 17,212YYN8000$ - 0
0157775015777590000002742008141787SSP3/6/6659M033/19/20$ 2,011$ - 0$ 70,398NYN8000$ - 0Social Security Status
0157775015777593000001702011021070SSP3/21/7649F016/1/20$ 1,923$ - 0$ - 0YYN8000$ - 0CodeDescription
0157775015777596010001642009148934SSP1/28/6066M016/4/20$ 1,948$ - 0$ - 0NYN8000$ - 0SSASS benefits have been approved
0157775015777512000001612108238271SSP11/14/7055M016/9/20$ 2,480$ - 0$ - 0NYN8000$ - 0SSPSS status is pending (have not yet submitted or have submitted and not been denied twice)
0157775015777512000001652006088945SSP11/14/7055M016/9/20$ 2,378$ - 0$ - 0YYN8000$ - 0NEDClaimant is not eligible for SS or has been denied at least twice
0157775015777512000001742011091367SSP11/14/7055M036/9/20$ 2,378$ - 0$ 25,682YYN8000$ - 0
0157775015777593000001682101198088SSP10/25/6560F018/19/20$ 1,956$ - 0$ - 0YYN8000$ - 0Claim Status
0157775015777511600001642012178734NED8/9/5768M0110/2/20$ 2,267$ - 0$ 20,481YYN8000$ - 0CodeDescription
0157775015777593000001732103291096SSP4/18/9530F0110/8/20$ 2,040$ - 0$ - 0NYN8000$ - 000Active
015777501577756900000264201028851409/16/7352F0110/27/20$ 1,771$ - 0$ - 0NYN8000$ - 001Declined
0157775015777567000001702103311220NED10/18/6758F0010/29/20$ 2,366$ 1,252$ 63,837NYN8000$ 138,97602Waiting
0157775015777593000001752104260289NED3/15/6362M0311/26/20$ 2,102$ - 0$ 62,775NYN8000$ - 003Ended
0157775015777593000001742106250877NED9/22/7154F031/12/21$ 3,118$ - 0$ 12,783YYN8000$ - 004Inactive
0157775015777596000001752107201929SSP11/6/6065F031/18/21$ 1,905$ - 0$ 45,727YYN8000$ - 005Incomplete
0157775015777596000001692201248329SSP9/6/7253M032/18/21$ 5,014$ - 0$ 10,027YYN8000$ - 0PSPending
0157775015777570000001662106158256SSP6/4/7154M012/19/21$ 2,299$ - 0$ - 0YYN8000$ - 0
0157775015777593000001722108301723SSP12/26/7649F013/11/21$ 2,177$ - 0$ - 0YYN8000$ - 0
0157775015777593000001712109240822SSP4/22/7748F013/25/21$ 2,219$ - 0$ - 0NYN8000$ - 0
0157775015777593000001742109140377SSP10/16/9233F034/13/21$ 2,063$ - 0$ 31,363YYN8000$ - 0
0157775015777596000001732110011135NED6/8/7253M035/10/21$ 5,014$ - 0$ 128,364YYN8000$ - 0
0157775015777596010001742201031167SSP6/11/8639M035/21/21$ 2,841$ - 0$ 4,168NYN8000$ - 0
0157775015777593000001742111080788SSP8/7/8144F016/2/21$ 2,162$ - 0$ - 0YYN8000$ - 0
0157775015777540000001742108301747SSP9/2/6560M036/3/21$ 3,212$ - 0$ 54,810NYN8000$ - 0
0157775015777570000001672203298337NED9/2/7253F036/7/21$ 2,289$ - 0$ 96,140NYN8000$ - 0
0157775015777593000001612112038671SSP5/9/8738F037/20/21$ 2,162$ - 0$ 26,523NYN8000$ - 0
0157775015777593000001642108028964SSP5/9/8738F017/20/21$ 2,162$ - 0$ - 0YYN8000$ - 0
0157775015777593000001642107268804SSP2/16/8045F017/28/21$ 2,065$ - 0$ - 0NYN8000$ - 0
0157775015777593000001702112280910SSP1/20/6858F037/28/21$ 2,193$ - 0$ 6,580NYN8000$ - 0
0157775015777590000002642201078144SSP1/8/8838M018/12/21$ 2,100$ - 0$ - 0NYN8000$ - 0
0157775015777590000002732201121555SSP1/8/8838M018/12/21$ 2,100$ - 0$ - 0NYN8000$ - 0
0157775015777593000001742202231437SSP6/15/8936F039/10/21$ 2,237$ - 0$ 4,493YYN8000$ - 0
0157775015777570000002702204181680SSP3/12/8738F0310/23/21$ 1,744$ - 0$ 10,523YYN8000$ - 0
0157775015777596010001732203250775SSP8/21/7253M0310/23/21$ 5,014$ - 0$ 120,341YYN8000$ - 0
0157775015777596010001712205050491NED10/7/7649M0311/19/21$ 5,014$ - 0$ 60,335YYN8000$ - 0
0157775015777570000001702205170980SSP4/12/8936F0112/17/21$ 1,722$ - 0$ - 0YYN8000$ - 0
0157775015777567000001622207148032SSA4/30/5867F0312/20/21$ 1,726$ - 0$ 16,667NYN8000$ - 0
0157775015777544000002732206240135SSP7/20/6956F031/18/22$ 3,206$ - 0$ 6,520NYN8000$ - 0
0157775015777500010021712209050591NED12/25/6857F034/5/22$ 1,683$ - 0$ 5,369NYN8000$ - 0
0157775015777500010003642205098054SSP11/8/6263F014/6/22$ 1,456$ - 0$ - 0YYN8000$ - 0
0157775015777544000002672212018207SSP1/16/7056F035/27/22$ 3,032$ - 0$ 39,411NYN8000$ - 0
0157775015777570000001632208268793SSP2/13/9530M016/17/22$ 2,608$ - 0$ - 0YYN8000$ - 0
0157775015777563000002732211220026SSP2/18/5768F016/22/22$ 2,755$ - 0$ - 0YYN8000$ - 0
0157775015777544000002622306238562SSP1/19/9531F018/8/22$ 2,725$ - 0$ - 0NYN8000$ - 0
0157775015777544000002742304171567SSP2/17/9134M019/29/22$ 2,477$ - 0$ - 0NYN8000$ - 0
0157775015777511100002722303020014SSP4/15/7154F039/30/22$ 3,296$ - 0$ 3,186YYN8000$ - 0
0157775015777593000001752303270839SSA10/4/5669F0310/21/22$ 2,471$ - 0$ 41,423YYN8000$ - 0
0157775015777593000001742304111378NED4/22/7748F0311/9/22$ 2,786$ - 0$ 16,717YYN8000$ - 0
0157775015777570000001602212078270SSP4/14/9827F0112/7/22$ 2,298$ - 0$ - 0NYN8000$ - 0
0157775015777513000001602306078150SSP6/17/6659F032/17/23$ 3,161$ - 0$ 3,161NYN8000$ - 0
0157775015777513000001712307201042SSP6/17/6659F012/17/23$ 3,161$ - 0$ - 0NYN8000$ - 0
0157775015777512000002722307311464SSP10/10/6659M032/28/23$ 3,782$ - 0$ 28,116NYN8000$ - 0
0157775015777596010001662309138166SSP2/11/6857M013/27/23$ 5,446$ - 0$ - 0YYN8000$ - 0
0157775015777511000002752309181759NED6/19/5867F004/4/23$ 2,084$ 2,084$ 43,837NYN8000$ 18,757
0157775015777511400001682312138858NED4/24/5966F004/17/23$ 3,669$ 1,595$ 30,431NYN8000$ 23,930
0157775015777511400001732404031935SSP4/24/5966F014/18/23$ 3,669$ - 0$ - 0NYN8000$ - 0
0157775015777593000001752309220009SSP11/13/6461F014/22/23$ 2,216$ - 0$ - 0YYN8000$ - 0
0157775015777569000002702311130480SSP4/23/6362F016/12/23$ 2,007$ - 0$ - 0NYN8000$ - 0
0157775015777512000001722311271053SSP3/1/6065M006/26/23$ 2,521$ 2,108$ 39,251NYN8000$ 13,274
0157775015777593000001722311281104SSP2/3/6461F016/28/23$ 2,918$ - 0$ - 0YYN8000$ - 0
0157775015777570000001622307058862SSP6/4/7154M016/29/23$ 2,772$ - 0$ - 0NYN8000$ - 0
0157775015777570000002622307278542SSP12/9/7748F017/18/23$ 2,590$ - 0$ - 0YYN8000$ - 0
0157775015777593000002752312190049SSP2/15/7451F037/19/23$ 3,158$ - 0$ 6,738YYN8000$ - 0
0157775015777593000002742401010518NED9/19/7253F037/27/23$ 2,086$ - 0$ 1,182NYN8000$ - 0
0157775015777565000002742402021928NED7/5/6362F009/6/23$ 3,139$ 2,005$ 33,674YYN8000$ 56,945
0157775015777599970001752404260759SSP5/14/6263F0310/30/23$ 2,139$ - 0$ 1,070NYN8000$ - 0
0157775015777565000001722404230614SSP3/17/6362F0111/22/23$ 1,991$ - 0$ - 0YYN8000$ - 0
0157775015777568000002742405101268NED1/15/6264M0312/9/23$ 4,873$ - 0$ 55,395NYN8000$ - 0
0157775015777593000001662408148686SSP8/30/9134F001/19/24$ 2,424$ 2,424$ 29,091YYN8000$ 32,225
0157775015777593000001732406261016NED3/12/6164F002/23/24$ 2,757$ 2,757$ 27,570YYN8000$ 88,225
0157775015777593000002702405271850NED6/1/5768F003/15/24$ 2,984$ 2,984$ 29,838NYN8000$ 32,821
0157775015777567000001752411010049SSA2/7/8144F003/20/24$ 2,398$ 100$ 19,286NYN8000$ 16,450
0157775015777528000001682406188188SSP8/21/5966F034/17/24$ 2,762$ - 0$ 16,666NYN8000$ - 0
0157775015777593000001732411110395NED12/3/7253F005/10/24$ 2,937$ 2,937$ 23,496YYN8000$ 126,778
0157775015777540000001722412111884SSP10/2/8441M006/14/24$ 3,007$ 3,007$ 21,046NYN8000$ 145,528
0157775015777593000002712411140791SSP3/11/5867M016/14/24$ 3,083$ - 0$ - 0YYN8000$ - 0
0157775015777593000002712411150842SSP6/10/6362F006/15/24$ 3,306$ 3,306$ 23,143NYN8000$ 97,360
0157775015777590000002642409068314SSP8/7/5768F016/28/24$ 3,703$ - 0$ - 0YYN8000$ - 0
0157775015777569000002722412160054SSA3/4/7748F007/15/24$ 2,129$ 2,129$ 12,776YYN8000$ 68,258
0157775015777532000002742504170447SSP1/8/6462F029/16/24$ 2,524$ 2,524$ 5,627NYN8000$ 44,540
0157775015777593000001722503171284SSP11/12/7748F0010/16/24$ 2,372$ 2,372$ 7,196NYN8000$ 84,656
0157775015777599970001702503241570NED1/23/6363M0010/22/24$ 3,554$ 3,554$ 7,107NYN8000$ 191,899
0157775015777512500002732505010976SSP3/29/6560M0011/24/24$ 3,270$ 3,270$ 3,270YYN8000$ 52,929
0157775015777593000001612506068131SSP2/22/6065FPS12/6/24$ 2,415$ - 0$ - 0NYN8000$ 39,000
0157775015777570000001722505061123SSP5/16/9827FPS12/9/24$ 2,322$ - 0$ - 0YYN8000$ 39,000
0157775015777512000001722505281843SSP11/3/6560M0012/28/24$ 2,293$ 2,293$ - 0NYN8000$ 20,365
0157775015777588000002732506120345SSP6/7/7451F001/10/25$ 2,010$ 2,010$ - 0NYN8000$ 79,446
0157775015777593000002732506050125SSP9/2/7649F001/17/25$ 3,954$ - 0$ - 0YYN8000$ 39,000

File details come from the government source that posted it. Updated .