Civic Intelligence

Yellow Ribbon Foundation of Cincinnati

990EZ • Fiscal year 2017 • EIN 45-3610096

Aug 01, 2016 to Jul 31, 2017 • Filed on Dec 01, 2017

PO Box 7Batavia, OH 45103

(513) 403-0210

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

46th percentile

1.5%

Higher net margin than 46% 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

49th percentile

1.6%

Faster asset growth than 49% of similar nonprofits.

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

Revenue Growth

69th percentile

16%

Faster revenue growth than 69% of similar nonprofits.

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

Assets

Up

$86,032

Up $1,390 (+1.6%) from 2016

Net Assets

Up

$86,032

Up $1,390 (+1.6%) from 2016

Liabilities

-

No earlier filing loaded for comparison.

Revenue

Up

$90,445

Up $12,396 (+16%) from 2016

Expenses

Up

$89,055

Up $21,619 (+32%) from 2016

Net Income

Down

$1,390

Down $9,223 (-87%) from 2016

Historical Trend

Balance Sheet Trend

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

$200K$150K$100K$50K$0Assets 2012: $37,395Liabilities 2012: $02012Assets 2013: $82,090Liabilities 2013: $02013Assets 2014: $76,186Liabilities 2014: $02014Assets 2015: $74,029Net Assets 2015: $74,0292015Assets 2016: $84,642Net Assets 2016: $84,6422016Assets 2017: $86,032Net Assets 2017: $86,0322017Assets 2018: $123,311Liabilities 2018: $3,625Net Assets 2018: $119,6862018Assets 2019: $131,971Liabilities 2019: $0Net Assets 2019: $131,9712019Assets 2020: $147,142Liabilities 2020: $1,875Net Assets 2020: $145,2672020Assets 2021: $138,874Net Assets 2021: $138,8742021Assets 2022: $133,156Liabilities 2022: $1,000Net Assets 2022: $132,1562022Assets 2023: $137,074Net Assets 2023: $137,0742023Assets 2024: $154,022Liabilities 2024: $1,600Net Assets 2024: $152,4222024

Highlighted filing

2017

Assets$86,032
Liabilities-
Net Assets$86,032

Operations Trend

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

$150K$100K$50K$0-$50KRevenue 2012: $108,233Expenses 2012: $70,838Net Income 2012: $37,3952012Revenue 2013: $97,975Expenses 2013: $54,280Net Income 2013: $43,6952013Revenue 2014: $109,712Expenses 2014: $115,616Net Income 2014: -$5,9042014Revenue 2015: $89,104Expenses 2015: $91,612Net Income 2015: -$2,5082015Revenue 2016: $78,049Expenses 2016: $67,436Net Income 2016: $10,6132016Revenue 2017: $90,445Expenses 2017: $89,055Net Income 2017: $1,3902017Revenue 2018: $93,307Expenses 2018: $59,653Net Income 2018: $33,6542018Revenue 2019: $84,789Expenses 2019: $72,504Net Income 2019: $12,2852019Revenue 2020: $85,145Expenses 2020: $71,849Net Income 2020: $13,2962020Revenue 2021: $64,873Expenses 2021: $71,266Net Income 2021: -$6,3932021Revenue 2022: $82,626Expenses 2022: $89,344Net Income 2022: -$6,7182022Revenue 2023: $93,537Expenses 2023: $88,619Net Income 2023: $4,9182023Revenue 2024: $93,275Expenses 2024: $77,927Net Income 2024: $15,3482024

Highlighted filing

2017

Revenue$90,445
Expenses$89,055
Net Income$1,390
Jump To
Filing Snapshot
Filing Period
Aug 1, 2016 to Jul 31, 2017
Signed
Dec 1, 2017
Return Version
2016v3.0
Gross Receipts
$120,800
Mission and Program Overview

Mission

Support military personnel serving in harms way and remembering those who did not walk off the plane and to their families

Support military personnel serving in harms way and remembering those who did not walk off the plane and to their families.

Program Services

DescriptionGrantsExpenses
AWARDS OF POST-SECONDARY EDUCATION SCHOLARSHIPS$46,750$46,750
PROVISION OF CARE PACKAGES TO MILITARY PERSONNEL AND THEIR FAMILIES--
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
KEITH MAUPINPresidentFT$0--
JUNE BAILEYDirectorPT$0--
TODD MAYDirectorPT$0--
STEPHEN CLAYBOURNDirectorPT$0--
HOPE CONTRALLDirectorPT$0--
MELLANIE GILLIAMDirectorPT$0--
MICHAEL J WILHELMDirectorPT$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Fallen Hero Dinner$49,500$49,500-$49,500
Total Events$49,500$49,500$30,355$19,145
Filing and Contact Details

Filer

Filer Name
Yellow Ribbon Support Foundation
EIN
45-3610096
Phone
5134030210
Address
PO BOX 7, BATAVIA, OH 45103

Signing Officer

Name
Keith Maupin
Title
Keith Maupin President
Phone
5134030210
Signed
2017-12-01
Discuss with paid preparer
Yes

Preparer

Firm
Michael J Wilhelm & Associates
Address
4440 Lake Forest DrSuite 116, Cincinnati, OH 45242
Preparer
Michael Jwilhelm
Phone
5137338300
Supplemental Narrative

Additional Explanations

Pt V, Line 35B

Taxpayer had less than $1,000 in non business income for year and is not required to file form 990-t

Form 990EZ, Part I, Line 16

OFFICE EXPENSE 4129.

Form 990EZ, Part I, Line 16

TRAVEL 35.

Form 990EZ, Part I, Line 16

FILING FEE 189.

Form 990EZ, Part I, Line 16

SCHOLARSHIPS 46750.

Form 990EZ, Part II, Line 24

PREPAID POSTAGE 378.

Raw XML Appendix182 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/PersonNm0KEITH MAUPIN
IRS990EZ/BooksInCareOfDetail/PhoneNum05134030210
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 7
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0BATAVIA
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd045103
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt084642
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt085654
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt071300
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt01390
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt084642
IRS990EZ/Form990TotalAssetsGrp/EOYAmt086032
IRS990EZ/FundraisingGrossIncomeAmt049500
IRS990EZ/GainOrLossFromSaleOfAssetsAmt00
IRS990EZ/GamingGrossIncomeAmt00
IRS990EZ/GrossProfitLossSlsOfInvntryAmt00
IRS990EZ/GrossReceiptsAmt0120800
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InfoInScheduleOPartVInd0X
IRS990EZ/InvestmentIncomeAmt00
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt00
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt084642
IRS990EZ/NetAssetsOrFundBalancesEOYAmt086032
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt084642
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt086032
IRS990EZ/OccupancyRentUtltsAndMaintAmt010456
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt040.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt15.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt210.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt35.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt410.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt510.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt65.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0KEITH MAUPIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1JUNE BAILEY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2TODD MAY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3STEPHEN CLAYBOURN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4HOPE CONTRALL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5MELLANIE GILLIAM
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6MICHAEL J WILHELM
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6DIRECTOR
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationFiled990TInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/EOYAmt0378
IRS990EZ/OtherExpensesTotalAmt051103
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0SUPPORT MILITARY PERSONNEL SERVING IN HARMS WAY AND REMEMBERING THOSE WHO DID NOT WALK OFF THE PLANE AND TO THEIR FAMILIES.
IRS990EZ/PrintingPublicationsPostageAmt027496
IRS990EZ/ProgramServiceRevenueAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0AWARDS OF POST-SECONDARY EDUCATION SCHOLARSHIPS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1PROVISION OF CARE PACKAGES TO MILITARY PERSONNEL AND THEIR FAMILIES
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt046750
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt046750
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/RelatedOrgSect527OrgInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt030355
IRS990EZ/SpecialEventsNetIncomeLossAmt019145
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt089055
IRS990EZ/TotalProgramServiceExpensesAmt046750
IRS990EZ/TotalRevenueAmt090445
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.YELLOWRIBBONSUPPORTCENTER.COM
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt0120780
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt0104861
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt0128500
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt0201577
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt0179619
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt0735337
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt052
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus3YearsAmt04
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus4YearsAmt04
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt060
IRS990ScheduleA/InvestmentIncomeCYPct00
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.99990
IRS990ScheduleA/PublicSupportCY509Pct00
IRS990ScheduleA/PublicSupportPY170Pct00.99990
IRS990ScheduleA/PublicSupportTotal170Amt0735337
IRS990ScheduleA/PublicSupportTotal509Amt00
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt0120780
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt0104861
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt0128500
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt0201577
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt0179619
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt0735337
IRS990ScheduleA/TotalSupportAmt0735397
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt030355
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0FALLEN HERO DINNER
IRS990ScheduleG/FundraisingEventInformationGrp/FoodAndBeverageEvent1Amt030355
IRS990ScheduleG/FundraisingEventInformationGrp/FoodAndBeverageTotalEventsAmt030355
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt049500
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt049500
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt049500
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt049500
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt019145
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0TAXPAYER HAD LESS THAN $1,000 IN NON BUSINESS INCOME FOR YEAR AND IS NOT REQUIRED TO FILE FORM 990-T
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1OFFICE EXPENSE 4129.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2TRAVEL 35.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3FILING FEE 189.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4SCHOLARSHIPS 46750.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5PREPAID POSTAGE 378.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Pt V, Line 35b
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Form 990EZ, Part II, Line 24
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0KEITH MAUPIN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0KEITH MAUPIN PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum05134030210
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-12-01
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0YELLOW RIBBON SUPPORT FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0YELL
ReturnHeader/Filer/EIN0453610096
ReturnHeader/Filer/PhoneNum05134030210
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 7
ReturnHeader/Filer/USAddress/CityNm0BATAVIA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OH
ReturnHeader/Filer/USAddress/ZIPCd045103
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId05C8B053449016066BA4E46510379D70D57321D3E
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId05C8B053449016066BA4E46510379D70D57321D3E
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt050.5.165.17
ReturnHeader/FilingSecurityInformation/IPDt02017-12-01
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0PS
ReturnHeader/FilingSecurityInformation/IPTm008:08:59
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Michael J Wilhelm & Associates
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt04440 Lake Forest DrSuite 116
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Cincinnati
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0OH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd045242
ReturnHeader/PreparerPersonGrp/PhoneNum05137338300
ReturnHeader/PreparerPersonGrp/PreparationDt02017-12-01
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0MICHAEL JWILHELM
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02017-12-01T08:09:26-08:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-08-01
ReturnHeader/TaxPeriodEndDt02017-07-31
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings