Civic Intelligence

Franklin Community Association

990EZ • Fiscal year 2017 • EIN 38-1616420

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

PO Box 250046Franklin, MI 48025

(248) 827-1890

Siviq Scores

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

Liabilities / Assets

56th percentile

0.00x

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

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

Liabilities / Revenue

56th percentile

0.00x

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

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

Net Margin

11th percentile

-33%

Higher net margin than 11% 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

25th percentile

-13%

Faster asset growth than 25% of similar nonprofits.

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

Revenue Growth

33rd percentile

-10%

Faster revenue growth than 33% of similar nonprofits.

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

Assets

Down

$81,559

Down $12,539 (-13%) from 2016

Net Assets

Down

$81,559

Down $12,539 (-13%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue

Down

$38,184

Down $4,300 (-10%) from 2016

Expenses

Up

$50,723

Up $14,669 (+41%) from 2016

Net Income

Down

-$12,539

Down $18,969 (-295%) from 2016

Historical Trend

Balance Sheet Trend

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

$100K$50K$0Assets 2010: $55,976Liabilities 2010: $0Net Assets 2010: $55,9762010Assets 2011: $59,548Liabilities 2011: $0Net Assets 2011: $59,5482011Assets 2012: $59,026Liabilities 2012: $0Net Assets 2012: $59,0262012Assets 2013: $65,349Liabilities 2013: $0Net Assets 2013: $65,3492013Assets 2014: $64,694Liabilities 2014: $0Net Assets 2014: $64,6942014Assets 2015: $87,668Liabilities 2015: $0Net Assets 2015: $87,6682015Assets 2016: $94,098Liabilities 2016: $0Net Assets 2016: $94,0982016Assets 2017: $81,559Liabilities 2017: $0Net Assets 2017: $81,5592017Assets 2018: $79,835Liabilities 2018: $0Net Assets 2018: $79,8352018Assets 2019: $56,797Liabilities 2019: $0Net Assets 2019: $56,7972019

Highlighted filing

2017

Assets$81,559
Liabilities$0
Net Assets$81,559

Operations Trend

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

$60K$40K$20K$0-$20K-$40KRevenue 2010: $35,420Expenses 2010: $27,748Net Income 2010: $7,6722010Revenue 2011: $43,417Expenses 2011: $39,845Net Income 2011: $3,5722011Revenue 2012: $43,370Expenses 2012: $43,892Net Income 2012: -$5222012Revenue 2013: $47,513Expenses 2013: $41,190Net Income 2013: $6,3232013Revenue 2014: $35,446Expenses 2014: $36,101Net Income 2014: -$6552014Revenue 2015: $47,047Expenses 2015: $24,073Net Income 2015: $22,9742015Revenue 2016: $42,484Expenses 2016: $36,054Net Income 2016: $6,4302016Revenue 2017: $38,184Expenses 2017: $50,723Net Income 2017: -$12,5392017Revenue 2018: $46,593Expenses 2018: $48,317Net Income 2018: -$1,7242018Revenue 2019: $4,291Expenses 2019: $27,329Net Income 2019: -$23,0382019

Highlighted filing

2017

Revenue$38,184
Expenses$50,723
Net Income-$12,539
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Aug 14, 2018
Return Version
2017v2.3
Gross Receipts
$61,929
Mission and Program Overview

Mission

Preservation and beautification of franklin village community.

Program Services

DescriptionGrantsExpenses
SUMMER ROUND UP$0$23,745
DONATION TO FRANKLIN CHARITIES$0$13,800
MUSIC ON THE GREEN$0$3,694
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
KATHY ERLICHVice President, Director-$0--
STEWART WEINERTreasurer-$0--
BARRY SILVERMANSecretary-$0--
JESSE POLANDirector-$0--
JANE POLANPresident-$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Round Up$26,564$26,564$23,745$2,819
Total Events$26,564$26,564$23,745$2,819
Filing and Contact Details

Filer

Filer Name
Franklin Community Association
EIN
38-1616420
Phone
2488271890
Address
PO BOX 250046, FRANKLIN, MI 48025

Signing Officer

Name
Stewart Weiner
Title
Treasurer
Phone
2488271890
Signed
2018-08-14
Discuss with paid preparer
Yes

Preparer

Firm
Garelik & Epstein Pllc
Address
18444 W TEN MILE STE 104, SOUTHFIELD, MI 48075
Preparer
Robert M Garelik CPA
Phone
2485577466
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 4 - Other Investment Income

Description: interest income. Amount: 21.

Form 990-ez, Part I, Line 16 - Other Expenses

Description: insurance for events. Amount: 7,607. Description: lawn service. Amount: 10,320. Description: repairs to community property. Amount: 850. Description: grants & donations to village. Amount: 10,000. Description: movies. Amount: 3,694. Description: donations to franklin charities. Amount: 3,800. Total to form 990-ez, line 16: 36,271.

Raw XML Appendix191 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/ActivitiesNotPreviouslyRptInd00
IRS990EZ/BooksInCareOfDetail/PersonNm0STEWART WEINER
IRS990EZ/BooksInCareOfDetail/PhoneNum02488271890
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 250046
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0FRANKLIN
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MI
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd048025
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt094098
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt081559
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd00
IRS990EZ/ContributionsGiftsGrantsEtcAmt012974
IRS990EZ/DirectIndirectPltclExpendAmt00
IRS990EZ/DonorAdvisedFndsInd00
IRS990EZ/EngagedInExcessBenefitTransInd00
IRS990EZ/ExcessOrDeficitForYearAmt0-12539
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt01000
IRS990EZ/FiledScheduleAInd01
IRS990EZ/ForeignFinancialAccountInd00
IRS990EZ/ForeignOfficeInd00
IRS990EZ/Form990TotalAssetsGrp/BOYAmt094098
IRS990EZ/Form990TotalAssetsGrp/EOYAmt081559
IRS990EZ/FundraisingGrossIncomeAmt026564
IRS990EZ/GrossReceiptsAmt061929
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InfoInScheduleOPartVInd0X
IRS990EZ/InvestmentIncomeAmt021
IRS990EZ/LobbyingActivitiesInd00
IRS990EZ/MadeLoansToFromOfficersInd00
IRS990EZ/MembershipDuesAmt022370
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt094098
IRS990EZ/NetAssetsOrFundBalancesEOYAmt081559
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt094098
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt081559
IRS990EZ/OccupancyRentUtltsAndMaintAmt01054
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt31.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt41.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0KATHY ERLICH
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1STEWART WEINER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2BARRY SILVERMAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3JESSE POLAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4JANE POLAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0VICE PRESIDENT, DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4PRESIDENT
IRS990EZ/OperateHospitalInd00
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd00
IRS990EZ/OrganizationHadUBIInd00
IRS990EZ/OtherChangesInNetAssetsAmt00
IRS990EZ/OtherExpensesTotalAmt036271
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd00
IRS990EZ/PrimaryExemptPurposeTxt0PRESERVATION AND BEAUTIFICATION OF FRANKLIN VILLAGE COMMUNITY.
IRS990EZ/PrintingPublicationsPostageAmt012398
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0SUMMER ROUND UP
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1MUSIC ON THE GREEN
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt2DONATION TO FRANKLIN CHARITIES
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt10
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt20
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt023745
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt13694
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt213800
IRS990EZ/ProhibitedTaxShelterTransInd00
IRS990EZ/RelatedOrganizationCtrlEntInd00
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd00
IRS990EZ/SpecialEventsDirectExpensesAmt023745
IRS990EZ/SpecialEventsNetIncomeLossAmt02819
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0MI
IRS990EZ/SubjectToProxyTaxInd00
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd00
IRS990EZ/TaxImposedOnOrganizationMgrAmt00
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TaxReimbursedByOrganizationAmt00
IRS990EZ/TotalExpensesAmt050723
IRS990EZ/TotalProgramServiceExpensesAmt041239
IRS990EZ/TotalRevenueAmt038184
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd00
IRS990EZ/TypeOfOrganizationTrustInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/AmountsRcvdDsqlfyPersonGrp/TotalAmt00
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt028925
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt035308
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt038194
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt036696
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt037620
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0176743
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct01.00000
IRS990ScheduleA/PublicSupportPY509Pct01.00000
IRS990ScheduleA/PublicSupportTotal509Amt0322772
IRS990ScheduleA/SubstAndDsqlfyPrsnsTotGrp/TotalAmt00
IRS990ScheduleA/SubstantialContributorsAmtGrp/TotalAmt00
IRS990ScheduleA/TaxRevLeviedOrgnztnlBnft509Grp/CurrentTaxYearAmt047030
IRS990ScheduleA/TaxRevLeviedOrgnztnlBnft509Grp/CurrentTaxYearMinus1YearAmt033483
IRS990ScheduleA/TaxRevLeviedOrgnztnlBnft509Grp/CurrentTaxYearMinus2YearsAmt016952
IRS990ScheduleA/TaxRevLeviedOrgnztnlBnft509Grp/CurrentTaxYearMinus3YearsAmt035998
IRS990ScheduleA/TaxRevLeviedOrgnztnlBnft509Grp/CurrentTaxYearMinus4YearsAmt012566
IRS990ScheduleA/TaxRevLeviedOrgnztnlBnft509Grp/TotalAmt0146029
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt075955
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt068791
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt055146
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt072694
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt050186
IRS990ScheduleA/Total509Grp/TotalAmt0322772
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt075955
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt068791
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt055146
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt072694
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt050186
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0322772
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt023745
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0ROUND UP
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt026564
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt026564
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt026564
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt026564
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt02819
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt023745
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt023745
IRS990ScheduleG/FundraisingEventInformationGrp/OtherEventsTotalCnt01
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0DESCRIPTION: INTEREST INCOME. AMOUNT: 21.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1DESCRIPTION: INSURANCE FOR EVENTS. AMOUNT: 7,607. DESCRIPTION: LAWN SERVICE. AMOUNT: 10,320. DESCRIPTION: REPAIRS TO COMMUNITY PROPERTY. AMOUNT: 850. DESCRIPTION: GRANTS & DONATIONS TO VILLAGE. AMOUNT: 10,000. DESCRIPTION: MOVIES. AMOUNT: 3,694. DESCRIPTION: DONATIONS TO FRANKLIN CHARITIES. AMOUNT: 3,800. TOTAL TO FORM 990-EZ, LINE 16: 36,271.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 4 - OTHER INVESTMENT INCOME
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 16 - OTHER EXPENSES
TransferPrsnlBnftContractsDecl/DeclarationDesc0THE ORGANIZATION DID NOT, DURING THE YEAR, RECEIVE ANY FUNDS, DIRECTLY,OR INDIRECTLY, TO PAY PREMIUMS ON A PERSONAL BENEFIT CONTRACT.THE ORGANIZATION, DID NOT, DURING THE YEAR, PAY ANY PREMIUMS, DIRECTLY,OR INDIRECTLY, ON A PERSONAL BENEFIT CONTRACT.
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0STEWART WEINER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum02488271890
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-08-14
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0FRANKLIN COMMUNITY ASSOCIATION
ReturnHeader/Filer/BusinessNameControlTxt0FRAN
ReturnHeader/Filer/EIN0381616420
ReturnHeader/Filer/PhoneNum02488271890
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 250046
ReturnHeader/Filer/USAddress/CityNm0FRANKLIN
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd048025
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId025D29F448DE971699F58B3B4117A50AD3DF8A144
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId025D29F448DE971699F58B3B4117A50AD3DF8A144
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt068.58.202.250
ReturnHeader/FilingSecurityInformation/IPDt02018-08-14
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0ED
ReturnHeader/FilingSecurityInformation/IPTm012:53:32
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0815226625
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0GARELIK & EPSTEIN PLLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt018444 W TEN MILE STE 104
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0SOUTHFIELD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd048075
ReturnHeader/PreparerPersonGrp/PhoneNum02485577466
ReturnHeader/PreparerPersonGrp/PreparationDt02018-08-14
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0ROBERT M GARELIK CPA
ReturnHeader/ReturnTs02018-08-14T12:34:44-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