Civic Intelligence

Sycamore Trails Resource Conserv- Ation and Development Council Inc

990EZ • Fiscal year 2021 • EIN 35-1712619

Jan 01, 2021 to Dec 31, 2021 • Filed on Oct 17, 2022

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

76th percentile

0.08x

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

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

Liabilities / Revenue

93rd percentile

0.82x

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

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

Net Margin

5th percentile

-196%

Higher net margin than 5% of similar nonprofits.

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

Top Officer Pay

81st percentile

$8,744

Higher top officer pay than 81% of similar nonprofits.

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

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

Asset Growth

21st percentile

-16%

Faster asset growth than 21% of similar nonprofits.

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

Revenue Growth

37th percentile

-12%

Faster revenue growth than 37% of similar nonprofits.

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

Assets

Down

$146,265

Down $28,210 (-16%) from 2020

Net Assets

Down

$134,854

Down $27,412 (-17%) from 2020

Liabilities

Down

$11,411

Down $798 (-6.5%) from 2020

Revenue

Down

$13,993

Down $1,865 (-12%) from 2020

Expenses

Up

$41,405

Up $19,395 (+88%) from 2020

Net Income

Down

-$27,412

Down $21,260 (-346%) from 2020

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

2021

Assets$146,265
Liabilities$11,411
Net Assets$134,854

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

2021

Revenue$13,993
Expenses$41,405
Net Income-$27,412
Jump To
Filing Snapshot
Filing Period
Jan 1, 2021 to Dec 31, 2021
Signed
Oct 17, 2022
Return Version
2021v4.0
Gross Receipts
$13,993
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.-$41,290
EDUCATION WORKSHOPS IN FORESTRY MANAGEMENT AND INVASIVE PLANT SPECIES.-$115
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--
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
2022-10-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 862 information technology 404 conferences & meetings 115 insurance 2,271 miscellaneous expense 1,730 dues, fees, subscriptions 1,006 contract labor 856 licenses & permits 162 telecommunications 2,517 bank fees 84 grant expenses 17,015 total 27,022

Form 990-ez, Part II, Line 26

Accrued payroll taxes payable 844 826 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,103

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 Appendix171 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/BOYAmt045606
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt020637
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt011656
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-27412
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt01689
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0174475
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0146265
IRS990EZ/GrossReceiptsAmt013993
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt02
IRS990EZ/LandAndBuildingsGrp/BOYAmt0128869
IRS990EZ/LandAndBuildingsGrp/EOYAmt0125628
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0162266
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0134854
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0162266
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0134854
IRS990EZ/OccupancyRentUtltsAndMaintAmt03281
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/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/OtherExpensesTotalAmt027022
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/ProgramServiceRevenueAmt02335
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/ProgramServiceExpensesAmt041290
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt1115
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt09413
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0IN
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt012209
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt011411
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt041405
IRS990EZ/TotalProgramServiceExpensesAmt041405
IRS990EZ/TotalRevenueAmt013993
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt011656
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt012809
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt019179
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt033578
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt037272
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0114494
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt02
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt0110
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt0450
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt0695
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt0165
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt01422
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt02335
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt02939
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt03393
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt01011
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt03326
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt013004
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt02
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt0110
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt0450
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt0695
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt0165
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt01422
IRS990ScheduleA/InvestmentIncomeCYPct00.01000
IRS990ScheduleA/InvestmentIncomePYPct00.02000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.98900
IRS990ScheduleA/PublicSupportPY509Pct00.98440
IRS990ScheduleA/PublicSupportTotal509Amt0127498
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt013991
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt015748
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt022572
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt034589
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt040598
IRS990ScheduleA/Total509Grp/TotalAmt0127498
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt013993
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt015858
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt023022
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt035284
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt040763
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0128920
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES OFFICE SUPPLIES 862 INFORMATION TECHNOLOGY 404 CONFERENCES & MEETINGS 115 INSURANCE 2,271 MISCELLANEOUS EXPENSE 1,730 DUES, FEES, SUBSCRIPTIONS 1,006 CONTRACT LABOR 856 LICENSES & PERMITS 162 TELECOMMUNICATIONS 2,517 BANK FEES 84 GRANT EXPENSES 17,015 TOTAL 27,022
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1ACCRUED PAYROLL TAXES PAYABLE 844 826 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,103
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/SignatureDt02022-10-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/PreparationDt02022-10-17
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0MARK N HAMMER CPA
ReturnHeader/ReturnTs02022-10-17T16:42:17-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0RON
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0ELLIS
ReturnHeader/TaxPeriodBeginDt02021-01-01
ReturnHeader/TaxPeriodEndDt02021-12-31
ReturnHeader/TaxYr02021

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings