Civic Intelligence

Robert E Brennan Trust Under Will

990PF • Fiscal year 2011 • EIN 61-6063803

Jan 01, 2011 to Dec 31, 2011 • Filed on Apr 26, 2012

C/O Pnc Bank 620 Liberty Avenue No10thfl15222-2705
Siviq Scores

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

Liabilities / Assets

14th percentile

0.00x

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

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

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2011

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2011

Top Officer Pay

72nd percentile

$46,576

Higher top officer pay than 72% of similar nonprofits.

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

Asset Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2011

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Assets

$10,320,865

No earlier filing loaded for comparison.

Net Assets

$10,320,865

No earlier filing loaded for comparison.

Liabilities

$0

No earlier filing loaded for comparison.

Revenue

-

No earlier filing loaded for comparison.

Expenses

$545,751

No earlier filing loaded for comparison.

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

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

2011

Assets$10,320,865
Liabilities$0
Net Assets$10,320,865

Operations Trend

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

2011

Revenue-
Expenses$545,751
Net Income-
Jump To
Filing Snapshot
Filing Period
Jan 1, 2011 to Dec 31, 2011
Signed
Apr 26, 2012
Return Version
2011v1.2
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
PNC BANK NATrusteePT$46,576-$46,576
Grants and Assistance

Foundation Grants and Related Investments

TypeRecipientPurposeStatusLocationAmount
Paid GrantEPISCOPAL DIOCESE OF KENTUCKYGENERAL SUPPORTPUBLIC CHARITYLEXINGTON, KY, US$113,967
Paid GrantCHILDREN'S HOSPITAL FOUNDATION INCGENERAL SUPPORTPUBLIC CHARITYLOUISVILLE, KY, US$113,967
Paid GrantTHE SALVATION ARMYGENERAL SUPPORTPUBLIC CHARITYLEXINGTON, KY, US$113,967
Paid GrantUNIVERSITY OF LOUISVILLE FOUNDATION INCGENERAL SUPPORTPUBLIC CHARITYLOUISVILLE, KY, US$113,966
Filing and Contact Details

Filer

EIN
61-6063803
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
AccountingFeesSchedule/AccountingFees/Amount0700
AccountingFeesSchedule/AccountingFees/Category0TAX PREP FEES
AccountingFeesSchedule/AccountingFees/DisbursementsCharitablePrps0700
AccountingFeesSchedule/AccountingFees/NetInvestmentIncome00
AllOthProgRltdInvestmentsSch/AllOthProgRltdInvestments/Amount00
AllOthProgRltdInvestmentsSch/AllOthProgRltdInvestments/Description0N/A
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue03177181
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV03843574
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock0CORPORATE STOCK
InvestmentsOtherSchedule2/InvestmentsOther/BookValue03728803
InvestmentsOtherSchedule2/InvestmentsOther/BookValue13182650
InvestmentsOtherSchedule2/InvestmentsOther/BookValue2908
InvestmentsOtherSchedule2/InvestmentsOther/CategoryOrItem0MUTUAL FUNDS - FIXED
InvestmentsOtherSchedule2/InvestmentsOther/CategoryOrItem1MUTUAL FUNDS - EQUITY
InvestmentsOtherSchedule2/InvestmentsOther/CategoryOrItem2LIMITED PARTNERSHIPS
InvestmentsOtherSchedule2/InvestmentsOther/EOYFMV03740071
InvestmentsOtherSchedule2/InvestmentsOther/EOYFMV13237925
InvestmentsOtherSchedule2/InvestmentsOther/EOYFMV2908
InvestmentsOtherSchedule2/InvestmentsOther/ListedAtCostOrFMV0AT COST
InvestmentsOtherSchedule2/InvestmentsOther/ListedAtCostOrFMV1AT COST
InvestmentsOtherSchedule2/InvestmentsOther/ListedAtCostOrFMV2AT COST
IRS990PF/AnalysisIncomeProducingActy/DividendsAndIntFromSecPartVII/ExclusionAmount0239102
IRS990PF/AnalysisIncomeProducingActy/DividendsAndIntFromSecPartVII/ExclusionCode014
IRS990PF/AnalysisIncomeProducingActy/GainSalesAssetsOthThanInvntry/ExclusionAmount0315184
IRS990PF/AnalysisIncomeProducingActy/GainSalesAssetsOthThanInvntry/ExclusionCode018
IRS990PF/AnalysisIncomeProducingActy/IntOnSavingsAndTempCashInvst/ExclusionAmount089
IRS990PF/AnalysisIncomeProducingActy/IntOnSavingsAndTempCashInvst/ExclusionCode014
IRS990PF/AnalysisIncomeProducingActy/OtherInvestmentIncomePartVII/ExclusionAmount050
IRS990PF/AnalysisIncomeProducingActy/OtherInvestmentIncomePartVII/ExclusionCode014
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/Description0CLASS ACTION PROCEEDS
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/Description1FOREIGN TAX REFUNDS
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/ExclusionAmount05268
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/ExclusionAmount1125
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/ExclusionCode014
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/ExclusionCode114
IRS990PF/AnalysisIncomeProducingActy/SubtotalsPartXVIA/ExclusionAmount0559818
IRS990PF/AnalysisIncomeProducingActy/SubtotalsPartXVIA/RelatedOrExemptFunctionIncome00
IRS990PF/AnalysisIncomeProducingActy/SubtotalsPartXVIA/UnrelatedBusinessIncomeAmount00
IRS990PF/AnalysisIncomeProducingActy/TotalPartXVIA0559818
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesDsbrsChrtblPrps0700
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncm00
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnss0700
IRS990PF/AnalysisOfRevenueAndExpenses/CapitalGainNetIncmNetInvstIncm0270231
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblPrps02329
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncm044247
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnss046576
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidDsbrsChrtblPrps0455867
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidRevAndExpnss0455867
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncm0239221
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnss0239102
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessOfRevenueOverExpenses014067
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPrice02797501
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsNetInvstIncm089
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsRevAndExpnss089
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAssetsRevAndExpnss0315184
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncome0439329
IRS990PF/AnalysisOfRevenueAndExpenses/NotRequiredToAttachScheduleB0X
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncm025910
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnss025885
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeNetInvstIncm0143
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnss05443
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncm0198
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnss016723
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblPrps0458896
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncm070355
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnss0545751
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvestmentIncome0509684
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevenueAndExpenses0559818
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblPrps03029
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncm070355
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnss089884
IRS990PF/BalanceSheets/CapitalStockBOY010179180
IRS990PF/BalanceSheets/CapitalStockEOY010170144
IRS990PF/BalanceSheets/InvestmentsCorpStockBOY03126726
IRS990PF/BalanceSheets/InvestmentsCorpStockEOY03177181
IRS990PF/BalanceSheets/InvestmentsCorpStockEOYFMV03843574
IRS990PF/BalanceSheets/InvestmentsOtherBOY06833368
IRS990PF/BalanceSheets/InvestmentsOtherEOY06912361
IRS990PF/BalanceSheets/InvestmentsOtherEOYFMV06978904
IRS990PF/BalanceSheets/OrgThatDoNotFollowSFAS1170X
IRS990PF/BalanceSheets/PaidInOrCapitalSurplusBOY00
IRS990PF/BalanceSheets/PaidInOrCapitalSurplusEOY00
IRS990PF/BalanceSheets/RetainedEarningsBOY0127618
IRS990PF/BalanceSheets/RetainedEarningsEOY0150721
IRS990PF/BalanceSheets/SavingsAndTempCashInvstBOY0346704
IRS990PF/BalanceSheets/SavingsAndTempCashInvstEOY0231323
IRS990PF/BalanceSheets/SavingsAndTempCashInvstEOYFMV02313263
IRS990PF/BalanceSheets/TotalAssetsBOY010306798
IRS990PF/BalanceSheets/TotalAssetsEOY010320865
IRS990PF/BalanceSheets/TotalAssetsEOYFMV013135741
IRS990PF/BalanceSheets/TotalLiabilitiesBOY00
IRS990PF/BalanceSheets/TotalLiabilitiesEOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsBOY010306798
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsEOY010320865
IRS990PF/BalanceSheets/TotalNetAssetsBOY010306798
IRS990PF/BalanceSheets/TotalNetAssetsEOY010320865
IRS990PF/CapitalGainsAndLosses/CapitalGainNetIncome0270231
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis02532566
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis1181
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset0SALES OF PUBLICLY TRADED SECURITIES
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset1CLASS ACTION SETTLEMENTS
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset2KKR FINANCIAL HOLDINGS LLC
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset3CAPITAL GAINS DIVIDENDS
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss0237567
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss15268
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss228
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss327368
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses0237567
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses15268
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses228
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses327368
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice02770133
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice15449
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice228
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice327368
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired0P
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired1P
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired2P
IRS990PF/ChangesInNetAssetsFundBalances/ExcessOfRevenueOverExpenses014067
IRS990PF/ChangesInNetAssetsFundBalances/OtherDecreases00
IRS990PF/ChangesInNetAssetsFundBalances/OtherIncreases00
IRS990PF/ChangesInNetAssetsFundBalances/Subtotal010320865
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesBOY010306798
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesEOY010320865
IRS990PF/DistributableAmount/DeductionFrDistributableAmount00
IRS990PF/DistributableAmount/DistributableAmountAsAdjusted0565830
IRS990PF/DistributableAmount/DistributableAmountBeforeAdj0565830
IRS990PF/DistributableAmount/DistributableAmountBeforeDed0565830
IRS990PF/DistributableAmount/MinimumInvestmentReturn0574617
IRS990PF/DistributableAmount/RecoveriesQlfyDistributions00
IRS990PF/DistributableAmount/TaxBasedOnInvestmentIncome08787
IRS990PF/DistributableAmount/TotalTax08787
IRS990PF/ExciseTaxBasedOnInvestmentIncm/EstTaxPaymentsAndOverpayment08280
IRS990PF/ExciseTaxBasedOnInvestmentIncm/InvestmentIncomeExciseTax08787
IRS990PF/ExciseTaxBasedOnInvestmentIncm/SubtitleATax00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/Subtotal08787
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxBasedOnInvestmentIncome08787
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxDue0507
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxUnderSection51100
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TotalCreditsAndPayments08280
IRS990PF/ExemptPF0X
IRS990PF/FMVAssetsEOY013135741
IRS990PF/MethodOfAccountingCash0X
IRS990PF/MinimumInvestmentReturn/AcquisitionIndebtedness00
IRS990PF/MinimumInvestmentReturn/AdjTotalFMVOfUnusedAssets011667340
IRS990PF/MinimumInvestmentReturn/AvgMonthlyCashBalances00
IRS990PF/MinimumInvestmentReturn/AvgMonthlyFMVOfSecurities011667340
IRS990PF/MinimumInvestmentReturn/CashDeemedCharitable0175010
IRS990PF/MinimumInvestmentReturn/FMVAllOtherNoncharitableAssets00
IRS990PF/MinimumInvestmentReturn/MinimumInvestmentReturn0574617
IRS990PF/MinimumInvestmentReturn/NetNoncharitableAssets011492330
IRS990PF/MinimumInvestmentReturn/ReductionClaimed00
IRS990PF/MinimumInvestmentReturn/TotalFMVOfUnusedAssets011667340
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHghstPaidCntrctNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHighestPaidEmplNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition010.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation046576
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName0PNC BANK NA
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title0TRUSTEE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine10620 LIBERTY AVENUE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City0PITTSBURGH
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State0PA
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode0152222705
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/TotNumberOfCntrctPaidOver50k00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/TotNumberOfOthEmplPaidOver50k00
IRS990PF/QlfyUndSect4940eForReducedTax/AdjNonchrtblAssetsAndOnePct0533948
IRS990PF/QlfyUndSect4940eForReducedTax/AdjustedNoncharitableAssets0529555
IRS990PF/QlfyUndSect4940eForReducedTax/AverageDistributionRatio00.046079
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear100.046079
IRS990PF/QlfyUndSect4940eForReducedTax/LiableFor4942Tax00
IRS990PF/QlfyUndSect4940eForReducedTax/NetNoncharitableAssets011492330
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear1010790292
IRS990PF/QlfyUndSect4940eForReducedTax/OnePercentNetInvestmentIncome04393
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributions0458896
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear10497208
IRS990PF/QlfyUndSect4940eForReducedTax/TotalDistributionRatio00.046079
IRS990PF/QualifyingDistributions/AdjQualifyingDistributions0458896
IRS990PF/QualifyingDistributions/ExpensesAndContributions0458896
IRS990PF/QualifyingDistributions/OnePctSect4940eOrgNetInvstIncm00
IRS990PF/QualifyingDistributions/ProgramRelatedInvestmentsTotal00
IRS990PF/QualifyingDistributions/QualifyingDistributions0458896
IRS990PF/StatementsRegardingActivities/ActivitiesNotPrevReported00
IRS990PF/StatementsRegardingActivities/ApplicableInsuranceContract00
IRS990PF/StatementsRegardingActivities/AtLeast5000InAssets01
IRS990PF/StatementsRegardingActivities/BooksInCareOfBusinessName/BusinessNameLine10PNC BANK NA
IRS990PF/StatementsRegardingActivities/BooksInCareOfPhoneNumber04127620861
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine10620 LIBERTY AVENUE 10TH FL
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/City0PITTSBURGH
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/State0PA
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/ZIPCode0152222705
IRS990PF/StatementsRegardingActivities/ChangesToArticlesOrBylaws00
IRS990PF/StatementsRegardingActivities/ComplyWithPublicInspectionRqr01
IRS990PF/StatementsRegardingActivities/ForeignBank00
IRS990PF/StatementsRegardingActivities/Form1120POLFiled00
IRS990PF/StatementsRegardingActivities/Form990PFFiledWithAG01
IRS990PF/StatementsRegardingActivities/InterestInControlledEntity00
IRS990PF/StatementsRegardingActivities/LegislativePoliticalActivities00
IRS990PF/StatementsRegardingActivities/MoreThan100Spent00
IRS990PF/StatementsRegardingActivities/NewSubstantialContributors00
IRS990PF/StatementsRegardingActivities/PrivateOperatingFoundation00
IRS990PF/StatementsRegardingActivities/ReimbursementOfTax00
IRS990PF/StatementsRegardingActivities/RequirementsOfSect508e01
IRS990PF/StatementsRegardingActivities/Sect4955TaxOnManagers00
IRS990PF/StatementsRegardingActivities/Sect4955TaxOnOrganization00
IRS990PF/StatementsRegardingActivities/StatesFiledWith0KY
IRS990PF/StatementsRegardingActivities/TerminationEtc00
IRS990PF/StatementsRegardingActivities/UnrelatedBusIncomeOver100000
IRS990PF/StatementsRegardingActivities/WebsiteAddress0N/A
IRS990PF/StatementsRegardingActy4720/ActsFailToQualifyAsExceptions00
IRS990PF/StatementsRegardingActy4720/BorrowOrLendWithDsqflyPerson00
IRS990PF/StatementsRegardingActy4720/BusinessHoldings00
IRS990PF/StatementsRegardingActy4720/FurnishedGoodsWithDsqflyPerson00
IRS990PF/StatementsRegardingActy4720/GrantsToIndividuals00
IRS990PF/StatementsRegardingActy4720/GrantsToOrganizations00
IRS990PF/StatementsRegardingActy4720/InfluenceElection00
IRS990PF/StatementsRegardingActy4720/InfluenceLegislation00
IRS990PF/StatementsRegardingActy4720/JeopardyInvestments00
IRS990PF/StatementsRegardingActy4720/NoncharitablePurpose00
IRS990PF/StatementsRegardingActy4720/PayCompensationToDsqflyPerson01
IRS990PF/StatementsRegardingActy4720/PaymentToGovernmentOffical00
IRS990PF/StatementsRegardingActy4720/PayPremiumsPrsnlBnftContract00
IRS990PF/StatementsRegardingActy4720/ProhibitedTaxShelterTransactn00
IRS990PF/StatementsRegardingActy4720/RcvFundsToPayPrsnlBnftContract00
IRS990PF/StatementsRegardingActy4720/SaleOrExchangeWithDsqflyPerson00
IRS990PF/StatementsRegardingActy4720/TransferAssetsToDsqflyPerson00
IRS990PF/StatementsRegardingActy4720/UncorrectedJeopardyInvestments00
IRS990PF/StatementsRegardingActy4720/UncorrectedPriorActs00
IRS990PF/StatementsRegardingActy4720/UndistributedIncomePriorYears00
IRS990PF/SummaryOfDirectCharitableActy/Description10N/A
IRS990PF/SummaryOfDirectCharitableActy/Expenses100
IRS990PF/SumOfProgramRelatedInvestments/AllOthProgRltdInvestmentsTotal00
IRS990PF/SumOfProgramRelatedInvestments/Amount100
IRS990PF/SumOfProgramRelatedInvestments/Description10N/A
IRS990PF/SumOfProgramRelatedInvestments/Total00
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount0113967
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount1113967
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount2113967
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount3113966
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution0GENERAL SUPPORT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution1GENERAL SUPPORT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution2GENERAL SUPPORT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution3GENERAL SUPPORT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine10EPISCOPAL DIOCESE OF KENTUCKY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine11CHILDREN'S HOSPITAL FOUNDATION INC
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine12THE SALVATION ARMY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine13UNIVERSITY OF LOUISVILLE FOUNDATION INC
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus0PUBLIC CHARITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus1PUBLIC CHARITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus2PUBLIC CHARITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus3PUBLIC CHARITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship0NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship1NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship2NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship3NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine10425 S 2ND STREET STE 200
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine11234 GRAY STREET STE 450
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine12216 W CHESTNUT STREET
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine13SERVICE COMPLEX
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City0LEXINGTON
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City1LOUISVILLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City2LEXINGTON
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City3LOUISVILLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State0KY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State1KY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State2KY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State3KY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode040202
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode140202
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode2402012229
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode340292
IRS990PF/SupplementaryInformation/OnlyContributesToPreselected0X
IRS990PF/SupplementaryInformation/TotGrantOrContriApprovedFuture00
IRS990PF/SupplementaryInformation/TotGrantOrContriPaidDuringYear0455867
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/LoansOrLoanGuarantees00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PerformanceOfServicesEtc00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PurchaseAssetsNoncharitableEO00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/ReimbursementArrangements00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RelationshipsNoncharitableEOs00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RentalOfFacilitiesEtc00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SalesOrExchangesOfAssets00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SharingOfFacilitiesEtc00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOfCashToNoncharitableEO00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOthAssetsNoncharitableEO00
IRS990PF/UndistributedIncome/AppliedToCurrentYear0424834
IRS990PF/UndistributedIncome/AppliedToPriorYears00
IRS990PF/UndistributedIncome/AppliedToYear1034062
IRS990PF/UndistributedIncome/DistributableAmountAsAdjusted0565830
IRS990PF/UndistributedIncome/DistriFromCorpus170b1EOr4942g300
IRS990PF/UndistributedIncome/ExcessDistriCyovAppCYCorpus00
IRS990PF/UndistributedIncome/ExcessDistriCyovAppliedCY00
IRS990PF/UndistributedIncome/ExcessDistriCyovFromYear500
IRS990PF/UndistributedIncome/ExcessDistriCyovToNextYear00
IRS990PF/UndistributedIncome/PriorYearDeficiencyOrTax00
IRS990PF/UndistributedIncome/PriorYearUndistributedIncome00
IRS990PF/UndistributedIncome/QualifyingDistributions0458896
IRS990PF/UndistributedIncome/RemainingDistriFromCorpus00
IRS990PF/UndistributedIncome/TaxableAmount100
IRS990PF/UndistributedIncome/TaxableAmount200
IRS990PF/UndistributedIncome/TotalCorpus00
IRS990PF/UndistributedIncome/TotalExcessDistriCarryover00
IRS990PF/UndistributedIncome/TotalForPriorYears00
IRS990PF/UndistributedIncome/TreatedAsDistriFromCorpus00
IRS990PF/UndistributedIncome/UndistributedIncomeCY0140996
IRS990PF/UndistributedIncome/UndistributedIncomePriorYear034062
OtherExpensesSchedule/OtherExpenses/Description0MAP MANAGER FEES
OtherExpensesSchedule/OtherExpenses/Description1INVESTMENT INTEREST EXPENSE
OtherExpensesSchedule/OtherExpenses/Description2FOREIGN TAX PROCESSING FEES
OtherExpensesSchedule/OtherExpenses/DisbursementsCharitablePrps00
OtherExpensesSchedule/OtherExpenses/DisbursementsCharitablePrps10
OtherExpensesSchedule/OtherExpenses/DisbursementsCharitablePrps20
OtherExpensesSchedule/OtherExpenses/NetInvestmentIncome025798
OtherExpensesSchedule/OtherExpenses/NetInvestmentIncome125
OtherExpensesSchedule/OtherExpenses/NetInvestmentIncome287
OtherExpensesSchedule/OtherExpenses/RevenueAndExpensesPerBooks025798
OtherExpensesSchedule/OtherExpenses/RevenueAndExpensesPerBooks10
OtherExpensesSchedule/OtherExpenses/RevenueAndExpensesPerBooks287
OtherIncomeSchedule2/OtherIncome/AdjustedNetIncome050
OtherIncomeSchedule2/OtherIncome/AdjustedNetIncome15268
OtherIncomeSchedule2/OtherIncome/AdjustedNetIncome2125
OtherIncomeSchedule2/OtherIncome/Description0PARTNERSHIP DISTRIBUTIONS
OtherIncomeSchedule2/OtherIncome/Description1ROYALTIES FROM PARTNERSHIP K-1
OtherIncomeSchedule2/OtherIncome/Description2PARTNERSHIP INCOME FROM K-1S
OtherIncomeSchedule2/OtherIncome/Description3CLASS ACTION PROCEEDS
OtherIncomeSchedule2/OtherIncome/Description4FOREIGN TAX REFUNDS
OtherIncomeSchedule2/OtherIncome/NetInvestmentIncome00
OtherIncomeSchedule2/OtherIncome/NetInvestmentIncome12
OtherIncomeSchedule2/OtherIncome/NetInvestmentIncome216
OtherIncomeSchedule2/OtherIncome/NetInvestmentIncome3125
OtherIncomeSchedule2/OtherIncome/RevenueAndExpensesPerBooks050
OtherIncomeSchedule2/OtherIncome/RevenueAndExpensesPerBooks15268
OtherIncomeSchedule2/OtherIncome/RevenueAndExpensesPerBooks2125
TaxesSchedule/Taxes/Amount0198
TaxesSchedule/Taxes/Amount18245
TaxesSchedule/Taxes/Amount28280
TaxesSchedule/Taxes/Category0FOREIGN TAX PAID
TaxesSchedule/Taxes/Category12010 EXCISE TAX BALANCE DUE
TaxesSchedule/Taxes/Category22011 ESTIMATED EXCISE TAX PAID
TaxesSchedule/Taxes/DisbursementsCharitablePrps00
TaxesSchedule/Taxes/DisbursementsCharitablePrps10
TaxesSchedule/Taxes/DisbursementsCharitablePrps20
TaxesSchedule/Taxes/NetInvestmentIncome0198
TaxesSchedule/Taxes/NetInvestmentIncome10
TaxesSchedule/Taxes/NetInvestmentIncome20
ReturnHeader/BuildTS02016-02-24 21:20:13Z
ReturnHeader/Filer/EIN0616063803
ReturnHeader/Filer/Name/BusinessNameLine10ROBERT E BRENNAN TRUST UNDER WILL
ReturnHeader/Filer/NameControl0BREN
ReturnHeader/Filer/Phone04127620861
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/Officer/DateSigned02012-04-26
ReturnHeader/Officer/Name0JOHN W ALRUTZ
ReturnHeader/Officer/Phone04127620861
ReturnHeader/Officer/Title0ASSISTANT VICE-PRESIDENT
ReturnHeader/ReturnType0990PF
ReturnHeader/TaxPeriodBeginDate02011-01-01
ReturnHeader/TaxPeriodEndDate02011-12-31
ReturnHeader/TaxYear02011
ReturnHeader/Timestamp02012-04-26T14:02:42-05:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

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