Civic Intelligence

Herbert C Shipman Foundation

990PF • Fiscal year 2020 • EIN 99-0175917

Aug 01, 2019 to Jul 31, 2020 • Filed on Sep 24, 2020

101 Aupuni Street Suite 139Hilo, HI 96720

(808) 935-5404

Siviq Scores

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

Liabilities / Assets

38th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2020 filings • $500k-$1M nonprofits • Source year 2020

Liabilities / Revenue

37th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2020 filings • $500k-$1M nonprofits • Source year 2020

Net Margin

3rd percentile

-308%

Higher net margin than 3% of similar nonprofits.

2020 filings • $500k-$1M nonprofits • Source year 2020

Top Officer Pay

55th percentile

$0

Higher top officer pay than 55% of similar nonprofits.

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

2020 filings • $500k-$1M nonprofits • Source year 2020

Asset Growth

19th percentile

-5.5%

Faster asset growth than 19% of similar nonprofits.

2020 filings • $500k-$1M nonprofits • Annualized from 2019 to 2020

Revenue Growth

5th percentile

-75%

Faster revenue growth than 5% of similar nonprofits.

2020 filings • $500k-$1M nonprofits • Annualized from 2019 to 2020

Assets

Down

$521,075

Down $30,460 (-5.5%) from 2019

Net Assets

Down

$521,075

Down $27,523 (-5.0%) from 2019

Liabilities

Down

$0

Down $2,937 (-100%) from 2019

Revenue

Down

$8,922

Down $26,371 (-75%) from 2019

Expenses

Down

$36,445

Down $2,245 (-5.8%) from 2019

Net Income

Down

-$27,523

Down $24,126 (-710%) from 2019

Historical Trend

Balance Sheet Trend

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

$600K$400K$200K$0Assets 2011: $517,701Liabilities 2011: $0Net Assets 2011: $517,7012011Assets 2012: $516,395Liabilities 2012: $0Net Assets 2012: $516,3952012Assets 2013: $584,139Liabilities 2013: $0Net Assets 2013: $584,1392013Assets 2014: $568,714Liabilities 2014: $0Net Assets 2014: $568,7142014Assets 2015: $567,592Liabilities 2015: $0Net Assets 2015: $567,5922015Assets 2016: $539,499Liabilities 2016: $0Net Assets 2016: $539,4992016Assets 2017: $533,252Liabilities 2017: $0Net Assets 2017: $533,2522017Assets 2018: $551,995Liabilities 2018: $0Net Assets 2018: $551,9952018Assets 2019: $551,535Liabilities 2019: $2,937Net Assets 2019: $548,5982019Assets 2020: $521,075Liabilities 2020: $0Net Assets 2020: $521,0752020Assets 2021: $501,016Liabilities 2021: $0Net Assets 2021: $501,0162021Assets 2022: $545,325Liabilities 2022: $0Net Assets 2022: $545,3252022Assets 2023: $521,868Liabilities 2023: $0Net Assets 2023: $521,8682023

Highlighted filing

2020

Assets$521,075
Liabilities$0
Net Assets$521,075

Operations Trend

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

$100K$50K$0-$50KExpenses 2011: $31,1072011Expenses 2012: $26,7782012Expenses 2013: $22,7562013Revenue 2014: $28,057Expenses 2014: $43,482Net Income 2014: -$15,4252014Revenue 2015: $35,340Expenses 2015: $36,462Net Income 2015: -$1,1222015Revenue 2016: $8,340Expenses 2016: $36,433Net Income 2016: -$28,0932016Revenue 2017: $25,354Expenses 2017: $31,601Net Income 2017: -$6,2472017Revenue 2018: $53,322Expenses 2018: $34,579Net Income 2018: $18,7432018Revenue 2019: $35,293Expenses 2019: $38,690Net Income 2019: -$3,3972019Revenue 2020: $8,922Expenses 2020: $36,445Net Income 2020: -$27,5232020Revenue 2021: $15,517Expenses 2021: $35,576Net Income 2021: -$20,0592021Revenue 2022: $83,075Expenses 2022: $38,766Net Income 2022: $44,3092022Revenue 2023: $15,581Expenses 2023: $39,038Net Income 2023: -$23,4572023

Highlighted filing

2020

Revenue$8,922
Expenses$36,445
Net Income-$27,523
Jump To
Filing Snapshot
Filing Period
Aug 1, 2019 to Jul 31, 2020
Signed
Sep 24, 2020
Return Version
2019v5.1
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
OLIVER ENGLISHDirector-$0--
NANCY CABRALPresident/Sec/Treas-$0--
BARBARA TAKASEVice President-$0--
DOUG ADAMSDirector-$0--
Filing and Contact Details

Filer

Filer Name
Herbert C Shipman Foundation
EIN
99-0175917
Phone
8089355404
Address
101 AUPUNI STREET SUITE 139, HILO, HI 96720

Signing Officer

Name
Nancy Cabral
Title
President
Phone
8089355404
Signed
2020-09-24
Discuss with paid preparer
Yes

Preparer

Firm
Taketa Iwata Hara & Associates LLC
Address
101 AUPUNI STREET SUITE 139, HILO, HI 96720
Preparer
Brian M Iwata
Phone
8089355404
Raw XML Appendix373 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
AccountingFeesSchedule/AccountingFeesDetail/Amt03763
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0ACCOUNTING FEES
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt00
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt03763
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt041012
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt053028
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0WCM FOCUSED INTL GROWTH FUND INSTL (WCMIX)
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt016032
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt1151896
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt220317
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt316146
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt420184
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt537364
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt693331
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt747353
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt853295
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0FIDELITY MSCI INFORMATION (FTEC)
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1ISHARES CORE S&P TOTAL US STOCK (ITOT)
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt2ISHARES TR U.S. MED DVC ETF
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt3ISHARES EDGE MSCI USA MOMENTUM (MTUM)
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt4ISHARES EDGE MSCI USA MOMENTUM (VLUE)
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt5ISHARES INC CORE MSCI EMERGING MRKTS ETF
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt6ISHARES CORE U.S. AGGREGATE BOND EFF
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt7ISHARES IBOXX INVESTMENT GRADE
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt8PIMCO ETF TR ACTIVE BD ETF
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt022154
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt1173759
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt222272
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt319020
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt421328
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt537852
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt694572
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt752020
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt856889
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd1AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd2AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd3AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd4AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd5AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd6AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd7AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd8AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt021220
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt0-12298
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt08922
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt08922
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt03763
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt03763
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt029000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt029000
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt021220
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt021220
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-27523
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0614573
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt0-12298
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt014060
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesNetInvstIncmAmt03397
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt03397
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0285
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt029000
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt07160
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt036445
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt021220
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt08922
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt07160
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt07445
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt0626871
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-12298
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-12298
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt0614573
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0FIDELITY
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt0-12298
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-27523
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0521075
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0548598
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0521075
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt028216
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt028216
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt028216
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt028357
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0141
IRS990PF/DistributableAmountGrp/TotalTaxAmt0141
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt0807
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/BackupWithholdingWithheldAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0948
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0141
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt0807
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0141
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0141
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0948
IRS990PF/FMVAssetsEOYAmt0577039
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsBOYAmt077643
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0182828
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt041012
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt053028
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt0291064
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt0455918
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt0499866
IRS990PF/Form990PFBalanceSheetsGrp/OtherLiabilitiesBOYAmt02937
IRS990PF/Form990PFBalanceSheetsGrp/OtherLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0548598
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0521075
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt024145
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt024145
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0551535
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0521075
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0577039
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt02937
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0551535
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0521075
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0548598
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0521075
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0575775
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt019984
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0555791
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt08637
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt028357
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0567138
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0575775
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt00.25
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt10.50
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt20.25
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt30.25
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt30
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt30
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt30
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0OLIVER ENGLISH
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1NANCY CABRAL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm2BARBARA TAKASE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm3DOUG ADAMS
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0DIRECTOR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1PRESIDENT/SEC/TREAS
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt2VICE PRESIDENT
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt3DIRECTOR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt016-523 KEAAU-PAHOA ROAD
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt12 KAMEHAMEHA AVE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt2287 KANOELANI ST
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt3PO BOX 6926
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0KEAAU
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1HILO
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm2HILO
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm3HILO
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0HI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1HI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd2HI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd3HI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd096749
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd196720
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd296720
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd396720
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt028129
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt028270
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt029715
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt028130
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt025581
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt029650
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt029209
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.049599
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.051592
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.045862
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.044852
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.057282
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.048406
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0141
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0567138
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0575963
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0613357
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0570345
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0517613
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0603413
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt029000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.247994
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt028859
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt029000
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt0141
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt029000
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd00
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd00
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd00
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd00
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd00
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd00
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/SubjToTaxRmnrtnExPrchtPymtInd00
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd00
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd00
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd00
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd01
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd00
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd01
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd00
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd00
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd00
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd01
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0TAKETA IWATA HARA ASSOCIATES LL
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd00
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0101 AUPUNI STREET SUITE 139
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0HILO
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0HI
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd096720
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd00
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd00
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd00
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0HI
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd00
IRS990PF/StatementsRegardingActyGrp/PhoneNum08089355404
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd00
IRS990PF/StatementsRegardingActyGrp/Section4955ManagersTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section4955OrganizationTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd01
IRS990PF/StatementsRegardingActyGrp/TaxReimbursedAmt00
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd00
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SumOfProgramRelatedInvstGrp/TotalAmt00
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt015000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt114000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0SCHOLARSHIPS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1SUPPORT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0HAWAII COMMUNITY FOUNDATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt1ROTARY CLUB OF HILO FOUNDATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0501(C)(3)
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1501(C)(3)
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0827 FORT STREET MALL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt1PO BOX 4192
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0HONOLULU
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1HILO
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0HI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1HI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd0968134317
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd196720
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt029000
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd00
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt0764
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt028236
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt028216
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt029000
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt027452
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt028236
OtherLiabilitiesSchedule/OtherLiabilitiesDetail/BOYBookValueAmt02937
OtherLiabilitiesSchedule/OtherLiabilitiesDetail/Desc0BANK OVERDRAFT
OtherLiabilitiesSchedule/OtherLiabilitiesDetail/EOYBookValueAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt03397
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0ADVISORY FEES
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/DisbursementsCharitablePrpsAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/NetInvestmentIncomeAmt03397
TaxesSchedule/TaxesDetail/Amt0285
TaxesSchedule/TaxesDetail/CategoryTxt0EXCISE TAX
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
ReturnHeader/BuildTS02021-04-22 16:20:28Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0NANCY CABRAL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum08089355404
ReturnHeader/BusinessOfficerGrp/SignatureDt02020-09-24
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0HERBERT C SHIPMAN FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0HERB
ReturnHeader/Filer/EIN0990175917
ReturnHeader/Filer/PhoneNum08089355404
ReturnHeader/Filer/USAddress/AddressLine1Txt0101 AUPUNI STREET SUITE 139
ReturnHeader/Filer/USAddress/CityNm0HILO
ReturnHeader/Filer/USAddress/StateAbbreviationCd0HI
ReturnHeader/Filer/USAddress/ZIPCd096720
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0858C669B49D8D797AE88FD3AA651DC76581CD475
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0FA6914B6CB02A97D6AE55F3D5F2ADB1A2E2631D7
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt066.91.146.226
ReturnHeader/FilingSecurityInformation/IPDt02020-09-24
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0HS
ReturnHeader/FilingSecurityInformation/IPTm013:45:21
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0593783195
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0TAKETA IWATA HARA & ASSOCIATES LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0101 AUPUNI STREET SUITE 139
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0HILO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0HI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd096720
ReturnHeader/PreparerPersonGrp/PhoneNum08089355404
ReturnHeader/PreparerPersonGrp/PreparationDt02020-09-23
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0BRIAN M IWATA
ReturnHeader/ReturnTs02020-10-02T19:50:49-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02019-08-01
ReturnHeader/TaxPeriodEndDt02020-07-31
ReturnHeader/TaxYr02019

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$5.22$0.00$5.22$0.16$0.39$0.23
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$5.45$0.00$5.45$0.83$0.39$0.44
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$5.01$0.00$5.01$0.16$0.36$0.20
2020Detailed filing. Detailed filing data is available for this year.$5.21$0.00$5.21$0.09$0.36$0.28
2019Detailed filing. Detailed filing data is available for this year.$5.52$0.03$5.49$0.35$0.39$0.03
2018Detailed filing. Detailed filing data is available for this year.$5.52$0.00$5.52$0.53$0.35$0.19
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$5.33$0.00$5.33$0.25$0.32$0.06
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$5.39$0.00$5.39$0.08$0.36$0.28
2015Detailed filing. Detailed filing data is available for this year.$5.68$0.00$5.68$0.35$0.36$0.01
2014XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$5.69$0.00$5.69$0.28$0.43$0.15
2013Detailed filing. Detailed filing data is available for this year.$5.84$0.00$5.84$0.23
2012Detailed filing. Detailed filing data is available for this year.$5.16$0.00$5.16$0.27
2011Detailed filing. Detailed filing data is available for this year.$5.18$0.00$5.18$0.31