Civic Intelligence

Yellow Ribbon Foundation of Cincinnati

990EZ • Fiscal year 2016 • EIN 45-3610096

Aug 01, 2015 to Jul 31, 2016 • Filed on Dec 15, 2016

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 2016

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2016

Net Margin

69th percentile

14%

Higher net margin than 69% of similar nonprofits.

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

Top Officer Pay

75th percentile

$0

Higher top officer pay than 75% of similar nonprofits.

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

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

Asset Growth

67th percentile

14%

Faster asset growth than 67% of similar nonprofits.

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

Revenue Growth

31st percentile

-12%

Faster revenue growth than 31% of similar nonprofits.

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

Assets

Up

$84,642

Up $10,613 (+14%) from 2015

Net Assets

Up

$84,642

Up $10,613 (+14%) from 2015

Liabilities

-

No earlier filing loaded for comparison.

Revenue

Down

$78,049

Down $11,055 (-12%) from 2015

Expenses

Down

$67,436

Down $24,176 (-26%) from 2015

Net Income

Up

$10,613

Up $13,121 (+523%) from 2015

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

2016

Assets$84,642
Liabilities-
Net Assets$84,642

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

2016

Revenue$78,049
Expenses$67,436
Net Income$10,613
Jump To
Filing Snapshot
Filing Period
Aug 1, 2015 to Jul 31, 2016
Signed
Dec 15, 2016
Return Version
2015v2.1
Gross Receipts
$104,861
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 their families.

Program Services

DescriptionGrantsExpenses
PROVISION OF CARE PACKAGES TO MILITARY PERSONNEL AND THEIR FAMILIES$5,882$5,882
AWARDS OF POST-SECONDARY EDUCATION SCHOLARSHIPS$1,000$1,000
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
Annual Fallen Hero Dinner$44,713$44,713$2,670$42,043
Total Events$44,713$44,713$26,477$18,236
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
2016-12-15
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 1614.

Form 990EZ, Part I, Line 16

Information technology 6776.

Form 990EZ, Part I, Line 16

TRAVEL 24.

Form 990EZ, Part I, Line 16

ACCESSORIES 10.

Form 990EZ, Part I, Line 16

Bank service charges 197.

Form 990EZ, Part I, Line 16

Unknown disbursements by prior board 18175.

Form 990EZ, Part I, Line 16

SCHOLARSHIPS 1000.

Raw XML Appendix183 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/BOYAmt074029
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt084642
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt060148
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt010613
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt010700
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt074029
IRS990EZ/Form990TotalAssetsGrp/EOYAmt084642
IRS990EZ/FundraisingGrossIncomeAmt044713
IRS990EZ/GainOrLossFromSaleOfAssetsAmt00
IRS990EZ/GamingGrossIncomeAmt00
IRS990EZ/GrossProfitLossSlsOfInvntryAmt00
IRS990EZ/GrossReceiptsAmt0104861
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InfoInScheduleOPartVInd0X
IRS990EZ/InvestmentIncomeAmt00
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt00
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt074029
IRS990EZ/NetAssetsOrFundBalancesEOYAmt084642
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt074029
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt084642
IRS990EZ/OccupancyRentUtltsAndMaintAmt012833
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/OtherExpensesTotalAmt027796
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 THEIR FAMILIES.
IRS990EZ/PrintingPublicationsPostageAmt016107
IRS990EZ/ProgramServiceRevenueAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0AWARDS OF POST-SECONDARY EDUCATION SCHOLARSHIPS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1PROVISION OF CARE PACKAGES TO MILITARY PERSONNEL AND THEIR FAMILIES
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt01000
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt15882
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt01000
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt15882
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/RelatedOrgSect527OrgInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt026812
IRS990EZ/SpecialEventsNetIncomeLossAmt017901
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt067436
IRS990EZ/TotalProgramServiceExpensesAmt06882
IRS990EZ/TotalRevenueAmt078049
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.YELLOWRIBBONSUPPORTCENTER.COM
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt0104861
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt0128500
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt0201577
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt0179619
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt0147718
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt0762275
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus1YearAmt052
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt04
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus3YearsAmt04
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus4YearsAmt08
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt068
IRS990ScheduleA/InvestmentIncomeCYPct00
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.99990
IRS990ScheduleA/PublicSupportCY509Pct00
IRS990ScheduleA/PublicSupportTotal170Amt0762275
IRS990ScheduleA/PublicSupportTotal509Amt00
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt0104861
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt0128500
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt0201577
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt0179619
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt0147718
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt0762275
IRS990ScheduleA/TotalSupportAmt0762343
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt026477
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0ANNUAL FALLEN HERO DINNER
IRS990ScheduleG/FundraisingEventInformationGrp/FoodAndBeverageEvent1Amt023807
IRS990ScheduleG/FundraisingEventInformationGrp/FoodAndBeverageTotalEventsAmt023807
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt044713
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt044713
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt044713
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt044713
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt018236
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt02670
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt02670
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 1614.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2INFORMATION TECHNOLOGY 6776.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3TRAVEL 24.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4ACCESSORIES 10.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5BANK SERVICE CHARGES 197.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6UNKNOWN DISBURSEMENTS BY PRIOR BOARD 18175.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7SCHOLARSHIPS 1000.
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 I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7Form 990EZ, Part I, Line 16
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0KEITH MAUPIN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0KEITH MAUPIN PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum05134030210
ReturnHeader/BusinessOfficerGrp/SignatureDt02016-12-15
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/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/PreparationDt02016-12-15
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0MICHAEL JWILHELM
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02016-12-15T11:27:02-08:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02015-08-01
ReturnHeader/TaxPeriodEndDt02016-07-31
ReturnHeader/TaxYr02015

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings