Civic Intelligence

Rachel Branagan Educational Foundation

990EZ • Fiscal year 2017 • EIN 04-3784319

Jan 01, 2017 to Dec 31, 2017 • Filed on Jun 05, 2018

Organization ProfileWWW.RACHELSROOM.ORG
PO Box 624Attleboro, MA 02703

(508) 252-6559

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

1st percentile

-15194%

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

32nd percentile

-7.3%

Faster asset growth than 32% of similar nonprofits.

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

Revenue Growth

36th percentile

-7.7%

Faster revenue growth than 36% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets56th percentile

Assets

Down

$69,258

Down $5,470 (-7.3%) from 2016

Net Assets

Down

$69,258

Down $5,470 (-7.3%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue And Expenses
Liabilities / Revenue56th percentileNet Margin1st percentile

Revenue

Down

$36

Down $3 (-7.7%) from 2016

Expenses

Up

$5,506

Up $1,012 (+23%) from 2016

Net Income

Down

-$5,470

Down $1,015 (-23%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth32nd percentile

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

$100K$50K$0Assets 2010: $81,282Net Assets 2010: $81,2822010Assets 2011: $87,679Net Assets 2011: $87,6792011Assets 2012: $98,486Net Assets 2012: $98,4862012Assets 2013: $92,759Liabilities 2013: $0Net Assets 2013: $92,7592013Assets 2014: $86,587Liabilities 2014: $0Net Assets 2014: $86,5872014Assets 2015: $79,183Liabilities 2015: $0Net Assets 2015: $79,1832015Assets 2016: $74,728Liabilities 2016: $0Net Assets 2016: $74,7282016Assets 2017: $69,258Liabilities 2017: $0Net Assets 2017: $69,2582017Assets 2018: $65,156Liabilities 2018: $0Net Assets 2018: $65,1562018Assets 2019: $62,333Liabilities 2019: $0Net Assets 2019: $62,3332019Assets 2020: $59,534Liabilities 2020: $0Net Assets 2020: $59,5342020Assets 2021: $56,592Liabilities 2021: $0Net Assets 2021: $56,5922021Assets 2022: $54,491Liabilities 2022: $0Net Assets 2022: $54,4912022Assets 2023: $52,699Liabilities 2023: $0Net Assets 2023: $52,6992023Assets 2024: $48,172Net Assets 2024: $48,1722024

Highlighted filing

2017

Assets$69,258
Liabilities$0
Net Assets$69,258
Open 2017 Filing

Operations Trend

Revenue Growth36th percentile

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

$20K$10K$0-$10KRevenue 2010: $16,592Expenses 2010: $5,615Net Income 2010: $10,9772010Revenue 2011: $13,705Expenses 2011: $6,826Net Income 2011: $6,8792011Revenue 2012: $12,129Expenses 2012: $1,674Net Income 2012: $10,4552012Revenue 2013: $2,969Expenses 2013: $8,697Net Income 2013: -$5,7282013Revenue 2014: $634Expenses 2014: $6,805Net Income 2014: -$6,1712014Revenue 2015: $42Expenses 2015: $7,446Net Income 2015: -$7,4042015Revenue 2016: $39Expenses 2016: $4,494Net Income 2016: -$4,4552016Revenue 2017: $36Expenses 2017: $5,506Net Income 2017: -$5,4702017Revenue 2018: $34Expenses 2018: $4,137Net Income 2018: -$4,1032018Revenue 2019: $562Expenses 2019: $3,384Net Income 2019: -$2,8222019Revenue 2020: $531Expenses 2020: $3,330Net Income 2020: -$2,7992020Revenue 2021: $529Expenses 2021: $3,471Net Income 2021: -$2,9422021Revenue 2022: $528Expenses 2022: $2,630Net Income 2022: -$2,1022022Revenue 2023: $1,777Expenses 2023: $3,568Net Income 2023: -$1,7912023Revenue 2024: $161Expenses 2024: $4,688Net Income 2024: -$4,5272024

Highlighted filing

2017

Revenue$36
Expenses$5,506
Net Income-$5,470
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Jun 5, 2018
Return Version
2017v2.3
Gross Receipts
$36
Mission and Program Overview

Mission

Funds raised through this organization will be used for: build and maintain an outdoor classroom at hyman fine elementary school in attleboro, ma, provide funding for enrichment programs for local elementary schools, and provide scholarships for eligible high school seniors beginning with the class of 2013.

Program Services

DescriptionGrantsExpenses
COMMITTED TO EXPANDING EDUCATIONAL OPPORTUNITIES THROUGH THE FUNDING OF ELEMENTARY ENRICHMENT PROGRAMS AND SCHOLARSHIPS FOR HIGHER EDUCATION.$4,000$4,887
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
BETSY BRANAGANPresident-$0--
ROBERT BRANAGANTreasurer-$0--
JUDITH A LUSKVice Preside-$0--
RHONDA PROKOSSecretary-$0--
KATHLEEN LALLIERDirector-$0--
MARIE MORRELLDirector-$0--
Filing and Contact Details

Filer

Filer Name
Rachel Branagan Educational Foundat
EIN
04-3784319
Phone
5082526559
Address
PO BOX 624, ATTLEBORO, MA 02703

Signing Officer

Name
Robert Branagan
Title
Treasurer
Phone
5082526559
Signed
2018-06-05

Preparer

Firm
COLLINS SMITH & O'CONNOR LLP
Address
77 N MAIN ST, ATTLEBORO, MA 02703-2219
Preparer
Matthew W Harrison CPA Mst
Phone
5082223795
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

“Expenses books 887 taxes 35 total 922”

Form 990-ez, Part III

“Funds raised through this organization will be used for: build and maintain an outdoor classroom at hyman fine elementary school in attleboro, ma, provide funding for enrichment programs for local elementary schools, and provide scholarships for eligible high school seniors beginning with the class of 2013.”

Raw XML Appendix152 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/BusinessName/BusinessNameLine1Txt0ROBERT BRANAGAN
IRS990EZ/BooksInCareOfDetail/PhoneNum05082526559
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0109 SUMMER STREET
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0REHOBOTH
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MA
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd002769
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt074728
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt069258
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-5470
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0450
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt074728
IRS990EZ/Form990TotalAssetsGrp/EOYAmt069258
IRS990EZ/GrantsAndSimilarAmountsPaidAmt04000
IRS990EZ/GrossReceiptsAmt036
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt036
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt074728
IRS990EZ/NetAssetsOrFundBalancesEOYAmt069258
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt074728
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt069258
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt3000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt4000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt5000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0BETSY BRANAGAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1ROBERT BRANAGAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2JUDITH A LUSK
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3RHONDA PROKOS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4KATHLEEN LALLIER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5MARIE MORRELL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2VICE PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5DIRECTOR
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt0922
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0FUNDS RAISED THROUGH THIS ORGANIZATION WILL BE USED FOR: BUILD AND MAINTAIN AN OUTDOOR CLASSROOM AT HYMAN FINE ELEMENTARY SCHOOL IN ATTLEBORO, MA, PROVIDE FUNDING FOR ENRICHMENT PROGRAMS FOR LOCAL ELEMENTARY SCHOOLS, AND PROVIDE SCHOLARSHIPS FOR ELIGIBLE HIGH SCHOOL SENIORS BEGINNING WITH THE CLASS OF 2013.
IRS990EZ/PrintingPublicationsPostageAmt0134
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0COMMITTED TO EXPANDING EDUCATIONAL OPPORTUNITIES THROUGH THE FUNDING OF ELEMENTARY ENRICHMENT PROGRAMS AND SCHOLARSHIPS FOR HIGHER EDUCATION.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt04000
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt04887
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0MA
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt05506
IRS990EZ/TotalProgramServiceExpensesAmt04887
IRS990EZ/TotalRevenueAmt036
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.RACHELSROOM.ORG
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt0600
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt02925
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt03525
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt036
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt039
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt042
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt034
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt044
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt0195
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt036
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt039
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt042
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt034
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt044
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt0195
IRS990ScheduleA/InvestmentIncomeCYPct00.05000
IRS990ScheduleA/InvestmentIncomePYPct00.01000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.94760
IRS990ScheduleA/PublicSupportPY509Pct00.98930
IRS990ScheduleA/PublicSupportTotal509Amt03525
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt0600
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt02925
IRS990ScheduleA/Total509Grp/TotalAmt03525
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt036
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt039
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt042
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt0634
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt02969
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt03720
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES BOOKS 887 TAXES 35 TOTAL 922
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1FUNDS RAISED THROUGH THIS ORGANIZATION WILL BE USED FOR: BUILD AND MAINTAIN AN OUTDOOR CLASSROOM AT HYMAN FINE ELEMENTARY SCHOOL IN ATTLEBORO, MA, PROVIDE FUNDING FOR ENRICHMENT PROGRAMS FOR LOCAL ELEMENTARY SCHOOLS, AND PROVIDE SCHOLARSHIPS FOR ELIGIBLE HIGH SCHOOL SENIORS BEGINNING WITH THE CLASS OF 2013.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART III
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/PersonNm0ROBERT BRANAGAN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum05082526559
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-06-05
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0RACHEL BRANAGAN EDUCATIONAL FOUNDAT
ReturnHeader/Filer/BusinessNameControlTxt0RACH
ReturnHeader/Filer/EIN0043784319
ReturnHeader/Filer/PhoneNum05082526559
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 624
ReturnHeader/Filer/USAddress/CityNm0ATTLEBORO
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MA
ReturnHeader/Filer/USAddress/ZIPCd002703
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0A54311C9E81845C5A152B5409981A2DA40B07888
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId01C9CF1BFF51B54C0D9762FBD20219B33F0E47AA2
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt075.150.84.105
ReturnHeader/FilingSecurityInformation/IPDt02018-06-05
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm007:32:47
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0043256157
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0COLLINS SMITH & O'CONNOR LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt077 N MAIN ST
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0ATTLEBORO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0027032219
ReturnHeader/PreparerPersonGrp/PhoneNum05082223795
ReturnHeader/PreparerPersonGrp/PreparationDt02018-06-05
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0MATTHEW W HARRISON CPA MST
ReturnHeader/ReturnTs02018-06-05T08:32:47-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$69,258
Liabilities
$0
Net assets
$69,258
Revenue
$36
Expenses
$5,506
Net income
-$5,470
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$48.2$48.2$0.16$4.69$4.53
2023Detailed filing. Detailed filing data is available for this year.$52.7$0.00$52.7$1.78$3.57$1.79
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$54.5$0.00$54.5$0.53$2.63$2.10
2021Detailed filing. Detailed filing data is available for this year.$56.6$0.00$56.6$0.53$3.47$2.94
2020Detailed filing. Detailed filing data is available for this year.$59.5$0.00$59.5$0.53$3.33$2.80
2019Detailed filing. Detailed filing data is available for this year.$62.3$0.00$62.3$0.56$3.38$2.82
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$65.2$0.00$65.2$0.03$4.14$4.10
2017Detailed filing. Detailed filing data is available for this year.$69.3$0.00$69.3$0.04$5.51$5.47
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$74.7$0.00$74.7$0.04$4.49$4.46
2015Detailed filing. Detailed filing data is available for this year.$79.2$0.00$79.2$0.04$7.45$7.40
2014Detailed filing. Detailed filing data is available for this year.$86.6$0.00$86.6$0.63$6.81$6.17
2013Import issue. A filing source exists for this year, but detailed import did not complete cleanly.$92.8$0.00$92.8$2.97$8.70$5.73
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$98.5$98.5$12.1$1.67$10.5
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$87.7$87.7$13.7$6.83$6.88
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$81.3$81.3$16.6$5.62$11.0