Civic Intelligence

David C AI Charitable Trust

990T • Fiscal year 2023 • EIN 99-6078252

Jan 01, 2023 to Dec 31, 2023 • Filed on Nov 06, 2024

PO Box 1559Honolulu, HI 96806

(808) 529-5834

Siviq Scores

Scores are not available for this record yet.

Balance Sheet

Assets

-

No earlier filing loaded for comparison.

Net Assets

-

No earlier filing loaded for comparison.

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses

Revenue

-

No earlier filing loaded for comparison.

Expenses

-

No earlier filing loaded for comparison.

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

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

$20M$15M$10M$5.0M$0Assets 2010: $3,559,275Liabilities 2010: $0Net Assets 2010: $3,559,2752010Assets 2011: $3,618,413Liabilities 2011: $0Net Assets 2011: $3,618,4132011Assets 2013: $3,550,359Liabilities 2013: $0Net Assets 2013: $3,550,3592013Assets 2014: $3,699,103Liabilities 2014: $0Net Assets 2014: $3,699,1032014Assets 2015: $3,843,893Liabilities 2015: $0Net Assets 2015: $3,843,8932015Assets 2016: $3,801,122Liabilities 2016: $0Net Assets 2016: $3,801,1222016Assets 2017: $3,642,353Liabilities 2017: $0Net Assets 2017: $3,642,3532017Assets 2018: $3,601,438Liabilities 2018: $0Net Assets 2018: $3,601,4382018Assets 2019: $3,756,266Liabilities 2019: $0Net Assets 2019: $3,756,2662019Assets 2020: $3,849,318Liabilities 2020: $0Net Assets 2020: $3,849,3182020Assets 2021: $4,205,692Liabilities 2021: $0Net Assets 2021: $4,205,6922021Assets 2022: $9,123,580Liabilities 2022: $0Net Assets 2022: $9,123,5802022Assets 2023: $15,046,086Liabilities 2023: $0Net Assets 2023: $15,046,0862023Assets 2024: $15,740,860Liabilities 2024: $0Net Assets 2024: $15,740,8602024

Latest loaded filing

2024

Assets$15,740,860
Liabilities$0
Net Assets$15,740,860

Operations Trend

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

$6.0M$4.0M$2.0M$0-$2.0MExpenses 2010: $287,4672010Revenue 2011: $270,795Expenses 2011: $178,566Net Income 2011: $92,2292011Revenue 2013: $61,117Expenses 2013: $99,142Net Income 2013: -$38,0252013Revenue 2014: $267,287Expenses 2014: $74,881Net Income 2014: $192,4062014Revenue 2015: $568,256Expenses 2015: $392,756Net Income 2015: $175,5002015Revenue 2016: $433,007Expenses 2016: $520,712Net Income 2016: -$87,7052016Revenue 2017: $408,440Expenses 2017: $627,501Net Income 2017: -$219,0612017Revenue 2018: $606,990Expenses 2018: $551,494Net Income 2018: $55,4962018Revenue 2019: $161,906Expenses 2019: $138,340Net Income 2019: $23,5662019Revenue 2020: $161,391Expenses 2020: $132,592Net Income 2020: $28,7992020Revenue 2021: $440,420Expenses 2021: $149,740Net Income 2021: $290,6802021Revenue 2022: $96,996Expenses 2022: $316,582Net Income 2022: -$219,5862022Revenue 2023: $5,774,205Expenses 2023: $945,925Net Income 2023: $4,828,2802023Revenue 2024: $797,026Expenses 2024: $1,082,780Net Income 2024: -$285,7542024

Latest loaded filing

2024

Revenue$797,026
Expenses$1,082,780
Net Income-$285,754
Jump To
Filing Snapshot
Filing Period
Jan 1, 2023 to Dec 31, 2023
Signed
Nov 6, 2024
Return Version
2023v7.0
Mission and Program Overview

Mission

"the trustee shall distribute all of the net income of the charitable trust each year and may distribute so much or all of the principal of the charitbale trust as it deems necessary for the charitable trust's purposes, consistent with the long term needs of the beneficiaries." "payment shall be made, first, to the nuuanu ymca, honolulu, hawaii, to fund its teen fitness program...". "any net income remaining and any principal distributions the trustee may deem necessary shall be distributed to such one or more charitable orginizations listed on exhibit iii ... In such amounts, as the trustee shall determine."

Filing and Contact Details

Filer

Filer Name
David C Ai Charitable Trust
EIN
99-6078252
Phone
8085295834
Address
PO BOX 1559, HONOLULU, HI 96806

Signing Officer

Name
Steven C Ai
Title
Trustee
Phone
8085295834
Signed
2024-11-06
Discuss with paid preparer
Yes

Preparer

Firm
Cw Associates Cpas
Address
700 BISHOP STREET SUITE 1040, HONOLULU, HI 96813
Preparer
Melanie a King
Phone
8085311040
Raw XML Appendix187 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
IRS1041ScheduleD/CapitalLossLimitationAmt03000
IRS1041ScheduleD/EstateOrTrustCapGainOrLossGrp/NetLongTermGainOrLossGrp/TotalForYearAmt0-3393582
IRS1041ScheduleD/EstateOrTrustCapGainOrLossGrp/NetSTCapitalGainOrLossAmt0775
IRS1041ScheduleD/EstateOrTrustCapGainOrLossGrp/TotalNetGainOrLossAmt0-3392807
IRS1041ScheduleD/LTCapitalLossCarryoverAmt0130912
IRS1041ScheduleD/NetLTCapitalGainOrLossAmt0-3393582
IRS1041ScheduleD/NetLTGainOrLossFromSchK1Amt0-317792
IRS1041ScheduleD/NetSTCapitalGainOrLossAmt0775
IRS1041ScheduleD/NetSTGainOrLossFromSchK1Amt0775
IRS1041ScheduleD/TotalCapitalGainOrLossGrp/NetLongTermGainOrLossGrp/TotalForYearAmt0-3393582
IRS1041ScheduleD/TotalCapitalGainOrLossGrp/NetSTCapitalGainOrLossAmt0775
IRS1041ScheduleD/TotalCapitalGainOrLossGrp/TotalNetGainOrLossAmt0-3392807
IRS1041ScheduleD/TotalLTCGL1099BNotReceivedGrp/TotalCostOrOtherBasisAmt016414898
IRS1041ScheduleD/TotalLTCGL1099BNotReceivedGrp/TotalGainOrLossAmt0-2944878
IRS1041ScheduleD/TotalLTCGL1099BNotReceivedGrp/TotalProceedsSalesPriceAmt013470020
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/AcquiredDt02003-08-09
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/CostOrOtherBasisAmt016414898
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt0-2944878
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/ProceedsSalesPriceAmt013470020
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc0SALE OF CITY MILL STOCK
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/SoldOrDisposedDt02023-05-31
IRS8949/LongTermCapitalGainAndLossGrp/TotalCostOrOtherBasisAmt016414898
IRS8949/LongTermCapitalGainAndLossGrp/TotalGainOrLossAmt0-2944878
IRS8949/LongTermCapitalGainAndLossGrp/TotalProceedsSalesPriceAmt013470020
IRS8949/LongTermCapitalGainAndLossGrp/TransactionsNotRptedOn1099BInd0X
IRS990T/BooksInCareOfDetail/PersonNm0MR STEVEN C AI
IRS990T/BooksInCareOfDetail/PhoneNum08085295834
IRS990T/BooksInCareOfDetail/USAddress/AddressLine1Txt0660 NORTH NIMITZ HIGHWAY-ADMIN OFF
IRS990T/BooksInCareOfDetail/USAddress/CityNm0HONOLULU
IRS990T/BooksInCareOfDetail/USAddress/StateAbbreviationCd0HI
IRS990T/BooksInCareOfDetail/USAddress/ZIPCd096817
IRS990T/BookValueAssetsEOYAmt015046086
IRS990T/CharitableContributionsDedAmt00
IRS990T/EstimatedTaxPaymentsAmt0141000
IRS990T/ForeignAccountsQuestionInd00
IRS990T/ForeignTrustQuestionInd00
IRS990T/Form990TScheduleAAttachedCnt02
IRS990T/Organization501cTrustInd0X
IRS990T/Organization501IndicatorGrp/Organization501cTypeTxt0c3
IRS990T/Organization501IndicatorGrp/Organization501Ind0X
IRS990T/OtherTaxesAmt00
IRS990T/OverpaymentSection/AppliedToESTaxAmt0141000
IRS990T/OverpaymentSection/OverpaymentAmt0141000
IRS990T/OverpaymentSection/RefundAmt00
IRS990T/PaidTaxLiabilityAmt00
IRS990TScheduleA/CapitalLossLimitationAmt0-3000
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/DeductionSetAsidesAmt00
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/DeductionSetAsidesAmt10
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/IncomeTypeDesc0OTHER INCOME
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/IncomeTypeDesc1OTHER INCOME
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/InvestmentIncomeAmt00
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/InvestmentIncomeAmt10
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/InvestmentIncomeDeductionAmt00
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/InvestmentIncomeDeductionAmt10
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/InvestmentIncomeSetAsidesAmt00
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/InvestmentIncomeSetAsidesAmt10
IRS990TScheduleA/NetOperatingLossDeductionAmt00
IRS990TScheduleA/NetOperatingLossDeductionAmt10
IRS990TScheduleA/OtherDeductionsAmt02970
IRS990TScheduleA/OtherDeductionsAmt115694
IRS990TScheduleA/PrincipalBusinessActivityCd0444100
IRS990TScheduleA/PrincipalBusinessActivityCd1444100
IRS990TScheduleA/RentIncomePropertyGrp/DeductionsConnectedRentIncmAmt00
IRS990TScheduleA/RentIncomePropertyGrp/DeductionsConnectedRentIncmAmt10
IRS990TScheduleA/RentIncomePropertyGrp/RentPersonalPropertyAmt00
IRS990TScheduleA/RentIncomePropertyGrp/RentPersonalPropertyAmt10
IRS990TScheduleA/RentIncomePropertyGrp/RentRealPersonalPropertyAmt00
IRS990TScheduleA/RentIncomePropertyGrp/RentRealPersonalPropertyAmt10
IRS990TScheduleA/RentIncomePropertyGrp/TotalRentsByPropertyAmt00
IRS990TScheduleA/RentIncomePropertyGrp/TotalRentsByPropertyAmt10
IRS990TScheduleA/RentIncomePropertyGrp/USAddress/AddressLine1Txt0PO BOX 1559
IRS990TScheduleA/RentIncomePropertyGrp/USAddress/AddressLine1Txt1660 N NIMITZ HWY
IRS990TScheduleA/RentIncomePropertyGrp/USAddress/CityNm0HONOLULU
IRS990TScheduleA/RentIncomePropertyGrp/USAddress/CityNm1HONOLULU
IRS990TScheduleA/RentIncomePropertyGrp/USAddress/StateAbbreviationCd0HI
IRS990TScheduleA/RentIncomePropertyGrp/USAddress/StateAbbreviationCd1HI
IRS990TScheduleA/RentIncomePropertyGrp/USAddress/ZIPCd096817
IRS990TScheduleA/RentIncomePropertyGrp/USAddress/ZIPCd196817
IRS990TScheduleA/SequenceReferenceNum01
IRS990TScheduleA/SequenceReferenceNum12
IRS990TScheduleA/SequenceTotalNum02
IRS990TScheduleA/SequenceTotalNum12
IRS990TScheduleA/TaxesAndLicensesAmt0278
IRS990TScheduleA/TotalAllocableDeductionsAmt00
IRS990TScheduleA/TotalAllocableDeductionsAmt10
IRS990TScheduleA/TotalCtrlOrgDeductionAmt00
IRS990TScheduleA/TotalCtrlOrgDeductionAmt10
IRS990TScheduleA/TotalCtrlOrgPymtGrossIncmAmt00
IRS990TScheduleA/TotalCtrlOrgPymtGrossIncmAmt10
IRS990TScheduleA/TotalDeductionsAmt02970
IRS990TScheduleA/TotalDeductionsAmt115972
IRS990TScheduleA/TotalDeductionSetAsidesAmt00
IRS990TScheduleA/TotalDeductionSetAsidesAmt10
IRS990TScheduleA/TotalDirectAdvertisingCostAmt00
IRS990TScheduleA/TotalDirectAdvertisingCostAmt10
IRS990TScheduleA/TotalDividendsReceivedDedAmt00
IRS990TScheduleA/TotalDividendsReceivedDedAmt10
IRS990TScheduleA/TotalGrossAdvertisingIncomeAmt00
IRS990TScheduleA/TotalGrossAdvertisingIncomeAmt10
IRS990TScheduleA/TotalGrossDebtFinancedIncmAmt00
IRS990TScheduleA/TotalGrossDebtFinancedIncmAmt10
IRS990TScheduleA/TotalInvestmentIncomeAmt00
IRS990TScheduleA/TotalInvestmentIncomeAmt10
IRS990TScheduleA/TotalRentDeductionsAmt00
IRS990TScheduleA/TotalRentDeductionsAmt10
IRS990TScheduleA/TotalRentIncomeAmt00
IRS990TScheduleA/TotalRentIncomeAmt10
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt00
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt10
IRS990TScheduleA/TotExcessReadershipCostsDedAmt00
IRS990TScheduleA/TotExcessReadershipCostsDedAmt10
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt0-3000
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt10
IRS990TScheduleA/TotUnrltTrdBusIncmAmt0-3000
IRS990TScheduleA/TotUnrltTrdBusIncmAmt10
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt00
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt10
IRS990TScheduleA/TradeOrBusinessDesc0SCHEDULE K-1 INCOME FROM DAVID AI MARITAL IN WHICH THE TRUST IS A BENFCY
IRS990TScheduleA/TradeOrBusinessDesc1SCHEDULE K-1 INCOME FROM CITY MILL CO., LTD IN WHICH THE TRUST IS A STKHDER
IRS990TScheduleA/UBIBeforeNOLDedAmt0-5970
IRS990TScheduleA/UBIBeforeNOLDedAmt1-15972
IRS990TScheduleA/UnrelatedBusinessTaxblIncmAmt0-5970
IRS990TScheduleA/UnrelatedBusinessTaxblIncmAmt1-15972
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AllocableDeductionAmt00
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AllocableDeductionAmt10
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAcquisitionAdjBasisPct00.00000
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAcquisitionAdjBasisPct10.00000
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAcquisitionDebtAmt00
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAcquisitionDebtAmt10
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAdjustedBasisAmt00
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAdjustedBasisAmt10
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/GrossIncomeAmt00
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/GrossIncomeAmt10
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/GrossIncomeReportableAmt00
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/GrossIncomeReportableAmt10
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/OtherDebtFinancedDeductionAmt00
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/OtherDebtFinancedDeductionAmt10
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/StraightLineDepreciationDedAmt00
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/StraightLineDepreciationDedAmt10
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/USAddress/AddressLine1Txt0PO BOX 1559
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/USAddress/AddressLine1Txt1660 N NIMITZ HWY
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/USAddress/CityNm0HONOLULU
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/USAddress/CityNm1HONOLULU
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/USAddress/StateAbbreviationCd0HI
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/USAddress/StateAbbreviationCd1HI
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/USAddress/ZIPCd096817
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/USAddress/ZIPCd196817
IRS990T/SpecificDeductionAmt01000
IRS990T/SubsidiaryCorporationInd00
IRS990T/TaxableTrustAmt00
IRS990T/TaxLessCreditsAmt00
IRS990T/TaxRateScheduleInd0X
IRS990T/TotalDeductionAmt01000
IRS990T/TotalPaymentsAmt0141000
IRS990T/TotalTaxAmt00
IRS990T/TotalTaxComputationAmt00
IRS990T/TotalUBTIAmt00
IRS990T/TotalUBTIComputedAmt00
ReturnHeader/BuildTS02024-10-15 13:58:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0STEVEN C AI
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum08085295834
ReturnHeader/BusinessOfficerGrp/SignatureDt02024-11-06
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0DAVID C AI CHARITABLE TRUST
ReturnHeader/Filer/BusinessNameControlTxt0AI
ReturnHeader/Filer/EIN0996078252
ReturnHeader/Filer/PhoneNum08085295834
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 1559
ReturnHeader/Filer/USAddress/CityNm0HONOLULU
ReturnHeader/Filer/USAddress/StateAbbreviationCd0HI
ReturnHeader/Filer/USAddress/ZIPCd096806
ReturnHeader/IRSResponsiblePrtyInfoCurrInd00
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0261659234
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0CW ASSOCIATES CPAS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0700 BISHOP STREET SUITE 1040
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0HONOLULU
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0HI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd096813
ReturnHeader/PreparerPersonGrp/PhoneNum08085311040
ReturnHeader/PreparerPersonGrp/PreparationDt02024-10-29
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0MELANIE A KING
ReturnHeader/ReturnTs02024-11-06T11:38:24-06:00
ReturnHeader/ReturnTypeCd0990T
ReturnHeader/TaxPeriodBeginDt02023-01-01
ReturnHeader/TaxPeriodEndDt02023-12-31
ReturnHeader/TaxYr02023

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$15.7$0.00$15.7$0.80$1.08$0.29
2023Detailed filing. Detailed filing data is available for this year.$15.0$0.00$15.0$5.77$0.95$4.83
2023Facts available. Structured filing facts are available, but richer extracted sections are limited.
2022Detailed filing. Detailed filing data is available for this year.$9.12$0.00$9.12$0.10$0.32$0.22
2021Detailed filing. Detailed filing data is available for this year.$4.21$0.00$4.21$0.44$0.15$0.29
2020Detailed filing. Detailed filing data is available for this year.$3.85$0.00$3.85$0.16$0.13$0.03
2019Detailed filing. Detailed filing data is available for this year.$3.76$0.00$3.76$0.16$0.14$0.02
2018Detailed filing. Detailed filing data is available for this year.$3.60$0.00$3.60$0.61$0.55$0.06
2017Detailed filing. Detailed filing data is available for this year.$3.64$0.00$3.64$0.41$0.63$0.22
2016Detailed filing. Detailed filing data is available for this year.$3.80$0.00$3.80$0.43$0.52$0.09
2015Detailed filing. Detailed filing data is available for this year.$3.84$0.00$3.84$0.57$0.39$0.18
2014Detailed filing. Detailed filing data is available for this year.$3.70$0.00$3.70$0.27$0.07$0.19
2013Detailed filing. Detailed filing data is available for this year.$3.55$0.00$3.55$0.06$0.10$0.04
2011Summary only. Only limited summary data is available for this year.$3.62$0.00$3.62$0.27$0.18$0.09
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.56$0.00$3.56$0.29