Attachment N Historical LTD and STD Premium Payments.xlsx

XLSX spreadsheet 13 KB Posted

Attached to
State of Nebraska Short-Term Disability (STD) and Long-Term Disability (LTD) Insurance
Solicitation number
120084 O5
Issued by
Lancaster County, Nebraska

About this file

Written by GovTribe AI ·

This document contains historical premium payments for Long-Term Disability (LTD) and Short-Term Disability (STD) insurance coverage over a five-year period across multiple plan years. The data covers the period from July 2019 through June 2024, broken down by month. The LTD premiums range from approximately $67,000 to over $84,000 per month, while the STD premiums range from around $87,000 to over $164,000 per month. The document provides detailed information on the premium payments for each plan year, with totals for each year shown at the end of the respective sections.

The historical data presented in this document would be useful for evaluating the costs associated with the LTD and STD insurance coverage and for budgeting and planning purposes. The information could also be used to analyze trends in premium payments over time and to assess the impact of any changes in plan design or coverage levels.

View the file

Other files

File Type Posted
120084 O5 SOLICITATION ADDENDUM ONE final.docx DOCX document
Attachment I - STD Payment Details.xlsx XLSX spreadsheet
120084 O5- Addendum Two- Revised Schedule of Events.pdf PDF
120084 O5 RFP STD LTD Insurance.docx DOCX document
Attachment P Claim details for SAE from 07.01.2019.pdf PDF
Attachment A Requirements Matrix.docx DOCX document
Attachment C Current Short Term Disability Benefits.pdf PDF
UnitedHealthCare BAFO cost.pdf PDF
120084 O5 Cost Proposal.xlsx XLSX spreadsheet
BAFO 120084 O5 FinalEvaluationDocument.pdf PDF
Attachment F - LTD Group Paid by month.pdf PDF
Attachment J - LTD Claims Status.pdf PDF
List of Respondents.pdf PDF
Attachment G- STD Group Paid by month.pdf PDF
120084 O5 RFP STD LTD Insurance.pdf PDF
Attachment K - STD Claims Status.pdf PDF
UnitedHealthCare (stacked).pdf PDF
120084 O5- Addendum Three - Revised Schedule of Events.pdf PDF
Metlife Response (stacked).pdf PDF
Addendum 4 - Revised Schedule of Events.pdf PDF
120084 O5 Intent to Award.pdf PDF
Attachment N Historical LTD and STD Premium Payments.xlsx XLSX spreadsheet
Attachment O October 2024 STD LTD Monthly Invoice.pdf PDF
Attachment E - STD open and closed paid claim summary.pdf PDF
120084 O5 SolicitationEvaluationCriteria.pdf PDF
Metlife Response BAFO cost.pdf PDF
Attachment D - LTD open and closed paid claim summary.pdf PDF
120084 O5 BAFO Cost Proposal.xlsx XLSX spreadsheet
Attachment H - LTD Payment Details.xlsx XLSX spreadsheet
Attachment M EligibilityCensus.xlsx XLSX spreadsheet
Attachment L Census LTD STD.xlsx XLSX spreadsheet
Attachment B Current Long Term Disability Benefits.pdf PDF
120084 O5 RFP STD LTD Insurance.docx DOCX document
Attachment L Census LTD STD.xlsx XLSX spreadsheet
Attachment G- STD Group Paid by month.pdf PDF
120084 O5 SOLICITATION ADDENDUM ONE final.docx DOCX document
Attachment B Current Long Term Disability Benefits.pdf PDF
Attachment I - STD Payment Details.xlsx XLSX spreadsheet
120084 O5 Cost Proposal.xlsx XLSX spreadsheet
Attachment O October 2024 STD LTD Monthly Invoice.pdf PDF
Attachment J - LTD Claims Status.pdf PDF
Metlife Response (stacked).pdf PDF
Attachment H - LTD Payment Details.xlsx XLSX spreadsheet
Attachment K - STD Claims Status.pdf PDF
Metlife Response BAFO cost.pdf PDF
120084 O5 Intent to Award.pdf PDF
Attachment E - STD open and closed paid claim summary.pdf PDF
120084 O5- Addendum Three - Revised Schedule of Events.pdf PDF
Attachment D - LTD open and closed paid claim summary.pdf PDF
Attachment C Current Short Term Disability Benefits.pdf PDF
Show 40 more

Latest 50 of 146 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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

LTD Premium Payments

HISTORICAL LTD PREMIUM PAYMENTS
LTD Premium Payments for 5 Plan Years
Plan Year 19/206 Month Elimination
July 2019$67,061.35
August 2019$68,375.09
September 2019$68,141.37
October 2019$68,216.02
November 2019$68,386.53
December 2019$68,818.90
January 2020$68,893.88
February 2020$69,808.90
March 2020$68,603.19
April 2020$68,534.26
May 2020$68,949.87
June 2020$68,935.65
Plan Year Totals$822,725.01
Plan Year 20/216 Month Elimination
July 2020$70,327.55
August 2020$70,514.70
September 2020$70,521.99
October 2020$70,640.78
November 2020$70,476.37
December 2020$70,587.29
January 2021$70,068.06
February 2021$69,722.15
March 2021$69,906.84
April 2021$69,729.80
May 2021$69,785.32
June 2021$69,077.60
Plan Year Totals$841,358.45
Plan Year 21/226 Month Elimination
July 2021$70,525.81
August 2021$70,347.75
September 2021$70,081.39
October 2021$69,905.67
November 2021$69,906.64
December 2021$72,304.07
January 2022$72,984.69
February 2022$73,215.86
March 2022$73,508.94
April 2022$74,009.20
May 2022$74,174.64
June 2022$74,092.85
Plan Year Totals$865,057.51
Plan Year 22/236 Month Elimination
July 2022$76,526.99
August 2022$76,914.96
September 2022$76,798.98
October 2022$76,874.36
November 2022$77,069.78
December 2022$77,407.62
January 2023$76,869.88
February 2023$76,698.87
March 2023$77,104.51
April 2023$76,946.55
May 2023$77,022.90
June 2023$76,776.93
Plan Year Totals$923,012.33
Plan Year 23/246 Month Elimination
July 2023$83,161.99
August 2023$84,207.68
September 2023$84,242.92
October 2023$84,115.21
November 2023$84,723.10
December 2023$84,599.02
January 2024$84,026.58
February 2024$83,517.41
March 2024$83,818.70
April 2024$83,768.83
May 2024$83,309.92
June 2024$82,891.96
Plan Year Totals$1,006,383.32

STD Premium Payments

HISTORICAL STD PREMIUM PAYMENTS
STD Premium Payments for 5 Plan Years
Plan Year 19/201st day injury, 8th day sickness
July 2019$87,337.06
August 2019$89,532.35
September 2019$90,856.90
October 2019$91,843.99
November 2019$93,294.36
December 2019$95,594.13
January 2020$96,199.74
February 2020$99,745.98
March 2020$99,855.36
April 2020$100,650.99
May 2020$104,448.21
June 2020$103,514.92
Plan Year Totals$1,152,873.99
Plan Year 20/211st day injury, 8th day sickness
July 2020$102,141.03
August 2020$103,375.18
September 2020$104,433.03
October 2020$106,429.89
November 2020$106,176.09
December 2020$106,154.35
January 2021$107,175.31
February 2021$107,289.11
March 2021$107,933.23
April 2021$107,939.67
May 2021$107,765.83
June 2021$107,061.75
Plan Year Totals$1,273,874.47
Plan Year 21/221st day injury, 8th day sickness
July 2021$111,117.32
August 2021$110,320.65
September 2021$110,105.80
October 2021$109,730.64
November 2021$109,806.15
December 2021$116,562.53
January 2022$122,474.20
February 2022$124,432.94
March 2022$126,730.80
April 2022$130,588.49
May 2022$132,509.71
June 2022$134,986.67
Plan Year Totals$1,439,365.90
Plan Year 22/231st day injury, 8th day sickness
July 2022$132,855.98
August 2022$135,513.97
September 2022$136,895.47
October 2022$137,925.12
November 2022$138,967.23
December 2022$141,032.35
January 2023$141,739.26
February 2023$142,804.27
March 2023$144,870.09
April 2023$145,407.66
May 2023$147,620.61
June 2023$148,532.22
Plan Year Totals$1,694,164.23
Plan Year 23/241st day injury, 8th day sickness
July 2023$157,319.83
August 2023$159,511.01
September 2023$159,382.64
October 2023$161,282.30
November 2023$163,408.54
December 2023$163,678.82
January 2024$162,982.99
February 2024$163,445.25
March 2024$163,039.99
April 2024$164,895.61
May 2024$164,290.01
June 2024$164,103.30
Plan Year Totals$1,947,340.29

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