Civic Intelligence

Sycamore Trails Resource Conserv- Ation and Development Council Inc

990EZ • Fiscal year 2018 • EIN 35-1712619

Jan 01, 2018 to Dec 31, 2018 • Filed on Oct 01, 2019

1239 E CO Rd 200 SGreencastle, IN 46135

(765) 721-0949

Siviq Scores

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

Liabilities / Assets

75th percentile

0.06x

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

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

Liabilities / Revenue

91st percentile

0.36x

Higher debt load relative to revenue than 91% of similar nonprofits.

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

Net Margin

17th percentile

-19%

Higher net margin than 17% of similar nonprofits.

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

Top Officer Pay

80th percentile

$8,744

Higher top officer pay than 80% of similar nonprofits.

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

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

Asset Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2018

Revenue Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2018

Assets

$199,032

No earlier filing loaded for comparison.

Net Assets

$186,241

No earlier filing loaded for comparison.

Liabilities

$12,791

No earlier filing loaded for comparison.

Revenue

$35,284

No earlier filing loaded for comparison.

Expenses

$41,879

No earlier filing loaded for comparison.

Net Income

-$6,595

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

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

$200K$150K$100K$50K$0Assets 2018: $199,032Liabilities 2018: $12,791Net Assets 2018: $186,2412018Assets 2019: $180,551Liabilities 2019: $12,132Net Assets 2019: $168,4192019Assets 2020: $174,475Liabilities 2020: $12,209Net Assets 2020: $162,2662020Assets 2021: $146,265Liabilities 2021: $11,411Net Assets 2021: $134,8542021Assets 2022: $131,497Liabilities 2022: $826Net Assets 2022: $130,6712022Assets 2023: $119,837Net Assets 2023: $119,8372023Assets 2024: $0Net Assets 2024: $02024

Highlighted filing

2018

Assets$199,032
Liabilities$12,791
Net Assets$186,241

Operations Trend

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

$50K$0-$50K-$100K-$150KRevenue 2018: $35,284Expenses 2018: $41,879Net Income 2018: -$6,5952018Revenue 2019: $23,022Expenses 2019: $40,844Net Income 2019: -$17,8222019Revenue 2020: $15,858Expenses 2020: $22,010Net Income 2020: -$6,1522020Revenue 2021: $13,993Expenses 2021: $41,405Net Income 2021: -$27,4122021Revenue 2022: $6,672Expenses 2022: $21,439Net Income 2022: -$14,7672022Revenue 2023: $6,940Expenses 2023: $12,079Net Income 2023: -$5,1392023Revenue 2024: -$111,667Expenses 2024: $8,170Net Income 2024: -$119,8372024

Highlighted filing

2018

Revenue$35,284
Expenses$41,879
Net Income-$6,595
Jump To
Filing Snapshot
Filing Period
Jan 1, 2018 to Dec 31, 2018
Signed
Oct 1, 2019
Return Version
2018v3.1
Gross Receipts
$35,284
Mission and Program Overview

Mission

To motivate, enable, assist, educate, and coordinate local citizens in the conservation and development of natural, human and economic resources.

Program Services

DescriptionGrantsExpenses
ABANDONED MINELAND RECLAMATION AND REMISSION OF TOXIC & EROSIVE EFFLUENTS. ALSO TO PROVIDE SUPPORT TO ENABLE STANDING COMMITIES AND ENSURE PROPER GROWTH AND LIFE.-$40,517
EDUCATION WORKSHOPS IN FORESTRY MANAGEMENT AND INVASIVE PLANT SPECIES.-$1,362
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
JESSICA A FERRANKey EmployeePT$8,744-$8,744
RON ELLISPresidentPT$0--
JAN CAMEVice Preside-$0--
RAOUL MOORESecretary-$0--
CHARLES BEARDDirector-$0--
DUANE KELLYDirector-$0--
Filing and Contact Details

Filer

Filer Name
Sycamore Trails Resource
EIN
35-1712619
Phone
7657210949
Address
1239 E CO RD 200 S, GREENCASTLE, IN 46135

Signing Officer

Name
Ron Ellis
Title
President
Phone
7657210949
Signed
2019-10-01
Discuss with paid preparer
Yes

Preparer

Firm
Hammer & Swigart Cpas Inc
Address
25 S VINE ST, GREENCASTLE, IN 46135-0412
Preparer
Mark N Hammer CPA
Phone
7656536941
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

Expenses advertising 257 office supplies 398 information technology 2,486 conferences & meetings 1,362 insurance 3,798 supplies 119 dues, fees, subscriptions 649 grant expenses 17,796 outside labor 1,194 total 28,059

Form 990-ez, Part I, Line 20

Rounding errors on previous tax returns 23 tree sale recorded in error on 2017 form 990ez 5a -27,667 2017 depreciation not reflected on 990ez, line 23 -347 overstated value of 2017 cash on 990 ez, line 22 -3,039

Form 990-ez, Part II, Line 26

Payroll taxes 482 766 clay expo 601 601 friends of shakamak 638 0 deer exclosure 415 415 tsi at froehde woods 4,500 4,500 big walnut creek watershed alliance 372 372 swcd education/outreach fund 1,594 1,594 releaf funds 4,213 4,543

Form 990-ez, Part III

To motivate, enable, assist, educate, and coordinate local citizens in the conservation and development of natural, human and economic resources.

Raw XML Appendix180 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/PersonNm0JESSICA A FERRAN
IRS990EZ/BooksInCareOfDetail/PhoneNum07657210949
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt01239 E CO RD 200 S
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0GREENCASTLE
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IN
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd046135
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt097742
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt063681
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt033578
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-6595
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt01017
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0236681
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0199032
IRS990EZ/GrossReceiptsAmt035284
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0695
IRS990EZ/LandAndBuildingsGrp/BOYAmt0138939
IRS990EZ/LandAndBuildingsGrp/EOYAmt0135351
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0223866
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0186241
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0223866
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0186241
IRS990EZ/OccupancyRentUtltsAndMaintAmt03241
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt08.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt116.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt22.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt34.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt41.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt51.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt18744
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0RON ELLIS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1JESSICA A FERRAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2JAN CAME
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3RAOUL MOORE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4CHARLES BEARD
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5DUANE KELLY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1KEY EMPLOYEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2VICE PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5DIRECTOR
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherChangesInNetAssetsAmt0-31030
IRS990EZ/OtherExpensesTotalAmt028059
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO MOTIVATE, ENABLE, ASSIST, EDUCATE, AND COORDINATE LOCAL CITIZENS IN THE CONSERVATION AND DEVELOPMENT OF NATURAL, HUMAN AND ECONOMIC RESOURCES.
IRS990EZ/PrintingPublicationsPostageAmt0149
IRS990EZ/ProgramServiceRevenueAmt01011
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0ABANDONED MINELAND RECLAMATION AND REMISSION OF TOXIC & EROSIVE EFFLUENTS. ALSO TO PROVIDE SUPPORT TO ENABLE STANDING COMMITIES AND ENSURE PROPER GROWTH AND LIFE.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1EDUCATION WORKSHOPS IN FORESTRY MANAGEMENT AND INVASIVE PLANT SPECIES.
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt040517
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt11362
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt09413
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0IN
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt012815
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt012791
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt041879
IRS990EZ/TotalProgramServiceExpensesAmt041879
IRS990EZ/TotalRevenueAmt035284
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt033578
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt037272
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt010865
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt012386
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt050450
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0144551
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt0695
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt0165
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt0570
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt0416
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt0654
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt02500
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt01011
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt03326
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt01355
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt01342
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt01734
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt08768
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt0695
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt0165
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt0570
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt0416
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt0654
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt02500
IRS990ScheduleA/InvestmentIncomeCYPct00.02000
IRS990ScheduleA/InvestmentIncomePYPct00.01000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.98400
IRS990ScheduleA/PublicSupportPY509Pct00.99310
IRS990ScheduleA/PublicSupportTotal509Amt0153319
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt034589
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt040598
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt012220
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt013728
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt052184
IRS990ScheduleA/Total509Grp/TotalAmt0153319
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt035284
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt040763
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt012790
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt014144
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt052838
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0155819
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES ADVERTISING 257 OFFICE SUPPLIES 398 INFORMATION TECHNOLOGY 2,486 CONFERENCES & MEETINGS 1,362 INSURANCE 3,798 SUPPLIES 119 DUES, FEES, SUBSCRIPTIONS 649 GRANT EXPENSES 17,796 OUTSIDE LABOR 1,194 TOTAL 28,059
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1ROUNDING ERRORS ON PREVIOUS TAX RETURNS 23 TREE SALE RECORDED IN ERROR ON 2017 FORM 990EZ 5A -27,667 2017 DEPRECIATION NOT REFLECTED ON 990EZ, LINE 23 -347 OVERSTATED VALUE OF 2017 CASH ON 990 EZ, LINE 22 -3,039
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2PAYROLL TAXES 482 766 CLAY EXPO 601 601 FRIENDS OF SHAKAMAK 638 0 DEER EXCLOSURE 415 415 TSI AT FROEHDE WOODS 4,500 4,500 BIG WALNUT CREEK WATERSHED ALLIANCE 372 372 SWCD EDUCATION/OUTREACH FUND 1,594 1,594 RELEAF FUNDS 4,213 4,543
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3TO MOTIVATE, ENABLE, ASSIST, EDUCATE, AND COORDINATE LOCAL CITIZENS IN THE CONSERVATION AND DEVELOPMENT OF NATURAL, HUMAN AND ECONOMIC RESOURCES.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 20
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART II, LINE 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART III
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0RON ELLIS
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum07657210949
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-10-01
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0SYCAMORE TRAILS RESOURCE
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0CONSERVATION & DEVELOPMENT COUNCIL
ReturnHeader/Filer/BusinessNameControlTxt0SYCA
ReturnHeader/Filer/EIN0351712619
ReturnHeader/Filer/PhoneNum07657210949
ReturnHeader/Filer/USAddress/AddressLine1Txt01239 E CO RD 200 S
ReturnHeader/Filer/USAddress/CityNm0GREENCASTLE
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IN
ReturnHeader/Filer/USAddress/ZIPCd046135
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId02B8C93D922C4DF1CD5B09BFE3ACBC95D8EFE7CC5
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0FA3463838DF3C9BECD8325E08ECB226E2301C8B5
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0167.68.16.49
ReturnHeader/FilingSecurityInformation/IPDt02019-10-03
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm007:06:42
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0832871184
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0HAMMER & SWIGART CPAS INC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt025 S VINE ST
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0GREENCASTLE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0461350412
ReturnHeader/PreparerPersonGrp/PhoneNum07656536941
ReturnHeader/PreparerPersonGrp/PreparationDt02019-09-30
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0MARK N HAMMER CPA
ReturnHeader/ReturnTs02019-10-03T07:06:42-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02018-01-01
ReturnHeader/TaxPeriodEndDt02018-12-31
ReturnHeader/TaxYr02018

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings