Civic Intelligence

Rockwell Collins Veba

EIN 52-2323393 • 501(c)9 • Pittsburgh, PA

Profile

To provide benefits to eligible members

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

n/A

Siviq Scores

Precomputed percentiles relative to similar nonprofits. These scores are descriptive rather than judgmental.

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on the latest valid filing.

Source year 2022

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on the latest valid filing.

Source year 2022

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on the latest valid filing.

Source year 2022

Top Officer Pay

83rd percentile

$0

Higher top officer pay than 83% of similar nonprofits.

501(c)9 • <$500k nonprofits • Source year 2022

Asset Growth

Score unavailable

No value available

A valid growth rate could not be computed from the available filing history.

Annualized from 2021 to 2022

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Assets

Flat

$0

Flat from 2021

Liabilities

Flat

$0

Flat from 2021

Net Assets

Flat

$0

Flat from 2021

Revenue

-

No earlier filing loaded for comparison.

Expenses

-

No earlier filing loaded for comparison.

Net Income

-

No earlier filing loaded for comparison.

Trend Graphs

Balance Sheet Trend

Grouped bars show assets, liabilities, and net assets across loaded filings.

$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

2022

Assets$0
Liabilities$0
Net Assets$0

Operations Trend

Revenue, expenses, and net income by year, with the latest 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

Latest loaded filing

2020

Revenue$10
Expenses-
Net Income-

Filings

Latest Filing Detail
Jump To
Filing Snapshot
Filing Period
Jan 1, 2022 to Dec 31, 2022
Signed
Sep 1, 2023
Return Version
2022v5.0
Mission and Program Overview

Mission

Provision of welfare benefits

Program Services

DescriptionGrantsExpenses
TO PROVIDE BENEFITS TO ELIGIBLE MEMBERS.--
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
-Trustee (See Schedule O)-$0--
Filing and Contact Details

Filer

Filer Name
Rockwell Collins Veba
EIN
52-2323393
Phone
4122342242
Address
C/O THE BNYM PO BOX 535007, PITTSBURGH, PA 15253-5007

Signing Officer

Name
Shelly M Paletta
Title
Bnym, Trustee
Phone
4122342242
Signed
2023-09-01

Preparer

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

Additional Explanations

Form 990EZ Part IV

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,

Form 990EZ Part IV Continued

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.

Raw XML Appendix94 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
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0THE BANK OF NEW YORK MELLON
IRS990EZ/BooksInCareOfDetail/PhoneNum04122342242
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 535007
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0PITTSBURGH
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0PA
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd0152535007
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt00
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/FinalReturnInd0X
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt00
IRS990EZ/Form990TotalAssetsGrp/EOYAmt00
IRS990EZ/GrossReceiptsForPublicUseAmt00
IRS990EZ/InitiationFeesAndCapContriAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt00
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00.0
IRS990EZ/OfficerDirectorTrusteeEmplGrp/BusinessName/BusinessNameLine1Txt0THE BANK OF NEW YORK MELLON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0TRUSTEE (SEE SCHEDULE O)
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0true
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/EOYAmt00
IRS990EZ/OtherChangesInNetAssetsAmt00
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0PROVISION OF WELFARE BENEFITS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0TO PROVIDE BENEFITS TO ELIGIBLE MEMBERS.
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TaxImposedOnOrganizationMgrAmt00
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TaxReimbursedByOrganizationAmt00
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleN/AssetsDistributedInd0true
IRS990ScheduleN/AttorneyGeneralNotifiedInd0true
IRS990ScheduleN/BondLiabilitiesDischargedInd0false
IRS990ScheduleN/BondsOutstandingInd0false
IRS990ScheduleN/DirectorOfSuccessorInd0false
IRS990ScheduleN/EmployeeOfSuccessorInd0false
IRS990ScheduleN/LiabilitiesPaidInd0true
IRS990ScheduleN/OwnerOfSuccessorInd0false
IRS990ScheduleN/ReceiveCompensationInd0false
IRS990ScheduleN/RequiredToNotifyAGInd0true
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0AVERAGE 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,
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1BUT 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/FormAndLineReferenceDesc0FORM 990EZ PART IV
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990EZ PART IV CONTINUED
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/PersonNm0SHELLY M PALETTA
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0BNYM, TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum04122342242
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-09-01
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ROCKWELL COLLINS VEBA
ReturnHeader/Filer/BusinessNameControlTxt0ROCK
ReturnHeader/Filer/EIN0522323393
ReturnHeader/Filer/PhoneNum04122342242
ReturnHeader/Filer/USAddress/AddressLine1Txt0C/O THE BNYM PO BOX 535007
ReturnHeader/Filer/USAddress/CityNm0PITTSBURGH
ReturnHeader/Filer/USAddress/StateAbbreviationCd0PA
ReturnHeader/Filer/USAddress/ZIPCd0152535007
ReturnHeader/IRSResponsiblePrtyInfoCurrInd0false
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0346565596
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/PreparationDt02023-09-01
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0LINDSEY PIGG
ReturnHeader/ReturnTs02023-11-10T16:00:41-06:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02022-01-01
ReturnHeader/TaxPeriodEndDt02022-12-31
ReturnHeader/TaxYr02022

Document Assets

No mirrored PDF or thumbnail assets are attached yet.