Civic Intelligence

Rainbow Village Inc

990 • Fiscal year 2012 • EIN 31-0885096

Jul 01, 2011 to Jun 30, 2012 • Filed on Nov 14, 2012

Organization Profile
481 Columbus Street45177
Siviq Scores

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

Liabilities / Assets

97th percentile

2.40x

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

2012 filings • 501(c)3 • <$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

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2012

Asset Growth

30th percentile

-9.5%

Faster asset growth than 30% of similar nonprofits.

2012 filings • 501(c)3 • <$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 / Assets97th percentile

Assets

Down

$7,009

Down $733 (-9.5%) from 2011

Net Assets

Down

-$9,792

Down $10,138 (-2930%) from 2011

Liabilities

Up

$16,801

Up $9,405 (+127%) from 2011

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

Up

$218,179

Up $2,343 (+1.1%) from 2011

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth30th percentile

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

$20K$10K$0-$10KAssets 2011: $7,742Liabilities 2011: $7,396Net Assets 2011: $3462011Assets 2012: $7,009Liabilities 2012: $16,801Net Assets 2012: -$9,7922012Assets 2015: $0Net Assets 2015: $02015

Highlighted filing

2012

Assets$7,009
Liabilities$16,801
Net Assets-$9,792
Open 2012 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$300K$200K$100K$0-$100KExpenses 2011: $215,8362011Expenses 2012: $218,1792012Revenue 2015: $296Expenses 2015: $869Net Income 2015: -$5732015

Highlighted filing

2012

Revenue-
Expenses$218,179
Net Income-
Open 2012 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2011 to Jun 30, 2012
Signed
Nov 14, 2012
Return Version
2011v1.2
Gross Receipts
$208,040
Filing and Contact Details

Filer

EIN
31-0885096
Raw XML Appendix317 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
IRS990/AccountantCompileOrReview0true
IRS990/AccountsPayableAccruedExpenses/BOY07396
IRS990/AccountsPayableAccruedExpenses/EOY07846
IRS990/ActivitiesConductedPartnership0false
IRS990/ActivityOrMissionDescription0DAYCARE SERVICES
IRS990/AddressPrincipalOfficerUS/AddressLine101526 HAWS CHAPEL
IRS990/AddressPrincipalOfficerUS/City0WILMINGTON
IRS990/AddressPrincipalOfficerUS/State0OH
IRS990/AddressPrincipalOfficerUS/ZIPCode045177
IRS990/AllOtherContributions019156
IRS990/AllOtherExpenses/Fundraising00
IRS990/AllOtherExpenses/ManagementAndGeneral0110
IRS990/AllOtherExpenses/ProgramServices032117
IRS990/AllOtherExpenses/Total032227
IRS990/AuditCommittee0false
IRS990/BenefitsPaidToMembersCY00
IRS990/BsnssRltnshpThruFamilyMember0false
IRS990/BsnssRltnshpWithOrganization0false
IRS990/CashNonInterestBearing/BOY02025
IRS990/CashNonInterestBearing/EOY02692
IRS990/ChangesToOrganizingDocs0false
IRS990/CollectionsOfArt0false
IRS990/CompensationFromOtherSources0false
IRS990/CompensationProcessCEO0false
IRS990/CompensationProcessOther0false
IRS990/ConflictOfInterestPolicy0false
IRS990/ConservationEasements0false
IRS990/ConsolidatedAuditFinancialStmt0false
IRS990/ContributionsGrantsCurrentYear0208040
IRS990/ContributionsGrantsPriorYear0222937
IRS990/CreditCounseling0false
IRS990/DecisionsSubjectToApproval0false
IRS990/DeductibleContributionsOfArt0false
IRS990/DeductibleNonCashContributions0false
IRS990/DelegationOfManagementDuties0false
IRS990/DepreciationDepletion/Fundraising00
IRS990/DepreciationDepletion/ManagementAndGeneral00
IRS990/DepreciationDepletion/ProgramServices01400
IRS990/DepreciationDepletion/Total01400
IRS990/DescribedIn501C30true
IRS990/Description0PROGRAM EXPENSES WERE INCURRED TO OPERATE THE DAYCARE CENTER ON A DAILY BASIS. THE CENTER PROVIDES DAYCARE SERVICES FOR WORKING ADULTS IN THE WILMINGTON, OH AREA.
IRS990/DisregardedEntity0false
IRS990/DocumentRetentionPolicy0false
IRS990/DonorAdvisedFunds0false
IRS990/DoNotFollowSFAS1170X
IRS990/ElectionOfBoardMembers0false
IRS990/EmploymentTaxReturnsFiled0false
IRS990/ExcessBenefitTransaction0false
IRS990/Expense0201028
IRS990/FamilyOrBusinessRelationship0false
IRS990/FederalGrantAuditRequired0false
IRS990/FeesForServicesAccounting/Fundraising00
IRS990/FeesForServicesAccounting/ManagementAndGeneral03860
IRS990/FeesForServicesAccounting/ProgramServices00
IRS990/FeesForServicesAccounting/Total03860
IRS990/FinancialStatementSeparate0X
IRS990/ForeignActivities0false
IRS990/ForeignFinancialAccount0false
IRS990/ForeignOffice0false
IRS990/Form8282PropertyDisposedOf0false
IRS990/Form990PartVIISectionA/AverageHoursPerWeek02.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek10.50
IRS990/Form990PartVIISectionA/AverageHoursPerWeek20.50
IRS990/Form990PartVIISectionA/AverageHoursPerWeek30.50
IRS990/Form990PartVIISectionA/NamePerson0BRIAN BOURGRAF
IRS990/Form990PartVIISectionA/NamePerson1BONNIE
IRS990/Form990PartVIISectionA/NamePerson2JODY TOLLE
IRS990/Form990PartVIISectionA/NamePerson3CONNIE BAILEY
IRS990/Form990PartVIISectionA/Officer0X
IRS990/Form990PartVIISectionA/Officer1X
IRS990/Form990PartVIISectionA/Officer2X
IRS990/Form990PartVIISectionA/Officer3X
IRS990/Form990PartVIISectionA/OtherCompensation00
IRS990/Form990PartVIISectionA/OtherCompensation10
IRS990/Form990PartVIISectionA/OtherCompensation20
IRS990/Form990PartVIISectionA/OtherCompensation30
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization00
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization10
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization20
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization30
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs00
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs10
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs20
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs30
IRS990/Form990PartVIISectionA/Title0President
IRS990/Form990PartVIISectionA/Title1Mathews
IRS990/Form990PartVIISectionA/Title2Secretary
IRS990/Form990PartVIISectionA/Title3Treasurer
IRS990/Form990ProvidedToGoverningBody0false
IRS990/FormersListed0false
IRS990/FSAudited0false
IRS990/FundraisingActivities0false
IRS990/FundsToPayPremiums0false
IRS990/Gaming0false
IRS990/GovernmentGrants0141985
IRS990/GrantsAndSimilarAmntsCY00
IRS990/GrantsToIndividuals0false
IRS990/GrantsToOrganizations0false
IRS990/GrantToRelatedPerson0false
IRS990/GrossReceipts0208040
IRS990/GroupReturnForAffiliates0false
IRS990/Hospital0false
IRS990/IndependentAuditFinancialStmt0false
IRS990/IndoorTanningServices0false
IRS990/InfoInScheduleOPartVI0X
IRS990/Insurance/Fundraising00
IRS990/Insurance/ManagementAndGeneral00
IRS990/Insurance/ProgramServices01178
IRS990/Insurance/Total01178
IRS990/Interest/Fundraising00
IRS990/Interest/ManagementAndGeneral00
IRS990/Interest/ProgramServices0449
IRS990/Interest/Total0449
IRS990/InvestmentIncomeCurrentYear00
IRS990/InvestmentInJointVenture0false
IRS990/LandBldgEquipmentAccumDeprec019497
IRS990/LandBuildingsEquipmentBasis023814
IRS990/LandBuildingsEquipmentBasisNet/BOY05717
IRS990/LandBuildingsEquipmentBasisNet/EOY04317
IRS990/LoanToOfficerOrDQP0false
IRS990/LobbyingActivities0false
IRS990/LocalChapters0false
IRS990/MaterialDiversionOrMisuse0false
IRS990/MembershipDues046899
IRS990/MembersOrStockholders0false
IRS990/MethodOfAccountingCash0X
IRS990/MinutesOfCommittees0true
IRS990/MinutesOfGoverningBody0true
IRS990/MissionDescription0DAYCARE SERVICES
IRS990/MoreThan5000KToIndividuals0false
IRS990/MoreThan5000KToOrganizations0false
IRS990/MortNotesPyblSecuredInvestProp/EOY08955
IRS990/NameOfPrincipalOfficerPerson0BRIAN BOURGRAF
IRS990/NbrIndependentVotingMembers00
IRS990/NbrVotingGoverningBodyMembers04
IRS990/NbrVotingMembersGoverningBody04
IRS990/NetAssetsOrFundBalancesBOY0346
IRS990/NetAssetsOrFundBalancesEOY0-9792
IRS990/NoListedPersonsCompensated0X
IRS990/NonDeductibleContributions0false
IRS990/NumberFormsTransmittedWith109600
IRS990/NumberIndependentVotingMembers00
IRS990/NumberOfEmployees023
IRS990/NumberW2GIncluded00
IRS990/Occupancy/Fundraising00
IRS990/Occupancy/ManagementAndGeneral00
IRS990/Occupancy/ProgramServices013329
IRS990/Occupancy/Total013329
IRS990/OfficerEntityWithBsnssRltnshp0false
IRS990/OfficerMailingAddress0false
IRS990/Organization501c30X
IRS990/OtherExpensePriorYear056197
IRS990/OtherExpensesCurrentYear061391
IRS990/OtherExpenses/Description0workers compensation
IRS990/OtherExpenses/Description1fuel
IRS990/OtherExpenses/Description2auto expense
IRS990/OtherExpenses/Description3repairs & maintenance
IRS990/OtherExpenses/Fundraising00
IRS990/OtherExpenses/Fundraising10
IRS990/OtherExpenses/Fundraising20
IRS990/OtherExpenses/Fundraising30
IRS990/OtherExpenses/ManagementAndGeneral00
IRS990/OtherExpenses/ManagementAndGeneral10
IRS990/OtherExpenses/ManagementAndGeneral20
IRS990/OtherExpenses/ManagementAndGeneral30
IRS990/OtherExpenses/ProgramServices02572
IRS990/OtherExpenses/ProgramServices1140
IRS990/OtherExpenses/ProgramServices20
IRS990/OtherExpenses/ProgramServices36236
IRS990/OtherExpenses/Total02572
IRS990/OtherExpenses/Total1140
IRS990/OtherExpenses/Total20
IRS990/OtherExpenses/Total36236
IRS990/OtherRevenueCurrentYear00
IRS990/OtherSalariesAndWages/Fundraising00
IRS990/OtherSalariesAndWages/ManagementAndGeneral00
IRS990/OtherSalariesAndWages/ProgramServices0143607
IRS990/OtherSalariesAndWages/Total0143607
IRS990/PartialLiquidation0false
IRS990/PayrollTaxes/Fundraising00
IRS990/PayrollTaxes/ManagementAndGeneral013181
IRS990/PayrollTaxes/ProgramServices00
IRS990/PayrollTaxes/Total013181
IRS990/PoliticalActivities0false
IRS990/PremiumsPaid0false
IRS990/PriorExcessBenefitTransaction0false
IRS990/ProfessionalFundraising0false
IRS990/ProgramServiceRevenueCY00
IRS990/ProhibitedTaxShelterTrans0false
IRS990/QuidProQuoContributions0false
IRS990/ReconcilationRevenueExpenses0-10139
IRS990/RelatedEntity0false
IRS990/RelatedOrgControlledEntity0false
IRS990/ReportFin48Footnote0false
IRS990/ReportInvestOthSecurities0false
IRS990/ReportLandBldgEquip0true
IRS990/ReportOtherAssets0false
IRS990/ReportOtherLiabilities0false
IRS990/ReportProgRelInvest0false
IRS990/RetainedEarningsEndowmentEtc/BOY0346
IRS990/RetainedEarningsEndowmentEtc/EOY0-9792
IRS990/Revenue0208040
IRS990/RevenuesLessExpensesCY0-10139
IRS990/RevenuesLessExpensesPriorYear07101
IRS990/SalariesEtcCurrentYear0156788
IRS990/SalariesEtcPriorYear0159639
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYear0208040
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYearMinus1Year0222937
IRS990ScheduleA/GiftsGrantsContribReceived170/Total0430977
IRS990ScheduleA/GrossInvestmentIncome170/Total00
IRS990ScheduleA/InvestmentIncomePercentage00
IRS990ScheduleA/PubliclySupportedOrg170b1Avi0X
IRS990ScheduleA/PublicSupportPercentage50900
IRS990ScheduleA/PublicSupportPertcentage17001.00000
IRS990ScheduleA/PublicSupportPertcentPriorYear01.00000
IRS990ScheduleA/PublicSupportTotal1700430977
IRS990ScheduleA/PublicSupportTotal50900
IRS990ScheduleA/ThirtyThreePercntTestsCY1700X
IRS990ScheduleA/Total170/CurrentTaxYear0208040
IRS990ScheduleA/Total170/CurrentTaxYearMinus1Year0222937
IRS990ScheduleA/Total170/Total0430977
IRS990ScheduleA/TotalSupport0430977
IRS990/ScheduleBRequired0false
IRS990ScheduleD/Equipment/Depreciation09162
IRS990ScheduleD/Equipment/OtherCostOrOtherBasis09162
IRS990ScheduleD/LeaseholdImprovements/Depreciation07652
IRS990ScheduleD/LeaseholdImprovements/OtherCostOrOtherBasis07652
IRS990ScheduleD/OtherLandBuildings/BookValue04317
IRS990ScheduleD/OtherLandBuildings/Depreciation02683
IRS990ScheduleD/OtherLandBuildings/OtherCostOrOtherBasis07000
IRS990ScheduleD/TotalOfBookValueLandBuildings04317
IRS990/ScheduleJRequired0false
IRS990ScheduleO/GeneralExplanation/Explanation0They have not had a board meeting before filing had to be done
IRS990ScheduleO/GeneralExplanation/Explanation1PAYROLL EXPENSES WORKERS COMPENSATION FUEL AUTO EXPENSE OFFICE SUPPLIES FOOD MATERIALS/ACTIVITIES PROFESSIONAL FEES DUES & SUBSCRIPTIONS SEMINARS & TUITION INTEREST EXPENSE BANK SERVICE CHARGES MISCELLANEOUS EXPENSE FINES & PENALITIES
IRS990ScheduleO/GeneralExplanation/Explanation2OFFICE SUPPLIES 2961. 2961. PRINTING & POSTAGE 697. 697. 0. 0. FOOD 17957. 17957. LICENSES AND FEES 373. 373. ADVERTISING 270. 270. MATERIALS & ACTIVITIES 5395. 5395. 0. 0. GIFTS 211. 211. 0. 0. PROFESSIONAL FEES 110. 110. DUES & SUBSCRIPTIONS 921. 921. SEMINARS & TRAINING 314. 314. BANK SERVICE CHARGES 2201. 2201. MISCELLANEOUS 35. 35. PENALTIES 750. 750. JANITORIAL SERVICE 32. 32.
IRS990ScheduleO/GeneralExplanation/Identifier0Pt VI, Line 11a
IRS990ScheduleO/GeneralExplanation/Identifier1Form 990EZ, Part I, Line 16
IRS990ScheduleO/GeneralExplanation/Identifier2Form 990, Part IX, Line 24f
IRS990/ScheduleORequired0true
IRS990/School0false
IRS990/SignificantChange0false
IRS990/SignificantNewProgramServices0false
IRS990/StateLegalDomicile0OH
IRS990/SubjectToProxyTax0false
IRS990/TaxablePartyNotification0false
IRS990/TaxExemptBonds0false
IRS990/Terminated0false
IRS990/TermOrPermanentEndowments0false
IRS990/TheBooksAreInCareOf/AddressUS/AddressLine102911 N SR 72
IRS990/TheBooksAreInCareOf/AddressUS/City0SABINA
IRS990/TheBooksAreInCareOf/AddressUS/State0OH
IRS990/TheBooksAreInCareOf/AddressUS/ZIPCode045169
IRS990/TheBooksAreInCareOf/NamePerson0PENNY S MOORE
IRS990/TheBooksAreInCareOf/TelephoneNumber09375844880
IRS990/TotalAssets/BOY07742
IRS990/TotalAssetsBOY07742
IRS990/TotalAssets/EOY07009
IRS990/TotalAssetsEOY07009
IRS990/TotalCompGT150K0false
IRS990/TotalContributions0208040
IRS990/TotalExpensesCurrentYear0218179
IRS990/TotalExpensesPriorYear0215836
IRS990/TotalFunctionalExpenses/Fundraising00
IRS990/TotalFunctionalExpenses/ManagementAndGeneral017151
IRS990/TotalFunctionalExpenses/ProgramServices0201028
IRS990/TotalFunctionalExpenses/Total0218179
IRS990/TotalFundrsngExpCurrentYear00
IRS990/TotalGrossUBI00
IRS990/TotalLiabilities/BOY07396
IRS990/TotalLiabilitiesBOY07396
IRS990/TotalLiabilities/EOY016801
IRS990/TotalLiabilitiesEOY016801
IRS990/TotalLiabNetAssetsFundBalances/BOY07742
IRS990/TotalLiabNetAssetsFundBalances/EOY07009
IRS990/TotalNbrEmployees023
IRS990/TotalNbrVolunteers00
IRS990/TotalNetAssetsFundBalances/BOY0346
IRS990/TotalNetAssetsFundBalances/EOY0-9792
IRS990/TotalProfFundrsngExpCY00
IRS990/TotalProgramServiceExpense0201028
IRS990/TotalRevenueCurrentYear0208040
IRS990/TotalRevenuePriorYear0222937
IRS990/TotalRevenue/TotalRevenueColumn0208040
IRS990/TransactionRelatedEntity0false
IRS990/TypeOfOrganizationCorporation0X
IRS990/UnrelatedBusinessIncome0false
IRS990/UponRequest0X
IRS990/WebSite0N/A
IRS990/WhistleblowerPolicy0false
IRS990/YearFormation01993
ReturnHeader/BuildTS02016-02-24 21:20:13Z
ReturnHeader/Filer/EIN0310885096
ReturnHeader/Filer/Name/BusinessNameLine10RAINBOW VILLAGE INC
ReturnHeader/Filer/NameControl0RAIN
ReturnHeader/Filer/Phone09373821762
ReturnHeader/Filer/USAddress/AddressLine10481 COLUMBUS STREET
ReturnHeader/Filer/USAddress/City0WILMINGTON
ReturnHeader/Filer/USAddress/State0OH
ReturnHeader/Filer/USAddress/ZIPCode045177
ReturnHeader/Officer/AuthorizeThirdParty0true
ReturnHeader/Officer/DateSigned02012-11-14
ReturnHeader/Officer/Name0BRIAN BOURGRAF
ReturnHeader/Officer/Phone09373821762
ReturnHeader/Officer/Title0PRESIDENT
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10PENNY S MOORE CPA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine102911 N STATE ROUTE 72
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0SABINA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0OH
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode0451699119
ReturnHeader/Preparer/Name0PENNY S MOORE CPA
ReturnHeader/Preparer/Phone09375844880
ReturnHeader/Preparer/SelfEmployed0X
ReturnHeader/ReturnType0990
ReturnHeader/TaxPeriodBeginDate02011-07-01
ReturnHeader/TaxPeriodEndDate02012-06-30
ReturnHeader/TaxYear02011
ReturnHeader/Timestamp02012-11-14T11:34:30-08:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2012 • Form 990Facts available. Structured filing facts are available, but richer extracted sections are limited.

Open filing
Assets
$7,009
Liabilities
$16,801
Net assets
-$9,792
Revenue
-
Expenses
$218,179
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2015Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.01$0.01
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.07$0.17$0.10$2.18
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.08$0.07$0.00$2.16