Civic Intelligence

Shell Medical Plan

990 • Fiscal year 2012 • EIN 74-2200128

Jan 01, 2012 to Dec 31, 2012

Phoenix, AZ
Siviq Scores

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

Liabilities / Assets

21st percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2012 filings • 501(c)9 • $250M-$1B nonprofits • Source year 2012

Liabilities / Revenue

11th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2012 filings • $250M-$1B nonprofits • Source year 2012

Net Margin

25th percentile

-2.2%

Higher net margin than 25% of similar nonprofits.

2012 filings • $250M-$1B nonprofits • Source year 2012

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2012

Asset Growth

2nd percentile

-39%

Faster asset growth than 2% of similar nonprofits.

2012 filings • 501(c)9 • $250M-$1B nonprofits • Annualized from 2011 to 2012

Revenue Growth

59th percentile

5.5%

Faster revenue growth than 59% of similar nonprofits.

2012 filings • $250M-$1B nonprofits • Annualized from 2011 to 2012

Assets

Down

$16,477,327

Down $10,642,033 (-39%) from 2011

Net Assets

Down

$16,477,327

Down $10,642,033 (-39%) from 2011

Liabilities

Flat

$0

Flat from 2011

Revenue

Up

$488,765,569

Up $25,673,324 (+5.5%) from 2011

Expenses

Up

$499,406,328

Up $37,077,266 (+8.0%) from 2011

Net Income

Down

-$10,640,759

Down $11,403,942 (-1494%) from 2011

Historical Trend

Balance Sheet Trend

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

$100M$50M$0Assets 2010: $26,353,018Liabilities 2010: $0Net Assets 2010: $26,353,0182010Assets 2011: $27,119,360Liabilities 2011: $0Net Assets 2011: $27,119,3602011Assets 2012: $16,477,327Liabilities 2012: $0Net Assets 2012: $16,477,3272012Assets 2013: $22,654,258Liabilities 2013: $0Net Assets 2013: $22,654,2582013Assets 2014: $93,391,180Liabilities 2014: $0Net Assets 2014: $93,391,1802014Assets 2015: $52,549,065Liabilities 2015: $0Net Assets 2015: $52,549,0652015Assets 2016: $58,427,273Liabilities 2016: $0Net Assets 2016: $58,427,2732016Assets 2017: $61,665,299Liabilities 2017: $0Net Assets 2017: $61,665,2992017Assets 2018: $35,946,509Liabilities 2018: $0Net Assets 2018: $35,946,5092018Assets 2019: $42,010,617Liabilities 2019: $0Net Assets 2019: $42,010,6172019Assets 2020: $75,038,733Liabilities 2020: $0Net Assets 2020: $75,038,7332020Assets 2021: $59,819,611Liabilities 2021: $0Net Assets 2021: $59,819,6112021Assets 2022: $88,722,408Liabilities 2022: $0Net Assets 2022: $88,722,4082022Assets 2023: $34,783,734Liabilities 2023: $0Net Assets 2023: $34,783,7342023Assets 2024: $0Liabilities 2024: $0Net Assets 2024: $02024

Highlighted filing

2012

Assets$16,477,327
Liabilities$0
Net Assets$16,477,327

Operations Trend

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

$800M$600M$400M$200M$0-$200MRevenue 2010: $441,766,966Expenses 2010: $443,407,976Net Income 2010: -$1,641,0102010Revenue 2011: $463,092,245Expenses 2011: $462,329,062Net Income 2011: $763,1832011Revenue 2012: $488,765,569Expenses 2012: $499,406,328Net Income 2012: -$10,640,7592012Revenue 2013: $536,920,747Expenses 2013: $530,745,476Net Income 2013: $6,175,2712013Revenue 2014: $618,775,202Expenses 2014: $548,037,487Net Income 2014: $70,737,7152014Revenue 2015: $571,185,918Expenses 2015: $612,027,816Net Income 2015: -$40,841,8982015Revenue 2016: $617,181,215Expenses 2016: $611,289,900Net Income 2016: $5,891,3152016Revenue 2017: $579,961,309Expenses 2017: $576,676,411Net Income 2017: $3,284,8982017Revenue 2018: $546,094,116Expenses 2018: $571,794,295Net Income 2018: -$25,700,1792018Revenue 2019: $574,863,871Expenses 2019: $568,815,435Net Income 2019: $6,048,4362019Revenue 2020: $535,906,788Expenses 2020: $502,878,672Net Income 2020: $33,028,1162020Revenue 2021: $509,542,348Expenses 2021: $524,763,374Net Income 2021: -$15,221,0262021Revenue 2022: $481,084,441Expenses 2022: $452,121,857Net Income 2022: $28,962,5842022Revenue 2023: $342,743,076Expenses 2023: $396,521,621Net Income 2023: -$53,778,5452023Revenue 2024: $137,927,620Expenses 2024: $172,932,187Net Income 2024: -$35,004,5672024

Highlighted filing

2012

Revenue$488,765,569
Expenses$499,406,328
Net Income-$10,640,759
Filing Detail Status

This 2012 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
Jan 1, 2012 to Dec 31, 2012
Mission and Program Overview

Mission

Provide certain health wellness accident, life, disability, and other welfare benefits for eligible employees and their dependents

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.$0.00$0.00$0.00$138$173$35.0
2023Detailed filing. Detailed filing data is available for this year.$34.8$0.00$34.8$343$397$53.8
2022Detailed filing. Detailed filing data is available for this year.$88.7$0.00$88.7$481$452$29.0
2021Detailed filing. Detailed filing data is available for this year.$59.8$0.00$59.8$510$525$15.2
2020Detailed filing. Detailed filing data is available for this year.$75.0$0.00$75.0$536$503$33.0
2019Detailed filing. Detailed filing data is available for this year.$42.0$0.00$42.0$575$569$6.05
2018Detailed filing. Detailed filing data is available for this year.$35.9$0.00$35.9$546$572$25.7
2017Summary only. Only limited summary data is available for this year.$61.7$0.00$61.7$580$577$3.28
2016Summary only. Only limited summary data is available for this year.$58.4$0.00$58.4$617$611$5.89
2015Summary only. Only limited summary data is available for this year.$52.5$0.00$52.5$571$612$40.8
2014Summary only. Only limited summary data is available for this year.$93.4$0.00$93.4$619$548$70.7
2013Summary only. Only limited summary data is available for this year.$22.7$0.00$22.7$537$531$6.18
2012Summary only. Only limited summary data is available for this year.$16.5$0.00$16.5$489$499$10.6
2011Summary only. Only limited summary data is available for this year.$27.1$0.00$27.1$463$462$0.76
2010Summary only. Only limited summary data is available for this year.$26.4$0.00$26.4$442$443$1.64