Civic Intelligence

Alexander Franklin Charitable Foundation

990EZ • Fiscal year 2020 • EIN 31-1662965

Jan 01, 2020 to Dec 31, 2020 • Filed on Apr 22, 2021

Organization ProfileN/A
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

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on this filing.

Source year 2020

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2020

Net Margin

72nd percentile

22%

Higher net margin than 72% of similar nonprofits.

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

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.

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

Asset Growth

63rd percentile

15%

Faster asset growth than 63% of similar nonprofits.

2020 filings • 501(c)3 • <$500k nonprofits • Annualized from 2019 to 2020

Revenue Growth

36th percentile

-30%

Faster revenue growth than 36% of similar nonprofits.

2020 filings • 501(c)3 • <$500k nonprofits • Annualized from 2019 to 2020

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Up

$30,996

Up $4,065 (+15%) from 2019

Net Assets

Up

$30,996

Up $4,065 (+15%) from 2019

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin72nd percentile

Revenue

Down

$16,945

Down $7,130 (-30%) from 2019

Expenses

Down

$13,196

Down $7,030 (-35%) from 2019

Net Income

Down

$3,749

Down $100 (-2.6%) from 2019

Historical Trend

Balance Sheet Trend

Asset Growth63rd percentile

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

2020

Assets$30,996
Liabilities-
Net Assets$30,996
Open 2020 Filing

Operations Trend

Revenue Growth36th percentile

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

2020

Revenue$16,945
Expenses$13,196
Net Income$3,749
Open 2020 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2020 to Dec 31, 2020
Signed
Apr 22, 2021
Return Version
2020v4.0
Gross Receipts
$25,864
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.

Scholarships and support non-profit groups

Program Services

DescriptionGrantsExpenses
PROVIDE SCHOLARSHIPS TO STUDENTS AND CONTRIBUTIONS TO VARIOUS NON-PROFIT ORGANIZATIONS, INCLUDING THE BOY SCOUTS, PUBLIC LIBRARIES, AND OTHER YOUTH ORGANIZATIONS.$12,855$13,196
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

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

Filer

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

Signing Officer

Name
Jerry Franklin
Title
Trustee
Phone
8606732706
Signed
2021-04-22
Discuss with paid preparer
Yes

Preparer

Firm
Olliff & Fordham Cpas Pc
Address
3 NORTH BROAD STREET PO BOX 537, METTER, GA 30439
Preparer
J Dale Fordham
Phone
9126856850
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 10

“Cash contribution: 12,855”

Form 990-ez, Part I, Line 16

“Expenses bank fees 341 total 341”

Form 990-ez, Part I, Line 20

“Unrealized gain on investments 316”

Form 990-ez, Part II, Line 24

“Marketable securities 10,018 12,464 total 10,018 12,464”

Raw XML Appendix139 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/CompensationExplanationGrp/PersonNm0JERRY FRANKLIN
CompensationExplanation/CompensationExplanationGrp/PersonNm1IDA FRANKLIN
CompensationExplanation/CompensationExplanationGrp/PersonNm2JENNIFER FRANKLIN
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/PersonNm0JERRY FRANKLIN
IRS990EZ/BooksInCareOfDetail/PhoneNum08606732706
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt037 CROSSWOOD ROAD
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0FARMINGTON
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0CT
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd0060321067
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt016913
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt018532
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt016153
IRS990EZ/CostOrOtherBasisExpenseSaleAmt08919
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt03749
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt026931
IRS990EZ/Form990TotalAssetsGrp/EOYAmt030996
IRS990EZ/GainOrLossFromSaleOfAssetsAmt0460
IRS990EZ/GrantsAndSimilarAmountsPaidAmt012855
IRS990EZ/GrossReceiptsAmt025864
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0332
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt026931
IRS990EZ/NetAssetsOrFundBalancesEOYAmt030996
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt026931
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt030996
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00.25
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10.25
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt20.25
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0JERRY FRANKLIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1IDA FRANKLIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2JENNIFER FRANKLIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2BOARD MEMBER
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt010018
IRS990EZ/OtherAssetsTotalDetail/EOYAmt012464
IRS990EZ/OtherChangesInNetAssetsAmt0316
IRS990EZ/OtherExpensesTotalAmt0341
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0SCHOLARSHIPS AND SUPPORT NON-PROFIT GROUPS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PROVIDE SCHOLARSHIPS TO STUDENTS AND CONTRIBUTIONS TO VARIOUS NON-PROFIT ORGANIZATIONS, INCLUDING THE BOY SCOUTS, PUBLIC LIBRARIES, AND OTHER YOUTH ORGANIZATIONS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt012855
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt013196
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SaleOfAssetsGrossAmt09379
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt013196
IRS990EZ/TotalProgramServiceExpensesAmt013196
IRS990EZ/TotalRevenueAmt016945
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationTrustInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt016153
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt022139
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt018084
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt017904
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt013820
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt088100
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearAmt0332
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus1YearAmt0465
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt0533
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus3YearsAmt0571
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus4YearsAmt0821
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt02722
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.97000
IRS990ScheduleA/PublicSupportTotal170Amt088100
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt016153
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt022139
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt018084
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt017904
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt013820
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt088100
IRS990ScheduleA/TotalSupportAmt090822
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0CASH CONTRIBUTION: 12,855
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1EXPENSES BANK FEES 341 TOTAL 341
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2UNREALIZED GAIN ON INVESTMENTS 316
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3MARKETABLE SECURITIES 10,018 12,464 TOTAL 10,018 12,464
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 10
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART I, LINE 20
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART II, LINE 24
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0JERRY FRANKLIN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum08606732706
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-04-22
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ALEXANDER FRANKLIN CHARITABLE FDN
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/PreparerFirmGrp/PreparerFirmEIN0581972715
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0OLLIFF & FORDHAM CPAS PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt03 NORTH BROAD STREET PO BOX 537
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0METTER
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0GA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd030439
ReturnHeader/PreparerPersonGrp/PhoneNum09126856850
ReturnHeader/PreparerPersonGrp/PreparationDt02021-05-06
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0J DALE FORDHAM
ReturnHeader/ReturnTs02021-05-06T15:36:30-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0JERRY
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0FRANKLIN
ReturnHeader/TaxPeriodBeginDt02020-01-01
ReturnHeader/TaxPeriodEndDt02020-12-31
ReturnHeader/TaxYr02020

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$30,996
Liabilities
-
Net assets
$30,996
Revenue
$16,945
Expenses
$13,196
Net income
$3,749
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
2020Detailed filing. Detailed filing data is available for this year.$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
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$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