Civic Intelligence

Nellie L Sparrell Educational Trust

990 • Fiscal year 2017 • EIN 04-6259904

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

PO Box 482Norwell, MA 02061

(781) 659-4553

Siviq Scores

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

Liabilities / Assets

26th percentile

0.00x

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

2017 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2017

Liabilities / Revenue

26th percentile

0.00x

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

2017 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2017

Net Margin

96th percentile

71%

Higher net margin than 96% of similar nonprofits.

2017 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2017

Top Officer Pay

49th percentile

$0

Higher top officer pay than 49% of similar nonprofits.

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

2017 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2017

Asset Growth

63rd percentile

8.6%

Faster asset growth than 63% of similar nonprofits.

2017 filings • 501(c)3 • $500k-$1M nonprofits • Annualized from 2015 to 2017

Revenue Growth

91st percentile

88%

Faster revenue growth than 91% of similar nonprofits.

2017 filings • 501(c)3 • $500k-$1M nonprofits • Annualized from 2015 to 2017

Assets

Up

$572,166

Up $87,231 (+18%) from 2015

Net Assets

$572,166

No earlier filing loaded for comparison.

Liabilities

Flat

$0

Flat from 2015

Revenue

Up

$57,044

Up $40,883 (+253%) from 2015

Expenses

Up

$16,457

Up $2,365 (+17%) from 2015

Net Income

Up

$40,587

Up $38,518 (+1862%) from 2015

Historical Trend

Balance Sheet Trend

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

$1.0M$500K$0Assets 2014: $511,784Liabilities 2014: $02014Assets 2015: $484,935Liabilities 2015: $02015Assets 2017: $572,166Liabilities 2017: $0Net Assets 2017: $572,1662017Assets 2018: $507,124Liabilities 2018: $0Net Assets 2018: $507,1242018Assets 2023: $832,043Liabilities 2023: $0Net Assets 2023: $832,0432023Assets 2024: $947,387Liabilities 2024: $0Net Assets 2024: $947,3872024

Highlighted filing

2017

Assets$572,166
Liabilities$0
Net Assets$572,166

Operations Trend

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

$80K$60K$40K$20K$0Revenue 2014: $36,151Expenses 2014: $14,092Net Income 2014: $22,0592014Revenue 2015: $16,161Expenses 2015: $14,092Net Income 2015: $2,0692015Revenue 2017: $57,044Expenses 2017: $16,457Net Income 2017: $40,5872017Revenue 2018: $40,201Expenses 2018: $20,510Net Income 2018: $19,6912018Revenue 2023: $41,597Expenses 2023: $18,211Net Income 2023: $23,3862023Revenue 2024: $69,183Expenses 2024: $23,195Net Income 2024: $45,9882024

Highlighted filing

2017

Revenue$57,044
Expenses$16,457
Net Income$40,587
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
May 14, 2018
Return Version
2017v2.3
Gross Receipts
$57,044
Mission and Program Overview

Mission

To provide scholarships to local high school graduates.

Balance Sheet Detail
LineBeginningEndChange
Assets
Investments in Publicly Traded Securities$426,950$490,457▲ $63,507
Savings and Temporary Cash Investments$77,721$79,081▲ $1,360
Cash and Non-Interest-Bearing Accounts$2,990$2,628▼ $362
Total Assets$507,661$572,166▲ $64,505
Liabilities
Total Liabilities$0$0→ $0
Net Assets / Fund Balance
Unrestricted Net Assets$507,661$572,166▲ $64,505
Total Net Assets Fund Balance$507,661$572,166▲ $64,505
Total Liabilities and Net Assets / Fund Balance$507,661$572,166▲ $64,505
Compensation and Service Providers

Board Members and Trustees

Revenue and Support

Revenue Composition

Contributions and Grants
$100
Program Service Revenue
$0
Investment Income
$56,944
Other Revenue
$0
All Other Contributions
$100
Change in Net Assets
$40,587
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Other Expenses$16,457
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0
Salaries, Compensation, and Employee Benefits$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Other Expenses$16,000--$16,000
Fees for Services Accounting-$310-$310
Office Expenses-$112-$112
Fees for Services Other-$35-$35
Total Functional Expenses$16,000$457$0$16,457
Fundraising, Events, and Gaming
Fundraising activities
No
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

Line ItemAmount
Professional Fundraising Fees$0
Political and Lobbying Activity
Political campaign activity
No
Lobbying activity
No
Subject to proxy tax
No
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
No
Backup withholding compliance
No
Business relationship with family members
No
Business relationship with organization members
No
Material changes to governing documents
No
Compensation from other sources disclosed
No
CEO compensation reviewed
No
Other officer compensation reviewed
No
Conflict-of-interest policy
No
Audited financial statements prepared
No
Key decisions subject to board approval
No
Management duties delegated
No

Governance Explanations

Form 990, Page 6, Part VI, Line 11B

No review was or will be conducted.

Form 990, Page 6, Part VI, Line 19

No documents available to the public

Filing and Contact Details

Filer

Filer Name
Nellie L Sparrell Educational Trust
EIN
04-6259904
Phone
7816594553
Address
PO BOX 482, NORWELL, MA 02061
Doing Business As
Richard a Merritt

Signing Officer

Name
Richard a Merritt
Title
Treasurer
Phone
7816594553
Signed
2018-05-14
Discuss with paid preparer
Yes

Organization Details

Principal Officer
Wesley H Osborne
Formed
1964
Legal Domicile
Ma
Voting Board Members
4
Independent Board Members
4
Employees
0

Preparer

Firm
South Shore Accounting & Tax Service LLC
Address
183 COLUMBIA RD, HANOVER, MA 02339
Preparer
Thomas J Pugliese
Phone
6176335742
Supplemental Narrative

Additional Explanations

Form 990, Part XI, Line 9

CHANGE IN MARKET VALUE 0

Raw XML Appendix254 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
IRS990/AccountantCompileOrReviewInd0false
IRS990/ActivitiesConductedPrtshpInd0false
IRS990/ActivityOrMissionDesc0TO PROVIDE SCHOLARSHIPS TO LOCAL HIGH SCHOOL GRADUATES.
IRS990/AllOtherContributionsAmt0100
IRS990/BackupWthldComplianceInd0false
IRS990/BooksInCareOfDetail/PersonNm0RICHARD A MERRITT
IRS990/BooksInCareOfDetail/PhoneNum07816594553
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt0363 CROSS ST
IRS990/BooksInCareOfDetail/USAddress/CityNm0NORWELL
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MA
IRS990/BooksInCareOfDetail/USAddress/ZIPCd002061
IRS990/BusinessRlnWithFamMemInd0false
IRS990/BusinessRlnWithOfficerEntInd0false
IRS990/BusinessRlnWithOrgMemInd0false
IRS990/CashNonInterestBearingGrp/BOYAmt02990
IRS990/CashNonInterestBearingGrp/EOYAmt02628
IRS990/ChangeToOrgDocumentsInd0false
IRS990/CollectionsOfArtInd0false
IRS990/CompensationFromOtherSrcsInd0false
IRS990/CompensationProcessCEOInd0false
IRS990/CompensationProcessOtherInd0false
IRS990/ConflictOfInterestPolicyInd0false
IRS990/ConservationEasementsInd0false
IRS990/ConsolidatedAuditFinclStmtInd0false
IRS990/CreditCounselingInd0false
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt0100
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt056944
IRS990/CYOtherExpensesAmt016457
IRS990/CYOtherRevenueAmt00
IRS990/CYProgramServiceRevenueAmt00
IRS990/CYRevenuesLessExpensesAmt040587
IRS990/CYSalariesCompEmpBnftPaidAmt00
IRS990/CYTotalExpensesAmt016457
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt057044
IRS990/DecisionsSubjectToApprovaInd0false
IRS990/DeductibleArtContributionInd0false
IRS990/DeductibleNonCashContriInd0false
IRS990/DelegationOfMgmtDutiesInd0false
IRS990/Desc0AWARD SCHOLARSHIPS TO NORWELL HIGH SCHOOL STUDENTS
IRS990/DescribedInSection501c3Ind0true
IRS990/DisregardedEntityInd0false
IRS990/DocumentRetentionPolicyInd0false
IRS990/DoingBusinessAsName/BusinessNameLine1Txt0RICHARD A MERRITT
IRS990/DonorAdvisedFundInd0false
IRS990/ElectionOfBoardMembersInd0false
IRS990/EmployeeCnt00
IRS990/EngagedInExcessBenefitTransInd0false
IRS990/ExpenseAmt016000
IRS990/FamilyOrBusinessRlnInd0false
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt0310
IRS990/FeesForServicesAccountingGrp/TotalAmt0310
IRS990/FeesForServicesOtherGrp/ManagementAndGeneralAmt035
IRS990/FeesForServicesOtherGrp/TotalAmt035
IRS990/ForeignActivitiesInd0false
IRS990/ForeignFinancialAccountInd0false
IRS990/ForeignOfficeInd0false
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd2X
IRS990/Form990PartVIISectionAGrp/OfficerInd0X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt10
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt20
IRS990/Form990PartVIISectionAGrp/PersonNm0WESLEY H OSBORNE
IRS990/Form990PartVIISectionAGrp/PersonNm1RICHARD A MERRITT
IRS990/Form990PartVIISectionAGrp/PersonNm2SUSAN E CURTAIN
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/TitleTxt0PRES
IRS990/Form990PartVIISectionAGrp/TitleTxt1TREASURER
IRS990/Form990PartVIISectionAGrp/TitleTxt2SECRETARY
IRS990/Form990ProvidedToGvrnBodyInd0false
IRS990/FormationYr01964
IRS990/FormerOfcrEmployeesListedInd0false
IRS990/FSAuditedInd0false
IRS990/FundraisingActivitiesInd0false
IRS990/GainOrLossGrp/OtherAmt030246
IRS990/GamingActivitiesInd0false
IRS990/GoverningBodyVotingMembersCnt04
IRS990/GrantsToIndividualsInd0false
IRS990/GrantsToOrganizationsInd0false
IRS990/GrantToRelatedPersonInd0false
IRS990/GrossAmountSalesAssetsGrp/OtherAmt030246
IRS990/GrossReceiptsAmt057044
IRS990/GroupReturnForAffiliatesInd0false
IRS990/IncludeFIN48FootnoteInd0false
IRS990/IndependentAuditFinclStmtInd0false
IRS990/IndependentVotingMemberCnt04
IRS990/IndoorTanningServicesInd0false
IRS990/InvestmentIncomeGrp/RelatedOrExemptFuncIncomeAmt026698
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt026698
IRS990/InvestmentInJointVentureInd0false
IRS990/InvestmentsPubTradedSecGrp/BOYAmt0426950
IRS990/InvestmentsPubTradedSecGrp/EOYAmt0490457
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LegalDomicileStateCd0MA
IRS990/LoanOutstandingInd0false
IRS990/LobbyingActivitiesInd0false
IRS990/LocalChaptersInd0false
IRS990/MaterialDiversionOrMisuseInd0false
IRS990/MembersOrStockholdersInd0false
IRS990/MethodOfAccountingCashInd0X
IRS990/MinutesOfCommitteesInd0true
IRS990/MinutesOfGoverningBodyInd0true
IRS990/MissionDesc0TO PROVIDE SCHOLARSHIPS TO LOCAL HIGH SCHOOL GRADUATES.
IRS990/MoreThan5000KToIndividualsInd0false
IRS990/MoreThan5000KToOrgInd0false
IRS990/NetAssetsOrFundBalancesBOYAmt0507661
IRS990/NetAssetsOrFundBalancesEOYAmt0572166
IRS990/NetGainOrLossInvestmentsGrp/RelatedOrExemptFuncIncomeAmt030246
IRS990/NetGainOrLossInvestmentsGrp/TotalRevenueColumnAmt030246
IRS990/NetUnrlzdGainsLossesInvstAmt023918
IRS990/NoListedPersonsCompensatedInd0X
IRS990/NondeductibleContributionsInd0false
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt0112
IRS990/OfficeExpensesGrp/TotalAmt0112
IRS990/OfficerMailingAddressInd0false
IRS990/OperateHospitalInd0false
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsSFAS117Ind0X
IRS990/OtherExpensesGrp/Desc0SCHOLARSHIPS PAID
IRS990/OtherExpensesGrp/ProgramServicesAmt016000
IRS990/OtherExpensesGrp/TotalAmt016000
IRS990/PartialLiquidationInd0false
IRS990/PoliticalCampaignActyInd0false
IRS990/PrincipalOfficerNm0WESLEY H OSBORNE
IRS990/ProfessionalFundraisingInd0false
IRS990/ProhibitedTaxShelterTransInd0false
IRS990/PYExcessBenefitTransInd0false
IRS990/PYInvestmentIncomeAmt032783
IRS990/PYOtherExpensesAmt012393
IRS990/PYRevenuesLessExpensesAmt020390
IRS990/PYTotalExpensesAmt012393
IRS990/PYTotalRevenueAmt032783
IRS990/ReconcilationRevenueExpnssAmt040587
IRS990/RelatedEntityInd0false
IRS990/RelatedOrganizationCtrlEntInd0false
IRS990/ReportInvestmentsOtherSecInd0false
IRS990/ReportLandBuildingEquipmentInd0false
IRS990/ReportOtherAssetsInd0false
IRS990/ReportOtherLiabilitiesInd0false
IRS990/ReportProgramRelatedInvstInd0false
IRS990/SavingsAndTempCashInvstGrp/BOYAmt077721
IRS990/SavingsAndTempCashInvstGrp/EOYAmt079081
IRS990ScheduleA/CommunityTrustInd0X
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt0100
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt0100
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus1YearAmt035543
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt016160
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus3YearsAmt036151
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus4YearsAmt024992
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt0112846
IRS990ScheduleA/GrossReceiptsRltdActivitiesAmt026698
IRS990ScheduleA/PrivateFoundation170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.00090
IRS990ScheduleA/PublicSupportTotal170Amt0100
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt0100
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt0100
IRS990ScheduleA/TotalSupportAmt0112946
IRS990/ScheduleBRequiredInd0false
IRS990/ScheduleJRequiredInd0false
IRS990/ScheduleORequiredInd0false
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0NO REVIEW WAS OR WILL BE CONDUCTED.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1NO DOCUMENTS AVAILABLE TO THE PUBLIC
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2CHANGE IN MARKET VALUE 0
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990, PAGE 6, PART VI, LINE 11B
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990, PAGE 6, PART VI, LINE 19
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990, PART XI, LINE 9
IRS990/SchoolOperatingInd0false
IRS990/SignificantChangeInd0false
IRS990/SignificantNewProgramSrvcInd0false
IRS990/SubjectToProxyTaxInd0false
IRS990/TaxablePartyNotificationInd0false
IRS990/TaxExemptBondsInd0false
IRS990/TempOrPermanentEndowmentsInd0false
IRS990/TerminateOperationsInd0false
IRS990/TotalAssetsBOYAmt0507661
IRS990/TotalAssetsEOYAmt0572166
IRS990/TotalAssetsGrp/BOYAmt0507661
IRS990/TotalAssetsGrp/EOYAmt0572166
IRS990/TotalCompGreaterThan150KInd0false
IRS990/TotalContributionsAmt0100
IRS990/TotalEmployeeCnt00
IRS990/TotalFunctionalExpensesGrp/FundraisingAmt00
IRS990/TotalFunctionalExpensesGrp/ManagementAndGeneralAmt0457
IRS990/TotalFunctionalExpensesGrp/ProgramServicesAmt016000
IRS990/TotalFunctionalExpensesGrp/TotalAmt016457
IRS990/TotalGrossUBIAmt00
IRS990/TotalLiabilitiesEOYAmt00
IRS990/TotalLiabilitiesGrp/BOYAmt00
IRS990/TotalLiabilitiesGrp/EOYAmt00
IRS990/TotalNetAssetsFundBalanceGrp/BOYAmt0507661
IRS990/TotalNetAssetsFundBalanceGrp/EOYAmt0572166
IRS990/TotalProgramServiceExpensesAmt016000
IRS990/TotalRevenueGrp/RelatedOrExemptFuncIncomeAmt056944
IRS990/TotalRevenueGrp/TotalRevenueColumnAmt057044
IRS990/TotLiabNetAssetsFundBalanceGrp/BOYAmt0507661
IRS990/TotLiabNetAssetsFundBalanceGrp/EOYAmt0572166
IRS990/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990/TypeOfOrganizationTrustInd0X
IRS990/UnrelatedBusIncmOverLimitInd0false
IRS990/UnrestrictedNetAssetsGrp/BOYAmt0507661
IRS990/UnrestrictedNetAssetsGrp/EOYAmt0572166
IRS990/USAddress/AddressLine1Txt045 HOOP POLE LN
IRS990/USAddress/CityNm0NORWELL
IRS990/USAddress/StateAbbreviationCd0MA
IRS990/USAddress/ZIPCd002061
IRS990/VotingMembersGoverningBodyCnt04
IRS990/VotingMembersIndependentCnt04
IRS990/WhistleblowerPolicyInd0false
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0RICHARD A MERRITT
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum07816594553
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-14
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0NELLIE L SPARRELL EDUCATIONAL TRUST
ReturnHeader/Filer/BusinessNameControlTxt0NELL
ReturnHeader/Filer/EIN0046259904
ReturnHeader/Filer/PhoneNum07816594553
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 482
ReturnHeader/Filer/USAddress/CityNm0NORWELL
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MA
ReturnHeader/Filer/USAddress/ZIPCd002061
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0907090C34A29CA8A65C14DF986E917E145617969
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId01732320ED3813B64B37FEB5E62C280D56B5BD3E0
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt024.60.45.255
ReturnHeader/FilingSecurityInformation/IPDt02018-05-12
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm015:09:20
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0814438141
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0SOUTH SHORE ACCOUNTING & TAX SERVICE LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0183 COLUMBIA RD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0HANOVER
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd002339
ReturnHeader/PreparerPersonGrp/PhoneNum06176335742
ReturnHeader/PreparerPersonGrp/PreparationDt02018-05-11
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0THOMAS J PUGLIESE
ReturnHeader/ReturnTs02018-05-12T16:09:20-04:00
ReturnHeader/ReturnTypeCd0990
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings