Civic Intelligence

Shell Medical Plan

990 • Fiscal year 2022 • EIN 74-2200128

Jan 01, 2022 to Dec 31, 2022 • Filed on Nov 03, 2023

Organization ProfileN/A
PO Box 53456 S4101-22gPhoenix, AZ 85072

(602) 562-0883

Siviq Scores

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

Liabilities / Assets

23rd percentile

0.00x

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

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

Liabilities / Revenue

22nd percentile

0.00x

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

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

Net Margin

60th percentile

6.0%

Higher net margin than 60% of similar nonprofits.

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

Top Officer Pay

50th percentile

$56,600

Higher top officer pay than 50% of similar nonprofits.

Top officer pay equals 0.0% of source-year revenue.

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

Asset Growth

98th percentile

48%

Faster asset growth than 98% of similar nonprofits.

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

Revenue Growth

37th percentile

-5.6%

Faster revenue growth than 37% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets23rd percentile

Assets

Up

$88,722,408

Up $28,902,797 (+48%) from 2021

Net Assets

Up

$88,722,408

Up $28,902,797 (+48%) from 2021

Liabilities

Flat

$0

Flat from 2021

Revenue And Expenses
Liabilities / Revenue22nd percentileNet Margin60th percentile

Revenue

Down

$481,084,441

Down $28,457,907 (-5.6%) from 2021

Expenses

Down

$452,121,857

Down $72,641,517 (-14%) from 2021

Net Income

Up

$28,962,584

Up $44,183,610 (+290%) from 2021

Historical Trend

Balance Sheet Trend

Asset Growth98th percentile

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

2022

Assets$88,722,408
Liabilities$0
Net Assets$88,722,408
Open 2022 Filing

Operations Trend

Revenue Growth37th percentile

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

2022

Revenue$481,084,441
Expenses$452,121,857
Net Income$28,962,584
Open 2022 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2022 to Dec 31, 2022
Signed
Nov 3, 2023
Return Version
2022v5.0
Gross Receipts
$481,084,441
Mission and Program Overview

Mission

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

Balance Sheet Detail
LineBeginningEndChange
Assets
Savings and Temporary Cash Investments$59,817,504$88,431,484▲ $28,613,980
Cap Stk Tr Prin Current Funds$59,819,611$88,431,484▲ $28,611,873
Accounts Receivable-$290,924-
Rtn Earn Endowment Incm Other Fnds-$290,924-
Cash and Non-Interest-Bearing Accounts$2,107--
Total Assets$59,819,611$88,722,408▲ $28,902,797
Liabilities
Total Liabilities$0$0→ $0
Net Assets / Fund Balance
Total Net Assets Fund Balance$59,819,611$88,722,408▲ $28,902,797
Total Liabilities and Net Assets / Fund Balance$59,819,611$88,722,408▲ $28,902,797
Compensation and Service Providers
Top Officer Pay50th percentile

Employees

NameTitleBaseTotal
-Trustee$56,600$56,600

Board Members and Trustees

NameTitle
Marvin E OdumPresident
Candida WolframAsst. Secretary
Hector PinedaAsst. Secretary
John M EsquivelAsst. Secretary
Lynn S BorogemierAsst. Secretary
Stephanie J PaulAsst. Secretary
Tabatha R BakerAsst. Secretary
A M NolteController
Julian DalzellSenior VP
William C LowreySenior VP
Richard MennitiTreasurer
T T ColesVP
Cynthia a DeereVP Finance
B P MalnakVP Gov/t Affairs
Revenue and Support

Revenue Composition

Contributions and Grants
$0
Program Service Revenue
$479,427,137
Investment Income
$1,068,408
Other Revenue
$588,896
Change in Net Assets
$28,962,584
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Other Expenses$11,301,902
Salaries, Compensation, and Employee Benefits$56,600
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Benefits to Members$440,763,355--$440,763,355
Other Expenses$11,301,902--$11,301,902
Current Officers, Directors, Trustees, and Key Employees$56,600--$56,600
Total Functional Expenses$452,121,857$0$0$452,121,857
Fundraising, Events, and Gaming
Fundraising activities
No
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

Line ItemAmount
Professional Fundraising Fees$0
Political and Lobbying Activity
Political campaign activity
No
Subject to proxy tax
No
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
No
Annual disclosure for covered persons
Yes
Audit committee
Yes
Backup withholding compliance
Yes
Business relationship with 35% controlled entity
No
Business relationship with family members
No
Business relationship with organization members
No
Material changes to governing documents
No
Compensation from other sources disclosed
No
CEO compensation reviewed
No
Other officer compensation reviewed
No
Conflict-of-interest policy
Yes
Audited financial statements prepared
No
Key decisions subject to board approval
No
Management duties delegated
No

Governance Explanations

Form 990, Page 6, Part VI, Line 11-description of Process for Review

“The sole trustee receives and reviews the form 990”

EXPLANATION FOR FORM 990, PAGE 6, PART VI, LINE 12C

“The organization complies with the same policy and enforcement as its trustee”

Form 990, Page 6, Part VI, Line 19

“No documents available to the public”

Filing and Contact Details

Filer

Filer Name
Shell Medical Plan
EIN
74-2200128
Phone
6025620883
Address
PO BOX 53456 S4101-22G, PHOENIX, AZ 85072

Signing Officer

Name
-
Title
Trustee
Phone
6025620883
Signed
2023-11-03
Discuss with paid preparer
Yes

Organization Details

Principal Officer
Principal Financial Group
Formed
2002
Legal Domicile
TX
Voting Board Members
1
Independent Board Members
0
Employees
0

Preparer

Firm
Pwc US Tax Llp
Address
301 GRANT STREET 45TH FLOOR, PITTSBURGH, PA 15219
Preparer
Laura B Strobel
Phone
4123556000
Supplemental Narrative

Additional Explanations

Part IV, Line 12B

“The organization was included in consolidated independent audited financial statements but did not obtain separate independent audited financial statements for the year. The orgnization opts out of completing schedule d, parts xi and xii.”

Explanation for Form 990, Part XI, Line 9

“Beginning asset basis adjustment: ($59,789), rounding: $2”

Raw XML Appendix367 raw XML fields

This appendix keeps the raw XML leaves available for debugging and edge-case review. The human report above is the primary experience.

Path#Value
IRS990/AccountantCompileOrReviewInd0false
IRS990/AccountsReceivableGrp/EOYAmt0290924
IRS990/ActivitiesConductedPrtshpInd0false
IRS990/ActivityOrMissionDesc0PROVIDE CERTAIN HEALTH WELLNESS ACCIDENT, LIFE, DISABILITY, AND OTHER WELFARE BENEFITS FOR ELIGIBLE EMPLOYEES AND THEIR DEPENDENTS
IRS990/AnnualDisclosureCoveredPrsnInd0true
IRS990/AuditCommitteeInd0true
IRS990/BackupWthldComplianceInd0true
IRS990/BenefitsToMembersGrp/ProgramServicesAmt0440763355
IRS990/BenefitsToMembersGrp/TotalAmt0440763355
IRS990/BooksInCareOfDetail/PersonNm0PRINCIPAL BANK - PCS TAX
IRS990/BooksInCareOfDetail/PhoneNum06025620883
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 10316
IRS990/BooksInCareOfDetail/USAddress/CityNm0DES MOINES
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IA
IRS990/BooksInCareOfDetail/USAddress/ZIPCd050306
IRS990/BusinessRlnWith35CtrlEntInd0false
IRS990/BusinessRlnWithFamMemInd0false
IRS990/BusinessRlnWithOrgMemInd0false
IRS990/CapStkTrPrinCurrentFundsGrp/BOYAmt059819611
IRS990/CapStkTrPrinCurrentFundsGrp/EOYAmt088431484
IRS990/CashNonInterestBearingGrp/BOYAmt02107
IRS990/ChangeToOrgDocumentsInd0false
IRS990/CollectionsOfArtInd0false
IRS990/CompCurrentOfcrDirectorsGrp/ProgramServicesAmt056600
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt056600
IRS990/CompensationFromOtherSrcsInd0false
IRS990/CompensationProcessCEOInd0false
IRS990/CompensationProcessOtherInd0false
IRS990/ConflictOfInterestPolicyInd0true
IRS990/ConservationEasementsInd0false
IRS990/ConsolidatedAuditFinclStmtInd0false
IRS990/CreditCounselingInd0false
IRS990/CYBenefitsPaidToMembersAmt0440763355
IRS990/CYContributionsGrantsAmt00
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt01068408
IRS990/CYOtherExpensesAmt011301902
IRS990/CYOtherRevenueAmt0588896
IRS990/CYProgramServiceRevenueAmt0479427137
IRS990/CYRevenuesLessExpensesAmt028962584
IRS990/CYSalariesCompEmpBnftPaidAmt056600
IRS990/CYTotalExpensesAmt0452121857
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt0481084441
IRS990/DecisionsSubjectToApprovaInd0false
IRS990/DeductibleArtContributionInd0false
IRS990/DeductibleNonCashContriInd0false
IRS990/DelegationOfMgmtDutiesInd0false
IRS990/Desc0PROVIDE CERTAIN HEALTH WELLNESS ACCIDENT, LIFE, DISABILITY, AND OTHER WELFARE BENEFITS FOR ELIGIBLE EMPLOYEES AND THEIR DEPENDENTS
IRS990/DescribedInSection501c3Ind0false
IRS990/DisregardedEntityInd0false
IRS990/DocumentRetentionPolicyInd0true
IRS990/DonorAdvisedFundInd0false
IRS990/DonorRstrOrQuasiEndowmentsInd0false
IRS990/ElectionOfBoardMembersInd0false
IRS990/EmployeeCnt00
IRS990/ExcsTaxSect4951Or4952Or4953Ind0false
IRS990/FamilyOrBusinessRlnInd0false
IRS990/FederalGrantAuditRequiredInd0false
IRS990/ForeignActivitiesInd0false
IRS990/ForeignFinancialAccountInd0false
IRS990/ForeignOfficeInd0false
IRS990/Form8282PropertyDisposedOfInd0false
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt01.0
IRS990/Form990PartVIISectionAGrp/BusinessName/BusinessNameLine1Txt0PRINCIPAL BANK - PCS TAX
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd2X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd3X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd4X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd5X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd6X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd7X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd8X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd9X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd10X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd11X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd12X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd13X
IRS990/Form990PartVIISectionAGrp/InstitutionalTrusteeInd0X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt10
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt20
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt30
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt40
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt50
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt60
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt70
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt80
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt90
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt100
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt110
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt120
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt130
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt140
IRS990/Form990PartVIISectionAGrp/PersonNm0MARVIN E ODUM
IRS990/Form990PartVIISectionAGrp/PersonNm1JULIAN DALZELL
IRS990/Form990PartVIISectionAGrp/PersonNm2WILLIAM C LOWREY
IRS990/Form990PartVIISectionAGrp/PersonNm3T T COLES
IRS990/Form990PartVIISectionAGrp/PersonNm4CYNTHIA A DEERE
IRS990/Form990PartVIISectionAGrp/PersonNm5B P MALNAK
IRS990/Form990PartVIISectionAGrp/PersonNm6RICHARD MENNITI
IRS990/Form990PartVIISectionAGrp/PersonNm7A M NOLTE
IRS990/Form990PartVIISectionAGrp/PersonNm8LYNN S BOROGEMIER
IRS990/Form990PartVIISectionAGrp/PersonNm9JOHN M ESQUIVEL
IRS990/Form990PartVIISectionAGrp/PersonNm10HECTOR PINEDA
IRS990/Form990PartVIISectionAGrp/PersonNm11STEPHANIE J PAUL
IRS990/Form990PartVIISectionAGrp/PersonNm12CANDIDA WOLFRAM
IRS990/Form990PartVIISectionAGrp/PersonNm13TABATHA R BAKER
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt70
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt80
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt90
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt100
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt110
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt120
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt130
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt1456600
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt70
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt80
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt90
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt100
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt110
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt120
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt130
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt140
IRS990/Form990PartVIISectionAGrp/TitleTxt0PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt1SENIOR VP
IRS990/Form990PartVIISectionAGrp/TitleTxt2SENIOR VP
IRS990/Form990PartVIISectionAGrp/TitleTxt3VP
IRS990/Form990PartVIISectionAGrp/TitleTxt4VP FINANCE
IRS990/Form990PartVIISectionAGrp/TitleTxt5VP GOV/T AFFAIRS
IRS990/Form990PartVIISectionAGrp/TitleTxt6TREASURER
IRS990/Form990PartVIISectionAGrp/TitleTxt7CONTROLLER
IRS990/Form990PartVIISectionAGrp/TitleTxt8ASST. SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt9ASST. SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt10ASST. SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt11ASST. SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt12ASST. SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt13ASST. SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt14TRUSTEE
IRS990/Form990ProvidedToGvrnBodyInd0true
IRS990/FormationYr02002
IRS990/FormerOfcrEmployeesListedInd0false
IRS990/FSAuditedBasisGrp/ConsolidatedBasisFinclStmtInd0X
IRS990/FSAuditedInd0true
IRS990/FundraisingActivitiesInd0false
IRS990/GamingActivitiesInd0false
IRS990/GoverningBodyVotingMembersCnt01
IRS990/GrantsToIndividualsInd0false
IRS990/GrantsToOrganizationsInd0false
IRS990/GrantToRelatedPersonInd0false
IRS990/GrossReceiptsAmt0481084441
IRS990/GroupReturnForAffiliatesInd0false
IRS990/IncludeFIN48FootnoteInd0false
IRS990/IndependentAuditFinclStmtInd0false
IRS990/IndependentVotingMemberCnt00
IRS990/IndoorTanningServicesInd0false
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIInd0X
IRS990/InvestmentIncomeGrp/ExclusionAmt01068408
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt01068408
IRS990/InvestmentInJointVentureInd0false
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LegalDomicileStateCd0TX
IRS990/LoanOutstandingInd0false
IRS990/LocalChaptersInd0false
IRS990/MaterialDiversionOrMisuseInd0false
IRS990/MembersOrStockholdersInd0false
IRS990/MethodOfAccountingCashInd0X
IRS990/MinutesOfCommitteesInd0true
IRS990/MinutesOfGoverningBodyInd0true
IRS990/MiscellaneousRevenueGrp/ExclusionAmt0551497
IRS990/MiscellaneousRevenueGrp/TotalRevenueColumnAmt0551497
IRS990/MissionDesc0PROVIDE CERTAIN HEALTH WELLNESS ACCIDENT, LIFE, DISABILITY, AND OTHER WELFARE BENEFITS FOR ELIGIBLE EMPLOYEES AND THEIR DEPENDENTS
IRS990/MoreThan5000KToIndividualsInd0false
IRS990/MoreThan5000KToOrgInd0false
IRS990/NetAssetsOrFundBalancesBOYAmt059819611
IRS990/NetAssetsOrFundBalancesEOYAmt088722408
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NondeductibleContributionsInd0false
IRS990/OfficerMailingAddressInd0false
IRS990/OperateHospitalInd0false
IRS990/Organization501cInd0X
IRS990/OrgDoesNotFollowFASB117Ind0X
IRS990/OtherChangesInNetAssetsAmt0-59787
IRS990/OtherExpensesGrp/Desc0ADMINISTRATIVE EXPENSES
IRS990/OtherExpensesGrp/ProgramServicesAmt011301902
IRS990/OtherExpensesGrp/TotalAmt011301902
IRS990/OtherRevenueMiscGrp/BusinessCd0900099
IRS990/OtherRevenueMiscGrp/Desc0OTHER INCOME
IRS990/OtherRevenueMiscGrp/ExclusionAmt037399
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt037399
IRS990/OtherRevenueTotalAmt0588896
IRS990/PartialLiquidationInd0false
IRS990/PayPremiumsPrsnlBnftCntrctInd0false
IRS990/PoliticalCampaignActyInd0false
IRS990/PrincipalOfficerNm0PRINCIPAL FINANCIAL GROUP
IRS990/ProfessionalFundraisingInd0false
IRS990/ProgramServiceRevenueGrp/BusinessCd0525100
IRS990/ProgramServiceRevenueGrp/BusinessCd1900099
IRS990/ProgramServiceRevenueGrp/BusinessCd2900099
IRS990/ProgramServiceRevenueGrp/Desc0EMPLOYER CONTRIBUTIONS
IRS990/ProgramServiceRevenueGrp/Desc1REIMBURSEMENTS
IRS990/ProgramServiceRevenueGrp/Desc2ACCRUED INCOME
IRS990/ProgramServiceRevenueGrp/ExclusionAmt0475522055
IRS990/ProgramServiceRevenueGrp/ExclusionAmt13614158
IRS990/ProgramServiceRevenueGrp/ExclusionAmt2290924
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt0475522055
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt13614158
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt2290924
IRS990/ProhibitedTaxShelterTransInd0false
IRS990/PYBenefitsPaidToMembersAmt0507648362
IRS990/PYExcessBenefitTransInd0false
IRS990/PYInvestmentIncomeAmt026953
IRS990/PYOtherExpensesAmt017058412
IRS990/PYOtherRevenueAmt032
IRS990/PYProgramServiceRevenueAmt0509515363
IRS990/PYRevenuesLessExpensesAmt0-15221026
IRS990/PYSalariesCompEmpBnftPaidAmt056600
IRS990/PYTotalExpensesAmt0524763374
IRS990/PYTotalRevenueAmt0509542348
IRS990/QuidProQuoContributionsInd0false
IRS990/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990/ReconcilationRevenueExpnssAmt028962584
IRS990/RegularMonitoringEnfrcInd0true
IRS990/RelatedEntityInd0true
IRS990/RelatedOrganizationCtrlEntInd0false
IRS990/ReportInvestmentsOtherSecInd0false
IRS990/ReportLandBuildingEquipmentInd0false
IRS990/ReportOtherAssetsInd0false
IRS990/ReportOtherLiabilitiesInd0false
IRS990/ReportProgramRelatedInvstInd0false
IRS990/RtnEarnEndowmentIncmOthFndsGrp/EOYAmt0290924
IRS990/SavingsAndTempCashInvstGrp/BOYAmt059817504
IRS990/SavingsAndTempCashInvstGrp/EOYAmt088431484
IRS990/ScheduleBRequiredInd0false
IRS990/ScheduleJRequiredInd0false
IRS990/ScheduleORequiredInd0true
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0THE ORGANIZATION WAS INCLUDED IN CONSOLIDATED INDEPENDENT AUDITED FINANCIAL STATEMENTS BUT DID NOT OBTAIN SEPARATE INDEPENDENT AUDITED FINANCIAL STATEMENTS FOR THE YEAR. THE ORGNIZATION OPTS OUT OF COMPLETING SCHEDULE D, PARTS XI AND XII.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1THE SOLE TRUSTEE RECEIVES AND REVIEWS THE FORM 990
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2THE ORGANIZATION COMPLIES WITH THE SAME POLICY AND ENFORCEMENT AS ITS TRUSTEE
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3NO DOCUMENTS AVAILABLE TO THE PUBLIC
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4BEGINNING ASSET BASIS ADJUSTMENT: ($59,789), ROUNDING: $2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Part IV, Line 12b
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990, PAGE 6, PART VI, LINE 11-DESCRIPTION OF PROCESS FOR REVIEW
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2EXPLANATION FOR FORM 990, PAGE 6, PART VI, LINE 12c
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990, PAGE 6, PART VI, LINE 19
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4EXPLANATION FOR FORM 990, PART XI, LINE 9
IRS990ScheduleR/AssetExchangeInd0false
IRS990ScheduleR/AssetPurchaseFromOtherOrgInd0false
IRS990ScheduleR/AssetSaleToOtherOrgInd0false
IRS990ScheduleR/DivRelatedOrganizationInd0false
IRS990ScheduleR/GiftGrntCapContriFromOthOrgInd0false
IRS990ScheduleR/GiftGrntOrCapContriToOthOrgInd0false
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/DirectControllingNACd0N/A
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/EntityTypeTxt0C corp
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/LegalDomicileStateCd0TX
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/PrimaryActivitiesTxt0OIL AND GAS
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/RelatedOrganizationName/BusinessNameLine1Txt0SHELL OIL COMPANY
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/AddressLine1Txt0909 FANNIN STREET
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/CityNm0HOUSTON
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/StateAbbreviationCd0TX
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/ZIPCd077010
IRS990ScheduleR/LoansOrGuaranteesFromOthOrgInd0false
IRS990ScheduleR/LoansOrGuaranteesToOtherOrgInd0false
IRS990ScheduleR/PaidEmployeesSharingInd0false
IRS990ScheduleR/PerformOfServicesByOtherOrgInd0false
IRS990ScheduleR/PerformOfServicesForOthOrgInd0false
IRS990ScheduleR/ReceiptOfIntAnntsRntsRyltsInd0false
IRS990ScheduleR/ReimbursementPaidByOtherOrgInd0false
IRS990ScheduleR/ReimbursementPaidToOtherOrgInd0false
IRS990ScheduleR/RentalOfFacilitiesToOthOrgInd0false
IRS990ScheduleR/RentalOfFcltsFromOthOrgInd0false
IRS990ScheduleR/SharingOfFacilitiesInd0false
IRS990ScheduleR/TransferFromOtherOrgInd0true
IRS990ScheduleR/TransferToOtherOrgInd0false
IRS990/SchoolOperatingInd0false
IRS990/SignificantChangeInd0false
IRS990/SignificantNewProgramSrvcInd0false
IRS990/SubjectToExcsTaxNetInvstIncInd0false
IRS990/SubjectToProxyTaxInd0false
IRS990/SubjToTaxRmnrtnExPrchtPymtInd0false
IRS990/TaxablePartyNotificationInd0false
IRS990/TaxExemptBondsInd0false
IRS990/TerminateOperationsInd0false
IRS990/TotalAssetsBOYAmt059819611
IRS990/TotalAssetsEOYAmt088722408
IRS990/TotalAssetsGrp/BOYAmt059819611
IRS990/TotalAssetsGrp/EOYAmt088722408
IRS990/TotalCompGreaterThan150KInd0false
IRS990/TotalEmployeeCnt00
IRS990/TotalFunctionalExpensesGrp/FundraisingAmt00
IRS990/TotalFunctionalExpensesGrp/ManagementAndGeneralAmt00
IRS990/TotalFunctionalExpensesGrp/ProgramServicesAmt0452121857
IRS990/TotalFunctionalExpensesGrp/TotalAmt0452121857
IRS990/TotalGrossUBIAmt00
IRS990/TotalLiabilitiesBOYAmt00
IRS990/TotalLiabilitiesEOYAmt00
IRS990/TotalLiabilitiesGrp/BOYAmt00
IRS990/TotalLiabilitiesGrp/EOYAmt00
IRS990/TotalNetAssetsFundBalanceGrp/BOYAmt059819611
IRS990/TotalNetAssetsFundBalanceGrp/EOYAmt088722408
IRS990/TotalOtherCompensationAmt00
IRS990/TotalProgramServiceRevenueAmt0479427137
IRS990/TotalReportableCompFromOrgAmt056600
IRS990/TotalRevenueGrp/ExclusionAmt0481084441
IRS990/TotalRevenueGrp/TotalRevenueColumnAmt0481084441
IRS990/TotLiabNetAssetsFundBalanceGrp/BOYAmt059819611
IRS990/TotLiabNetAssetsFundBalanceGrp/EOYAmt088722408
IRS990/TotReportableCompRltdOrgAmt00
IRS990/TypeOfOrganizationTrustInd0X
IRS990/UnrelatedBusIncmOverLimitInd0false
IRS990/UponRequestInd0X
IRS990/USAddress/AddressLine1Txt0PO BOX 10316
IRS990/USAddress/CityNm0DES MOINES
IRS990/USAddress/StateAbbreviationCd0IA
IRS990/USAddress/ZIPCd050306
IRS990/VotingMembersGoverningBodyCnt01
IRS990/VotingMembersIndependentCnt00
IRS990/WebsiteAddressTxt0N/A
IRS990/WhistleblowerPolicyInd0true
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0-
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum06025620883
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-11-03
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0SHELL MEDICAL PLAN
ReturnHeader/Filer/BusinessNameControlTxt0SHEL
ReturnHeader/Filer/EIN0742200128
ReturnHeader/Filer/PhoneNum06025620883
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 53456 S4101-22G
ReturnHeader/Filer/USAddress/CityNm0PHOENIX
ReturnHeader/Filer/USAddress/StateAbbreviationCd0AZ
ReturnHeader/Filer/USAddress/ZIPCd085072
ReturnHeader/IRSResponsiblePrtyInfoCurrInd0false
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0920460586
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0PWC US TAX LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0301 GRANT STREET 45TH FLOOR
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0PITTSBURGH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0PA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd015219
ReturnHeader/PreparerPersonGrp/PhoneNum04123556000
ReturnHeader/PreparerPersonGrp/PreparationDt02023-11-03
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0LAURA B STROBEL
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02023-11-09T10:00:46-06:00
ReturnHeader/ReturnTypeCd0990
ReturnHeader/TaxPeriodBeginDt02022-01-01
ReturnHeader/TaxPeriodEndDt02022-12-31
ReturnHeader/TaxYr02022

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2022 • Form 990Detailed filing. Detailed filing data is available for this year.

Open filing
Assets
$88,722,408
Liabilities
$0
Net assets
$88,722,408
Revenue
$481,084,441
Expenses
$452,121,857
Net income
$28,962,584
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