STRATEGY STUDIO / PUBLIC DATA EXPLORER

BERNARD R BRENNAN CHARITABLE TR: Form 990PF, tax year 2011

View the entire original 990 at ProPublica ↗

Organization
BERNARD R BRENNAN CHARITABLE TR (EIN 36-7494242)
Tax period
2011-01-01 to 2011-12-31
Filed
2012-05-08
IRS object ID
201211299349100601
Schema version
2011v1.2
Source
Download XML · Original 990 at ProPublica

Every field in the e-filed return. Faint text is the IRS element name, for citing.

Return header ReturnHeader

FieldValueIRS element (for citing)
Timestamp2012-05-08T07:42:29-04:00Timestamp
Tax Period End Date2011-12-31TaxPeriodEndDate

Preparer Firm PreparerFirm

Preparer Firm Business Name PreparerFirmBusinessName

FieldValueIRS element (for citing)
Business Name Line1BKD LLPBusinessNameLine1

Preparer Firm US Address PreparerFirmUSAddress

FieldValueIRS element (for citing)
Address Line1200 E Main St Suite 700AddressLine1
CityFort WayneCity
StateINState
ZIP Code46802ZIPCode
FieldValueIRS element (for citing)
Return Type990PFReturnType
Tax Period Begin Date2011-01-01TaxPeriodBeginDate

Filer Filer

FieldValueIRS element (for citing)
EIN367494242EIN

Name Name

FieldValueIRS element (for citing)
Business Name Line1BERNARD R BRENNAN CHARITABLE TRUSTBusinessNameLine1
FieldValueIRS element (for citing)
In Care Of Name% DAVID E BRENNANInCareOfName
Name ControlBERNNameControl
Phone2609271890Phone

US Address USAddress

FieldValueIRS element (for citing)
Address Line11812 N DEWEY STREETAddressLine1
CityAUBURNCity
StateINState
ZIP Code46706ZIPCode

Officer Officer

FieldValueIRS element (for citing)
NameDAVID E BRENNANName
TitleTRUSTEETitle
Date Signed2012-05-15DateSigned
Authorize Third PartytrueAuthorizeThirdParty

Preparer Preparer

FieldValueIRS element (for citing)
NameJoyce A DulworthName
Phone2604604000Phone
FieldValueIRS element (for citing)
Tax Year2011TaxYear
Build TS2016-02-24 21:20:13ZBuildTS

Form 990-PF IRS990PF

FieldValueIRS element (for citing)
Exempt PFXExemptPF
FMV Assets EOY1787501FMVAssetsEOY
Method Of Accounting CashXMethodOfAccountingCash

Analysis Of Revenue And Expenses AnalysisOfRevenueAndExpenses

FieldValueIRS element (for citing)
Contri Received Rev And Expnss0ContriReceivedRevAndExpnss
Not Required To Attach Schedule BXNotRequiredToAttachScheduleB
Dividends Rev And Expnss48995DividendsRevAndExpnss
Dividends Net Invst Incm48995DividendsNetInvstIncm
Net Gain Sale Assets Rev And Expnss6543NetGainSaleAssetsRevAndExpnss
Gross Sales Price74837GrossSalesPrice
Capital Gain Net Incm Net Invst Incm6543CapitalGainNetIncmNetInvstIncm
Other Income Rev And Expnss1086OtherIncomeRevAndExpnss
Total Revenue And Expenses56624TotalRevenueAndExpenses
Total Net Investment Income55538TotalNetInvestmentIncome
Comp Ofcr Dir Trst Rev And Expnss1000CompOfcrDirTrstRevAndExpnss
Comp Ofcr Dir Trst Net Invst Incm500CompOfcrDirTrstNetInvstIncm
Comp Ofcr Dir Trst Dsbrs Chrtbl Prps500CompOfcrDirTrstDsbrsChrtblPrps
Accounting Fees Rev And Expnss1850AccountingFeesRevAndExpnss
Accounting Fees Net Invst Incm0AccountingFeesNetInvstIncm
Accounting Fees Adj Net Incm0AccountingFeesAdjNetIncm
Accounting Fees Dsbrs Chrtbl Prps1850AccountingFeesDsbrsChrtblPrps
Other Prof Fees Rev And Expnss7200OtherProfFeesRevAndExpnss
Other Prof Fees Net Invst Incm7200OtherProfFeesNetInvstIncm
Taxes Rev And Expnss1102TaxesRevAndExpnss
Taxes Net Invst Incm466TaxesNetInvstIncm
Tot Opr Expenses Rev And Expnss11152TotOprExpensesRevAndExpnss
Tot Opr Expenses Net Invst Incm8166TotOprExpensesNetInvstIncm
Tot Opr Expenses Adj Net Incm0TotOprExpensesAdjNetIncm
Tot Opr Expenses Dsbrs Chrtbl Prps2350TotOprExpensesDsbrsChrtblPrps
Contri Gifts Paid Rev And Expnss88052ContriGiftsPaidRevAndExpnss
Contri Gifts Paid Dsbrs Chrtbl Prps88052ContriGiftsPaidDsbrsChrtblPrps
Total Expenses Rev And Expnss99204TotalExpensesRevAndExpnss
Total Expenses Net Invst Incm8166TotalExpensesNetInvstIncm
Total Expenses Adj Net Incm0TotalExpensesAdjNetIncm
Total Expenses Dsbrs Chrtbl Prps90402TotalExpensesDsbrsChrtblPrps
Excess Of Revenue Over Expenses-42580ExcessOfRevenueOverExpenses
Net Investment Income47372NetInvestmentIncome

Balance Sheets BalanceSheets

FieldValueIRS element (for citing)
Cash BOY99CashBOY
Cash EOY91CashEOY
Cash EOYFMV91CashEOYFMV
Savings And Temp Cash Invst BOY27779SavingsAndTempCashInvstBOY
Savings And Temp Cash Invst EOY50641SavingsAndTempCashInvstEOY
Savings And Temp Cash Invst EOYFMV50641SavingsAndTempCashInvstEOYFMV
Investments Corp Stock BOY1647710InvestmentsCorpStockBOY
Investments Corp Stock EOY1582511InvestmentsCorpStockEOY
Investments Corp Stock EOYFMV1736769InvestmentsCorpStockEOYFMV
Investments Corp Bonds BOY1040InvestmentsCorpBondsBOY
Investments Corp Bonds EOY1040InvestmentsCorpBondsEOY
Investments Corp Bonds EOYFMV0InvestmentsCorpBondsEOYFMV
Total Assets BOY1676628TotalAssetsBOY
Total Assets EOY1634283TotalAssetsEOY
Total Assets EOYFMV1787501TotalAssetsEOYFMV
Total Liabilities EOY0TotalLiabilitiesEOY
Org That Do Not Follow SFAS117XOrgThatDoNotFollowSFAS117
Retained Earnings BOY1676628RetainedEarningsBOY
Retained Earnings EOY1634283RetainedEarningsEOY
Total Net Assets BOY1676628TotalNetAssetsBOY
Total Net Assets EOY1634283TotalNetAssetsEOY
Total Liabilities Net Assets BOY1676628TotalLiabilitiesNetAssetsBOY
Total Liabilities Net Assets EOY1634283TotalLiabilitiesNetAssetsEOY

Changes In Net Assets Fund Balances ChangesInNetAssetsFundBalances

FieldValueIRS element (for citing)
Total Net Assets Fund Balances BOY1676628TotalNetAssetsFundBalancesBOY
Excess Of Revenue Over Expenses-42580ExcessOfRevenueOverExpenses
Other Increases235OtherIncreases
Subtotal1634283Subtotal
Total Net Assets Fund Balances EOY1634283TotalNetAssetsFundBalancesEOY

Capital Gains And Losses CapitalGainsAndLosses

Capital Gains And Losses Info CapitalGainsAndLossesInfo (2 entries)

Description Of AssetDescriptionOfAssetGross Sales PriceGrossSalesPriceCost Or Other BasisCostOrOtherBasisGain Or LossGainOrLossGains Minus Excess Or LossesGainsMinusExcessOrLossesHow AcquiredHowAcquired
FIDELITY LT CAPITAL GAIN703836829420892089
CAPITAL GAIN DIVIDENDS4454P
FieldValueIRS element (for citing)
Capital Gain Net Income6543CapitalGainNetIncome

Qlfy Und Sect4940e For Reduced Tax QlfyUndSect4940eForReducedTax

FieldValueIRS element (for citing)
Liable For4942 TaxfalseLiableFor4942Tax
Qualifying Distributions Year197364QualifyingDistributionsYear1
Noncharitable Assets Year11768430NoncharitableAssetsYear1
Distribution Ratio Year10.055057DistributionRatioYear1
Qualifying Distributions Year292148QualifyingDistributionsYear2
Noncharitable Assets Year21554500NoncharitableAssetsYear2
Distribution Ratio Year20.059278DistributionRatioYear2
Total Distribution Ratio0.114335TotalDistributionRatio
Average Distribution Ratio0.057168AverageDistributionRatio
Net Noncharitable Assets1875542NetNoncharitableAssets
Adjusted Noncharitable Assets107221AdjustedNoncharitableAssets
One Percent Net Investment Income474OnePercentNetInvestmentIncome
Adj Nonchrtbl Assets And One107695AdjNonchrtblAssetsAndOnePct
Qualifying Distributions90402QualifyingDistributions

Excise Tax Based On Investment Incm ExciseTaxBasedOnInvestmentIncm

FieldValueIRS element (for citing)
Investment Income Excise Tax947InvestmentIncomeExciseTax
Subtotal947Subtotal
Tax Based On Investment Income947TaxBasedOnInvestmentIncome
Est Tax Payments And Overpayment840EstTaxPaymentsAndOverpayment
Total Credits And Payments840TotalCreditsAndPayments
Tax Due107TaxDue
Amount Credited To Next Year0AmountCreditedToNextYear

Statements Regarding Activities StatementsRegardingActivities

FieldValueIRS element (for citing)
Legislative Political ActivitiesfalseLegislativePoliticalActivities
More Than100 SpentfalseMoreThan100Spent
Form1120 POL FiledfalseForm1120POLFiled
Activities Not Prev ReportedfalseActivitiesNotPrevReported
Changes To Articles Or BylawsfalseChangesToArticlesOrBylaws
Unrelated Bus Income Over1000falseUnrelatedBusIncomeOver1000
Termination EtcfalseTerminationEtc
Requirements Of Sect508etrueRequirementsOfSect508e
At Least5000 In AssetstrueAtLeast5000InAssets
States Filed WithINStatesFiledWith
Form990 PF Filed With AGtrueForm990PFFiledWithAG
Private Operating FoundationfalsePrivateOperatingFoundation
New Substantial ContributorsfalseNewSubstantialContributors
Interest In Controlled EntityfalseInterestInControlledEntity
Applicable Insurance ContractfalseApplicableInsuranceContract
Comply With Public Inspection RqrtrueComplyWithPublicInspectionRqr

Books In Care Of Business Name BooksInCareOfBusinessName

FieldValueIRS element (for citing)
Business Name Line1DAVID E BRENNANBusinessNameLine1
FieldValueIRS element (for citing)
Books In Care Of Phone Number2609271890BooksInCareOfPhoneNumber

Books In Care Of US Address BooksInCareOfUSAddress

FieldValueIRS element (for citing)
Address Line11812 N DEWEY STREETAddressLine1
CityAUBURNCity
StateINState
ZIP Code46706ZIPCode
FieldValueIRS element (for citing)
Foreign BankfalseForeignBank

Statements Regarding Acty4720 StatementsRegardingActy4720

FieldValueIRS element (for citing)
Sale Or Exchange With Dsqfly PersonfalseSaleOrExchangeWithDsqflyPerson
Borrow Or Lend With Dsqfly PersonfalseBorrowOrLendWithDsqflyPerson
Furnished Goods With Dsqfly PersonfalseFurnishedGoodsWithDsqflyPerson
Pay Compensation To Dsqfly PersontruePayCompensationToDsqflyPerson
Transfer Assets To Dsqfly PersonfalseTransferAssetsToDsqflyPerson
Payment To Government OfficalfalsePaymentToGovernmentOffical
Acts Fail To Qualify As ExceptionsfalseActsFailToQualifyAsExceptions
Uncorrected Prior ActsfalseUncorrectedPriorActs
Undistributed Income Prior YearsfalseUndistributedIncomePriorYears
Undistr Income4942a2 Not AppliedfalseUndistrIncome4942a2NotApplied
Business HoldingsfalseBusinessHoldings
Jeopardy InvestmentsfalseJeopardyInvestments
Uncorrected Jeopardy InvestmentsfalseUncorrectedJeopardyInvestments
Influence LegislationfalseInfluenceLegislation
Influence ElectionfalseInfluenceElection
Grants To IndividualsfalseGrantsToIndividuals
Grants To OrganizationsfalseGrantsToOrganizations
Noncharitable PurposefalseNoncharitablePurpose
Rcv Funds To Pay Prsnl Bnft ContractfalseRcvFundsToPayPrsnlBnftContract
Pay Premiums Prsnl Bnft ContractfalsePayPremiumsPrsnlBnftContract
Prohibited Tax Shelter TransactnfalseProhibitedTaxShelterTransactn

Ofcr Dir Trustees Key Employee Info OfcrDirTrusteesKeyEmployeeInfo

Ofcr Dir Trustees Or Key Employee OfcrDirTrusteesOrKeyEmployee (2 entries)

Address Line1USAddress/AddressLine1CityUSAddress/CityStateUSAddress/StateZIP CodeUSAddress/ZIPCodeTitleTitleAvg Hours Per Wk Devoted To PositionAvgHoursPerWkDevotedToPositionCompensationCompensationContri To Empl Benefit Plans EtcContriToEmplBenefitPlansEtcExpense Account Other AllowancesExpenseAccountOtherAllowances
DAVID BRENNAN
1812 N DEWEY STREETAUBURNIN46706TRUSTEE1.050000
DARLAH BRENNAN
1812 N DEWEY STREETAUBURNIN46706TRUSTEE1.050000
FieldValueIRS element (for citing)
Summary Of Direct Charitable ActySummaryOfDirectCharitableActy
Sum Of Program Related InvestmentsSumOfProgramRelatedInvestments

Minimum Investment Return MinimumInvestmentReturn

FieldValueIRS element (for citing)
Avg Monthly FMV Of Securities1847742AvgMonthlyFMVOfSecurities
Avg Monthly Cash Balances56362AvgMonthlyCashBalances
FMV All Other Noncharitable Assets0FMVAllOtherNoncharitableAssets
Total FMV Of Unused Assets1904104TotalFMVOfUnusedAssets
Acquisition Indebtedness0AcquisitionIndebtedness
Adj Total FMV Of Unused Assets1904104AdjTotalFMVOfUnusedAssets
Cash Deemed Charitable28562CashDeemedCharitable
Net Noncharitable Assets1875542NetNoncharitableAssets
Minimum Investment Return93777MinimumInvestmentReturn

Distributable DistributableAmount

FieldValueIRS element (for citing)
Minimum Investment Return93777MinimumInvestmentReturn
Tax Based On Investment Income947TaxBasedOnInvestmentIncome
Total Tax947TotalTax
Distributable Amount Before Adj92830DistributableAmountBeforeAdj
Distributable Amount Before Ded92830DistributableAmountBeforeDed
Distributable Amount As Adjusted92830DistributableAmountAsAdjusted

Qualifying Distributions QualifyingDistributions

FieldValueIRS element (for citing)
Expenses And Contributions90402ExpensesAndContributions
Program Related Investments Total0ProgramRelatedInvestmentsTotal
Amounts Paid Acq Charitable Assets0AmountsPaidAcqCharitableAssets
Amounts Set Aside Suitability Test0AmountsSetAsideSuitabilityTest
Amounts Set Aside Cash Distri Test0AmountsSetAsideCashDistriTest
Qualifying Distributions90402QualifyingDistributions
Adj Qualifying Distributions90402AdjQualifyingDistributions

Undistributed Income UndistributedIncome

FieldValueIRS element (for citing)
Distributable Amount As Adjusted92830DistributableAmountAsAdjusted
Undistributed Income Prior Year0UndistributedIncomePriorYear
Prior Year12009PriorYear1
Prior Year22008PriorYear2
Prior Year32007PriorYear3
Excess Distri Carryover Year247290ExcessDistriCarryoverYear2
Excess Distri Carryover Year19778ExcessDistriCarryoverYear1
Total Excess Distri Carryover57068TotalExcessDistriCarryover
Qualifying Distributions90402QualifyingDistributions
Applied To Year10AppliedToYear1
Applied To Current Year90402AppliedToCurrentYear
Remaining Distri From Corpus0RemainingDistriFromCorpus
Excess Distri Cyov App CY Corpus2428ExcessDistriCyovAppCYCorpus
Excess Distri Cyov Applied CY2428ExcessDistriCyovAppliedCY
Total Corpus54640TotalCorpus
Taxable Amount20TaxableAmount2
Undistributed Income CY0UndistributedIncomeCY
Excess Distri Cyov To Next Year54640ExcessDistriCyovToNextYear
Excess From Year244862ExcessFromYear2
Excess From Year19778ExcessFromYear1
FieldValueIRS element (for citing)
Private Operating FoundationsPrivateOperatingFoundations

Supplementary Information SupplementaryInformation

FieldValueIRS element (for citing)
Only Contributes To PreselectedXOnlyContributesToPreselected

Grant Or Contri Paid During Year GrantOrContriPaidDuringYear (2 entries)

Address Line1RecipientUSAddress/AddressLine1CityRecipientUSAddress/CityStateRecipientUSAddress/StateZIP CodeRecipientUSAddress/ZIPCodeRecipient RelationshipRecipientRelationshipRecipient Foundation StatusRecipientFoundationStatusPurpose Of Grant Or ContributionPurposeOfGrantOrContributionAmountAmount
ST JOSEPH CATHOLIC SCHOOL
1812 N DEWEY STREETAUBURNIN46706NONEPUBLICGENERAL$66,039
ST JOSEPH CATHOLIC CHURCH
1812 N DEWEY STREETAUBURNIN46706NONEPUBLICGENERAL$22,013
FieldValueIRS element (for citing)
Tot Grant Or Contri Paid During Year88052TotGrantOrContriPaidDuringYear

Analysis Income Producing Acty AnalysisIncomeProducingActy

FieldValueIRS element (for citing)
Fees Contracts From Govt AgenciesFeesContractsFromGovtAgencies
Membership Dues And AssessmentsMembershipDuesAndAssessments
Int On Savings And Temp Cash InvstIntOnSavingsAndTempCashInvst

Dividends And Int From Sec Part VII DividendsAndIntFromSecPartVII

FieldValueIRS element (for citing)
Exclusion Code14ExclusionCode
Exclusion$48,995ExclusionAmount
FieldValueIRS element (for citing)
Net Rental Incm Re Debt Fincd PropNetRentalIncmReDebtFincdProp
Net Rntl Incm Re Not Debt Fincd PropNetRntlIncmReNotDebtFincdProp
Net Rental Incm Personal PropertyNetRentalIncmPersonalProperty

Other Investment Income Part VII OtherInvestmentIncomePartVII

FieldValueIRS element (for citing)
Exclusion Code14ExclusionCode
Exclusion$1,086ExclusionAmount

Gain Sales Assets Oth Than Invntry GainSalesAssetsOthThanInvntry

FieldValueIRS element (for citing)
Exclusion Code18ExclusionCode
Exclusion$6,543ExclusionAmount
FieldValueIRS element (for citing)
Net Income Loss From Special EventsNetIncomeLossFromSpecialEvents
Gross Profit Loss Sales Of InvntryGrossProfitLossSalesOfInvntry

Subtotals Part XVIA SubtotalsPartXVIA

FieldValueIRS element (for citing)
Exclusion$56,624ExclusionAmount
FieldValueIRS element (for citing)
Total Part XVIA56624TotalPartXVIA

Trnsfr Tr Rln With Noncharitable EO TrnsfrTrRlnWithNoncharitableEO

FieldValueIRS element (for citing)
Trnsfr Of Cash To Noncharitable EOfalseTrnsfrOfCashToNoncharitableEO
Trnsfr Oth Assets Noncharitable EOfalseTrnsfrOthAssetsNoncharitableEO
Sales Or Exchanges Of AssetsfalseSalesOrExchangesOfAssets
Purchase Assets Noncharitable EOfalsePurchaseAssetsNoncharitableEO
Rental Of Facilities EtcfalseRentalOfFacilitiesEtc
Reimbursement ArrangementsfalseReimbursementArrangements
Loans Or Loan GuaranteesfalseLoansOrLoanGuarantees
Performance Of Services EtcfalsePerformanceOfServicesEtc
Sharing Of Facilities EtcfalseSharingOfFacilitiesEtc
Relationships Noncharitable E OsfalseRelationshipsNoncharitableEOs

Accounting Fees Schedule AccountingFeesSchedule

Accounting Fees AccountingFees (2 entries)

CategoryCategoryAmountAmountDisbursements Charitable PrpsDisbursementsCharitablePrps
BKD, LLP - COMPLIANCE AND$1,8501850
CONSULTING

Depreciation Schedule DepreciationSchedule

Investments Corp Bonds Schedule InvestmentsCorpBondsSchedule

Investments Corp Bonds InvestmentsCorpBonds

FieldValueIRS element (for citing)
Name Of BondAPP INTL FIN CO B V GTDSECNTNameOfBond
EOY Book Value1040EOYBookValue
EOYFMV0EOYFMV

Investments Corp Stock Schedule InvestmentsCorpStockSchedule

Investments Corp Stock InvestmentsCorpStock (13 entries)

Name Of StockNameOfStockEOY Book ValueEOYBookValueEOYFMVEOYFMV
ISHARES TR S&P 500/VALUE230661220332
SOLUTIA INC50
SPDR INDEX SHS FDS S&P INTL3305034005
VANGUARD INDEX FDS REIT ETF5090289552
VANGUARD INDEX FDS SMALL CAP6227971444
VANGUARD INDEX FDS SC VALUE2992836159
VANGUARD INTL EQUITY INDEX FD174923162565
ISHARES TR S&P MIDCAP 400164738212104
ISHARES TR S&P 500 INDEX207960217155
VANGUARD INTERMED TRM INVST GR117697135930
VANGUARD SHORT TERM INVMT130730138668
VANGUARD TOTAL BOND MARKET IND321492349490
VANGUARD INFLATION PROTECTED5810169365

Land Etc Schedule2 LandEtcSchedule2

Other Income Schedule2 OtherIncomeSchedule2

Other Income OtherIncome

FieldValueIRS element (for citing)
DescriptionNONDIVIDEND DISTRIBUTIONSDescription
Revenue And Expenses Per Books1086RevenueAndExpensesPerBooks

Other Increases Schedule OtherIncreasesSchedule

Other Increases OtherIncreases

FieldValueIRS element (for citing)
DescriptionCASH ADJDescription
Amount$235Amount

Other Professional Fees Schedule OtherProfessionalFeesSchedule

Other Professional Fees OtherProfessionalFees (2 entries)

CategoryCategoryAmountAmountNet Investment IncomeNetInvestmentIncome
CAMBRIDGE INVESTMENT FEES$3,7933793
FIDELITY INVESTMENT FEES$3,4073407

Taxes Schedule TaxesSchedule

Taxes Taxes (2 entries)

CategoryCategoryAmountAmountNet Investment IncomeNetInvestmentIncome
FOREIGN TAX PAID$466466
FEDERAL TAX PAYMENTS$636