Civic Intelligence

Rockwell Collins Veba

990 • Fiscal year 2016 • EIN 52-2323393

Jan 01, 2016 to Dec 31, 2016 • Filed on Jul 24, 2017

Organization ProfileN/A
C/O The Bnym PO Box 535007Pittsburgh, PA 15253-5007

(412) 236-7175

Siviq Scores

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

Liabilities / Assets

21st percentile

0.00x

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

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

Liabilities / Revenue

17th percentile

0.00x

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

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

Net Margin

35th percentile

-0.2%

Higher net margin than 35% of similar nonprofits.

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

Top Officer Pay

41st percentile

$9,832

Higher top officer pay than 41% of similar nonprofits.

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

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

Asset Growth

10th percentile

-8.4%

Faster asset growth than 10% of similar nonprofits.

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

Revenue Growth

31st percentile

0.1%

Faster revenue growth than 31% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets21st percentile

Assets

Down

$2,623,594

Down $240,894 (-8.4%) from 2015

Net Assets

Down

$2,622,706

Down $241,782 (-8.4%) from 2015

Liabilities

Up

$888

Up $888 from 2015

Revenue And Expenses
Liabilities / Revenue17th percentileNet Margin35th percentile

Revenue

Up

$129,914,991

Up $104,078 (+0.1%) from 2015

Expenses

Down

$130,156,773

Down $580,664 (-0.4%) from 2015

Net Income

Up

-$241,782

Up $684,742 (+74%) from 2015

Historical Trend

Balance Sheet Trend

Asset Growth10th percentile

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

$30M$20M$10M$0-$10MAssets 2011: $2,660,561Liabilities 2011: $0Net Assets 2011: $2,660,5612011Assets 2012: $2,037,827Liabilities 2012: $0Net Assets 2012: $2,037,8272012Assets 2013: $505,464Liabilities 2013: $0Net Assets 2013: $505,4642013Assets 2014: $3,791,012Liabilities 2014: $0Net Assets 2014: $3,791,0122014Assets 2015: $2,864,488Liabilities 2015: $0Net Assets 2015: $2,864,4882015Assets 2016: $2,623,594Liabilities 2016: $888Net Assets 2016: $2,622,7062016Assets 2017: $4,796,331Liabilities 2017: $0Net Assets 2017: $4,796,3312017Assets 2018: $20,543,265Liabilities 2018: $0Net Assets 2018: $20,543,2652018Assets 2019: $0Liabilities 2019: $10Net Assets 2019: -$102019Assets 2020: $0Liabilities 2020: $0Net Assets 2020: $02020Assets 2021: $0Liabilities 2021: $0Net Assets 2021: $02021Assets 2022: $0Liabilities 2022: $0Net Assets 2022: $02022

Highlighted filing

2016

Assets$2,623,594
Liabilities$888
Net Assets$2,622,706
Open 2016 Filing

Operations Trend

Revenue Growth31st percentile

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

$200M$150M$100M$50M$0-$50MRevenue 2011: $164,209,982Expenses 2011: $161,642,646Net Income 2011: $2,567,3362011Expenses 2012: $164,874,8682012Expenses 2013: $149,693,4582013Revenue 2014: $148,027,723Expenses 2014: $144,471,066Net Income 2014: $3,556,6572014Revenue 2015: $129,810,913Expenses 2015: $130,737,437Net Income 2015: -$926,5242015Revenue 2016: $129,914,991Expenses 2016: $130,156,773Net Income 2016: -$241,7822016Revenue 2017: $111,288,486Expenses 2017: $109,114,861Net Income 2017: $2,173,6252017Revenue 2018: $158,377,781Expenses 2018: $142,630,847Net Income 2018: $15,746,9342018Revenue 2019: $17,472,416Expenses 2019: $30,827,869Net Income 2019: -$13,355,4532019Revenue 2020: $102020

Highlighted filing

2016

Revenue$129,914,991
Expenses$130,156,773
Net Income-$241,782
Open 2016 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2016 to Dec 31, 2016
Signed
Jul 24, 2017
Return Version
2016v3.1
Gross Receipts
$129,914,991
Mission and Program Overview

Mission

Provision of welfare benefits

Balance Sheet Detail
LineBeginningEndChange
Assets
Savings and Temporary Cash Investments$2,864,467$2,622,753▼ $241,714
Cap Stk Tr Prin Current Funds$2,864,488$2,622,706▼ $241,782
Accounts Receivable$21$841▲ $820
Cash and Non-Interest-Bearing Accounts$0$0→ $0
Other Notes and Loans Receivable, Net$0$0→ $0
Pledges and Grants Receivable$0$0→ $0
Receivable From Disqualified Prsn$0$0→ $0
Receivables From Officers Etc$0$0→ $0
Investments Other Securities$0$0→ $0
Investments Program Related$0$0→ $0
Investments in Publicly Traded Securities$0$0→ $0
Land, Buildings, and Equipment, Net$0$0→ $0
Pd in Cap Srpls Land Bldg Eqp Fund$0$0→ $0
Rtn Earn Endowment Incm Other Fnds$0$0→ $0
Intangible Assets$0$0→ $0
Inventories for Sale or Use$0$0→ $0
Loans From Officers Directors$0$0→ $0
Prepaid Expenses and Deferred Charges$0$0→ $0
Total Assets$2,864,488$2,623,594▼ $240,894
Other Assets Total$0$0→ $0
Liabilities
Accounts Payable and Accrued Expenses$0$888▲ $888
Grants Payable$0$0→ $0
Mortgage Notes Payable Secured by Investment Property$0$0→ $0
Unsecured Notes Loans Payable$0$0→ $0
Other Liabilities$0$0→ $0
Deferred Revenue$0$0→ $0
Escrow Account Liability$0$0→ $0
Tax Exempt Bond Liabilities$0$0→ $0
Total Liabilities$0$888▲ $888
Net Assets / Fund Balance
Total Net Assets Fund Balance$2,864,488$2,622,706▼ $241,782
Total Liabilities and Net Assets / Fund Balance$2,864,488$2,623,594▼ $240,894
Compensation and Service Providers
Top Officer Pay41st percentile

Employees

NameTitleBaseTotal
The Bank of New York MellonTrustee (see Schedule O)$9,832$9,832

Highest Paid Contractors

ContractorServicesLocationCompensation
Wellmark Blue Cross Blue Shield OfAdministration600 3RD AVENUE SE SUITE 200, Cedar Rapids, IA 52401$5,975,627
Delta Dental Of CaliforniaAdministrationPO BOX 44460, San Francisco, CA 94120$1,138,605
Castlight HealthMiscellaneous121 SPEAR STREET SUITE 300, San Francisco, CA 94105$1,128,432
Value OptionsAdministrationPO BOX 1347, Latham, NY 12110$489,361
OptumrxAdministrationPO BOX 509075, San Diego, CA 92150-9075$474,190
Revenue and Support

Revenue Composition

Contributions and Grants
$0
Program Service Revenue
$129,904,649
Investment Income
$10,342
Other Revenue
$0
Change in Net Assets
$-241,782
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Other Expenses$9,581,852
Salaries, Compensation, and Employee Benefits$9,832
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Benefits to Members---$120,565,089
Other Expenses---$7,259,563
Fees for Services Other---$2,245,152
Fees for Services Accounting---$49,000
Fees for Services Legal---$28,137
Current Officers, Directors, Trustees, and Key Employees---$9,832
Total Functional Expenses$0$0$0$130,156,773
Fundraising, Events, and Gaming
Fundraising activities
No
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

Line ItemAmount
Fundraising Direct Expenses$0
Fundraising Gross Income$0
Gaming Direct Expenses$0
Gaming Gross Income$0
Professional Fundraising Fees$0
Political and Lobbying Activity
Political campaign activity
No
Subject to proxy tax
No
Insider Transactions and Loans

Loans and Receivables

Line ItemBeginningEndChange
Loans from Officers, Directors, Trustees, and Key Employees$0$0→ $0
Receivables from Disqualified Persons$0$0→ $0
Receivables from Officers, Directors, Trustees, and Key Employees$0$0→ $0
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
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
No
Audited financial statements prepared
No
Key decisions subject to board approval
No
Management duties delegated
No

Governance Explanations

Form 990 Part VI Section A Line 1A & B

“The bank of new york mellon serves as the sole directed trustee of this trust. The plan sponsor is rockwell collins inc. The trust is administered by the plan sponsor in accordance with the terms of the trust agreement. As such the trust does not have a governing body that exercises discretion.”

Form 990 Part VI Section A & B Lines 8, 12-15

“These questions are not applicable to the trust. Additionally, the trust does not have any employees, therefore, no processes related to employee compensation are in place.”

Form 990 Part VI Section B Line 11B

“A complete electronic copy of the organization's form 990 was provided to the trustee for review prior to filing with the irs.”

Form 990 Part VI Section C Line 19

“As a 501(c)(9) organization the trust is not required to make the documents referenced in question 19 available to the general public.”

Form 990 Part VII Section A Line 1A Column (B)

“Average hours per week devoted to position: as trustee, the bank of new york mellon provides administrative services such as acting as investment manager for the rockwell collins veba. These services require numerous individual bank employees' involvement in the activities of the organization and thus cannot be quantified on an hourly basis. Therefore, the trustee fees are not based upon an hourly basis, but are calculated based upon factors such as the market value of the account and in accordance with the bank of new york mellon's agreement with rockwell collins inc.”

Filing and Contact Details

Filer

Filer Name
Rockwell Collins VEBA
EIN
52-2323393
In Care Of
% THE BANK OF NEW YORK MELLON
Phone
4122367175
Address
C/O THE BNYM PO BOX 535007, PITTSBURGH, PA 15253-5007

Signing Officer

Name
Brent Heintzelman
Title
VP, Bnym, as Trustee
Phone
4122367175
Signed
2017-07-24
Discuss with paid preparer
Yes

Organization Details

Principal Officer
The Bank of New York Mellon
Formed
2001
Legal Domicile
Pa
Voting Board Members
1
Independent Board Members
0
Employees
0
Volunteers
0

Preparer

Firm
Ernst & Young US Llp
Address
2100 ONE PPG PLACE, PITTSBURGH, PA 15222
Preparer
Janice K Martin
Phone
4126447800
Supplemental Narrative

Additional Explanations

Form 990 Part XII Line 1

“MODIFIED CASH BASIS”

Raw XML AppendixShowing 400 of 404 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/AccountsPayableAccrExpnssGrp/BOYAmt00
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt0888
IRS990/AccountsReceivableGrp/BOYAmt021
IRS990/AccountsReceivableGrp/EOYAmt0841
IRS990/ActivitiesConductedPrtshpInd0false
IRS990/ActivityOrMissionDesc0PROVISION OF WELFARE BENEFITS
IRS990/AdvertisingGrp/TotalAmt00
IRS990/BenefitsToMembersGrp/TotalAmt0120565089
IRS990/BooksInCareOfDetail/PersonNm0THE BANK OF NEW YORK MELLON
IRS990/BooksInCareOfDetail/PhoneNum04122367175
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 535007
IRS990/BooksInCareOfDetail/USAddress/CityNm0PITTSBURGH
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0PA
IRS990/BooksInCareOfDetail/USAddress/ZIPCd0152535007
IRS990/BusinessRlnWithFamMemInd0false
IRS990/BusinessRlnWithOfficerEntInd0false
IRS990/BusinessRlnWithOrgMemInd0false
IRS990/CapStkTrPrinCurrentFundsGrp/BOYAmt02864488
IRS990/CapStkTrPrinCurrentFundsGrp/EOYAmt02622706
IRS990/CashNonInterestBearingGrp/BOYAmt00
IRS990/CashNonInterestBearingGrp/EOYAmt00
IRS990/ChangeToOrgDocumentsInd0false
IRS990/CntrctRcvdGreaterThan100KCnt07
IRS990/CollectionsOfArtInd0false
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt09832
IRS990/CompDisqualPersonsGrp/TotalAmt00
IRS990/CompensationFromOtherSrcsInd0false
IRS990/CompensationProcessCEOInd0false
IRS990/CompensationProcessOtherInd0false
IRS990/ConferencesMeetingsGrp/TotalAmt00
IRS990/ConflictOfInterestPolicyInd0false
IRS990/ConservationEasementsInd0false
IRS990/ConsolidatedAuditFinclStmtInd0false
IRS990/ContractorCompensationGrp/CompensationAmt05975627
IRS990/ContractorCompensationGrp/CompensationAmt11138605
IRS990/ContractorCompensationGrp/CompensationAmt2474190
IRS990/ContractorCompensationGrp/CompensationAmt31128432
IRS990/ContractorCompensationGrp/CompensationAmt4489361
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt0600 3RD AVENUE SE SUITE 200
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt1PO BOX 44460
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt2PO BOX 509075
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt3121 SPEAR STREET SUITE 300
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt4PO BOX 1347
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm0CEDAR RAPIDS
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm1SAN FRANCISCO
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm2SAN DIEGO
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm3SAN FRANCISCO
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm4LATHAM
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd0IA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd1CA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd2CA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd3CA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd4NY
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd052401
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd194120
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd2921509075
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd394105
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd412110
IRS990/ContractorCompensationGrp/ContractorName/PersonNm0WELLMARK BLUE CROSS BLUE SHIELD OF
IRS990/ContractorCompensationGrp/ContractorName/PersonNm1DELTA DENTAL OF CALIFORNIA
IRS990/ContractorCompensationGrp/ContractorName/PersonNm2OPTUMRX
IRS990/ContractorCompensationGrp/ContractorName/PersonNm3CASTLIGHT HEALTH
IRS990/ContractorCompensationGrp/ContractorName/PersonNm4VALUE OPTIONS
IRS990/ContractorCompensationGrp/ServicesDesc0ADMINISTRATION
IRS990/ContractorCompensationGrp/ServicesDesc1ADMINISTRATION
IRS990/ContractorCompensationGrp/ServicesDesc2ADMINISTRATION
IRS990/ContractorCompensationGrp/ServicesDesc3MISCELLANEOUS
IRS990/ContractorCompensationGrp/ServicesDesc4ADMINISTRATION
IRS990/CostOfGoodsSoldAmt00
IRS990/CreditCounselingInd0false
IRS990/CYBenefitsPaidToMembersAmt0120565089
IRS990/CYContributionsGrantsAmt00
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt010342
IRS990/CYOtherExpensesAmt09581852
IRS990/CYOtherRevenueAmt00
IRS990/CYProgramServiceRevenueAmt0129904649
IRS990/CYRevenuesLessExpensesAmt0-241782
IRS990/CYSalariesCompEmpBnftPaidAmt09832
IRS990/CYTotalExpensesAmt0130156773
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt0129914991
IRS990/DecisionsSubjectToApprovaInd0false
IRS990/DeductibleArtContributionInd0false
IRS990/DeductibleNonCashContriInd0false
IRS990/DeferredRevenueGrp/BOYAmt00
IRS990/DeferredRevenueGrp/EOYAmt00
IRS990/DelegationOfMgmtDutiesInd0false
IRS990/DepreciationDepletionGrp/TotalAmt00
IRS990/Desc0TO PROVIDE BENEFITS TO ELIGIBLE MEMBERS
IRS990/DescribedInSection501c3Ind0false
IRS990/DisregardedEntityInd0false
IRS990/DocumentRetentionPolicyInd0false
IRS990/DonorAdvisedFundInd0false
IRS990/ElectionOfBoardMembersInd0false
IRS990/EmployeeCnt00
IRS990/EscrowAccountLiabilityGrp/BOYAmt00
IRS990/EscrowAccountLiabilityGrp/EOYAmt00
IRS990/ExpenseAmt00
IRS990/FamilyOrBusinessRlnInd0false
IRS990/FederalGrantAuditRequiredInd0false
IRS990/FeesForServicesAccountingGrp/TotalAmt049000
IRS990/FeesForServicesLegalGrp/TotalAmt028137
IRS990/FeesForServicesLobbyingGrp/TotalAmt00
IRS990/FeesForServicesManagementGrp/TotalAmt00
IRS990/FeesForServicesOtherGrp/TotalAmt02245152
IRS990/FeesForServicesProfFundraising/TotalAmt00
IRS990/FeesForSrvcInvstMgmntFeesGrp/TotalAmt00
IRS990/ForeignActivitiesInd0false
IRS990/ForeignFinancialAccountInd0false
IRS990/ForeignGrantsGrp/TotalAmt00
IRS990/ForeignOfficeInd0false
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt00.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt00.0
IRS990/Form990PartVIISectionAGrp/InstitutionalTrusteeInd0X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/PersonNm0THE BANK OF NEW YORK MELLON
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt09832
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/TitleTxt0TRUSTEE (SEE SCHEDULE O)
IRS990/Form990ProvidedToGvrnBodyInd0true
IRS990/FormationYr02001
IRS990/FormerOfcrEmployeesListedInd0false
IRS990/FSAuditedInd0false
IRS990/FundraisingActivitiesInd0false
IRS990/FundraisingDirectExpensesAmt00
IRS990/FundraisingGrossIncomeAmt00
IRS990/GamingActivitiesInd0false
IRS990/GamingDirectExpensesAmt00
IRS990/GamingGrossIncomeAmt00
IRS990/GoverningBodyVotingMembersCnt01
IRS990/GrantAmt00
IRS990/GrantsPayableGrp/BOYAmt00
IRS990/GrantsPayableGrp/EOYAmt00
IRS990/GrantsToDomesticIndividualsGrp/TotalAmt00
IRS990/GrantsToDomesticOrgsGrp/TotalAmt00
IRS990/GrantsToIndividualsInd0false
IRS990/GrantsToOrganizationsInd0false
IRS990/GrantToRelatedPersonInd0false
IRS990/GrossReceiptsAmt0129914991
IRS990/GrossSalesOfInventoryAmt00
IRS990/GroupReturnForAffiliatesInd0false
IRS990/IncludeFIN48FootnoteInd0false
IRS990/IncmFromInvestBondProceedsGrp/TotalRevenueColumnAmt00
IRS990/IndependentAuditFinclStmtInd0false
IRS990/IndependentVotingMemberCnt00
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd0false
IRS990/InfoInScheduleOPartVIIInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIIInd0X
IRS990/InformationTechnologyGrp/TotalAmt00
IRS990/InsuranceGrp/TotalAmt00
IRS990/IntangibleAssetsGrp/BOYAmt00
IRS990/IntangibleAssetsGrp/EOYAmt00
IRS990/InterestGrp/TotalAmt00
IRS990/InventoriesForSaleOrUseGrp/BOYAmt00
IRS990/InventoriesForSaleOrUseGrp/EOYAmt00
IRS990/InvestmentIncomeGrp/ExclusionAmt010342
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt010342
IRS990/InvestmentInJointVentureInd0false
IRS990/InvestmentsOtherSecuritiesGrp/BOYAmt00
IRS990/InvestmentsOtherSecuritiesGrp/EOYAmt00
IRS990/InvestmentsProgramRelatedGrp/BOYAmt00
IRS990/InvestmentsProgramRelatedGrp/EOYAmt00
IRS990/InvestmentsPubTradedSecGrp/BOYAmt00
IRS990/InvestmentsPubTradedSecGrp/EOYAmt00
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipBasisNetGrp/BOYAmt00
IRS990/LandBldgEquipBasisNetGrp/EOYAmt00
IRS990/LegalDomicileStateCd0PA
IRS990/LoanOutstandingInd0false
IRS990/LoansFromOfficersDirectorsGrp/BOYAmt00
IRS990/LoansFromOfficersDirectorsGrp/EOYAmt00
IRS990/LocalChaptersInd0false
IRS990/MaterialDiversionOrMisuseInd0false
IRS990/MembersOrStockholdersInd0false
IRS990/MethodOfAccountingOtherInd0X
IRS990/MinutesOfCommitteesInd0false
IRS990/MinutesOfGoverningBodyInd0false
IRS990/MissionDesc0TO PROVIDE BENEFITS TO ELIGIBLE MEMBERS
IRS990/MoreThan5000KToIndividualsInd0false
IRS990/MoreThan5000KToOrgInd0false
IRS990/MortgNotesPyblScrdInvstPropGrp/BOYAmt00
IRS990/MortgNotesPyblScrdInvstPropGrp/EOYAmt00
IRS990/NetAssetsOrFundBalancesBOYAmt02864488
IRS990/NetAssetsOrFundBalancesEOYAmt02622706
IRS990/NetGainOrLossInvestmentsGrp/TotalRevenueColumnAmt00
IRS990/NetIncmFromFundraisingEvtGrp/TotalRevenueColumnAmt00
IRS990/NetIncomeFromGamingGrp/TotalRevenueColumnAmt00
IRS990/NetIncomeOrLossGrp/TotalRevenueColumnAmt00
IRS990/NetRentalIncomeOrLossGrp/TotalRevenueColumnAmt00
IRS990/NondeductibleContributionsInd0false
IRS990/OccupancyGrp/TotalAmt00
IRS990/OfficeExpensesGrp/TotalAmt00
IRS990/OfficerMailingAddressInd0false
IRS990/OperateHospitalInd0false
IRS990/Organization501cInd0X
IRS990/OrgDoesNotFollowSFAS117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt00
IRS990/OtherAssetsTotalGrp/EOYAmt00
IRS990/OtherEmployeeBenefitsGrp/TotalAmt00
IRS990/OtherExpensesGrp/Desc0ADMINISTRATIVE FEES
IRS990/OtherExpensesGrp/TotalAmt07259563
IRS990/OtherLiabilitiesGrp/BOYAmt00
IRS990/OtherLiabilitiesGrp/EOYAmt00
IRS990/OtherRevenueTotalAmt00
IRS990/OtherSalariesAndWagesGrp/TotalAmt00
IRS990/OthNotesLoansReceivableNetGrp/BOYAmt00
IRS990/OthNotesLoansReceivableNetGrp/EOYAmt00
IRS990/PartialLiquidationInd0false
IRS990/PaymentsToAffiliatesGrp/TotalAmt00
IRS990/PayrollTaxesGrp/TotalAmt00
IRS990/PdInCapSrplsLandBldgEqpFundGrp/BOYAmt00
IRS990/PdInCapSrplsLandBldgEqpFundGrp/EOYAmt00
IRS990/PensionPlanContributionsGrp/TotalAmt00
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt00
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt00
IRS990/PoliticalCampaignActyInd0false
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt00
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt00
IRS990/PrincipalOfficerNm0THE BANK OF NEW YORK MELLON
IRS990/ProfessionalFundraisingInd0false
IRS990/ProgramServiceRevenueGrp/BusinessCd0525100
IRS990/ProgramServiceRevenueGrp/BusinessCd1525100
IRS990/ProgramServiceRevenueGrp/BusinessCd2525100
IRS990/ProgramServiceRevenueGrp/Desc0EMPLOYER CONTRIBUTIONS
IRS990/ProgramServiceRevenueGrp/Desc1EMPLOYEE CONTRIBUTIONS
IRS990/ProgramServiceRevenueGrp/Desc2COBRA CONTRIBUTIONS
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt0126500000
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt13112628
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt2292021
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt0126500000
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt13112628
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt2292021
IRS990/ProhibitedTaxShelterTransInd0false
IRS990/PYBenefitsPaidToMembersAmt0120579573
IRS990/PYContributionsGrantsAmt00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt043
IRS990/PymtTravelEntrtnmntPubOfclGrp/TotalAmt00
IRS990/PYOtherExpensesAmt010147731
IRS990/PYOtherRevenueAmt00
IRS990/PYProgramServiceRevenueAmt0129810870
IRS990/PYRevenuesLessExpensesAmt0-926524
IRS990/PYSalariesCompEmpBnftPaidAmt010133
IRS990/PYTotalExpensesAmt0130737437
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt0129810913
IRS990/RcvblFromDisqualifiedPrsnGrp/BOYAmt00
IRS990/RcvblFromDisqualifiedPrsnGrp/EOYAmt00
IRS990/ReceivablesFromOfficersEtcGrp/BOYAmt00
IRS990/ReceivablesFromOfficersEtcGrp/EOYAmt00
IRS990/ReconcilationRevenueExpnssAmt0-241782
IRS990/RelatedEntityInd0true
IRS990/RelatedOrganizationCtrlEntInd0false
IRS990/RentalIncomeOrLossGrp/PersonalAmt00
IRS990/RentalIncomeOrLossGrp/RealAmt00
IRS990/ReportInvestmentsOtherSecInd0false
IRS990/ReportLandBuildingEquipmentInd0false
IRS990/ReportOtherAssetsInd0false
IRS990/ReportOtherLiabilitiesInd0false
IRS990/ReportProgramRelatedInvstInd0false
IRS990/RevenueAmt00
IRS990/RoyaltiesGrp/TotalAmt00
IRS990/RoyaltiesRevenueGrp/TotalRevenueColumnAmt00
IRS990/RtnEarnEndowmentIncmOthFndsGrp/BOYAmt00
IRS990/RtnEarnEndowmentIncmOthFndsGrp/EOYAmt00
IRS990/SavingsAndTempCashInvstGrp/BOYAmt02864467
IRS990/SavingsAndTempCashInvstGrp/EOYAmt02622753
IRS990/ScheduleBRequiredInd0false
IRS990/ScheduleJRequiredInd0false
IRS990/ScheduleORequiredInd0true
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0THE BANK OF NEW YORK MELLON SERVES AS THE SOLE DIRECTED TRUSTEE OF THIS TRUST. THE PLAN SPONSOR IS ROCKWELL COLLINS INC. THE TRUST IS ADMINISTERED BY THE PLAN SPONSOR IN ACCORDANCE WITH THE TERMS OF THE TRUST AGREEMENT. AS SUCH THE TRUST DOES NOT HAVE A GOVERNING BODY THAT EXERCISES DISCRETION.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1THESE QUESTIONS ARE NOT APPLICABLE TO THE TRUST. ADDITIONALLY, THE TRUST DOES NOT HAVE ANY EMPLOYEES, THEREFORE, NO PROCESSES RELATED TO EMPLOYEE COMPENSATION ARE IN PLACE.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2A COMPLETE ELECTRONIC COPY OF THE ORGANIZATION'S FORM 990 WAS PROVIDED TO THE TRUSTEE FOR REVIEW PRIOR TO FILING WITH THE IRS.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3AS A 501(C)(9) ORGANIZATION THE TRUST IS NOT REQUIRED TO MAKE THE DOCUMENTS REFERENCED IN QUESTION 19 AVAILABLE TO THE GENERAL PUBLIC.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4AVERAGE HOURS PER WEEK DEVOTED TO POSITION: AS TRUSTEE, THE BANK OF NEW YORK MELLON PROVIDES ADMINISTRATIVE SERVICES SUCH AS ACTING AS INVESTMENT MANAGER FOR THE ROCKWELL COLLINS VEBA. THESE SERVICES REQUIRE NUMEROUS INDIVIDUAL BANK EMPLOYEES' INVOLVEMENT IN THE ACTIVITIES OF THE ORGANIZATION AND THUS CANNOT BE QUANTIFIED ON AN HOURLY BASIS. THEREFORE, THE TRUSTEE FEES ARE NOT BASED UPON AN HOURLY BASIS, BUT ARE CALCULATED BASED UPON FACTORS SUCH AS THE MARKET VALUE OF THE ACCOUNT AND IN ACCORDANCE WITH THE BANK OF NEW YORK MELLON'S AGREEMENT WITH ROCKWELL COLLINS INC.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5MODIFIED CASH BASIS
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990 PART VI SECTION A LINE 1A & B
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990 PART VI SECTION A & B LINES 8, 12-15
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990 PART VI SECTION B LINE 11B
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990 PART VI SECTION C LINE 19
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4FORM 990 PART VII SECTION A LINE 1A COLUMN (B)
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5FORM 990 PART XII LINE 1
IRS990ScheduleR/AssetExchangeInd0false
IRS990ScheduleR/AssetPurchaseFromOtherOrgInd0false
IRS990ScheduleR/AssetSaleToOtherOrgInd0false
IRS990ScheduleR/DivRelatedOrganizationInd0false
IRS990ScheduleR/GiftGrntCapContriFromOthOrgInd0false
IRS990ScheduleR/GiftGrntOrCapContriToOthOrgInd0false
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/ControlledOrganizationInd0false
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/DirectControllingEntityName/BusinessNameLine1Txt0NA
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/EIN0522314475
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/EntityTypeTxt0C CORP
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/LegalDomicileStateCd0DE
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/PrimaryActivitiesTxt0COMMUNICATION
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/RelatedOrganizationName/BusinessNameLine1Txt0ROCKWELL COLLINS INC
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/AddressLine1Txt0400 COLLINS ROAD NE
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/CityNm0CEDAR RAPIDS
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/StateAbbreviationCd0IA
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/ZIPCd052498
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/SubjectToProxyTaxInd0false
IRS990/TaxablePartyNotificationInd0false
IRS990/TaxExemptBondLiabilitiesGrp/BOYAmt00
IRS990/TaxExemptBondLiabilitiesGrp/EOYAmt00
IRS990/TaxExemptBondsInd0false
IRS990/TempOrPermanentEndowmentsInd0false
IRS990/TerminateOperationsInd0false
IRS990/TotalAssetsBOYAmt02864488
IRS990/TotalAssetsEOYAmt02623594
IRS990/TotalAssetsGrp/BOYAmt02864488
IRS990/TotalAssetsGrp/EOYAmt02623594
IRS990/TotalCompGreaterThan150KInd0false
IRS990/TotalContributionsAmt00
IRS990/TotalEmployeeCnt00
IRS990/TotalFunctionalExpensesGrp/TotalAmt0130156773
IRS990/TotalGrossUBIAmt00
IRS990/TotalLiabilitiesBOYAmt00
IRS990/TotalLiabilitiesEOYAmt0888
IRS990/TotalLiabilitiesGrp/BOYAmt00
IRS990/TotalLiabilitiesGrp/EOYAmt0888
IRS990/TotalNetAssetsFundBalanceGrp/BOYAmt02864488
IRS990/TotalNetAssetsFundBalanceGrp/EOYAmt02622706
IRS990/TotalOtherCompensationAmt00
IRS990/TotalOtherProgSrvcExpenseAmt00
IRS990/TotalOtherProgSrvcGrantAmt00
IRS990/TotalOtherProgSrvcRevenueAmt00
IRS990/TotalProgramServiceExpensesAmt00
IRS990/TotalProgramServiceRevenueAmt0129904649
IRS990/TotalReportableCompFromOrgAmt09832
IRS990/TotalRevenueGrp/ExclusionAmt010342
IRS990/TotalRevenueGrp/RelatedOrExemptFuncIncomeAmt0129904649
IRS990/TotalRevenueGrp/TotalRevenueColumnAmt0129914991
IRS990/TotalVolunteersCnt00
IRS990/TotLiabNetAssetsFundBalanceGrp/BOYAmt02864488
IRS990/TotLiabNetAssetsFundBalanceGrp/EOYAmt02623594
IRS990/TotReportableCompRltdOrgAmt00
IRS990/TravelGrp/TotalAmt00
IRS990/TypeOfOrganizationTrustInd0X
IRS990/UnrelatedBusIncmOverLimitInd0false
IRS990/UnsecuredNotesLoansPayableGrp/BOYAmt00
IRS990/UnsecuredNotesLoansPayableGrp/EOYAmt00
IRS990/UponRequestInd0X
IRS990/USAddress/AddressLine1Txt0PO BOX 535007
IRS990/USAddress/CityNm0PITTSBURGH
IRS990/USAddress/StateAbbreviationCd0PA
IRS990/USAddress/ZIPCd0152535007
IRS990/VotingMembersGoverningBodyCnt01
IRS990/VotingMembersIndependentCnt00
IRS990/WebsiteAddressTxt0N/A
IRS990/WhistleblowerPolicyInd0false
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0BRENT HEINTZELMAN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0VP, BNYM, AS TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum04122367175
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-07-24
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Rockwell Collins VEBA
ReturnHeader/Filer/BusinessNameControlTxt0ROCK
ReturnHeader/Filer/EIN0522323393
ReturnHeader/Filer/InCareOfNm0% THE BANK OF NEW YORK MELLON
ReturnHeader/Filer/PhoneNum04122367175
ReturnHeader/Filer/USAddress/AddressLine1Txt0C/O THE BNYM PO BOX 535007
ReturnHeader/Filer/USAddress/CityNm0PITTSBURGH
ReturnHeader/Filer/USAddress/StateAbbreviationCd0PA
ReturnHeader/Filer/USAddress/ZIPCd0152535007
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId05BF8B1FAA6EEDEED44D541882D0DE71D1382AD83
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId08CBFF85A9FEE20D4AA76175B08418E5C9805F127
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId025553720172055000002
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02017-07-24
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0164.57.159.253
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0ERNST & YOUNG US LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02100 ONE PPG PLACE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0PITTSBURGH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0PA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd015222
ReturnHeader/PreparerPersonGrp/PhoneNum04126447800
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Janice K Martin
ReturnHeader/ReturnTs02017-07-24T15:30:50-05:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$2,623,594
Liabilities
$888
Net assets
$2,622,706
Revenue
$129,914,991
Expenses
$130,156,773
Net income
-$241,782
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2022Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00
2021Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00
2020Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00
2019Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$17.5$30.8$13.4
2018Detailed filing. Detailed filing data is available for this year.$20.5$0.00$20.5$158$143$15.7
2017Detailed filing. Detailed filing data is available for this year.$4.80$0.00$4.80$111$109$2.17
2016Detailed filing. Detailed filing data is available for this year.$2.62$0.00$2.62$130$130$0.24
2015Detailed filing. Detailed filing data is available for this year.$2.86$0.00$2.86$130$131$0.93
2014Detailed filing. Detailed filing data is available for this year.$3.79$0.00$3.79$148$144$3.56
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.51$0.00$0.51$150
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.04$0.00$2.04$165
2011Summary only. Only limited summary data is available for this year.$2.66$0.00$2.66$164$162$2.57