Civic Intelligence

Johnson County Trail Foundation

990EZ • Fiscal year 2016 • EIN 26-1667461

Jan 01, 2016 to Dec 31, 2016 • Filed on May 11, 2017

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 2016

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2016

Net Margin

5th percentile

-94%

Higher net margin than 5% of similar nonprofits.

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

Top Officer Pay

75th percentile

$0

Higher top officer pay than 75% of similar nonprofits.

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

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

Asset Growth

Score unavailable

No value available

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

Source year 2016

Revenue Growth

Score unavailable

No value available

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

Source year 2016

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Up

$37,153

Up $15,410 (+71%) from 2012

Net Assets

Up

$37,153

Up $15,410 (+71%) from 2012

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin5th percentile

Revenue

Up

$2,162

Up $774 (+56%) from 2012

Expenses

Up

$4,184

Up $2,752 (+192%) from 2012

Net Income

Down

-$2,022

Down $1,978 (-4495%) from 2012

Historical Trend

Balance Sheet Trend

Asset GrowthScore unavailable

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

2016

Assets$37,153
Liabilities-
Net Assets$37,153
Open 2016 Filing

Operations Trend

Revenue GrowthScore unavailable

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

2016

Revenue$2,162
Expenses$4,184
Net Income-$2,022
Open 2016 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2016 to Dec 31, 2016
Signed
May 11, 2017
Return Version
2016v3.0
Gross Receipts
$2,162
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 Pay75th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
THOMAS D BERGPres., Direct., Secr-$0--
WANDA K BERGVice Pres., Treas.DiPT$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
2017-05-11

Preparer

Firm
Hrb Tax Group Inc
Address
1620 SYCAMORE ST, IOWA CITY, IA 52240
Preparer
connie schnoebelen
Phone
3193541750
Supplemental Narrative

Additional Explanations

Line 16 Part I

“Tweed event expenses $448”

Line 16 Reimbursement to City of Iowa City

“METRO DATA STRAVA $2955”

Line 16 Part I

“DELUXE CHECK ACC FEE $25”

Raw XML Appendix116 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/BOYAmt039175
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt037153
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt02124
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-2022
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0160
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt039175
IRS990EZ/Form990TotalAssetsGrp/EOYAmt037153
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GrossReceiptsAmt02162
IRS990EZ/InvestmentIncomeAmt038
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt039175
IRS990EZ/NetAssetsOrFundBalancesEOYAmt037153
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt039175
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt037153
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt15.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/OtherExpensesTotalAmt03428
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0DEVELOPING TRAILS
IRS990EZ/PrintingPublicationsPostageAmt0596
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0MARKING AND PLACING DISTANCE SIGNS ON JOHNSON COUNTY TRAILS
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/RelatedOrgSect527OrgInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt04184
IRS990EZ/TotalRevenueAmt02162
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationOtherDesc0FOUNDATION
IRS990EZ/TypeOfOrganizationOtherInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt02124
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt0780
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt02904
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus1YearAmt037
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt037
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.98740
IRS990ScheduleA/PublicSupportCY509Pct01.00000
IRS990ScheduleA/PublicSupportPY509Pct01.00000
IRS990ScheduleA/PublicSupportTotal170Amt02904
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt02124
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt0780
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt02904
IRS990ScheduleA/TotalSupportAmt02941
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0TWEED EVENT EXPENSES $448
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1METRO DATA STRAVA $2955
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2DELUXE CHECK ACC FEE $25
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0LINE 16 PART I
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1LINE 16 REIMBURSEMENT TO CITY OF IOWA CITY
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2LINE 16 PART I
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/PersonNm0WANDA BERG
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0VICE PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum03193254848
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-05-11
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/FilingSecurityInformation/AtSubmissionCreationDeviceId0F8D1C37992997DA5B6FD568B94C13E51BF317C28
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0F8D1C37992997DA5B6FD568B94C13E51BF317C28
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt050.80.241.28
ReturnHeader/FilingSecurityInformation/IPDt02017-05-15
ReturnHeader/FilingSecurityInformation/IPTm015:10:03
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0HRB TAX GROUP INC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01620 SYCAMORE ST
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0IOWA CITY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd052240
ReturnHeader/PreparerPersonGrp/PhoneNum03193541750
ReturnHeader/PreparerPersonGrp/PreparationDt02017-05-12
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0connie schnoebelen
ReturnHeader/ReturnTs02017-05-12T16:20:05Z
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-01-01
ReturnHeader/TaxPeriodEndDt02016-12-31
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$37,153
Liabilities
-
Net assets
$37,153
Revenue
$2,162
Expenses
$4,184
Net income
-$2,022
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