Civic Intelligence

Herbert C Shipman Foundation

990PF • Fiscal year 2023 • EIN 99-0175917

Aug 01, 2022 to Jul 31, 2023 • Filed on Nov 29, 2023

Organization Profile
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

40th percentile

0.00x

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

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

Liabilities / Revenue

40th percentile

0.00x

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

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

Net Margin

6th percentile

-151%

Higher net margin than 6% of similar nonprofits.

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

Top Officer Pay

57th percentile

$0

Higher top officer pay than 57% of similar nonprofits.

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

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

Asset Growth

27th percentile

-4.3%

Faster asset growth than 27% of similar nonprofits.

2023 filings • $500k-$1M nonprofits • Annualized from 2022 to 2023

Revenue Growth

3rd percentile

-81%

Faster revenue growth than 3% of similar nonprofits.

2023 filings • $500k-$1M nonprofits • Annualized from 2022 to 2023

Balance Sheet
Liabilities / Assets40th percentile

Assets

Down

$521,868

Down $23,457 (-4.3%) from 2022

Net Assets

Down

$521,868

Down $23,457 (-4.3%) from 2022

Liabilities

Flat

$0

Flat from 2022

Revenue And Expenses
Liabilities / Revenue40th percentileNet Margin6th percentile

Revenue

Down

$15,581

Down $67,494 (-81%) from 2022

Expenses

Up

$39,038

Up $272 (+0.7%) from 2022

Net Income

Down

-$23,457

Down $67,766 (-153%) from 2022

Historical Trend

Balance Sheet Trend

Asset Growth27th percentile

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

2023

Assets$521,868
Liabilities$0
Net Assets$521,868
Open 2023 Filing

Operations Trend

Revenue Growth3rd percentile

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

2023

Revenue$15,581
Expenses$39,038
Net Income-$23,457
Open 2023 Filing
Jump To
Filing Snapshot
Filing Period
Aug 1, 2022 to Jul 31, 2023
Signed
Nov 29, 2023
Return Version
2022v5.0
Compensation and Service Providers
Top Officer Pay57th percentile

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
2023-11-29
Discuss with paid preparer
Yes

Preparer

Firm
Taketa Iwata Hara & Associates LLC
Address
101 AUPUNI STREET SUITE 139, HILO, HI 96720
Preparer
Nathan Colgrove
Phone
8089355404
Raw XML Appendix361 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/Amt03822
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0ACCOUNTING FEES
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt00
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt03822
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm0BLACKROCK STRATEGIC INC OPP (BSIIX)
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm1JPMORGAN CORE BOND CLASS (WOBDX)
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm2PIMCO INCOME FUND CL A (PONAX)
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt022004
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt1129920
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt239680
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt021427
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt1114517
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt234765
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt034273
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt125512
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt217209
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt326714
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt039547
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt124335
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt218918
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt326893
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0WCM FOCUSED INTL GROWTH FUND INSTL (WCMRX)
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm1BARON EMERGING MARKETS FUND (BEXIX)
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm2JPMORGAN HEDGED EQUITY GLASS I (JHEQX)
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm3GOLDMAN SACHS INTL EQTY INC (GSIKX)
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt089885
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt114506
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt232013
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt325623
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt428822
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt58042
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0ISHARES CORE S&P TOTAL US STOCK (ITOT)
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1ISHARES TR CORE MSCI EAFE (IEFA)
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt2SCHWAB US DIV EQUITY (SCHD)
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt3ISHARES TR 10-20 YR TRS ETF (TLH)
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt4ISHARES TR MSCI USA QLT FCT (QUAL)
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt5ISHARES TR SHORT TREAS BD (SHV)
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt0136268
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt113562
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt233215
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt323726
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt432613
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt58062
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd1AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd2AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd3AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd4AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd5AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DividendsAndInterestFromSecDtl/ExclusionAmt015473
IRS990PF/AnalysisIncomeProducingActyGrp/DividendsAndInterestFromSecDtl/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt0108
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt015581
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt015581
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt03822
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt03822
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt0108
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt030200
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt030200
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt015473
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt015473
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-23457
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0260858
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt0108
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt08088
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblAmt04
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt04
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesNetInvstIncmAmt03671
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt03671
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt01341
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt030204
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt07493
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt039038
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt015581
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt015581
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt04
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt07493
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt08838
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt0260750
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-58
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt1166
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-58
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt1166
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt0260692
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt1166
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0FIDELITY INVESTMENTS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1CAPITAL GAINS DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt0108
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-23457
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0521868
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0545325
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0521868
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt026836
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt026836
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt026836
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt026948
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0112
IRS990PF/DistributableAmountGrp/TotalTaxAmt0112
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt0928
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/BackupWithholdingWithheldAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt01040
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExemptFrgnOrgTaxWthldAtSrceAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0112
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt0928
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0112
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0112
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt01040
IRS990PF/FMVAssetsEOYAmt0555513
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsBOYAmt0167547
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYAmt0191604
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYFMVAmt0170709
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt069383
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0103708
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0109693
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt0297375
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt0198891
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt0247446
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0545325
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0521868
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt011020
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt027665
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt027665
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0545325
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0521868
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0555513
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0545325
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0521868
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0545325
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0521868
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0547174
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt021874
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0525300
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt08208
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt026948
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0538966
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0547174
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt12.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt31.00
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/PFQualifyingDistributionsGrp/ExpensesAndContributionsAmt030204
IRS990PF/PFQualifyingDistributionsGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/PFQualifyingDistributionsGrp/QualifyingDistributionsAmt030204
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/Amt021200
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt19000
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/TotalGrantOrContriPdDurYrAmt030200
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/AppliedToCurrentYearAmt055
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt030149
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt026836
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt030204
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt026781
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt030149
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0LICENSE & PERMITS
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt04
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt04
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt03671
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0ADVISORY FEES
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/DisbursementsCharitablePrpsAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/NetInvestmentIncomeAmt03671
TaxesSchedule/TaxesDetail/Amt01341
TaxesSchedule/TaxesDetail/CategoryTxt0EXCISE TAX
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd02
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0NANCY CABRAL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum08089355404
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-11-29
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/IRSResponsiblePrtyInfoCurrInd00
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/PreparationDt02023-11-29
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0NATHAN COLGROVE
ReturnHeader/ReturnTs02023-12-07T15:04:13-06:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0NANCY
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0CABRAL
ReturnHeader/TaxPeriodBeginDt02022-08-01
ReturnHeader/TaxPeriodEndDt02023-07-31
ReturnHeader/TaxYr02022

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$521,868
Liabilities
$0
Net assets
$521,868
Revenue
$15,581
Expenses
$39,038
Net income
-$23,457
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023Detailed filing. Detailed filing data is available for this year.$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
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$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