Civic Intelligence

Bruce Allen Bro Charitable Foundation Trust

990PF • Fiscal year 2011 • EIN 27-1812624

Jan 01, 2011 to Dec 31, 2011 • Filed on May 11, 2012

19 Clear Crossing Trail89052
Siviq Scores

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

Liabilities / Assets

35th percentile

0.00x

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

2011 filings • $500k-$1M 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

68th percentile

$0

Higher top officer pay than 68% of similar nonprofits.

2011 filings • $500k-$1M 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

$631,167

No earlier filing loaded for comparison.

Net Assets

$631,167

No earlier filing loaded for comparison.

Liabilities

$0

No earlier filing loaded for comparison.

Revenue

-

No earlier filing loaded for comparison.

Expenses

$26,374

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.

$800K$600K$400K$200K$0Assets 2011: $631,167Liabilities 2011: $0Net Assets 2011: $631,1672011Assets 2012: $632,131Liabilities 2012: $0Net Assets 2012: $632,1312012Assets 2013: $618,016Liabilities 2013: $0Net Assets 2013: $618,0162013Assets 2014: $615,476Liabilities 2014: $0Net Assets 2014: $615,4762014Assets 2015: $609,462Liabilities 2015: $0Net Assets 2015: $609,4622015Assets 2016: $549,320Liabilities 2016: $0Net Assets 2016: $549,3202016Assets 2017: $413,750Liabilities 2017: $0Net Assets 2017: $413,7502017Assets 2018: $426,356Liabilities 2018: $0Net Assets 2018: $426,3562018Assets 2019: $465,510Liabilities 2019: $0Net Assets 2019: $465,5102019Assets 2020: $465,806Liabilities 2020: $0Net Assets 2020: $465,8062020Assets 2021: $428,494Liabilities 2021: $0Net Assets 2021: $428,4942021Assets 2022: $303,536Liabilities 2022: $0Net Assets 2022: $303,5362022

Highlighted filing

2011

Assets$631,167
Liabilities$0
Net Assets$631,167

Operations Trend

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

$200K$100K$0-$100K-$200KExpenses 2011: $26,3742011Expenses 2012: $26,7432012Revenue 2013: $31,867Expenses 2013: $28,261Net Income 2013: $3,6062013Revenue 2014: $49,525Expenses 2014: $43,708Net Income 2014: $5,8172014Revenue 2015: $51,628Expenses 2015: $31,095Net Income 2015: $20,5332015Revenue 2016: $13,479Expenses 2016: $44,645Net Income 2016: -$31,1662016Revenue 2017: $8,572Expenses 2017: $121,013Net Income 2017: -$112,4412017Revenue 2018: $27,161Expenses 2018: $34,741Net Income 2018: -$7,5802018Revenue 2019: $14,402Expenses 2019: $49,505Net Income 2019: -$35,1032019Revenue 2020: $37,046Expenses 2020: $60,623Net Income 2020: -$23,5772020Revenue 2021: $26,831Expenses 2021: $47,426Net Income 2021: -$20,5952021Revenue 2022: -$18,733Expenses 2022: $55,340Net Income 2022: -$74,0732022

Highlighted filing

2011

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

Employees

NameTitleFull / Part TimeBaseOtherTotal
BRUCE A BROTrustee-$0--
Grants and Assistance

Foundation Grants and Related Investments

TypeRecipientPurposeStatusLocationAmount
Paid GrantFAITH SOUND INCCHARITABLE501 (C) 3HARLAN, IA, US$26,000
Filing and Contact Details

Filer

EIN
27-1812624
Raw XML Appendix199 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
IRS990PF/AddressChange0X
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnss0374
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncome014407
IRS990PF/AnalysisOfRevenueAndExpenses/CapitalGainNetIncmNetInvstIncm00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidDsbrsChrtblPrps026000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidRevAndExpnss026000
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsAdjNetIncm014404
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncm014404
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnss014404
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessOfRevenueOverExpenses0-9557
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsAdjNetIncm03
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsNetInvstIncm03
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsRevAndExpnss03
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncome014407
IRS990PF/AnalysisOfRevenueAndExpenses/NotRequiredToAttachScheduleB0X
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnss02410
IRS990PF/AnalysisOfRevenueAndExpenses/TotalAdjustedNetIncome014407
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblPrps026000
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncm00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnss026374
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvestmentIncome014407
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevenueAndExpenses016817
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncm00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnss0374
IRS990PF/BalanceSheets/CashEOY05061
IRS990PF/BalanceSheets/CashEOYFMV05061
IRS990PF/BalanceSheets/InvestmentsCorpBondsEOY0626106
IRS990PF/BalanceSheets/InvestmentsCorpBondsEOYFMV0582133
IRS990PF/BalanceSheets/OrgThatDoNotFollowSFAS1170X
IRS990PF/BalanceSheets/RetainedEarningsEOY0631167
IRS990PF/BalanceSheets/TotalAssetsEOY0631167
IRS990PF/BalanceSheets/TotalAssetsEOYFMV0587194
IRS990PF/BalanceSheets/TotalLiabilitiesEOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsBOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsEOY0631167
IRS990PF/BalanceSheets/TotalNetAssetsEOY0631167
IRS990PF/CapitalGainsAndLosses/CapitalGainNetIncome0-1976
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/AdjustedBasisAsOf12316900
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis060777
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateAcquired02011-01-01
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateSold02011-11-16
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/Depreciation00
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset0AMERIPRISE ACCT
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/ExcessOfFMVOverAdjustedBasis00
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/FMVAsOf12316900
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss0-1976
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses0-1976
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice058801
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired0P
IRS990PF/CapitalGainsAndLosses/NetShortTermCapitalGainOrLoss0-1976
IRS990PF/ChangesInNetAssetsFundBalances/ExcessOfRevenueOverExpenses0-9557
IRS990PF/ChangesInNetAssetsFundBalances/OtherDecreases01975
IRS990PF/ChangesInNetAssetsFundBalances/OtherIncreases0642699
IRS990PF/ChangesInNetAssetsFundBalances/Subtotal0633142
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesEOY0631167
IRS990PF/DistributableAmount/DistributableAmountAsAdjusted00
IRS990PF/DistributableAmount/TaxBasedOnInvestmentIncome0288
IRS990PF/DistributableAmount/TotalTax0288
IRS990PF/ExciseTaxBasedOnInvestmentIncm/AmountCreditedToNextYear00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/InvestmentIncomeExciseTax0288
IRS990PF/ExciseTaxBasedOnInvestmentIncm/Subtotal0288
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxBasedOnInvestmentIncome0288
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxDue0288
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxPaidOriginalReturn00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxUnderSection51100
IRS990PF/ExemptPF0X
IRS990PF/FMVAssetsEOY0587194
IRS990PF/InitialReturn0X
IRS990PF/MethodOfAccountingCash0X
IRS990PF/MinimumInvestmentReturn/AdjTotalFMVOfUnusedAssets00
IRS990PF/MinimumInvestmentReturn/AvgMonthlyCashBalances00
IRS990PF/MinimumInvestmentReturn/AvgMonthlyFMVOfSecurities00
IRS990PF/MinimumInvestmentReturn/CashDeemedCharitable00
IRS990PF/MinimumInvestmentReturn/FMVAllOtherNoncharitableAssets00
IRS990PF/MinimumInvestmentReturn/MinimumInvestmentReturn00
IRS990PF/MinimumInvestmentReturn/NetNoncharitableAssets00
IRS990PF/MinimumInvestmentReturn/TotalFMVOfUnusedAssets00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHghstPaidCntrctNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHighestPaidEmplNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition01.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName0BRUCE A BRO
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title0TRUSTEE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine1019 CLEAR CROSSING TRAIL
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City0HENDERSON
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State0NV
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode089052
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/TotNumberOfCntrctPaidOver50k00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/TotNumberOfOthEmplPaidOver50k00
IRS990PF/QlfyUndSect4940eForReducedTax/AdjNonchrtblAssetsAndOnePct00
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributions00
IRS990PF/QualifyingDistributions/AdjQualifyingDistributions026000
IRS990PF/QualifyingDistributions/ExpensesAndContributions026000
IRS990PF/QualifyingDistributions/QualifyingDistributions026000
IRS990PF/StatementsRegardingActivities/ActivitiesNotPrevReported0false
IRS990PF/StatementsRegardingActivities/ApplicableInsuranceContract0false
IRS990PF/StatementsRegardingActivities/AtLeast5000InAssets0true
IRS990PF/StatementsRegardingActivities/BooksInCareOfBusinessName/BusinessNameLine10MUXFELDT ASSOCIATES CPA PC
IRS990PF/StatementsRegardingActivities/BooksInCareOfPhoneNumber07127553366
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine102309 B CHATBURN AVE
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/City0HARLAN
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/State0IA
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/ZIPCode0515370551
IRS990PF/StatementsRegardingActivities/ChangesToArticlesOrBylaws0false
IRS990PF/StatementsRegardingActivities/ComplyWithPublicInspectionRqr0true
IRS990PF/StatementsRegardingActivities/ForeignBank0false
IRS990PF/StatementsRegardingActivities/Form1120POLFiled0false
IRS990PF/StatementsRegardingActivities/Form990PFFiledWithAG0true
IRS990PF/StatementsRegardingActivities/InterestInControlledEntity0false
IRS990PF/StatementsRegardingActivities/LegislativePoliticalActivities0false
IRS990PF/StatementsRegardingActivities/MoreThan100Spent0false
IRS990PF/StatementsRegardingActivities/NewSubstantialContributors0false
IRS990PF/StatementsRegardingActivities/PrivateOperatingFoundation0false
IRS990PF/StatementsRegardingActivities/RequirementsOfSect508e0false
IRS990PF/StatementsRegardingActivities/TerminationEtc0false
IRS990PF/StatementsRegardingActivities/UnrelatedBusIncomeOver10000false
IRS990PF/StatementsRegardingActivities/WebsiteAddress0N/A
IRS990PF/StatementsRegardingActy4720/BorrowOrLendWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/BusinessHoldings0false
IRS990PF/StatementsRegardingActy4720/FurnishedGoodsWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/GrantsToIndividuals0false
IRS990PF/StatementsRegardingActy4720/GrantsToOrganizations0false
IRS990PF/StatementsRegardingActy4720/InfluenceElection0false
IRS990PF/StatementsRegardingActy4720/InfluenceLegislation0false
IRS990PF/StatementsRegardingActy4720/JeopardyInvestments0false
IRS990PF/StatementsRegardingActy4720/NoncharitablePurpose0false
IRS990PF/StatementsRegardingActy4720/PayCompensationToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/PaymentToGovernmentOffical0false
IRS990PF/StatementsRegardingActy4720/PayPremiumsPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/ProhibitedTaxShelterTransactn0false
IRS990PF/StatementsRegardingActy4720/RcvFundsToPayPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/SaleOrExchangeWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/TransferAssetsToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/UncorrectedJeopardyInvestments0false
IRS990PF/StatementsRegardingActy4720/UncorrectedPriorActs0false
IRS990PF/StatementsRegardingActy4720/UndistributedIncomePriorYears0false
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount026000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution0CHARITABLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine10FAITH SOUND INC
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus0501 (C) 3
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine101210 DURANT STREET
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City0HARLAN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State0IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode051537
IRS990PF/SupplementaryInformation/OnlyContributesToPreselected0X
IRS990PF/SupplementaryInformation/TotGrantOrContriPaidDuringYear026000
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/LoansOrLoanGuarantees0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PerformanceOfServicesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PurchaseAssetsNoncharitableEO0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/ReimbursementArrangements0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RelationshipsNoncharitableEOs0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RentalOfFacilitiesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SalesOrExchangesOfAssets0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SharingOfFacilitiesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOfCashToNoncharitableEO0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOthAssetsNoncharitableEO0false
IRS990PF/UndistributedIncome/DistributableAmountAsAdjusted00
IRS990PF/UndistributedIncome/ExcessDistriCyovToNextYear026000
IRS990PF/UndistributedIncome/ExcessFromCurrentYear026000
IRS990PF/UndistributedIncome/QualifyingDistributions026000
IRS990PF/UndistributedIncome/RemainingDistriFromCorpus026000
IRS990PF/UndistributedIncome/TotalCorpus026000
IRS990PF/UndistributedIncome/UndistributedIncomeCY00
OtherDecreasesSchedule/OtherDecreases/Amount01975
OtherDecreasesSchedule/OtherDecreases/Description0CAPITAL LOSS
OtherIncomeSchedule2/OtherIncome/Description0OTER INC
OtherIncomeSchedule2/OtherIncome/RevenueAndExpensesPerBooks02410
OtherIncreasesSchedule/OtherIncreases/Amount0642699
OtherIncreasesSchedule/OtherIncreases/Description0TRUST PRINCIPAL
ReasonableCauseExplanation/Explanation0THIS IS THE INITIAL YEAR OF THE FOUNDATION AND GETTING ACCOUNTING RECORDS IN ORDER TOOK LONGER THAN ANTICIPATED.
ReturnHeader/BuildTS02016-02-24 21:20:13Z
ReturnHeader/Filer/EIN0271812624
ReturnHeader/Filer/Name/BusinessNameLine10BRUCE A BRO CHARITABLE FOUND
ReturnHeader/Filer/NameControl0BRUC
ReturnHeader/Filer/Phone05153142190
ReturnHeader/Filer/USAddress/AddressLine1019 CLEAR CROSSING TRAIL
ReturnHeader/Filer/USAddress/City0HENDERSON
ReturnHeader/Filer/USAddress/State0NV
ReturnHeader/Filer/USAddress/ZIPCode089052
ReturnHeader/Officer/AuthorizeThirdParty0true
ReturnHeader/Officer/DateSigned02012-05-11
ReturnHeader/Officer/Name0BRUCE A BRO
ReturnHeader/Officer/Phone05153142190
ReturnHeader/Officer/Title0TRUSTEE
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10MUXFELDT ASSOCIATES CPA PC
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine102309 B CHATBURN AVE
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0HARLAN
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0IA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode051537
ReturnHeader/Preparer/Name0MUXFELDT ASSOCIATES CPA PC
ReturnHeader/Preparer/Phone07127553366
ReturnHeader/ReturnType0990PF
ReturnHeader/TaxPeriodBeginDate02011-01-01
ReturnHeader/TaxPeriodEndDate02011-12-31
ReturnHeader/TaxYear02011
ReturnHeader/Timestamp02012-06-20T14:48:51-07:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings