Civic Intelligence

Hawaii Area Committee

990EZ • Fiscal year 2012 • EIN 99-0241292

Jan 01, 2012 to Dec 31, 2012 • Filed on Apr 24, 2013

210796814
Siviq Scores

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

Liabilities / Assets

76th percentile

0.11x

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

2012 filings • 501(c)3 • <$500k nonprofits • Source year 2012

Liabilities / Revenue

78th percentile

0.06x

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

2012 filings • 501(c)3 • <$500k nonprofits • Source year 2012

Net Margin

14th percentile

-26%

Higher net margin than 14% of similar nonprofits.

2012 filings • 501(c)3 • <$500k nonprofits • Source year 2012

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2012

Asset Growth

14th percentile

-32%

Faster asset growth than 14% of similar nonprofits.

2012 filings • 501(c)3 • <$500k nonprofits • Annualized from 2011 to 2012

Revenue Growth

4th percentile

-75%

Faster revenue growth than 4% of similar nonprofits.

2012 filings • 501(c)3 • <$500k nonprofits • Annualized from 2011 to 2012

Assets

Down

$13,156

Down $6,331 (-32%) from 2011

Net Assets

Down

$11,650

Down $7,837 (-40%) from 2011

Liabilities

$1,506

No earlier filing loaded for comparison.

Revenue

Down

$25,117

Down $77,192 (-75%) from 2011

Expenses

Down

$31,604

Down $72,989 (-70%) from 2011

Net Income

Down

-$6,487

Down $4,203 (-184%) from 2011

Historical Trend

Balance Sheet Trend

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

$100K$50K$0Assets 2010: $21,922Net Assets 2010: $21,9222010Assets 2011: $19,487Net Assets 2011: $19,4872011Assets 2012: $13,156Liabilities 2012: $1,506Net Assets 2012: $11,6502012Assets 2013: $22,567Liabilities 2013: $1,977Net Assets 2013: $20,5902013Assets 2014: $29,469Liabilities 2014: $2,223Net Assets 2014: $27,2462014Assets 2015: $32,721Liabilities 2015: $1,045Net Assets 2015: $31,6762015Assets 2016: $33,258Liabilities 2016: $1,130Net Assets 2016: $32,1282016Assets 2017: $36,168Liabilities 2017: $1,730Net Assets 2017: $34,4382017Assets 2018: $39,073Liabilities 2018: $2,3302018Assets 2019: $41,050Liabilities 2019: $2,9302019Assets 2020: $51,506Liabilities 2020: $2,8962020Assets 2021: $68,161Liabilities 2021: $3,246Net Assets 2021: $64,9152021Assets 2022: $67,610Liabilities 2022: $12,074Net Assets 2022: $55,5362022Assets 2023: $74,926Liabilities 2023: $23,431Net Assets 2023: $51,4952023Assets 2024: $92,076Liabilities 2024: $35,802Net Assets 2024: $56,2742024

Highlighted filing

2012

Assets$13,156
Liabilities$1,506
Net Assets$11,650

Operations Trend

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

$150K$100K$50K$0-$50KRevenue 2010: $23,007Expenses 2010: $34,118Net Income 2010: -$11,1112010Revenue 2011: $102,309Expenses 2011: $104,593Net Income 2011: -$2,2842011Revenue 2012: $25,117Expenses 2012: $31,604Net Income 2012: -$6,4872012Revenue 2013: $31,558Expenses 2013: $22,304Net Income 2013: $9,2542013Revenue 2014: $37,531Expenses 2014: $30,915Net Income 2014: $6,6162014Revenue 2015: $28,689Expenses 2015: $24,259Net Income 2015: $4,4302015Revenue 2016: $29,248Expenses 2016: $28,796Net Income 2016: $4522016Revenue 2017: $30,875Expenses 2017: $28,565Net Income 2017: $2,3102017Revenue 2018: $32,995Expenses 2018: $30,690Net Income 2018: $2,3052018Revenue 2019: $31,116Expenses 2019: $29,909Net Income 2019: $1,2072019Revenue 2020: $25,996Expenses 2020: $15,507Net Income 2020: $10,4892020Revenue 2021: $25,765Expenses 2021: $9,460Net Income 2021: $16,3052021Revenue 2022: $30,097Expenses 2022: $39,476Net Income 2022: -$9,3792022Revenue 2023: $34,823Expenses 2023: $38,864Net Income 2023: -$4,0412023Revenue 2024: $49,374Expenses 2024: $44,595Net Income 2024: $4,7792024

Highlighted filing

2012

Revenue$25,117
Expenses$31,604
Net Income-$6,487
Jump To
Filing Snapshot
Filing Period
Jan 1, 2012 to Dec 31, 2012
Signed
Apr 24, 2013
Return Version
2012v2.1
Mission and Program Overview

Mission

Public education regarding alcohol addic

Filing and Contact Details

Filer

EIN
99-0241292
Raw XML Appendix144 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
IRS990EZ/ActivitiesNotPreviouslyRpt0false
IRS990EZ/AddressChange0X
IRS990EZ/CashSavingsAndInvestments/BOY019487
IRS990EZ/CashSavingsAndInvestments/EOY013156
IRS990EZ/ContributionsGiftsGrantsEtc025093
IRS990EZ/DidOrgFileForm1120POLThisYear0false
IRS990EZ/DoesOrgHaveHospital0false
IRS990EZ/EngagedInExcessBenefitTrans0false
IRS990EZ/EngageInLobbyingActivities0false
IRS990EZ/EngagePoliticalCmpgnActivities0false
IRS990EZ/ExcessOrDeficitForYear0-6487
IRS990EZ/FiledScheduleA0true
IRS990EZ/ForeignFinancialAccount0false
IRS990EZ/ForeignOffice0false
IRS990EZ/GroProfitLossSalesOfInventory022
IRS990EZ/GrossReceipts025117
IRS990EZ/GrossReceiptsLessThan250000X
IRS990EZ/GrossSalesOfInventory022
IRS990EZ/InfoInScheduleOPartI0X
IRS990EZ/InfoInScheduleOPartII0X
IRS990EZ/InvestmentIncome02
IRS990EZ/LandAndBuildings/BOY00
IRS990EZ/LandAndBuildings/EOY00
IRS990EZ/MadeChangesToOrgnzngEtcDoc0false
IRS990EZ/MadeLoansToFromOfficers0false
IRS990EZ/MaintainAnyDonorAdvisedFunds0false
IRS990EZ/MethodOfAccountingCash0X
IRS990EZ/NetAssetsOrFundBalances/BOY018137
IRS990EZ/NetAssetsOrFundBalancesBOY018137
IRS990EZ/NetAssetsOrFundBalances/EOY011650
IRS990EZ/NetAssetsOrFundBalancesEOY011650
IRS990EZ/OccupancyRentUtilitiesAndMaint03447
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition03.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition13.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition23.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation10
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation20
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc10
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc20
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances10
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances20
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName0Robert Harrison
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName1Coleen Ashworth
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName2Kunani Dreier
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title0Chair
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title1Alternate Chair
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title2Treasurer
IRS990EZ/OperatingSchool0false
IRS990EZ/Organization501c30X
IRS990EZ/OrganizationDissolvedEtc0false
IRS990EZ/OrganizationHadUBI0false
IRS990EZ/OtherAssetsTotal/BOY00
IRS990EZ/OtherAssetsTotal/EOY00
IRS990EZ/OtherExpensesTotal026366
IRS990EZ/PartVIAHghstPaidCntrctProfSer0NONE
IRS990EZ/PartVIOfCompOfHighestPaidEmpl0NONE
IRS990EZ/PrimaryExemptPurpose0PUBLIC EDUCATION REGARDING ALCOHOL ADDIC
IRS990EZ/PrintingPublicationsPostage01791
IRS990EZ/ProgramServiceAccomplishment/DescriptionProgramServiceAccom0HELP AND EDUCATION OF THE PUBLIC REGARDING ALCOHOL ADDICTION HELP AND SUPPORT TO INDIVIDUALS DEALING WITH ALCOHOL RELATED PROBLEMS
IRS990EZ/ProgramServiceAccomplishment/DescriptionProgramServiceAccom1WORKING WITH THE PUBLIC ANONYMOUSLY TO PROVIDE RESOURCES AND HELP OTHERS WITH ALCOHOL RELATED PROBLEMS
IRS990EZ/ProgramServiceAccomplishment/ProgramServiceExpenses029606
IRS990EZ/ProhibitedTaxShelterTrans0false
IRS990EZ/RelatedOrgControlledEntity0false
IRS990EZ/ScheduleBNotRequired0X
IRS990EZ/SubjectToProxyTax0false
IRS990EZ/SumOfTotalLiabilities/BOY01350
IRS990EZ/SumOfTotalLiabilities/EOY01506
IRS990EZ/TanningServicesProvided0false
IRS990EZ/TheBooksAreInCareOf/AddressUS/AddressLine10PO Box 486
IRS990EZ/TheBooksAreInCareOf/AddressUS/City0Hauula
IRS990EZ/TheBooksAreInCareOf/AddressUS/State0HI
IRS990EZ/TheBooksAreInCareOf/AddressUS/ZIPCode096717
IRS990EZ/TheBooksAreInCareOf/NamePerson0Kunani Dreier
IRS990EZ/TheBooksAreInCareOf/TelephoneNumber08082772463
IRS990EZ/TotalAssets/BOY019487
IRS990EZ/TotalAssets/EOY013156
IRS990EZ/TotalExpenses031604
IRS990EZ/TotalProgramServiceExpenses029606
IRS990EZ/TotalRevenue025117
IRS990EZ/TransactionWithControlEntity0false
IRS990EZ/TrnsfrsExemptNonCharRelatedOrg0false
IRS990EZ/WebSite0WWWAREA17AAORG
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYear025093
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYearMinus1Year024119
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYearMinus2Years023002
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYearMinus3Years023436
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYearMinus4Years028121
IRS990ScheduleA/GiftsGrantsContribReceived170/Total0123771
IRS990ScheduleA/GrossInvestmentIncome170/CurrentTaxYear02
IRS990ScheduleA/GrossInvestmentIncome170/CurrentTaxYearMinus1Year05
IRS990ScheduleA/GrossInvestmentIncome170/CurrentTaxYearMinus2Years05
IRS990ScheduleA/GrossInvestmentIncome170/CurrentTaxYearMinus3Years05
IRS990ScheduleA/GrossInvestmentIncome170/CurrentTaxYearMinus4Years012
IRS990ScheduleA/GrossInvestmentIncome170/Total029
IRS990ScheduleA/OtherIncome170/CurrentTaxYear022
IRS990ScheduleA/OtherIncome170/Total022
IRS990ScheduleA/PubliclySupportedOrg170b1Avi0X
IRS990ScheduleA/PublicSupportPertcentage17000.99960
IRS990ScheduleA/PublicSupportTotal1700123771
IRS990ScheduleA/ThirtyThreePercntTestsCY1700X
IRS990ScheduleA/Total170/CurrentTaxYear025093
IRS990ScheduleA/Total170/CurrentTaxYearMinus1Year024119
IRS990ScheduleA/Total170/CurrentTaxYearMinus2Years023002
IRS990ScheduleA/Total170/CurrentTaxYearMinus3Years023436
IRS990ScheduleA/Total170/CurrentTaxYearMinus4Years028121
IRS990ScheduleA/Total170/Total0123771
IRS990ScheduleA/TotalSupport0123822
IRS990ScheduleC/Form4720Filed4955Tax0false
IRS990ScheduleO/GeneralExplanation/Explanation0DESCRIPTION AMOUNT BANK CHARGES 38 COMPUTER EQUIPMENT 250 INSURANCE 516 FEES 3 TRAVEL 24,705 COMMUNITY OUTREACH 762 OFFICE SUPPLIES 92
IRS990ScheduleO/GeneralExplanation/Explanation1CATEGORY BEGINNING OF YEAR END OF YEAR FUNDS HELD FOR INTL CONVENTION 350 700 FUNDS HELD FOR COMPUTER 1,000 806
IRS990ScheduleO/GeneralExplanation/Identifier0O01
IRS990ScheduleO/GeneralExplanation/Identifier1O02
IRS990ScheduleO/GeneralExplanation/ReturnReference0Description of other expenses Part I line 16
IRS990ScheduleO/GeneralExplanation/ReturnReference1Description of total liabilities Part II line 26
ReturnHeader/BuildTS02016-03-07 17:11:31Z
ReturnHeader/Filer/EIN0990241292
ReturnHeader/Filer/Name/BusinessNameLine10HAWAII AREA COMMITTEE
ReturnHeader/Filer/NameControl0HAWA
ReturnHeader/Filer/USAddress/AddressLine102107
ReturnHeader/Filer/USAddress/City0HONOLULU
ReturnHeader/Filer/USAddress/State0HI
ReturnHeader/Filer/USAddress/ZIPCode096814
ReturnHeader/Officer/AuthorizeThirdParty0true
ReturnHeader/Officer/DateSigned02013-04-24
ReturnHeader/Officer/Name0Robert Harrison
ReturnHeader/Officer/Phone08082772463
ReturnHeader/Officer/Title0Chair
ReturnHeader/Preparer/DatePrepared02013-04-30
ReturnHeader/PreparerFirm/EIN0860869769
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10MICHAEL J SNEED CPA PC
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine103740 E SOUTHERN AVE SUITE 212
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0MESA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0AZ
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode085206
ReturnHeader/Preparer/Name0SHERI BROWN
ReturnHeader/Preparer/Phone04802754719
ReturnHeader/ReturnType0990EZ
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-04-30T08:43:09-07:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.92$0.36$0.56$0.49$0.45$0.05
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.75$0.23$0.51$0.35$0.39$0.04
2022Detailed filing. Detailed filing data is available for this year.$0.68$0.12$0.56$0.30$0.39$0.09
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.68$0.03$0.65$0.26$0.09$0.16
2020Summary only. Only limited summary data is available for this year.$0.52$0.03$0.26$0.16$0.10
2019Summary only. Only limited summary data is available for this year.$0.41$0.03$0.31$0.30$0.01
2018Summary only. Only limited summary data is available for this year.$0.39$0.02$0.33$0.31$0.02
2017Detailed filing. Detailed filing data is available for this year.$0.36$0.02$0.34$0.31$0.29$0.02
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.33$0.01$0.32$0.29$0.29$0.00
2015XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.33$0.01$0.32$0.29$0.24$0.04
2014XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.29$0.02$0.27$0.38$0.31$0.07
2013Detailed filing. Detailed filing data is available for this year.$0.23$0.02$0.21$0.32$0.22$0.09
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.13$0.02$0.12$0.25$0.32$0.06
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.19$0.19$1.02$1.05$0.02
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.22$0.22$0.23$0.34$0.11