Civic Intelligence

Rachel Branagan Educational Foundation

990EZ • Fiscal year 2018 • EIN 04-3784319

Jan 01, 2018 to Dec 31, 2018 • Filed on Oct 01, 2019

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

57th percentile

0.00x

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

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

Liabilities / Revenue

56th percentile

0.00x

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

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

Net Margin

1st percentile

-12068%

Higher net margin than 1% of similar nonprofits.

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

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.

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

Asset Growth

35th percentile

-5.9%

Faster asset growth than 35% of similar nonprofits.

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

Revenue Growth

40th percentile

-5.6%

Faster revenue growth than 40% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets57th percentile

Assets

Down

$65,156

Down $4,102 (-5.9%) from 2017

Net Assets

Down

$65,156

Down $4,102 (-5.9%) from 2017

Liabilities

Flat

$0

Flat from 2017

Revenue And Expenses
Liabilities / Revenue56th percentileNet Margin1st percentile

Revenue

Down

$34

Down $2 (-5.6%) from 2017

Expenses

Down

$4,137

Down $1,369 (-25%) from 2017

Net Income

Up

-$4,103

Up $1,367 (+25%) from 2017

Historical Trend

Balance Sheet Trend

Asset Growth35th 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

2018

Assets$65,156
Liabilities$0
Net Assets$65,156
Open 2018 Filing

Operations Trend

Revenue Growth40th 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

2018

Revenue$34
Expenses$4,137
Net Income-$4,103
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2018 to Dec 31, 2018
Signed
Oct 1, 2019
Return Version
2018v3.1
Gross Receipts
$34
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.$2,000$3,591
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
2019-10-01

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 768 taxes 35 outdoor classroom 823 total 1,626”

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 Appendix150 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/BOYAmt069259
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt065156
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-4103
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0375
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt069259
IRS990EZ/Form990TotalAssetsGrp/EOYAmt065156
IRS990EZ/GrantsAndSimilarAmountsPaidAmt02000
IRS990EZ/GrossReceiptsAmt034
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt034
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt069259
IRS990EZ/NetAssetsOrFundBalancesEOYAmt065156
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt069259
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt065156
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/OtherExpensesTotalAmt01626
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/PrintingPublicationsPostageAmt0136
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0COMMITTED TO EXPANDING EDUCATIONAL OPPORTUNITIES THROUGH THE FUNDING OF ELEMENTARY ENRICHMENT PROGRAMS AND SCHOLARSHIPS FOR HIGHER EDUCATION.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt02000
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt03591
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0MA
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt04137
IRS990EZ/TotalProgramServiceExpensesAmt03591
IRS990EZ/TotalRevenueAmt034
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.RACHELSROOM.ORG
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt0600
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0600
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt034
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt036
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt039
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt042
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt034
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt0185
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt034
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt036
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt039
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt042
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt034
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt0185
IRS990ScheduleA/InvestmentIncomeCYPct00.24000
IRS990ScheduleA/InvestmentIncomePYPct00.05000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.76430
IRS990ScheduleA/PublicSupportPY509Pct00.94760
IRS990ScheduleA/PublicSupportTotal509Amt0600
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt0600
IRS990ScheduleA/Total509Grp/TotalAmt0600
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt034
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt036
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt039
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt042
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt0634
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0785
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES BOOKS 768 TAXES 35 OUTDOOR CLASSROOM 823 TOTAL 1,626
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/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/PersonNm0ROBERT BRANAGAN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum05082526559
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-10-01
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/IPDt02019-10-01
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm008:41:33
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/PreparationDt02019-10-01
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0MATTHEW W HARRISON CPA MST
ReturnHeader/ReturnTs02019-10-01T08:41:33-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02018-01-01
ReturnHeader/TaxPeriodEndDt02018-12-31
ReturnHeader/TaxYr02018

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$65,156
Liabilities
$0
Net assets
$65,156
Revenue
$34
Expenses
$4,137
Net income
-$4,103
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
2018Detailed filing. Detailed filing data is available for this year.$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