Civic Intelligence

Cedar Hill Rotary Foundation

990EZ • Fiscal year 2017 • EIN 43-2082668

Jan 01, 2017 to Dec 31, 2017 • Filed on Oct 10, 2018

P O Box 1006Cedar Hill, TX 75106

(214) 649-2554

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

26th percentile

-8.0%

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

13th percentile

-36%

Faster asset growth than 13% of similar nonprofits.

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

Revenue Growth

27th percentile

-16%

Faster revenue growth than 27% of similar nonprofits.

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

Assets

Down

$7,273

Down $4,120 (-36%) from 2016

Net Assets

$7,273

No earlier filing loaded for comparison.

Liabilities

-

No earlier filing loaded for comparison.

Revenue

Down

$51,620

Down $9,479 (-16%) from 2016

Expenses

Down

$55,740

Down $3,327 (-5.6%) from 2016

Net Income

Down

-$4,120

Down $6,152 (-303%) from 2016

Historical Trend

Balance Sheet Trend

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

$30K$20K$10K$0Assets 2011: $22,625Liabilities 2011: $02011Assets 2012: $19,426Liabilities 2012: $02012Assets 2013: $20,388Liabilities 2013: $02013Assets 2014: $16,489Liabilities 2014: $02014Assets 2015: $9,361Liabilities 2015: $02015Assets 2016: $11,393Liabilities 2016: $02016Assets 2017: $7,273Net Assets 2017: $7,2732017Assets 2018: $7,973Net Assets 2018: $7,9732018Assets 2019: $2,102Net Assets 2019: $2,1022019Assets 2020: $10,414Net Assets 2020: $10,4142020Assets 2021: $6,222Net Assets 2021: $6,2222021Assets 2022: $11,252Net Assets 2022: $11,2522022Assets 2023: $6,183Net Assets 2023: $6,1832023Assets 2024: $13,346Net Assets 2024: $13,3462024Assets 2025: $11,588Net Assets 2025: $11,5882025

Highlighted filing

2017

Assets$7,273
Liabilities-
Net Assets$7,273

Operations Trend

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

$80K$60K$40K$20K$0-$20KRevenue 2011: $52,594Expenses 2011: $57,547Net Income 2011: -$4,9532011Revenue 2012: $57,563Expenses 2012: $60,762Net Income 2012: -$3,1992012Revenue 2013: $59,299Expenses 2013: $58,337Net Income 2013: $9622013Revenue 2014: $61,665Expenses 2014: $65,564Net Income 2014: -$3,8992014Revenue 2015: $51,445Expenses 2015: $58,573Net Income 2015: -$7,1282015Revenue 2016: $61,099Expenses 2016: $59,067Net Income 2016: $2,0322016Revenue 2017: $51,620Expenses 2017: $55,740Net Income 2017: -$4,1202017Revenue 2018: $55,621Expenses 2018: $54,921Net Income 2018: $7002018Revenue 2019: $6,810Expenses 2019: $12,681Net Income 2019: -$5,8712019Revenue 2020: $20,156Expenses 2020: $11,844Net Income 2020: $8,3122020Revenue 2021: $47,806Expenses 2021: $51,998Net Income 2021: -$4,1922021Revenue 2022: $67,511Expenses 2022: $62,481Net Income 2022: $5,0302022Revenue 2023: $55,316Expenses 2023: $60,385Net Income 2023: -$5,0692023Revenue 2024: $72,186Expenses 2024: $65,023Net Income 2024: $7,1632024Revenue 2025: $55,893Expenses 2025: $57,651Net Income 2025: -$1,7582025

Highlighted filing

2017

Revenue$51,620
Expenses$55,740
Net Income-$4,120
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Oct 10, 2018
Return Version
2017v2.2
Gross Receipts
$51,620
Mission and Program Overview

Mission

Provide Humanitarian Service

Program Services

DescriptionGrantsExpenses
Bike Rally - Annual Fundraiser to Provide Cash Flow to Support Various Local Charities$34,994-
Support Local Organizations for Families Suffering from Poverty and/or Violence.$17,828-
Interact Club - Provides Services for Youths Ages 14 - 18.$663-
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
Larry HornerPresident-$0--
Jon WillamsonDirector-$0--
Patricia BondsDirector-$0--
Glenn MajorsDirector-$0--
Filing and Contact Details

Filer

Filer Name
Cedar Hill Rotary Foundation
EIN
43-2082668
Phone
2146492554
Address
P O Box 1006, Cedar Hill, TX 75106

Signing Officer

Name
Larry Horner
Title
President
Signed
2018-10-10
Discuss with paid preparer
Yes

Preparer

Firm
Cymun Steve Horner CPA PC
Address
951 N Walnut Creek Dr Ste 105, Mansfield, TX 76063
Preparer
Cymun Steve Horner
Phone
8174533001
Supplemental Narrative

Additional Explanations

Grants and Similar Amounts Paid In Excess of $5,000.1

| Donee's Name: Coats For Kids | Cash Amount Given: $6218

Grants and Similar Amounts Paid In Excess of $5,000.2

| Donee's Name: Amounts less than $5,000 | Cash Amount Given: $12910

Other Expenses.1001

Advertising and Promotion $19687

Other Expenses.1002

Office Expenses $824

Other Expenses.1

Sanitation $3617

Other Expenses.2

Security $3530

Other Expenses.4

Equipment Rental $2672

Other Expenses.6

Bank Charges & Merchant Fees $750

Other Expenses.7

Interact Club Support $663

Other Expenses.8

Training $325

Other Expenses.9

Miscellaneous $30

Other Expenses.10

Permits $25

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/PersonNm0Larry Horner
IRS990EZ/BooksInCareOfDetail/PhoneNum02146492554
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0805 Cobblestone Ct
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Cedar Hill
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0TX
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd075104
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt011393
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt07273
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt026261
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-4120
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0600
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form720FiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt011393
IRS990EZ/Form990TotalAssetsGrp/EOYAmt07273
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GrantsAndSimilarAmountsPaidAmt019128
IRS990EZ/GrossReceiptsAmt051620
IRS990EZ/GrossReceiptsForPublicUseAmt00
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InitiationFeesAndCapContriAmt00
IRS990EZ/InvestmentIncomeAmt033
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt011393
IRS990EZ/NetAssetsOrFundBalancesEOYAmt07273
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt011393
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt07273
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt02.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt20.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt30.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0Larry Horner
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1Jon Willamson
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2Patricia Bonds
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3Glenn Majors
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0President
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Director
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationFiled990TInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt032123
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0Provide Humanitarian Service
IRS990EZ/PrintingPublicationsPostageAmt03889
IRS990EZ/ProgramServiceRevenueAmt025326
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0Bike Rally - Annual Fundraiser to Provide Cash Flow to Support Various Local Charities
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1Interact Club - Provides Services for Youths Ages 14 - 18.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt2Support Local Organizations for Families Suffering from Poverty and/or Violence.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt034994
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt1663
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt217828
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/RelatedOrgSect527OrgInd0false
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt055740
IRS990EZ/TotalProgramServiceExpensesAmt053485
IRS990EZ/TotalRevenueAmt051620
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/AmountsRcvdDsqlfyPersonGrp/TotalAmt00
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt026261
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt024800
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt025953
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt026732
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt025228
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0128974
IRS990ScheduleA/GovtFurnSrvcFcltsVl509Grp/TotalAmt00
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt033
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt042
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt041
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt055
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt068
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt0239
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt00
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/TotalAmt00
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt033
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt042
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt041
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt055
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt068
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt0239
IRS990ScheduleA/InvestmentIncomeCYPct00.00180
IRS990ScheduleA/InvestmentIncomePYPct00.00240
IRS990ScheduleA/NetIncomeFromOtherUBIGrp/TotalAmt00
IRS990ScheduleA/OtherIncome509Grp/TotalAmt00
IRS990ScheduleA/Post1975UBTIGrp/TotalAmt00
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.99820
IRS990ScheduleA/PublicSupportPY509Pct00.99760
IRS990ScheduleA/PublicSupportTotal509Amt0128974
IRS990ScheduleA/SubstantialContributorsAmtGrp/TotalAmt00
IRS990ScheduleA/TaxRevLeviedOrgnztnlBnft509Grp/TotalAmt00
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt026261
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt024800
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt025953
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt026732
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt025228
IRS990ScheduleA/Total509Grp/TotalAmt0128974
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt026294
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt024842
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt025994
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt026787
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt025296
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0129213
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0| Donee's Name: Coats For Kids | Cash Amount Given: $6218
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1| Donee's Name: Amounts less than $5,000 | Cash Amount Given: $12910
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Advertising and Promotion $19687
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Office Expenses $824
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4Sanitation $3617
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5Security $3530
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6Equipment Rental $2672
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7Bank Charges & Merchant Fees $750
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt8Interact Club Support $663
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt9Training $325
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt10Miscellaneous $30
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt11Permits $25
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Grants and Similar Amounts Paid In Excess of $5,000.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Grants and Similar Amounts Paid In Excess of $5,000.2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Other Expenses.1001
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Other Expenses.1002
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Other Expenses.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Other Expenses.2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6Other Expenses.4
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7Other Expenses.6
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc8Other Expenses.7
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc9Other Expenses.8
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc10Other Expenses.9
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc11Other Expenses.10
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0Larry Horner
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0President
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-10-10
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Cedar Hill Rotary Foundation
ReturnHeader/Filer/BusinessNameControlTxt0CEDA
ReturnHeader/Filer/EIN0432082668
ReturnHeader/Filer/PhoneNum02146492554
ReturnHeader/Filer/USAddress/AddressLine1Txt0P O Box 1006
ReturnHeader/Filer/USAddress/CityNm0Cedar Hill
ReturnHeader/Filer/USAddress/StateAbbreviationCd0TX
ReturnHeader/Filer/USAddress/ZIPCd075106
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0260047746
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Cymun Steve Horner CPA PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0951 N Walnut Creek Dr Ste 105
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Mansfield
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0TX
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd076063
ReturnHeader/PreparerPersonGrp/PhoneNum08174533001
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Cymun Steve Horner
ReturnHeader/ReturnTs02018-10-10T13:58:25-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

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$11.6$11.6$55.9$57.7$1.76
2024Detailed filing. Detailed filing data is available for this year.$13.3$13.3$72.2$65.0$7.16
2023Detailed filing. Detailed filing data is available for this year.$6.18$6.18$55.3$60.4$5.07
2022Detailed filing. Detailed filing data is available for this year.$11.3$11.3$67.5$62.5$5.03
2021Detailed filing. Detailed filing data is available for this year.$6.22$6.22$47.8$52.0$4.19
2020Detailed filing. Detailed filing data is available for this year.$10.4$10.4$20.2$11.8$8.31
2019Detailed filing. Detailed filing data is available for this year.$2.10$2.10$6.81$12.7$5.87
2018Detailed filing. Detailed filing data is available for this year.$7.97$7.97$55.6$54.9$0.70
2017Detailed filing. Detailed filing data is available for this year.$7.27$7.27$51.6$55.7$4.12
2016Summary only. Only limited summary data is available for this year.$11.4$0.00$61.1$59.1$2.03
2015Summary only. Only limited summary data is available for this year.$9.36$0.00$51.4$58.6$7.13
2014Summary only. Only limited summary data is available for this year.$16.5$0.00$61.7$65.6$3.90
2013Summary only. Only limited summary data is available for this year.$20.4$0.00$59.3$58.3$0.96
2012Summary only. Only limited summary data is available for this year.$19.4$0.00$57.6$60.8$3.20
2011Summary only. Only limited summary data is available for this year.$22.6$0.00$52.6$57.5$4.95