Civic Intelligence

Laulima Data Alliance

990 • Fiscal year 2019 • EIN 82-1726643

Jul 01, 2018 to Jun 30, 2019 • Filed on Jul 15, 2020

Organization ProfileLAULIMADATA.ORG
707 Richards Street No Ph2Honolulu, HI 96813

(808) 521-8961

Siviq Scores

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

Liabilities / Assets

72nd percentile

0.18x

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

2019 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2019

Liabilities / Revenue

65th percentile

0.08x

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

2019 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2019

Net Margin

48th percentile

3.0%

Higher net margin than 48% of similar nonprofits.

2019 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2019

Top Officer Pay

98th percentile

$302,068

Higher top officer pay than 98% of similar nonprofits.

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

2019 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2019

Asset Growth

10th percentile

-19%

Faster asset growth than 10% of similar nonprofits.

2019 filings • 501(c)3 • $500k-$1M nonprofits • Annualized from 2018 to 2019

Revenue Growth

60th percentile

9.5%

Faster revenue growth than 60% of similar nonprofits.

2019 filings • 501(c)3 • $500k-$1M nonprofits • Annualized from 2018 to 2019

Balance Sheet
Liabilities / Assets72nd percentile

Assets

Down

$374,689

Down $89,468 (-19%) from 2018

Net Assets

Up

$306,245

Up $110,865 (+57%) from 2018

Liabilities

Down

$68,444

Down $200,333 (-75%) from 2018

Revenue And Expenses
Liabilities / Revenue65th percentileNet Margin48th percentile

Revenue

Up

$830,657

Up $72,192 (+9.5%) from 2018

Expenses

Up

$805,484

Up $242,399 (+43%) from 2018

Net Income

Down

$25,173

Down $170,207 (-87%) from 2018

Historical Trend

Balance Sheet Trend

Asset Growth10th percentile

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

$1.0M$500K$0Assets 2018: $464,157Liabilities 2018: $268,777Net Assets 2018: $195,3802018Assets 2019: $374,689Liabilities 2019: $68,444Net Assets 2019: $306,2452019Assets 2020: $480,473Liabilities 2020: $131,344Net Assets 2020: $349,1292020Assets 2021: $512,141Liabilities 2021: $90,019Net Assets 2021: $422,1222021Assets 2022: $636,215Liabilities 2022: $104,880Net Assets 2022: $531,3352022Assets 2023: $806,081Liabilities 2023: $188,261Net Assets 2023: $617,8202023

Highlighted filing

2019

Assets$374,689
Liabilities$68,444
Net Assets$306,245
Open 2019 Filing

Operations Trend

Revenue Growth60th percentile

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

$1.0M$500K$0Revenue 2018: $758,465Expenses 2018: $563,085Net Income 2018: $195,3802018Revenue 2019: $830,657Expenses 2019: $805,484Net Income 2019: $25,1732019Revenue 2020: $829,559Expenses 2020: $786,675Net Income 2020: $42,8842020Revenue 2021: $838,055Expenses 2021: $765,062Net Income 2021: $72,9932021Revenue 2022: $917,900Expenses 2022: $808,687Net Income 2022: $109,2132022Revenue 2023: $981,366Expenses 2023: $898,964Net Income 2023: $82,4022023

Highlighted filing

2019

Revenue$830,657
Expenses$805,484
Net Income$25,173
Open 2019 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2018 to Jun 30, 2019
Signed
Jul 15, 2020
Return Version
2018v3.2
Gross Receipts
$830,657
Mission and Program Overview

Mission

To provide a comprehensive data analytics and reporting platform that hospitals, healthcare leaders, policymakers, researchers, and community leaders can access to support decision making and policy in creating sustainable healthcare solutions for hawaii's communities.

Balance Sheet Detail
LineBeginningEndChange
Assets
Cash and Non-Interest-Bearing Accounts$176,587$181,452▲ $4,865
Prepaid Expenses and Deferred Charges$114,900$136,882▲ $21,982
Land, Buildings, and Equipment, Net$4,740$48,293▲ $43,553
Accounts Receivable$167,930$8,062▼ $159,868
Total Assets$464,157$374,689▼ $89,468
Liabilities
Accounts Payable and Accrued Expenses$40,961$66,510▲ $25,549
Other Liabilities$227,816$1,934▼ $225,882
Total Liabilities$268,777$68,444▼ $200,333
Net Assets / Fund Balance
Unrestricted Net Assets$195,380$306,245▲ $110,865
Total Net Assets Fund Balance$195,380$306,245▲ $110,865
Total Liabilities and Net Assets / Fund Balance$464,157$374,689▼ $89,468

Asset Categories

AssetBook ValueDepreciationBasis
Equipment$47,590$145,584$193,174
Other Land Buildings$703$422$1,125
Compensation and Service Providers
Top Officer Pay98th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
Haley HseihExecutive DirectorFT$177,659$26,448$204,107

Board Members and Trustees

NameTitle
Hilton RaethelPresident and CEO
Steve RobertsonVice-chair
Brandon HargrettDirector
Bruce Anderson PhdDirector
Colbert SetoDirector
Dan BrinkmanDirector
Donna ScannellDirector
Gary KajiwaraDirector
Kathy Fujihara ChongDirector
Tiffany LemmenDirector
C Becket Mahnke MdFormer Director
Travis CleggFormer Director
Bess HayashiChief Financial Officer
John J ChenSecretary

Highest Paid Contractors

ContractorServicesLocationCompensation
Iowa Hospital AssociationConsulting100 E GRAND AVE STE 100, Des Moines, IA 50309$192,867
Revenue and Support

Revenue Composition

Contributions and Grants
$0
Program Service Revenue
$830,657
Investment Income
$0
Other Revenue
$0
Change in Net Assets
$25,173
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Other Expenses$419,629
Salaries, Compensation, and Employee Benefits$385,855
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Information Technology$200,142$4,125-$204,267
Current Officers, Directors, Trustees, and Key Employees$68,128$120,238-$188,366
Other Salaries and Wages$47,054$83,043-$130,097
Fees for Services Other$61,564$827-$62,391
Depreciation Depletion$30,325$30,325-$60,650
Other Employee Benefits$10,188$18,217-$28,405
Payroll Taxes$7,676$13,646-$21,322
Occupancy$10,233$10,233-$20,466
Pension Plan Contributions$6,389$11,276-$17,665
Insurance$8,383$8,383-$16,766
Travel$15,553--$15,553
Fees for Services Legal$12,503--$12,503
Fees for Services Accounting-$10,601-$10,601
Office Expenses$1,291$1,293-$2,584
Conferences and Meetings$407$855-$1,262
Other Expenses$402$792-$792
All Other Expenses-$616-$616
Total Functional Expenses$482,993$322,491$0$805,484
Fundraising, Events, and Gaming
Fundraising activities
No
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

Line ItemAmount
Professional Fundraising Fees$0
Political and Lobbying Activity
Political campaign activity
No
Lobbying activity
No
Subject to proxy tax
No
Debt and Bond Financing

Other Reported Liabilities

LiabilityAmount
Due to Hah$1,934
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
Yes
Annual disclosure for covered persons
Yes
Audit committee
Yes
Business relationship with family members
No
Business relationship with organization members
No
Material changes to governing documents
No
Compensation from other sources disclosed
No
CEO compensation reviewed
Yes
Other officer compensation reviewed
No
Conflict-of-interest policy
Yes
Audited financial statements prepared
No
Key decisions subject to board approval
No
Management duties delegated
No

Governance Explanations

Form 990, Part VI, Section A, Line 6

“The healthcare association of hawaii is the sole initial member.”

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

“The governing body is made up of representatives of six designated hospitals or hospital systems, one rotating hospital not part of the first six, state of hawaii department of health, hawaii medical service association, the john a. Burns school of medicine/university of hawaii, the president and ceo of the healthcare association of hawaii and the executive director of laulima data alliance.”

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

“All 990 reporting was reviewed internally by senior management. All questions and changes were addressed prior to filing of the 990.”

Form 990, Part VI, Section B, Line 12C

“Laulima data alliance adopted a conflict of interest policy in fye 6/30/19. The policy is sent out on an annual basis to the current board of directors, officers and key employees. The responses are summarized, reviewed and analyzed for reporting.”

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

“The compensation of the executive director was determined by certain board members and an outside consultant. In determining the compensation amount, the compensation for a similar position in a comparable organization was considered. This process was documented in the personnel files.”

Form 990, Part VI, Section C, Line 19

“Laulima data alliance does not make its governing documents and financial statements available to the public.”

Filing and Contact Details

Filer

Filer Name
Laulima Data Alliance
EIN
82-1726643
Phone
8085218961
Address
707 RICHARDS STREET NO PH2, HONOLULU, HI 96813

Signing Officer

Name
Hilton R Raethel
Title
President & Board Chair
Phone
8085218961
Signed
2020-07-15
Discuss with paid preparer
Yes

Organization Details

Principal Officer
Hilton R Raethel
Formed
2018
Legal Domicile
Hi
Voting Board Members
12
Independent Board Members
10
Employees
2
Volunteers
12

Preparer

Firm
Cw Associates Cpas
Address
700 BISHOP STREET SUITE 1040, HONOLULU, HI 96813
Preparer
Melanie a King
Phone
8085311040
Supplemental Narrative

Financial Statement Notes

PART X, LINE 2:

“Accounting principles generally accepted in the united states of america require uncertain tax positions to be recognized in the consolidated financial statements if they are more likely than not to fail upon regulatory examination. Management evaluated the hah's and laulima's tax positions as of and for the years ended june 30, 2019 and 2018 by reviewing their income tax returns and conferring with their tax advisors, and determined that hah and laulima had no uncertain tax positions required to be reported in accordance with such generally accepted accounting principles. Hah and laulima are subject to routine audits by taxing jurisdictions; however, there are currently no audits in progress for any open tax periods.”

Raw XML AppendixShowing 400 of 572 raw XML fields

This appendix keeps the raw XML leaves available for debugging and edge-case review. The human report above is the primary experience.

Path#Value
IRS990/AccountantCompileOrReviewInd01
IRS990/AccountsPayableAccrExpnssGrp/BOYAmt040961
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt066510
IRS990/AccountsReceivableGrp/BOYAmt0167930
IRS990/AccountsReceivableGrp/EOYAmt08062
IRS990/AcctCompileOrReviewBasisGrp/ConsolidatedBasisFinclStmtInd0X
IRS990/ActivitiesConductedPrtshpInd00
IRS990/ActivityOrMissionDesc0TO PROVIDE A COMPREHENSIVE DATA ANALYTICS AND REPORTING PLATFORM THAT HOSPITALS, HEALTHCARE LEADERS, POLICYMAKERS, RESEARCHERS, AND COMMUNITY LEADERS CAN ACCESS TO SUPPORT DECISION MAKING AND POLICY IN CREATING SUSTAINABLE HEALTHCARE SOLUTIONS FOR HAWAII'S COMMUNITIES.
IRS990/AllOtherExpensesGrp/ManagementAndGeneralAmt0616
IRS990/AllOtherExpensesGrp/TotalAmt0616
IRS990/AnnualDisclosureCoveredPrsnInd01
IRS990/AuditCommitteeInd01
IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0WENDY ODO
IRS990/BooksInCareOfDetail/PhoneNum08085218961
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt0707 RICHARDS STREET PH2
IRS990/BooksInCareOfDetail/USAddress/CityNm0HONOLULU
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0HI
IRS990/BooksInCareOfDetail/USAddress/ZIPCd096813
IRS990/BusinessRlnWithFamMemInd00
IRS990/BusinessRlnWithOfficerEntInd00
IRS990/BusinessRlnWithOrgMemInd00
IRS990/CashNonInterestBearingGrp/BOYAmt0176587
IRS990/CashNonInterestBearingGrp/EOYAmt0181452
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt01
IRS990/CollectionsOfArtInd00
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt0120238
IRS990/CompCurrentOfcrDirectorsGrp/ProgramServicesAmt068128
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt0188366
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd00
IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt0855
IRS990/ConferencesMeetingsGrp/ProgramServicesAmt0407
IRS990/ConferencesMeetingsGrp/TotalAmt01262
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContractorCompensationGrp/CompensationAmt0192867
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt0100 E GRAND AVE STE 100
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm0DES MOINES
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd0IA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd050309
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt0IOWA HOSPITAL ASSOCIATION
IRS990/ContractorCompensationGrp/ServicesDesc0CONSULTING
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt00
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt00
IRS990/CYOtherExpensesAmt0419629
IRS990/CYOtherRevenueAmt00
IRS990/CYProgramServiceRevenueAmt0830657
IRS990/CYRevenuesLessExpensesAmt025173
IRS990/CYSalariesCompEmpBnftPaidAmt0385855
IRS990/CYTotalExpensesAmt0805484
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt0830657
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DelegationOfMgmtDutiesInd00
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt030325
IRS990/DepreciationDepletionGrp/ProgramServicesAmt030325
IRS990/DepreciationDepletionGrp/TotalAmt060650
IRS990/Desc0DATA ANALYTICS AND REPORTING PLATFORM.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd00
IRS990/DonorAdvisedFundInd00
IRS990/ElectionOfBoardMembersInd01
IRS990/EmployeeCnt02
IRS990/EmploymentTaxReturnsFiledInd01
IRS990/EngagedInExcessBenefitTransInd00
IRS990/ExpenseAmt0482993
IRS990/FamilyOrBusinessRlnInd00
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt010601
IRS990/FeesForServicesAccountingGrp/TotalAmt010601
IRS990/FeesForServicesLegalGrp/ProgramServicesAmt012503
IRS990/FeesForServicesLegalGrp/TotalAmt012503
IRS990/FeesForServicesOtherGrp/ManagementAndGeneralAmt0827
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt061564
IRS990/FeesForServicesOtherGrp/TotalAmt062391
IRS990/ForeignActivitiesInd00
IRS990/ForeignFinancialAccountInd00
IRS990/ForeignOfficeInd00
IRS990/Form8282PropertyDisposedOfInd00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt02.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt12.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt237.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt334.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt01.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt11.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt21.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt31.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt41.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt51.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt61.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt71.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt81.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt91.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt103.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt111.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt121.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt1340.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt146.00
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd2X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd3X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd4X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd5X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd6X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd7X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd8X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd9X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd10X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd11X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd12X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd13X
IRS990/Form990PartVIISectionAGrp/OfficerInd0X
IRS990/Form990PartVIISectionAGrp/OfficerInd1X
IRS990/Form990PartVIISectionAGrp/OfficerInd2X
IRS990/Form990PartVIISectionAGrp/OfficerInd3X
IRS990/Form990PartVIISectionAGrp/OfficerInd4X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt10
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt20
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt30
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt40
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt50
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt60
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt70
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt80
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt90
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt1022932
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt110
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt120
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt1321857
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt1423499
IRS990/Form990PartVIISectionAGrp/PersonNm0DAN BRINKMAN
IRS990/Form990PartVIISectionAGrp/PersonNm1BRANDON HARGRETT
IRS990/Form990PartVIISectionAGrp/PersonNm2KATHY FUJIHARA CHONG
IRS990/Form990PartVIISectionAGrp/PersonNm3GARY KAJIWARA
IRS990/Form990PartVIISectionAGrp/PersonNm4TIFFANY LEMMEN
IRS990/Form990PartVIISectionAGrp/PersonNm5BRUCE ANDERSON PHD
IRS990/Form990PartVIISectionAGrp/PersonNm6DONNA SCANNELL
IRS990/Form990PartVIISectionAGrp/PersonNm7COLBERT SETO
IRS990/Form990PartVIISectionAGrp/PersonNm8TRAVIS CLEGG
IRS990/Form990PartVIISectionAGrp/PersonNm9C BECKET MAHNKE MD
IRS990/Form990PartVIISectionAGrp/PersonNm10HILTON RAETHEL
IRS990/Form990PartVIISectionAGrp/PersonNm11STEVE ROBERTSON
IRS990/Form990PartVIISectionAGrp/PersonNm12JOHN J CHEN
IRS990/Form990PartVIISectionAGrp/PersonNm13HALEY HSEIH
IRS990/Form990PartVIISectionAGrp/PersonNm14BESS HAYASHI
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt70
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt80
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt90
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt100
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt110
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt120
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt13182250
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt140
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt70
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt80
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt90
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10279136
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt110
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt120
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt130
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt14153474
IRS990/Form990PartVIISectionAGrp/TitleTxt0DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt1DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt2DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt3DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt4DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt5DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt6DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt7DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt8FORMER DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt9FORMER DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt10PRESIDENT AND CEO
IRS990/Form990PartVIISectionAGrp/TitleTxt11VICE-CHAIR
IRS990/Form990PartVIISectionAGrp/TitleTxt12SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt13EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt14CHIEF FINANCIAL OFFICER
IRS990/Form990ProvidedToGvrnBodyInd01
IRS990/Form990TFiledInd01
IRS990/FormationYr02018
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedInd00
IRS990/FundraisingActivitiesInd00
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt012
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt0830657
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd01
IRS990/IndependentAuditFinclStmtInd00
IRS990/IndependentVotingMemberCnt010
IRS990/IndivRcvdGreaterThan100KCnt01
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InformationTechnologyGrp/ManagementAndGeneralAmt04125
IRS990/InformationTechnologyGrp/ProgramServicesAmt0200142
IRS990/InformationTechnologyGrp/TotalAmt0204267
IRS990/InsuranceGrp/ManagementAndGeneralAmt08383
IRS990/InsuranceGrp/ProgramServicesAmt08383
IRS990/InsuranceGrp/TotalAmt016766
IRS990/InvestmentInJointVentureInd00
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt0146006
IRS990/LandBldgEquipBasisNetGrp/BOYAmt04740
IRS990/LandBldgEquipBasisNetGrp/EOYAmt048293
IRS990/LandBldgEquipCostOrOtherBssAmt0194299
IRS990/LegalDomicileStateCd0HI
IRS990/LoanOutstandingInd00
IRS990/LobbyingActivitiesInd00
IRS990/LocalChaptersInd00
IRS990/MaterialDiversionOrMisuseInd00
IRS990/MembersOrStockholdersInd01
IRS990/MethodOfAccountingAccrualInd0X
IRS990/MinutesOfCommitteesInd01
IRS990/MinutesOfGoverningBodyInd01
IRS990/MissionDesc0TO PROVIDE A COMPREHENSIVE DATA ANALYTICS AND REPORTING PLATFORM THAT HOSPITALS, HEALTHCARE LEADERS, POLICYMAKERS, RESEARCHERS, AND COMMUNITY LEADERS CAN ACCESS TO SUPPORT DECISION MAKING AND POLICY IN CREATING SUSTAINABLE HEALTHCARE SOLUTIONS FOR HAWAII'S COMMUNITIES.
IRS990/MoreThan5000KToIndividualsInd00
IRS990/MoreThan5000KToOrgInd00
IRS990/NetAssetsOrFundBalancesBOYAmt0195380
IRS990/NetAssetsOrFundBalancesEOYAmt0306245
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt010233
IRS990/OccupancyGrp/ProgramServicesAmt010233
IRS990/OccupancyGrp/TotalAmt020466
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt01293
IRS990/OfficeExpensesGrp/ProgramServicesAmt01291
IRS990/OfficeExpensesGrp/TotalAmt02584
IRS990/OfficerMailingAddressInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsSFAS117Ind0X
IRS990/OtherChangesInNetAssetsAmt00
IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt018217
IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt010188
IRS990/OtherEmployeeBenefitsGrp/TotalAmt028405
IRS990/OtherExpensesGrp/Desc0EQUIPMENT RENT AND MAIN
IRS990/OtherExpensesGrp/Desc1AUTOMOBILE AND PARKING
IRS990/OtherExpensesGrp/Desc2PUBLIC RELATIONS
IRS990/OtherExpensesGrp/Desc3UNRELATED BUSINESS INCO
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt02755
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt14370
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt2896
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt3792
IRS990/OtherExpensesGrp/ProgramServicesAmt02755
IRS990/OtherExpensesGrp/ProgramServicesAmt1402
IRS990/OtherExpensesGrp/TotalAmt05510
IRS990/OtherExpensesGrp/TotalAmt14772
IRS990/OtherExpensesGrp/TotalAmt2896
IRS990/OtherExpensesGrp/TotalAmt3792
IRS990/OtherLiabilitiesGrp/BOYAmt0227816
IRS990/OtherLiabilitiesGrp/EOYAmt01934
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt083043
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt047054
IRS990/OtherSalariesAndWagesGrp/TotalAmt0130097
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt013646
IRS990/PayrollTaxesGrp/ProgramServicesAmt07676
IRS990/PayrollTaxesGrp/TotalAmt021322
IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt011276
IRS990/PensionPlanContributionsGrp/ProgramServicesAmt06389
IRS990/PensionPlanContributionsGrp/TotalAmt017665
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt0114900
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt0136882
IRS990/PrincipalOfficerNm0HILTON R RAETHEL
IRS990/PriorPeriodAdjustmentsAmt085692
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0900099
IRS990/ProgramServiceRevenueGrp/BusinessCd1900099
IRS990/ProgramServiceRevenueGrp/Desc0MEMBERSHIP DUES
IRS990/ProgramServiceRevenueGrp/Desc1ALL OTHER PROGRAMS
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt0619393
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt1211264
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt0619393
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt1211264
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt00
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt00
IRS990/PYOtherExpensesAmt0340782
IRS990/PYOtherRevenueAmt00
IRS990/PYProgramServiceRevenueAmt0758465
IRS990/PYRevenuesLessExpensesAmt0195380
IRS990/PYSalariesCompEmpBnftPaidAmt0222303
IRS990/PYTotalExpensesAmt0563085
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt0758465
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt025173
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd00
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd00
IRS990/RevenueAmt0830657
IRS990ScheduleA/AmountsRcvdDsqlfyPersonGrp/TotalAmt00
IRS990ScheduleA/First5Years509Ind0X
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt0830657
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt0758465
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt01589122
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportTotal509Amt01589122
IRS990ScheduleA/SubstAndDsqlfyPrsnsTotGrp/TotalAmt00
IRS990ScheduleA/SubstantialContributorsAmtGrp/TotalAmt00
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt0830657
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt0758465
IRS990ScheduleA/Total509Grp/TotalAmt01589122
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt0830657
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt0758465
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt01589122
IRS990/ScheduleBRequiredInd00
IRS990ScheduleD/EquipmentGrp/BookValueAmt047590
IRS990ScheduleD/EquipmentGrp/DepreciationAmt0145584
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt0193174
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/OtherLandBuildingsGrp/BookValueAmt0703
IRS990ScheduleD/OtherLandBuildingsGrp/DepreciationAmt0422
IRS990ScheduleD/OtherLandBuildingsGrp/OtherCostOrOtherBasisAmt01125
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt01934
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0DUE TO HAH
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0ACCOUNTING PRINCIPLES GENERALLY ACCEPTED IN THE UNITED STATES OF AMERICA REQUIRE UNCERTAIN TAX POSITIONS TO BE RECOGNIZED IN THE CONSOLIDATED FINANCIAL STATEMENTS IF THEY ARE MORE LIKELY THAN NOT TO FAIL UPON REGULATORY EXAMINATION. MANAGEMENT EVALUATED THE HAH'S AND LAULIMA'S TAX POSITIONS AS OF AND FOR THE YEARS ENDED JUNE 30, 2019 AND 2018 BY REVIEWING THEIR INCOME TAX RETURNS AND CONFERRING WITH THEIR TAX ADVISORS, AND DETERMINED THAT HAH AND LAULIMA HAD NO UNCERTAIN TAX POSITIONS REQUIRED TO BE REPORTED IN ACCORDANCE WITH SUCH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. HAH AND LAULIMA ARE SUBJECT TO ROUTINE AUDITS BY TAXING JURISDICTIONS; HOWEVER, THERE ARE CURRENTLY NO AUDITS IN PROGRESS FOR ANY OPEN TAX PERIODS.
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0PART X, LINE 2:
IRS990ScheduleD/TotalBookValueLandBuildingsAmt048293
IRS990ScheduleD/TotalLiabilityAmt01934
IRS990ScheduleJ/AnyNonFixedPaymentsInd00
IRS990ScheduleJ/BoardOrCommitteeApprovalInd0X
IRS990ScheduleJ/CompBasedOnRevenueOfFlngOrgInd00
IRS990ScheduleJ/CompBsdNetEarnsFlngOrgInd00
IRS990ScheduleJ/CompBsdNetEarnsRltdOrgsInd00
IRS990ScheduleJ/CompBsdOnRevRelatedOrgsInd00
IRS990ScheduleJ/CompensationSurveyInd0X
IRS990ScheduleJ/EquityBasedCompArrngmInd00
IRS990ScheduleJ/IndependentConsultantInd0X
IRS990ScheduleJ/InitialContractExceptionInd00
IRS990/ScheduleJRequiredInd01
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BaseCompensationFilingOrgAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BaseCompensationFilingOrgAmt1177659
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BaseCompensationFilingOrgAmt20
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusFilingOrganizationAmount00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusFilingOrganizationAmount12608
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusFilingOrganizationAmount20
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusRelatedOrganizationsAmt041250
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusRelatedOrganizationsAmt10
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusRelatedOrganizationsAmt219656
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompensationBasedOnRltdOrgsAmt0223518
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompensationBasedOnRltdOrgsAmt10
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompensationBasedOnRltdOrgsAmt2130414
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompReportPrior990FilingOrgAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompReportPrior990FilingOrgAmt10
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompReportPrior990FilingOrgAmt20
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompReportPrior990RltdOrgsAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompReportPrior990RltdOrgsAmt10
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompReportPrior990RltdOrgsAmt20
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/DeferredCompensationFlngOrgAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/DeferredCompensationFlngOrgAmt10
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/DeferredCompensationFlngOrgAmt20
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/DeferredCompRltdOrgsAmt016500
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/DeferredCompRltdOrgsAmt10
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/DeferredCompRltdOrgsAmt210704
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/NontaxableBenefitsFilingOrgAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/NontaxableBenefitsFilingOrgAmt121857
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/NontaxableBenefitsFilingOrgAmt20
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/NontaxableBenefitsRltdOrgsAmt06432
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/NontaxableBenefitsRltdOrgsAmt10

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2019 • Form 990Detailed filing. Detailed filing data is available for this year.

Open filing
Assets
$374,689
Liabilities
$68,444
Net assets
$306,245
Revenue
$830,657
Expenses
$805,484
Net income
$25,173
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023Summary only. Only limited summary data is available for this year.$8.06$1.88$6.18$9.81$8.99$0.82
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$6.36$1.05$5.31$9.18$8.09$1.09
2021Facts available. Structured filing facts are available, but richer extracted sections are limited.$5.12$0.90$4.22$8.38$7.65$0.73
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.80$1.31$3.49$8.30$7.87$0.43
2019Detailed filing. Detailed filing data is available for this year.$3.75$0.68$3.06$8.31$8.05$0.25
2018Summary only. Only limited summary data is available for this year.$4.64$2.69$1.95$7.58$5.63$1.95