Civic Intelligence

Ro Foundation

990PF • Fiscal year 2023 • EIN 84-2881695

Jan 01, 2023 to Dec 31, 2023 • Filed on Sep 17, 2024

Organization Profile
3158 Monsarrat AvenueHonolulu, HI 96815

(808) 728-6867

Siviq Scores

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

Liabilities / Assets

60th percentile

0.00x

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

2023 filings • <$500k nonprofits • Source year 2023

Liabilities / Revenue

61st percentile

0.00x

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

2023 filings • <$500k nonprofits • Source year 2023

Net Margin

9th percentile

-94%

Higher net margin than 9% of similar nonprofits.

2023 filings • <$500k nonprofits • Source year 2023

Top Officer Pay

79th percentile

$0

Higher top officer pay than 79% of similar nonprofits.

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

2023 filings • <$500k nonprofits • Source year 2023

Asset Growth

33rd percentile

-7.9%

Faster asset growth than 33% of similar nonprofits.

2023 filings • <$500k nonprofits • Annualized from 2022 to 2023

Revenue Growth

6th percentile

-79%

Faster revenue growth than 6% of similar nonprofits.

2023 filings • <$500k nonprofits • Annualized from 2022 to 2023

Balance Sheet
Liabilities / Assets60th percentile

Assets

Down

$293,071

Down $24,991 (-7.9%) from 2022

Net Assets

Down

$293,071

Down $24,991 (-7.9%) from 2022

Liabilities

Flat

$1

Flat from 2022

Revenue And Expenses
Liabilities / Revenue61st percentileNet Margin9th percentile

Revenue

Down

$26,574

Down $98,772 (-79%) from 2022

Expenses

Up

$51,565

Up $31,116 (+152%) from 2022

Net Income

Down

-$24,991

Down $129,888 (-124%) from 2022

Historical Trend

Balance Sheet Trend

Asset Growth33rd percentile

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

$600K$400K$200K$0Assets 2019: $35,000Liabilities 2019: $02019Assets 2020: $37,113Liabilities 2020: $1Net Assets 2020: $37,1132020Assets 2021: $213,165Liabilities 2021: $1Net Assets 2021: $213,1652021Assets 2022: $318,062Liabilities 2022: $1Net Assets 2022: $318,0622022Assets 2023: $293,071Liabilities 2023: $1Net Assets 2023: $293,0712023Assets 2024: $409,461Liabilities 2024: $0Net Assets 2024: $409,4612024

Highlighted filing

2023

Assets$293,071
Liabilities$1
Net Assets$293,071
Open 2023 Filing

Operations Trend

Revenue Growth6th percentile

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

$200K$100K$0-$100KRevenue 2019: $35,000Expenses 2019: $0Net Income 2019: $35,0002019Revenue 2020: $11,000Expenses 2020: $8,887Net Income 2020: $2,1132020Revenue 2021: $181,500Expenses 2021: $5,448Net Income 2021: $176,0522021Revenue 2022: $125,346Expenses 2022: $20,449Net Income 2022: $104,8972022Revenue 2023: $26,574Expenses 2023: $51,565Net Income 2023: -$24,9912023Revenue 2024: $172,820Expenses 2024: $56,430Net Income 2024: $116,3902024

Highlighted filing

2023

Revenue$26,574
Expenses$51,565
Net Income-$24,991
Open 2023 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2023 to Dec 31, 2023
Signed
Sep 17, 2024
Return Version
2023v5.1
Compensation and Service Providers
Top Officer Pay79th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
KELVIN ROPrestreasdirector-$0--
JAN ROVpsecdirector-$0--
MICHAEL CHINADirector-$0--
BRYAN LUKEDirector-$0--
Filing and Contact Details

Filer

Filer Name
Ro Foundation
EIN
84-2881695
Address
3158 MONSARRAT AVENUE, HONOLULU, HI 96815

Signing Officer

Name
Kelvin Ro
Title
President
Phone
8087320077
Signed
2024-09-17
Discuss with paid preparer
Yes

Preparer

Firm
Rtf LLC
Address
600 Queen St No 1710, Honolulu, HI 96813
Preparer
Reed Fujimoto
Phone
8087286867
Raw XML Appendix306 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/AdjustedNetIncomeAmt00
AccountingFeesSchedule/AccountingFeesDetail/Amt0471
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0ACCOUNTING FEES
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt00
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt00
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt070592
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt071991
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0INVESTMENTS
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt0471
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt021402
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt033508
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt033508
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt05000
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt0150
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt0150
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-24991
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0638932
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt022
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt022
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt021402
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt021574
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt03585
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt014000
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt01
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt033508
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt051565
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt021574
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt026574
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt018057
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt0617530
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt021402
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt021402
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt0638932
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0PUBLICLY TRADED SECURITIES
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt021402
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-24991
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0293071
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0318062
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0293071
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt014572
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt014572
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt014572
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt014872
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0300
IRS990PF/DistributableAmountGrp/TotalTaxAmt0300
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt0400
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt0700
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0300
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt0400
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0300
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0300
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0700
IRS990PF/FMVAssetsEOYAmt0294470
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt0269016
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt0222316
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt0222316
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt043657
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt070592
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt071991
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherAssetsEOYAmt0135
IRS990PF/Form990PFBalanceSheetsGrp/OtherAssetsEOYFMVAmt0135
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0318062
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0293071
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt05389
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt028
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt028
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0318062
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0293071
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0294470
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0318062
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0293071
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0318062
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0293071
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0301964
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt0237909
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt064055
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt04529
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt014872
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0297435
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0301964
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt11.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/PersonNm0KELVIN RO
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1JAN RO
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm2MICHAEL CHINA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm3BRYAN LUKE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0PRESTREASDIRECTOR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1VPSECDIRECTOR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt2DIRECTOR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt3DIRECTOR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt03158 MONSARRAT AVENUE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt1PO BOX 893095
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt2555 SOUTH STREET NO 106
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt345 N KING ST
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0HONOLULU
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1MILILANI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm2HONOLULU
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm3HONOLULU
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0HI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1HI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd2HI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd3HI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd096815
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd196789
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd296813
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd396817
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/PFQualifyingDistributionsGrp/ExpensesAndContributionsAmt033508
IRS990PF/PFQualifyingDistributionsGrp/QualifyingDistributionsAmt033508
IRS990PF/RlnOfActyToAccomOfExmptPrpsGrp/RlnOfActyToAccomOfExmptPrpsGrp/LineNumberTxt001a
IRS990PF/RlnOfActyToAccomOfExmptPrpsGrp/RlnOfActyToAccomOfExmptPrpsGrp/RelationshipStatementTxt0NA
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/SubjToTaxRmnrtnExPrchtPymtInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0true
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0JAN RO OR KELVIN RO
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt03158 MONSARRAT AVENUE
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0HONOLULU
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0HI
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd096815
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0HI
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PhoneNum08087320077
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/SummaryOfDirectChrtblActyGrp/Description1Txt0NONE
IRS990PF/SummaryOfDirectChrtblActyGrp/Expenses1Amt00
IRS990PF/SumOfProgramRelatedInvstGrp/Description1Txt0NONE
IRS990PF/SumOfProgramRelatedInvstGrp/Expenses1Amt00
IRS990PF/SupplementaryInformationGrp/ContributingManagerNm0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt011000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt115000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt25000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt32508
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0PRESERVE ASPECTS OF HAWAIIAN CULTURE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1EDUCATION SUPPORT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2SEEK COMMUNITY PARTNERSHIPS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt3PROVIDE A SAFE SPACE FOR LGBTQ
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt2PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt3PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm0WAHEA FOUNDATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm1FRIENDS OF WAIPAHU HIGH SCHOOL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm2KE ALII PAUAHI FOUNDATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm3HIGFFL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1NA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt2NA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt3NA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0PO BOX 89498
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt1PO BOX 971363
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt2567 SOUTH KING ST STE 160
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt3PO BOX 89063
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0HONOLULU
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1WAIPAHU
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm2HONOLULU
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm3HONOLULU
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0HI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1HI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd2HI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd3HI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd096830
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd196797
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd296813
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd396830
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/ShareholderManagerNm0NONE
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt033508
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt014572
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt014572
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt02136
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt021072
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt018936
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt02136
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt033508
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt018936
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt021072
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt02136
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990ScheduleB/ContributorInformationGrp/ContributorNum01
IRS990ScheduleB/ContributorInformationGrp/ContributorPersonNm0STEPHEN GLORIA GAINSLEY
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine1Txt01559 AINAKOA AVE
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/CityNm0HONOLULU
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/StateAbbreviationCd0HI
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCd096821
IRS990ScheduleB/ContributorInformationGrp/PersonContributionInd0X
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt05000
IRS990ScheduleB/GeneralRuleInd0X
IRS990ScheduleB/Organization501c3ExemptPFInd0X
OtherAssetsSchedule/OtherAssetsScheduleGrp/BOYBookValueAmt00
OtherAssetsSchedule/OtherAssetsScheduleGrp/Desc0OTHER RECEIVABLES
OtherAssetsSchedule/OtherAssetsScheduleGrp/EOYBookValueAmt0135
OtherAssetsSchedule/OtherAssetsScheduleGrp/EOYFMVAmt0135
OtherExpensesSchedule/OtherExpensesScheduleGrp/AdjustedNetIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0ADVERTISING AND MARKETING
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt03585
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/AdjustedNetIncomeAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt014000
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0PROFESSIONAL FUNDRAISING FEES
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/DisbursementsCharitablePrpsAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/NetInvestmentIncomeAmt00
TaxesSchedule/TaxesDetail/AdjustedNetIncomeAmt00
TaxesSchedule/TaxesDetail/Amt01
TaxesSchedule/TaxesDetail/CategoryTxt0FEDERAL EXCISE TAX
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
ReturnHeader/BuildTS02024-08-08 14:25:15Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0Kelvin Ro
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum08087320077
ReturnHeader/BusinessOfficerGrp/SignatureDt02024-09-17
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0RO FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0ROFO
ReturnHeader/Filer/EIN0842881695
ReturnHeader/Filer/USAddress/AddressLine1Txt03158 MONSARRAT AVENUE
ReturnHeader/Filer/USAddress/CityNm0HONOLULU
ReturnHeader/Filer/USAddress/StateAbbreviationCd0HI
ReturnHeader/Filer/USAddress/ZIPCd096815
ReturnHeader/IRSResponsiblePrtyInfoCurrInd0true
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0822949278
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0RTF LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0600 Queen St No 1710
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Honolulu
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0HI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd096813
ReturnHeader/PreparerPersonGrp/PhoneNum08087286867
ReturnHeader/PreparerPersonGrp/PreparationDt02024-09-18
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Reed Fujimoto
ReturnHeader/ReturnTs02024-09-18T18:54:42-04:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02023-01-01
ReturnHeader/TaxPeriodEndDt02023-12-31
ReturnHeader/TaxYr02023

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
$293,071
Liabilities
$1
Net assets
$293,071
Revenue
$26,574
Expenses
$51,565
Net income
-$24,991
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$4.09$0.00$4.09$1.73$0.56$1.16
2023Detailed filing. Detailed filing data is available for this year.$2.93$0.00$2.93$0.27$0.52$0.25
2022Detailed filing. Detailed filing data is available for this year.$3.18$0.00$3.18$1.25$0.20$1.05
2021Detailed filing. Detailed filing data is available for this year.$2.13$0.00$2.13$1.82$0.05$1.76
2020Detailed filing. Detailed filing data is available for this year.$0.37$0.00$0.37$0.11$0.09$0.02
2019Summary only. Only limited summary data is available for this year.$0.35$0.00$0.35$0.00$0.35