{"success":true,"data":{"_id":990048359,"filings":[{"Organization":{"value":null,"Person":["WAYNE MAU","LYNN KINNEY","DON BACHE","ALAN KOBAYASHI","MICHAEL KOGA","DAVID OIFER","PATRICK LEDGERWOOD","WAYNE PARKER","BERT TOBA","TIM DIETRICH","JASON AMOY","NORMAN ASAO"],"Title":["PRESIDENT","2ND VICE PRESIDENT","SECRETARY","TREASURER","VICE PRESIDENT","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","GENERAL MANAGER","COURSE SUPERINTENDENT","EXECUTIVE CHEF"],"Hours":[2.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,40.0,40.0,40.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,183024,142217,117948],"Direct compensation":[0,0,0,0,0,0,0,0,0,167000,124351,103820],"Other compensation":[0,0,0,0,0,0,0,0,0,16024,17866,14128]},"Basic":{"value":null,"mission":"To provide for the recreation and other nonprofitable purposes for the members of the club.","year":2013,"name":"MID PACIFIC COUNTRY CLUB","phone":8082628161,"website":"MPCCHI.ORG","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"WAYNE MAU","year_formation":1926,"state_legal_domicile":"HI","total_volunteers":0,"tax_period_begin":"2013-07-01T00:00:00","tax_period_end":"2014-06-30T00:00:00","address":"266 KAELEPULU DRIVE, KAILUA, HI, 96734, USA","city":"KAILUA","state":"HI","country":"USA","zip_code":96734},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":123,"Total Gross UBI":828124,"Net unrelated business taxable income":0,"Number of employees":123,"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":7501176,"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":5381177,"Total revenue":{"value":5381177,"MEMBERSHIP DUES":3937776,"GOLF OPERATIONS":1427330,"LOCKER ROOMS":16071},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":3635,"Investment income total":3635,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":2116364,"Other total":71375,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":2044989,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":8114708,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":3544472,"Current officers":395171,"Disqualified persons":0,"Other salaries and wages":2346868,"Pension plan contributions":75644,"Other employee benefits":455155,"Payroll taxes":271634},"Other expenses":{"value":4570236,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":172984,"Advertising":0,"Office expenses":56695,"Information technology":0,"Royalties":0,"Occupancy":702746,"Travel":0,"Conferences and meetings":1985,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":887126,"Insurance":177161,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":2362456,"LEASE RENT":1127935,"MISCELLANEOUS":583233,"SUPPLIES":408222,"REPAIRS AND MAINTENANCE":243066},"All other expenses":209083},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":6556465,"Non-interest bearing cash":778384,"Savings and temp cash investments":711851,"Pledges and grants receivable":0,"Accounts receivable":349712,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":208545,"Prepaid expenses deferred charges":217068,"Land, building, equipment":4010437,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":280468},"Liabilities":{"value":6413464,"Sum of Total Liabilities":0,"Accounts payable, accrued":930458,"Grants payable":0,"Deferred, revenue":142210,"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":5340796},"Fund balance":{"value":143001,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":143001,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.08179144176859734,"percentile":0.2429093079045929},"Liabilities to Assets Ratio":{"score":0.9781893139061979,"percentile":0.05459656393541484},"Operating Reserve Ratio":{"score":0.8079730040809848,"percentile":0.3654891548724511},"Officer Compensation Ratio":{"score":0.054615520361299505,"percentile":0.7345418688801771},"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.48392965365045615,"percentile":0.2835192824229664}},"source_xml":"201443259349300329_public.xml"},{"Organization":{"value":null,"Person":["WILLIAM CHRISTENSEN","TED COONS","MICHAEL ROTA","MICHAEL KOGA","JOHN XENAKIS","KENNETH BUNCE","GARY NORTH","TANA-RACHELLE ZIMMER","WAYNE MAU","MARK SOUSA","JASON AMOY","JEFF BONISA","JIM SWIETER","CHRIS MEANS","DREW SCHNELKER"],"Title":["DIRECTOR","SECRETARY","PRESIDENT","DIRECTOR","DIRECTOR","TREASURER","1ST VICE PRESIDENT","2ND VICE PRESIDENT","DIRECTOR","GOLF PRO","COURSE SUPERINTENDENT","EXECUTIVE CHEF","GENERAL MANAGER","DIRECTOR OF FINANCE","DIRECTOR"],"Hours":[1.0,1.0,1.0,1.0,1.0,10.0,1.0,1.0,1.0,40.0,40.0,40.0,40.0,40.0,40.0],"Total Compensation":[0,0,0,0,0,19033,0,0,0,138840,159199,153012,249969,142749,113443],"Direct compensation":[0,0,0,0,0,19033,0,0,0,138840,159199,153012,249969,142749,113443],"Other compensation":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide for the recreation and other nonprofitable purposes for the members of the club.","year":2020,"name":"MID PACIFIC COUNTRY CLUB","phone":8082628161,"website":"MPCCHI.ORG","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RON HAAS","year_formation":1926,"state_legal_domicile":"HI","total_volunteers":0,"tax_period_begin":"2020-07-01T00:00:00","tax_period_end":"2021-06-30T00:00:00","address":"266 KAELEPULU DRIVE, KAILUA, HI, 96734, USA","city":"KAILUA","state":"HI","country":"USA","zip_code":96734},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":9,"Number of independent voting members":8,"Number of employees total":167,"Total Gross UBI":208834,"Net unrelated business taxable income":0,"Number of employees":167,"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":9430357,"Contributions":{"value":10000,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":10000,"Related organizations":0},"Program revenue":{"value":7110418,"Total revenue":{"value":7110418,"MEMBERSHIP DUES":5930617,"GOLF OPERATIONS":1179801},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":28,"Investment income total":28,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":2309911,"Other total":473431,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":1836480,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":7791040,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":3112012,"Current officers":0,"Disqualified persons":843212,"Other salaries and wages":1204397,"Pension plan contributions":75170,"Other employee benefits":673717,"Payroll taxes":315516},"Other expenses":{"value":4679028,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":159242,"Advertising":0,"Office expenses":34749,"Information technology":0,"Royalties":0,"Occupancy":697864,"Travel":0,"Conferences and meetings":75,"Interest":12186,"Payments to affiliates":0,"Depreciation and depletion":436313,"Insurance":159397,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":2780287,"MISCELLANEOUS":1111011,"LEASE RENT & REAL ESTAT":1095174,"SUPPLIES":409578,"REPAIRS AND MAINTENANCE":164524},"All other expenses":398915},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":9777454,"Non-interest bearing cash":890232,"Savings and temp cash investments":1500025,"Pledges and grants receivable":0,"Accounts receivable":1508749,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":192507,"Prepaid expenses deferred charges":161279,"Land, building, equipment":2350226,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":3174436},"Liabilities":{"value":12130883,"Sum of Total Liabilities":0,"Accounts payable, accrued":1430060,"Grants payable":0,"Deferred, revenue":341147,"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":10359676},"Fund balance":{"value":-2353429,"Net assets without donor restriction":-2353429,"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.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.1738340340667909,"percentile":0.7281344469446646},"Liabilities to Assets Ratio":{"score":1.240699572710851,"percentile":0.035536631090091815},"Operating Reserve Ratio":{"score":1.2549613402061857,"percentile":0.4881593708009221},"Officer Compensation Ratio":{"score":0.1253035538259334,"percentile":0.47484526606715255},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.026496980611730784,"percentile":0.4974048469547022},"Asset Growth":{"score":0.13331514695290694,"percentile":0.7538501306623506},"Independent Voting Board Pct":{"score":0.8888888888888888,"percentile":0.2330250129411084},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5168440263084443,"percentile":0.36504803732034125}},"source_xml":"202240329349301549_public.xml"},{"Organization":{"value":null,"Person":["RON HAAS","WILLIAM CHRISTENSEN","WAYNE MAU","GARY NORTH","CASEY PELKEY","JOHN XENAKIS","KENNETH BUNCE","MARK SOUSA","JASON AMOY","JEFF BONISA","TANA-RACHELLE ZIMMER","CANA DAY","CHERYL BETHE","DREW SCHNELKER","PAUL SHAUGHNESSY","SARA PARKER","JIM SWIETER","LANCE UCHIMURA"],"Title":["GENERAL MANAGER","DIRECTOR","SECRETARY","PRESIDENT","DIRECTOR","DIRECTOR","TREASURER","GOLF PRO","COURSE SUPERINTENDENT","EXECUTIVE CHEF","1ST VICE PRESIDENT","2ND VICE PRESIDENT","DIRECTOR OF FINANCE","DIRECTOR","DIRECTOR","ASSISTANT GENERAL MANAGER","FORMER GENERAL MANAGER","DIRECTOR"],"Hours":[40.0,1.0,1.0,1.0,1.0,1.0,10.0,40.0,40.0,40.0,1.0,1.0,40.0,40.0,1.0,40.0,0.0,1.0],"Total Compensation":[0,0,1806,0,0,0,12464,142009,167812,158285,0,0,104508,115792,0,136839,222943,0],"Direct compensation":[0,0,1806,0,0,0,12464,142009,167812,158285,0,0,104508,115792,0,136839,222943,0],"Other compensation":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide for the recreation and other nonprofitable purposes for the members of the club.","year":2021,"name":"MID PACIFIC COUNTRY CLUB","phone":8082628161,"website":"MPCCHI.ORG","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RON HAAS","year_formation":1926,"state_legal_domicile":"HI","total_volunteers":0,"tax_period_begin":"2021-07-01T00:00:00","tax_period_end":"2022-06-30T00:00:00","address":"266 KAELEPULU DRIVE, KAILUA, HI, 96734, USA","city":"KAILUA","state":"HI","country":"USA","zip_code":96734},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":9,"Number of independent voting members":8,"Number of employees total":190,"Total Gross UBI":361467,"Net unrelated business taxable income":24773,"Number of employees":190,"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":10335893,"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":8041949,"Total revenue":{"value":8041949,"MEMBERSHIP DUES":6961504,"GOLF OPERATIONS":1080445},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":1081,"Investment income total":1081,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":2292863,"Other total":495335,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":1797528,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":9580257,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":4524336,"Current officers":0,"Disqualified persons":1047151,"Other salaries and wages":2381081,"Pension plan contributions":103133,"Other employee benefits":623879,"Payroll taxes":369092},"Other expenses":{"value":5055921,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":296789,"Advertising":0,"Office expenses":42630,"Information technology":0,"Royalties":0,"Occupancy":783611,"Travel":0,"Conferences and meetings":3349,"Interest":31108,"Payments to affiliates":0,"Depreciation and depletion":411055,"Insurance":180210,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":2947036,"MISCELLANEOUS":1127518,"LEASE RENT":1016029,"SUPPLIES":588037,"REPAIRS AND MAINTENANCE":215452},"All other expenses":360133},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":11125427,"Non-interest bearing cash":626266,"Savings and temp cash investments":2886642,"Pledges and grants receivable":0,"Accounts receivable":1707181,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":228159,"Prepaid expenses deferred charges":52172,"Land, building, equipment":2368997,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":3256010},"Liabilities":{"value":12749230,"Sum of Total Liabilities":0,"Accounts payable, accrued":1859021,"Grants payable":0,"Deferred, revenue":381025,"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":10509184},"Fund balance":{"value":-1623803,"Net assets without donor restriction":-1623803,"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.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.07310795496818707,"percentile":0.5735753245728934},"Liabilities to Assets Ratio":{"score":1.145954218206636,"percentile":0.03978541802885127},"Operating Reserve Ratio":{"score":1.161286904933761,"percentile":0.4661694143334049},"Officer Compensation Ratio":{"score":0.11090078272430479,"percentile":0.5170772636720915},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.036311009533437105,"percentile":0.545074528584759},"Asset Growth":{"score":0.1054924151817763,"percentile":0.6962729058628299},"Independent Voting Board Pct":{"score":0.8888888888888888,"percentile":0.2330250129411084},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.49056325923153404,"percentile":0.2989063037771307}},"source_xml":"202301289349304475_public.xml"},{"Organization":{"value":null,"Person":["CANA DAY","BENJAMIN SINGER","WAYNE MAU","MICHAEL KOGA","ALAN MAYHACK","BOB CROWLEY","MICHAEL ROUNDS","PAUL SHAUGHNESSY","LANCE UCHIMURA","RON HAAS","JORGE GUTIERREZ","JASON AMOY","SARA PARKER","MARK SOUSA"],"Title":["PRESIDENT","1ST VICE PRESIDENT","2ND VICE PRESIDENT","SECRETARY","TREASURER","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","GENERAL MANAGER","DIRECTOR OF FINANCE","SUPERINTENDENT","ASSISTANT GENERAL MANGER","AMBASSADOR OF ALOHA"],"Hours":[1.0,1.0,1.0,1.0,10.0,1.0,1.0,1.0,1.0,40.0,40.0,40.0,40.0,40.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,334346,179187,192839,163587,136522],"Direct compensation":[0,0,0,0,0,0,0,0,0,300258,171824,166049,142230,117231],"Other compensation":[0,0,0,0,0,0,0,0,0,34088,7363,26790,21357,19291]},"Basic":{"value":null,"mission":"To provide for the recreation and other nonprofitable purposes for the members of the club.","year":2023,"name":"MID PACIFIC COUNTRY CLUB","phone":8086943522,"website":"MPCCHI.ORG","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RON HAAS","year_formation":1926,"state_legal_domicile":"HI","total_volunteers":9,"tax_period_begin":"2023-07-01T00:00:00","tax_period_end":"2024-06-30T00:00:00","address":"266 KAELEPULU DRIVE, KAILUA, HI, 96734, USA","city":"KAILUA","state":"HI","country":"USA","zip_code":96734},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":189,"Total Gross UBI":600278,"Net unrelated business taxable income":107291,"Number of employees":189,"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":12874233,"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":10635487,"Total revenue":{"value":10635487,"MEMBERSHIP DUES":8986542,"GOLF OPERATIONS":1648945},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":117008,"Investment income total":117008,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":2121738,"Other total":110025,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":2011713,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":12003988,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":6264691,"Current officers":442076,"Disqualified persons":0,"Other salaries and wages":4213958,"Pension plan contributions":68585,"Other employee benefits":1059358,"Payroll taxes":480714},"Other expenses":{"value":5739297,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":3475,"Other services":392699,"Advertising":0,"Office expenses":259962,"Information technology":122505,"Royalties":0,"Occupancy":2000707,"Travel":43053,"Conferences and meetings":24591,"Interest":25215,"Payments to affiliates":0,"Depreciation and depletion":581309,"Insurance":233164,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":1474930,"REPAIRS AND MAINTENANCE":418687,"SUPPLIES":401680,"CERTIFICATE PAYMENTS":396000,"GENERAL EXCISE TAXES":258563},"All other expenses":577687},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":15492967,"Non-interest bearing cash":1623242,"Savings and temp cash investments":549614,"Pledges and grants receivable":0,"Accounts receivable":533380,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":390100,"Prepaid expenses deferred charges":264310,"Land, building, equipment":4246552,"Investments publicly traded":1599476,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":6286293},"Liabilities":{"value":15642090,"Sum of Total Liabilities":0,"Accounts payable, accrued":1425888,"Grants payable":0,"Deferred, revenue":424114,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":500916,"Other liabilities":13291172},"Fund balance":{"value":-149123,"Net assets without donor restriction":-149123,"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.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.06759587153658009,"percentile":0.5624451895059774},"Liabilities to Assets Ratio":{"score":1.0096252060693087,"percentile":0.04841634261011778},"Operating Reserve Ratio":{"score":1.290651656766068,"percentile":0.49605184368886107},"Officer Compensation Ratio":{"score":0.08384555199488704,"percentile":0.6095039576625103},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.05376477904999263,"percentile":0.6218422884941169},"Asset Growth":{"score":0.09937854150065781,"percentile":0.681565155809351},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5699451485871032,"percentile":0.5166526244089703}},"source_xml":"202530959349300528_public.xml"},{"Organization":{"value":null,"Person":["STEVE HOLMBERG","SHARLAND CHUN","DWIGHT AKAGI","PETER OSBORNE","GARY FUJITANI","RONALD KOTOSHIRODA","GLENN KOUCHI","NATHAN YOSHIOKA","DAVID YOKOI","TIM DIETRICH","JIM SWIETER","JASON AMOY","TRACY WONG"],"Title":["1ST VICE PRESIDENT","TREASURER","2ND VICE PRESIDENT","DIRECTOR","SECRETARY","DIRECTOR","DIRECTOR","DIRECTOR","PRESIDENT","GENERAL MANAGER","GENERAL MANAGER","COURSE SUPERINTENDENT","MEMBERSHIP SALES DIRECTOR"],"Hours":[1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,2.0,40.0,40.0,40.0,40.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,123865,87965,146349,134883],"Direct compensation":[0,0,0,0,0,0,0,0,0,114927,81908,126720,125073],"Other compensation":[0,0,0,0,0,0,0,0,0,8938,6057,19629,9810]},"Basic":{"value":null,"mission":"To provide for the recreation and other nonprofitable purposes for the members of the club.","year":2016,"name":"MID PACIFIC COUNTRY CLUB","phone":8082628161,"website":"MPCCHI.ORG","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"DAVID YOKOI","year_formation":1926,"state_legal_domicile":"HI","total_volunteers":0,"tax_period_begin":"2016-07-01T00:00:00","tax_period_end":"2017-06-30T00:00:00","address":"266 KAELEPULU DRIVE, KAILUA, HI, 96734, USA","city":"KAILUA","state":"HI","country":"USA","zip_code":96734},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":157,"Total Gross UBI":298285,"Net unrelated business taxable income":0,"Number of employees":157,"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":7715020,"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":5763182,"Total revenue":{"value":5763182,"MEMBERSHIP DUES":4143445,"GOLF OPERATIONS":1336166,"ASSESSMENT":262249,"LOCKER ROOMS":21322},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":-90720,"Investment income total":7,"Net investment gain":-90727,"Income from invest bond proceeds":0},"Other revenues":{"value":2042558,"Other total":176389,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":1866169,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":8868690,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":4095826,"Current officers":448628,"Disqualified persons":0,"Other salaries and wages":2691292,"Pension plan contributions":79926,"Other employee benefits":617369,"Payroll taxes":258611},"Other expenses":{"value":4772864,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":433048,"Advertising":0,"Office expenses":43471,"Information technology":0,"Royalties":0,"Occupancy":698392,"Travel":0,"Conferences and meetings":968,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":747084,"Insurance":181418,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":2566979,"LEASE RENT":1193849,"MISCELLANEOUS":743182,"SUPPLIES":425238,"REPAIRS AND MAINTENANCE":204710},"All other expenses":101504},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":4725051,"Non-interest bearing cash":830858,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":393869,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":152741,"Prepaid expenses deferred charges":263908,"Land, building, equipment":2610219,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":473456},"Liabilities":{"value":7529564,"Sum of Total Liabilities":0,"Accounts payable, accrued":1052309,"Grants payable":0,"Deferred, revenue":489438,"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":5987817},"Fund balance":{"value":-2804513,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":-2804513,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.14953558124282243,"percentile":0.18137705767995013},"Liabilities to Assets Ratio":{"score":1.5935413183900025,"percentile":0.02488946844893672},"Operating Reserve Ratio":{"score":0.5327789109778333,"percentile":0.2645793197162881},"Officer Compensation Ratio":{"score":0.055595809527675455,"percentile":0.7298552853731807},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.0024038964280705243,"percentile":0.3804965548674903},"Asset Growth":{"score":-0.1158705624296148,"percentile":0.09254668084546853},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.42913114142037506,"percentile":0.1714324682729303}},"source_xml":"201831309349304318_public.xml"},{"Organization":{"value":null,"Person":["LANE UCHIMURA","DON ARMSTRONG","TED COONS","MICHAEL ROTA","MICHAEL KOGA","JOHN XENAKIS","KENNETH BUNCE","DARRELL YAMAGATA","GARY NORTH","JIM SWIETER","MARK SOUSA","JASON AMOY","JEFF BONISA","CHRIS MEANS"],"Title":["PRESIDENT","DIRECTOR","SECRETARY","1ST VICE PRESIDENT","DIRECTOR","DIRECTOR","TREASURER","DIRECTOR","2ND VICE PRESIDENT","GENERAL MANAGER","GOLF PRO","COURSE SUPERINTENDENT","EXECUTIVE CHEF","DIRECTOR OF FINANCE"],"Hours":[2.0,1.0,1.0,1.0,1.0,1.0,10.0,1.0,1.0,40.0,40.0,40.0,40.0,40.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,200000,121176,137271,131179,112706],"Direct compensation":[0,0,0,0,0,0,0,0,0,200000,121176,137271,131179,112706],"Other compensation":[0,0,0,0,0,0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide for the recreation and other nonprofitable purposes for the members of the club.","year":2019,"name":"MID PACIFIC COUNTRY CLUB","phone":8082628161,"website":"MPCCHI.ORG","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"LANE UCHIMURA","year_formation":1926,"state_legal_domicile":"HI","total_volunteers":0,"tax_period_begin":"2019-07-01T00:00:00","tax_period_end":"2020-06-30T00:00:00","address":"266 KAELEPULU DRIVE, KAILUA, HI, 96734, USA","city":"KAILUA","state":"HI","country":"USA","zip_code":96734},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":156,"Total Gross UBI":728397,"Net unrelated business taxable income":0,"Number of employees":156,"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":7672857,"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":5747491,"Total revenue":{"value":5747491,"MEMBERSHIP DUES":4784331,"GOLF OPERATIONS":963160},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":4250,"Investment income total":0,"Net investment gain":4250,"Income from invest bond proceeds":0},"Other revenues":{"value":1921116,"Other total":260273,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":1660843,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":8484902,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":4238343,"Current officers":0,"Disqualified persons":702333,"Other salaries and wages":2560160,"Pension plan contributions":68198,"Other employee benefits":626757,"Payroll taxes":280895},"Other expenses":{"value":4246559,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":120302,"Advertising":0,"Office expenses":35573,"Information technology":0,"Royalties":0,"Occupancy":655614,"Travel":0,"Conferences and meetings":7985,"Interest":8948,"Payments to affiliates":0,"Depreciation and depletion":534968,"Insurance":185991,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":2516310,"LEASE RENT":927783,"MISCELLANEOUS":885278,"SUPPLIES":513754,"NON CASH LAND LEASE":189495},"All other expenses":180868},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":9198250,"Non-interest bearing cash":1504168,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":337879,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":213197,"Prepaid expenses deferred charges":240724,"Land, building, equipment":2618329,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":4283953},"Liabilities":{"value":13164986,"Sum of Total Liabilities":0,"Accounts payable, accrued":838277,"Grants payable":0,"Deferred, revenue":776891,"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":11549818},"Fund balance":{"value":-3966736,"Net assets without donor restriction":-3966736,"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.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.10583345942717295,"percentile":0.21742343446555196},"Liabilities to Assets Ratio":{"score":1.431248987579159,"percentile":0.028940994669249286},"Operating Reserve Ratio":{"score":1.0840726268847891,"percentile":0.4465609015211209},"Officer Compensation Ratio":{"score":0.08277432078767674,"percentile":0.6135673564514026},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.015678482831445063,"percentile":0.44279730593465405},"Asset Growth":{"score":0.19148047416958303,"percentile":0.8375340323486393},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.4930406953373003,"percentile":0.30480585187174664}},"source_xml":"202111889349300141_public.xml"},{"Organization":{"value":null,"Person":["STEVE HOLMBERG","DON ARMSTRONG","DWIGHT AKAGI","DAVID YOKOI","GARY FUJITANI","MILES KIMHAN","LANE UCHIMURA","DARRELL YAMAGATA","NATHAN YOSHIOKA","JIM SWIETER","MARK SOUSA","JASON AMOY","JEFF BONISA","CHERYL BETHE"],"Title":["1ST VICE PRESIDENT","TREASURER","2ND VICE PRESIDENT","PRESIDENT","SECRETARY","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","GENERAL MANAGER","GOLF PRO","COURSE SUPERINTENDENT","EXECUTIVE CHEF","CONTROLLER"],"Hours":[1.0,1.0,1.0,2.0,1.0,1.0,1.0,1.0,1.0,40.0,40.0,40.0,40.0,40.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,203630,129803,152585,134869,115647],"Direct compensation":[0,0,0,0,0,0,0,0,0,194117,112988,130447,114221,112279],"Other compensation":[0,0,0,0,0,0,0,0,0,9513,16815,22138,20648,3368]},"Basic":{"value":null,"mission":"To provide for the recreation and other nonprofitable purposes for the members of the club.","year":2017,"name":"MID PACIFIC COUNTRY CLUB","phone":8082628161,"website":"MPCCHI.ORG","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"DAVID YOKOI","year_formation":1926,"state_legal_domicile":"HI","total_volunteers":0,"tax_period_begin":"2017-07-01T00:00:00","tax_period_end":"2018-06-30T00:00:00","address":"266 KAELEPULU DRIVE, KAILUA, HI, 96734, USA","city":"KAILUA","state":"HI","country":"USA","zip_code":96734},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":147,"Total Gross UBI":216949,"Net unrelated business taxable income":0,"Number of employees":147,"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":8356448,"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":6304930,"Total revenue":{"value":6304930,"MEMBERSHIP DUES":4886913,"GOLF OPERATIONS":1376339,"LOCKER ROOMS":41678},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":8,"Investment income total":8,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":2051510,"Other total":76390,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":1975120,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":8548118,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":4193228,"Current officers":437552,"Disqualified persons":0,"Other salaries and wages":2776965,"Pension plan contributions":66764,"Other employee benefits":633329,"Payroll taxes":278618},"Other expenses":{"value":4354890,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":122469,"Advertising":0,"Office expenses":37557,"Information technology":0,"Royalties":0,"Occupancy":662778,"Travel":0,"Conferences and meetings":7056,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":589730,"Insurance":185729,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":2640464,"LEASE RENT":1117357,"MISCELLANEOUS":957860,"SUPPLIES":397603,"REPAIRS AND MAINTENANCE":167644},"All other expenses":109107},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":4545001,"Non-interest bearing cash":564792,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":322192,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":212763,"Prepaid expenses deferred charges":282039,"Land, building, equipment":2424421,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":738794},"Liabilities":{"value":7567195,"Sum of Total Liabilities":0,"Accounts payable, accrued":998528,"Grants payable":0,"Deferred, revenue":391355,"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":6177312},"Fund balance":{"value":-3022194,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":-3022194,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.02293677888021322,"percentile":0.3325581314775228},"Liabilities to Assets Ratio":{"score":1.6649490286140751,"percentile":0.0234310091391321},"Operating Reserve Ratio":{"score":0.531696099656088,"percentile":0.26413411262425834},"Officer Compensation Ratio":{"score":0.08616329348752556,"percentile":0.6008697236253917},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.021625583396980407,"percentile":0.47295981831268996},"Asset Growth":{"score":-0.10129540513537526,"percentile":0.10322984546208717},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.459211040131127,"percentile":0.22979099800955247}},"source_xml":"201901359349310765_public.xml"},{"Organization":{"value":null,"Person":["WAYNE MAU","LYNN KINNEY","ALAN KOBAYASHI","MICHAEL KOGA","PETER OSBORNE","PATRICK LEDGERWOOD","WAYNE PARKER","GLENN KOUCHI","LILLIAN YAMAMATO","TIM DIETRICH","JASON AMOY","NORMAN ASAO"],"Title":["PRESIDENT","2ND VICE PRESIDENT","DIRECTOR","TREASURER","DIRECTOR","1ST VICE PRESIDENT","SECRETARY","DIRECTOR","DIRECTOR","GENERAL MANAGER","COURSE SUPERINTENDENT","EXECUTIVE CHEF"],"Hours":[2.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,40.0,40.0,40.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,183842,149030,121535],"Direct compensation":[0,0,0,0,0,0,0,0,0,167800,130557,107308],"Other compensation":[0,0,0,0,0,0,0,0,0,16042,18473,14227]},"Basic":{"value":null,"mission":"To provide for the recreation and other nonprofitable purposes for the members of the club.","year":2014,"name":"MID PACIFIC COUNTRY CLUB","phone":8082628161,"website":"MPCCHI.ORG","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"WAYNE MAU","year_formation":1926,"state_legal_domicile":"HI","total_volunteers":0,"tax_period_begin":"2014-07-01T00:00:00","tax_period_end":"2015-06-30T00:00:00","address":"266 KAELEPULU DRIVE, KAILUA, HI, 96734, USA","city":"KAILUA","state":"HI","country":"USA","zip_code":96734},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":138,"Total Gross UBI":759924,"Net unrelated business taxable income":-124299,"Number of employees":138,"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":7755068,"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":5512982,"Total revenue":{"value":5512982,"MEMBERSHIP DUES":4072810,"GOLF OPERATIONS":1424621,"LOCKER ROOMS":15551},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":2915,"Investment income total":2915,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":2239171,"Other total":93612,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":2145559,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":8324120,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":3715770,"Current officers":405665,"Disqualified persons":0,"Other salaries and wages":2522667,"Pension plan contributions":56784,"Other employee benefits":475161,"Payroll taxes":255493},"Other expenses":{"value":4608350,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":249483,"Advertising":0,"Office expenses":63355,"Information technology":0,"Royalties":0,"Occupancy":708839,"Travel":0,"Conferences and meetings":8695,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":893130,"Insurance":191782,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":2388120,"LEASE RENT":1129966,"MISCELLANEOUS":603302,"SUPPLIES":423112,"REPAIRS AND MAINTENANCE":231740},"All other expenses":104946},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":6208774,"Non-interest bearing cash":394404,"Savings and temp cash investments":714697,"Pledges and grants receivable":0,"Accounts receivable":358684,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":224135,"Prepaid expenses deferred charges":313046,"Land, building, equipment":3864118,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":339690},"Liabilities":{"value":6660837,"Sum of Total Liabilities":0,"Accounts payable, accrued":970231,"Grants payable":0,"Deferred, revenue":81780,"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":5608826},"Fund balance":{"value":-452063,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":-452063,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.07337807998588794,"percentile":0.25300595372144785},"Liabilities to Assets Ratio":{"score":1.0728103487097453,"percentile":0.043856199189489915},"Operating Reserve Ratio":{"score":0.7458775221885316,"percentile":0.34460645653349997},"Officer Compensation Ratio":{"score":0.0545891938126793,"percentile":0.7346664081459424},"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.48383946063787814,"percentile":0.28330909852305314}},"source_xml":"201630419349301693_public.xml"},{"Organization":{"value":null,"Person":["CANA DAY","BENJAMIN SINGER","WAYNE MAU","MICHAEL KOGA","ALAN MAYHACK","BOB CROWLEY","MICHAEL ROUNDS","PAUL SHAUGHNESSY","LANCE UCHIMURA","RON HAAS","DONNA MATHES","JORGE GUTIERREZ","JASON AMOY","SARA PARKER","MARK SOUSA","JEFFREY BONISA"],"Title":["PRESIDENT","1ST VICE PRESIDENT","2ND VICE PRESIDENT","SECRETARY","TREASURER","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","GENERAL MANAGER","FORMER DIRECTOR OF FINANCE","DIRECTOR OF FINANCE","SUPERINTENDENT","ASSISTANT GENERAL MANGER","AMBASSADOR OF ALOHA","FORMER EXECUTIVE CHEF"],"Hours":[1.0,1.0,1.0,1.0,10.0,1.0,1.0,1.0,1.0,40.0,40.0,40.0,40.0,40.0,40.0,40.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,347580,115675,20697,182875,150607,139190,126218],"Direct compensation":[0,0,0,0,0,0,0,0,0,323429,105058,20090,158937,134117,122948,107369],"Other compensation":[0,0,0,0,0,0,0,0,0,24151,10617,607,23938,16490,16242,18849]},"Basic":{"value":null,"mission":"To provide for the recreation and other nonprofitable purposes for the members of the club.","year":2022,"name":"MID PACIFIC COUNTRY CLUB","phone":8086943522,"website":"MPCCHI.ORG","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RON HAAS","year_formation":1926,"state_legal_domicile":"HI","total_volunteers":9,"tax_period_begin":"2022-07-01T00:00:00","tax_period_end":"2023-06-30T00:00:00","address":"266 KAELEPULU DRIVE, KAILUA, HI, 96734, USA","city":"KAILUA","state":"HI","country":"USA","zip_code":96734},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":9,"Number of independent voting members":8,"Number of employees total":200,"Total Gross UBI":494331,"Net unrelated business taxable income":12309,"Number of employees":200,"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":11379370,"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":9440290,"Total revenue":{"value":9440290,"MEMBERSHIP DUES":7894224,"GOLF OPERATIONS":1546066},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":7399,"Investment income total":7399,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":1931681,"Other total":128857,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":1802824,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":10806427,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":5503909,"Current officers":960097,"Disqualified persons":0,"Other salaries and wages":3197442,"Pension plan contributions":37101,"Other employee benefits":876660,"Payroll taxes":432609},"Other expenses":{"value":5302518,"Management services":0,"Legal":0,"Accounting":14660,"Lobbying services":0,"Investment management fees":1647,"Other services":335047,"Advertising":0,"Office expenses":262701,"Information technology":65763,"Royalties":0,"Occupancy":1909991,"Travel":43107,"Conferences and meetings":15732,"Interest":50368,"Payments to affiliates":0,"Depreciation and depletion":504496,"Insurance":208252,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":1284573,"REPAIRS AND MAINTENANCE":431054,"SUPPLIES":399729,"GENERAL EXCISE TAXES":244968,"LAUNDRY":208822},"All other expenses":606181},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":15407571,"Non-interest bearing cash":1221770,"Savings and temp cash investments":798567,"Pledges and grants receivable":0,"Accounts receivable":1424586,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":322723,"Prepaid expenses deferred charges":232833,"Land, building, equipment":3995219,"Investments publicly traded":1028768,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":6383105},"Liabilities":{"value":16433318,"Sum of Total Liabilities":0,"Accounts payable, accrued":1789244,"Grants payable":0,"Deferred, revenue":436336,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":386774,"Unsecured notes loans payable":513508,"Other liabilities":13307456},"Fund balance":{"value":-1025747,"Net assets without donor restriction":-1025747,"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.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.05034927241139009,"percentile":0.5257804718833248},"Liabilities to Assets Ratio":{"score":1.066574218609799,"percentile":0.04424580447140682},"Operating Reserve Ratio":{"score":1.4257784742357489,"percentile":0.5241597095059091},"Officer Compensation Ratio":{"score":0.10020351777696736,"percentile":0.5513314224288869},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.044928801837556286,"percentile":0.5845868150715133},"Asset Growth":{"score":0.10537320343240386,"percentile":0.6959821712687495},"Independent Voting Board Pct":{"score":0.8888888888888888,"percentile":0.2330250129411084},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.49157883461202634,"percentile":0.3013267183733726}},"source_xml":"202431319349305318_public.xml"},{"Organization":{"value":null,"Person":["STEVE HOLMBERG","DON ARMSTRONG","TED COONS","MICHAEL ROTA","MICHAEL KOGA","MILES KIMHAN","LANE UCHIMURA","DARRELL YAMAGATA","NATHAN YOSHIOKA","JIM SWIETER","MARK SOUSA","JASON AMOY","JEFF BONISA","CHERYL BETHE"],"Title":["PRESIDENT","DIRECTOR","SECRETARY","1ST VICE PRESIDENT","DIRECTOR","DIRECTOR","1ST VICE PRESIDENT","TREASURER","DIRECTOR","GENERAL MANAGER","GOLF PRO","COURSE SUPERINTENDENT","EXECUTIVE CHEF","CONTROLLER"],"Hours":[2.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,40.0,40.0,40.0,40.0,40.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,199587,122353,133258,127564,113597],"Direct compensation":[0,0,0,0,0,0,0,0,0,199587,122353,133258,127564,113597],"Other compensation":[0,0,0,0,0,0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide for the recreation and other nonprofitable purposes for the members of the club.","year":2018,"name":"MID PACIFIC COUNTRY CLUB","phone":8082628161,"website":"MPCCHI.ORG","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"DONALD ARMSTRONG","year_formation":1926,"state_legal_domicile":"HI","total_volunteers":0,"tax_period_begin":"2018-07-01T00:00:00","tax_period_end":"2019-06-30T00:00:00","address":"266 KAELEPULU DRIVE, KAILUA, HI, 96734, USA","city":"KAILUA","state":"HI","country":"USA","zip_code":96734},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":156,"Total Gross UBI":229114,"Net unrelated business taxable income":0,"Number of employees":156,"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":8691272,"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":6283156,"Total revenue":{"value":6283156,"MEMBERSHIP DUES":5127962,"GOLF OPERATIONS":1155194},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":0,"Investment income total":0,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":2408116,"Other total":354587,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":2053529,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":8769242,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":4369362,"Current officers":0,"Disqualified persons":696358,"Other salaries and wages":2659505,"Pension plan contributions":72946,"Other employee benefits":651677,"Payroll taxes":288876},"Other expenses":{"value":4399880,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":131098,"Advertising":0,"Office expenses":38565,"Information technology":0,"Royalties":0,"Occupancy":644188,"Travel":0,"Conferences and meetings":0,"Interest":618,"Payments to affiliates":0,"Depreciation and depletion":569632,"Insurance":191756,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":2529712,"LEASE RENT":926186,"MISCELLANEOUS":894914,"SUPPLIES":519117,"NON CASH LAND LEASE":189495},"All other expenses":294311},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":26705626,"Non-interest bearing cash":677011,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":399220,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":238112,"Prepaid expenses deferred charges":259567,"Land, building, equipment":2789014,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":22342702},"Liabilities":{"value":29834305,"Sum of Total Liabilities":0,"Accounts payable, accrued":957995,"Grants payable":0,"Deferred, revenue":383148,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":4117,"Unsecured notes loans payable":0,"Other liabilities":28489045},"Fund balance":{"value":-3128679,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":-3128679,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.008971068906829749,"percentile":0.3627667511977042},"Liabilities to Assets Ratio":{"score":1.117154302992186,"percentile":0.04127849526328468},"Operating Reserve Ratio":{"score":3.0453745032923027,"percentile":0.7155743060336979},"Officer Compensation Ratio":{"score":0.07940925794954684,"percentile":0.6266923298952356},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.029616618348310367,"percentile":0.5127999460223844},"Asset Growth":{"score":0.30328251041187754,"percentile":0.9211991498326103},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5509266434855029,"percentile":0.4600331614598322}},"source_xml":"202001979349308020_public.xml"},{"Organization":{"value":null,"Person":["NORMAN SANTOS","LYNN KINNEY","DWIGHT AKAGI","PETER OSBORNE","GARY FUJITANI","WAYNE PARKER","GLENN KOUCHI","BILL MCROBERTS","DAVID YOKOI","TIM DIETRICH","JASON AMOY","CHERYL BETHE"],"Title":["PRESIDENT","2ND VICE PRESIDENT","TREASURER","DIRECTOR","1ST VICE PRESIDENT","SECRETARY","DIRECTOR","DIRECTOR","DIRECTOR","GENERAL MANAGER","COURSE SUPERINTENDENT","DIRECTOR OF FINANCE"],"Hours":[2.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,40.0,40.0,40.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,190376,151677,109206],"Direct compensation":[0,0,0,0,0,0,0,0,0,173400,132243,106138],"Other compensation":[0,0,0,0,0,0,0,0,0,16976,19434,3068]},"Basic":{"value":null,"mission":"To provide for the recreation and other nonprofitable purposes for the members of the club.","year":2015,"name":"MID PACIFIC COUNTRY CLUB","phone":8082628161,"website":"MPCCHI.ORG","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"WAYNE MAU","year_formation":1926,"state_legal_domicile":"HI","total_volunteers":0,"tax_period_begin":"2015-07-01T00:00:00","tax_period_end":"2016-06-30T00:00:00","address":"266 KAELEPULU DRIVE, KAILUA, HI, 96734, USA","city":"KAILUA","state":"HI","country":"USA","zip_code":96734},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":141,"Total Gross UBI":619779,"Net unrelated business taxable income":3887,"Number of employees":141,"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":7295431,"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":5432751,"Total revenue":{"value":5432751,"MEMBERSHIP DUES":3901840,"GOLF OPERATIONS":1222439,"ASSESSMENT":292002,"LOCKER ROOMS":16470},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":970,"Investment income total":970,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":1861710,"Other total":82057,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":1779653,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":8531340,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":3821924,"Current officers":411781,"Disqualified persons":0,"Other salaries and wages":2471024,"Pension plan contributions":81716,"Other employee benefits":614384,"Payroll taxes":243019},"Other expenses":{"value":4709416,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":399746,"Advertising":0,"Office expenses":58682,"Information technology":0,"Royalties":0,"Occupancy":659264,"Travel":0,"Conferences and meetings":11900,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":836675,"Insurance":197184,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":2434199,"LEASE RENT":1203495,"MISCELLANEOUS":586676,"SUPPLIES":417099,"REPAIRS AND MAINTENANCE":226929},"All other expenses":111766},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":5145858,"Non-interest bearing cash":718004,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":304310,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":231051,"Prepaid expenses deferred charges":283784,"Land, building, equipment":3398514,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":210195},"Liabilities":{"value":6781308,"Sum of Total Liabilities":0,"Accounts payable, accrued":884004,"Grants payable":0,"Deferred, revenue":98983,"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":5798321},"Fund balance":{"value":-1635450,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":-1635450,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.1694086339792673,"percentile":0.1683586800766873},"Liabilities to Assets Ratio":{"score":1.317818719443871,"percentile":0.03258898650187715},"Operating Reserve Ratio":{"score":0.6031711313814712,"percentile":0.2924404320792424},"Officer Compensation Ratio":{"score":0.05289426983334388,"percentile":0.7427248312248754},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":-0.013684903671235062,"percentile":0.31707929586088557},"Asset Growth":{"score":-0.11813405398898794,"percentile":0.09104927152340161},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.42328176765319797,"percentile":0.1609898681760977}},"source_xml":"201731359349313173_public.xml"}],"Latest":{"Organization":{"value":null,"Person":["CANA DAY","BENJAMIN SINGER","WAYNE MAU","MICHAEL KOGA","ALAN MAYHACK","BOB CROWLEY","MICHAEL ROUNDS","PAUL SHAUGHNESSY","LANCE UCHIMURA","RON HAAS","JORGE GUTIERREZ","JASON AMOY","SARA PARKER","MARK SOUSA"],"Title":["PRESIDENT","1ST VICE PRESIDENT","2ND VICE PRESIDENT","SECRETARY","TREASURER","DIRECTOR","DIRECTOR","DIRECTOR","DIRECTOR","GENERAL MANAGER","DIRECTOR OF FINANCE","SUPERINTENDENT","ASSISTANT GENERAL MANGER","AMBASSADOR OF ALOHA"],"Hours":[1.0,1.0,1.0,1.0,10.0,1.0,1.0,1.0,1.0,40.0,40.0,40.0,40.0,40.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,334346,179187,192839,163587,136522],"Direct compensation":[0,0,0,0,0,0,0,0,0,300258,171824,166049,142230,117231],"Other compensation":[0,0,0,0,0,0,0,0,0,34088,7363,26790,21357,19291]},"Basic":{"value":null,"mission":"To provide for the recreation and other nonprofitable purposes for the members of the club.","year":2023,"name":"MID PACIFIC COUNTRY CLUB","phone":8086943522,"website":"MPCCHI.ORG","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"RON HAAS","year_formation":1926,"state_legal_domicile":"HI","total_volunteers":9,"tax_period_begin":"2023-07-01T00:00:00","tax_period_end":"2024-06-30T00:00:00","address":"266 KAELEPULU DRIVE, KAILUA, HI, 96734, USA","city":"KAILUA","state":"HI","country":"USA","zip_code":96734},"Governance":{"value":null,"501c3 determination":false,"501c determination":true,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":189,"Total Gross UBI":600278,"Net unrelated business taxable income":107291,"Number of employees":189,"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":12874233,"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":10635487,"Total revenue":{"value":10635487,"MEMBERSHIP DUES":8986542,"GOLF OPERATIONS":1648945},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":117008,"Investment income total":117008,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":2121738,"Other total":110025,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":2011713,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":12003988,"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":0,"Benefits paid to members Total":0},"Salaries":{"value":6264691,"Current officers":442076,"Disqualified persons":0,"Other salaries and wages":4213958,"Pension plan contributions":68585,"Other employee benefits":1059358,"Payroll taxes":480714},"Other expenses":{"value":5739297,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":3475,"Other services":392699,"Advertising":0,"Office expenses":259962,"Information technology":122505,"Royalties":0,"Occupancy":2000707,"Travel":43053,"Conferences and meetings":24591,"Interest":25215,"Payments to affiliates":0,"Depreciation and depletion":581309,"Insurance":233164,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":1474930,"REPAIRS AND MAINTENANCE":418687,"SUPPLIES":401680,"CERTIFICATE PAYMENTS":396000,"GENERAL EXCISE TAXES":258563},"All other expenses":577687},"Functional Expenses":{"value":null,"Program Service Expenses":0,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":15492967,"Non-interest bearing cash":1623242,"Savings and temp cash investments":549614,"Pledges and grants receivable":0,"Accounts receivable":533380,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":390100,"Prepaid expenses deferred charges":264310,"Land, building, equipment":4246552,"Investments publicly traded":1599476,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":6286293},"Liabilities":{"value":15642090,"Sum of Total Liabilities":0,"Accounts payable, accrued":1425888,"Grants payable":0,"Deferred, revenue":424114,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":500916,"Other liabilities":13291172},"Fund balance":{"value":-149123,"Net assets without donor restriction":-149123,"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.0,"percentile":0.4421253816471043},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.06759587153658009,"percentile":0.5624451895059774},"Liabilities to Assets Ratio":{"score":1.0096252060693087,"percentile":0.04841634261011778},"Operating Reserve Ratio":{"score":1.290651656766068,"percentile":0.49605184368886107},"Officer Compensation Ratio":{"score":0.08384555199488704,"percentile":0.6095039576625103},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":0.05376477904999263,"percentile":0.6218422884941169},"Asset Growth":{"score":0.09937854150065781,"percentile":0.681565155809351},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5699451485871032,"percentile":0.5166526244089703}},"source_xml":"202530959349300528_public.xml"},"sector":"","donation_categories":[],"zakat_policy":null},"error":null}