Civic Intelligence

Josiah a Spaulding Education Fund C/O Kathleen Wilson

990EZ • Fiscal year 2022 • EIN 22-3031985

Jan 01, 2022 to Dec 31, 2022 • Filed on May 05, 2023

Organization ProfileN/A
PO Box 192Manchester, MA 01944

(978) 526-8336

Siviq Scores

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

Liabilities / Assets

82nd percentile

0.15x

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

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

Liabilities / Revenue

98th percentile

3.70x

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

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

Net Margin

81st percentile

34%

Higher net margin than 81% of similar nonprofits.

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

Top Officer Pay

78th percentile

$0

Higher top officer pay than 78% of similar nonprofits.

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

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

Asset Growth

48th percentile

0.0%

Faster asset growth than 48% of similar nonprofits.

2022 filings • 501(c)3 • <$500k nonprofits • Annualized from 2021 to 2022

Revenue Growth

28th percentile

-15%

Faster revenue growth than 28% of similar nonprofits.

2022 filings • 501(c)3 • <$500k nonprofits • Annualized from 2021 to 2022

Balance Sheet
Liabilities / Assets82nd percentile

Assets

Up

$131,601

Up $3 (+0.0%) from 2021

Net Assets

Up

$111,841

Up $1,803 (+1.6%) from 2021

Liabilities

Down

$19,760

Down $1,800 (-8.3%) from 2021

Revenue And Expenses
Liabilities / Revenue98th percentileNet Margin81st percentile

Revenue

Down

$5,334

Down $913 (-15%) from 2021

Expenses

Up

$3,531

Up $1,782 (+102%) from 2021

Net Income

Down

$1,803

Down $2,695 (-60%) from 2021

Historical Trend

Balance Sheet Trend

Asset Growth48th percentile

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

$200K$150K$100K$50K$0Assets 2010: $157,376Net Assets 2010: $157,3762010Assets 2011: $194,654Net Assets 2011: $194,6542011Assets 2012: $122,957Net Assets 2012: $122,9572012Assets 2013: $144,099Net Assets 2013: $144,0992013Assets 2014: $126,191Liabilities 2014: $15,239Net Assets 2014: $110,9522014Assets 2015: $110,899Liabilities 2015: $33,228Net Assets 2015: $77,6712015Assets 2016: $126,166Liabilities 2016: $20,597Net Assets 2016: $105,5692016Assets 2017: $134,301Liabilities 2017: $29,298Net Assets 2017: $105,0032017Assets 2018: $142,622Liabilities 2018: $27,325Net Assets 2018: $115,2972018Assets 2019: $136,429Liabilities 2019: $35,057Net Assets 2019: $101,3722019Assets 2020: $127,100Liabilities 2020: $21,560Net Assets 2020: $105,5402020Assets 2021: $131,598Liabilities 2021: $21,560Net Assets 2021: $110,0382021Assets 2022: $131,601Liabilities 2022: $19,760Net Assets 2022: $111,8412022Assets 2023: $150,266Liabilities 2023: $19,760Net Assets 2023: $130,5062023Assets 2024: $166,590Liabilities 2024: $19,760Net Assets 2024: $146,8302024

Highlighted filing

2022

Assets$131,601
Liabilities$19,760
Net Assets$111,841
Open 2022 Filing

Operations Trend

Revenue Growth28th percentile

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

$150K$100K$50K$0-$50K-$100KRevenue 2010: $49,810Expenses 2010: $76,095Net Income 2010: -$26,2852010Revenue 2011: $87,463Expenses 2011: $50,185Net Income 2011: $37,2782011Revenue 2012: $34,635Expenses 2012: $106,332Net Income 2012: -$71,6972012Revenue 2013: $65,676Expenses 2013: $44,534Net Income 2013: $21,1422013Revenue 2014: $35,451Expenses 2014: $68,598Net Income 2014: -$33,1472014Revenue 2015: $38,694Expenses 2015: $71,975Net Income 2015: -$33,2812015Revenue 2016: $50,023Expenses 2016: $22,125Net Income 2016: $27,8982016Revenue 2017: $50,756Expenses 2017: $51,322Net Income 2017: -$5662017Revenue 2018: $51,332Expenses 2018: $41,038Net Income 2018: $10,2942018Revenue 2019: $28,926Expenses 2019: $42,851Net Income 2019: -$13,9252019Revenue 2020: $6,202Expenses 2020: $2,034Net Income 2020: $4,1682020Revenue 2021: $6,247Expenses 2021: $1,749Net Income 2021: $4,4982021Revenue 2022: $5,334Expenses 2022: $3,531Net Income 2022: $1,8032022Revenue 2023: $24,215Expenses 2023: $5,551Net Income 2023: $18,6642023Revenue 2024: $47,158Expenses 2024: $30,833Net Income 2024: $16,3252024

Highlighted filing

2022

Revenue$5,334
Expenses$3,531
Net Income$1,803
Open 2022 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2022 to Dec 31, 2022
Signed
May 5, 2023
Return Version
2022v5.0
Gross Receipts
$5,334
Mission and Program Overview

Mission

To issue educational scholarships & grants under the name of the trust to further a child's education.

Program Services

DescriptionGrantsExpenses
TO ISSUE EDUCATIONAL SCHOLARSHIPS & GRANTS UNDER THE NAME OF THE TRUST TO FURTHER A CHILD'S EDUCATION.-$2,490
Compensation and Service Providers
Top Officer Pay78th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
SHANNON ERDMANN SHANNON ERDMANNTrustee-$0--
ALISON DALEY ALISON DALEYTrustee-$0--
KATHY WILSON KATHY WILSONTreasurer-$0--
JESSICA LAMOTHE JESSICA LAMOTHETrustee-$0--
Filing and Contact Details

Filer

Filer Name
Josiah a Spaulding Education Fund
EIN
22-3031985
Phone
9785268336
Address
PO BOX 192, MANCHESTER, MA 01944

Signing Officer

Name
Kathy Wilson Kathy Wilson
Title
Treasurer
Phone
9785268336
Signed
2023-05-05

Preparer

Firm
Roy & Rurak LLC
Address
84 PARK ROAD, CHELMSFORD, MA 01824
Preparer
Denise S Roy
Phone
9784096180
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

“Expenses bookkeeping 580 filing fees 35 scholarship paid 1,800 total 2,415”

Form 990-ez, Part II, Line 26

“Grants payable 21,560 19,760”

Form 990-ez, Part III

“To issue educational scholarships & grants under the name of the trust to further a child's education.”

Raw XML Appendix129 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/PersonNm0KATHY WILSON KATHY WILSON
IRS990EZ/BooksInCareOfDetail/PhoneNum09785268336
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt01 MILLETS LANE
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0MANCHESTER
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MA
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd001944
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0131598
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0131601
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt01803
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0800
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0131598
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0131601
IRS990EZ/GrossReceiptsAmt05334
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0179
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0110038
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0111841
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0110038
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0111841
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt3000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0SHANNON ERDMANN SHANNON ERDMANN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1ALISON DALEY ALISON DALEY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2KATHY WILSON KATHY WILSON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3JESSICA LAMOTHE JESSICA LAMOTHE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TRUSTEE
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt02415
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO ISSUE EDUCATIONAL SCHOLARSHIPS & GRANTS UNDER THE NAME OF THE TRUST TO FURTHER A CHILD'S EDUCATION.
IRS990EZ/PrintingPublicationsPostageAmt0316
IRS990EZ/ProgramServiceRevenueAmt05155
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0TO ISSUE EDUCATIONAL SCHOLARSHIPS & GRANTS UNDER THE NAME OF THE TRUST TO FURTHER A CHILD'S EDUCATION.
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt02490
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt021560
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt019760
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt03531
IRS990EZ/TotalProgramServiceExpensesAmt02490
IRS990EZ/TotalRevenueAmt05334
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationAssocInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt05334
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt06247
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt011581
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/InvestmentIncomePYPct00.00000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct01.00000
IRS990ScheduleA/PublicSupportPY509Pct01.00000
IRS990ScheduleA/PublicSupportTotal509Amt011581
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt05334
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt06247
IRS990ScheduleA/Total509Grp/TotalAmt011581
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt05334
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt06247
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt011581
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES BOOKKEEPING 580 FILING FEES 35 SCHOLARSHIP PAID 1,800 TOTAL 2,415
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1GRANTS PAYABLE 21,560 19,760
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2TO ISSUE EDUCATIONAL SCHOLARSHIPS & GRANTS UNDER THE NAME OF THE TRUST TO FURTHER A CHILD'S EDUCATION.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART II, LINE 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART III
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/PersonNm0KATHY WILSON KATHY WILSON
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum09785268336
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-05-05
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0JOSIAH A SPAULDING EDUCATION FUND
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0C/O KATHLEEN WILSON
ReturnHeader/Filer/BusinessNameControlTxt0JOSI
ReturnHeader/Filer/EIN0223031985
ReturnHeader/Filer/PhoneNum09785268336
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 192
ReturnHeader/Filer/USAddress/CityNm0MANCHESTER
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MA
ReturnHeader/Filer/USAddress/ZIPCd001944
ReturnHeader/IRSResponsiblePrtyInfoCurrInd0false
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0043529783
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0ROY & RURAK LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt084 PARK ROAD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0CHELMSFORD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd001824
ReturnHeader/PreparerPersonGrp/PhoneNum09784096180
ReturnHeader/PreparerPersonGrp/PreparationDt02023-05-05
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0DENISE S ROY
ReturnHeader/ReturnTs02023-05-08T07:13:33-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0KATHY A
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0WILSON
ReturnHeader/TaxPeriodBeginDt02022-01-01
ReturnHeader/TaxPeriodEndDt02022-12-31
ReturnHeader/TaxYr02022

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$131,601
Liabilities
$19,760
Net assets
$111,841
Revenue
$5,334
Expenses
$3,531
Net income
$1,803
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$1.67$0.20$1.47$0.47$0.31$0.16
2023Detailed filing. Detailed filing data is available for this year.$1.50$0.20$1.31$0.24$0.06$0.19
2022Detailed filing. Detailed filing data is available for this year.$1.32$0.20$1.12$0.05$0.04$0.02
2021Detailed filing. Detailed filing data is available for this year.$1.32$0.22$1.10$0.06$0.02$0.04
2020Detailed filing. Detailed filing data is available for this year.$1.27$0.22$1.06$0.06$0.02$0.04
2019Detailed filing. Detailed filing data is available for this year.$1.36$0.35$1.01$0.29$0.43$0.14
2018Detailed filing. Detailed filing data is available for this year.$1.43$0.27$1.15$0.51$0.41$0.10
2017Detailed filing. Detailed filing data is available for this year.$1.34$0.29$1.05$0.51$0.51$0.01
2016Detailed filing. Detailed filing data is available for this year.$1.26$0.21$1.06$0.50$0.22$0.28
2015Detailed filing. Detailed filing data is available for this year.$1.11$0.33$0.78$0.39$0.72$0.33
2014Detailed filing. Detailed filing data is available for this year.$1.26$0.15$1.11$0.35$0.69$0.33
2013Detailed filing. Detailed filing data is available for this year.$1.44$1.44$0.66$0.45$0.21
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.23$1.23$0.35$1.06$0.72
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.95$1.95$0.87$0.50$0.37
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.57$1.57$0.50$0.76$0.26
Peer Organizations

Similar nonprofits based on the same Siviq industry and scale cohort. 2022 filings • 501(c)3 • <$500k nonprofits