Civic Intelligence

Bertrand Farm Inc

990EZ • Fiscal year 2017 • EIN 20-8659533

Jan 01, 2017 to Dec 31, 2017 • Filed on May 14, 2018

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

93rd percentile

0.88x

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

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

Liabilities / Revenue

82nd percentile

0.10x

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

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

Net Margin

16th percentile

-19%

Higher net margin than 16% of similar nonprofits.

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

Top Officer Pay

81st percentile

$12,900

Higher top officer pay than 81% of similar nonprofits.

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

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

Asset Growth

7th percentile

-58%

Faster asset growth than 7% of similar nonprofits.

2017 filings • 501(c)3 • <$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

18th percentile

-27%

Faster revenue growth than 18% of similar nonprofits.

2017 filings • 501(c)3 • <$500k nonprofits • Annualized from 2016 to 2017

Balance Sheet
Liabilities / Assets93rd percentile

Assets

Down

$7,166

Down $9,868 (-58%) from 2016

Net Assets

Down

$857

Down $11,584 (-93%) from 2016

Liabilities

Up

$6,309

Up $1,716 (+37%) from 2016

Revenue And Expenses
Liabilities / Revenue82nd percentileNet Margin16th percentile

Revenue

Down

$60,872

Down $22,596 (-27%) from 2016

Expenses

Down

$72,456

Down $22,690 (-24%) from 2016

Net Income

Up

-$11,584

Up $94 (+0.8%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth7th 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

2017

Assets$7,166
Liabilities$6,309
Net Assets$857
Open 2017 Filing

Operations Trend

Revenue Growth18th 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

2017

Revenue$60,872
Expenses$72,456
Net Income-$11,584
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
May 14, 2018
Return Version
2017v2.2
Gross Receipts
$66,881
Mission and Program Overview

Mission

Sustainable Farm Practice Education

Program Services

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

Employees

NameTitleFull / Part TimeBaseOtherTotal
Therese NiemierExec DirectorFT$12,900-$12,900
Suzanne WilsonBoard Chair-$0--
Elizabeth ZapfTreasurer-$0--
Melanie LissSecretary-$0--
Jessica VelazquezDirector-$0--
John SchommerDirector-$0--
Margaret PfeilDirector-$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 M Zimmerman Niemier
Title
Executive Direc
Signed
2018-05-14
Discuss with paid preparer
Yes

Preparer

Firm
Michael G Horvath EA
Address
PO Box 5098, Mooresville, NC 28117
Preparer
Michael G Horvath EA
Phone
7046775620
Supplemental Narrative

Additional Explanations

Description of other expenses Part I line 16

“Description AmountDepreciation from 4562 3,299Business Registration Fees 66Materials 661Lunch Meeting 104Miscellaneous 526Bank Charges 37Repairs and Maintenance 90Program Refund 110Books and Subscriptions 1,011Gasoline 1,510Postage 7Supplies 18,952Payroll Taxes 1,702Staff Appreciation 374Staff Education 185”

Description of total liabilities Part II line 26

“Category Beginning of Year End of YearCurrent Liabilities 4,593 6,309”

Raw XML Appendix179 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/BOYAmt03288
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt02726
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt010380
IRS990EZ/CostOrOtherBasisExpenseSaleAmt06009
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-11584
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt05293
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt017034
IRS990EZ/Form990TotalAssetsGrp/EOYAmt07166
IRS990EZ/GainOrLossFromSaleOfAssetsAmt01991
IRS990EZ/GrossReceiptsAmt066881
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LandAndBuildingsGrp/BOYAmt013746
IRS990EZ/LandAndBuildingsGrp/EOYAmt04440
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt012441
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0857
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt012441
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0857
IRS990EZ/OccupancyRentUtltsAndMaintAmt013979
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt045.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10.75
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt20.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt30.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt40.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt50.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt60.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt012900
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/PersonNm4Jessica Velazquez
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5John Schommer
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6Margaret Pfeil
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0Exec Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Board Chair
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Treasurer
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Secretary
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6Director
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt00
IRS990EZ/OtherAssetsTotalDetail/EOYAmt00
IRS990EZ/OtherExpensesTotalAmt028634
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0Sustainable Farm Practice Education
IRS990EZ/PrintingPublicationsPostageAmt0443
IRS990EZ/ProgramServiceRevenueAmt048501
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0The corporation has been operated for the purpose of promoting and stimulating project based education for the purpose of promoting ethical farm practices and environmental issues
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt072456
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt024107
IRS990EZ/SaleOfAssetsGrossAmt08000
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0MI
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt04593
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt06309
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt072456
IRS990EZ/TotalProgramServiceExpensesAmt072456
IRS990EZ/TotalRevenueAmt060872
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.BERTRANDFARM.ORG
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt010380
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt020285
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt031565
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt066266
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0128496
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt048501
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt063183
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt064825
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt053008
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt015934
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt0245451
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/InvestmentIncomePYPct00.00000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct01.00000
IRS990ScheduleA/PublicSupportPY509Pct01.00000
IRS990ScheduleA/PublicSupportTotal509Amt0373947
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt058881
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt083468
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt096390
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt0119274
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt015934
IRS990ScheduleA/Total509Grp/TotalAmt0373947
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt058881
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt083468
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt096390
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt0119274
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt015934
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0373947
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Description AmountDepreciation from 4562 3,299Business Registration Fees 66Materials 661Lunch Meeting 104Miscellaneous 526Bank Charges 37Repairs and Maintenance 90Program Refund 110Books and Subscriptions 1,011Gasoline 1,510Postage 7Supplies 18,952Payroll Taxes 1,702Staff Appreciation 374Staff Education 185
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Category Beginning of Year End of YearCurrent Liabilities 4,593 6,309
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Description of other expenses Part I line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Description of total liabilities Part II line 26
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0THERESE M ZIMMERMAN NIEMIER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0EXECUTIVE DIREC
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-14
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/FilingSecurityInformation/AtSubmissionCreationDeviceId059D6EC41C1B8665FE370B67137FBA73593383EE8
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId059D6EC41C1B8665FE370B67137FBA73593383EE8
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId05631882018198wgpsveb
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02018-07-17
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt040.142.196.155
ReturnHeader/FilingSecurityInformation/IPDt02018-07-17
ReturnHeader/FilingSecurityInformation/IPTm018:17:33
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Michael G Horvath EA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0PO Box 5098
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Mooresville
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0NC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd028117
ReturnHeader/PreparerPersonGrp/PhoneNum07046775620
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Michael G Horvath EA
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02018-07-17T18:26:11-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$7,166
Liabilities
$6,309
Net assets
$857
Revenue
$60,872
Expenses
$72,456
Net income
-$11,584
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