Civic Intelligence

The Ralph E Bates Charitable Foundation

990PF • Fiscal year 2017 • EIN 45-6615332

Jan 01, 2017 to Dec 31, 2017 • Filed on Apr 04, 2018

153 Pine StreetManchester, MA 01944

(978) 526-4151

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.

2017 filings • <$500k nonprofits • Source year 2017

Liabilities / Revenue

57th percentile

0.00x

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

2017 filings • <$500k nonprofits • Source year 2017

Net Margin

99th percentile

98%

Higher net margin than 99% of similar nonprofits.

2017 filings • <$500k nonprofits • Source year 2017

Top Officer Pay

83rd percentile

$0

Higher top officer pay than 83% of similar nonprofits.

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

2017 filings • <$500k nonprofits • Source year 2017

Asset Growth

88th percentile

58%

Faster asset growth than 88% of similar nonprofits.

2017 filings • <$500k nonprofits • Annualized from 2015 to 2017

Revenue Growth

4th percentile

-81%

Faster revenue growth than 4% of similar nonprofits.

2017 filings • <$500k nonprofits • Annualized from 2015 to 2017

Assets

Up

$59,308

Up $35,626 (+150%) from 2015

Net Assets

Up

$59,308

Up $35,626 (+150%) from 2015

Liabilities

Flat

$0

Flat from 2015

Revenue

Down

$50,910

Down $1,319,486 (-96%) from 2015

Expenses

Down

$872

Down $1,468,479 (-100%) from 2015

Net Income

Up

$50,038

Up $148,993 (+151%) from 2015

Historical Trend

Balance Sheet Trend

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

$300K$200K$100K$0Assets 2011: $270,124Liabilities 2011: $02011Assets 2012: $269,753Liabilities 2012: $02012Assets 2013: $203,978Liabilities 2013: $02013Assets 2014: $122,637Liabilities 2014: $0Net Assets 2014: $122,6372014Assets 2015: $23,682Liabilities 2015: $0Net Assets 2015: $23,6822015Assets 2017: $59,308Liabilities 2017: $0Net Assets 2017: $59,3082017Assets 2018: $59,435Liabilities 2018: $0Net Assets 2018: $59,4352018Assets 2019: $9,377Liabilities 2019: $02019Assets 2020: $36,047Liabilities 2020: $0Net Assets 2020: $36,0472020Assets 2021: $46,157Liabilities 2021: $0Net Assets 2021: $46,1572021Assets 2022: $41,557Liabilities 2022: $0Net Assets 2022: $41,5572022Assets 2023: $42,470Liabilities 2023: $0Net Assets 2023: $42,4702023Assets 2024: $51,624Liabilities 2024: $0Net Assets 2024: $51,6242024

Highlighted filing

2017

Assets$59,308
Liabilities$0
Net Assets$59,308

Operations Trend

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

$1.5M$1.0M$500K$0-$500KRevenue 2011: $278,241Expenses 2011: $8,117Net Income 2011: $270,1242011Revenue 2012: $4Expenses 2012: $375Net Income 2012: -$3712012Revenue 2013: -$49,394Expenses 2013: $16,381Net Income 2013: -$65,7752013Revenue 2014: $73,377Expenses 2014: $154,716Net Income 2014: -$81,3392014Revenue 2015: $1,370,396Expenses 2015: $1,469,351Net Income 2015: -$98,9552015Revenue 2017: $50,910Expenses 2017: $872Net Income 2017: $50,0382017Revenue 2018: $941Expenses 2018: $814Net Income 2018: $1272018Revenue 2019: $43,272Expenses 2019: $50,813Net Income 2019: -$7,5412019Revenue 2020: $1,061Expenses 2020: $631Net Income 2020: $4302020Revenue 2021: $1,098Expenses 2021: $1,761Net Income 2021: -$6632021Revenue 2022: $2,029Expenses 2022: $1,131Net Income 2022: $8982022Revenue 2023: $9,961Expenses 2023: $860Net Income 2023: $9,1012023Revenue 2024: $1,594Expenses 2024: $885Net Income 2024: $7092024

Highlighted filing

2017

Revenue$50,910
Expenses$872
Net Income$50,038
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Apr 4, 2018
Return Version
2017v2.2
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
RALPH BATESTrustee-$0--
Filing and Contact Details

Filer

Filer Name
The Ralph E Bates Charitable Foundation
EIN
45-6615332
Phone
9785264151
Address
153 PINE STREET, MANCHESTER, MA 01944

Signing Officer

Name
Ralph Bates
Title
Trustee
Signed
2018-04-04
Discuss with paid preparer
Yes

Preparer

Firm
Tiedemann & Company
Address
1061 Washington Street, West Newton, MA 02465
Preparer
Bruce Tiedemann
Phone
6179641777
Raw XML Appendix187 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
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt0360
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt0360
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt0360
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt0360
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt050550
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsAdjNetIncmAmt0360
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt0360
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt0360
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt050038
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt0872
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0872
IRS990PF/AnalysisOfRevenueAndExpenses/TotalAdjNetIncmAmt0360
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt0872
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt0872
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt0360
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt050910
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt0872
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt0872
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt050038
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt059308
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt09270
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt059308
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/FMVAssetsEOYAmt082308
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt0690
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt0178
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt0178
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt08580
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt059130
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt082130
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt09270
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt059308
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt09270
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt059308
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt082308
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt09270
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt059308
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt09270
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt059308
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt00
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt00
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt00
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt00
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt00.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0RALPH BATES
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0Trustee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0153 PINE STREET
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0MANCHESTER
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0MA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd001944
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt0174328
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt01459242
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt0150000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.775014
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt03.87507
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt038709
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt01295
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt031265
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt03.875068
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt00
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd0false
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/ExcessBusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/MaintainedExpenditureRspnsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProceedsOrNetIncomeInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransactionsFailToQlfyAsExcInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistrIncmSect4942a2NotAppInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0true
IRS990PF/StatementsRegardingActyGrp/Form990TFiledInd0false
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0153 PINE STREET
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0MANCHESTER
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0MA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd001944
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0MA
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0RALPH BATES
IRS990PF/StatementsRegardingActyGrp/PhoneNum09785264151
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SupplementaryInformationGrp/ContributingManagerNm0RALPH BATES
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt0175000
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt01459609
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt0148065
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt01782674
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt0175000
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt01459609
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt0148065
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt01782674
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt01782674
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
TaxesSchedule/TaxesDetail/Amt0872
TaxesSchedule/TaxesDetail/CategoryTxt0INVESTMENT MANAGEMENT FEES
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt0872
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0RALPH BATES
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Trustee
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-04-04
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0THE RALPH E BATES CHARITABLE FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0RALP
ReturnHeader/Filer/EIN0456615332
ReturnHeader/Filer/PhoneNum09785264151
ReturnHeader/Filer/USAddress/AddressLine1Txt0153 PINE STREET
ReturnHeader/Filer/USAddress/CityNm0MANCHESTER
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MA
ReturnHeader/Filer/USAddress/ZIPCd001944
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0043305846
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Tiedemann & Company
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01061 Washington Street
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0West Newton
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd002465
ReturnHeader/PreparerPersonGrp/PhoneNum06179641777
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Bruce Tiedemann
ReturnHeader/ReturnTs02018-04-04T18:03:53-07:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings