Civic Intelligence

Hy-Vee and Affiliates' Benefit Plan

990 • Fiscal year 2018 • EIN 42-1170511

Oct 01, 2017 to Sep 30, 2018

Wdm, IA
Siviq Scores

Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.

Liabilities / Assets

93rd percentile

0.84x

Higher debt load relative to assets than 93% of similar nonprofits.

2018 filings • 501(c)9 • $100M-$250M nonprofits • Source year 2018

Liabilities / Revenue

65th percentile

0.11x

Higher debt load relative to revenue than 65% of similar nonprofits.

2018 filings • 501(c)9 • $100M-$250M nonprofits • Source year 2018

Net Margin

27th percentile

-1.1%

Higher net margin than 27% of similar nonprofits.

2018 filings • 501(c)9 • $100M-$250M nonprofits • Source year 2018

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2018

Asset Growth

67th percentile

6.6%

Faster asset growth than 67% of similar nonprofits.

2018 filings • 501(c)9 • $100M-$250M nonprofits • Annualized from 2017 to 2018

Revenue Growth

23rd percentile

-1.9%

Faster revenue growth than 23% of similar nonprofits.

2018 filings • 501(c)9 • $100M-$250M nonprofits • Annualized from 2017 to 2018

Assets

Up

$26,874,066

Up $1,661,684 (+6.6%) from 2017

Net Assets

Down

$4,373,144

Down $1,112,450 (-20%) from 2017

Liabilities

Up

$22,500,922

Up $2,774,134 (+14%) from 2017

Revenue

Down

$195,835,074

Down $3,743,720 (-1.9%) from 2017

Expenses

Up

$198,034,291

Up $3,529,538 (+1.8%) from 2017

Net Income

Down

-$2,199,217

Down $7,273,258 (-143%) from 2017

Historical Trend

Balance Sheet Trend

The highlighted filing sits inside the broader history for assets, liabilities, and net assets.

$40M$30M$20M$10M$0-$10MAssets 2011: $13,480,360Liabilities 2011: $13,480,360Net Assets 2011: $02011Assets 2012: $15,872,469Liabilities 2012: $15,872,469Net Assets 2012: $02012Assets 2013: $19,174,455Liabilities 2013: $19,174,455Net Assets 2013: $02013Assets 2014: $18,816,592Liabilities 2014: $15,296,102Net Assets 2014: $3,520,4902014Assets 2015: $20,651,102Liabilities 2015: $16,929,957Net Assets 2015: $3,721,1452015Assets 2016: $21,124,767Liabilities 2016: $19,086,581Net Assets 2016: $2,038,1862016Assets 2017: $25,212,382Liabilities 2017: $19,726,788Net Assets 2017: $5,485,5942017Assets 2018: $26,874,066Liabilities 2018: $22,500,922Net Assets 2018: $4,373,1442018Assets 2019: $29,169,011Liabilities 2019: $25,356,205Net Assets 2019: $3,812,8062019Assets 2020: $29,863,544Liabilities 2020: $23,895,614Net Assets 2020: $5,967,9302020Assets 2021: $28,091,611Liabilities 2021: $26,350,940Net Assets 2021: $1,740,6712021Assets 2022: $23,465,030Liabilities 2022: $27,202,476Net Assets 2022: -$3,737,4462022Assets 2023: $32,189,368Liabilities 2023: $24,343,147Net Assets 2023: $7,846,2212023Assets 2024: $27,178,762Liabilities 2024: $27,588,292Net Assets 2024: -$409,5302024

Highlighted filing

2018

Assets$26,874,066
Liabilities$22,500,922
Net Assets$4,373,144

Operations Trend

Revenue, expenses, and net income across loaded years, with this filing highlighted.

$300M$200M$100M$0-$100MRevenue 2011: $120,197,908Expenses 2011: $120,197,908Net Income 2011: $02011Revenue 2012: $129,209,211Expenses 2012: $129,209,211Net Income 2012: $02012Revenue 2013: $139,877,352Expenses 2013: $139,877,352Net Income 2013: $02013Revenue 2014: $134,691,845Expenses 2014: $135,048,742Net Income 2014: -$356,8972014Revenue 2015: $161,554,274Expenses 2015: $161,211,533Net Income 2015: $342,7412015Revenue 2016: $178,537,753Expenses 2016: $177,768,952Net Income 2016: $768,8012016Revenue 2017: $199,578,794Expenses 2017: $194,504,753Net Income 2017: $5,074,0412017Revenue 2018: $195,835,074Expenses 2018: $198,034,291Net Income 2018: -$2,199,2172018Revenue 2019: $205,885,346Expenses 2019: $203,856,778Net Income 2019: $2,028,5682019Revenue 2020: $200,252,040Expenses 2020: $199,518,249Net Income 2020: $733,7912020Revenue 2021: $202,937,537Expenses 2021: $204,171,537Net Income 2021: -$1,234,0002021Revenue 2022: $205,365,119Expenses 2022: $210,689,163Net Income 2022: -$5,324,0442022Revenue 2023: $217,149,390Expenses 2023: $206,035,365Net Income 2023: $11,114,0252023Revenue 2024: $213,249,431Expenses 2024: $217,804,467Net Income 2024: -$4,555,0362024

Highlighted filing

2018

Revenue$195,835,074
Expenses$198,034,291
Net Income-$2,199,217
Filing Detail Status

This 2018 filing currently has summary financial data only. Detailed schedules, leadership, and program rows are not available for this filing yet.

Jump To
Filing Snapshot
Filing Period
Oct 1, 2017 to Sep 30, 2018
Mission and Program Overview

Mission

To provide quality, cost-effective and comprehensive medical, dental, life and disability benefits; to provide meaningful information, resources, and assistance; and to provide preventive and wellness-related interventions and programs.

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$27.2$27.6$0.41$213$218$4.56
2023Detailed filing. Detailed filing data is available for this year.$32.2$24.3$7.85$217$206$11.1
2022Detailed filing. Detailed filing data is available for this year.$23.5$27.2$3.74$205$211$5.32
2021Detailed filing. Detailed filing data is available for this year.$28.1$26.4$1.74$203$204$1.23
2020Detailed filing. Detailed filing data is available for this year.$29.9$23.9$5.97$200$200$0.73
2019Summary only. Only limited summary data is available for this year.$29.2$25.4$3.81$206$204$2.03
2018Summary only. Only limited summary data is available for this year.$26.9$22.5$4.37$196$198$2.20
2017Summary only. Only limited summary data is available for this year.$25.2$19.7$5.49$200$195$5.07
2016Summary only. Only limited summary data is available for this year.$21.1$19.1$2.04$179$178$0.77
2015Summary only. Only limited summary data is available for this year.$20.7$16.9$3.72$162$161$0.34
2014Summary only. Only limited summary data is available for this year.$18.8$15.3$3.52$135$135$0.36
2013Summary only. Only limited summary data is available for this year.$19.2$19.2$0.00$140$140$0.00
2012Summary only. Only limited summary data is available for this year.$15.9$15.9$0.00$129$129$0.00
2011Summary only. Only limited summary data is available for this year.$13.5$13.5$0.00$120$120$0.00