Civic Intelligence

Bertrand Farm Inc

990EZ • Fiscal year 2014 • EIN 20-8659533

Jan 01, 2014 to Dec 31, 2014 • Filed on May 09, 2015

Organization ProfileWWW.BERTRANDFARM.ORG
3575 W Bertrand RdNiles, MI 49120

(269) 695-3306

Siviq Scores

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

Liabilities / Assets

77th percentile

0.11x

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

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

Liabilities / Revenue

71st percentile

0.03x

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

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

Net Margin

26th percentile

-7.2%

Higher net margin than 26% of similar nonprofits.

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

Top Officer Pay

74th percentile

$0

Higher top officer pay than 74% of similar nonprofits.

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

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

Asset Growth

18th percentile

-23%

Faster asset growth than 18% of similar nonprofits.

2014 filings • 501(c)3 • <$500k nonprofits • Annualized from 2013 to 2014

Revenue Growth

23rd percentile

-19%

Faster revenue growth than 23% of similar nonprofits.

2014 filings • 501(c)3 • <$500k nonprofits • Annualized from 2013 to 2014

Balance Sheet
Liabilities / Assets77th percentile

Assets

Down

$29,408

Down $8,673 (-23%) from 2013

Net Assets

Down

$26,084

Down $8,698 (-25%) from 2013

Liabilities

Up

$3,324

Up $25 (+0.8%) from 2013

Revenue And Expenses
Liabilities / Revenue71st percentileNet Margin26th percentile

Revenue

Down

$120,172

Down $28,617 (-19%) from 2013

Expenses

Up

$128,870

Up $9,178 (+7.7%) from 2013

Net Income

Down

-$8,698

Down $37,795 (-130%) from 2013

Historical Trend

Balance Sheet Trend

Asset Growth18th percentile

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

$40K$30K$20K$10K$0Assets 2010: $6,300Liabilities 2010: $2,830Net Assets 2010: $3,4702010Assets 2011: $5,431Liabilities 2011: $4,759Net Assets 2011: $6722011Assets 2012: $9,838Liabilities 2012: $4,153Net Assets 2012: $5,6852012Assets 2013: $38,081Liabilities 2013: $3,299Net Assets 2013: $34,7822013Assets 2014: $29,408Liabilities 2014: $3,324Net Assets 2014: $26,0842014Assets 2015: $27,442Liabilities 2015: $3,323Net Assets 2015: $24,1192015Assets 2016: $17,034Liabilities 2016: $4,593Net Assets 2016: $12,4412016Assets 2017: $7,166Liabilities 2017: $6,309Net Assets 2017: $8572017Assets 2018: $0Liabilities 2018: $0Net Assets 2018: $02018

Highlighted filing

2014

Assets$29,408
Liabilities$3,324
Net Assets$26,084
Open 2014 Filing

Operations Trend

Revenue Growth23rd percentile

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

$150K$100K$50K$0-$50KRevenue 2010: $76,539Expenses 2010: $75,405Net Income 2010: $1,1342010Revenue 2011: $55,493Expenses 2011: $58,291Net Income 2011: -$2,7982011Revenue 2012: $82,040Expenses 2012: $74,398Net Income 2012: $7,6422012Revenue 2013: $148,789Expenses 2013: $119,692Net Income 2013: $29,0972013Revenue 2014: $120,172Expenses 2014: $128,870Net Income 2014: -$8,6982014Revenue 2015: $96,390Expenses 2015: $98,355Net Income 2015: -$1,9652015Revenue 2016: $83,468Expenses 2016: $95,146Net Income 2016: -$11,6782016Revenue 2017: $60,872Expenses 2017: $72,456Net Income 2017: -$11,5842017Revenue 2018: $6,182Expenses 2018: $7,039Net Income 2018: -$8572018

Highlighted filing

2014

Revenue$120,172
Expenses$128,870
Net Income-$8,698
Open 2014 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2014 to Dec 31, 2014
Signed
May 9, 2015
Return Version
2014v5.0
Gross Receipts
$120,322
Mission and Program Overview

Mission

Sustainable Farm Practice Education

Program Services

DescriptionGrantsExpenses
The corporation has been operated for the purpose of promting and stimulating project based education for the purpose of promoting ethical farm practices and environmental issues--
Compensation and Service Providers
Top Officer Pay74th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
Therese NiemierExec DirectorFT$0--
Suzanne WilsonBoard ChairPT$0--
Elizabeth ZapfTreasurer-$0--
Melanie LissDirector-$0--
Michael HebbelerDirector-$0--
Nicole LambeletDirector-$0--
Jessica HellmannDirector-$0--
Filing and Contact Details

Filer

Filer Name
Bertrand Farm Inc
EIN
20-8659533
Address
3575 W BERTRAND RD, Niles, MI 49120

Signing Officer

Name
Therese Zimmerman Niemier
Title
Executive Direc
Signed
2015-05-09
Discuss with paid preparer
No

Preparer

Firm
Michael G Horvath Ea
Address
Post Office Box 5098, Mooresville, NC 28117
Preparer
Michael G Horvath
Phone
7046775620
Supplemental Narrative

Additional Explanations

Description of other expenses Part I line 16

“Description AmountDepreciation from 4562 9,334Registration Fees 348Bank Charges 1Material 4,980Repairs and Maintenance 4,697Gasoline 628Books and Subscriptions 1,105Supplies 23,913Refund 525Payroll Taxes 3,286Meeting 105Education and Training 1,388Contract Labor 24,773Miscellaneous 15”

Description of total liabilities Part II line 26

“Category Beginning of Year End of YearCurrent Liabilities 3,299 3,324”

Raw XML Appendix169 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
CompensationExplanation/CompensationExplanationGrp/PersonNm0Therese Niemier
CompensationExplanation/CompensationExplanationGrp/ShortExplanationTxt0STRAIGHT SALARY
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/PersonNm0BERTRAND FARM INC
IRS990EZ/BooksInCareOfDetail/PhoneNum02696953306
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt03575 W BERTRAND ROD
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Niles
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MI
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd049120
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt03374
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt04035
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt066266
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-8698
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt010349
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt038081
IRS990EZ/Form990TotalAssetsGrp/EOYAmt029408
IRS990EZ/FundraisingGrossIncomeAmt01048
IRS990EZ/GrossReceiptsAmt0120322
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LandAndBuildingsGrp/BOYAmt034707
IRS990EZ/LandAndBuildingsGrp/EOYAmt025373
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt034782
IRS990EZ/NetAssetsOrFundBalancesEOYAmt026084
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt034782
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt026084
IRS990EZ/OccupancyRentUtltsAndMaintAmt025400
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt060.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt110.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt22.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt32.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt42.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt52.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt62.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0Therese Niemier
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1Suzanne Wilson
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2Elizabeth Zapf
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3Melanie Liss
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4Michael Hebbeler
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5Nicole Lambelet
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6Jessica Hellmann
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0Exec Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Board Chair
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Treasurer
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6Director
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt00
IRS990EZ/OtherAssetsTotalDetail/EOYAmt00
IRS990EZ/OtherExpensesTotalAmt075098
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0Sustainable Farm Practice Education
IRS990EZ/PrintingPublicationsPostageAmt01823
IRS990EZ/ProgramServiceRevenueAmt053008
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0The corporation has been operated for the purpose of promting and stimulating project based education for the purpose of promoting ethical farm practices and environmental issues
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt016200
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt0150
IRS990EZ/SpecialEventsNetIncomeLossAmt0898
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0MI
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt03299
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt03324
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0128870
IRS990EZ/TotalProgramServiceExpensesAmt00
IRS990EZ/TotalRevenueAmt0120172
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.BERTRANDFARM.ORG
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt066266
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt040874
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt07310
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt05456
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt0727
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0120633
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt053008
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt015934
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt074730
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt051018
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt080146
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt0274836
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct01.00000
IRS990ScheduleA/PublicSupportPY509Pct01.00000
IRS990ScheduleA/PublicSupportTotal509Amt0395469
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt0119274
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt056808
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt082040
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt056474
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt080873
IRS990ScheduleA/Total509Grp/TotalAmt0395469
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt0119274
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt056808
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt082040
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt056474
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt080873
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0395469
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Description AmountDepreciation from 4562 9,334Registration Fees 348Bank Charges 1Material 4,980Repairs and Maintenance 4,697Gasoline 628Books and Subscriptions 1,105Supplies 23,913Refund 525Payroll Taxes 3,286Meeting 105Education and Training 1,388Contract Labor 24,773Miscellaneous 15
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Category Beginning of Year End of YearCurrent Liabilities 3,299 3,324
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Description of other expenses Part I line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Description of total liabilities Part II line 26
ReturnHeader/BuildTS02016-02-25 16:41:14Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0false
ReturnHeader/BusinessOfficerGrp/PersonNm0THERESE ZIMMERMAN NIEMIER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0EXECUTIVE DIREC
ReturnHeader/BusinessOfficerGrp/SignatureDt02015-05-09
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0BERTRAND FARM INC
ReturnHeader/Filer/BusinessNameControlTxt0BERT
ReturnHeader/Filer/EIN0208659533
ReturnHeader/Filer/USAddress/AddressLine1Txt03575 W BERTRAND RD
ReturnHeader/Filer/USAddress/CityNm0Niles
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd049120
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0MICHAEL G HORVATH EA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0Post Office Box 5098
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Mooresville
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0NC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd028117
ReturnHeader/PreparerPersonGrp/PhoneNum07046775620
ReturnHeader/PreparerPersonGrp/PreparationDt02015-05-14
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Michael G Horvath
ReturnHeader/ReturnTs02015-05-14T18:19:16-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02014-01-01
ReturnHeader/TaxPeriodEndDt02014-12-31
ReturnHeader/TaxYr02014

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$29,408
Liabilities
$3,324
Net assets
$26,084
Revenue
$120,172
Expenses
$128,870
Net income
-$8,698
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2018Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.06$0.07$0.01
2017Detailed filing. Detailed filing data is available for this year.$0.07$0.06$0.01$0.61$0.72$0.12
2016Detailed filing. Detailed filing data is available for this year.$0.17$0.05$0.12$0.83$0.95$0.12
2015Detailed filing. Detailed filing data is available for this year.$0.27$0.03$0.24$0.96$0.98$0.02
2014Detailed filing. Detailed filing data is available for this year.$0.29$0.03$0.26$1.20$1.29$0.09
2013Detailed filing. Detailed filing data is available for this year.$0.38$0.03$0.35$1.49$1.20$0.29
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.10$0.04$0.06$0.82$0.74$0.08
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.05$0.05$0.01$0.55$0.58$0.03
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.06$0.03$0.03$0.77$0.75$0.01