Civic Intelligence

The Crable Foundation

990EZ • Fiscal year 2017 • EIN 20-5626590

Jan 01, 2017 to Dec 31, 2017 • Filed on May 15, 2018

Organization Profilecrablefoundation.org
564 Miami Trace CourtLoveland, OH 45140

(866) 284-2984

Siviq Scores

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

Liabilities / Assets

Score unavailable

No value available

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

Source year 2017

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2017

Net Margin

2nd percentile

-391%

Higher net margin than 2% of similar nonprofits.

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

Top Officer Pay

76th percentile

$0

Higher top officer pay than 76% of similar nonprofits.

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

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

Asset Growth

26th percentile

-12%

Faster asset growth than 26% of similar nonprofits.

2017 filings • 501(c)3 • <$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

3rd percentile

-89%

Faster revenue growth than 3% of similar nonprofits.

2017 filings • 501(c)3 • <$500k nonprofits • Annualized from 2016 to 2017

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Down

$188,689

Down $26,586 (-12%) from 2016

Net Assets

Down

$188,689

Down $26,586 (-12%) from 2016

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin2nd percentile

Revenue

Down

$4,628

Down $36,431 (-89%) from 2016

Expenses

Down

$22,746

Down $14,643 (-39%) from 2016

Net Income

Down

-$18,118

Down $21,788 (-594%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth26th percentile

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

$300K$200K$100K$0Assets 2010: $158,140Liabilities 2010: $02010Assets 2011: $145,936Liabilities 2011: $02011Assets 2012: $158,194Liabilities 2012: $02012Assets 2013: $134,532Liabilities 2013: $0Net Assets 2013: $134,5322013Assets 2014: $201,476Liabilities 2014: $02014Assets 2015: $186,745Net Assets 2015: $186,7452015Assets 2016: $215,275Net Assets 2016: $215,2752016Assets 2017: $188,689Net Assets 2017: $188,6892017Assets 2018: $0Net Assets 2018: $02018

Highlighted filing

2017

Assets$188,689
Liabilities-
Net Assets$188,689
Open 2017 Filing

Operations Trend

Revenue Growth3rd percentile

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

$200K$100K$0-$100K-$200KRevenue 2010: $35,772Expenses 2010: $22,885Net Income 2010: $12,8872010Revenue 2011: $33,211Expenses 2011: $45,415Net Income 2011: -$12,2042011Revenue 2012: $71,240Expenses 2012: $58,982Net Income 2012: $12,2582012Revenue 2013: $50,490Expenses 2013: $74,152Net Income 2013: -$23,6622013Revenue 2014: $82,987Expenses 2014: $18,981Net Income 2014: $64,0062014Revenue 2015: $54,289Expenses 2015: $53,956Net Income 2015: $3332015Revenue 2016: $41,059Expenses 2016: $37,389Net Income 2016: $3,6702016Revenue 2017: $4,628Expenses 2017: $22,746Net Income 2017: -$18,1182017Revenue 2018: -$8,614Expenses 2018: $180,075Net Income 2018: -$188,6892018

Highlighted filing

2017

Revenue$4,628
Expenses$22,746
Net Income-$18,118
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
May 15, 2018
Return Version
2017v2.2
Gross Receipts
$4,628
Mission and Program Overview

Mission

To provide scholarship tuition assistance and athletic program funding support to exempt organizations.

Program Services

DescriptionGrantsExpenses
Provided scholarship tuition assistance and athletic program funding.$18,500-
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
Robert CrableChairman-$0--
Amy GeorgeTrustee-$0--
Bill CrableTreasurer-$0--
Brad PhillipsTrustee-$0--
John GeorgeTrustee-$0--
Filing and Contact Details

Filer

Filer Name
The Crable Foundation
EIN
20-5626590
Address
564 MIAMI TRACE COURT, LOVELAND, OH 45140

Signing Officer

Name
Bill Crable
Title
Trustee
Signed
2018-05-15
Discuss with paid preparer
Yes

Preparer

Firm
Stephanie M Bauer CPA Inc
Address
13200 STATE ROAD 46, SUNMAN, IN 47041
Preparer
Stephanie M Bauer
Phone
8129321399
Supplemental Narrative

Additional Explanations

Other Revenue.1

“Dividend & Interest Inc $4628”

Other Expenses.1

“Scholarships $18500”

Other Expenses.2

“Banking Expense $146”

Other Expenses.3

“Filing fee $100”

Raw XML Appendix166 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/PersonNm0BILL CRABLE
IRS990EZ/BooksInCareOfDetail/PhoneNum08662842984
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0564 MIAMI TRACE COURT
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0LOVELAND
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd045140
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0215275
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0188689
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-18118
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt04000
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form720FiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0215275
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0188689
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GrossReceiptsAmt04628
IRS990EZ/GrossReceiptsForPublicUseAmt00
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InitiationFeesAndCapContriAmt00
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0215275
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0188689
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0215275
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0188689
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt31.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt41.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0Robert Crable
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1Amy George
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2Bill Crable
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3Brad Phillips
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4John George
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0Chairman
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Trustee
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Treasurer
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Trustee
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4Trustee
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationFiled990TInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherChangesInNetAssetsAmt0-8468
IRS990EZ/OtherExpensesTotalAmt018746
IRS990EZ/OtherRevenueTotalAmt04628
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0To provide scholarship tuition assistance and athletic program funding support to exempt organizations.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0Provided scholarship tuition assistance and athletic program funding.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt018500
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/RelatedOrgSect527OrgInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0OH
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt022746
IRS990EZ/TotalProgramServiceExpensesAmt018500
IRS990EZ/TotalRevenueAmt04628
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/WebsiteAddressTxt0crablefoundation.org
IRS990ScheduleA/AmountsRcvdDsqlfyPersonGrp/TotalAmt00
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt021395
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt027997
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt060265
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt043533
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0153190
IRS990ScheduleA/GovtFurnSrvcFcltsVl509Grp/TotalAmt00
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt04628
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt03116
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt04742
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt04656
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt05504
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt022646
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt00
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/TotalAmt00
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt04628
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt03116
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt04742
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt04656
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt05504
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt022646
IRS990ScheduleA/InvestmentIncomeCYPct00.09700
IRS990ScheduleA/InvestmentIncomePYPct00.09410
IRS990ScheduleA/NetIncomeFromOtherUBIGrp/TotalAmt00
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearMinus1YearAmt016548
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearMinus2YearsAmt021550
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearMinus3YearsAmt018066
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearMinus4YearsAmt01453
IRS990ScheduleA/OtherIncome509Grp/TotalAmt057617
IRS990ScheduleA/Post1975UBTIGrp/TotalAmt00
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.65620
IRS990ScheduleA/PublicSupportPY509Pct00.66240
IRS990ScheduleA/PublicSupportTotal509Amt0153190
IRS990ScheduleA/SubstantialContributorsAmtGrp/TotalAmt00
IRS990ScheduleA/TaxRevLeviedOrgnztnlBnft509Grp/TotalAmt00
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt021395
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt027997
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt060265
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt043533
IRS990ScheduleA/Total509Grp/TotalAmt0153190
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt04628
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt041059
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt054289
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt082987
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt050490
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0233453
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Dividend & Interest Inc $4628
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Scholarships $18500
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Banking Expense $146
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Filing fee $100
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Other Revenue.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Other Expenses.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Other Expenses.2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Other Expenses.3
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0Bill Crable
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Trustee
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-15
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0THE CRABLE FOUNDATION
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0CO BILL CRABLE
ReturnHeader/Filer/BusinessNameControlTxt0CRAB
ReturnHeader/Filer/EIN0205626590
ReturnHeader/Filer/USAddress/AddressLine1Txt0564 MIAMI TRACE COURT
ReturnHeader/Filer/USAddress/CityNm0LOVELAND
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OH
ReturnHeader/Filer/USAddress/ZIPCd045140
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0205435436
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0STEPHANIE M BAUER CPA INC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt013200 STATE ROAD 46
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0SUNMAN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd047041
ReturnHeader/PreparerPersonGrp/PhoneNum08129321399
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Stephanie M Bauer
ReturnHeader/ReturnTs02018-05-15T16:58:43-07:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2017 • Form 990EZDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$188,689
Liabilities
-
Net assets
$188,689
Revenue
$4,628
Expenses
$22,746
Net income
-$18,118
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2018Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.09$1.80$1.89
2017Detailed filing. Detailed filing data is available for this year.$1.89$1.89$0.05$0.23$0.18
2016Detailed filing. Detailed filing data is available for this year.$2.15$2.15$0.41$0.37$0.04
2015Detailed filing. Detailed filing data is available for this year.$1.87$1.87$0.54$0.54$0.00
2014Summary only. Only limited summary data is available for this year.$2.01$0.00$0.83$0.19$0.64
2013Summary only. Only limited summary data is available for this year.$1.35$0.00$1.35$0.50$0.74$0.24
2012Summary only. Only limited summary data is available for this year.$1.58$0.00$0.71$0.59$0.12
2011Summary only. Only limited summary data is available for this year.$1.46$0.00$0.33$0.45$0.12
2010Summary only. Only limited summary data is available for this year.$1.58$0.00$0.36$0.23$0.13