Civic Intelligence

Raphael Avellar Charitable Trust

990PF • Fiscal year 2023 • EIN 27-2149604

Jan 01, 2023 to Dec 31, 2023 • Filed on Mar 31, 2024

116 Allegheny Center Mall P8yb3502lPittsburgh, PA 15212

(412) 467-1575

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.

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

Liabilities / Revenue

40th percentile

0.00x

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

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

Net Margin

67th percentile

14%

Higher net margin than 67% of similar nonprofits.

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

Top Officer Pay

69th percentile

$21,049

Higher top officer pay than 69% of similar nonprofits.

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

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

Asset Growth

51st percentile

1.9%

Faster asset growth than 51% of similar nonprofits.

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

Revenue Growth

84th percentile

61%

Faster revenue growth than 84% of similar nonprofits.

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

Assets

Up

$847,680

Up $16,214 (+2.0%) from 2022

Net Assets

Up

$847,680

Up $16,214 (+2.0%) from 2022

Liabilities

Flat

$0

Flat from 2022

Revenue

Up

$118,101

Up $44,850 (+61%) from 2022

Expenses

Down

$101,408

Down $2,588 (-2.5%) from 2022

Net Income

Up

$16,693

Up $47,438 (+154%) from 2022

Historical Trend

Balance Sheet Trend

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

2023

Assets$847,680
Liabilities$0
Net Assets$847,680

Operations Trend

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

2023

Revenue$118,101
Expenses$101,408
Net Income$16,693
Jump To
Filing Snapshot
Filing Period
Jan 1, 2023 to Dec 31, 2023
Signed
Mar 31, 2024
Return Version
2023v5.0
Compensation and Service Providers

Employees

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

Filer

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

Signing Officer

Name
Pnc Bank N a
Title
Tax Manager
Phone
4124671575
Signed
2024-03-31
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 Appendix366 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/BookValueAmt127663
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt247359
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt3109064
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt449626
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt5122000
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt6140579
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt7132986
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt8130000
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0464287465 ISHARES MSCI EAFE ET
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1464287499 ISHARES RUSSELL MID-
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt2464287655 ISHARES RUSSELL 2000
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt309260B382 BLACKROCK STRATEGIC
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt446434V621 ISHARES CORE DIVIDEN
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt574440B884 PRUDENTIAL TOTAL RET
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt678462F103 SPDR S&P 500 ETF TRU
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt7057071854 BAIRD AGGREGATE BOND
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt877958B402 T ROWE PRICE INSTITU
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt9256210105 DODGE & COX INCOME F
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt0136685
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt1189428
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt2102563
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt3104294
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt496876
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt5109784
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt6558965
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt7120519
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt8131205
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/ExclusionAmt037381
IRS990PF/AnalysisIncomeProducingActyGrp/DividendsAndInterestFromSecDtl/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt080720
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt0118101
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt0118101
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt080720
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt01052
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt019997
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt021049
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt079432
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt079432
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt036701
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt037381
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt016693
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0251124
IRS990PF/AnalysisOfRevenueAndExpenses/InterestDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt080720
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt097165
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/TaxesNetInvstIncmAmt0259
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0927
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt080484
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt020256
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt0101408
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt0117421
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt0118101
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt01052
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt020256
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt021976
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingNetInvstIncmAmt00
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02016-02-03
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12016-09-28
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt22009-03-09
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt32022-08-31
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt42016-09-28
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt52016-04-27
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt62009-03-09
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt72005-07-01
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt055067
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt130000
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt26341
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt37719
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt429461
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt510752
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt622620
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt73065
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt85379
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-5067
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt1-1517
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt25817
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt342199
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt420
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt59454
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt6-2620
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt717039
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt815395
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-5067
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt1-1517
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt25817
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt342199
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt420
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt59454
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt6-2620
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt717039
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt815395
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt050000
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt128483
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt212158
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt349918
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt429481
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt520206
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt620000
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt720104
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt820774
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc05060.729 BAIRD AGGREGATE BOND FUND FD 72
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc13095.992 T ROWE PRICE INSTITUTIONAL FLOATING RATE FUND
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc2230. ISHARES CORE DIVIDEND GROWTH ETF
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc3680. ISHARES RUSSELL MID-CAP ETF
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc4160. ISHARES RUSSELL 2000 ETF
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc5390. ISHARES CORE DIVIDEND GROWTH ETF
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc62079.002 BAIRD AGGREGATE BOND FUND FD 72
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc7270. ISHARES RUSSELL MID-CAP ETF
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc845. SPDR S&P 500 ETF TRUST
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02023-03-23
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12023-03-23
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt22023-08-02
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt32023-12-04
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt42023-12-04
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt52023-12-04
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt62023-12-11
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt72023-12-11
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt82023-12-11
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt080720
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt016693
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt03633
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt03154
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0851313
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0831466
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0847680
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt072999
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt072999
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt072999
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt074350
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt01351
IRS990PF/DistributableAmountGrp/TotalTaxAmt01351
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0728
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExemptFrgnOrgTaxWthldAtSrceAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt01351
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt01351
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt01351
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt0623
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0728
IRS990PF/FMVAssetsEOYAmt01562706
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0831466
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0847680
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt0825697
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt0835293
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt01550319
IRS990PF/Form990PFBalanceSheetsGrp/OtherRcvblAllwncDbtflAcctAmt00
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt05769
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt012387
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt012387
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0831466
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0847680
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt01562706
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0831466
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0847680
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0831466
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0847680
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt01509639
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt01509639
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt022645
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt074350
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt01486994
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt01509639
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt05
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt021049
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/ExpensesAndContributionsAmt080484
IRS990PF/PFQualifyingDistributionsGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/PFQualifyingDistributionsGrp/QualifyingDistributionsAmt080484
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/PhoneNum04124671575
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt079432
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/TotalGrantOrContriPdDurYrAmt079432
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/AppliedToCurrentYearAmt05038
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt075446
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt072999
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/QualifyingDistributionsAmt080484
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt067961
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt075446
OtherDecreasesSchedule/OtherDecreasesDetail/Amt03633
OtherDecreasesSchedule/OtherDecreasesDetail/Desc02023 TRANSACTION POSTED IN 2024
OtherIncreasesSchedule/OtherIncreasesDetail/Amt03152
OtherIncreasesSchedule/OtherIncreasesDetail/Amt12
OtherIncreasesSchedule/OtherIncreasesDetail/Desc02022 TRANSACTION POSTED IN 2023
OtherIncreasesSchedule/OtherIncreasesDetail/Desc1ROUNDING
TaxesSchedule/TaxesDetail/Amt0668
TaxesSchedule/TaxesDetail/Amt1259
TaxesSchedule/TaxesDetail/CategoryTxt0FEDERAL ESTIMATES - PRINCIPAL
TaxesSchedule/TaxesDetail/CategoryTxt1FOREIGN TAXES ON QUALIFIED FOR
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt10
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt1259
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0PNC BANK N A
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TAX MANAGER
ReturnHeader/BusinessOfficerGrp/PhoneNum04124671575
ReturnHeader/BusinessOfficerGrp/SignatureDt02024-03-31
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0RAPHAEL AVELLAR CHARITABLE TRUST
ReturnHeader/Filer/BusinessNameControlTxt0RAPH
ReturnHeader/Filer/EIN0272149604
ReturnHeader/Filer/PhoneNum04124671575
ReturnHeader/Filer/USAddress/AddressLine1Txt0116 ALLEGHENY CENTER MALL P8YB3502L
ReturnHeader/Filer/USAddress/CityNm0PITTSBURGH
ReturnHeader/Filer/USAddress/StateAbbreviationCd0PA
ReturnHeader/Filer/USAddress/ZIPCd015212
ReturnHeader/IRSResponsiblePrtyInfoCurrInd0true
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/PreparationDt02024-03-31
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JASON BELOT
ReturnHeader/ReturnTs02024-04-16T13:01:50-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02023-01-01
ReturnHeader/TaxPeriodEndDt02023-12-31
ReturnHeader/TaxYr02023

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings