Civic Intelligence

Alexander Franklin Charitable Foundation

990EZ • Fiscal year 2016 • EIN 31-1662965

Jan 01, 2016 to Dec 31, 2016 • Filed on May 05, 2017

37 Crosswood RoadFarmington, CT 06032-1067

(860) 673-2706

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.

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

Liabilities / Revenue

55th percentile

0.00x

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

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

Net Margin

7th percentile

-58%

Higher net margin than 7% of similar nonprofits.

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

Top Officer Pay

75th percentile

$0

Higher top officer pay than 75% of similar nonprofits.

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

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

Asset Growth

22nd percentile

-18%

Faster asset growth than 22% of similar nonprofits.

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

Revenue Growth

17th percentile

-31%

Faster revenue growth than 17% of similar nonprofits.

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

Assets

Down

$39,159

Down $8,595 (-18%) from 2015

Net Assets

Down

$39,159

Down $8,595 (-18%) from 2015

Liabilities

Flat

$0

Flat from 2015

Revenue

Down

$16,430

Down $7,347 (-31%) from 2015

Expenses

Up

$25,926

Up $1,660 (+6.8%) from 2015

Net Income

Down

-$9,496

Down $9,007 (-1842%) from 2015

Historical Trend

Balance Sheet Trend

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

$100K$50K$0Assets 2010: $87,463Liabilities 2010: $0Net Assets 2010: $87,4632010Assets 2011: $63,547Liabilities 2011: $0Net Assets 2011: $63,5472011Assets 2012: $53,359Liabilities 2012: $0Net Assets 2012: $53,3592012Assets 2013: $58,985Liabilities 2013: $0Net Assets 2013: $58,9852013Assets 2014: $53,441Liabilities 2014: $0Net Assets 2014: $53,4412014Assets 2015: $47,754Liabilities 2015: $0Net Assets 2015: $47,7542015Assets 2016: $39,159Liabilities 2016: $0Net Assets 2016: $39,1592016Assets 2017: $33,687Liabilities 2017: $0Net Assets 2017: $33,6872017Assets 2018: $22,469Liabilities 2018: $0Net Assets 2018: $22,4692018Assets 2019: $26,931Liabilities 2019: $0Net Assets 2019: $26,9312019Assets 2020: $30,996Net Assets 2020: $30,9962020Assets 2021: $33,487Net Assets 2021: $33,4872021Assets 2022: $24,086Net Assets 2022: $24,0862022Assets 2023: $31,838Net Assets 2023: $31,8382023Assets 2024: $26,777Net Assets 2024: $26,7772024

Highlighted filing

2016

Assets$39,159
Liabilities$0
Net Assets$39,159

Operations Trend

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

$60K$40K$20K$0-$20K-$40KRevenue 2010: $18,554Expenses 2010: $30,467Net Income 2010: -$11,9132010Revenue 2011: $22,909Expenses 2011: $46,872Net Income 2011: -$23,9632011Revenue 2012: $14,655Expenses 2012: $28,385Net Income 2012: -$13,7302012Revenue 2013: $21,658Expenses 2013: $21,944Net Income 2013: -$2862013Revenue 2014: $25,912Expenses 2014: $27,829Net Income 2014: -$1,9172014Revenue 2015: $23,777Expenses 2015: $24,266Net Income 2015: -$4892015Revenue 2016: $16,430Expenses 2016: $25,926Net Income 2016: -$9,4962016Revenue 2017: $21,428Expenses 2017: $27,101Net Income 2017: -$5,6732017Revenue 2018: $21,043Expenses 2018: $28,877Net Income 2018: -$7,8342018Revenue 2019: $24,075Expenses 2019: $20,226Net Income 2019: $3,8492019Revenue 2020: $16,945Expenses 2020: $13,196Net Income 2020: $3,7492020Revenue 2021: $21,608Expenses 2021: $15,408Net Income 2021: $6,2002021Revenue 2022: $4,650Expenses 2022: $14,053Net Income 2022: -$9,4032022Revenue 2023: $26,397Expenses 2023: $30,280Net Income 2023: -$3,8832023Revenue 2024: $25,716Expenses 2024: $30,778Net Income 2024: -$5,0622024

Highlighted filing

2016

Revenue$16,430
Expenses$25,926
Net Income-$9,496
Jump To
Filing Snapshot
Filing Period
Jan 1, 2016 to Dec 31, 2016
Signed
May 5, 2017
Return Version
2016v3.0
Gross Receipts
$36,749
Mission and Program Overview

Mission

To support the activities of groups such as the boy scouts, public libraries, inner city youth activities and other civic groups.

Program Services

DescriptionGrantsExpenses
PROVIDES CONTRIBUTIONS AND SCHOLARSHIPS TO STUDENTS AND VARIOUS NON-PROFIT ORGANIZATIONS, INCLUDING THE BOY SCOUTS, PUBLIC LIBRARIES AND OTHER YOUTH ORGANIZATIONS.$25,260$25,926
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
JERRY FRANKLINBoard Member-$0--
IDA FRANKLINBoard Member-$0--
JENNIFER FRANKLINBoard Member-$0--
Filing and Contact Details

Filer

Filer Name
Alexander Franklin Charitable Foundation
EIN
31-1662965
Phone
8606732706
Address
37 CROSSWOOD ROAD, FARMINGTON, CT 06032-1067

Signing Officer

Name
Jerry Franklin
Title
Trustee
Phone
8606732706
Signed
2017-05-05
Discuss with paid preparer
Yes

Preparer

Firm
Crowe Horwath Llp
Address
175 POWDER FOREST DR, SIMSBURY, CT 06089
Preparer
Beth Thurz
Phone
8606789200
Supplemental Narrative

Additional Explanations

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

Description: dividend income. Amount: 821.

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

Description: bank management fees. Amount: 666.

Form 990-ez, Part I, Line 20 - Other Changes in Net Assets

Description: change in unrealized gains (losses) on investments. Amount: 901.

Form 990-ez, Part II, Line 24 - Other Assets

Description: mutual funds. Beg. Of year amount: 8,455. End of year amount: 9,138. Description: equities. Beg. Of year amount: 24,059. End of year amount: 22,406. Description: real assets. Beg. Of year amount: 398. End of year amount: 495.

Raw XML Appendix157 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/BusinessName/BusinessNameLine1Txt0JERRY FRANKLIN
IRS990EZ/BooksInCareOfDetail/PhoneNum08606732706
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt037 CROSSWOOD ROAD
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0FARMINGTON
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0CT
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd0060321067
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt014842
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt07120
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd00
IRS990EZ/ContributionsGiftsGrantsEtcAmt013820
IRS990EZ/CostOrOtherBasisExpenseSaleAmt020319
IRS990EZ/DirectIndirectPltclExpendAmt00
IRS990EZ/DonorAdvisedFndsInd00
IRS990EZ/EngagedInExcessBenefitTransInd00
IRS990EZ/ExcessOrDeficitForYearAmt0-9496
IRS990EZ/FiledScheduleAInd01
IRS990EZ/ForeignFinancialAccountInd00
IRS990EZ/ForeignOfficeInd00
IRS990EZ/Form990TotalAssetsGrp/BOYAmt047754
IRS990EZ/Form990TotalAssetsGrp/EOYAmt039159
IRS990EZ/GainOrLossFromSaleOfAssetsAmt01789
IRS990EZ/GrantsAndSimilarAmountsPaidAmt025260
IRS990EZ/GrossReceiptsAmt036749
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InfoInScheduleOPartVInd0X
IRS990EZ/InvestmentIncomeAmt0821
IRS990EZ/LobbyingActivitiesInd00
IRS990EZ/MadeLoansToFromOfficersInd00
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt047754
IRS990EZ/NetAssetsOrFundBalancesEOYAmt039159
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt047754
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt039159
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00.25
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10.25
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt20.25
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0JERRY FRANKLIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1IDA FRANKLIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2JENNIFER FRANKLIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2BOARD MEMBER
IRS990EZ/OperateHospitalInd00
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd00
IRS990EZ/OrganizationHadUBIInd00
IRS990EZ/OtherAssetsTotalDetail/BOYAmt032912
IRS990EZ/OtherAssetsTotalDetail/EOYAmt032039
IRS990EZ/OtherChangesInNetAssetsAmt0901
IRS990EZ/OtherExpensesTotalAmt0666
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd00
IRS990EZ/PrimaryExemptPurposeTxt0TO SUPPORT THE ACTIVITIES OF GROUPS SUCH AS THE BOY SCOUTS, PUBLIC LIBRARIES, INNER CITY YOUTH ACTIVITIES AND OTHER CIVIC GROUPS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PROVIDES CONTRIBUTIONS AND SCHOLARSHIPS TO STUDENTS AND VARIOUS NON-PROFIT ORGANIZATIONS, INCLUDING THE BOY SCOUTS, PUBLIC LIBRARIES AND OTHER YOUTH ORGANIZATIONS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt025260
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt025926
IRS990EZ/ProhibitedTaxShelterTransInd00
IRS990EZ/RelatedOrganizationCtrlEntInd00
IRS990EZ/SaleOfAssetsGrossAmt022108
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd00
IRS990EZ/SubjectToProxyTaxInd00
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd00
IRS990EZ/TaxImposedOnOrganizationMgrAmt00
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TaxReimbursedByOrganizationAmt00
IRS990EZ/TotalExpensesAmt025926
IRS990EZ/TotalProgramServiceExpensesAmt025926
IRS990EZ/TotalRevenueAmt016430
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd00
IRS990EZ/TypeOfOrganizationTrustInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt013820
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt018960
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt018559
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt017133
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt011171
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt079643
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearAmt0821
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus1YearAmt0822
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt01143
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus3YearsAmt01205
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus4YearsAmt01293
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt05284
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.93780
IRS990ScheduleA/PublicSupportPY170Pct00.93820
IRS990ScheduleA/PublicSupportTotal170Amt079643
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt013820
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt018960
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt018559
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt017133
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt011171
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt079643
IRS990ScheduleA/TotalSupportAmt084927
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0DESCRIPTION: DIVIDEND INCOME. AMOUNT: 821.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1DESCRIPTION: BANK MANAGEMENT FEES. AMOUNT: 666.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2DESCRIPTION: CHANGE IN UNREALIZED GAINS (LOSSES) ON INVESTMENTS. AMOUNT: 901.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3DESCRIPTION: MUTUAL FUNDS. BEG. OF YEAR AMOUNT: 8,455. END OF YEAR AMOUNT: 9,138. DESCRIPTION: EQUITIES. BEG. OF YEAR AMOUNT: 24,059. END OF YEAR AMOUNT: 22,406. DESCRIPTION: REAL ASSETS. BEG. OF YEAR AMOUNT: 398. END OF YEAR AMOUNT: 495.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 4 - OTHER INVESTMENT INCOME
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 16 - OTHER EXPENSES
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART I, LINE 20 - OTHER CHANGES IN NET ASSETS
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART II, LINE 24 - OTHER ASSETS
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/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0JERRY FRANKLIN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum08606732706
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-05-05
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ALEXANDER FRANKLIN CHARITABLE FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0ALEX
ReturnHeader/Filer/EIN0311662965
ReturnHeader/Filer/PhoneNum08606732706
ReturnHeader/Filer/USAddress/AddressLine1Txt037 CROSSWOOD ROAD
ReturnHeader/Filer/USAddress/CityNm0FARMINGTON
ReturnHeader/Filer/USAddress/StateAbbreviationCd0CT
ReturnHeader/Filer/USAddress/ZIPCd0060321067
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0DA39A3EE5E6B4B0D3255BFEF95601890AFD80709
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0C39BF47562FD23EE52259DBA0A3C8DF7B9D90A91
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0159.246.20.2
ReturnHeader/FilingSecurityInformation/IPDt02017-05-05
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0ED
ReturnHeader/FilingSecurityInformation/IPTm009:08:16
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0350921680
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0CROWE HORWATH LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0175 POWDER FOREST DR
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0SIMSBURY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0CT
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd006089
ReturnHeader/PreparerPersonGrp/PhoneNum08606789200
ReturnHeader/PreparerPersonGrp/PreparationDt02017-05-01
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0BETH THURZ
ReturnHeader/ReturnTs02017-05-08T12:44:26-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-01-01
ReturnHeader/TaxPeriodEndDt02016-12-31
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$26.8$26.8$25.7$30.8$5.06
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$31.8$31.8$26.4$30.3$3.88
2022Detailed filing. Detailed filing data is available for this year.$24.1$24.1$4.65$14.1$9.40
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$33.5$33.5$21.6$15.4$6.20
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$31.0$31.0$16.9$13.2$3.75
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$26.9$0.00$26.9$24.1$20.2$3.85
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$22.5$0.00$22.5$21.0$28.9$7.83
2017Detailed filing. Detailed filing data is available for this year.$33.7$0.00$33.7$21.4$27.1$5.67
2016Detailed filing. Detailed filing data is available for this year.$39.2$0.00$39.2$16.4$25.9$9.50
2015Detailed filing. Detailed filing data is available for this year.$47.8$0.00$47.8$23.8$24.3$0.49
2014Detailed filing. Detailed filing data is available for this year.$53.4$0.00$53.4$25.9$27.8$1.92
2013Detailed filing. Detailed filing data is available for this year.$59.0$0.00$59.0$21.7$21.9$0.29
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$53.4$0.00$53.4$14.7$28.4$13.7
2011XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$63.5$0.00$63.5$22.9$46.9$24.0
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$87.5$0.00$87.5$18.6$30.5$11.9