Civic Intelligence

Bertrand Farm Inc

990EZ • Fiscal year 2012 • EIN 20-8659533

Jan 01, 2012 to Dec 31, 2012 • Filed on Mar 10, 2013

Organization ProfileWWW.BERTRANDFARM.ORG
3575 W Bertrand Rd49120
Siviq Scores

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

Liabilities / Assets

87th percentile

0.42x

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

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

Liabilities / Revenue

76th percentile

0.05x

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

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

Net Margin

64th percentile

9.3%

Higher net margin than 64% of similar nonprofits.

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

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2012

Asset Growth

90th percentile

81%

Faster asset growth than 90% of similar nonprofits.

2012 filings • 501(c)3 • <$500k nonprofits • Annualized from 2011 to 2012

Revenue Growth

85th percentile

48%

Faster revenue growth than 85% of similar nonprofits.

2012 filings • 501(c)3 • <$500k nonprofits • Annualized from 2011 to 2012

Balance Sheet
Liabilities / Assets87th percentile

Assets

Up

$9,838

Up $4,407 (+81%) from 2011

Net Assets

Up

$5,685

Up $5,013 (+746%) from 2011

Liabilities

Down

$4,153

Down $606 (-13%) from 2011

Revenue And Expenses
Liabilities / Revenue76th percentileNet Margin64th percentile

Revenue

Up

$82,040

Up $26,547 (+48%) from 2011

Expenses

Up

$74,398

Up $16,107 (+28%) from 2011

Net Income

Up

$7,642

Up $10,440 (+373%) from 2011

Historical Trend

Balance Sheet Trend

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

2012

Assets$9,838
Liabilities$4,153
Net Assets$5,685
Open 2012 Filing

Operations Trend

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

2012

Revenue$82,040
Expenses$74,398
Net Income$7,642
Open 2012 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2012 to Dec 31, 2012
Signed
Mar 10, 2013
Return Version
2012v2.1
Mission and Program Overview

Mission

Sustainable Farm Practice Education

Filing and Contact Details

Filer

EIN
20-8659533
Raw XML Appendix185 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/Compensation/Explanation0STRAIGHT SALARY
CompensationExplanation/Compensation/PersonName0Therese Niemier
IRS990EZ/ActivitiesNotPreviouslyRpt0false
IRS990EZ/CashSavingsAndInvestments/BOY0504
IRS990EZ/CashSavingsAndInvestments/EOY017
IRS990EZ/ContributionsGiftsGrantsEtc07310
IRS990EZ/DidOrgFileForm1120POLThisYear0false
IRS990EZ/DoesOrgHaveHospital0false
IRS990EZ/EngagedInExcessBenefitTrans0false
IRS990EZ/EngagePoliticalCmpgnActivities0false
IRS990EZ/ExcessOrDeficitForYear07642
IRS990EZ/FeesAndOthPymtToIndContractors03481
IRS990EZ/FiledScheduleA0true
IRS990EZ/ForeignFinancialAccount0false
IRS990EZ/ForeignOffice0false
IRS990EZ/GrossReceipts082040
IRS990EZ/InfoInScheduleOPartI0X
IRS990EZ/InfoInScheduleOPartII0X
IRS990EZ/LandAndBuildings/BOY02298
IRS990EZ/LandAndBuildings/EOY09821
IRS990EZ/MadeChangesToOrgnzngEtcDoc0false
IRS990EZ/MadeLoansToFromOfficers0false
IRS990EZ/MaintainAnyDonorAdvisedFunds0false
IRS990EZ/MethodOfAccountingCash0X
IRS990EZ/NetAssetsOrFundBalances/BOY0-1957
IRS990EZ/NetAssetsOrFundBalancesBOY0-1957
IRS990EZ/NetAssetsOrFundBalances/EOY05685
IRS990EZ/NetAssetsOrFundBalancesEOY05685
IRS990EZ/OccupancyRentUtilitiesAndMaint05544
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition062.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition110.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition22.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition32.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition42.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition51.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition61.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition71.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition81.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation016000
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation10
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation20
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation30
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation40
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation50
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation60
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation70
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation80
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc10
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc20
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc30
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc40
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc50
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc60
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc70
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc80
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances10
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances20
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances30
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances40
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances50
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances60
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances70
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances80
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName0Therese Niemier
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName1Suzanne Wilson
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName2Jean Pawlak
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName3Nancy Majerek
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName4Jan Markel
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName5Daniel P Castillo
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName6Michael Hebbeler
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName7Matthew R Kaczmarek
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName8Margaret Pfeil
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title0Exec Director
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title1Board Chair
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title2Treasurer
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title3Treasurer
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title4Director
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title5Director
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title6Director
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title7Director
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title8Director
IRS990EZ/OperatingSchool0false
IRS990EZ/Organization501c30X
IRS990EZ/OrganizationDissolvedEtc0false
IRS990EZ/OrganizationHadUBI0false
IRS990EZ/OtherAssetsTotal/BOY00
IRS990EZ/OtherAssetsTotal/EOY00
IRS990EZ/OtherExpensesTotal036729
IRS990EZ/PartVIAHghstPaidCntrctProfSer0NONE
IRS990EZ/PartVIOfCompOfHighestPaidEmpl0NONE
IRS990EZ/PrimaryExemptPurpose0Sustainable Farm Practice Education
IRS990EZ/ProgramServiceAccomplishment/DescriptionProgramServiceAccom0The 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/ProgramServiceRevenue074730
IRS990EZ/ProhibitedTaxShelterTrans0false
IRS990EZ/RelatedOrgControlledEntity0false
IRS990EZ/SalariesOtherCompEmplBenefits028644
IRS990EZ/SubjectToProxyTax0false
IRS990EZ/SumOfTotalLiabilities/BOY04759
IRS990EZ/SumOfTotalLiabilities/EOY04153
IRS990EZ/TanningServicesProvided0false
IRS990EZ/TheBooksAreInCareOf/AddressUS/AddressLine103575 W BERTRAMD RD
IRS990EZ/TheBooksAreInCareOf/AddressUS/City0Niles
IRS990EZ/TheBooksAreInCareOf/AddressUS/State0MI
IRS990EZ/TheBooksAreInCareOf/AddressUS/ZIPCode049120
IRS990EZ/TheBooksAreInCareOf/NamePerson0THERI NIEMIER
IRS990EZ/TheBooksAreInCareOf/TelephoneNumber02696953306
IRS990EZ/TotalAssets/BOY02802
IRS990EZ/TotalAssets/EOY09838
IRS990EZ/TotalExpenses074398
IRS990EZ/TotalProgramServiceExpenses00
IRS990EZ/TotalRevenue082040
IRS990EZ/TransactionWithControlEntity0false
IRS990EZ/WebSite0WWWBERTRANDFARMORG
IRS990ScheduleA/GiftsGrantsContribReceived509/CurrentTaxYear07310
IRS990ScheduleA/GiftsGrantsContribReceived509/CurrentTaxYearMinus1Year05456
IRS990ScheduleA/GiftsGrantsContribReceived509/CurrentTaxYearMinus2Years0727
IRS990ScheduleA/GiftsGrantsContribReceived509/CurrentTaxYearMinus3Years07535
IRS990ScheduleA/GiftsGrantsContribReceived509/CurrentTaxYearMinus4Years03300
IRS990ScheduleA/GiftsGrantsContribReceived509/Total024328
IRS990ScheduleA/GrossReceiptsFromAdmissions/CurrentTaxYear074730
IRS990ScheduleA/GrossReceiptsFromAdmissions/CurrentTaxYearMinus1Year051018
IRS990ScheduleA/GrossReceiptsFromAdmissions/CurrentTaxYearMinus2Years080146
IRS990ScheduleA/GrossReceiptsFromAdmissions/CurrentTaxYearMinus3Years062077
IRS990ScheduleA/GrossReceiptsFromAdmissions/CurrentTaxYearMinus4Years055924
IRS990ScheduleA/GrossReceiptsFromAdmissions/Total0323895
IRS990ScheduleA/InvestmentIncomePercentage00.00000
IRS990ScheduleA/PriorYearSupportPercentage01.00000
IRS990ScheduleA/PubliclySupportedOrg509a20X
IRS990ScheduleA/PublicSupportPercentage50901.00000
IRS990ScheduleA/PublicSupportTotal5090348223
IRS990ScheduleA/ThirtyThreePercntTestsCY5090X
IRS990ScheduleA/Total509/CurrentTaxYear082040
IRS990ScheduleA/Total509/CurrentTaxYearMinus1Year056474
IRS990ScheduleA/Total509/CurrentTaxYearMinus2Years080873
IRS990ScheduleA/Total509/CurrentTaxYearMinus3Years069612
IRS990ScheduleA/Total509/CurrentTaxYearMinus4Years059224
IRS990ScheduleA/Total509/Total0348223
IRS990ScheduleA/TotalSupportTotal/CurrentTaxYear082040
IRS990ScheduleA/TotalSupportTotal/CurrentTaxYearMinus1Year056474
IRS990ScheduleA/TotalSupportTotal/CurrentTaxYearMinus2Years080873
IRS990ScheduleA/TotalSupportTotal/CurrentTaxYearMinus3Years069612
IRS990ScheduleA/TotalSupportTotal/CurrentTaxYearMinus4Years059224
IRS990ScheduleA/TotalSupportTotal/Total0348223
IRS990ScheduleB/ContributorInfo/AggregateContributions0RESTRICTED
IRS990ScheduleB/ContributorInfo/ContributorAddressUS/AddressLine10RESTRICTED
IRS990ScheduleB/ContributorInfo/ContributorAddressUS/AddressLine20RESTRICTED
IRS990ScheduleB/ContributorInfo/ContributorAddressUS/City0RESTRICTED
IRS990ScheduleB/ContributorInfo/ContributorAddressUS/State0RESTRICTED
IRS990ScheduleB/ContributorInfo/ContributorAddressUS/ZIPCode0RESTRICTED
IRS990ScheduleB/ContributorInfo/ContributorNameBusiness/BusinessNameLine10RESTRICTED
IRS990ScheduleB/ContributorInfo/ContributorNumber0RESTRICTED
IRS990ScheduleO/GeneralExplanation/Explanation0Description Amount Depreciation from 4562 632 Registration Fees 30 Bank Charges 49 Refund 775 Supplies 23,720 Materials 3,148 Gasoline 1,700 Books and Subscriptions 277 Staff 300 Miscellaneous 5,620 Meeting 478
IRS990ScheduleO/GeneralExplanation/Explanation1Category Beginning of Year End of Year Current Liabilities 4,759 4,153
IRS990ScheduleO/GeneralExplanation/Identifier0O01
IRS990ScheduleO/GeneralExplanation/Identifier1O02
IRS990ScheduleO/GeneralExplanation/ReturnReference0Description of other expenses Part I line 16
IRS990ScheduleO/GeneralExplanation/ReturnReference1Description of total liabilities Part II line 26
ReturnHeader/BuildTS02016-02-24 21:20:13Z
ReturnHeader/Filer/EIN0208659533
ReturnHeader/Filer/Name/BusinessNameLine10BERTRAND FARM INC
ReturnHeader/Filer/NameControl0BERT
ReturnHeader/Filer/USAddress/AddressLine103575 W BERTRAND RD
ReturnHeader/Filer/USAddress/City0Niles
ReturnHeader/Filer/USAddress/State0MI
ReturnHeader/Filer/USAddress/ZIPCode049120
ReturnHeader/Officer/AuthorizeThirdParty0true
ReturnHeader/Officer/DateSigned02013-03-10
ReturnHeader/Officer/Name0THERESE ZIMMERMAN NIEMIER
ReturnHeader/Officer/Title0EXECUTIVE DIREC
ReturnHeader/PreparerFirm/EIN0314623246
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10MICHAEL G HORVATH EA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine10PO BOX 5098
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0Mooresville
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0NC
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode028117
ReturnHeader/Preparer/Name0MICHAEL G HORVATH
ReturnHeader/Preparer/Phone07046775620
ReturnHeader/Preparer/SelfEmployed0X
ReturnHeader/ReturnType0990EZ
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-05-14T10:15:59-04:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2012 • Form 990EZFacts available. Structured filing facts are available, but richer extracted sections are limited.

Open filing
Assets
$9,838
Liabilities
$4,153
Net assets
$5,685
Revenue
$82,040
Expenses
$74,398
Net income
$7,642
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