Civic Intelligence

Robert E Brennan Trust Under Will

990PF • Fiscal year 2013 • EIN 61-6063803

Jan 01, 2013 to Dec 31, 2013 • Filed on May 01, 2014

Organization Profile
C/O Pnc Bank 620 Liberty Avenue No10thfl15222-2705

(412) 762-0861

Siviq Scores

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

Liabilities / Assets

15th percentile

0.00x

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

2013 filings • $10M-$25M nonprofits • Source year 2013

Liabilities / Revenue

19th percentile

0.00x

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

2013 filings • $10M-$25M nonprofits • Source year 2013

Net Margin

92nd percentile

68%

Higher net margin than 92% of similar nonprofits.

2013 filings • $10M-$25M nonprofits • Source year 2013

Top Officer Pay

32nd percentile

$55,309

Higher top officer pay than 32% of similar nonprofits.

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

2013 filings • $10M-$25M nonprofits • Source year 2013

Asset Growth

75th percentile

11%

Faster asset growth than 75% of similar nonprofits.

2013 filings • $10M-$25M nonprofits • Annualized from 2012 to 2013

Revenue Growth

89th percentile

96%

Faster revenue growth than 89% of similar nonprofits.

2013 filings • $10M-$25M nonprofits • Annualized from 2012 to 2013

Balance Sheet
Liabilities / Assets15th percentile

Assets

Up

$11,935,362

Up $1,227,646 (+11%) from 2012

Net Assets

$11,935,362

No earlier filing loaded for comparison.

Liabilities

Down

$0

Down $1 (-100%) from 2012

Revenue And Expenses
Liabilities / Revenue19th percentileNet Margin92nd percentile

Revenue

Up

$1,802,744

Up $881,590 (+96%) from 2012

Expenses

Up

$575,264

Up $39,960 (+7.5%) from 2012

Net Income

Up

$1,227,480

Up $841,630 (+218%) from 2012

Historical Trend

Balance Sheet Trend

Asset Growth75th percentile

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

$15M$10M$5.0M$0Assets 2011: $10,320,865Liabilities 2011: $0Net Assets 2011: $10,320,8652011Assets 2012: $10,707,716Liabilities 2012: $12012Assets 2013: $11,935,362Liabilities 2013: $0Net Assets 2013: $11,935,3622013Assets 2014: $12,038,327Liabilities 2014: $12014Assets 2015: $12,686,198Liabilities 2015: $0Net Assets 2015: $12,686,1982015Assets 2016: $12,386,375Liabilities 2016: $0Net Assets 2016: $12,386,3752016Assets 2017: $12,774,145Liabilities 2017: $0Net Assets 2017: $12,774,1452017Assets 2018: $12,963,164Liabilities 2018: $0Net Assets 2018: $12,963,1642018Assets 2019: $13,055,486Liabilities 2019: $0Net Assets 2019: $13,055,4862019Assets 2020: $13,059,305Liabilities 2020: $0Net Assets 2020: $13,059,3052020Assets 2021: $13,822,496Liabilities 2021: $0Net Assets 2021: $13,822,4962021Assets 2022: $14,389,599Liabilities 2022: $0Net Assets 2022: $14,389,5992022Assets 2023: $14,446,724Liabilities 2023: $12023Assets 2024: $14,550,655Liabilities 2024: $0Net Assets 2024: $14,550,6552024

Highlighted filing

2013

Assets$11,935,362
Liabilities$0
Net Assets$11,935,362
Open 2013 Filing

Operations Trend

Revenue Growth89th percentile

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

$2.0M$1.0M$0-$1.0MExpenses 2011: $545,7512011Revenue 2012: $921,154Expenses 2012: $535,304Net Income 2012: $385,8502012Revenue 2013: $1,802,744Expenses 2013: $575,264Net Income 2013: $1,227,4802013Revenue 2014: $1,046,636Expenses 2014: $653,999Net Income 2014: $392,6372014Revenue 2015: $1,336,612Expenses 2015: $688,754Net Income 2015: $647,8582015Revenue 2016: $438,756Expenses 2016: $738,513Net Income 2016: -$299,7572016Revenue 2017: $1,160,819Expenses 2017: $773,049Net Income 2017: $387,7702017Revenue 2018: $1,007,996Expenses 2018: $818,978Net Income 2018: $189,0182018Revenue 2019: $942,413Expenses 2019: $850,089Net Income 2019: $92,3242019Revenue 2020: $886,361Expenses 2020: $867,282Net Income 2020: $19,0792020Revenue 2021: $1,664,760Expenses 2021: $911,288Net Income 2021: $753,4722021Revenue 2022: $1,666,272Expenses 2022: $1,074,886Net Income 2022: $591,3862022Revenue 2023: $940,817Expenses 2023: $899,524Net Income 2023: $41,2932023Revenue 2024: $994,177Expenses 2024: $886,487Net Income 2024: $107,6902024

Highlighted filing

2013

Revenue$1,802,744
Expenses$575,264
Net Income$1,227,480
Open 2013 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2013 to Dec 31, 2013
Signed
May 1, 2014
Return Version
2013v3.0
Compensation and Service Providers
Top Officer Pay32nd percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
PNC BANK NATrusteePT$55,309-$55,309
Filing and Contact Details

Filer

EIN
61-6063803
Phone
4127620861

Signing Officer

Name
John W Alrutz
Title
Assistant Vice-president
Phone
4127620861
Signed
2014-05-01
Raw XML Appendix369 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
AllOthProgRltdInvestmentsSch/AllOtherProgramRelatedInvstGrp/Amt00
AllOthProgRltdInvestmentsSch/AllOtherProgramRelatedInvstGrp/Desc0N/A
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt0945731
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt01415014
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0CORPORATE STOCK
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt04274810
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt16278287
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0MUTUAL FUNDS - FIXED
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1MUTUAL FUNDS - EQUITY
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt04168750
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt17729116
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd1AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt0269556
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt01520217
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionAmt048
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/OtherInvestmentIncmPartVIIGrp/ExclusionAmt013
IRS990PF/AnalysisIncomeProducingActyGrp/OtherInvestmentIncmPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/Desc0CLASS ACTION PROCEEDS
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/Desc1PROCEEDS FROM CASH & STOCK MERGERS
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/Desc2FOREIGN TAX REFUNDS
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/Desc3MAP MANAGER FEE REIMBURSMENTS
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/ExclusionAmt0780
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/ExclusionAmt110807
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/ExclusionAmt270
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/ExclusionAmt31253
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/ExclusionCd114
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/ExclusionCd214
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/ExclusionCd314
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt01802744
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt01802744
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt01619421
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt02765
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt052544
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt055309
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt0482189
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt0482189
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt0269569
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt0269556
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt01227480
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt06429566
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt048
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt048
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt01520217
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt01824018
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncmAmt013531
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt013531
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeNetInvstIncmAmt01323
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnssAmt012923
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt0268
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt024235
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt0484954
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt066343
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt0575264
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt01890361
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt01802744
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt02765
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt066343
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt093075
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt04813665
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt18067
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt228
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt01415421
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt12740
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt2780
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt3200480
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt01415421
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt12740
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt2780
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt3200480
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt06229086
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt110807
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt2808
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt3200480
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd1P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd2P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0SALE OF PUBLICLY TRADED SECURITIES
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1PERRIGO CASH & STOCK MERGER
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc2CLASS ACTION SETTLEMENTS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc3CAPITAL GAINS DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt01619421
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt01227480
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt0166
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt011935362
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt010707716
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt011935362
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt0595813
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt0595813
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt0595813
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt0632293
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt036480
IRS990PF/DistributableAmountGrp/TotalTaxAmt036480
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt016400
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt036480
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt036480
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt036480
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt020080
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt016400
IRS990PF/FMVAssetsEOYAmt013749414
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt010484197
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt011706607
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt02258580
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0945731
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt01415014
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt08080498
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt010553097
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt011897866
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0223519
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0228755
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt0368638
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt0436534
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt0436534
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt010707716
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt011935362
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt013749414
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt010707716
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt011935362
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt010707716
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt011935362
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt012838434
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt012838434
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt0192577
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt0632293
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt012645857
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt012838434
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt010.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt055309
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0PNC BANK NA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine10620 LIBERTY AVENUE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/City0PITTSBURGH
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/State0PA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCode0152222705
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt0527092
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt0545332
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt0456341
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt0458896
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt0497208
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.041681
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.039034
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.039931
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.046079
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt018240
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt012645857
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt011690810
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt011492330
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt010790292
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt0484954
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.125044
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt0484954
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt0484954
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt0484954
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd00
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd00
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd00
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd00
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd00
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd01
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd00
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd00
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd00
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd00
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd00
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd01
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd00
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd01
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd00
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd00
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd00
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd01
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd00
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine10620 LIBERTY AVENUE 10TH FL
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/City0PITTSBURGH
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/State0PA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCode0152222705
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd00
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd00
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd00
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0KY
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd00
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine10PNC BANK NA
IRS990PF/StatementsRegardingActyGrp/PhoneNum04127620861
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd00
IRS990PF/StatementsRegardingActyGrp/Section4955ManagersTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section4955OrganizationTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd01
IRS990PF/StatementsRegardingActyGrp/TaxReimbursedAmt00
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd00
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SummaryOfDirectChrtblActyGrp/Description1Txt0N/A
IRS990PF/SummaryOfDirectChrtblActyGrp/Expenses1Amt00
IRS990PF/SumOfProgramRelatedInvstGrp/AllOtherProgramRltdInvstTotAmt00
IRS990PF/SumOfProgramRelatedInvstGrp/Description1Txt0N/A
IRS990PF/SumOfProgramRelatedInvstGrp/Expenses1Amt00
IRS990PF/SumOfProgramRelatedInvstGrp/TotalAmt00
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt0120547
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt1120547
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt2120547
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt3120548
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0GENERAL SUPPORT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1GENERAL SUPPORT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2GENERAL SUPPORT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt3GENERAL SUPPORT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine10CHILDREN'S HOSPITAL FOUNDATION INC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine11EPISCOPAL DIOCESE OF KENTUCKY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine12THE SALVATION ARMY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine13UNIVERSITY OF LOUISVILLE FOUNDATION INC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt2PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt3PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt2NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt3NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine10234 GRAY STREET STE 450
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine11425 S 2ND STREET STE 200
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine12216 W CHESTNUT STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine13SERVICE COMPLEX
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/City0LOUISVILLE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/City1LEXINGTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/City2LEXINGTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/City3LOUISVILLE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/State0KY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/State1KY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/State2KY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/State3KY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCode040202
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCode140202
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCode2402012229
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCode340292
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt0482189
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd00
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt0232125
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt0252829
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt0595813
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt0484954
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt0363688
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt0252829
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0MAP MANAGER FEES
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc1PROCESSING FEES ON FOREIGN DIVIDENDS
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt10
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt013421
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt1110
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt013421
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt1110
OtherIncomeSchedule2/OtherIncomeDetail/AdjustedNetIncomeAmt013
OtherIncomeSchedule2/OtherIncomeDetail/AdjustedNetIncomeAmt1780
OtherIncomeSchedule2/OtherIncomeDetail/AdjustedNetIncomeAmt210807
OtherIncomeSchedule2/OtherIncomeDetail/AdjustedNetIncomeAmt370
OtherIncomeSchedule2/OtherIncomeDetail/AdjustedNetIncomeAmt41253
OtherIncomeSchedule2/OtherIncomeDetail/Desc0PARTNERSHIP DISTRIBUTIONS
OtherIncomeSchedule2/OtherIncomeDetail/Desc1CLASS ACTION PROCEEDS
OtherIncomeSchedule2/OtherIncomeDetail/Desc2PROCEEDS FROM CASH & STOCK MERGERS
OtherIncomeSchedule2/OtherIncomeDetail/Desc3FOREIGN TAX REFUNDS
OtherIncomeSchedule2/OtherIncomeDetail/Desc4MAP MANAGER FEE REIMBURSMENTS
OtherIncomeSchedule2/OtherIncomeDetail/NetInvestmentIncomeAmt00
OtherIncomeSchedule2/OtherIncomeDetail/NetInvestmentIncomeAmt170
OtherIncomeSchedule2/OtherIncomeDetail/NetInvestmentIncomeAmt21253
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt013
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt1780
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt210807
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt370
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt41253
OtherIncreasesSchedule/OtherIncreasesDetail/Amount0166
OtherIncreasesSchedule/OtherIncreasesDetail/Description0TWO HARBORS SHARES RECEIVED THROUGH STOCK DISTRIBUTION
TaxesSchedule/TaxesDetail/Amt0268
TaxesSchedule/TaxesDetail/Amt116400
TaxesSchedule/TaxesDetail/Amt27567
TaxesSchedule/TaxesDetail/CategoryTxt0FOREIGN TAX PAID
TaxesSchedule/TaxesDetail/CategoryTxt12013 ESTIMATED EXCISE TAX PAID
TaxesSchedule/TaxesDetail/CategoryTxt22012 FEDERAL EXCISE TAX BALANCE DUE
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt10
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt20
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt0268
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt10
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt20
ReturnHeader/BuildTS02015-12-30 17:16:21Z
ReturnHeader/BusinessOfficerGrp/PersonNm0JOHN W ALRUTZ
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0ASSISTANT VICE-PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum04127620861
ReturnHeader/BusinessOfficerGrp/SignatureDt02014-05-01
ReturnHeader/Filer/BusinessName/BusinessNameLine10ROBERT E BRENNAN TRUST UNDER WILL
ReturnHeader/Filer/BusinessNameControlTxt0BREN
ReturnHeader/Filer/EIN0616063803
ReturnHeader/Filer/PhoneNum04127620861
ReturnHeader/Filer/USAddress/AddressLine10C/O PNC BANK 620 LIBERTY AVENUE NO
ReturnHeader/Filer/USAddress/AddressLine2010THFL
ReturnHeader/Filer/USAddress/City0PITTSBURGH
ReturnHeader/Filer/USAddress/State0PA
ReturnHeader/Filer/USAddress/ZIPCode0152222705
ReturnHeader/ReturnTs02014-05-01T14:05:51-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02013-01-01
ReturnHeader/TaxPeriodEndDt02013-12-31
ReturnHeader/TaxYr02013

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$11,935,362
Liabilities
$0
Net assets
$11,935,362
Revenue
$1,802,744
Expenses
$575,264
Net income
$1,227,480
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$14.6$0.00$14.6$0.99$0.89$0.11
2023Summary only. Only limited summary data is available for this year.$14.4$0.00$0.94$0.90$0.04
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$14.4$0.00$14.4$1.67$1.07$0.59
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$13.8$0.00$13.8$1.66$0.91$0.75
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$13.1$0.00$13.1$0.89$0.87$0.02
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$13.1$0.00$13.1$0.94$0.85$0.09
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$13.0$0.00$13.0$1.01$0.82$0.19
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$12.8$0.00$12.8$1.16$0.77$0.39
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$12.4$0.00$12.4$0.44$0.74$0.30
2015Detailed filing. Detailed filing data is available for this year.$12.7$0.00$12.7$1.34$0.69$0.65
2014Summary only. Only limited summary data is available for this year.$12.0$0.00$1.05$0.65$0.39
2013Detailed filing. Detailed filing data is available for this year.$11.9$0.00$11.9$1.80$0.58$1.23
2012Summary only. Only limited summary data is available for this year.$10.7$0.00$0.92$0.54$0.39
2011Detailed filing. Detailed filing data is available for this year.$10.3$0.00$10.3$0.55