STRATEGY STUDIO / PUBLIC DATA EXPLORER

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

View the entire original 990 at ProPublica ↗

Organization
BERNARD R BRENNAN CHARITABLE TR (EIN 36-7494242)
Tax period
2010-01-01 to 2010-12-31
Filed
2011-05-09
IRS object ID
201121299349101502
Schema version
2010v3.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)
Timestamp2011-05-09T13:05:52-05:00Timestamp
Tax Period End Date2010-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 Date2010-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)
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 Signed2011-05-05DateSigned

Preparer Preparer

FieldValueIRS element (for citing)
Phone2604604000Phone
FieldValueIRS element (for citing)
Tax Year2010TaxYear
Build TS2016-02-24 21:20:13ZBuildTS

Form 990-PF IRS990PF

FieldValueIRS element (for citing)
Exempt PFXExemptPF
FMV Assets EOY1874065FMVAssetsEOY
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 Expnss50122DividendsRevAndExpnss
Dividends Net Invst Incm50122DividendsNetInvstIncm
Net Gain Sale Assets Rev And Expnss-401NetGainSaleAssetsRevAndExpnss
Gross Sales Price83724GrossSalesPrice
Total Revenue And Expenses49721TotalRevenueAndExpenses
Total Net Investment Income50122TotalNetInvestmentIncome
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 Expnss3839AccountingFeesRevAndExpnss
Accounting Fees Net Invst Incm0AccountingFeesNetInvstIncm
Accounting Fees Adj Net Incm0AccountingFeesAdjNetIncm
Accounting Fees Dsbrs Chrtbl Prps3839AccountingFeesDsbrsChrtblPrps
Other Prof Fees Rev And Expnss7508OtherProfFeesRevAndExpnss
Other Prof Fees Net Invst Incm7508OtherProfFeesNetInvstIncm
Other Prof Fees Adj Net Incm0OtherProfFeesAdjNetIncm
Other Prof Fees Dsbrs Chrtbl Prps0OtherProfFeesDsbrsChrtblPrps
Taxes Rev And Expnss1941TaxesRevAndExpnss
Taxes Net Invst Incm313TaxesNetInvstIncm
Other Expenses Rev And Expnss6OtherExpensesRevAndExpnss
Other Expenses Net Invst Incm0OtherExpensesNetInvstIncm
Other Expenses Adj Net Incm0OtherExpensesAdjNetIncm
Other Expenses Dsbrs Chrtbl Prps6OtherExpensesDsbrsChrtblPrps
Tot Opr Expenses Rev And Expnss14294TotOprExpensesRevAndExpnss
Tot Opr Expenses Net Invst Incm8321TotOprExpensesNetInvstIncm
Tot Opr Expenses Adj Net Incm0TotOprExpensesAdjNetIncm
Tot Opr Expenses Dsbrs Chrtbl Prps4345TotOprExpensesDsbrsChrtblPrps
Contri Gifts Paid Rev And Expnss93019ContriGiftsPaidRevAndExpnss
Contri Gifts Paid Dsbrs Chrtbl Prps93019ContriGiftsPaidDsbrsChrtblPrps
Total Expenses Rev And Expnss107313TotalExpensesRevAndExpnss
Total Expenses Net Invst Incm8321TotalExpensesNetInvstIncm
Total Expenses Adj Net Incm0TotalExpensesAdjNetIncm
Total Expenses Dsbrs Chrtbl Prps97364TotalExpensesDsbrsChrtblPrps
Excess Of Revenue Over Expenses-57592ExcessOfRevenueOverExpenses
Net Investment Income41801NetInvestmentIncome

Balance Sheets BalanceSheets

FieldValueIRS element (for citing)
Cash BOY82CashBOY
Cash EOY99CashEOY
Cash EOYFMV99CashEOYFMV
Savings And Temp Cash Invst BOY29138SavingsAndTempCashInvstBOY
Savings And Temp Cash Invst EOY27779SavingsAndTempCashInvstEOY
Savings And Temp Cash Invst EOYFMV27779SavingsAndTempCashInvstEOYFMV
Investments Corp Stock BOY1691292InvestmentsCorpStockBOY
Investments Corp Stock EOY1647710InvestmentsCorpStockEOY
Investments Corp Stock EOYFMV1846187InvestmentsCorpStockEOYFMV
Investments Corp Bonds BOY14415InvestmentsCorpBondsBOY
Investments Corp Bonds EOY1040InvestmentsCorpBondsEOY
Investments Corp Bonds EOYFMV0InvestmentsCorpBondsEOYFMV
Total Assets BOY1734927TotalAssetsBOY
Total Assets EOY1676628TotalAssetsEOY
Total Assets EOYFMV1874065TotalAssetsEOYFMV
Total Liabilities EOY0TotalLiabilitiesEOY
Org That Do Not Follow SFAS117XOrgThatDoNotFollowSFAS117
Retained Earnings BOY1734927RetainedEarningsBOY
Retained Earnings EOY1676628RetainedEarningsEOY
Total Net Assets BOY1734927TotalNetAssetsBOY
Total Net Assets EOY1676628TotalNetAssetsEOY
Total Liabilities Net Assets BOY1734927TotalLiabilitiesNetAssetsBOY
Total Liabilities Net Assets EOY1676628TotalLiabilitiesNetAssetsEOY

Changes In Net Assets Fund Balances ChangesInNetAssetsFundBalances

FieldValueIRS element (for citing)
Total Net Assets Fund Balances BOY1734927TotalNetAssetsFundBalancesBOY
Excess Of Revenue Over Expenses-57592ExcessOfRevenueOverExpenses
Subtotal1677335Subtotal
Other Decreases707OtherDecreases
Total Net Assets Fund Balances EOY1676628TotalNetAssetsFundBalancesEOY

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
CAMBRIDGE LT CAPITAL LOSS8106684125-3059-3059
CAPITAL GAIN DIVIDENDS2658P
FieldValueIRS element (for citing)
Capital Gain Net Income-401CapitalGainNetIncome

Qlfy Und Sect4940e For Reduced Tax QlfyUndSect4940eForReducedTax

FieldValueIRS element (for citing)
Liable For4942 TaxfalseLiableFor4942Tax
Qualifying Distributions Year192148QualifyingDistributionsYear1
Noncharitable Assets Year11554500NoncharitableAssetsYear1
Distribution Ratio Year10.059278DistributionRatioYear1
Total Distribution Ratio0.059278TotalDistributionRatio
Average Distribution Ratio0.059278AverageDistributionRatio
Net Noncharitable Assets1768430NetNoncharitableAssets
Adjusted Noncharitable Assets104829AdjustedNoncharitableAssets
One Percent Net Investment Income418OnePercentNetInvestmentIncome
Adj Nonchrtbl Assets And One105247AdjNonchrtblAssetsAndOnePct
Qualifying Distributions97364QualifyingDistributions

Excise Tax Based On Investment Incm ExciseTaxBasedOnInvestmentIncm

FieldValueIRS element (for citing)
Investment Income Excise Tax836InvestmentIncomeExciseTax
Subtotal836Subtotal
Tax Based On Investment Income836TaxBasedOnInvestmentIncome
Est Tax Payments And Overpayment1040EstTaxPaymentsAndOverpayment
Total Credits And Payments1040TotalCreditsAndPayments
Overpayment204Overpayment
Amount Credited To Next Year204AmountCreditedToNextYear

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 Securities1746623AvgMonthlyFMVOfSecurities
Avg Monthly Cash Balances48737AvgMonthlyCashBalances
FMV All Other Noncharitable Assets0FMVAllOtherNoncharitableAssets
Total FMV Of Unused Assets1795360TotalFMVOfUnusedAssets
Acquisition Indebtedness0AcquisitionIndebtedness
Adj Total FMV Of Unused Assets1795360AdjTotalFMVOfUnusedAssets
Cash Deemed Charitable26930CashDeemedCharitable
Net Noncharitable Assets1768430NetNoncharitableAssets
Minimum Investment Return88422MinimumInvestmentReturn

Distributable DistributableAmount

FieldValueIRS element (for citing)
Minimum Investment Return88422MinimumInvestmentReturn
Tax Based On Investment Income836TaxBasedOnInvestmentIncome
Total Tax836TotalTax
Distributable Amount Before Adj87586DistributableAmountBeforeAdj
Distributable Amount Before Ded87586DistributableAmountBeforeDed
Distributable Amount As Adjusted87586DistributableAmountAsAdjusted

Qualifying Distributions QualifyingDistributions

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

Undistributed Income UndistributedIncome

FieldValueIRS element (for citing)
Distributable Amount As Adjusted87586DistributableAmountAsAdjusted
Prior Year12008PriorYear1
Prior Year22007PriorYear2
Prior Year32006PriorYear3
Excess Distri Carryover Year147290ExcessDistriCarryoverYear1
Total Excess Distri Carryover47290TotalExcessDistriCarryover
Qualifying Distributions97364QualifyingDistributions
Applied To Current Year87586AppliedToCurrentYear
Remaining Distri From Corpus9778RemainingDistriFromCorpus
Total Corpus57068TotalCorpus
Undistributed Income CY0UndistributedIncomeCY
Excess Distri Cyov To Next Year57068ExcessDistriCyovToNextYear
Excess From Year147290ExcessFromYear1
Excess From Current Year9778ExcessFromCurrentYear
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$69,764
ST JOSEPH CATHOLIC CHURCH
1812 N DEWEY STREETAUBURNIN46706NONEPUBLICGENERAL$23,255
FieldValueIRS element (for citing)
Tot Grant Or Contri Paid During Year93019TotGrantOrContriPaidDuringYear

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$50,122ExclusionAmount
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 VIIOtherInvestmentIncomePartVII

Gain Sales Assets Oth Than Invntry GainSalesAssetsOthThanInvntry

FieldValueIRS element (for citing)
Exclusion Code18ExclusionCode
Exclusion-$401ExclusionAmount
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$49,721ExclusionAmount
FieldValueIRS element (for citing)
Total Part XVIA49721TotalPartXVIA

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$3,8393839
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 (14 entries)

Name Of StockNameOfStockEOY Book ValueEOYBookValueEOYFMVEOYFMV
EQUITY FUNDS
ISHARES TR S&P MIDCAP 400234641230613
SOLUTIA INC50
SPDR INDEX SHS FDS S&P INTL3305041665
VANGUARD INDEX FDS REIT ETF5717693520
VANGUARD INDEX FDS SMALL CAP6764681904
VANGUARD INDEX FDS SC VALUE3321641326
VANGUARD INTL EQUITY INDEX FD171827192113
ISHARES TR S&P MIDCAP 400182659239512
ISHARES TR S&P 500 INDEX222960232174
VANGUARD INTERMED TRM INVST GR117697134977
VANGUARD SHORT TERM INVMT132697142474
VANGUARD TOTAL BOND MARKET IND335242351184
VANGUARD INFLATION PROTECTED5884964725

Land Etc Schedule2 LandEtcSchedule2

Other Decreases Schedule OtherDecreasesSchedule

Other Decreases OtherDecreases

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

Other Expenses Schedule OtherExpensesSchedule

Other Expenses OtherExpenses

FieldValueIRS element (for citing)
DescriptionPOSTAGE FEEDescription
Revenue And Expenses Per Books6RevenueAndExpensesPerBooks
Net Investment Income0NetInvestmentIncome
Adjusted Net Income0AdjustedNetIncome
Disbursements Charitable Prps6DisbursementsCharitablePrps

Other Professional Fees Schedule OtherProfessionalFeesSchedule

Other Professional Fees OtherProfessionalFees

FieldValueIRS element (for citing)
CategoryACCOUNT FEES - CAMBRIDGECategory
Amount$7,508Amount
Net Investment Income7508NetInvestmentIncome
Adjusted Net Income0AdjustedNetIncome
Disbursements Charitable Prps0DisbursementsCharitablePrps

Taxes Schedule TaxesSchedule

Taxes Taxes (2 entries)

CategoryCategoryAmountAmountNet Investment IncomeNetInvestmentIncome
FOREIGN TAX PAID$313313
FEDERAL TAX PAYMENTS$1,628