STRATEGY STUDIO / PUBLIC DATA EXPLORER

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

View the entire original 990 at ProPublica ↗

Organization
BERNARD R BRENNAN CHARITABLE TR (EIN 36-7494242)
Tax period
2012-01-01 to 2012-12-31
Filed
2013-04-30
IRS object ID
201301209349100515
Schema version
2012v2.1
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)
Timestamp2013-04-30T14:36:54-05:00Timestamp
Tax Period End Date2012-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 Date2012-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
Address Line2SuiteAddressLine2
CityAUBURNCity
StateINState
ZIP Code46706ZIPCode

Officer Officer

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

Preparer Preparer

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

Form 990-PF IRS990PF

FieldValueIRS element (for citing)
Exempt PFXExemptPF
FMV Assets EOY1906116FMVAssetsEOY
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 Expnss48004DividendsRevAndExpnss
Dividends Net Invst Incm48004DividendsNetInvstIncm
Net Gain Sale Assets Rev And Expnss21393NetGainSaleAssetsRevAndExpnss
Gross Sales Price310974GrossSalesPrice
Capital Gain Net Incm Net Invst Incm21393CapitalGainNetIncmNetInvstIncm
Other Income Rev And Expnss1101OtherIncomeRevAndExpnss
Total Revenue And Expenses70498TotalRevenueAndExpenses
Total Net Investment Income69397TotalNetInvestmentIncome
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 Expnss1910AccountingFeesRevAndExpnss
Accounting Fees Net Invst Incm0AccountingFeesNetInvstIncm
Accounting Fees Adj Net Incm0AccountingFeesAdjNetIncm
Accounting Fees Dsbrs Chrtbl Prps1910AccountingFeesDsbrsChrtblPrps
Other Prof Fees Rev And Expnss6789OtherProfFeesRevAndExpnss
Other Prof Fees Net Invst Incm6789OtherProfFeesNetInvstIncm
Taxes Rev And Expnss1438TaxesRevAndExpnss
Taxes Net Invst Incm371TaxesNetInvstIncm
Tot Opr Expenses Rev And Expnss11137TotOprExpensesRevAndExpnss
Tot Opr Expenses Net Invst Incm7660TotOprExpensesNetInvstIncm
Tot Opr Expenses Adj Net Incm0TotOprExpensesAdjNetIncm
Tot Opr Expenses Dsbrs Chrtbl Prps2410TotOprExpensesDsbrsChrtblPrps
Contri Gifts Paid Rev And Expnss89983ContriGiftsPaidRevAndExpnss
Contri Gifts Paid Dsbrs Chrtbl Prps89983ContriGiftsPaidDsbrsChrtblPrps
Total Expenses Rev And Expnss101120TotalExpensesRevAndExpnss
Total Expenses Net Invst Incm7660TotalExpensesNetInvstIncm
Total Expenses Adj Net Incm0TotalExpensesAdjNetIncm
Total Expenses Dsbrs Chrtbl Prps92393TotalExpensesDsbrsChrtblPrps
Excess Of Revenue Over Expenses-30622ExcessOfRevenueOverExpenses
Net Investment Income61737NetInvestmentIncome

Balance Sheets BalanceSheets

FieldValueIRS element (for citing)
Cash BOY91CashBOY
Cash EOY610CashEOY
Cash EOYFMV610CashEOYFMV
Savings And Temp Cash Invst BOY50641SavingsAndTempCashInvstBOY
Savings And Temp Cash Invst EOY60492SavingsAndTempCashInvstEOY
Savings And Temp Cash Invst EOYFMV60492SavingsAndTempCashInvstEOYFMV
Investments Corp Stock BOY1582511InvestmentsCorpStockBOY
Investments Corp Stock EOY1540736InvestmentsCorpStockEOY
Investments Corp Stock EOYFMV1845014InvestmentsCorpStockEOYFMV
Investments Corp Bonds BOY1040InvestmentsCorpBondsBOY
Investments Corp Bonds EOY1040InvestmentsCorpBondsEOY
Total Assets BOY1634283TotalAssetsBOY
Total Assets EOY1602878TotalAssetsEOY
Total Assets EOYFMV1906116TotalAssetsEOYFMV
Total Liabilities EOY0TotalLiabilitiesEOY
Org That Do Not Follow SFAS117XOrgThatDoNotFollowSFAS117
Retained Earnings BOY1634283RetainedEarningsBOY
Retained Earnings EOY1602878RetainedEarningsEOY
Total Net Assets BOY1634283TotalNetAssetsBOY
Total Net Assets EOY1602878TotalNetAssetsEOY
Total Liabilities Net Assets BOY1634283TotalLiabilitiesNetAssetsBOY
Total Liabilities Net Assets EOY1602878TotalLiabilitiesNetAssetsEOY

Changes In Net Assets Fund Balances ChangesInNetAssetsFundBalances

FieldValueIRS element (for citing)
Total Net Assets Fund Balances BOY1634283TotalNetAssetsFundBalancesBOY
Excess Of Revenue Over Expenses-30622ExcessOfRevenueOverExpenses
Subtotal1603661Subtotal
Other Decreases783OtherDecreases
Total Net Assets Fund Balances EOY1602878TotalNetAssetsFundBalancesEOY

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 GAIN3064052895811682416824
CAPITAL GAIN DIVIDENDS4569P
FieldValueIRS element (for citing)
Capital Gain Net Income21393CapitalGainNetIncome

Qlfy Und Sect4940e For Reduced Tax QlfyUndSect4940eForReducedTax

FieldValueIRS element (for citing)
Liable For4942 TaxfalseLiableFor4942Tax
Qualifying Distributions Year190402QualifyingDistributionsYear1
Noncharitable Assets Year11875542NoncharitableAssetsYear1
Distribution Ratio Year10.0482DistributionRatioYear1
Qualifying Distributions Year297364QualifyingDistributionsYear2
Noncharitable Assets Year21768430NoncharitableAssetsYear2
Distribution Ratio Year20.055057DistributionRatioYear2
Qualifying Distributions Year392148QualifyingDistributionsYear3
Noncharitable Assets Year31554500NoncharitableAssetsYear3
Distribution Ratio Year30.059278DistributionRatioYear3
Total Distribution Ratio0.162535TotalDistributionRatio
Average Distribution Ratio0.054178AverageDistributionRatio
Net Noncharitable Assets1874104NetNoncharitableAssets
Adjusted Noncharitable Assets101535AdjustedNoncharitableAssets
One Percent Net Investment Income617OnePercentNetInvestmentIncome
Adj Nonchrtbl Assets And One102152AdjNonchrtblAssetsAndOnePct
Qualifying Distributions92393QualifyingDistributions

Excise Tax Based On Investment Incm ExciseTaxBasedOnInvestmentIncm

FieldValueIRS element (for citing)
Investment Income Excise Tax1235InvestmentIncomeExciseTax
Subtotal1235Subtotal
Tax Based On Investment Income1235TaxBasedOnInvestmentIncome
Est Tax Payments And Overpayment960EstTaxPaymentsAndOverpayment
Total Credits And Payments960TotalCreditsAndPayments
Tax Due275TaxDue

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 Securities1843373AvgMonthlyFMVOfSecurities
Avg Monthly Cash Balances59271AvgMonthlyCashBalances
FMV All Other Noncharitable Assets0FMVAllOtherNoncharitableAssets
Total FMV Of Unused Assets1902644TotalFMVOfUnusedAssets
Acquisition Indebtedness0AcquisitionIndebtedness
Adj Total FMV Of Unused Assets1902644AdjTotalFMVOfUnusedAssets
Cash Deemed Charitable28540CashDeemedCharitable
Net Noncharitable Assets1874104NetNoncharitableAssets
Minimum Investment Return93705MinimumInvestmentReturn

Distributable DistributableAmount

FieldValueIRS element (for citing)
Minimum Investment Return93705MinimumInvestmentReturn
Tax Based On Investment Income1235TaxBasedOnInvestmentIncome
Total Tax1235TotalTax
Distributable Amount Before Adj92470DistributableAmountBeforeAdj
Distributable Amount Before Ded92470DistributableAmountBeforeDed
Distributable Amount As Adjusted92470DistributableAmountAsAdjusted

Qualifying Distributions QualifyingDistributions

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

Undistributed Income UndistributedIncome

FieldValueIRS element (for citing)
Distributable Amount As Adjusted92470DistributableAmountAsAdjusted
Undistributed Income Prior Year0UndistributedIncomePriorYear
Prior Year12010PriorYear1
Prior Year22009PriorYear2
Prior Year32008PriorYear3
Total For Prior Years0TotalForPriorYears
Excess Distri Carryover Year344862ExcessDistriCarryoverYear3
Excess Distri Carryover Year29778ExcessDistriCarryoverYear2
Total Excess Distri Carryover54640TotalExcessDistriCarryover
Qualifying Distributions92393QualifyingDistributions
Applied To Year10AppliedToYear1
Applied To Current Year92393AppliedToCurrentYear
Remaining Distri From Corpus0RemainingDistriFromCorpus
Excess Distri Cyov App CY Corpus77ExcessDistriCyovAppCYCorpus
Excess Distri Cyov Applied CY77ExcessDistriCyovAppliedCY
Total Corpus54563TotalCorpus
Prior Year Undistributed Income0PriorYearUndistributedIncome
Taxable Amount10TaxableAmount1
Taxable Amount20TaxableAmount2
Undistributed Income CY0UndistributedIncomeCY
Excess Distri Cyov To Next Year54563ExcessDistriCyovToNextYear
Excess From Year344785ExcessFromYear3
Excess From Year29778ExcessFromYear2
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$67,487
ST JOSEPH CATHOLIC CHURCH
1812 N DEWEY STREETAUBURNIN46706NONEPUBLICGENERAL$22,496
FieldValueIRS element (for citing)
Tot Grant Or Contri Paid During Year89983TotGrantOrContriPaidDuringYear

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,004ExclusionAmount
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,101ExclusionAmount

Gain Sales Assets Oth Than Invntry GainSalesAssetsOthThanInvntry

FieldValueIRS element (for citing)
Exclusion Code18ExclusionCode
Exclusion$21,393ExclusionAmount
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$70,498ExclusionAmount
FieldValueIRS element (for citing)
Total Part XVIA70498TotalPartXVIA

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,9101910
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

Investments Corp Stock Schedule InvestmentsCorpStockSchedule

Investments Corp Stock InvestmentsCorpStock (12 entries)

Name Of StockNameOfStockEOY Book ValueEOYBookValueEOYFMVEOYFMV
ISHARES TR S&P 500/VALUE202140224398
SOLUTIA INC50
VANGUARD INDEX FDS REIT ETF4624494357
VANGUARD INDEX FDS SMALL CAP5533474830
VANGUARD INDEX FDS SC VALUE2598237133
VANGUARD INTL EQUITY INDEX FD222597234409
ISHARES TR S&P MIDCAP 400150890228927
ISHARES CORE S&P 500 ETF183177219577
VANGUARD INTERMED TRM INVST GR123197145820
VANGUARD SHORT TERM INVMT137730148106
VANGUARD TOTAL BOND MARKET IND335294366014
VANGUARD INFLATION PROTECTED5810171443

Land Etc Schedule2 LandEtcSchedule2

Other Decreases Schedule OtherDecreasesSchedule

Other Decreases OtherDecreases

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

Other Income Schedule2 OtherIncomeSchedule2

Other Income OtherIncome

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

Other Professional Fees Schedule OtherProfessionalFeesSchedule

Other Professional Fees OtherProfessionalFees

FieldValueIRS element (for citing)
CategoryFIDELITY INVESTMENT FEESCategory
Amount$6,789Amount
Net Investment Income6789NetInvestmentIncome

Taxes Schedule TaxesSchedule

Taxes Taxes (2 entries)

CategoryCategoryAmountAmountNet Investment IncomeNetInvestmentIncome
FOREIGN TAX PAID$371371
FEDERAL TAX PAYMENTS$1,067