Civic Intelligence

State Farm Employees Activities Association

EIN 43-6049950 • 501(c)4 • Columbia, MO

Profile

Employee associations to provide social activies outside of work.

4700 S Providence RdColumbia, MO 65217-0001

n/A

Siviq Scores

Precomputed percentiles relative to similar nonprofits. These scores are descriptive rather than judgmental.

Liabilities / Assets

59th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

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

Liabilities / Revenue

61st percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

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

Net Margin

5th percentile

-276%

Higher net margin than 5% of similar nonprofits.

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

Top Officer Pay

89th percentile

$0

Higher top officer pay than 89% of similar nonprofits.

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

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

Asset Growth

10th percentile

-97%

Faster asset growth than 10% of similar nonprofits.

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

Revenue Growth

10th percentile

-75%

Faster revenue growth than 10% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets59th percentile

Assets

Down

$1,030

Down $30,976 (-97%) from 2016

Liabilities

Flat

$0

Flat from 2016

Net Assets

Down

$1,030

Down $30,976 (-97%) from 2016

Operations
Liabilities / Revenue61st percentileNet Margin5th percentile

Revenue

Down

$11,225

Down $32,825 (-75%) from 2016

Expenses

Up

$42,201

Up $17,445 (+70%) from 2016

Net Income

Down

-$30,976

Down $50,270 (-261%) from 2016

Trend Graphs

Balance Sheet Trend

Asset Growth10th percentile

Grouped bars show assets, liabilities, and net assets across loaded filings.

$40K$30K$20K$10K$0Assets 2011: $17,491Liabilities 2011: $02011Assets 2012: $9,022Liabilities 2012: $02012Assets 2013: $10,570Liabilities 2013: $02013Assets 2014: $9,844Liabilities 2014: $0Net Assets 2014: $9,8442014Assets 2015: $12,712Liabilities 2015: $0Net Assets 2015: $12,7122015Assets 2016: $32,006Liabilities 2016: $0Net Assets 2016: $32,0062016Assets 2017: $1,030Liabilities 2017: $0Net Assets 2017: $1,0302017

Highlighted filing

2017

Assets$1,030
Liabilities$0
Net Assets$1,030
Open 2017 Filing

Operations Trend

Revenue Growth10th percentile

Revenue, expenses, and net income by year, with the latest filing highlighted.

$100K$50K$0-$50KRevenue 2011: $85,578Expenses 2011: $73,349Net Income 2011: $12,2292011Revenue 2012: $68,386Expenses 2012: $76,855Net Income 2012: -$8,4692012Revenue 2013: $42,013Expenses 2013: $40,465Net Income 2013: $1,5482013Revenue 2014: $31,527Expenses 2014: $32,253Net Income 2014: -$7262014Revenue 2015: $28,435Expenses 2015: $25,567Net Income 2015: $2,8682015Revenue 2016: $44,050Expenses 2016: $24,756Net Income 2016: $19,2942016Revenue 2017: $11,225Expenses 2017: $42,201Net Income 2017: -$30,9762017

Highlighted filing

2017

Revenue$11,225
Expenses$42,201
Net Income-$30,976
Open 2017 Filing

Filings

Most recent year

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

Open filing
Assets
$1,030
Liabilities
$0
Net assets
$1,030
Revenue
$11,225
Expenses
$42,201
Net income
-$30,976
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2017Detailed filing. Detailed filing data is available for this year.$1.03$0.00$1.03$11.2$42.2$31.0
2016Detailed filing. Detailed filing data is available for this year.$32.0$0.00$32.0$44.1$24.8$19.3
2015Detailed filing. Detailed filing data is available for this year.$12.7$0.00$12.7$28.4$25.6$2.87
2014Detailed filing. Detailed filing data is available for this year.$9.84$0.00$9.84$31.5$32.3$0.73
2013Summary only. Only limited summary data is available for this year.$10.6$0.00$42.0$40.5$1.55
2012Summary only. Only limited summary data is available for this year.$9.02$0.00$68.4$76.9$8.47
2011Summary only. Only limited summary data is available for this year.$17.5$0.00$85.6$73.3$12.2
Latest Filing Detail
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Apr 14, 2018
Return Version
2017v2.3
Gross Receipts
$11,225
Mission and Program Overview

Mission

Employee associations to provide social activies outside of work.

Program Services

DescriptionGrantsExpenses
THE ORGANIZATION IS ABLE TO SCHEDULE, PROMOTE, ORGANIZE, AND HOLD EVENTS WHICH ALLOW EMPLOYEES TO MEET OUTSIDE OF WORK. (PICNICS, CHRISTMAS PROGRAMS, ETC.)-$42,201
Compensation and Service Providers
Top Officer Pay89th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
MELAINA DRISSELLPresident-$0--
CONSTANCE SMITHVice Preside-$0--
NATALEE KINSTLERHistorian-$0--
LORI ANN SMITHAdvisor-$0--
TAMMI LEIMKUEHLERCurrent Trea-$0--
JAYNE CARRINGTON WALKER2nd Vice Pre-$0--
CARRIE ALLENAdvisor-$0--
Filing and Contact Details

Filer

Filer Name
State Farm Employees Activities
EIN
43-6049950
Phone
5734992222
Address
4700 S PROVIDENCE RD, COLUMBIA, MO 65217-0001

Signing Officer

Name
Tammi Leimkuehler
Title
Current Treasurer
Signed
2018-04-14
Discuss with paid preparer
Yes

Preparer

Firm
Henry K Fisher Iii CPA LLC
Address
2510 W ASH ST, COLUMBIA, MO 65203-4608
Preparer
Henry K Fisher Iii CPA LLC
Phone
5734456513
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

“Expenses event expenses 41,550 miscellaneous 11 total 41,561”

Raw XML Appendix113 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/PersonNm0TAMMI LEIMKUEHLER
IRS990EZ/BooksInCareOfDetail/PhoneNum05734992222
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt04700 SOUTH PROVIDENCE ROAD
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0COLUMBIA
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MO
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd0652170001
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt032006
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt01030
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt011225
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-30976
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0640
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt032006
IRS990EZ/Form990TotalAssetsGrp/EOYAmt01030
IRS990EZ/GrossReceiptsAmt011225
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt032006
IRS990EZ/NetAssetsOrFundBalancesEOYAmt01030
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt032006
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt01030
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt31.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt41.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt51.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt61.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0MELAINA DRISSELL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1CONSTANCE SMITH
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2NATALEE KINSTLER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3LORI ANN SMITH
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4TAMMI LEIMKUEHLER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5JAYNE CARRINGTON WALKER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6CARRIE ALLEN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1VICE PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2HISTORIAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3ADVISOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4CURRENT TREA
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt52ND VICE PRE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6ADVISOR
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt041561
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0EMPLOYEE ASSOCIATIONS TO PROVIDE SOCIAL ACTIVIES OUTSIDE OF WORK.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0THE ORGANIZATION IS ABLE TO SCHEDULE, PROMOTE, ORGANIZE, AND HOLD EVENTS WHICH ALLOW EMPLOYEES TO MEET OUTSIDE OF WORK. (PICNICS, CHRISTMAS PROGRAMS, ETC.)
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt042201
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt042201
IRS990EZ/TotalProgramServiceExpensesAmt042201
IRS990EZ/TotalRevenueAmt011225
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationAssocInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES EVENT EXPENSES 41,550 MISCELLANEOUS 11 TOTAL 41,561
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0TAMMI LEIMKUEHLER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0CURRENT TREASURER
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-04-14
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0STATE FARM EMPLOYEES ACTIVITIES
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0ASSOCIATION
ReturnHeader/Filer/BusinessNameControlTxt0STAT
ReturnHeader/Filer/EIN0436049950
ReturnHeader/Filer/PhoneNum05734992222
ReturnHeader/Filer/USAddress/AddressLine1Txt04700 S PROVIDENCE RD
ReturnHeader/Filer/USAddress/CityNm0COLUMBIA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MO
ReturnHeader/Filer/USAddress/ZIPCd0652170001
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0ED948CB942FAF99C3FA186FDC57854839402F546
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0B8F88F9A39F500EDBF015B7E8F75A6FC44CB5D66
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0174.125.84.169
ReturnHeader/FilingSecurityInformation/IPDt02018-05-14
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm015:30:42
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0431406874
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0HENRY K FISHER III CPA LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02510 W ASH ST
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0COLUMBIA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0652034608
ReturnHeader/PreparerPersonGrp/PhoneNum05734456513
ReturnHeader/PreparerPersonGrp/PreparationDt02018-05-14
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0HENRY K FISHER III CPA LLC
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02018-05-14T15:30:42-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.