Civic Intelligence

Sycamore Trails Resource Conserv- Ation and Development Council Inc

990EZ • Fiscal year 2020 • EIN 35-1712619

Jan 01, 2020 to Dec 31, 2020 • Filed on Sep 17, 2021

1239 East County Road 200 SouthGreencastle, IN 46135

(765) 721-0949

Siviq Scores

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

Liabilities / Assets

72nd percentile

0.07x

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

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

Liabilities / Revenue

93rd percentile

0.77x

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

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

Net Margin

15th percentile

-39%

Higher net margin than 15% of similar nonprofits.

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

Top Officer Pay

80th percentile

$9,081

Higher top officer pay than 80% of similar nonprofits.

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

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

Asset Growth

36th percentile

-3.4%

Faster asset growth than 36% of similar nonprofits.

2020 filings • 501(c)3 • <$500k nonprofits • Annualized from 2019 to 2020

Revenue Growth

35th percentile

-31%

Faster revenue growth than 35% of similar nonprofits.

2020 filings • 501(c)3 • <$500k nonprofits • Annualized from 2019 to 2020

Assets

Down

$174,475

Down $6,076 (-3.4%) from 2019

Net Assets

Down

$162,266

Down $6,153 (-3.7%) from 2019

Liabilities

Up

$12,209

Up $77 (+0.6%) from 2019

Revenue

Down

$15,858

Down $7,164 (-31%) from 2019

Expenses

Down

$22,010

Down $18,834 (-46%) from 2019

Net Income

Up

-$6,152

Up $11,670 (+65%) from 2019

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

2020

Assets$174,475
Liabilities$12,209
Net Assets$162,266

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

2020

Revenue$15,858
Expenses$22,010
Net Income-$6,152
Jump To
Filing Snapshot
Filing Period
Jan 1, 2020 to Dec 31, 2020
Signed
Sep 17, 2021
Return Version
2020v4.0
Gross Receipts
$15,858
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.-$20,985
EDUCATION WORKSHOPS IN FORESTRY MANAGEMENT AND INVASIVE PLANT SPECIES.-$300
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
JESSICA A FERRANKey EmployeePT$9,081-$9,081
RON ELLISPresidentPT$0--
JAN CAMEVice Preside-$0--
RAOUL MOORESecretary-$0--
PERRY SEITZINGERDirector-$0--
DUANE KELLYDirector-$0--
Filing and Contact Details

Filer

Filer Name
Sycamore Trails Resource
EIN
35-1712619
Phone
7657210949
Address
1239 EAST COUNTY ROAD 200 SOUTH, GREENCASTLE, IN 46135

Signing Officer

Name
Ron Ellis
Title
President
Phone
7657210949
Signed
2021-09-17
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 office supplies 502 conferences & meetings 300 conference travel & meals 725 insurance 1,933 dues, fees, subscriptions 845 contract labor 856 licenses & permits 88 telecommunications 2,442 total 7,691

Form 990-ez, Part II, Line 26

Accrued payroll taxes payable 767 844 clay expo 601 601 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 3,883 3,883

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 Appendix177 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
CompensationExplanation/CompensationExplanationGrp/PersonNm0RON ELLIS
CompensationExplanation/CompensationExplanationGrp/PersonNm1JESSICA A FERRAN
CompensationExplanation/CompensationExplanationGrp/PersonNm2JAN CAME
CompensationExplanation/CompensationExplanationGrp/PersonNm3RAOUL MOORE
CompensationExplanation/CompensationExplanationGrp/PersonNm4PERRY SEITZINGER
CompensationExplanation/CompensationExplanationGrp/PersonNm5DUANE KELLY
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/BOYAmt048440
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt045606
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt012809
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-6152
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt01302
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0180550
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0174475
IRS990EZ/GrossReceiptsAmt015858
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0110
IRS990EZ/LandAndBuildingsGrp/BOYAmt0132110
IRS990EZ/LandAndBuildingsGrp/EOYAmt0128869
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0168418
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0162266
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0168418
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0162266
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/CompensationAmt19081
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/PersonNm4PERRY SEITZINGER
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/OtherExpensesTotalAmt07691
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/ProgramServiceRevenueAmt02939
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/ProgramServiceExpensesAmt020985
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt1300
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt09776
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0IN
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt012132
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt012209
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt022010
IRS990EZ/TotalProgramServiceExpensesAmt021285
IRS990EZ/TotalRevenueAmt015858
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt012809
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt019179
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt033578
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt037272
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt010865
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0113703
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt0110
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt0450
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt0695
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt0165
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt0570
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt01990
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt02939
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt03393
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt01011
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt03326
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt01355
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt012024
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt0110
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt0450
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt0695
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt0165
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt0570
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt01990
IRS990ScheduleA/InvestmentIncomeCYPct00.02000
IRS990ScheduleA/InvestmentIncomePYPct00.02000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.98440
IRS990ScheduleA/PublicSupportPY509Pct00.98180
IRS990ScheduleA/PublicSupportTotal509Amt0125727
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt015748
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt022572
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt034589
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt040598
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt012220
IRS990ScheduleA/Total509Grp/TotalAmt0125727
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt015858
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt023022
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt035284
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt040763
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt012790
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0127717
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES OFFICE SUPPLIES 502 CONFERENCES & MEETINGS 300 CONFERENCE TRAVEL & MEALS 725 INSURANCE 1,933 DUES, FEES, SUBSCRIPTIONS 845 CONTRACT LABOR 856 LICENSES & PERMITS 88 TELECOMMUNICATIONS 2,442 TOTAL 7,691
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1ACCRUED PAYROLL TAXES PAYABLE 767 844 CLAY EXPO 601 601 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 3,883 3,883
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2TO 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 II, LINE 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART III
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0RON ELLIS
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum07657210949
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-09-17
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 EAST COUNTY ROAD 200 SOUTH
ReturnHeader/Filer/USAddress/CityNm0GREENCASTLE
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IN
ReturnHeader/Filer/USAddress/ZIPCd046135
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/PreparationDt02021-09-17
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0MARK N HAMMER CPA
ReturnHeader/ReturnTs02021-09-17T13:06:29-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0RON
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0ELLIS
ReturnHeader/TaxPeriodBeginDt02020-01-01
ReturnHeader/TaxPeriodEndDt02020-12-31
ReturnHeader/TaxYr02020

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings