{"success":true,"data":{"_id":990349613,"filings":[{"Organization":{"value":null,"Person":["MERRIE AIPOALANI","LINDA NAONE","JEAN NISHI","GEORGETTE STEVENS","JAN SHIMABUKURP-LEE","DENICE KELI'IKOA"],"Title":["PRESIDENT","TREASURER & DIRECTOR","DIRECTOR","SECRETARY","DIRECTOR","EXECUTIVE DIRECTOR"],"Hours":[1.0,1.0,0.5,0.5,0.5,30.0],"Total Compensation":[0,0,0,0,0,34492],"Direct compensation":[0,0,0,0,0,34492],"Other compensation":[0,0,0,0,0,0]},"Basic":{"value":null,"mission":"Valley of the rainbows supports individuals to recognize their full potential, enrich their lives and discover new possibilities","year":2021,"name":"MAKING DREAMS COME TRUEVALLEY OF RAINBOWS INC","phone":8082867869,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"DENICE KELIIKOA","year_formation":2004,"state_legal_domicile":"HI","total_volunteers":10,"tax_period_begin":"2021-01-01T00:00:00","tax_period_end":"2021-12-31T00:00:00","address":"PO BOX 1009, WAIANAE, HI, 96792, USA","city":"WAIANAE","state":"HI","country":"USA","zip_code":96792},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":0,"Number of employees total":1,"Total Gross UBI":14,"Net unrelated business taxable income":0,"Number of employees":1,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":53670,"Contributions":{"value":2556,"Other contributions":2556,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":51100,"Total revenue":{"value":51100,"YOUTH LEADERSHIP CONFERENCE":30000,"GIRLS CONFERENCE":5000,"SCHOLARSHIP FUND":100,"BOYS CONFERENCE":5000,"KUPUNA KIT PROJECT":11000},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":0,"Investment income total":0,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":14,"Other total":14,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":41986,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":38031,"Current officers":34492,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":3539},"Other expenses":{"value":3955,"Management services":0,"Legal":0,"Accounting":2158,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":444,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":1232,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":121,"BOARD EXPENSES":415,"TRAFFIC BOX PROJECT":250,"GIRLS CONFERENCE":-680,"BOYS CONFERENCE":136},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":157,"Management And General Expenses":41829,"Fundraising Expenses":0}},"Assets":{"value":105969,"Non-interest bearing cash":101986,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":3983,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":105969,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":104886,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":1083},"Fund balance":{"value":0,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.0037393416853236795,"percentile":0.442421435073671},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.21770076392770635,"percentile":0.7733487354685318},"Liabilities to Assets Ratio":{"score":1.0,"percentile":0.051798247554622576},"Operating Reserve Ratio":{"score":2.5239127328157003,"percentile":0.6735595287150491},"Officer Compensation Ratio":{"score":0.8215119325489448,"percentile":0.02042443958551379},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":null,"percentile":null},"Asset Growth":{"score":null,"percentile":null},"Independent Voting Board Pct":{"score":0.0,"percentile":0.10798813433961453},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.47978499893317883,"percentile":0.2741094032197134}},"source_xml":"202222589349302207_public.xml"},{"Organization":{"value":null,"Person":["MERRIE AIPOALANI","LINDA NAONE","GEORGETTE STEVENS","JAN SHIMABUKURO-LEE","VIVIAN AULANI AHMAD"],"Title":["PRESIDENT","TREASURER & DIRECTOR","DIRECTOR","SECRETARY","EX OFFICIO"],"Hours":[1.0,1.0,0.5,0.5,0.5],"Total Compensation":[0,0,0,0,0],"Direct compensation":[0,0,0,0,0],"Other compensation":[0,0,0,0,0]},"Basic":{"value":null,"mission":"Valley of the rainbows supports individuals to recognize their full potential, enrich their lives and discover new possibilities","year":2024,"name":"MAKING DREAMS COME TRUEVALLEY OF RAINBOWS INC","phone":8082867869,"website":"www.valleyofrainbows.org","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"DENICE KELIIKOA","year_formation":2004,"state_legal_domicile":"HI","total_volunteers":10,"tax_period_begin":"2024-01-01T00:00:00","tax_period_end":"2024-12-31T00:00:00","address":"PO BOX 1009, WAIANAE, HI, 96792, USA","city":"WAIANAE","state":"HI","country":"USA","zip_code":96792},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":6,"Number of independent voting members":0,"Number of employees total":1,"Total Gross UBI":12,"Net unrelated business taxable income":0,"Number of employees":1,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":103722,"Contributions":{"value":95660,"Other contributions":95660,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":8050,"Total revenue":8050,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":12,"Investment income total":12,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":69724,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":37548,"Current officers":34492,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":3056},"Other expenses":{"value":32176,"Management services":0,"Legal":0,"Accounting":1300,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":1319,"Information technology":0,"Royalties":0,"Occupancy":7345,"Travel":1164,"Conferences and meetings":1213,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":3983,"Insurance":1480,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":6662,"CONFERENCE SUPPLIES":1856,"MAHALO GIFTS":1878,"VOLUNTEER EXPENSES":1145,"UNIFORMS":1783},"All other expenses":7710},"Functional Expenses":{"value":null,"Program Service Expenses":60296,"Management And General Expenses":9428,"Fundraising Expenses":0}},"Assets":{"value":77361,"Non-interest bearing cash":77361,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":938,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":938},"Fund balance":{"value":76423,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.8647811370546727,"percentile":0.7159462028630582},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.3277800273808835,"percentile":0.85125845811393},"Liabilities to Assets Ratio":{"score":0.01212497253137886,"percentile":0.48800703993392686},"Operating Reserve Ratio":{"score":1.1095318685101256,"percentile":0.45319070808540945},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":0.05665413813198376,"percentile":0.5556327715229036},"Revenue Growth":{"score":-0.0010410112151608246,"percentile":0.36483016788774225},"Asset Growth":{"score":-0.11033668475010013,"percentile":0.09640332990638459},"Independent Voting Board Pct":{"score":0.0,"percentile":0.10798813433961453},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5892520391955564,"percentile":0.5738358441743362}},"source_xml":"202600369349300000_public.xml"},{"Organization":{"value":null,"Person":["MERRIE AIPOALANI","LINDA NAONE","GEORGETTE STEVENS","JAN SHIMABUKURO-LEE","VIVIAN AULANI AHMAD","JEAN NISHI"],"Title":["PRESIDENT","TREASURER & DIRECTOR","DIRECTOR","SECRETARY","EX OFFICIO","BOARD MEMBER"],"Hours":[1.0,1.0,0.5,0.5,0.5,0.5],"Total Compensation":[0,0,0,0,0,0],"Direct compensation":[0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,0]},"Basic":{"value":null,"mission":"Valley of the rainbows supports individuals to recognize their full potential, enrich their lives and discover new possibilities","year":2022,"name":"MAKING DREAMS COME TRUEVALLEY OF RAINBOWS INC","phone":8082867869,"website":"www.valleyofrainbows.org","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"DENICE KELIIKOA","year_formation":2004,"state_legal_domicile":"HI","total_volunteers":10,"tax_period_begin":"2022-01-01T00:00:00","tax_period_end":"2022-12-31T00:00:00","address":"PO BOX 1009, WAIANAE, HI, 96792, USA","city":"WAIANAE","state":"HI","country":"USA","zip_code":96792},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":0,"Number of employees total":1,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":1,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":22014,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":22000,"Total revenue":{"value":22000,"YOUTH LEADERSHIP CONFERENCE":2000,"GIRLS CONFERENCE":10000,"BOYS CONFERENCE":10000},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":14,"Investment income total":14,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":64620,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":37824,"Current officers":0,"Disqualified persons":0,"Other salaries and wages":34492,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":3332},"Other expenses":{"value":26796,"Management services":730,"Legal":0,"Accounting":2674,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":1467,"Office expenses":1018,"Information technology":0,"Royalties":0,"Occupancy":8166,"Travel":798,"Conferences and meetings":2986,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":1749,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":7208,"CONFERENCE SUPPLIES":3558,"REFRESHMENT/MEALS":3420,"AUTO EXPENSES":30,"MISC EXPENSES":200},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":60212,"Management And General Expenses":4408,"Fundraising Expenses":0}},"Assets":{"value":63493,"Non-interest bearing cash":59510,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":3983,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":1027,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":1027},"Fund balance":{"value":62466,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.9317858248220365,"percentile":0.8192827451201534},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-1.9354047424366312,"percentile":0.025043211508231942},"Liabilities to Assets Ratio":{"score":0.016175011418581575,"percentile":0.47123107075494114},"Operating Reserve Ratio":{"score":0.9825595790776849,"percentile":0.41858540549312395},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":-0.1687214326196242,"percentile":0.10099048758312974},"Revenue Growth":{"score":-0.6646554525089351,"percentile":0.013087891964138482},"Asset Growth":{"score":-0.1554806959760518,"percentile":0.07056019257452072},"Independent Voting Board Pct":{"score":0.0,"percentile":0.10798813433961453},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.38270735407837586,"percentile":0.09560787643666495}},"source_xml":"202331949349302063_public.xml"},{"Organization":{"value":null,"Person":["MERRIE AIPOALANI","LINDA NAONE","GEORGETTE STEVENS","JAN SHIMABUKURO-LEE","VIVIAN AULANI AHMAD"],"Title":["PRESIDENT","TREASURER & DIRECTOR","DIRECTOR","SECRETARY","EX OFFICIO"],"Hours":[1.0,1.0,0.5,0.5,0.5],"Total Compensation":[0,0,0,0,0],"Direct compensation":[0,0,0,0,0],"Other compensation":[0,0,0,0,0]},"Basic":{"value":null,"mission":"Valley of the rainbows supports individuals to recognize their full potential, enrich their lives and discover new possibilities","year":2023,"name":"MAKING DREAMS COME TRUEVALLEY OF RAINBOWS INC","phone":8082867869,"website":"www.valleyofrainbows.org","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"DENICE KELIIKOA","year_formation":2004,"state_legal_domicile":"HI","total_volunteers":10,"tax_period_begin":"2023-01-01T00:00:00","tax_period_end":"2023-12-31T00:00:00","address":"PO BOX 1009, WAIANAE, HI, 96792, USA","city":"WAIANAE","state":"HI","country":"USA","zip_code":96792},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":6,"Number of independent voting members":0,"Number of employees total":1,"Total Gross UBI":12,"Net unrelated business taxable income":0,"Number of employees":1,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":45049,"Contributions":{"value":45000,"Other contributions":45000,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":37,"Total revenue":37,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":12,"Investment income total":12,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":61326,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":38031,"Current officers":0,"Disqualified persons":0,"Other salaries and wages":34492,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":3539},"Other expenses":{"value":23295,"Management services":0,"Legal":0,"Accounting":2896,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":2889,"Office expenses":586,"Information technology":0,"Royalties":0,"Occupancy":8862,"Travel":674,"Conferences and meetings":434,"Interest":0,"Payments to affiliates":533,"Depreciation and depletion":0,"Insurance":717,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":5704,"CONFERENCE SUPPLIES":2221,"EQUIPMENT RENTAL":2332,"MAHALO GIFTS":1151},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":59524,"Management And General Expenses":1802,"Fundraising Expenses":0}},"Assets":{"value":47259,"Non-interest bearing cash":43276,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":3983,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":1069,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":1069},"Fund balance":{"value":46190,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.9706160519192513,"percentile":0.875354055730547},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.36131767630802014,"percentile":0.09759839598229271},"Liabilities to Assets Ratio":{"score":0.022620030047186778,"percentile":0.44932058738219666},"Operating Reserve Ratio":{"score":0.7706193131787497,"percentile":0.3530742832984288},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":0.02486347607568569,"percentile":0.42641437325246506},"Revenue Growth":{"score":-0.35514191634691267,"percentile":0.037253513654404956},"Asset Growth":{"score":-0.22398609162209063,"percentile":0.04715143179077651},"Independent Voting Board Pct":{"score":0.0,"percentile":0.10798813433961453},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.4460429132646149,"percentile":0.203449815744114}},"source_xml":"202432309349300353_public.xml"},{"Organization":{"value":null,"Person":["MERRIE AIPOALANI","LINDA NAONE","VIVIAN AHMAD","GEORGETTE STEVENS","JAN SHIMABUKURP-LEE","DENICE KELI'IKOA"],"Title":["PRESIDENT","DIRECTOR","TREASURER","SECRETARY","DIRECTOR","EXECUTIVE DIRECTOR"],"Hours":[20.0,10.0,10.0,10.0,10.0,20.0],"Total Compensation":[0,0,0,0,0,34492],"Direct compensation":[0,0,0,0,0,34492],"Other compensation":[0,0,0,0,0,0]},"Basic":{"value":null,"mission":"Monthly scholarship program for youth ages 8-17 to assist with the educational, cultural, school or sports related activities. ----- scholarships awards distributed each","year":2020,"name":"MAKING DREAMS COME TRUEVALLEY OF RAINBOWS INC","phone":8082867869,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"DENICE KELIIKOA","year_formation":2004,"state_legal_domicile":"HI","total_volunteers":300,"tax_period_begin":"2020-01-01T00:00:00","tax_period_end":"2020-12-31T00:00:00","address":"PO BOX 1009, WAIANAE, HI, 96792, USA","city":"WAIANAE","state":"HI","country":"USA","zip_code":96792},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":6,"Number of independent voting members":0,"Number of employees total":1,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":1,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":99749,"Contributions":{"value":25327,"Other contributions":25327,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":74422,"Total revenue":{"value":74422,"YOUTH LEADERSHIP":19500,"GIRLS CONFERENCE":23000,"OTHER":30922,"TRAFFIC BOX PROJECT":1000,"PROJECT IGNITION":0},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":0,"Investment income total":0,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":77121,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":38552,"Current officers":0,"Disqualified persons":0,"Other salaries and wages":34492,"Pension plan contributions":0,"Other employee benefits":590,"Payroll taxes":3470},"Other expenses":{"value":38569,"Management services":0,"Legal":0,"Accounting":0,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":1627,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":145,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":0,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":23662,"BOARD EXPENSES":3227,"YOUTH LEADERSHIP":6120,"GIRLS CONFERENCE":14040,"BOYS CONFERENCE":275},"All other expenses":13135},"Functional Expenses":{"value":null,"Program Service Expenses":75494,"Management And General Expenses":1627,"Fundraising Expenses":0}},"Assets":{"value":90432,"Non-interest bearing cash":90432,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":90432,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":90432,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":0,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.978903281855785,"percentile":0.8879451878227386},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.22684939197385437,"percentile":0.7816221521725795},"Liabilities to Assets Ratio":{"score":1.0,"percentile":0.051798247554622576},"Operating Reserve Ratio":{"score":1.172598903022523,"percentile":0.46893361887484064},"Officer Compensation Ratio":{"score":0.4472452380026193,"percentile":0.09175662390167356},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":null,"percentile":null},"Asset Growth":{"score":null,"percentile":null},"Independent Voting Board Pct":{"score":0.0,"percentile":0.10798813433961453},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6379301697043304,"percentile":0.7110961300364392}},"source_xml":"202143169349313369_public.xml"}],"Latest":{"Organization":{"value":null,"Person":["MERRIE AIPOALANI","LINDA NAONE","GEORGETTE STEVENS","JAN SHIMABUKURO-LEE","VIVIAN AULANI AHMAD"],"Title":["PRESIDENT","TREASURER & DIRECTOR","DIRECTOR","SECRETARY","EX OFFICIO"],"Hours":[1.0,1.0,0.5,0.5,0.5],"Total Compensation":[0,0,0,0,0],"Direct compensation":[0,0,0,0,0],"Other compensation":[0,0,0,0,0]},"Basic":{"value":null,"mission":"Valley of the rainbows supports individuals to recognize their full potential, enrich their lives and discover new possibilities","year":2024,"name":"MAKING DREAMS COME TRUEVALLEY OF RAINBOWS INC","phone":8082867869,"website":"www.valleyofrainbows.org","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"DENICE KELIIKOA","year_formation":2004,"state_legal_domicile":"HI","total_volunteers":10,"tax_period_begin":"2024-01-01T00:00:00","tax_period_end":"2024-12-31T00:00:00","address":"PO BOX 1009, WAIANAE, HI, 96792, USA","city":"WAIANAE","state":"HI","country":"USA","zip_code":96792},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":6,"Number of independent voting members":0,"Number of employees total":1,"Total Gross UBI":12,"Net unrelated business taxable income":0,"Number of employees":1,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":103722,"Contributions":{"value":95660,"Other contributions":95660,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":8050,"Total revenue":8050,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":12,"Investment income total":12,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":69724,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":37548,"Current officers":34492,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":3056},"Other expenses":{"value":32176,"Management services":0,"Legal":0,"Accounting":1300,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":1319,"Information technology":0,"Royalties":0,"Occupancy":7345,"Travel":1164,"Conferences and meetings":1213,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":3983,"Insurance":1480,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":6662,"CONFERENCE SUPPLIES":1856,"MAHALO GIFTS":1878,"VOLUNTEER EXPENSES":1145,"UNIFORMS":1783},"All other expenses":7710},"Functional Expenses":{"value":null,"Program Service Expenses":60296,"Management And General Expenses":9428,"Fundraising Expenses":0}},"Assets":{"value":77361,"Non-interest bearing cash":77361,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":938,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":938},"Fund balance":{"value":76423,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.8647811370546727,"percentile":0.7159462028630582},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.3277800273808835,"percentile":0.85125845811393},"Liabilities to Assets Ratio":{"score":0.01212497253137886,"percentile":0.48800703993392686},"Operating Reserve Ratio":{"score":1.1095318685101256,"percentile":0.45319070808540945},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":0.05665413813198376,"percentile":0.5556327715229036},"Revenue Growth":{"score":-0.0010410112151608246,"percentile":0.36483016788774225},"Asset Growth":{"score":-0.11033668475010013,"percentile":0.09640332990638459},"Independent Voting Board Pct":{"score":0.0,"percentile":0.10798813433961453},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5892520391955564,"percentile":0.5738358441743362}},"source_xml":"202600369349300000_public.xml"},"sector":"Human Services","donation_categories":[],"zakat_policy":null},"error":null}