Civic Intelligence

Cambridge Public Employees Dental and Vision Fund

990 • Fiscal year 2023 • EIN 04-2762048

Jul 01, 2022 to Jun 30, 2023 • Filed on May 07, 2024

125 Cambridge Park Dr 104Cambridge, MA 02140

(617) 354-1110

Siviq Scores

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

Liabilities / Assets

65th percentile

0.07x

Higher debt load relative to assets than 65% of similar nonprofits.

2023 filings • 501(c)9 • $10M-$25M nonprofits • Source year 2023

Liabilities / Revenue

74th percentile

0.13x

Higher debt load relative to revenue than 74% of similar nonprofits.

2023 filings • 501(c)9 • $10M-$25M nonprofits • Source year 2023

Net Margin

75th percentile

17%

Higher net margin than 75% of similar nonprofits.

2023 filings • 501(c)9 • $10M-$25M nonprofits • Source year 2023

Top Officer Pay

52nd percentile

$4,800

Higher top officer pay than 52% of similar nonprofits.

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

2023 filings • 501(c)9 • $10M-$25M nonprofits • Source year 2023

Asset Growth

84th percentile

19%

Faster asset growth than 84% of similar nonprofits.

2023 filings • 501(c)9 • $10M-$25M nonprofits • Annualized from 2022 to 2023

Revenue Growth

40th percentile

1.6%

Faster revenue growth than 40% of similar nonprofits.

2023 filings • 501(c)9 • $10M-$25M nonprofits • Annualized from 2022 to 2023

Assets

Up

$11,761,714

Up $1,893,326 (+19%) from 2022

Net Assets

Up

$10,898,570

Up $1,580,887 (+17%) from 2022

Liabilities

Up

$863,144

Up $312,439 (+57%) from 2022

Revenue

Up

$6,634,738

Up $107,570 (+1.6%) from 2022

Expenses

Up

$5,492,781

Up $297,337 (+5.7%) from 2022

Net Income

Down

$1,141,957

Down $189,767 (-14%) from 2022

Historical Trend

Balance Sheet Trend

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

$15M$10M$5.0M$0Assets 2011: $4,359,903Liabilities 2011: $782,214Net Assets 2011: $3,577,6892011Assets 2012: $5,078,821Liabilities 2012: $505,000Net Assets 2012: $4,573,8212012Assets 2013: $5,634,002Liabilities 2013: $533,000Net Assets 2013: $5,101,0022013Assets 2014: $6,173,966Liabilities 2014: $560,000Net Assets 2014: $5,613,9662014Assets 2015: $6,321,709Liabilities 2015: $561,000Net Assets 2015: $5,760,7092015Assets 2016: $6,183,111Liabilities 2016: $604,000Net Assets 2016: $5,579,1112016Assets 2017: $6,090,796Liabilities 2017: $628,016Net Assets 2017: $5,462,7802017Assets 2018: $5,933,449Liabilities 2018: $615,990Net Assets 2018: $5,317,4592018Assets 2019: $6,227,393Liabilities 2019: $656,733Net Assets 2019: $5,570,6602019Assets 2020: $7,700,083Liabilities 2020: $370,773Net Assets 2020: $7,329,3102020Assets 2021: $9,863,852Liabilities 2021: $572,895Net Assets 2021: $9,290,9572021Assets 2022: $9,868,388Liabilities 2022: $550,705Net Assets 2022: $9,317,6832022Assets 2023: $11,761,714Liabilities 2023: $863,144Net Assets 2023: $10,898,5702023Assets 2024: $13,080,231Liabilities 2024: $945,753Net Assets 2024: $12,134,4782024

Highlighted filing

2023

Assets$11,761,714
Liabilities$863,144
Net Assets$10,898,570

Operations Trend

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

$10M$5.0M$0-$5.0MExpenses 2011: $4,173,4202011Expenses 2012: $3,558,8982012Revenue 2013: $4,560,811Expenses 2013: $4,232,340Net Income 2013: $328,4712013Revenue 2014: $4,604,640Expenses 2014: $4,447,144Net Income 2014: $157,4962014Revenue 2015: $4,610,523Expenses 2015: $4,467,035Net Income 2015: $143,4882015Revenue 2016: $4,546,544Expenses 2016: $4,782,225Net Income 2016: -$235,6812016Revenue 2017: $4,767,039Expenses 2017: $5,012,616Net Income 2017: -$245,5772017Revenue 2018: $5,190,408Expenses 2018: $5,089,468Net Income 2018: $100,9402018Revenue 2019: $5,361,882Expenses 2019: $5,315,639Net Income 2019: $46,2432019Revenue 2020: $5,808,211Expenses 2020: $4,175,475Net Income 2020: $1,632,7362020Revenue 2021: $6,326,439Expenses 2021: $5,270,776Net Income 2021: $1,055,6632021Revenue 2022: $6,527,168Expenses 2022: $5,195,444Net Income 2022: $1,331,7242022Revenue 2023: $6,634,738Expenses 2023: $5,492,781Net Income 2023: $1,141,9572023Revenue 2024: $8,459,144Expenses 2024: $6,061,522Net Income 2024: $2,397,6222024

Highlighted filing

2023

Revenue$6,634,738
Expenses$5,492,781
Net Income$1,141,957
Jump To
Filing Snapshot
Filing Period
Jul 1, 2022 to Jun 30, 2023
Signed
May 7, 2024
Return Version
2022v5.0
Gross Receipts
$6,667,154
Mission and Program Overview

Mission

To provide dental & vision benefits

Balance Sheet Detail
LineBeginningEndChange
Assets
Rtn Earn Endowment Incm Other Fnds$9,317,683$10,898,570▲ $1,580,887
Investments Other Securities$8,427,463$10,052,161▲ $1,624,698
Savings and Temporary Cash Investments$401,870$804,654▲ $402,784
Cash and Non-Interest-Bearing Accounts$898,674$614,749▼ $283,925
Accounts Receivable$62,392$58,855▼ $3,537
Prepaid Expenses and Deferred Charges$66,407$19,042▼ $47,365
Land, Buildings, and Equipment, Net$11,582$7,457▼ $4,125
Pd in Cap Srpls Land Bldg Eqp Fund$0$0→ $0
Cap Stk Tr Prin Current Funds$0$0→ $0
Total Assets$9,868,388$11,761,714▲ $1,893,326
Other Assets Total$0$204,796▲ $204,796
Liabilities
Other Liabilities$550,350$846,811▲ $296,461
Accounts Payable and Accrued Expenses$355$16,333▲ $15,978
Total Liabilities$550,705$863,144▲ $312,439
Net Assets / Fund Balance
Total Net Assets Fund Balance$9,317,683$10,898,570▲ $1,580,887
Total Liabilities and Net Assets / Fund Balance$9,868,388$11,761,714▲ $1,893,326

Asset Categories

AssetBook ValueDepreciationBasis
Equipment$7,457$88,209$95,666
Other Land Buildings$0$12,625$12,625
Other Securities$764,786--
Compensation and Service Providers

Employees

NameTitleBaseTotal
Geraldine HeroldTreasurer$4,800$4,800
Christina GiacobbeTrustee$2,400$2,400
Leonard SilvaTrustee$2,400$2,400
Mary Ellen CampbellTrustee$2,400$2,400
Peter MiliChairperson$2,400$2,400
Robert Travers JrTrustee$2,400$2,400
Sheila Keady-rawsonTrustee$2,200$2,200
Michele KincaidTrustee$2,000$2,000
Ray ClarkTrustee$2,000$2,000
DENNIS O'CONNORTrustee$1,200$1,200

Highest Paid Contractors

ContractorServicesLocationCompensation
Delta DentalBenefit Administration465 MEDFORD STREET, Boston, MA 02129$273,150
Revenue and Support

Revenue Composition

Contributions and Grants
$0
Program Service Revenue
$6,412,952
Investment Income
$221,786
Other Revenue
$0
Change in Net Assets
$1,141,957

Audited Revenue Reconciliation

Revenue per Audited Statements
$6,604,738
Revenue Not Reported on Financial Statements
$30,000
Revenue Not Reported on Form 990
$438,930
Total Revenue per Audited Statements
$7,043,668
Total Revenue per Form 990
$6,634,738
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Other Expenses$236,446
Salaries, Compensation, and Employee Benefits$145,627
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Benefits to Members---$5,110,708
Other Salaries and Wages---$105,660
Fees for Services Other---$93,713
Fees for Service Investment Mgmnt Fees---$30,000
Occupancy---$29,470
Fees for Services Legal---$28,000
Current Officers, Directors, Trustees, and Key Employees---$24,600
Fees for Services Accounting---$16,375
Insurance---$15,806
Payroll Taxes---$9,055
Other Employee Benefits---$6,312
Depreciation Depletion---$4,125
Office Expenses---$3,202
Other Expenses---$1,707
All Other Expenses---$1,654
Total Functional Expenses$0$0$0$5,492,781

Audited Expense Reconciliation

Line ItemAmount
Total Expenses per Form 990$5,492,781
Expenses per Audited Statements$5,370,384
Total Expenses per Audited Statements$5,370,384
Expenses Not Reported on Financial Statements$122,397
Other Expense Adjustments$92,397
Expenses Not Reported on Form 990$0
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
Subject to proxy tax
No
Debt and Bond Financing

Other Reported Liabilities

LiabilityAmount
Benefits Payable$372,547
Ibnr$270,200
Right-of-use Operating Lease Liability$204,064
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
No
Audit committee
Yes
Backup withholding compliance
Yes
Business relationship with 35% controlled entity
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
Yes
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, Part VI, Section A, Line 6

Organized with members who are qualifying public employees.

Form 990, Part VI, Section A, Line 7A

Members elect the trustees

Form 990, Part VI, Section B, Line 11B

Trustees review and approve the form 990 prior to filing.

Form 990, Part VI, Section B, Line 15B

Compensation determined by comparability data.

Form 990, Part VI, Section C, Line 19

AVAILABLE UPON REQUEST

Filing and Contact Details

Filer

Filer Name
Cambridge Public Employees
EIN
04-2762048
Phone
6173541110
Address
125 CAMBRIDGE PARK DR 104, CAMBRIDGE, MA 02140

Signing Officer

Name
Peter Mili
Title
Chairperson
Phone
6173541110
Signed
2024-05-07
Discuss with paid preparer
Yes

Organization Details

Principal Officer
Jill Herold
Formed
1984
Legal Domicile
Ma
Voting Board Members
10
Independent Board Members
10
Employees
2
Volunteers
0

Preparer

Firm
Manzi & Associates LLC
Address
855 TURNPIKE STREET, NORTH ANDOVER, MA 01845
Preparer
Jeannie Mickel
Phone
9789751099
Supplemental Narrative

Additional Explanations

FORM 990, PART XII, LINE 2:

No change in oversight process or selection of independent accountant.

Financial Statement Notes

PART X, LINE 2:

Accounting principles generally accepted in the united states of america require plan management to evaluate tax positions taken by the plan and recognize a tax liability (or asset) if the plan has taken an uncertain position that more likely than not would not be sustained upon examination by the department of labor and internal revenue service. The plan administrator has analyzed the tax positions taken by the plan, and has concluded that as of june 30, 2023, there are no uncertain positions taken or expected to be taken that would require recognition of a liability (or asset) or disclosure in the financial statements.

PART XII, LINE 4B - OTHER ADJUSTMENTS:

Change in benefit payable 54,797. Change in ibnr 37,600.

Raw XML AppendixShowing 400 of 445 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/AccountantCompileOrReviewInd00
IRS990/AccountsPayableAccrExpnssGrp/BOYAmt0355
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt016333
IRS990/AccountsReceivableGrp/BOYAmt062392
IRS990/AccountsReceivableGrp/EOYAmt058855
IRS990/ActivitiesConductedPrtshpInd00
IRS990/ActivityOrMissionDesc0TO PROVIDE DENTAL & VISION BENEFITS
IRS990/AddressChangeInd0X
IRS990/AllOtherExpensesGrp/TotalAmt01654
IRS990/AuditCommitteeInd01
IRS990/BackupWthldComplianceInd01
IRS990/BenefitsToMembersGrp/TotalAmt05110708
IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0GERALDINE HEROLD
IRS990/BooksInCareOfDetail/PhoneNum06173541110
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt0125 CAMBRIDGE PARK DRIVE SUITE 104
IRS990/BooksInCareOfDetail/USAddress/CityNm0CAMBRIDGE
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MA
IRS990/BooksInCareOfDetail/USAddress/ZIPCd002140
IRS990/BusinessRlnWith35CtrlEntInd00
IRS990/BusinessRlnWithFamMemInd00
IRS990/BusinessRlnWithOrgMemInd00
IRS990/CapStkTrPrinCurrentFundsGrp/BOYAmt00
IRS990/CapStkTrPrinCurrentFundsGrp/EOYAmt00
IRS990/CashNonInterestBearingGrp/BOYAmt0898674
IRS990/CashNonInterestBearingGrp/EOYAmt0614749
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt01
IRS990/CollectionsOfArtInd00
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt024600
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd00
IRS990/CompensationProcessOtherInd01
IRS990/ConflictOfInterestPolicyInd00
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContractorCompensationGrp/CompensationAmt0273150
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt0465 MEDFORD STREET
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm0BOSTON
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd0MA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd002129
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt0DELTA DENTAL
IRS990/ContractorCompensationGrp/ServicesDesc0BENEFIT ADMINISTRATION
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt05110708
IRS990/CYContributionsGrantsAmt00
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt0221786
IRS990/CYOtherExpensesAmt0236446
IRS990/CYOtherRevenueAmt00
IRS990/CYProgramServiceRevenueAmt06412952
IRS990/CYRevenuesLessExpensesAmt01141957
IRS990/CYSalariesCompEmpBnftPaidAmt0145627
IRS990/CYTotalExpensesAmt05492781
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt06634738
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DelegationOfMgmtDutiesInd00
IRS990/DepreciationDepletionGrp/TotalAmt04125
IRS990/Desc0TO PROVIDE DENTAL & VISION BENEFITS TO ELIGIBLE PARTICIPANTS AND DEPENDENTS PURSUANT TO THE FUND'S PLAN OF BENEFITS
IRS990/DescribedInSection501c3Ind00
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd00
IRS990/DonorAdvisedFundInd00
IRS990/DonorRstrOrQuasiEndowmentsInd00
IRS990/ElectionOfBoardMembersInd01
IRS990/EmployeeCnt02
IRS990/EmploymentTaxReturnsFiledInd01
IRS990/ExpenseAmt05219631
IRS990/FamilyOrBusinessRlnInd00
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/TotalAmt016375
IRS990/FeesForServicesLegalGrp/TotalAmt028000
IRS990/FeesForServicesOtherGrp/TotalAmt093713
IRS990/FeesForSrvcInvstMgmntFeesGrp/TotalAmt030000
IRS990/ForeignActivitiesInd00
IRS990/ForeignFinancialAccountInd00
IRS990/ForeignOfficeInd00
IRS990/Form8282PropertyDisposedOfInd00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt01.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt11.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt21.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt31.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt41.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt52.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt61.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt71.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt81.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt91.00
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd2X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd3X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd4X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd5X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd6X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd7X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd8X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd9X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt10
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt20
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt30
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt40
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt50
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt60
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt70
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt80
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt90
IRS990/Form990PartVIISectionAGrp/PersonNm0RAY CLARK
IRS990/Form990PartVIISectionAGrp/PersonNm1LEONARD SILVA
IRS990/Form990PartVIISectionAGrp/PersonNm2PETER MILI
IRS990/Form990PartVIISectionAGrp/PersonNm3MARY ELLEN CAMPBELL
IRS990/Form990PartVIISectionAGrp/PersonNm4DENNIS O'CONNOR
IRS990/Form990PartVIISectionAGrp/PersonNm5GERALDINE HEROLD
IRS990/Form990PartVIISectionAGrp/PersonNm6ROBERT TRAVERS JR
IRS990/Form990PartVIISectionAGrp/PersonNm7CHRISTINA GIACOBBE
IRS990/Form990PartVIISectionAGrp/PersonNm8MICHELE KINCAID
IRS990/Form990PartVIISectionAGrp/PersonNm9SHEILA KEADY-RAWSON
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt02000
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt12400
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt22400
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt32400
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt41200
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt54800
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt62400
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt72400
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt82000
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt92200
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt70
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt80
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt90
IRS990/Form990PartVIISectionAGrp/TitleTxt0TRUSTEE
IRS990/Form990PartVIISectionAGrp/TitleTxt1TRUSTEE
IRS990/Form990PartVIISectionAGrp/TitleTxt2CHAIRPERSON
IRS990/Form990PartVIISectionAGrp/TitleTxt3TRUSTEE
IRS990/Form990PartVIISectionAGrp/TitleTxt4TRUSTEE
IRS990/Form990PartVIISectionAGrp/TitleTxt5TREASURER
IRS990/Form990PartVIISectionAGrp/TitleTxt6TRUSTEE
IRS990/Form990PartVIISectionAGrp/TitleTxt7TRUSTEE
IRS990/Form990PartVIISectionAGrp/TitleTxt8TRUSTEE
IRS990/Form990PartVIISectionAGrp/TitleTxt9TRUSTEE
IRS990/Form990ProvidedToGvrnBodyInd01
IRS990/FormationYr01984
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/FSAuditedInd01
IRS990/FundraisingActivitiesInd00
IRS990/GainOrLossGrp/SecuritiesAmt0-2416
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt010
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossAmountSalesAssetsGrp/SecuritiesAmt030000
IRS990/GrossReceiptsAmt06667154
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd01
IRS990/IndependentAuditFinclStmtInd01
IRS990/IndependentVotingMemberCnt010
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIIInd0X
IRS990/InsuranceGrp/TotalAmt015806
IRS990/InvestmentIncomeGrp/ExclusionAmt0224202
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt0224202
IRS990/InvestmentInJointVentureInd00
IRS990/InvestmentsOtherSecuritiesGrp/BOYAmt08427463
IRS990/InvestmentsOtherSecuritiesGrp/EOYAmt010052161
IRS990/IRPDocumentCnt011
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt0100834
IRS990/LandBldgEquipBasisNetGrp/BOYAmt011582
IRS990/LandBldgEquipBasisNetGrp/EOYAmt07457
IRS990/LandBldgEquipCostOrOtherBssAmt0108291
IRS990/LegalDomicileStateCd0MA
IRS990/LessCostOthBasisSalesExpnssGrp/SecuritiesAmt032416
IRS990/LoanOutstandingInd00
IRS990/LocalChaptersInd00
IRS990/MaterialDiversionOrMisuseInd00
IRS990/MembersOrStockholdersInd01
IRS990/MethodOfAccountingAccrualInd0X
IRS990/MinutesOfCommitteesInd01
IRS990/MinutesOfGoverningBodyInd01
IRS990/MissionDesc0TO PROVIDE DENTAL & VISION BENEFITS
IRS990/MoreThan5000KToIndividualsInd00
IRS990/MoreThan5000KToOrgInd00
IRS990/NetAssetsOrFundBalancesBOYAmt09317683
IRS990/NetAssetsOrFundBalancesEOYAmt010898570
IRS990/NetGainOrLossInvestmentsGrp/ExclusionAmt0-2416
IRS990/NetGainOrLossInvestmentsGrp/TotalRevenueColumnAmt0-2416
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NetUnrlzdGainsLossesInvstAmt0438930
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/TotalAmt029470
IRS990/OfficeExpensesGrp/TotalAmt03202
IRS990/OfficerMailingAddressInd00
IRS990/OperateHospitalInd00
IRS990/Organization501cInd0X
IRS990/OrgDoesNotFollowFASB117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt00
IRS990/OtherAssetsTotalGrp/EOYAmt0204796
IRS990/OtherChangesInNetAssetsAmt00
IRS990/OtherEmployeeBenefitsGrp/TotalAmt06312
IRS990/OtherExpensesGrp/Desc0PAYROLL FEES
IRS990/OtherExpensesGrp/Desc1TELEPHONE
IRS990/OtherExpensesGrp/Desc2BANK CHARGES
IRS990/OtherExpensesGrp/Desc3DENTAL AND VISION REFUN
IRS990/OtherExpensesGrp/TotalAmt05983
IRS990/OtherExpensesGrp/TotalAmt14092
IRS990/OtherExpensesGrp/TotalAmt22319
IRS990/OtherExpensesGrp/TotalAmt31707
IRS990/OtherLiabilitiesGrp/BOYAmt0550350
IRS990/OtherLiabilitiesGrp/EOYAmt0846811
IRS990/OtherSalariesAndWagesGrp/TotalAmt0105660
IRS990/PartialLiquidationInd00
IRS990/PayrollTaxesGrp/TotalAmt09055
IRS990/PdInCapSrplsLandBldgEqpFundGrp/BOYAmt00
IRS990/PdInCapSrplsLandBldgEqpFundGrp/EOYAmt00
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt066407
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt019042
IRS990/PrincipalOfficerNm0JILL HEROLD
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0900099
IRS990/ProgramServiceRevenueGrp/BusinessCd1900099
IRS990/ProgramServiceRevenueGrp/Desc0EMPLOYER CONTRIBUTIONS
IRS990/ProgramServiceRevenueGrp/Desc1EMPLOYEE CONTRIBUTIONS
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt05238169
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt11174783
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt05238169
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt11174783
IRS990/ProgSrvcAccomActy2Grp/Desc0ADMINISTRATIVE EXPENSES RELATED TO PROVIDING DENTAL & VISION BENEFITS
IRS990/ProgSrvcAccomActy2Grp/ExpenseAmt0273150
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt04849303
IRS990/PYContributionsGrantsAmt00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt0194763
IRS990/PYOtherExpensesAmt0199330
IRS990/PYOtherRevenueAmt00
IRS990/PYProgramServiceRevenueAmt06332405
IRS990/PYRevenuesLessExpensesAmt01331724
IRS990/PYSalariesCompEmpBnftPaidAmt0146811
IRS990/PYTotalExpensesAmt05195444
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt06527168
IRS990/QuidProQuoContributionsInd00
IRS990/ReconcilationRevenueExpnssAmt01141957
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd01
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd00
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd00
IRS990/RevenueAmt06412952
IRS990/RtnEarnEndowmentIncmOthFndsGrp/BOYAmt09317683
IRS990/RtnEarnEndowmentIncmOthFndsGrp/EOYAmt010898570
IRS990/SavingsAndTempCashInvstGrp/BOYAmt0401870
IRS990/SavingsAndTempCashInvstGrp/EOYAmt0804654
IRS990/ScheduleBRequiredInd00
IRS990ScheduleD/EquipmentGrp/BookValueAmt07457
IRS990ScheduleD/EquipmentGrp/DepreciationAmt088209
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt095666
IRS990ScheduleD/ExpensesNotReportedAmt00
IRS990ScheduleD/ExpensesNotRptFinclStmtAmt0122397
IRS990ScheduleD/ExpensesSubtotalAmt05370384
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/InvestmentExpensesNotIncld2Amt030000
IRS990ScheduleD/InvestmentExpensesNotIncldAmt030000
IRS990ScheduleD/NetUnrealizedGainsInvstAmt0438930
IRS990ScheduleD/OtherExpensesNotIncludedAmt092397
IRS990ScheduleD/OtherLandBuildingsGrp/BookValueAmt00
IRS990ScheduleD/OtherLandBuildingsGrp/DepreciationAmt012625
IRS990ScheduleD/OtherLandBuildingsGrp/OtherCostOrOtherBasisAmt012625
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt0372547
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt1270200
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt2204064
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0BENEFITS PAYABLE
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc1IBNR
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc2RIGHT-OF-USE OPERATING LEASE LIABILITY
IRS990ScheduleD/OtherSecuritiesGrp/BookValueAmt01843818
IRS990ScheduleD/OtherSecuritiesGrp/BookValueAmt12930590
IRS990ScheduleD/OtherSecuritiesGrp/BookValueAmt21155419
IRS990ScheduleD/OtherSecuritiesGrp/BookValueAmt31815009
IRS990ScheduleD/OtherSecuritiesGrp/BookValueAmt41542539
IRS990ScheduleD/OtherSecuritiesGrp/BookValueAmt5764786
IRS990ScheduleD/OtherSecuritiesGrp/Desc0TOTAL INTERNATIONAL STOCK INDEX ADMIRAL
IRS990ScheduleD/OtherSecuritiesGrp/Desc1TOTAL STOCK MARKET INDEX ADMIRAL
IRS990ScheduleD/OtherSecuritiesGrp/Desc2INTERMEDIATE-TERM INVESTMENT GROUP
IRS990ScheduleD/OtherSecuritiesGrp/Desc3TOTAL BOND MARKET INDEX ADMIRAL
IRS990ScheduleD/OtherSecuritiesGrp/Desc4TOTAL INTERNATIONAL BOND INDEX ADMIRA
IRS990ScheduleD/OtherSecuritiesGrp/Desc5SHORT-TERM INVESTMENT GRADE
IRS990ScheduleD/OtherSecuritiesGrp/MethodValuationCd0F
IRS990ScheduleD/OtherSecuritiesGrp/MethodValuationCd1F
IRS990ScheduleD/OtherSecuritiesGrp/MethodValuationCd2F
IRS990ScheduleD/OtherSecuritiesGrp/MethodValuationCd3F
IRS990ScheduleD/OtherSecuritiesGrp/MethodValuationCd4F
IRS990ScheduleD/OtherSecuritiesGrp/MethodValuationCd5F
IRS990ScheduleD/RevenueNotReportedAmt0438930
IRS990ScheduleD/RevenueNotReportedFinclStmtAmt030000
IRS990ScheduleD/RevenueSubtotalAmt06604738
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0ACCOUNTING PRINCIPLES GENERALLY ACCEPTED IN THE UNITED STATES OF AMERICA REQUIRE PLAN MANAGEMENT TO EVALUATE TAX POSITIONS TAKEN BY THE PLAN AND RECOGNIZE A TAX LIABILITY (OR ASSET) IF THE PLAN HAS TAKEN AN UNCERTAIN POSITION THAT MORE LIKELY THAN NOT WOULD NOT BE SUSTAINED UPON EXAMINATION BY THE DEPARTMENT OF LABOR AND INTERNAL REVENUE SERVICE. THE PLAN ADMINISTRATOR HAS ANALYZED THE TAX POSITIONS TAKEN BY THE PLAN, AND HAS CONCLUDED THAT AS OF JUNE 30, 2023, THERE ARE NO UNCERTAIN POSITIONS TAKEN OR EXPECTED TO BE TAKEN THAT WOULD REQUIRE RECOGNITION OF A LIABILITY (OR ASSET) OR DISCLOSURE IN THE FINANCIAL STATEMENTS.
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt1CHANGE IN BENEFIT PAYABLE 54,797. CHANGE IN IBNR 37,600.
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0PART X, LINE 2:
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc1PART XII, LINE 4B - OTHER ADJUSTMENTS:
IRS990ScheduleD/TotalBookValueLandBuildingsAmt07457
IRS990ScheduleD/TotalBookValueSecuritiesAmt010052161
IRS990ScheduleD/TotalExpensesPerForm990Amt05492781
IRS990ScheduleD/TotalLiabilityAmt0846811
IRS990ScheduleD/TotalRevenuePerForm990Amt06634738
IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt07043668
IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt05370384
IRS990/ScheduleJRequiredInd00
IRS990/ScheduleORequiredInd01
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0ORGANIZED WITH MEMBERS WHO ARE QUALIFYING PUBLIC EMPLOYEES.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1MEMBERS ELECT THE TRUSTEES
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2TRUSTEES REVIEW AND APPROVE THE FORM 990 PRIOR TO FILING.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3COMPENSATION DETERMINED BY COMPARABILITY DATA.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4AVAILABLE UPON REQUEST
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5NO CHANGE IN OVERSIGHT PROCESS OR SELECTION OF INDEPENDENT ACCOUNTANT.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990, PART VI, SECTION A, LINE 6
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990, PART VI, SECTION A, LINE 7A
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990, PART VI, SECTION B, LINE 11B
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990, PART VI, SECTION B, LINE 15B
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4FORM 990, PART VI, SECTION C, LINE 19
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5FORM 990, PART XII, LINE 2:
IRS990ScheduleR/AssetExchangeInd00
IRS990ScheduleR/AssetPurchaseFromOtherOrgInd00
IRS990ScheduleR/AssetSaleToOtherOrgInd00
IRS990ScheduleR/DivRelatedOrganizationInd00
IRS990ScheduleR/GiftGrntCapContriFromOthOrgInd00
IRS990ScheduleR/GiftGrntOrCapContriToOthOrgInd00
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine1Txt0CITY OF CAMBRIDGE
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine1Txt1CAMBRIDGE RETIREMENT BOARD
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine1Txt2CAMBRIDGE HEALTH ALLIANCE
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine1Txt3CAMBRIDGE SCHOOL DEPARTMENT
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/LegalDomicileStateCd0MA
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/LegalDomicileStateCd1MA
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/LegalDomicileStateCd2MA
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/LegalDomicileStateCd3MA
IRS990ScheduleR/LoansOrGuaranteesFromOthOrgInd00
IRS990ScheduleR/LoansOrGuaranteesToOtherOrgInd00
IRS990ScheduleR/PaidEmployeesSharingInd00
IRS990ScheduleR/PerformOfServicesByOtherOrgInd00
IRS990ScheduleR/PerformOfServicesForOthOrgInd00
IRS990ScheduleR/ReceiptOfIntAnntsRntsRyltsInd00
IRS990ScheduleR/ReimbursementPaidByOtherOrgInd00
IRS990ScheduleR/ReimbursementPaidToOtherOrgInd00
IRS990ScheduleR/RentalOfFacilitiesToOthOrgInd00
IRS990ScheduleR/RentalOfFcltsFromOthOrgInd01
IRS990ScheduleR/SharingOfFacilitiesInd00
IRS990ScheduleR/TransferFromOtherOrgInd00
IRS990ScheduleR/TransferToOtherOrgInd00
IRS990/SchoolOperatingInd00
IRS990/SignificantChangeInd00
IRS990/SignificantNewProgramSrvcInd00
IRS990/SubjectToExcsTaxNetInvstIncInd00
IRS990/SubjectToProxyTaxInd00
IRS990/SubjToTaxRmnrtnExPrchtPymtInd00
IRS990/TaxablePartyNotificationInd00
IRS990/TaxExemptBondsInd00
IRS990/TerminateOperationsInd00
IRS990/TotalAssetsBOYAmt09868388
IRS990/TotalAssetsEOYAmt011761714
IRS990/TotalAssetsGrp/BOYAmt09868388
IRS990/TotalAssetsGrp/EOYAmt011761714
IRS990/TotalCompGreaterThan150KInd00
IRS990/TotalEmployeeCnt02
IRS990/TotalFunctionalExpensesGrp/TotalAmt05492781
IRS990/TotalGrossUBIAmt00
IRS990/TotalLiabilitiesBOYAmt0550705
IRS990/TotalLiabilitiesEOYAmt0863144
IRS990/TotalLiabilitiesGrp/BOYAmt0550705
IRS990/TotalLiabilitiesGrp/EOYAmt0863144
IRS990/TotalNetAssetsFundBalanceGrp/BOYAmt09317683
IRS990/TotalNetAssetsFundBalanceGrp/EOYAmt010898570
IRS990/TotalOtherCompensationAmt00
IRS990/TotalProgramServiceExpensesAmt05492781
IRS990/TotalProgramServiceRevenueAmt06412952
IRS990/TotalReportableCompFromOrgAmt024200
IRS990/TotalRevenueGrp/ExclusionAmt0221786
IRS990/TotalRevenueGrp/RelatedOrExemptFuncIncomeAmt06412952
IRS990/TotalRevenueGrp/TotalRevenueColumnAmt06634738
IRS990/TotalRevenueGrp/UnrelatedBusinessRevenueAmt00
IRS990/TotalVolunteersCnt00
IRS990/TotLiabNetAssetsFundBalanceGrp/BOYAmt09868388
IRS990/TotLiabNetAssetsFundBalanceGrp/EOYAmt011761714
IRS990/TotReportableCompRltdOrgAmt00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$13.1$0.95$12.1$8.46$6.06$2.40
2023Detailed filing. Detailed filing data is available for this year.$11.8$0.86$10.9$6.63$5.49$1.14
2022Detailed filing. Detailed filing data is available for this year.$9.87$0.55$9.32$6.53$5.20$1.33
2021Import issue. A filing source exists for this year, but detailed import did not complete cleanly.$9.86$0.57$9.29$6.33$5.27$1.06
2020Detailed filing. Detailed filing data is available for this year.$7.70$0.37$7.33$5.81$4.18$1.63
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$6.23$0.66$5.57$5.36$5.32$0.05
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$5.93$0.62$5.32$5.19$5.09$0.10
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$6.09$0.63$5.46$4.77$5.01$0.25
2016Detailed filing. Detailed filing data is available for this year.$6.18$0.60$5.58$4.55$4.78$0.24
2015XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$6.32$0.56$5.76$4.61$4.47$0.14
2014Detailed filing. Detailed filing data is available for this year.$6.17$0.56$5.61$4.60$4.45$0.16
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$5.63$0.53$5.10$4.56$4.23$0.33
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$5.08$0.51$4.57$3.56
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$4.36$0.78$3.58$4.17