Civic Intelligence

Big Red Hen Films

990EZ • Fiscal year 2017 • EIN 30-0831092

Jan 01, 2017 to Dec 31, 2017 • Filed on Apr 23, 2018

Organization ProfileBIGREDHENFILMS.ORG
20727 Scio Church RoadChelsea, MI 48118

(734) 475-2310

Siviq Scores

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

Liabilities / Assets

90th percentile

0.54x

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

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

Liabilities / Revenue

93rd percentile

0.56x

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

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

Net Margin

90th percentile

46%

Higher net margin than 90% of similar nonprofits.

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

Top Officer Pay

76th percentile

$0

Higher top officer pay than 76% of similar nonprofits.

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

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

Asset Growth

89th percentile

79%

Faster asset growth than 89% of similar nonprofits.

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

Revenue Growth

99th percentile

716%

Faster revenue growth than 99% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets90th percentile

Assets

Up

$9,267

Up $4,104 (+79%) from 2016

Net Assets

Up

$4,267

Up $4,104 (+2518%) from 2016

Liabilities

Flat

$5,000

Flat from 2016

Revenue And Expenses
Liabilities / Revenue93rd percentileNet Margin90th percentile

Revenue

Up

$8,888

Up $7,799 (+716%) from 2016

Expenses

Up

$4,784

Up $66 (+1.4%) from 2016

Net Income

Up

$4,104

Up $7,733 (+213%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth89th percentile

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

$15K$10K$5.0K$0-$5.0KAssets 2014: $3,240Net Assets 2014: $3,2402014Assets 2015: $8,792Liabilities 2015: $5,000Net Assets 2015: $3,7922015Assets 2016: $5,163Liabilities 2016: $5,000Net Assets 2016: $1632016Assets 2017: $9,267Liabilities 2017: $5,000Net Assets 2017: $4,2672017Assets 2018: $10,667Liabilities 2018: $5,000Net Assets 2018: $5,6672018Assets 2019: $4,841Liabilities 2019: $5,000Net Assets 2019: -$1592019Assets 2020: $4,531Liabilities 2020: $5,000Net Assets 2020: -$4692020Assets 2021: $4,121Liabilities 2021: $5,000Net Assets 2021: -$8792021

Highlighted filing

2017

Assets$9,267
Liabilities$5,000
Net Assets$4,267
Open 2017 Filing

Operations Trend

Revenue Growth99th percentile

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

$10K$5.0K$0-$5.0KRevenue 2014: $10,000Expenses 2014: $6,760Net Income 2014: $3,2402014Revenue 2015: $7,910Expenses 2015: $7,358Net Income 2015: $5522015Revenue 2016: $1,089Expenses 2016: $4,718Net Income 2016: -$3,6292016Revenue 2017: $8,888Expenses 2017: $4,784Net Income 2017: $4,1042017Revenue 2018: $3,699Expenses 2018: $2,299Net Income 2018: $1,4002018Expenses 2019: $5,8262019Revenue 2020: $60Expenses 2020: $370Net Income 2020: -$3102020Expenses 2021: $4102021

Highlighted filing

2017

Revenue$8,888
Expenses$4,784
Net Income$4,104
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Apr 23, 2018
Return Version
2017v2.3
Gross Receipts
$8,888
Mission and Program Overview

Mission

Produce and distribute films of minority artisic/cultural activities.

Program Services

DescriptionGrantsExpenses
PRODUCE FILM OF MINORITY ARTISTIC/CULTURAL ACTIVITY.-$4,784
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
SUSAN MOREL-SAMUELSDirector-$0--
STEVE KAGANDirector-$0--
DAVID STRAUSSDirector-$0--
ANDREW SACKSPresident-$0--
ANN SWEETTreasurer/Se-$0--
Filing and Contact Details

Filer

Filer Name
Big Red Hen Films
EIN
30-0831092
Phone
7344752310
Address
20727 SCIO CHURCH ROAD, CHELSEA, MI 48118

Signing Officer

Name
Andrew Sacks
Title
President
Phone
7346454847
Signed
2018-04-23

Preparer

Firm
Curtis Bailey Exelby & Sposito Pc
Address
2320 WASHTENAW AVE, ANN ARBOR, MI 48104-4558
Preparer
Henry E Alvarez CPA
Phone
7346637492
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

“Expenses supplies 180 state annual report fee 20 total 200”

Form 990-ez, Part II, Line 26

“Unsecured notes and loans payable 5,000 5,000”

Raw XML Appendix132 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
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0CURTIS BAILEY EXELBY & SPOSITO PC
IRS990EZ/BooksInCareOfDetail/PhoneNum07346637492
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt02320 WASHTENAW AVE
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0ANN ARBOR
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MI
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd048104
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt05163
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt09267
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt08500
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt04104
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt03434
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt05163
IRS990EZ/Form990TotalAssetsGrp/EOYAmt09267
IRS990EZ/GrossReceiptsAmt08888
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0163
IRS990EZ/NetAssetsOrFundBalancesEOYAmt04267
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0163
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt04267
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt3000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt4000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0SUSAN MOREL-SAMUELS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1STEVE KAGAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2DAVID STRAUSS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3ANDREW SACKS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4ANN SWEET
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4TREASURER/SE
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt0200
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0PRODUCE AND DISTRIBUTE FILMS OF MINORITY ARTISIC/CULTURAL ACTIVITIES.
IRS990EZ/ProgramServiceRevenueAmt0388
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PRODUCE FILM OF MINORITY ARTISTIC/CULTURAL ACTIVITY.
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt04784
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt01150
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt05000
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt05000
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt04784
IRS990EZ/TotalProgramServiceExpensesAmt04784
IRS990EZ/TotalRevenueAmt08888
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0BIGREDHENFILMS.ORG
IRS990ScheduleA/First5Years170Ind0X
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt08500
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt0150
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt05825
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt010000
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt024475
IRS990ScheduleA/GrossReceiptsRltdActivitiesAmt0388
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportTotal170Amt024475
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt08500
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt0150
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt05825
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt010000
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt024475
IRS990ScheduleA/TotalSupportAmt024475
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES SUPPLIES 180 STATE ANNUAL REPORT FEE 20 TOTAL 200
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1UNSECURED NOTES AND LOANS PAYABLE 5,000 5,000
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART II, LINE 26
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/PersonNm0ANDREW SACKS
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum07346454847
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-04-23
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0BIG RED HEN FILMS
ReturnHeader/Filer/BusinessNameControlTxt0BIGR
ReturnHeader/Filer/EIN0300831092
ReturnHeader/Filer/PhoneNum07344752310
ReturnHeader/Filer/USAddress/AddressLine1Txt020727 SCIO CHURCH ROAD
ReturnHeader/Filer/USAddress/CityNm0CHELSEA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd048118
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0054FEC8D104C75BFADFF2C012D6B349F7594B265
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0A839B8056B58515F074C86580174C438A04C9D47
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt050.247.12.109
ReturnHeader/FilingSecurityInformation/IPDt02018-11-09
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CS
ReturnHeader/FilingSecurityInformation/IPTm006:40:47
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0381988006
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0CURTIS BAILEY EXELBY & SPOSITO PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02320 WASHTENAW AVE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0ANN ARBOR
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0481044558
ReturnHeader/PreparerPersonGrp/PhoneNum07346637492
ReturnHeader/PreparerPersonGrp/PreparationDt02018-11-09
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0HENRY E ALVAREZ CPA
ReturnHeader/ReturnTs02018-11-09T07:40:47-05: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
$9,267
Liabilities
$5,000
Net assets
$4,267
Revenue
$8,888
Expenses
$4,784
Net income
$4,104
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2021Detailed filing. Detailed filing data is available for this year.$4.12$5.00$0.88$0.41
2020Detailed filing. Detailed filing data is available for this year.$4.53$5.00$0.47$0.06$0.37$0.31
2019Detailed filing. Detailed filing data is available for this year.$4.84$5.00$0.16$5.83
2018Detailed filing. Detailed filing data is available for this year.$10.7$5.00$5.67$3.70$2.30$1.40
2017Detailed filing. Detailed filing data is available for this year.$9.27$5.00$4.27$8.89$4.78$4.10
2016Detailed filing. Detailed filing data is available for this year.$5.16$5.00$0.16$1.09$4.72$3.63
2015Detailed filing. Detailed filing data is available for this year.$8.79$5.00$3.79$7.91$7.36$0.55
2014Detailed filing. Detailed filing data is available for this year.$3.24$3.24$10.0$6.76$3.24