Civic Intelligence

Berthoud Local

990PF • Fiscal year 2018 • EIN 46-4791763

Jan 01, 2018 to Dec 31, 2018 • Filed on Nov 21, 2019

PO Box 1331Berthoud, CO 80513

(970) 515-5801

Siviq Scores

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

Liabilities / Assets

79th percentile

0.08x

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

2018 filings • <$500k nonprofits • Source year 2018

Liabilities / Revenue

75th percentile

0.03x

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

2018 filings • <$500k nonprofits • Source year 2018

Net Margin

28th percentile

-8.2%

Higher net margin than 28% of similar nonprofits.

2018 filings • <$500k nonprofits • Source year 2018

Top Officer Pay

77th percentile

$0

Higher top officer pay than 77% of similar nonprofits.

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

2018 filings • <$500k nonprofits • Source year 2018

Asset Growth

17th percentile

-23%

Faster asset growth than 17% of similar nonprofits.

2018 filings • <$500k nonprofits • Annualized from 2017 to 2018

Revenue Growth

31st percentile

-12%

Faster revenue growth than 31% of similar nonprofits.

2018 filings • <$500k nonprofits • Annualized from 2017 to 2018

Assets

Down

$5,545

Down $1,654 (-23%) from 2017

Net Assets

Down

$5,099

Down $1,162 (-19%) from 2017

Liabilities

Down

$446

Down $492 (-52%) from 2017

Revenue

Down

$14,235

Down $1,918 (-12%) from 2017

Expenses

Up

$15,397

Up $208 (+1.4%) from 2017

Net Income

Down

-$1,162

Down $2,126 (-221%) from 2017

Historical Trend

Balance Sheet Trend

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

$30K$20K$10K$0Assets 2014: $3,143Liabilities 2014: $513Net Assets 2014: $2,6302014Assets 2015: $3,315Liabilities 2015: $0Net Assets 2015: $3,3152015Assets 2016: $5,297Liabilities 2016: $0Net Assets 2016: $5,2972016Assets 2017: $7,199Liabilities 2017: $938Net Assets 2017: $6,2612017Assets 2018: $5,545Liabilities 2018: $446Net Assets 2018: $5,0992018Assets 2019: $10,705Liabilities 2019: $1,256Net Assets 2019: $9,4492019Assets 2020: $10,164Liabilities 2020: $759Net Assets 2020: $9,4052020Assets 2021: $17,547Liabilities 2021: $1,065Net Assets 2021: $16,4822021Assets 2022: $25,455Liabilities 2022: $202Net Assets 2022: $25,2532022Assets 2023: $20,520Liabilities 2023: $204Net Assets 2023: $20,3162023Assets 2024: $12,658Liabilities 2024: $0Net Assets 2024: $12,6582024

Highlighted filing

2018

Assets$5,545
Liabilities$446
Net Assets$5,099

Operations Trend

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

$40K$20K$0-$20KRevenue 2014: $6,230Expenses 2014: $3,600Net Income 2014: $2,6302014Revenue 2015: $8,755Expenses 2015: $8,553Net Income 2015: $2022015Revenue 2016: $13,664Expenses 2016: $11,682Net Income 2016: $1,9822016Revenue 2017: $16,153Expenses 2017: $15,189Net Income 2017: $9642017Revenue 2018: $14,235Expenses 2018: $15,397Net Income 2018: -$1,1622018Revenue 2019: $15,447Expenses 2019: $11,097Net Income 2019: $4,3502019Revenue 2020: $8,483Expenses 2020: $8,527Net Income 2020: -$442020Revenue 2021: $11,335Expenses 2021: $4,258Net Income 2021: $7,0772021Revenue 2022: $15,313Expenses 2022: $6,542Net Income 2022: $8,7712022Revenue 2023: $1,024Expenses 2023: $5,961Net Income 2023: -$4,9372023Revenue 2024: $26,421Expenses 2024: $33,240Net Income 2024: -$6,8192024

Highlighted filing

2018

Revenue$14,235
Expenses$15,397
Net Income-$1,162
Jump To
Filing Snapshot
Filing Period
Jan 1, 2018 to Dec 31, 2018
Signed
Nov 21, 2019
Return Version
2018v3.1
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
VICKIE MCLANEPresidentPT$0--
KRISTIN RAMEYTreasurerPT$0--
Filing and Contact Details

Filer

Filer Name
Berthoud Local
EIN
46-4791763
Phone
9705155801
Address
PO BOX 1331, Berthoud, CO 80513

Signing Officer

Name
Kristin Ramey
Title
Treasurer
Phone
9702326667
Signed
2019-11-21
Discuss with paid preparer
Yes

Preparer

Firm
Ten-Key Accounting Inc
Address
9103 W 19 ST RD, Greeley, CO 80634
Preparer
Teresa L Riemenschneider
Phone
9705155801
Raw XML Appendix178 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
IRS990PF/AnalysisIncomeProducingActyGrp/MembershipDuesAndAssmntGrp/UnrelatedBusinessTaxblIncmAmt05963
IRS990PF/AnalysisIncomeProducingActyGrp/ProgramServiceRevPartVIIGrp/BusinessCd0110000
IRS990PF/AnalysisIncomeProducingActyGrp/ProgramServiceRevPartVIIGrp/Desc0Berthoud Local
IRS990PF/AnalysisIncomeProducingActyGrp/ProgramServiceRevPartVIIGrp/UnrelatedBusinessTaxblIncmAmt08272
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt014235
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt014235
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt05963
IRS990PF/AnalysisOfRevenueAndExpenses/CostOfGoodsSoldAmt08806
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-1162
IRS990PF/AnalysisOfRevenueAndExpenses/GrossProfitRevAndExpnssAmt08272
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesLessRetAndAllwncAmt017078
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsRevAndExpnssAmt04425
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt010403
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubRevAndExpnssAmt0204
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0365
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt015397
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt014235
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt015397
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-1162
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt05099
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt06261
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt05099
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/FMVAssetsEOYAmt05545
IRS990PF/Form990PFBalanceSheetsGrp/AccountsPayableBOYAmt0938
IRS990PF/Form990PFBalanceSheetsGrp/AccountsPayableEOYAmt0446
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt06292
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt04638
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt04638
IRS990PF/Form990PFBalanceSheetsGrp/InventoriesBOYAmt0907
IRS990PF/Form990PFBalanceSheetsGrp/InventoriesEOYAmt0907
IRS990PF/Form990PFBalanceSheetsGrp/InventoriesEOYFMVAmt0907
IRS990PF/Form990PFBalanceSheetsGrp/OrganizationFollowsSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt07199
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt05545
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt05545
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt0938
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt0446
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt07199
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt05545
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt06261
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt05099
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedBOYAmt06261
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedEOYAmt05099
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt0005.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt1010.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0VICKIE MCLANE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1KRISTIN RAMEY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0PRESIDENT
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1TREASURER
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0PO BOX 1331
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt1PO BOX 1331
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0BERTHOUD
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1BERTHOUD
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0CO
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1CO
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd080513
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd180513
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt00
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/SubjToTaxRmnrtnExPrchtPymtInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistrIncmSect4942a2NotAppInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0true
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0CO
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0false
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SummaryOfDirectChrtblActyGrp/Description1Txt0Berthoud Local
IRS990PF/SummaryOfDirectChrtblActyGrp/Description2Txt0Farmer's Market
IRS990PF/SummaryOfDirectChrtblActyGrp/Expenses1Amt00
IRS990PF/SummaryOfDirectChrtblActyGrp/Expenses2Amt00
IRS990PF/SumOfProgramRelatedInvstGrp/Description1Txt0NONE
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990ScheduleB/Organization501c3ExemptPFInd0X
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0Business Fees Dues
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc1Bank and CC Fees
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc2Gardening Supplies
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc3Insurance
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc4Misc Supplies
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc5Marketing
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt0421
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt1450
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt21205
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt31796
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt482
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt56449
SalesOfInventoryList/InventorySaleGrp/CategoryTxt0PROGRAM INCOME
SalesOfInventoryList/InventorySaleGrp/CostOfGoodsSoldAmt08806
SalesOfInventoryList/InventorySaleGrp/GrossSalesAmt017078
SalesOfInventoryList/InventorySaleGrp/NetAmt08272
TaxesSchedule/TaxesDetail/Amt0365
TaxesSchedule/TaxesDetail/CategoryTxt0Payroll Taxes
ReturnHeader/BuildTS02020-03-31 21:24:44Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0KRISTIN RAMEY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum09702326667
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-11-21
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Berthoud Local
ReturnHeader/Filer/BusinessNameControlTxt0BERT
ReturnHeader/Filer/EIN0464791763
ReturnHeader/Filer/PhoneNum09705155801
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 1331
ReturnHeader/Filer/USAddress/CityNm0Berthoud
ReturnHeader/Filer/USAddress/StateAbbreviationCd0CO
ReturnHeader/Filer/USAddress/ZIPCd080513
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId02F79348089C8066247A35E3D86EC480589DF7899
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId02F79348089C8066247A35E3D86EC480589DF7899
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt071.205.37.106
ReturnHeader/FilingSecurityInformation/IPDt02019-11-21
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0MS
ReturnHeader/FilingSecurityInformation/IPTm020:09:14
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Ten-Key Accounting Inc
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt09103 W 19 ST RD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Greeley
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0CO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd080634
ReturnHeader/PreparerPersonGrp/PhoneNum09705155801
ReturnHeader/PreparerPersonGrp/PreparationDt02019-11-21
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Teresa L Riemenschneider
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02019-11-21T02:50:43-00:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02018-01-01
ReturnHeader/TaxPeriodEndDt02018-12-31
ReturnHeader/TaxYr02018

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings