Civic Intelligence

Charles E Shellabarger Educational Trust

990PF • Fiscal year 2018 • EIN 42-6574321

Jan 01, 2018 to Dec 31, 2018 • Filed on May 14, 2019

Organization Profile
Community Bank 229 Main StColumbus Junction, IA 52738

(319) 728-2226

Siviq Scores

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

Liabilities / Assets

59th percentile

0.00x

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

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

Liabilities / Revenue

59th percentile

0.00x

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

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

Net Margin

3rd percentile

-342%

Higher net margin than 3% of similar nonprofits.

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

Top Officer Pay

78th percentile

$1,642

Higher top officer pay than 78% of similar nonprofits.

Top officer pay equals 50.5% of source-year revenue.

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

Asset Growth

35th percentile

-5.1%

Faster asset growth than 35% of similar nonprofits.

2018 filings • <$500k nonprofits • Annualized from 2017 to 2018

Revenue Growth

42nd percentile

-3.6%

Faster revenue growth than 42% of similar nonprofits.

2018 filings • <$500k nonprofits • Annualized from 2017 to 2018

Balance Sheet
Liabilities / Assets59th percentile

Assets

Down

$207,873

Down $11,110 (-5.1%) from 2017

Net Assets

Down

$207,873

Down $11,110 (-5.1%) from 2017

Liabilities

Flat

$0

Flat from 2017

Revenue And Expenses
Liabilities / Revenue59th percentileNet Margin3rd percentile

Revenue

Down

$3,251

Down $122 (-3.6%) from 2017

Expenses

Up

$14,361

Up $3,949 (+38%) from 2017

Net Income

Down

-$11,110

Down $4,071 (-58%) from 2017

Historical Trend

Balance Sheet Trend

Asset Growth35th 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

2018

Assets$207,873
Liabilities$0
Net Assets$207,873
Open 2018 Filing

Operations Trend

Revenue Growth42nd percentile

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

2018

Revenue$3,251
Expenses$14,361
Net Income-$11,110
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2018 to Dec 31, 2018
Signed
May 14, 2019
Return Version
2018v3.1
Compensation and Service Providers
Top Officer Pay78th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
-Trustee-$1,642-$1,642
Filing and Contact Details

Filer

Filer Name
Charles E Shellabarger Educational Trust
EIN
42-6574321
Phone
3197282226
Address
Community Bank 229 Main St, Columbus Junction, IA 52738

Signing Officer

Name
Gary D Slight
Title
Vice Chrmn Sr Tr Off
Phone
3197282226
Signed
2019-05-14
Discuss with paid preparer
No

Preparer

Firm
Newell and Sents Law Office
Address
PO Box 188, Columbus Junction, IA 52738-0188
Preparer
Steven A Sents
Phone
3197282426
Raw XML Appendix311 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/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/UnrelatedBusinessTaxblIncmAmt03251
IRS990PF/AnalysisIncomeProducingActyGrp/ProgramServiceRevPartVIIGrp/Desc0Refunded Scholarship
IRS990PF/AnalysisIncomeProducingActyGrp/ProgramServiceRevPartVIIGrp/Desc1Refunded Trustee Fee
IRS990PF/AnalysisIncomeProducingActyGrp/ProgramServiceRevPartVIIGrp/ExclusionCd001
IRS990PF/AnalysisIncomeProducingActyGrp/ProgramServiceRevPartVIIGrp/ExclusionCd101
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt03251
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt03251
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt01642
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt01642
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt012000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt012000
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-11110
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt03251
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt03251
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesNetInvstIncmAmt0700
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesRevAndExpnssAmt0700
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt0890
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt019
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt019
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt012000
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt02361
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt014361
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt03251
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt03251
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt02361
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt02361
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-11110
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0207873
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0218983
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0207873
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt010502
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt010502
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt010502
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt010511
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt09
IRS990PF/DistributableAmountGrp/TotalTaxAmt09
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt09
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt09
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt09
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt09
IRS990PF/FMVAssetsEOYAmt0207873
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0218983
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0207873
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt0218983
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt0207873
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt0207873
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0218983
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0207873
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0207873
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0218983
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0207873
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0218983
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0207873
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0213428
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0213428
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt03201
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt010511
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0210227
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0213428
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt0000.65
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/BusinessName/BusinessNameLine1Txt0Community Bank & Trust
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt01642
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0Trustee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0229 Main Street
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0Columbus Junction
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0IA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd052738
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt010044
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt010053
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt010000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt011000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt014996
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt09000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt011354
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt0000.047777
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt0000.045628
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt0000.048339
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt0000.062887
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt0000.036617
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt0000.045412
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt09
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0210227
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0219165
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0227559
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0238461
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0245790
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0250020
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt012000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt0000.238883
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt011991
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt012000
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt09
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt012000
IRS990PF/RlnOfActyToAccomOfExmptPrpsGrp/RlnOfActyToAccomOfExmptPrpsGrp/LineNumberTxt03
IRS990PF/RlnOfActyToAccomOfExmptPrpsGrp/RlnOfActyToAccomOfExmptPrpsGrp/RelationshipStatementTxt0Funds are held for the exclusive purpose of producing a return to provide scholarships.
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0true
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/SubjToTaxRmnrtnExPrchtPymtInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransactionsFailToQlfyAsExcInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePY1Yr02013
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistrIncmSect4942a2NotAppInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0true
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0229 Main Street
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Columbus Junction
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0IA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd052738
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0IA
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0Community Bank & Trust
IRS990PF/StatementsRegardingActyGrp/PhoneNum03197282226
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SummaryOfDirectChrtblActyGrp/Description1Txt0The Trust distributed $12,000.00 to further the education of high school graduates from the Columbus but was not delivered until 2018 along with paying the administrative expenses associated with the management of the trust.
IRS990PF/SummaryOfDirectChrtblActyGrp/Expenses1Amt012000
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/FormAndInfoAndMaterialsTxt0Requests 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/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientPersonNm0Columbus Comm HS Guidance Center
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientPhoneNum03197282231
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/AddressLine1Txt01004 Colton Street
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/CityNm0Columbus Junction
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/StateAbbreviationCd0IA
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/ZIPCd052738
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RestrictionsOnAwardsTxt0Only 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/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/SubmissionDeadlinesTxt0March 1
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt01000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt12000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt21000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt31000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt41000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt51000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt61000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt71000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt81000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt91000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt101000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0Education
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1Education
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2Education
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt3Education
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt4Education
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt5Education
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt6Education
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt7Education
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt8Education
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt9Education
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt10Education
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm0Northwest Iowa Community College FB
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm1Muscatine Community College FBO Meg
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm2Iowa State University FBO Erik Rees
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm3Iowa State University FBO Kelsey Pr
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm4Simpson CollegeFBO Erin Rush
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm5Geneva College FBO Sarah Rae Todd
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm6Iowa State University FBO Laura Min
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm7Iowa State University FBO Thomas Pr
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm8Kirkwood Comm Colge FBO Courtney Za
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm9Indian Hills Comm Colge FBO Maki Me
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm10Iowa State University FBO Abel Mena
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt2None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt3None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt4None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt5None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt6None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt7None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt8None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt9None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt10None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0603 W Park Street
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt15396 152 Colorado Street
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt21220 Beardshear Hall
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt31220 Beardshear Hall
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt4701 North C Street
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt53200 College Avenue
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt61220 Beardshear Hall
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt71220 Beardshear Hall
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt86301 Main Campus Kirkwood Blvd SW
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt9525 Grand Avenue
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt101220 Beardshear Hall
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0Sheldon
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1Muscatine
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm2Ames
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm3Ames
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm4Indianola
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm5Beaver Falls
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm6Ames
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm7Ames
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm8Cedar Rapids
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm9Ottumwa
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm10Ames
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd2IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd3IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd4IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd5PA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd6IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd7IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd8IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd9IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd10IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd051201
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd152761
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd250011
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd350011
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd450125
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd515010
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd650011
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd750011
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd852404
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd952501
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd1050011
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt012000
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt01610
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt010390
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt010502
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt012000
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt08892
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt010390
LegalFeesSchedule/LegalFeesGrp/CategoryTxt0Newell and Sents
LegalFeesSchedule/LegalFeesGrp/LegalFeesAmt0700
LegalFeesSchedule/LegalFeesGrp/NetInvestmentIncomeAmt0700
TaxesSchedule/TaxesDetail/Amt019
TaxesSchedule/TaxesDetail/CategoryTxt0Tax on investment income
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt019
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0false
ReturnHeader/BusinessOfficerGrp/PersonNm0Gary D Slight
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Vice Chrmn Sr Tr Off
ReturnHeader/BusinessOfficerGrp/PhoneNum03197282226
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-05-14
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Charles E Shellabarger Educational Trust
ReturnHeader/Filer/BusinessNameControlTxt0CHAR
ReturnHeader/Filer/EIN0426574321
ReturnHeader/Filer/PhoneNum03197282226
ReturnHeader/Filer/USAddress/AddressLine1Txt0Community Bank 229 Main St
ReturnHeader/Filer/USAddress/CityNm0Columbus Junction
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IA
ReturnHeader/Filer/USAddress/ZIPCd052738
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId018E35F97B02EE7098B8A5D968DBC05AE7CF1DF1A
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0A231C67EDD9067B9CC71F27DFEEF19A4CC4A028D
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId04212062019131sq1e3ft
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02019-05-13
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0207.199.242.75
ReturnHeader/FilingSecurityInformation/IPDt02019-05-14
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm016:32:14
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Newell and Sents Law Office
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0PO Box 188
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Columbus Junction
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0527380188
ReturnHeader/PreparerPersonGrp/PhoneNum03197282426
ReturnHeader/PreparerPersonGrp/PreparationDt02019-05-14
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Steven A Sents
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02019-05-14T11:37:46-00:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02018-01-01
ReturnHeader/TaxPeriodEndDt02018-12-31
ReturnHeader/TaxYr02018

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$207,873
Liabilities
$0
Net assets
$207,873
Revenue
$3,251
Expenses
$14,361
Net income
-$11,110
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
2018Detailed filing. Detailed filing data is available for this year.$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