Civic Intelligence

Charles E Shellabarger Educational Trust

990PF • Fiscal year 2012 • EIN 42-6574321

Jan 01, 2012 to Dec 31, 2012 • Filed on May 15, 2013

Organization Profile
Community Bank 229 Main St52738
Siviq Scores

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

Liabilities / Assets

58th percentile

0.00x

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

2012 filings • <$500k nonprofits • Source year 2012

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2012

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2012

Top Officer Pay

82nd percentile

$0

Higher top officer pay than 82% of similar nonprofits.

2012 filings • <$500k nonprofits • Source year 2012

Asset Growth

42nd percentile

-2.3%

Faster asset growth than 42% of similar nonprofits.

2012 filings • <$500k nonprofits • Annualized from 2011 to 2012

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / Assets58th percentile

Assets

Down

$255,246

Down $5,973 (-2.3%) from 2011

Net Assets

$255,246

No earlier filing loaded for comparison.

Liabilities

Flat

$0

Flat from 2011

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

Up

$15,633

Up $2,906 (+23%) from 2011

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth42nd percentile

The highlighted filing sits inside the broader history for assets, liabilities, and net assets.

$300K$200K$100K$0Assets 2011: $261,219Liabilities 2011: $02011Assets 2012: $255,246Liabilities 2012: $0Net Assets 2012: $255,2462012Assets 2013: $250,908Liabilities 2013: $0Net Assets 2013: $250,9082013Assets 2014: $248,158Liabilities 2014: $0Net Assets 2014: $248,1582014Assets 2015: $236,025Liabilities 2015: $0Net Assets 2015: $236,0252015Assets 2016: $226,022Liabilities 2016: $0Net Assets 2016: $226,0222016Assets 2017: $218,983Liabilities 2017: $0Net Assets 2017: $218,9832017Assets 2018: $207,873Liabilities 2018: $0Net Assets 2018: $207,8732018Assets 2019: $202,076Liabilities 2019: $0Net Assets 2019: $202,0762019Assets 2020: $201,104Liabilities 2020: $0Net Assets 2020: $201,1042020Assets 2021: $185,489Liabilities 2021: $0Net Assets 2021: $185,4892021Assets 2022: $177,337Liabilities 2022: $1,000Net Assets 2022: $176,3372022Assets 2023: $168,610Liabilities 2023: $0Net Assets 2023: $168,6102023Assets 2024: $160,886Liabilities 2024: $0Net Assets 2024: $160,8862024

Highlighted filing

2012

Assets$255,246
Liabilities$0
Net Assets$255,246
Open 2012 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$20K$10K$0-$10K-$20KRevenue 2011: $9,261Expenses 2011: $12,727Net Income 2011: -$3,4662011Expenses 2012: $15,6332012Revenue 2013: $8,954Expenses 2013: $13,793Net Income 2013: -$4,8392013Revenue 2014: $9,251Expenses 2014: $12,000Net Income 2014: -$2,7492014Revenue 2015: $6,143Expenses 2015: $18,276Net Income 2015: -$12,1332015Revenue 2016: $3,501Expenses 2016: $13,504Net Income 2016: -$10,0032016Revenue 2017: $3,373Expenses 2017: $10,412Net Income 2017: -$7,0392017Revenue 2018: $3,251Expenses 2018: $14,361Net Income 2018: -$11,1102018Revenue 2019: $4,472Expenses 2019: $10,268Net Income 2019: -$5,7962019Revenue 2020: $3,553Expenses 2020: $4,525Net Income 2020: -$9722020Revenue 2021: $3,402Expenses 2021: $19,017Net Income 2021: -$15,6152021Revenue 2022: $3,261Expenses 2022: $11,413Net Income 2022: -$8,1522022Revenue 2023: $3,143Expenses 2023: $11,870Net Income 2023: -$8,7272023Revenue 2024: $3,069Expenses 2024: $10,793Net Income 2024: -$7,7242024

Highlighted filing

2012

Revenue-
Expenses$15,633
Net Income-
Open 2012 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2012 to Dec 31, 2012
Signed
May 15, 2013
Return Version
2012v2.2
Compensation and Service Providers
Top Officer Pay82nd percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
-Trustee-$0--
Grants and Assistance

Foundation Grants and Related Investments

TypeRecipientPurposeStatusLocationAmount
Paid GrantGrace College & Seminary FBO Marina RamirezScholarship Winner-Winona Lake, IN, US$1,000
Paid GrantIowa State University FBO Rachel PierceScholarship Winner-Ames, IA, US$1,000
Paid GrantUniversity of Iowa FBO Pryscilla EstudilloScholarship Winner-Iowa City, IA, US$1,000
Paid GrantIowa State University FBO Mackenzie GriffinScholarship Winner-Ames, IA, US$1,000
Paid GrantNorthwest Missouri State University FBO Delaney HowellScholarship Winner-Maryville, MO, US$1,000
Paid GrantIowa State University FBO Natalina SentsScholarship Winner-Ames, IA, US$1,000
Paid GrantIowa Wesleyan College FBO Laura WittmannScholarship Winner-Mt Pleasant, IA, US$1,000
Paid GrantUniversity of Iowa FBO Corey GrotheScholarship Winner-Iowa City, IA, US$1,000
Paid GrantIndian Hills FBO Chelsey SmithScholarship Winner-Ottumwa, IA, US$500
Paid GrantIowa State University FBO Rachel PierceScholarship Winner-Ames, IA, US$500
Paid GrantGrace College & Seminary FBO Marina RamirezScholarship Winner-Winona Lake, IN, US$500
Paid GrantUniversity of Northern Iowa FBO Janessa TownsleyScholarship Winner-Cedar Falls, IA, US$500
Paid GrantUniversity of Iowa FBO Marisa LeydenScholarship Winner-Iowa City, IA, US$500
Paid GrantIowa State University FBO Olivia RomeroScholarship Winner-Ames, IA, US$500
Paid GrantCentral College FBO Mitchell Jon BeanScholarship Winner-Pella, IA, US$500
Paid GrantIowa State University FBO Olivia RomeroScholarship Winner-Ames, IA, US$500
Paid GrantUniversity of Northern Iowa FBO Janessa TownsleyScholarship Winner-Cedar Falls, IA, US$500
Paid GrantUniversity of Iowa FBO Marisa LeydenScholarship Winner-Iowa City, IA, US$500
Paid GrantIndian Hills FBO Jake KellerScholarship Winner-Ottumwa, IA, US$500
Paid GrantGrace College & Seminary FBO Marina RamirezScholarship Winner-Winona Lake, IN, US$500
Paid GrantIowa State University FBO Rachel PierceScholarship Winner-Ames, IA, US$500
Filing and Contact Details

Filer

EIN
42-6574321
Raw XML Appendix367 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/AnalysisIncomeProducingActy/IntOnSavingsAndTempCashInvst/ExclusionAmount09139
IRS990PF/AnalysisIncomeProducingActy/ProgramServiceRevenuePartVII/Description0Refunded Scholarship
IRS990PF/AnalysisIncomeProducingActy/ProgramServiceRevenuePartVII/Description1Refunded Trustee Fee
IRS990PF/AnalysisIncomeProducingActy/ProgramServiceRevenuePartVII/ExclusionAmount0500
IRS990PF/AnalysisIncomeProducingActy/ProgramServiceRevenuePartVII/ExclusionAmount121
IRS990PF/AnalysisIncomeProducingActy/ProgramServiceRevenuePartVII/ExclusionCode001
IRS990PF/AnalysisIncomeProducingActy/ProgramServiceRevenuePartVII/ExclusionCode101
IRS990PF/AnalysisIncomeProducingActy/SubtotalsPartXVIA/ExclusionAmount09660
IRS990PF/AnalysisIncomeProducingActy/TotalPartXVIA09660
IRS990PF/AnalysisOfRevenueAndExpenses/CapitalGainNetIncmNetInvstIncm00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidDsbrsChrtblPrps014500
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidRevAndExpnss014500
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessOfRevenueOverExpenses0-5973
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsNetInvstIncm09139
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsRevAndExpnss09139
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblPrps0433
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesNetInvstIncm0434
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesRevAndExpnss0867
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncome08439
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnss0521
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncm0266
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnss0266
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblPrps014933
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncm0700
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnss015633
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvestmentIncome09139
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevenueAndExpenses09660
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblPrps0433
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncm0700
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnss01133
IRS990PF/BalanceSheets/CapitalStockBOY0261219
IRS990PF/BalanceSheets/OrgThatDoNotFollowSFAS1170X
IRS990PF/BalanceSheets/RetainedEarningsEOY0255246
IRS990PF/BalanceSheets/SavingsAndTempCashInvstBOY0261219
IRS990PF/BalanceSheets/SavingsAndTempCashInvstEOY0255246
IRS990PF/BalanceSheets/SavingsAndTempCashInvstEOYFMV0255246
IRS990PF/BalanceSheets/TotalAssetsBOY0261219
IRS990PF/BalanceSheets/TotalAssetsEOY0255246
IRS990PF/BalanceSheets/TotalAssetsEOYFMV0255246
IRS990PF/BalanceSheets/TotalLiabilitiesEOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsBOY0261219
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsEOY0255246
IRS990PF/BalanceSheets/TotalNetAssetsBOY0261219
IRS990PF/BalanceSheets/TotalNetAssetsEOY0255246
IRS990PF/ChangesInNetAssetsFundBalances/ExcessOfRevenueOverExpenses0-5973
IRS990PF/ChangesInNetAssetsFundBalances/Subtotal0255246
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesBOY0261219
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesEOY0255246
IRS990PF/DistributableAmount/DistributableAmountAsAdjusted012646
IRS990PF/DistributableAmount/DistributableAmountBeforeAdj012646
IRS990PF/DistributableAmount/DistributableAmountBeforeDed012646
IRS990PF/DistributableAmount/MinimumInvestmentReturn012730
IRS990PF/DistributableAmount/TaxBasedOnInvestmentIncome084
IRS990PF/DistributableAmount/TotalTax084
IRS990PF/ExciseTaxBasedOnInvestmentIncm/DomesticOrgMeetingSect4940e0X
IRS990PF/ExciseTaxBasedOnInvestmentIncm/InvestmentIncomeExciseTax084
IRS990PF/ExciseTaxBasedOnInvestmentIncm/Subtotal084
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxBasedOnInvestmentIncome084
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxDue084
IRS990PF/ExemptPF0X
IRS990PF/FMVAssetsEOY0255246
IRS990PF/MethodOfAccountingCash0X
IRS990PF/MinimumInvestmentReturn/AdjTotalFMVOfUnusedAssets0258483
IRS990PF/MinimumInvestmentReturn/AvgMonthlyCashBalances0258483
IRS990PF/MinimumInvestmentReturn/AvgMonthlyFMVOfSecurities00
IRS990PF/MinimumInvestmentReturn/CashDeemedCharitable03877
IRS990PF/MinimumInvestmentReturn/FMVAllOtherNoncharitableAssets00
IRS990PF/MinimumInvestmentReturn/MinimumInvestmentReturn012730
IRS990PF/MinimumInvestmentReturn/NetNoncharitableAssets0254606
IRS990PF/MinimumInvestmentReturn/TotalFMVOfUnusedAssets0258483
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition0000.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/BusinessName/BusinessNameLine10Community Bank
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title0Trustee
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine10229 Main Street
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City0Columbus Junction
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State0IA
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode052738
IRS990PF/QlfyUndSect4940eForReducedTax/AdjNonchrtblAssetsAndOnePct012442
IRS990PF/QlfyUndSect4940eForReducedTax/AdjustedNoncharitableAssets012358
IRS990PF/QlfyUndSect4940eForReducedTax/AverageDistributionRatio0000.048536
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear10000.043686
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear20000.053692
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear30000.046872
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear40000.050408
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear50000.048023
IRS990PF/QlfyUndSect4940eForReducedTax/LiableFor4942Tax0false
IRS990PF/QlfyUndSect4940eForReducedTax/NetNoncharitableAssets0254606
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear10259009
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear20266240
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear30261177
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear40260850
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear50269165
IRS990PF/QlfyUndSect4940eForReducedTax/OnePercentNetInvestmentIncome084
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributions014933
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear1011315
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear2014295
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear3012242
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear4013149
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear5012926
IRS990PF/QlfyUndSect4940eForReducedTax/TotalDistributionRatio0000.242681
IRS990PF/QualifyingDistributions/AdjQualifyingDistributions014849
IRS990PF/QualifyingDistributions/ExpensesAndContributions014933
IRS990PF/QualifyingDistributions/OnePctSect4940eOrgNetInvstIncm084
IRS990PF/QualifyingDistributions/QualifyingDistributions014933
IRS990PF/RlnOfActyToAccomOfExemptPrps/RlnOfActyToAccomOfExemptPrps/LineNumber03
IRS990PF/RlnOfActyToAccomOfExemptPrps/RlnOfActyToAccomOfExemptPrps/RelationshipStatement0Funds are held for the exclusive purpose of producing a return to provide scholarships.
IRS990PF/StatementsRegardingActivities/ActivitiesNotPrevReported0false
IRS990PF/StatementsRegardingActivities/ApplicableInsuranceContract0false
IRS990PF/StatementsRegardingActivities/AtLeast5000InAssets0true
IRS990PF/StatementsRegardingActivities/BooksInCareOfBusinessName/BusinessNameLine10Community Bank
IRS990PF/StatementsRegardingActivities/BooksInCareOfPhoneNumber03197282226
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine10229 Main Street
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/City0Columbus Junction
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/State0IA
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/ZIPCode052738
IRS990PF/StatementsRegardingActivities/ChangesToArticlesOrBylaws0false
IRS990PF/StatementsRegardingActivities/ComplyWithPublicInspectionRqr0true
IRS990PF/StatementsRegardingActivities/ForeignBank0false
IRS990PF/StatementsRegardingActivities/Form1120POLFiled0false
IRS990PF/StatementsRegardingActivities/Form990PFFiledWithAG0true
IRS990PF/StatementsRegardingActivities/Form990TFiled0false
IRS990PF/StatementsRegardingActivities/InterestInControlledEntity0false
IRS990PF/StatementsRegardingActivities/LegislativePoliticalActivities0false
IRS990PF/StatementsRegardingActivities/MoreThan100Spent0false
IRS990PF/StatementsRegardingActivities/NewSubstantialContributors0false
IRS990PF/StatementsRegardingActivities/PrivateOperatingFoundation0false
IRS990PF/StatementsRegardingActivities/RequirementsOfSect508e0true
IRS990PF/StatementsRegardingActivities/StatesFiledWith0IA
IRS990PF/StatementsRegardingActivities/TerminationEtc0false
IRS990PF/StatementsRegardingActivities/UnrelatedBusIncomeOver10000true
IRS990PF/StatementsRegardingActy4720/BorrowOrLendWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/BusinessHoldings0false
IRS990PF/StatementsRegardingActy4720/FurnishedGoodsWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/GrantsToIndividuals0true
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/SaleOrExchangeWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/TransferAssetsToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/TrFailToQualifyAsExceptions0false
IRS990PF/StatementsRegardingActy4720/UncorrectedJeopardyInvestments0false
IRS990PF/StatementsRegardingActy4720/UncorrectedPriorActs0false
IRS990PF/StatementsRegardingActy4720/UndistributedIncomePriorYear102010
IRS990PF/StatementsRegardingActy4720/UndistributedIncomePriorYears0true
IRS990PF/SummaryOfDirectCharitableActy/Description10The Trust distributed $14,500.00 to further the education of highschool graduates from the Columbus Community School District
IRS990PF/SummaryOfDirectCharitableActy/Expenses100
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/FormAndInfoAndMaterials0Requests should be made in writing and provide information concerning the year of graduation from Columbus Comm and the schooling for which assistance is sought
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientName0Columbus Comm HS Guidance Center
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientPhoneNumber03197282231
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/AddressLine101004 Colton Street
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/City0Columbus Junction
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/State0IA
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/ZIPCode052738
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RestrictionsOnAwards0Only available to persons who have completed high school in the Col. School Dist. or its successor and are pursuing education at institutions of higher learning or trade or vocational school
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/SubmissionDeadlines0March 1
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount01000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount11000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount2500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount3500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount4500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount5500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount6500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount7500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount8500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount9500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount101000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount111000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount121000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount131000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount141000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount15500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount16500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount17500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount18500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount19500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount201000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution0Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution1Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution2Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution3Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution4Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution5Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution6Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution7Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution8Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution9Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution10Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution11Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution12Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution13Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution14Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution15Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution16Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution17Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution18Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution19Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution20Scholarship Winner
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine10Grace College & Seminary FBO Marina Ramirez
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine11Iowa State University FBO Rachel Pierce
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine12Indian Hills FBO Chelsey Smith
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine13Iowa State University FBO Rachel Pierce
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine14Grace College & Seminary FBO Marina Ramirez
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine15University of Northern Iowa FBO Janessa Townsley
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine16University of Iowa FBO Marisa Leyden
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine17Iowa State University FBO Olivia Romero
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine18Central College FBO Mitchell Jon Bean
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine19Iowa State University FBO Olivia Romero
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine110University of Iowa FBO Pryscilla Estudillo
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine111Iowa State University FBO Mackenzie Griffin
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine112Northwest Missouri State University FBO Delaney Howell
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine113Iowa State University FBO Natalina Sents
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine114Iowa Wesleyan College FBO Laura Wittmann
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine115University of Northern Iowa FBO Janessa Townsley
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine116University of Iowa FBO Marisa Leyden
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine117Indian Hills FBO Jake Keller
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine118Grace College & Seminary FBO Marina Ramirez
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine119Iowa State University FBO Rachel Pierce
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine120University of Iowa FBO Corey Grothe
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine10200 Seminary Drive
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine111220 Beardshear Hall
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine12525 Grandview Avenue
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine131220 Beardshear Hall
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine14200 Seminary Drive
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine151227 W 27th Street
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine16208 Calvin Hall
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine171220 Beardshear Hall
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine18812 University
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine191220 Beardshear Hall
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine110208 Calvin Hall
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine1111220 Beardshear Hall
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine112800 University Drive
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine1131220 Beardshear Hall
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine114601 N Main Street
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine1151227 W 27th Street
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine116208 Calvin Hall
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine117525 Grandview Avenue
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine118200 Seminary Drive
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine1191220 Beardshear Hall
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine120208 Calvin Hall
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City0Winona Lake
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City1Ames
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City2Ottumwa
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City3Ames
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City4Winona Lake
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City5Cedar Falls
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City6Iowa City
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City7Ames
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City8Pella
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City9Ames
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City10Iowa City
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City11Ames
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City12Maryville
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City13Ames
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City14Mt Pleasant
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City15Cedar Falls
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City16Iowa City
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City17Ottumwa
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City18Winona Lake
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City19Ames
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City20Iowa City
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State0IN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State1IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State2IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State3IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State4IN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State5IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State6IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State7IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State8IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State9IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State10IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State11IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State12MO
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State13IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State14IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State15IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State16IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State17IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State18IN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State19IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State20IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode046590
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode1500112044
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode252501
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode3500112044
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode446590
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode550614
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode6522421315
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode7500112044
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode850129
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode9500112044
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode10522421315
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode11500112044
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode1264468
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode13500112044
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode1452641
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode1550614
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode16522421315
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode1752501
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode1846590
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode19500112044
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode20522421315
IRS990PF/SupplementaryInformation/TotGrantOrContriPaidDuringYear014500
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/AppliedToCurrentYear02140
IRS990PF/UndistributedIncome/AppliedToYear1012793
IRS990PF/UndistributedIncome/DistributableAmountAsAdjusted012646
IRS990PF/UndistributedIncome/PriorYear102008
IRS990PF/UndistributedIncome/PriorYear202009
IRS990PF/UndistributedIncome/PriorYear302010
IRS990PF/UndistributedIncome/PriorYearUndistributedIncome024499
IRS990PF/UndistributedIncome/QualifyingDistributions014933
IRS990PF/UndistributedIncome/TaxableAmount1024499
IRS990PF/UndistributedIncome/TotalForPriorYears024499
IRS990PF/UndistributedIncome/UndistributedIncomeCY010506
IRS990PF/UndistributedIncome/UndistributedIncomePriorYear012793
LegalFeesSchedule/LegalFees/Amount0867
LegalFeesSchedule/LegalFees/Category0Newell Sents
LegalFeesSchedule/LegalFees/DisbursementsCharitablePrps0433
LegalFeesSchedule/LegalFees/NetInvestmentIncome0434
OtherIncomeSchedule2/OtherIncome/Description0Misc
OtherIncomeSchedule2/OtherIncome/RevenueAndExpensesPerBooks0521
TaxesSchedule/Taxes/Amount0266
TaxesSchedule/Taxes/Category0Income tax
TaxesSchedule/Taxes/NetInvestmentIncome0266
ReturnHeader/BuildTS02016-02-25 16:41:14Z
ReturnHeader/Filer/EIN0426574321
ReturnHeader/Filer/Name/BusinessNameLine10Charles E Shellabarger Educational Trust
ReturnHeader/Filer/NameControl0CHAR
ReturnHeader/Filer/Phone03197282226
ReturnHeader/Filer/USAddress/AddressLine10Community Bank 229 Main St
ReturnHeader/Filer/USAddress/City0Columbus Junction
ReturnHeader/Filer/USAddress/State0IA
ReturnHeader/Filer/USAddress/ZIPCode052738
ReturnHeader/Officer/AuthorizeThirdParty0false
ReturnHeader/Officer/DateSigned02013-05-15
ReturnHeader/Officer/Name0Jane Phillips
ReturnHeader/Officer/Title0VPTrust Officer
ReturnHeader/Preparer/DatePrepared02013-05-15
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10Newell and Sents Law Office
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine10PO Box 188
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0Columbus Junction
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0IA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode0527380188
ReturnHeader/Preparer/Name0Steven A Sents
ReturnHeader/Preparer/Phone03197282426
ReturnHeader/Preparer/SelfEmployed0X
ReturnHeader/ReturnType0990PF
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-05-15T04:29:59-00:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2012 • Form 990PFDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$255,246
Liabilities
$0
Net assets
$255,246
Revenue
-
Expenses
$15,633
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.61$0.00$1.61$0.03$0.11$0.08
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.69$0.00$1.69$0.03$0.12$0.09
2022Detailed filing. Detailed filing data is available for this year.$1.77$0.01$1.76$0.03$0.11$0.08
2021Detailed filing. Detailed filing data is available for this year.$1.85$0.00$1.85$0.03$0.19$0.16
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.01$0.00$2.01$0.04$0.05$0.01
2019Detailed filing. Detailed filing data is available for this year.$2.02$0.00$2.02$0.04$0.10$0.06
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.08$0.00$2.08$0.03$0.14$0.11
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.19$0.00$2.19$0.03$0.10$0.07
2016Detailed filing. Detailed filing data is available for this year.$2.26$0.00$2.26$0.04$0.14$0.10
2015Detailed filing. Detailed filing data is available for this year.$2.36$0.00$2.36$0.06$0.18$0.12
2014Detailed filing. Detailed filing data is available for this year.$2.48$0.00$2.48$0.09$0.12$0.03
2013Detailed filing. Detailed filing data is available for this year.$2.51$0.00$2.51$0.09$0.14$0.05
2012Detailed filing. Detailed filing data is available for this year.$2.55$0.00$2.55$0.16
2011Summary only. Only limited summary data is available for this year.$2.61$0.00$0.09$0.13$0.03