Civic Intelligence

Professional Insurance Agents of Hawaii Incorporated

990EZ • Fiscal year 2019 • EIN 99-0248796

Jan 01, 2019 to Dec 31, 2019 • Filed on May 11, 2020

C/O 1247 Kelewina StreetKailua, HI 96734-4517

(808) 261-9460

Siviq Scores

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

Liabilities / Assets

98th percentile

1.41x

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

2019 filings • 501(c)6 • <$500k nonprofits • Source year 2019

Liabilities / Revenue

88th percentile

0.27x

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

2019 filings • 501(c)6 • <$500k nonprofits • Source year 2019

Net Margin

27th percentile

-6.7%

Higher net margin than 27% of similar nonprofits.

2019 filings • 501(c)6 • <$500k nonprofits • Source year 2019

Top Officer Pay

83rd percentile

$42,990

Higher top officer pay than 83% of similar nonprofits.

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

2019 filings • 501(c)6 • <$500k nonprofits • Source year 2019

Asset Growth

10th percentile

-33%

Faster asset growth than 10% of similar nonprofits.

2019 filings • 501(c)6 • <$500k nonprofits • Annualized from 2018 to 2019

Revenue Growth

82nd percentile

23%

Faster revenue growth than 82% of similar nonprofits.

2019 filings • 501(c)6 • <$500k nonprofits • Annualized from 2018 to 2019

Assets

Down

$14,358

Down $7,063 (-33%) from 2018

Net Assets

Down

-$5,878

Down $4,983 (-557%) from 2018

Liabilities

Down

$20,236

Down $2,080 (-9.3%) from 2018

Revenue

Up

$74,637

Up $13,741 (+23%) from 2018

Expenses

Down

$79,620

Down $28,039 (-26%) from 2018

Net Income

Up

-$4,983

Up $41,780 (+89%) from 2018

Historical Trend

Balance Sheet Trend

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

$200K$150K$100K$50K$0-$50KAssets 2011: $153,856Liabilities 2011: $1,7772011Assets 2012: $75,625Liabilities 2012: $1872012Assets 2013: $87,233Liabilities 2013: $1872013Assets 2014: $103,859Liabilities 2014: $1872014Assets 2015: $84,241Liabilities 2015: $1872015Assets 2016: $51,901Liabilities 2016: $2,1152016Assets 2017: $139,557Liabilities 2017: $93,6902017Assets 2018: $21,421Liabilities 2018: $22,316Net Assets 2018: -$8952018Assets 2019: $14,358Liabilities 2019: $20,236Net Assets 2019: -$5,8782019Assets 2020: $11,613Liabilities 2020: $21,757Net Assets 2020: -$10,1442020Assets 2021: $14,195Liabilities 2021: $25,684Net Assets 2021: -$11,4892021Assets 2022: $20,790Liabilities 2022: $27,765Net Assets 2022: -$6,9752022Assets 2023: $0Net Assets 2023: $02023

Highlighted filing

2019

Assets$14,358
Liabilities$20,236
Net Assets-$5,878

Operations Trend

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

$200K$100K$0-$100KRevenue 2011: $135,812Expenses 2011: $184,427Net Income 2011: -$48,6152011Revenue 2012: $120,856Expenses 2012: $196,668Net Income 2012: -$75,8122012Revenue 2013: $149,802Expenses 2013: $138,194Net Income 2013: $11,6082013Revenue 2014: $144,701Expenses 2014: $128,075Net Income 2014: $16,6262014Revenue 2015: $127,845Expenses 2015: $147,463Net Income 2015: -$19,6182015Revenue 2016: $105,309Expenses 2016: $139,577Net Income 2016: -$34,2682016Revenue 2017: $122,800Expenses 2017: $126,719Net Income 2017: -$3,9192017Revenue 2018: $60,896Expenses 2018: $107,659Net Income 2018: -$46,7632018Revenue 2019: $74,637Expenses 2019: $79,620Net Income 2019: -$4,9832019Revenue 2020: $59,573Expenses 2020: $63,839Net Income 2020: -$4,2662020Revenue 2021: $59,859Expenses 2021: $61,204Net Income 2021: -$1,3452021Revenue 2022: $63,522Expenses 2022: $59,008Net Income 2022: $4,5142022Revenue 2023: $20,044Expenses 2023: $13,070Net Income 2023: $6,9742023

Highlighted filing

2019

Revenue$74,637
Expenses$79,620
Net Income-$4,983
Jump To
Filing Snapshot
Filing Period
Jan 1, 2019 to Dec 31, 2019
Signed
May 11, 2020
Return Version
2019v5.0
Gross Receipts
$74,637
Mission and Program Overview

Mission

To provide education to insurance industry workers and provide the public with properly trained workers

Program Services

DescriptionGrantsExpenses
SEMINARS ARE CONDUCTED TO EDUCATE INSURANCE PROFESSIONALS. ALL ARE REQUIRED TO REQUALIFY PERIODICALLY. LICENSING EXAMS ARE ALSO CONDUCTED.--
ERROR AND OMISSIONS PROVIDERS ARE OBTAINED, MOST ARE MEMBERS (UTICA). PIA PRO ERRORS AND OMISSIONS COVERAGE IS ONLY AVAILABLE TO PIA MEMBERS.--
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
JOHN LOOExecutive VIPT$36,717$6,273$42,990
TAY PERRYDirector-$0--
VICTOR PUNUA SRSecretary /-$0--
WAYNE WEHRDirector & Natl D-$0--
WAYNE WATANABEPresident-$0--
WILLIAM JONESVice Preside-$0--
Filing and Contact Details

Filer

Filer Name
Professional Insurance Agents of
EIN
99-0248796
Phone
8082619460
Address
C/O 1247 KELEWINA STREET, KAILUA, HI 96734-4517

Signing Officer

Name
John Loo
Title
Executive Vice Pres
Phone
8082619460
Signed
2020-05-11
Discuss with paid preparer
Yes

Preparer

Firm
Terry T Tamuracpa
Address
45-270 WILLIAM HENRY RD STE 202, KANEOHE, HI 96744-5808
Preparer
Terry T Tamura
Phone
8082354543
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

Expenses office supplies 493 internet 1,356 travel 7,259 interest 29 insurance 4,692 bank fees 283 dues and subscriptions 2,912 education and seminars 4,393 equipment rental 996 general excise tax 35 licenses and fees 1,995 telephone 1,971 utilities 1,194 nondeductible 459 total 28,067

Form 990-ez, Part II, Line 24

Office fixtures and equipment 9,358 9,358 less accumulated depreciation 9,358 9,358 total 0 0

Form 990-ez, Part II, Line 26

Other liabilites 19,386 13,734 accrued payroll taxes 1,055 540 accrued wages 1,875 5,962

Form 990-ez, Part III

To provide education to insurance industry workers and provide the public with properly trained workers

Raw XML Appendix123 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/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0PROFESSIONAL INSURANCE AGENTS OF HI
IRS990EZ/BooksInCareOfDetail/PhoneNum08082619460
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt01247 KELEWINA STREET
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0KAILUA
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0HI
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd096734
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt021421
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt014358
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-4983
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt03016
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt021421
IRS990EZ/Form990TotalAssetsGrp/EOYAmt014358
IRS990EZ/GrossReceiptsAmt074637
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0-895
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0-5878
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0-895
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0-5878
IRS990EZ/OccupancyRentUtltsAndMaintAmt02100
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt130.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt31.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt41.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt51.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt136717
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt06273
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0TAY PERRY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1JOHN LOO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2VICTOR PUNUA SR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3WAYNE WEHR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4WAYNE WATANABE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5WILLIAM JONES
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1EXECUTIVE VI
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY /
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3DIR & NATL D
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5VICE PRESIDE
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationFiled990TInd0true
IRS990EZ/OrganizationHadUBIInd0true
IRS990EZ/OtherExpensesTotalAmt028067
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO PROVIDE EDUCATION TO INSURANCE INDUSTRY WORKERS AND PROVIDE THE PUBLIC WITH PROPERLY TRAINED WORKERS
IRS990EZ/ProgramServiceRevenueAmt074637
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0SEMINARS ARE CONDUCTED TO EDUCATE INSURANCE PROFESSIONALS. ALL ARE REQUIRED TO REQUALIFY PERIODICALLY. LICENSING EXAMS ARE ALSO CONDUCTED.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1ERROR AND OMISSIONS PROVIDERS ARE OBTAINED, MOST ARE MEMBERS (UTICA). PIA PRO ERRORS AND OMISSIONS COVERAGE IS ONLY AVAILABLE TO PIA MEMBERS.
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt046437
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt022316
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt020236
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt079620
IRS990EZ/TotalRevenueAmt074637
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.PIAHAWAII.COM
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES OFFICE SUPPLIES 493 INTERNET 1,356 TRAVEL 7,259 INTEREST 29 INSURANCE 4,692 BANK FEES 283 DUES AND SUBSCRIPTIONS 2,912 EDUCATION AND SEMINARS 4,393 EQUIPMENT RENTAL 996 GENERAL EXCISE TAX 35 LICENSES AND FEES 1,995 TELEPHONE 1,971 UTILITIES 1,194 NONDEDUCTIBLE 459 TOTAL 28,067
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1OFFICE FIXTURES AND EQUIPMENT 9,358 9,358 LESS ACCUMULATED DEPRECIATION 9,358 9,358 TOTAL 0 0
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2OTHER LIABILITES 19,386 13,734 ACCRUED PAYROLL TAXES 1,055 540 ACCRUED WAGES 1,875 5,962
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3TO PROVIDE EDUCATION TO INSURANCE INDUSTRY WORKERS AND PROVIDE THE PUBLIC WITH PROPERLY TRAINED WORKERS
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART II, LINE 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART II, LINE 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART III
ReturnHeader/BuildTS02020-11-06 18:47:13Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0JOHN LOO
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0EXECUTIVE VICE PRES
ReturnHeader/BusinessOfficerGrp/PhoneNum08082619460
ReturnHeader/BusinessOfficerGrp/SignatureDt02020-05-11
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0PROFESSIONAL INSURANCE AGENTS OF
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0HAWAII INCORPORATED
ReturnHeader/Filer/BusinessNameControlTxt0PROF
ReturnHeader/Filer/EIN0990248796
ReturnHeader/Filer/PhoneNum08082619460
ReturnHeader/Filer/USAddress/AddressLine1Txt0C/O 1247 KELEWINA STREET
ReturnHeader/Filer/USAddress/CityNm0KAILUA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0HI
ReturnHeader/Filer/USAddress/ZIPCd0967344517
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId00788983C9A250A1E34315337053B6A728A97F049
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId00788983C9A250A1E34315337053B6A728A97F049
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt067.52.93.122
ReturnHeader/FilingSecurityInformation/IPDt02020-06-01
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm019:54:45
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0990198967
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0TERRY T TAMURACPA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt045-270 WILLIAM HENRY RD STE 202
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0KANEOHE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0HI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0967445808
ReturnHeader/PreparerPersonGrp/PhoneNum08082354543
ReturnHeader/PreparerPersonGrp/PreparationDt02020-05-11
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0TERRY T TAMURA
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02020-06-01T19:54:45-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02019-01-01
ReturnHeader/TaxPeriodEndDt02019-12-31
ReturnHeader/TaxYr02019

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings