{"success":true,"data":{"_id":996062933,"filings":[{"Organization":{"value":null,"Person":["DAVID O'NEAL","YOSHIKO YAMAUCHI","HENRY AQUINO","KEITH HAYASHI","KENT KUDO","PRIMA DONNA TAPAT","JENNIFER TOWNSEND","RICHARD ITO","MARTIN BURKE","SHERI DEFREITAS"],"Title":["PRESIDENT/DIRECTOR","DIRECTOR","DIRECTOR","VP/DIRECTOR","DIRECTOR","DIRECTOR","SECRETARY/DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR"],"Hours":[1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,0],"Direct compensation":[0,0,0,0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide support for charitable and educational purposes and programs in waipahu, hawaii.","year":2020,"name":"WAIPAHU COMMUNITY FOUNDATION C/O BANK OF HAWAII","phone":8086944393,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"BANK OF HAWAII","year_formation":1992,"state_legal_domicile":"HI","total_volunteers":0,"tax_period_begin":"2020-07-01T00:00:00","tax_period_end":"2021-06-30T00:00:00","address":"PO BOX 3170 DEPT 715, HONOLULU, HI, 968023170, USA","city":"HONOLULU","state":"HI","country":"USA","zip_code":968023170},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":11,"Number of independent voting members":11,"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":false,"Premiums Paid":false,"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":205759,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":205759,"Investment income total":50118,"Net investment gain":155641,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"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":168018,"Grant expense":{"value":121802,"Grants to domestic orgs":121802,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":39337,"Current officers":39337,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":6879,"Management services":0,"Legal":0,"Accounting":5906,"Lobbying services":0,"Investment management fees":23,"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":809,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":141,"FOREIGN TAXES WITHHELD":135,"DCCA FEE/ANNUAL REPORT":6},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":142082,"Management And General Expenses":25936,"Fundraising Expenses":0}},"Assets":{"value":2232422,"Non-interest bearing cash":1309,"Savings and temp cash investments":65463,"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":2165650,"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":2232422,"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.8456355866633337,"percentile":0.6866256354071842},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.1834233253466434,"percentile":0.738950927908673},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":13.286802604482853,"percentile":0.9169281559433328},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":null,"percentile":null},"Asset Growth":{"score":null,"percentile":null},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.8028530589869495,"percentile":0.9605600211023836}},"source_xml":"202221179349301307_public.xml"},{"Organization":{"value":null,"Person":["DAVID O'NEAL","HENRY AQUINO","JENNIFER TOWNSEND","RICHARD ITO","SHERI DEFREITAS","ZACHARY SHEETS","KENT KUDO","YOSHIKO YAMAUCHI","BANK OF HAWAII"],"Title":["PRESIDENT/DIRECTOR","VP/DIRECTOR","SECRETARY/DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","TRUSTEE"],"Hours":[0,0,0,0,0,0,0,0,0],"Total Compensation":[0,0,0,0,0,0,0,0,29210],"Direct compensation":[0,0,0,0,0,0,0,0,29210],"Other compensation":[0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide support for charitable and educational purposes and programs in waipahu, hawaii, principally for programs benefiting local schools, programs combating juvenile delinquency (including youth related activities and anti-drug, crime prevention, and recreational programs or activities), health related programs and cultural programs or facilities.","year":2024,"name":"WAIPAHU COMMUNITY FOUNDATION","phone":8086944393,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"BANK OF HAWAII","year_formation":1992,"state_legal_domicile":"HI","total_volunteers":null,"tax_period_begin":"2024-07-01T00:00:00","tax_period_end":"2025-06-30T00:00:00","address":"PO BOX 3170 DEPT 715, HONOLULU, HI, 968023170, USA","city":"HONOLULU","state":"HI","country":"USA","zip_code":968023170},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":10,"Number of independent voting members":10,"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":291504,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":291504,"Investment income total":72017,"Net investment gain":219487,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"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":185471,"Grant expense":{"value":136392,"Grants to domestic orgs":136392,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":29210,"Current officers":29210,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":19869,"Management services":0,"Legal":0,"Accounting":5959,"Lobbying services":0,"Investment management fees":11427,"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":2483},"Functional Expenses":{"value":null,"Program Service Expenses":136392,"Management And General Expenses":49079,"Fundraising Expenses":0}},"Assets":{"value":2282378,"Non-interest bearing cash":2653,"Savings and temp cash investments":37726,"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":2241999,"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":2282378,"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.7353818117118041,"percentile":0.5610621269122634},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.36374457983423897,"percentile":0.8692950975598771},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":12.305848353650974,"percentile":0.9106445317433869},"Officer Compensation Ratio":{"score":0.15749092850095164,"percentile":0.39542389014757656},"Program Expense Growth":{"score":0.00915393338555245,"percentile":0.35934459353505266},"Revenue Growth":{"score":0.11325045557306976,"percentile":0.7915836914809716},"Asset Growth":{"score":-0.0004997775061913476,"percentile":0.3169365937848962},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6894384917271871,"percentile":0.8304469877607376}},"source_xml":"202523179349304527_public.xml"},{"Organization":{"value":null,"Person":["DAVID O'NEAL","HENRY AQUINO","JENNIFER TOWNSEND","RICHARD ITO","SHERI DEFREITAS","ZACHARY SHEETS","KENT KUDO","PRIMA DONNA TAPAT","YOSHIKO YAMAUCHI","BANK OF HAWAII"],"Title":["PRESIDENT/DIRECTOR","VP/DIRECTOR","SECRETARY/DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","TRUSTEE"],"Hours":[1.0,0,0,0,0,0,0,0,0,0],"Total Compensation":[0,0,0,0,0,0,0,0,0,27298],"Direct compensation":[0,0,0,0,0,0,0,0,0,27298],"Other compensation":[0,0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide support for charitable and educational purposes and programs in waipahu, hawaii, principally for programs benefiting local schools, programs combating juvenile delinquency (including youth related activities and anti-drug, crime prevention, and recreational programs or activities), health related programs and cultural programs or facilities.","year":2023,"name":"WAIPAHU COMMUNITY FOUNDATION","phone":8086944393,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"BANK OF HAWAII","year_formation":1992,"state_legal_domicile":"HI","total_volunteers":null,"tax_period_begin":"2023-07-01T00:00:00","tax_period_end":"2024-06-30T00:00:00","address":"PO BOX 3170 DEPT 715, HONOLULU, HI, 968023170, USA","city":"HONOLULU","state":"HI","country":"USA","zip_code":968023170},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":10,"Number of independent voting members":10,"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":230600,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":230600,"Investment income total":67446,"Net investment gain":163154,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"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":211088,"Grant expense":{"value":169567,"Grants to domestic orgs":169567,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":27298,"Current officers":27298,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":14223,"Management services":0,"Legal":0,"Accounting":850,"Lobbying services":0,"Investment management fees":10679,"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":2694},"Functional Expenses":{"value":null,"Program Service Expenses":169567,"Management And General Expenses":41521,"Fundraising Expenses":0}},"Assets":{"value":2165656,"Non-interest bearing cash":0,"Savings and temp cash investments":31546,"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":2134110,"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":2165656,"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.803300045478663,"percentile":0.6296685812797564},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.08461405030355594,"percentile":0.5956957852755397},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":10.259493670886076,"percentile":0.8945445256604394},"Officer Compensation Ratio":{"score":0.12932047297809443,"percentile":0.4638066916168469},"Program Expense Growth":{"score":0.07328922504226913,"percentile":0.6089707720901696},"Revenue Growth":{"score":0.004024187549803437,"percentile":0.3876354304812827},"Asset Growth":{"score":-0.015299050661632571,"percentile":0.26174159834497157},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6545638958628306,"percentile":0.7527435398448479}},"source_xml":"202530499349300108_public.xml"},{"Organization":{"value":null,"Person":["DAVID O'NEAL","HENRY AQUINO","JENNIFER TOWNSEND","RICHARD ITO","KENT KUDO","PRIMA DONNA TAPAT","YOSHIKO YAMAUCHI","SHERI DEFREITAS","BANK OF HAWAII","MERYL MATSUMURA"],"Title":["PRESIDENT/DIRECTOR","VP/DIRECTOR","SECRETARY/DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","TRUSTEE","VP/DIRECTOR"],"Hours":[1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1.0,0.0],"Total Compensation":[0,0,0,0,0,0,0,0,26130,0],"Direct compensation":[0,0,0,0,0,0,0,0,26130,0],"Other compensation":[0,0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide support for charitable and educational purposes and programs in waipahu, hawaii, principally for programs benefiting local schools, programs combating juvenile delinquency (including youth related activities and anti-drug, crime prevention, and recreational programs or activities), health related programs and cultural programs or facilities.","year":2022,"name":"WAIPAHU COMMUNITY FOUNDATION","phone":8086944393,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"BANK OF HAWAII","year_formation":1992,"state_legal_domicile":"HI","total_volunteers":null,"tax_period_begin":"2022-07-01T00:00:00","tax_period_end":"2023-06-30T00:00:00","address":"PO BOX 3170 DEPT 715, HONOLULU, HI, 968023170, USA","city":"HONOLULU","state":"HI","country":"USA","zip_code":968023170},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":10,"Number of independent voting members":10,"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":106447,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":106447,"Investment income total":57263,"Net investment gain":49184,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"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":218962,"Grant expense":{"value":177699,"Grants to domestic orgs":177699,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":26130,"Current officers":26130,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":15133,"Management services":0,"Legal":0,"Accounting":2433,"Lobbying services":0,"Investment management fees":10222,"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":2478},"Functional Expenses":{"value":null,"Program Service Expenses":177699,"Management And General Expenses":41263,"Fundraising Expenses":0}},"Assets":{"value":2139822,"Non-interest bearing cash":0,"Savings and temp cash investments":116128,"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":2023694,"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":2139822,"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.8115517761072698,"percentile":0.6401827072575382},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-1.0570048944545172,"percentile":0.03975499518105831},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":9.772572409824535,"percentile":0.8899168374169582},"Officer Compensation Ratio":{"score":0.11933577515733323,"percentile":0.4917850481576247},"Program Expense Growth":{"score":0.1151724390675054,"percentile":0.704279602159724},"Revenue Growth":{"score":-0.3065393329176673,"percentile":0.045529334790281005},"Asset Growth":{"score":-0.020890661077374556,"percentile":0.2428567463462624},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5452562282482505,"percentile":0.4435002278825442}},"source_xml":"202401359349304930_public.xml"},{"Organization":{"value":null,"Person":["DAVID O'NEAL","YOSHIKO YAMAUCHI","HENRY AQUINO","KENT KUDO","PRIMA DONNA TAPAT","JENNIFER TOWNSEND","RICHARD ITO","SHERI DEFREITAS","MERYL MATSUMURA"],"Title":["PRESIDENT/DIRECTOR","DIRECTOR","VP/DIRECTOR","DIRECTOR","DIRECTOR","SECRETARY/DIRECTOR","DIRECTOR","DIRECTOR","TRUSTEE"],"Hours":[1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1.0],"Total Compensation":[0,0,0,0,0,0,0,0,0],"Direct compensation":[0,0,0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide support for charitable and educational purposes and programs in waipahu, hawaii.","year":2021,"name":"WAIPAHU COMMUNITY FOUNDATION C/O BANK OF HAWAII","phone":8086944393,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"BANK OF HAWAII","year_formation":1992,"state_legal_domicile":"HI","total_volunteers":0,"tax_period_begin":"2021-07-01T00:00:00","tax_period_end":"2022-06-30T00:00:00","address":"PO BOX 3170 DEPT 715, HONOLULU, HI, 968023170, USA","city":"HONOLULU","state":"HI","country":"USA","zip_code":968023170},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":10,"Number of independent voting members":10,"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":false,"Premiums Paid":false,"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":173761,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":173761,"Investment income total":58622,"Net investment gain":115139,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"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":171600,"Grant expense":{"value":123085,"Grants to domestic orgs":123085,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":41898,"Current officers":41898,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":6617,"Management services":0,"Legal":0,"Accounting":4826,"Lobbying services":0,"Investment management fees":8,"Other services":0,"Advertising":0,"Office expenses":900,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":830,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":53,"FOREIGN TAXES WITHHELD":47,"DCCA FEE/ANNUAL REPORT":6},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":144093,"Management And General Expenses":27507,"Fundraising Expenses":0}},"Assets":{"value":2276660,"Non-interest bearing cash":0,"Savings and temp cash investments":168479,"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":2108181,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":33297,"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":33297},"Fund balance":{"value":2243363,"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.8397027972027972,"percentile":0.6781282978740545},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.012436622717410696,"percentile":0.4318138602504871},"Liabilities to Assets Ratio":{"score":0.01462537225584848,"percentile":0.477270771983816},"Operating Reserve Ratio":{"score":13.267249417249417,"percentile":0.9168111450916373},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":null,"percentile":null},"Asset Growth":{"score":null,"percentile":null},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6831322521351578,"percentile":0.8177471605675005}},"source_xml":"202321359349314442_public.xml"}],"Latest":{"Organization":{"value":null,"Person":["DAVID O'NEAL","HENRY AQUINO","JENNIFER TOWNSEND","RICHARD ITO","SHERI DEFREITAS","ZACHARY SHEETS","KENT KUDO","YOSHIKO YAMAUCHI","BANK OF HAWAII"],"Title":["PRESIDENT/DIRECTOR","VP/DIRECTOR","SECRETARY/DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","TRUSTEE"],"Hours":[0,0,0,0,0,0,0,0,0],"Total Compensation":[0,0,0,0,0,0,0,0,29210],"Direct compensation":[0,0,0,0,0,0,0,0,29210],"Other compensation":[0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide support for charitable and educational purposes and programs in waipahu, hawaii, principally for programs benefiting local schools, programs combating juvenile delinquency (including youth related activities and anti-drug, crime prevention, and recreational programs or activities), health related programs and cultural programs or facilities.","year":2024,"name":"WAIPAHU COMMUNITY FOUNDATION","phone":8086944393,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"BANK OF HAWAII","year_formation":1992,"state_legal_domicile":"HI","total_volunteers":null,"tax_period_begin":"2024-07-01T00:00:00","tax_period_end":"2025-06-30T00:00:00","address":"PO BOX 3170 DEPT 715, HONOLULU, HI, 968023170, USA","city":"HONOLULU","state":"HI","country":"USA","zip_code":968023170},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":10,"Number of independent voting members":10,"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":291504,"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":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":291504,"Investment income total":72017,"Net investment gain":219487,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"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":185471,"Grant expense":{"value":136392,"Grants to domestic orgs":136392,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":29210,"Current officers":29210,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":19869,"Management services":0,"Legal":0,"Accounting":5959,"Lobbying services":0,"Investment management fees":11427,"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":2483},"Functional Expenses":{"value":null,"Program Service Expenses":136392,"Management And General Expenses":49079,"Fundraising Expenses":0}},"Assets":{"value":2282378,"Non-interest bearing cash":2653,"Savings and temp cash investments":37726,"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":2241999,"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":2282378,"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.7353818117118041,"percentile":0.5610621269122634},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.36374457983423897,"percentile":0.8692950975598771},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":12.305848353650974,"percentile":0.9106445317433869},"Officer Compensation Ratio":{"score":0.15749092850095164,"percentile":0.39542389014757656},"Program Expense Growth":{"score":0.00915393338555245,"percentile":0.35934459353505266},"Revenue Growth":{"score":0.11325045557306976,"percentile":0.7915836914809716},"Asset Growth":{"score":-0.0004997775061913476,"percentile":0.3169365937848962},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6894384917271871,"percentile":0.8304469877607376}},"source_xml":"202523179349304527_public.xml"},"sector":"Public, Societal Benefit","donation_categories":[],"zakat_policy":null},"error":null}