Civic Intelligence

Raphael Avellar Charitable Trust

990PF • Fiscal year 2022 • EIN 27-2149604

Jan 01, 2022 to Dec 31, 2022 • Filed on Apr 07, 2023

Organization Profile
116 Allegheny Center Mall P8yb3502lPittsburgh, PA 15212

(412) 258-3051

Siviq Scores

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

Liabilities / Assets

40th percentile

0.00x

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

2022 filings • $500k-$1M nonprofits • Source year 2022

Liabilities / Revenue

39th percentile

0.00x

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

2022 filings • $500k-$1M nonprofits • Source year 2022

Net Margin

14th percentile

-42%

Higher net margin than 14% of similar nonprofits.

2022 filings • $500k-$1M nonprofits • Source year 2022

Top Officer Pay

69th percentile

$21,949

Higher top officer pay than 69% of similar nonprofits.

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

2022 filings • $500k-$1M nonprofits • Source year 2022

Asset Growth

36th percentile

-3.6%

Faster asset growth than 36% of similar nonprofits.

2022 filings • $500k-$1M nonprofits • Annualized from 2021 to 2022

Revenue Growth

32nd percentile

-8.8%

Faster revenue growth than 32% of similar nonprofits.

2022 filings • $500k-$1M nonprofits • Annualized from 2021 to 2022

Balance Sheet
Liabilities / Assets40th percentile

Assets

Down

$831,466

Down $30,929 (-3.6%) from 2021

Net Assets

Down

$831,466

Down $30,929 (-3.6%) from 2021

Liabilities

Flat

$0

Flat from 2021

Revenue And Expenses
Liabilities / Revenue39th percentileNet Margin14th percentile

Revenue

Down

$73,251

Down $7,051 (-8.8%) from 2021

Expenses

Up

$103,996

Up $8,943 (+9.4%) from 2021

Net Income

Down

-$30,745

Down $15,994 (-108%) from 2021

Historical Trend

Balance Sheet Trend

Asset Growth36th percentile

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

$1.5M$1.0M$500K$0Assets 2011: $1,158,015Liabilities 2011: $0Net Assets 2011: $1,158,0152011Assets 2012: $1,137,056Liabilities 2012: $0Net Assets 2012: $1,137,0562012Assets 2013: $1,135,994Liabilities 2013: $0Net Assets 2013: $1,135,9942013Assets 2014: $1,085,575Liabilities 2014: $0Net Assets 2014: $1,085,5752014Assets 2019: $927,718Liabilities 2019: $0Net Assets 2019: $927,7182019Assets 2020: $877,202Liabilities 2020: $0Net Assets 2020: $877,2022020Assets 2021: $862,395Liabilities 2021: $0Net Assets 2021: $862,3952021Assets 2022: $831,466Liabilities 2022: $0Net Assets 2022: $831,4662022Assets 2023: $847,680Liabilities 2023: $0Net Assets 2023: $847,6802023Assets 2024: $855,511Liabilities 2024: $0Net Assets 2024: $855,5112024

Highlighted filing

2022

Assets$831,466
Liabilities$0
Net Assets$831,466
Open 2022 Filing

Operations Trend

Revenue Growth32nd percentile

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

$150K$100K$50K$0-$50K-$100KExpenses 2011: $47,4262011Expenses 2012: $72,7642012Revenue 2013: $66,226Expenses 2013: $67,288Net Income 2013: -$1,0622013Revenue 2014: $52,821Expenses 2014: $89,071Net Income 2014: -$36,2502014Revenue 2019: $39,589Expenses 2019: $92,348Net Income 2019: -$52,7592019Revenue 2020: $46,789Expenses 2020: $94,581Net Income 2020: -$47,7922020Revenue 2021: $80,302Expenses 2021: $95,053Net Income 2021: -$14,7512021Revenue 2022: $73,251Expenses 2022: $103,996Net Income 2022: -$30,7452022Revenue 2023: $118,101Expenses 2023: $101,408Net Income 2023: $16,6932023Revenue 2024: $106,267Expenses 2024: $98,351Net Income 2024: $7,9162024

Highlighted filing

2022

Revenue$73,251
Expenses$103,996
Net Income-$30,745
Open 2022 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2022 to Dec 31, 2022
Signed
Apr 7, 2023
Return Version
2022v5.0
Compensation and Service Providers
Top Officer Pay69th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
PNC BANK NATrusteePT$21,949-$21,949
Filing and Contact Details

Filer

Filer Name
Raphael Avellar Charitable Trust
EIN
27-2149604
Phone
4122583051
Address
116 ALLEGHENY CENTER MALL P8YB3502L, PITTSBURGH, PA 15212

Signing Officer

Name
Pnc Bank N a
Title
Tax Manager
Phone
4122583051
Signed
2023-04-07
Discuss with paid preparer
Yes

Preparer

Firm
Ernst & Young US Llp
Address
2100 ONE PPG PLACE, PITTSBURGH, PA 15222
Preparer
Jason Belot
Phone
3302555814
Raw XML Appendix341 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
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt076016
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt138447
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt276820
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt3109064
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt466719
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt572000
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt6145958
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt7210673
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt830000
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt057071854 BAIRD AGGREGATE BOND
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1464287465 ISHARES MSCI EAFE ET
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt2464287499 ISHARES RUSSELL MID-
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt3464287655 ISHARES RUSSELL 2000
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt446090E103 INVESCO QQQ TRUST ET
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt509260B382 BLACKROCK STRATEGIC
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt646434V621 ISHARES CORE DIVIDEN
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt774440B884 PRUDENTIAL TOTAL RET
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt877958B105 T ROWE PRICE INSTITU
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt978462F103 SPDR S&P 500 ETF TRU
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt10057071854 BAIRD AGGREGATE BOND
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1177958B402 T ROWE PRICE INSTITU
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt0119071
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt1228453
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt2116996
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt3101750
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt4121000
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt556998
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt6466947
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt7185882
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt828421
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd1AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd2AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd3AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd4AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd5AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd6AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd7AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd8AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DividendsAndInterestFromSecDtl/ExclusionAmt033609
IRS990PF/AnalysisIncomeProducingActyGrp/DividendsAndInterestFromSecDtl/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt039642
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt073251
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt073251
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt039642
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt01097
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt020852
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt021949
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt080848
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt080848
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt033609
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt033609
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-30745
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0155825
IRS990PF/AnalysisOfRevenueAndExpenses/InterestDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt039642
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt052399
IRS990PF/AnalysisOfRevenueAndExpenses/NetSTCapitalGainAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PensionEmplBnftAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PensionEmplBnftNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt01199
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt081945
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt020852
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt0103996
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt073251
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt073251
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt01097
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt020852
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt023148
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingNetInvstIncmAmt00
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02019-05-29
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12020-10-26
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt22022-08-31
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt32005-07-01
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt043867
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt152653
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt26517
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt35974
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt47172
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-3867
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt13170
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt223424
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt338
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt416877
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-3867
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt13170
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt223424
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt338
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt416877
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt040000
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt155823
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt229941
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt36012
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt424049
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc04028.197 BAIRD AGGREGATE BOND FUND FD 72
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1185. INVESCO QQQ TRUST ETF
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc2425. ISHARES TR RUSSELL MIDCAP INDEX FD
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc315. SPDR TR UNIT SER 1
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc460. SPDR TR UNIT SER 1
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02022-08-31
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12022-08-31
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt22022-11-23
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt32022-11-23
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt42022-11-23
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt039642
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-30745
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt03154
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt02970
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0834620
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0862395
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0831466
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt077092
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt077092
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt077092
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt077820
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0728
IRS990PF/DistributableAmountGrp/TotalTaxAmt0728
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt060
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0788
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExemptFrgnOrgTaxWthldAtSrceAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0728
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt060
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0728
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0728
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0788
IRS990PF/FMVAssetsEOYAmt01431287
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0862395
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0831466
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt0856319
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt0825697
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt01425518
IRS990PF/Form990PFBalanceSheetsGrp/OtherRcvblAllwncDbtflAcctAmt00
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt06076
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt05769
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt05769
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0862395
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0831466
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt01431287
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0862395
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0831466
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0862395
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0831466
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt01580101
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt01580101
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt023702
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt077820
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt01556399
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt01580101
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt05
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt021949
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0PNC BANK NA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0116 ALLEGHENY CENTER MALL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0PITTSBURGH
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0PA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd015212
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/PFQualifyingDistributionsGrp/CharitableAssetsAcquisPaidAmt00
IRS990PF/PFQualifyingDistributionsGrp/ExpensesAndContributionsAmt081945
IRS990PF/PFQualifyingDistributionsGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/PFQualifyingDistributionsGrp/QualifyingDistributionsAmt081945
IRS990PF/PFQualifyingDistributionsGrp/SetAsideCashDistriTestAmt00
IRS990PF/PFQualifyingDistributionsGrp/SetAsideSuitabilityTestAmt00
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd0false
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0true
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/SubjToTaxRmnrtnExPrchtPymtInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0true
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0116 ALLEGHENY CENTER MALL
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0PITTSBURGH
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0PA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd015212
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0KY
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0PNC BANK NA
IRS990PF/StatementsRegardingActyGrp/PhoneNum04122583051
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt080848
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0GENERAL SUPPORT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0JEFFERSON CO PUBLIC SCHOOLS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine2Txt0ATTN CORDELIA HARDIN CFO
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0P O BOX 34020
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0LOUISVILLE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0KY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd0402324020
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt080848
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt01646
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt080299
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt077092
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt00
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt00
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt081945
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt075446
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt080299
OtherDecreasesSchedule/OtherDecreasesDetail/Amt03152
OtherDecreasesSchedule/OtherDecreasesDetail/Amt12
OtherDecreasesSchedule/OtherDecreasesDetail/Desc02022 TRANSACTION POSTED IN 2023
OtherDecreasesSchedule/OtherDecreasesDetail/Desc1ROUNDING
OtherIncreasesSchedule/OtherIncreasesDetail/Amt02780
OtherIncreasesSchedule/OtherIncreasesDetail/Amt1190
OtherIncreasesSchedule/OtherIncreasesDetail/Desc02021 TRANSACTION POSTED IN 2022
OtherIncreasesSchedule/OtherIncreasesDetail/Desc1PRIOR PERIOD ADJUSTMENT
TaxesSchedule/TaxesDetail/Amt0411
TaxesSchedule/TaxesDetail/Amt1788
TaxesSchedule/TaxesDetail/CategoryTxt0FEDERAL TAX PAYMENT - PRIOR YE
TaxesSchedule/TaxesDetail/CategoryTxt1FEDERAL ESTIMATES - PRINCIPAL
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt10
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt10
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0PNC BANK N A
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TAX MANAGER
ReturnHeader/BusinessOfficerGrp/PhoneNum04122583051
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-04-07
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0RAPHAEL AVELLAR CHARITABLE TRUST
ReturnHeader/Filer/BusinessNameControlTxt0RAPH
ReturnHeader/Filer/EIN0272149604
ReturnHeader/Filer/PhoneNum04122583051
ReturnHeader/Filer/USAddress/AddressLine1Txt0116 ALLEGHENY CENTER MALL P8YB3502L
ReturnHeader/Filer/USAddress/CityNm0PITTSBURGH
ReturnHeader/Filer/USAddress/StateAbbreviationCd0PA
ReturnHeader/Filer/USAddress/ZIPCd015212
ReturnHeader/IRSResponsiblePrtyInfoCurrInd00
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/PhoneNum03302555814
ReturnHeader/PreparerPersonGrp/PreparationDt02023-04-07
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JASON BELOT
ReturnHeader/ReturnTs02023-04-12T15:11:34-05:00
ReturnHeader/ReturnTypeCd0990PF
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 990PFDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$831,466
Liabilities
$0
Net assets
$831,466
Revenue
$73,251
Expenses
$103,996
Net income
-$30,745
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$0.86$0.00$0.86$0.11$0.10$0.01
2023Detailed filing. Detailed filing data is available for this year.$0.85$0.00$0.85$0.12$0.10$0.02
2022Detailed filing. Detailed filing data is available for this year.$0.83$0.00$0.83$0.07$0.10$0.03
2021Detailed filing. Detailed filing data is available for this year.$0.86$0.00$0.86$0.08$0.10$0.01
2020Detailed filing. Detailed filing data is available for this year.$0.88$0.00$0.88$0.05$0.09$0.05
2019Detailed filing. Detailed filing data is available for this year.$0.93$0.00$0.93$0.04$0.09$0.05
2014Detailed filing. Detailed filing data is available for this year.$1.09$0.00$1.09$0.05$0.09$0.04
2013Detailed filing. Detailed filing data is available for this year.$1.14$0.00$1.14$0.07$0.07$0.00
2012Detailed filing. Detailed filing data is available for this year.$1.14$0.00$1.14$0.07
2011Detailed filing. Detailed filing data is available for this year.$1.16$0.00$1.16$0.05