Civic Intelligence

Marlborough Rotary Charitable Endowment Inc

990EZ • Fiscal year 2017 • EIN 04-3424082

Jul 01, 2016 to Jun 30, 2017 • Filed on Nov 07, 2017

CO R Turner 254 Vega RoadMarlborough, MA 01752

(508) 485-4290

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

54th percentile

5.3%

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

53rd percentile

4.0%

Faster asset growth than 53% of similar nonprofits.

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

Revenue Growth

28th percentile

-15%

Faster revenue growth than 28% of similar nonprofits.

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

Assets

Up

$127,389

Up $4,950 (+4.0%) from 2016

Net Assets

Up

$127,389

Up $4,950 (+4.0%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue

Down

$21,007

Down $3,644 (-15%) from 2016

Expenses

Down

$19,903

Down $3,220 (-14%) from 2016

Net Income

Down

$1,104

Down $424 (-28%) from 2016

Historical Trend

Balance Sheet Trend

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

$300K$200K$100K$0Assets 2010: $86,482Net Assets 2010: $86,4822010Assets 2015: $98,296Liabilities 2015: $0Net Assets 2015: $98,2962015Assets 2016: $122,439Liabilities 2016: $0Net Assets 2016: $122,4392016Assets 2017: $127,389Liabilities 2017: $0Net Assets 2017: $127,3892017Assets 2018: $144,092Liabilities 2018: $0Net Assets 2018: $144,0922018Assets 2019: $159,917Liabilities 2019: $0Net Assets 2019: $159,9172019Assets 2020: $176,099Liabilities 2020: $0Net Assets 2020: $176,0992020Assets 2021: $184,748Liabilities 2021: $0Net Assets 2021: $184,7482021Assets 2022: $184,456Liabilities 2022: $0Net Assets 2022: $184,4562022Assets 2023: $216,399Liabilities 2023: $0Net Assets 2023: $216,3992023Assets 2024: $243,816Net Assets 2024: $243,8162024Assets 2025: $284,276Net Assets 2025: $284,2762025

Highlighted filing

2017

Assets$127,389
Liabilities$0
Net Assets$127,389

Operations Trend

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

$100K$50K$0-$50KRevenue 2010: $19,061Expenses 2010: $14,098Net Income 2010: $4,9632010Revenue 2015: $19,049Expenses 2015: $32,155Net Income 2015: -$13,1062015Revenue 2016: $24,651Expenses 2016: $23,123Net Income 2016: $1,5282016Revenue 2017: $21,007Expenses 2017: $19,903Net Income 2017: $1,1042017Revenue 2018: $32,390Expenses 2018: $15,687Net Income 2018: $16,7032018Revenue 2019: $32,550Expenses 2019: $16,725Net Income 2019: $15,8252019Revenue 2020: $33,651Expenses 2020: $17,469Net Income 2020: $16,1822020Revenue 2021: $30,961Expenses 2021: $22,312Net Income 2021: $8,6492021Revenue 2022: $93,194Expenses 2022: $29,954Net Income 2022: $63,2402022Revenue 2023: $74,101Expenses 2023: $42,158Net Income 2023: $31,9432023Revenue 2024: $65,272Expenses 2024: $67,572Net Income 2024: -$2,3002024Revenue 2025: $65,123Expenses 2025: $37,102Net Income 2025: $28,0212025

Highlighted filing

2017

Revenue$21,007
Expenses$19,903
Net Income$1,104
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Signed
Nov 7, 2017
Return Version
2016v3.0
Gross Receipts
$64,298
Mission and Program Overview

Mission

Community Service\Local Charitable Giving

Program Services

DescriptionGrantsExpenses
ALL MONIES RAISED FROM FUND RAISERS WAS USED FOR SCHOLARSHIPS AND LOCAL CHARITABLE GIVING-$19,903
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
PEG SHELDONPresidentPT$0--
AARON AYKANIANSecretaryPT$0--
ROBERT TURNERAsst. Treasurer-$0--
MATTHEW MCCOOKTreasurerPT$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Turkey shoot raffle$24,644$24,644$9,077$15,567
Italian Night$6,896$6,896$2,672$4,224
Total Events$31,540$31,540$11,749$19,791
Filing and Contact Details

Filer

Filer Name
Marlborough Rotary Charitable Endowment Inc
EIN
04-3424082
Phone
5084854290
Address
CO R Turner 254 Vega Road, Marlborough, MA 01752

Signing Officer

Name
Peg Sheldon
Title
President
Phone
5084854290
Signed
2017-11-07
Discuss with paid preparer
Yes

Preparer

Firm
Turner & Costa PC
Address
190 Littleton Rd, Westford, MA 01886
Preparer
Robert M Turner
Phone
9786923291
Supplemental Narrative

Additional Explanations

Form 990EZ, Part I, Line 16

Scholarships 5000.

Form 990EZ, Part I, Line 16

Donations 7498.

Form 990EZ, Part I, Line 16

Rotary Youth Leadership 2400.

Form 990EZ, Part I, Line 16

Exhange student program 350.

Form 990EZ, Part I, Line 16

Marlborough Community Development 2000.

Form 990EZ, Part I, Line 16

The Rotary Foundtion 1700.

Form 990EZ, Part I, Line 16

MHS Interact 500.

Form 990EZ, Part I, Line 20

Prior year unrecorded investment gains 3846.

Form 990EZ, Part II, Line 24

Investments

Raw XML Appendix189 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/PersonNm0MATTHEW MCCOOK
IRS990EZ/BooksInCareOfDetail/PhoneNum05082811090
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0Main Street
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Marlboro
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MA
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd001752
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0122439
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0127389
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt02196
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt030504
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt01104
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0122439
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0127389
IRS990EZ/FundraisingGrossIncomeAmt034838
IRS990EZ/GainOrLossFromSaleOfAssetsAmt0-5104
IRS990EZ/GamingGrossIncomeAmt00
IRS990EZ/GrossProfitLossSlsOfInvntryAmt00
IRS990EZ/GrossReceiptsAmt064298
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt01864
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt00
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0122439
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0127389
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0122439
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0127389
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt010.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt15.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt22.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt37.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0PEG SHELDON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1AARON AYKANIAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2ROBERT TURNER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3MATTHEW MCCOOK
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0President
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Secretary
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Asst. Treasurer
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Treasurer
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherChangesInNetAssetsAmt03846
IRS990EZ/OtherExpensesTotalAmt019448
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0Community Service\Local Charitable Giving
IRS990EZ/PrintingPublicationsPostageAmt0455
IRS990EZ/ProgramServiceRevenueAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0ALL MONIES RAISED FROM FUND RAISERS WAS USED FOR SCHOLARSHIPS AND LOCAL CHARITABLE GIVING
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt019903
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SaleOfAssetsGrossAmt025400
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt012787
IRS990EZ/SpecialEventsNetIncomeLossAmt022051
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0MA
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt019903
IRS990EZ/TotalProgramServiceExpensesAmt019903
IRS990EZ/TotalRevenueAmt021007
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0www.marlboroughrotary.org
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt02196
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt03721
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt0360
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt04520
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt01150
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt011947
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt00
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt01864
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt0824
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt02200
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt02100
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt02000
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt08988
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt022051
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt020106
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt016689
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt025170
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt030158
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt0114174
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt01864
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt0824
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt02200
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt02100
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt02000
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt08988
IRS990ScheduleA/InvestmentIncomeCYPct00.06650
IRS990ScheduleA/InvestmentIncomePYPct00.08190
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00
IRS990ScheduleA/PublicSupportCY509Pct00.93350
IRS990ScheduleA/PublicSupportPY509Pct00.91810
IRS990ScheduleA/PublicSupportTotal170Amt00
IRS990ScheduleA/PublicSupportTotal509Amt0126121
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt024247
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt023827
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt017049
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt029690
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt031308
IRS990ScheduleA/Total509Grp/TotalAmt0126121
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0135109
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt011749
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0Turkey shoot raffle
IRS990ScheduleG/FundraisingEventInformationGrp/Event2Nm0Italian Night
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt024644
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent2Amt06896
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt031540
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt024644
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent2Amt06896
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt031540
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt019791
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt011749
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt09077
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent2Amt02672
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Scholarships 5000.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Donations 7498.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Rotary Youth Leadership 2400.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Exhange student program 350.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4Marlborough Community Development 2000.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5The Rotary Foundtion 1700.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6MHS Interact 500.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7Prior year unrecorded investment gains 3846.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt8Investments
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7Form 990EZ, Part I, Line 20
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc8Form 990EZ, Part II, Line 24
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0PEG SHELDON
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum05084854290
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-11-07
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Marlborough Rotary Charitable Endowment Inc
ReturnHeader/Filer/BusinessNameControlTxt0MARL
ReturnHeader/Filer/EIN0043424082
ReturnHeader/Filer/PhoneNum05084854290
ReturnHeader/Filer/USAddress/AddressLine1Txt0CO R Turner 254 Vega Road
ReturnHeader/Filer/USAddress/CityNm0Marlborough
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MA
ReturnHeader/Filer/USAddress/ZIPCd001752
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0D4969CE173623B1C58FFCCCD713DA75A44F97D82
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0EC13A38957C873E99F623AE54A5E9176E8483D24
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt071.184.122.43
ReturnHeader/FilingSecurityInformation/IPDt02018-05-08
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0PD
ReturnHeader/FilingSecurityInformation/IPTm018:29:17
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Turner & Costa PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0190 Littleton Rd
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Westford
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd001886
ReturnHeader/PreparerPersonGrp/PhoneNum09786923291
ReturnHeader/PreparerPersonGrp/PreparationDt02018-05-08
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0ROBERT M TURNER
ReturnHeader/ReturnTs02018-05-08T18:29:23-07:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-07-01
ReturnHeader/TaxPeriodEndDt02017-06-30
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings