{"success":true,"data":{"_id":581515861,"filings":[{"Organization":{"value":null,"Person":["PRINCIPAL FINANCIAL GROUP"],"Title":["TRUSTEE"],"Hours":[0],"Total Compensation":[24828],"Direct compensation":[24828],"Other compensation":[0]},"Basic":{"value":null,"mission":"Voluntary employees' beneficiary association providing payment of benefits to members, dependents, and beneficiaries","year":2024,"name":"CITY OF RALEIGH NC MEDICAL AND DENTAL BENFIT","phone":6025620883,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"PRINCIPAL FINANCIAL GROUP","year_formation":2008,"state_legal_domicile":"NC","total_volunteers":null,"tax_period_begin":"2024-08-01T00:00:00","tax_period_end":"2025-07-31T00:00:00","address":"PO BOX 10316, DES MOINES, IA, 50306, USA","city":"DES MOINES","state":"IA","country":"USA","zip_code":50306},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":1,"Number of independent voting members":0,"Number of employees total":0,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":66517487,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":65104260,"Total revenue":{"value":65104260,"PLAN CONTRIBUTIONS":62222962,"PLAN PREMIUMS":428129,"PLAN REBATES":2453169},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":1377569,"Investment income total":1377569,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":35658,"Other total":35658,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":59110389,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":59085561,"Benefits paid to members Total":59085561},"Salaries":{"value":24828,"Current officers":24828,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":0,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":0,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":0,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":59110389,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":33714668,"Non-interest bearing cash":0,"Savings and temp cash investments":33714668,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":33714668,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":1.0,"percentile":0.9996999186356569},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.11135564998118465,"percentile":0.6421473668850153},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":0.5703678925205516,"percentile":0.27967412376757156},"Officer Compensation Ratio":{"score":0.0004200276875186864,"percentile":0.9976293584469612},"Program Expense Growth":{"score":-0.0001309423427558066,"percentile":0.3210524241196023},"Revenue Growth":{"score":0.008175500023506624,"percentile":0.4064525647906366},"Asset Growth":{"score":-0.146403509948167,"percentile":0.07489794150375109},"Independent Voting Board Pct":{"score":0.0,"percentile":0.10798813433961453},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6510305184991904,"percentile":0.7441741962565668}},"source_xml":"202523449349300912_public.xml"},{"Organization":{"value":null,"Person":["PRINCIPAL FINANCIAL GROUP"],"Title":["TRUSTEE"],"Hours":[1.0],"Total Compensation":[23700],"Direct compensation":[23700],"Other compensation":[0]},"Basic":{"value":null,"mission":"Voluntary employees' beneficiary association","year":2022,"name":"CITY OF RALEIGH NC MEDICAL AND DENTAL BENFIT","phone":6025620883,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"PRINCIPAL FINANCIAL GROUP","year_formation":2008,"state_legal_domicile":"NC","total_volunteers":null,"tax_period_begin":"2022-08-01T00:00:00","tax_period_end":"2023-07-31T00:00:00","address":"PO BOX 10316, DES MOINES, IA, 50306, USA","city":"DES MOINES","state":"IA","country":"USA","zip_code":50306},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":1,"Number of independent voting members":0,"Number of employees total":0,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":71750282,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":70974527,"Total revenue":{"value":70974527,"ER EE CONTRIBUTIONS":69669755,"PREMIUMS":1304772},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":741648,"Investment income total":2666396,"Net investment gain":-1924748,"Income from invest bond proceeds":0},"Other revenues":{"value":34107,"Other total":34107,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":72123961,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":72062969,"Benefits paid to members Total":72062969},"Salaries":{"value":23700,"Current officers":23700,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":37292,"Management services":17469,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":0,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":19823,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":72123961,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":84891034,"Non-interest bearing cash":0,"Savings and temp cash investments":20290023,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":64601011,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":84891034,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":1.0,"percentile":0.9996999186356569},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.00520804921714454,"percentile":0.37200782851293107},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":1.1770156938551948,"percentile":0.47001682814096835},"Officer Compensation Ratio":{"score":0.00032860092085070034,"percentile":0.9979834406731567},"Program Expense Growth":{"score":0.03385519897761906,"percentile":0.46559857275186567},"Revenue Growth":{"score":-0.007708289250238252,"percentile":0.3384659662455125},"Asset Growth":{"score":0.07675040502754457,"percentile":0.6189403074497305},"Independent Voting Board Pct":{"score":0.0,"percentile":0.10798813433961453},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.656843533889282,"percentile":0.7582833154980329}},"source_xml":"202303419349300530_public.xml"},{"Organization":{"value":null,"Person":["PRINCIPAL FINANCIAL GROUP"],"Title":["TRUSTEE"],"Hours":[0],"Total Compensation":[45056],"Direct compensation":[45056],"Other compensation":[0]},"Basic":{"value":null,"mission":"Voluntary employees' beneficiary association providing payment of benefits to members, dependents, and beneficiaries","year":2023,"name":"CITY OF RALEIGH NC MEDICAL AND DENTAL BENFIT","phone":6025620883,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"PRINCIPAL FINANCIAL GROUP","year_formation":2008,"state_legal_domicile":"NC","total_volunteers":null,"tax_period_begin":"2023-08-01T00:00:00","tax_period_end":"2024-07-31T00:00:00","address":"PO BOX 10316, DES MOINES, IA, 50306, USA","city":"DES MOINES","state":"IA","country":"USA","zip_code":50306},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":1,"Number of independent voting members":0,"Number of employees total":0,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":98550536,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":86506450,"Total revenue":{"value":86506450,"PLAN CONTRIBUTIONS":73733781,"PLAN PREMIUMS":2748180,"PLAN REBATES":10024489},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":11888831,"Investment income total":3018770,"Net investment gain":8870061,"Income from invest bond proceeds":0},"Other revenues":{"value":155255,"Other total":155255,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":76014047,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":75940581,"Benefits paid to members Total":75940581},"Salaries":{"value":45056,"Current officers":45056,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":28410,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":0,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":28410,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":75985637,"Management And General Expenses":28410,"Fundraising Expenses":0}},"Assets":{"value":26310428,"Non-interest bearing cash":1375,"Savings and temp cash investments":26309053,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":26310428,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.9996262532897373,"percentile":0.9237450959857572},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.22867951727832309,"percentile":0.7832348519232663},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":0.34612586802541906,"percentile":0.18391357445113524},"Officer Compensation Ratio":{"score":0.0005927325511296616,"percentile":0.9970374306426177},"Program Expense Growth":{"score":0.03754829025643152,"percentile":0.4814361770041328},"Revenue Growth":{"score":0.05571151882409551,"percentile":0.6296136093022917},"Asset Growth":{"score":-0.11428149221988498,"percentile":0.09364008963709201},"Independent Voting Board Pct":{"score":0.0,"percentile":0.10798813433961453},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6867918068250529,"percentile":0.8256661539726057}},"source_xml":"202501779349300535_public.xml"},{"Organization":{"value":null,"Person":["WELLS FARGO BANK NA"],"Title":["TRUSTEE"],"Hours":[1.0],"Total Compensation":[105014],"Direct compensation":[105014],"Other compensation":[0]},"Basic":{"value":null,"mission":"Voluntary employees' beneficiary association","year":2020,"name":"CITY OF RALEIGH NC MEDICAL AND DENTAL BENFIT","phone":8887304933,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"WELLS FARGO BANK","year_formation":2008,"state_legal_domicile":"NC","total_volunteers":null,"tax_period_begin":"2020-08-01T00:00:00","tax_period_end":"2021-07-31T00:00:00","address":"6325 S RAINBOW BLVD STE 300, LAS VEGAS, NV, 89118, USA","city":"LAS VEGAS","state":"NV","country":"USA","zip_code":89118},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":1,"Number of independent voting members":0,"Number of employees total":0,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":80984147,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":72121577,"Total revenue":72121577,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":8844475,"Investment income total":1309117,"Net investment gain":7535358,"Income from invest bond proceeds":0},"Other revenues":{"value":18095,"Other total":18095,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":67346613,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":67217740,"Benefits paid to members Total":67217740},"Salaries":{"value":105014,"Current officers":105014,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":23859,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":0,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":23859,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":67217740,"Management And General Expenses":128873,"Fundraising Expenses":0}},"Assets":{"value":79319627,"Non-interest bearing cash":0,"Savings and temp cash investments":22059089,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":57260538,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":79319627,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.9980864219556224,"percentile":0.9206500285983582},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.168397575392132,"percentile":0.7217223706706716},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":1.1777819769496054,"percentile":0.4702110378620036},"Officer Compensation Ratio":{"score":0.0015593063306687746,"percentile":0.9937994097327192},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":null,"percentile":null},"Asset Growth":{"score":null,"percentile":null},"Independent Voting Board Pct":{"score":0.0,"percentile":0.10798813433961453},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.7747317138901582,"percentile":0.9409427237873579}},"source_xml":"202201649349300890_public.xml"},{"Organization":{"value":null,"Person":["WELLS FARGO BANK NA"],"Title":["TRUSTEE"],"Hours":[1.0],"Total Compensation":[114884],"Direct compensation":[114884],"Other compensation":[0]},"Basic":{"value":null,"mission":"Voluntary employees' beneficiary association","year":2019,"name":"CITY OF RALEIGH NC MEDICAL AND DENTAL BENFIT","phone":8887304933,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"WELLS FARGO BANK","year_formation":2008,"state_legal_domicile":"NC","total_volunteers":null,"tax_period_begin":"2019-08-01T00:00:00","tax_period_end":"2020-07-31T00:00:00","address":"6325 S RAINBOW BLVD STE 300, LAS VEGAS, NV, 89118, USA","city":"LAS VEGAS","state":"NV","country":"USA","zip_code":89118},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":1,"Number of independent voting members":0,"Number of employees total":0,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":71457979,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":69311904,"Total revenue":69311904,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":2135286,"Investment income total":1282735,"Net investment gain":852551,"Income from invest bond proceeds":0},"Other revenues":{"value":10789,"Other total":10789,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":65383747,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":65251796,"Benefits paid to members Total":65251796},"Salaries":{"value":114884,"Current officers":114884,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":17067,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":0,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":17067,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":65268863,"Management And General Expenses":114884,"Fundraising Expenses":0}},"Assets":{"value":65697424,"Non-interest bearing cash":0,"Savings and temp cash investments":19499431,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":46197993,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":65697424,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.9982429272522421,"percentile":0.920937019164928},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.08500425123973909,"percentile":0.5964264220259773},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":1.0047974766573107,"percentile":0.4250777899863366},"Officer Compensation Ratio":{"score":0.0017570727477579406,"percentile":0.9931225021940888},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":null,"percentile":null},"Asset Growth":{"score":null,"percentile":null},"Independent Voting Board Pct":{"score":0.0,"percentile":0.10798813433961453},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.7433687998218349,"percentile":0.909726514948955}},"source_xml":"202003499349300200_public.xml"}],"Latest":{"Organization":{"value":null,"Person":["PRINCIPAL FINANCIAL GROUP"],"Title":["TRUSTEE"],"Hours":[0],"Total Compensation":[24828],"Direct compensation":[24828],"Other compensation":[0]},"Basic":{"value":null,"mission":"Voluntary employees' beneficiary association providing payment of benefits to members, dependents, and beneficiaries","year":2024,"name":"CITY OF RALEIGH NC MEDICAL AND DENTAL BENFIT","phone":6025620883,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"PRINCIPAL FINANCIAL GROUP","year_formation":2008,"state_legal_domicile":"NC","total_volunteers":null,"tax_period_begin":"2024-08-01T00:00:00","tax_period_end":"2025-07-31T00:00:00","address":"PO BOX 10316, DES MOINES, IA, 50306, USA","city":"DES MOINES","state":"IA","country":"USA","zip_code":50306},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":1,"Number of independent voting members":0,"Number of employees total":0,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":66517487,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":65104260,"Total revenue":{"value":65104260,"PLAN CONTRIBUTIONS":62222962,"PLAN PREMIUMS":428129,"PLAN REBATES":2453169},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":1377569,"Investment income total":1377569,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":35658,"Other total":35658,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":59110389,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":59085561,"Benefits paid to members Total":59085561},"Salaries":{"value":24828,"Current officers":24828,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":0,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":0,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":0,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":0,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":59110389,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":33714668,"Non-interest bearing cash":0,"Savings and temp cash investments":33714668,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":33714668,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":1.0,"percentile":0.9996999186356569},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.11135564998118465,"percentile":0.6421473668850153},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":0.5703678925205516,"percentile":0.27967412376757156},"Officer Compensation Ratio":{"score":0.0004200276875186864,"percentile":0.9976293584469612},"Program Expense Growth":{"score":-0.0001309423427558066,"percentile":0.3210524241196023},"Revenue Growth":{"score":0.008175500023506624,"percentile":0.4064525647906366},"Asset Growth":{"score":-0.146403509948167,"percentile":0.07489794150375109},"Independent Voting Board Pct":{"score":0.0,"percentile":0.10798813433961453},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6510305184991904,"percentile":0.7441741962565668}},"source_xml":"202523449349300912_public.xml"},"sector":"","donation_categories":[],"zakat_policy":null},"error":null}