Civic Intelligence

Berthoud Local

990PF • Fiscal year 2017 • EIN 46-4791763

Jan 01, 2017 to Dec 31, 2017 • Filed on Mar 08, 2018

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

81st percentile

0.13x

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

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

Liabilities / Revenue

78th percentile

0.06x

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

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

Net Margin

57th percentile

6.0%

Higher net margin than 57% of similar nonprofits.

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

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2017

Asset Growth

83rd percentile

36%

Faster asset growth than 83% of similar nonprofits.

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

Revenue Growth

72nd percentile

18%

Faster revenue growth than 72% of similar nonprofits.

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

Assets

Up

$7,199

Up $1,902 (+36%) from 2016

Net Assets

Up

$6,261

Up $964 (+18%) from 2016

Liabilities

Up

$938

Up $938 from 2016

Revenue

Up

$16,153

Up $2,489 (+18%) from 2016

Expenses

Up

$15,189

Up $3,507 (+30%) from 2016

Net Income

Down

$964

Down $1,018 (-51%) from 2016

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

2017

Assets$7,199
Liabilities$938
Net Assets$6,261

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

2017

Revenue$16,153
Expenses$15,189
Net Income$964
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Mar 8, 2018
Return Version
2017v2.2
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
Signed
2018-03-08
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 Appendix182 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
AccountingFeesSchedule/AccountingFeesDetail/Amt059
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0Ten-Key Accounting LLC
IRS990PF/AnalysisIncomeProducingActyGrp/ProgramServiceRevPartVIIGrp/BusinessCd0110000
IRS990PF/AnalysisIncomeProducingActyGrp/ProgramServiceRevPartVIIGrp/BusinessCd1110000
IRS990PF/AnalysisIncomeProducingActyGrp/ProgramServiceRevPartVIIGrp/BusinessCd2110000
IRS990PF/AnalysisIncomeProducingActyGrp/ProgramServiceRevPartVIIGrp/Desc0Berthoud Local
IRS990PF/AnalysisIncomeProducingActyGrp/ProgramServiceRevPartVIIGrp/Desc1Farmers Market
IRS990PF/AnalysisIncomeProducingActyGrp/ProgramServiceRevPartVIIGrp/Desc2Membership/Misc
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt059
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt016153
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0964
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt09035
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt0101
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubRevAndExpnssAmt05833
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0114
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt015189
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt016153
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt015189
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingRevAndExpnssAmt047
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0964
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt06261
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt05297
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt06261
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/FMVAssetsEOYAmt07199
IRS990PF/Form990PFBalanceSheetsGrp/AccountsPayableEOYAmt0938
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt05297
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt06292
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt06292
IRS990PF/Form990PFBalanceSheetsGrp/InventoriesEOYAmt0907
IRS990PF/Form990PFBalanceSheetsGrp/InventoriesEOYFMVAmt0907
IRS990PF/Form990PFBalanceSheetsGrp/OrganizationFollowsSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt05297
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt07199
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt07199
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt0938
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt05297
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt07199
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt05297
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt06261
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedBOYAmt05297
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedEOYAmt06261
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/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePY1Yr02015
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0true
IRS990PF/StatementsRegardingActy4720Grp/UndistrIncmSect4942a2NotAppInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
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/Expenses1Amt05287
IRS990PF/SummaryOfDirectChrtblActyGrp/Expenses2Amt05833
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/PriorYear1Yr02013
IRS990PF/UndistributedIncomeGrp/PriorYear2Yr02014
IRS990PF/UndistributedIncomeGrp/PriorYear3Yr02015
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt0202
IRS990PF/UndistributedIncomeGrp/Taxable1Amt0202
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt0202
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990ScheduleB/Organization501c3ExemptPFInd0X
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0Cost of Goods
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc1Bank and CC Fees
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc2Event Expenses
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc3Insurance
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc4Misc Supplies
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc5Memberships Dues
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt0847
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt1355
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt25287
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt31546
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt4690
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt5310
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt0101
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0Other Fees Services
TaxesSchedule/TaxesDetail/Amt0114
TaxesSchedule/TaxesDetail/CategoryTxt0Sales Tax Collected and Paid
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0KRISTIN RAMEY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-03-08
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/AtSubmissionCreationDeviceId0DF0A4AA26D8EADF44730504072C04701AB885E91
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0DF0A4AA26D8EADF44730504072C04701AB885E91
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId08405552018065rauij3t
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02018-03-08
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt076.25.121.72
ReturnHeader/FilingSecurityInformation/IPDt02018-03-08
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0MS
ReturnHeader/FilingSecurityInformation/IPTm015:18:04
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/PreparationDt02018-03-08
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Teresa L Riemenschneider
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02018-03-08T10:19:22-00:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings