Civic Intelligence

Johnson County Trail Foundation

990EZ • Fiscal year 2020 • EIN 26-1667461

Jan 01, 2020 to Dec 31, 2020 • Filed on Jun 23, 2021

Organization ProfileN/A
1701 Quincent StIowa City, IA 52245

(319) 325-4848

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 2020

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2020

Net Margin

2nd percentile

-779%

Higher net margin than 2% of similar nonprofits.

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

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.

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

Asset Growth

2nd percentile

-100%

Faster asset growth than 2% of similar nonprofits.

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

Revenue Growth

6th percentile

-88%

Faster revenue growth than 6% of similar nonprofits.

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

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Down

$0

Down $32,881 (-100%) from 2019

Net Assets

Down

$30,201

Down $2,680 (-8.2%) from 2019

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin2nd percentile

Revenue

Down

$344

Down $2,477 (-88%) from 2019

Expenses

Down

$3,024

Down $124 (-3.9%) from 2019

Net Income

Down

-$2,680

Down $2,353 (-720%) from 2019

Historical Trend

Balance Sheet Trend

Asset Growth2nd percentile

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

$40K$30K$20K$10K$0Assets 2012: $21,743Net Assets 2012: $21,7432012Assets 2016: $37,153Net Assets 2016: $37,1532016Assets 2019: $32,881Net Assets 2019: $32,8812019Assets 2020: $0Net Assets 2020: $30,2012020Assets 2021: $29,739Net Assets 2021: $29,7392021Assets 2022: $29,463Net Assets 2022: $29,4632022Assets 2023: $0Net Assets 2023: $28,8612023Assets 2024: $29,646Net Assets 2024: $29,6462024

Highlighted filing

2020

Assets$0
Liabilities-
Net Assets$30,201
Open 2020 Filing

Operations Trend

Revenue Growth6th percentile

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

$6.0K$4.0K$2.0K$0-$2.0K-$4.0KRevenue 2012: $1,388Expenses 2012: $1,432Net Income 2012: -$442012Revenue 2016: $2,162Expenses 2016: $4,184Net Income 2016: -$2,0222016Revenue 2019: $2,821Expenses 2019: $3,148Net Income 2019: -$3272019Revenue 2020: $344Expenses 2020: $3,024Net Income 2020: -$2,6802020Revenue 2021: $1,858Expenses 2021: $2,320Net Income 2021: -$4622021Revenue 2022: $1,204Expenses 2022: $1,480Net Income 2022: -$2762022Revenue 2023: $1,229Expenses 2023: $1,831Net Income 2023: -$6022023Revenue 2024: $1,179Expenses 2024: $393Net Income 2024: $7862024

Highlighted filing

2020

Revenue$344
Expenses$3,024
Net Income-$2,680
Open 2020 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2020 to Dec 31, 2020
Signed
Jun 23, 2021
Return Version
2020v4.1
Gross Receipts
$344
Mission and Program Overview

Mission

DEVELOPING TRAILS

Program Services

DescriptionGrantsExpenses
MARKING AND PLACING DISTANCE SIGNS ON JOHNSON COUNTY TRAILS--
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
THOMAS D BERGPres., Direct., Secr-$0--
WANDA K BERGVice Pres., Treas.Di-$0--
Filing and Contact Details

Filer

Filer Name
Johnson County Trail Foundation
EIN
26-1667461
Phone
3193254848
Address
1701 QUINCENT ST, Iowa City, IA 52245

Signing Officer

Name
Wanda Berg
Title
Vice President
Phone
3193254848
Signed
2021-06-23
Discuss with paid preparer
No

Preparer

Firm
Hrb Tax Group Inc
Address
1630 SYCAMORE ST, IOWA CITY, IA 52240
Preparer
Connie Schnoebelen
Phone
3193541750
Supplemental Narrative

Additional Explanations

Part 1 Line 16

“2000 LAPTOP”

Part 1 Line 16

“318 QUICKBOOKS”

Part 1 Line 16

“73 OFFICE SUPPLIES”

Part 1 Line 16

“231 tweed fabric joann fabric”

Part 1 Line 16

“250 donation to bike library”

Raw XML Appendix124 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/PersonNm0WANDA K BERG
IRS990EZ/BooksInCareOfDetail/PhoneNum03193254848
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt01701 QUINCENT ST
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Iowa City
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IA
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd052245
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt032881
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt0314
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-2680
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0152
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt032881
IRS990EZ/Form990TotalAssetsGrp/EOYAmt00
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GrossReceiptsAmt0344
IRS990EZ/InvestmentIncomeAmt030
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt032881
IRS990EZ/NetAssetsOrFundBalancesEOYAmt030201
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt032881
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0THOMAS D BERG
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1WANDA K BERG
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRES., DIRECT., SECR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1VICE PRES., TREAS.DI
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt02872
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0DEVELOPING TRAILS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0MARKING AND PLACING DISTANCE SIGNS ON JOHNSON COUNTY TRAILS
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt03024
IRS990EZ/TotalRevenueAmt0344
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationOtherDesc0FOUNDATION
IRS990EZ/TypeOfOrganizationOtherInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt0313
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt02788
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt01855
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt02570
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt02124
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt09650
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearAmt030
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus1YearAmt033
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt034
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus3YearsAmt036
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus4YearsAmt038
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt0171
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.98260
IRS990ScheduleA/PublicSupportCY509Pct01.00000
IRS990ScheduleA/PublicSupportPY509Pct01.00000
IRS990ScheduleA/PublicSupportTotal170Amt09650
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt0313
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt02788
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt01855
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt02570
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt02124
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt09650
IRS990ScheduleA/TotalSupportAmt09821
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt02000 LAPTOP
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1318 QUICKBOOKS
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt273 OFFICE SUPPLIES
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3231 TWEED FABRIC JOANN FABRIC
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4250 DONATION TO BIKE LIBRARY
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0PART 1 LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1PART 1 LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2PART 1 LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3PART 1 LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4PART 1 LINE 16
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0false
ReturnHeader/BusinessOfficerGrp/PersonNm0WANDA BERG
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0VICE PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum03193254848
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-06-23
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0JOHNSON COUNTY TRAIL FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0TRAI
ReturnHeader/Filer/EIN0261667461
ReturnHeader/Filer/PhoneNum03193254848
ReturnHeader/Filer/USAddress/AddressLine1Txt01701 QUINCENT ST
ReturnHeader/Filer/USAddress/CityNm0Iowa City
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IA
ReturnHeader/Filer/USAddress/ZIPCd052245
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0431871840
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0HRB TAX GROUP INC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01630 SYCAMORE ST
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0IOWA CITY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd052240
ReturnHeader/PreparerPersonGrp/PhoneNum03193541750
ReturnHeader/PreparerPersonGrp/PreparationDt02021-06-25
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Connie Schnoebelen
ReturnHeader/ReturnTs02021-06-25T18:08:13Z
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0WANDA
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0BERG
ReturnHeader/TaxPeriodBeginDt02020-01-01
ReturnHeader/TaxPeriodEndDt02020-12-31
ReturnHeader/TaxYr02020

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2020 • Form 990EZDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$0
Liabilities
-
Net assets
$30,201
Revenue
$344
Expenses
$3,024
Net income
-$2,680
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$29.6$29.6$1.18$0.39$0.79
2023Detailed filing. Detailed filing data is available for this year.$0.00$28.9$1.23$1.83$0.60
2022Detailed filing. Detailed filing data is available for this year.$29.5$29.5$1.20$1.48$0.28
2021Detailed filing. Detailed filing data is available for this year.$29.7$29.7$1.86$2.32$0.46
2020Detailed filing. Detailed filing data is available for this year.$0.00$30.2$0.34$3.02$2.68
2019Detailed filing. Detailed filing data is available for this year.$32.9$32.9$2.82$3.15$0.33
2016Detailed filing. Detailed filing data is available for this year.$37.2$37.2$2.16$4.18$2.02
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$21.7$21.7$1.39$1.43$0.04