Civic Intelligence

Columbus Community Childrens Center

EIN 42-1512506 • 501(c)3 • Columbus Junction, IA

Profile

Daycare and Preschool provided for children made up of a cross section of the local population

250 Colonels DriveColumbus Junction, IA 52738

n/A

Siviq Scores

Precomputed percentiles relative to similar nonprofits. These scores are descriptive rather than judgmental.

Liabilities / Assets

72nd percentile

0.03x

Higher debt load relative to assets than 72% of similar nonprofits.

501(c)3 • <$500k nonprofits • Source year 2023

Liabilities / Revenue

83rd percentile

0.10x

Higher debt load relative to revenue than 83% of similar nonprofits.

501(c)3 • <$500k nonprofits • Source year 2023

Net Margin

7th percentile

-163%

Higher net margin than 7% of similar nonprofits.

501(c)3 • <$500k nonprofits • Source year 2023

Top Officer Pay

81st percentile

$0

Higher top officer pay than 81% of similar nonprofits.

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

501(c)3 • <$500k nonprofits • Source year 2023

Asset Growth

27th percentile

-29%

Faster asset growth than 27% of similar nonprofits.

501(c)3 • <$500k nonprofits • Annualized from 2022 to 2023

Revenue Growth

8th percentile

-85%

Faster revenue growth than 8% of similar nonprofits.

501(c)3 • <$500k nonprofits • Annualized from 2022 to 2023

Balance Sheet
Liabilities / Assets72nd percentile

Assets

Down

$256,612

Down $105,357 (-29%) from 2022

Liabilities

Up

$7,013

Up $7,013 from 2022

Net Assets

Down

$249,599

Down $112,370 (-31%) from 2022

Operations
Liabilities / Revenue83rd percentileNet Margin7th percentile

Revenue

Down

$68,766

Down $380,326 (-85%) from 2022

Expenses

Down

$181,136

Down $179,374 (-50%) from 2022

Net Income

Down

-$112,370

Down $200,952 (-227%) from 2022

Trend Graphs

Balance Sheet Trend

Asset Growth27th percentile

Grouped bars show assets, liabilities, and net assets across loaded filings.

$400K$300K$200K$100K$0Assets 2010: $246,205Liabilities 2010: $3,3292010Assets 2011: $234,397Liabilities 2011: $4,601Net Assets 2011: $229,7962011Assets 2012: $227,702Liabilities 2012: $5,316Net Assets 2012: $222,3862012Assets 2013: $203,536Liabilities 2013: $6,536Net Assets 2013: $197,0002013Assets 2014: $195,860Liabilities 2014: $6,750Net Assets 2014: $189,1102014Assets 2015: $201,487Liabilities 2015: $3,565Net Assets 2015: $197,9222015Assets 2016: $181,037Liabilities 2016: $22,096Net Assets 2016: $158,9412016Assets 2017: $171,025Liabilities 2017: $5,086Net Assets 2017: $165,9392017Assets 2018: $159,751Liabilities 2018: $3,877Net Assets 2018: $155,8742018Assets 2019: $155,932Liabilities 2019: $2,1882019Assets 2020: $185,030Liabilities 2020: $1,891Net Assets 2020: $183,1392020Assets 2021: $279,767Liabilities 2021: $6,380Net Assets 2021: $273,3872021Assets 2022: $361,969Liabilities 2022: $0Net Assets 2022: $361,9692022Assets 2023: $256,612Liabilities 2023: $7,013Net Assets 2023: $249,5992023

Highlighted filing

2023

Assets$256,612
Liabilities$7,013
Net Assets$249,599
Open 2023 Filing

Operations Trend

Revenue Growth8th percentile

Revenue, expenses, and net income by year, with the latest filing highlighted.

$600K$400K$200K$0-$200KRevenue 2010: $219,031Expenses 2010: $236,764Net Income 2010: -$17,7332010Revenue 2011: $197,340Expenses 2011: $210,417Net Income 2011: -$13,0772011Revenue 2012: $185,458Expenses 2012: $193,171Net Income 2012: -$7,7132012Revenue 2013: $152,173Expenses 2013: $177,538Net Income 2013: -$25,3652013Revenue 2014: $168,662Expenses 2014: $176,962Net Income 2014: -$8,3002014Revenue 2015: $219,880Expenses 2015: $211,068Net Income 2015: $8,8122015Revenue 2016: $246,253Expenses 2016: $285,234Net Income 2016: -$38,9812016Revenue 2017: $267,683Expenses 2017: $260,685Net Income 2017: $6,9982017Revenue 2018: $231,827Expenses 2018: $241,892Net Income 2018: -$10,0652018Revenue 2019: $185,937Expenses 2019: $188,067Net Income 2019: -$2,1302019Revenue 2020: $164,980Expenses 2020: $135,585Net Income 2020: $29,3952020Revenue 2021: $348,114Expenses 2021: $257,866Net Income 2021: $90,2482021Revenue 2022: $449,092Expenses 2022: $360,510Net Income 2022: $88,5822022Revenue 2023: $68,766Expenses 2023: $181,136Net Income 2023: -$112,3702023

Highlighted filing

2023

Revenue$68,766
Expenses$181,136
Net Income-$112,370
Open 2023 Filing

Filings

Most recent year

2023 • Form 990XML pending. An XML filing is linked for this year, but detailed extraction is still pending.

Open filing
Assets
$256,612
Liabilities
$7,013
Net assets
$249,599
Revenue
$68,766
Expenses
$181,136
Net income
-$112,370
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.57$0.07$2.50$0.69$1.81$1.12
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$3.62$0.00$3.62$4.49$3.61$0.89
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.80$0.06$2.73$3.48$2.58$0.90
2020Detailed filing. Detailed filing data is available for this year.$1.85$0.02$1.83$1.65$1.36$0.29
2019Summary only. Only limited summary data is available for this year.$1.56$0.02$1.86$1.88$0.02
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.60$0.04$1.56$2.32$2.42$0.10
2017Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.71$0.05$1.66$2.68$2.61$0.07
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.81$0.22$1.59$2.46$2.85$0.39
2015XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.01$0.04$1.98$2.20$2.11$0.09
2014Detailed filing. Detailed filing data is available for this year.$1.96$0.07$1.89$1.69$1.77$0.08
2013XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.04$0.07$1.97$1.52$1.78$0.25
2012XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.28$0.05$2.22$1.85$1.93$0.08
2011XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.34$0.05$2.30$1.97$2.10$0.13
2010Summary only. Only limited summary data is available for this year.$2.46$0.03$2.19$2.37$0.18
Latest Detailed Filing

The latest 2023 filing currently has linked XML that has not been fully parsed yet. Showing the latest detailed filing from 2020 below.

Jump To
Filing Snapshot
Filing Period
Jan 1, 2020 to Dec 31, 2020
Signed
Jul 19, 2021
Return Version
2020v4.1
Gross Receipts
$164,980
Mission and Program Overview

Mission

Provide day care services for up to 20 children, ages newborn to 5.

Provide day care services

Program Services

DescriptionGrantsExpenses
TO PROVIDE CHILDCARE SERVICES FOR AN AVERAGE OF 20 CHILDREN PER DAY, AGES INFANTS TO 5 YEARS OF AGE. PROGRAMS HAVE BEEN DEVELOPED TO PROVIDE STEM EDUCATION FOR THESE AGES.-$135,585
Compensation and Service Providers
Top Officer Pay81st percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
MARSHA GEROTPresident-$0--
DAWN LEDGERSecretary-$0--
Filing and Contact Details

Filer

Filer Name
Columbus Community Childrens Cente
EIN
42-1512506
Address
250 COLONELS DRIVE, COLUMBUS JUNCTION, IA 52738

Signing Officer

Name
Marsha Gerot
Title
President
Phone
3192120341
Signed
2021-07-19
Discuss with paid preparer
Yes

Preparer

Firm
Ivan Arthur Inc
Address
129 Main Street, Columbus Junction, IA 52738
Preparer
Ivan Arthur
Phone
3197282279
Supplemental Narrative

Additional Explanations

Description of other revenue Part I line 8

“Description amountpayroll protection program 26,600”

Description of other expenses Part I line 16

“Description amountmeals & treats for kids 6,689vehicle expenses 179dues, fees 1,279office expenses 544payroll taxes 7,511supplies 2,633depreciation 3,324”

Description of total liabilities Part II line 26

“Category beginning of year end of yearpayroll taxes 2,188 1,891”

Raw XML Appendix158 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
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/PersonNm0MARSHA GEROT
IRS990EZ/BooksInCareOfDetail/PhoneNum03197285101
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 231
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0COLUMBUS JUNCTION
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IA
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd052738
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt01408
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt031705
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt07300
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt029395
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt02319
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0155932
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0185030
IRS990EZ/GrossReceiptsAmt0164980
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LandAndBuildingsGrp/BOYAmt0154524
IRS990EZ/LandAndBuildingsGrp/EOYAmt0153325
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0153744
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0183139
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0153744
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0183139
IRS990EZ/OccupancyRentUtltsAndMaintAmt022007
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt03.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt12.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0MARSHA GEROT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1DAWN LEDGER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1SECRETARY
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt00
IRS990EZ/OtherAssetsTotalDetail/EOYAmt00
IRS990EZ/OtherExpensesTotalAmt022159
IRS990EZ/OtherRevenueTotalAmt026600
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0PROVIDE DAY CARE SERVICES
IRS990EZ/ProgramServiceRevenueAmt0131080
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0TO PROVIDE CHILDCARE SERVICES FOR AN AVERAGE OF 20 CHILDREN PER DAY, AGES INFANTS TO 5 YEARS OF AGE. PROGRAMS HAVE BEEN DEVELOPED TO PROVIDE STEM EDUCATION FOR THESE AGES.
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt0135585
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt089100
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt02188
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt01891
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0135585
IRS990EZ/TotalProgramServiceExpensesAmt0135585
IRS990EZ/TotalRevenueAmt0164980
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0NONE
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt07300
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt065670
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt091700
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt0107880
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt044853
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0317403
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt0419
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt0419
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt0131080
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt0120267
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt0140127
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt0158553
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt0199981
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt0750008
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt0419
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt0419
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/InvestmentIncomePYPct00.00000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.99960
IRS990ScheduleA/PublicSupportPY509Pct00.99950
IRS990ScheduleA/PublicSupportTotal509Amt01067411
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt0138380
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt0185937
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt0231827
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt0266433
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt0244834
IRS990ScheduleA/Total509Grp/TotalAmt01067411
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt0138380
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt0185937
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt0231827
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt0266433
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt0245253
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt01067830
IRS990ScheduleB/ContributorInformationGrp/ContributorBusinessName/BusinessNameLine10RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorNum0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine10RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine20RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/City0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/State0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCode0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt0RESTRICTED
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0DESCRIPTION AMOUNTPAYROLL PROTECTION PROGRAM 26,600
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1DESCRIPTION AMOUNTMEALS & TREATS FOR KIDS 6,689VEHICLE EXPENSES 179DUES, FEES 1,279OFFICE EXPENSES 544PAYROLL TAXES 7,511SUPPLIES 2,633DEPRECIATION 3,324
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2CATEGORY BEGINNING OF YEAR END OF YEARPAYROLL TAXES 2,188 1,891
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Description of other revenue Part I line 8
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Description of other expenses Part I line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Description of total liabilities Part II line 26
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/OOBSecurityVerificationCd000
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd00
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0MARSHA GEROT
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum03192120341
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-07-19
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0COLUMBUS COMMUNITY CHILDRENS CENTE
ReturnHeader/Filer/BusinessNameControlTxt0COLU
ReturnHeader/Filer/EIN0421512506
ReturnHeader/Filer/USAddress/AddressLine1Txt0250 COLONELS DRIVE
ReturnHeader/Filer/USAddress/CityNm0COLUMBUS JUNCTION
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IA
ReturnHeader/Filer/USAddress/ZIPCd052738
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0421483309
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Ivan Arthur Inc
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0129 Main Street
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Columbus Junction
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd052738
ReturnHeader/PreparerPersonGrp/PhoneNum03197282279
ReturnHeader/PreparerPersonGrp/PreparationDt02021-07-19
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Ivan Arthur
ReturnHeader/ReturnTs02021-07-19T12:00:50-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0MARSHA
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0GEROT
ReturnHeader/TaxPeriodBeginDt02020-01-01
ReturnHeader/TaxPeriodEndDt02020-12-31
ReturnHeader/TaxYr02020

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Peer Organizations

Similar nonprofits based on the same Siviq industry and scale cohort. 501(c)3 • <$500k nonprofits