Civic Intelligence

Renato & Maria Af Etrata Foundation

990EZ • Fiscal year 2017 • EIN 26-3870032

Jan 01, 2017 to Dec 31, 2017 • Filed on Apr 04, 2018

Organization Profile
94-412 Maikoiko StreetWaipahu, HI 96797

(808) 392-2962

Siviq Scores

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

Liabilities / Assets

56th percentile

0.00x

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

2017 filings • 501(c)3 • <$500k nonprofits • Source year 2017

Liabilities / Revenue

56th percentile

0.00x

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

2017 filings • 501(c)3 • <$500k nonprofits • Source year 2017

Net Margin

95th percentile

65%

Higher net margin than 95% of similar nonprofits.

2017 filings • 501(c)3 • <$500k nonprofits • Source year 2017

Top Officer Pay

76th percentile

$0

Higher top officer pay than 76% of similar nonprofits.

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

2017 filings • 501(c)3 • <$500k nonprofits • Source year 2017

Asset Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2017

Revenue Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2017

Balance Sheet
Liabilities / Assets56th percentile

Assets

$86,198

No earlier filing loaded for comparison.

Net Assets

$86,198

No earlier filing loaded for comparison.

Liabilities

$0

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / Revenue56th percentileNet Margin95th percentile

Revenue

$131,000

No earlier filing loaded for comparison.

Expenses

$46,435

No earlier filing loaded for comparison.

Net Income

$84,565

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset GrowthScore unavailable

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

$200K$150K$100K$50K$0Assets 2017: $86,198Liabilities 2017: $0Net Assets 2017: $86,1982017Assets 2018: $62,498Liabilities 2018: $0Net Assets 2018: $62,4982018Assets 2019: $82,662Liabilities 2019: $0Net Assets 2019: $82,6622019Assets 2020: $106,515Liabilities 2020: $0Net Assets 2020: $106,5152020Assets 2021: $123,293Liabilities 2021: $0Net Assets 2021: $123,2932021Assets 2022: $151,898Liabilities 2022: $0Net Assets 2022: $151,8982022Assets 2023: $144,708Liabilities 2023: $0Net Assets 2023: $144,7082023Assets 2024: $172,858Liabilities 2024: $0Net Assets 2024: $175,6582024

Highlighted filing

2017

Assets$86,198
Liabilities$0
Net Assets$86,198
Open 2017 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$150K$100K$50K$0-$50KRevenue 2017: $131,000Expenses 2017: $46,435Net Income 2017: $84,5652017Revenue 2018: $60,000Expenses 2018: $83,740Net Income 2018: -$23,7402018Revenue 2019: $128,181Expenses 2019: $48,017Net Income 2019: $80,1642019Revenue 2020: $41,722Expenses 2020: $18,369Net Income 2020: $23,3532020Revenue 2021: $22,102Expenses 2021: $5,325Net Income 2021: $16,7772021Revenue 2022: $63,590Expenses 2022: $34,985Net Income 2022: $28,6052022Revenue 2023: $55,310Expenses 2023: $62,500Net Income 2023: -$7,1902023Revenue 2024: $60,000Expenses 2024: $29,050Net Income 2024: $30,9502024

Highlighted filing

2017

Revenue$131,000
Expenses$46,435
Net Income$84,565
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Apr 4, 2018
Return Version
2017v2.3
Gross Receipts
$131,000
Mission and Program Overview

Mission

Promote nbsp;and nbsp;support nbsp;education/scholarship nbsp;cultural nbsp;and nbsp;to nbsp;provide nbsp;charitable/medical/medical nbsp;missions nbsp;(victims nbsp;of nbsp;natural nbsp;disasters nbsp;such nbsp;as nbsp;typhoons nbsp;without nbsp;limitation nbsp;relief nbsp;of nbsp;the nbsp;poor nbsp;and nbsp;distress nbsp;people

Promote and support educscholarship artsculture etc

Program Services

DescriptionGrantsExpenses
SCHOLARSHIPEDUCATIONAL PROGRAM-$21,465
CULTUREARTS PROGRAM-$12,300
AMDINISTRATIONMISCELLANEOUS EXPENDITURES-$8,170
HUMANITARIAN HELPMEDICAL MISSIONS FOR THE POOR-$4,500
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
MARIA F ETRATAPresidentPT$0--
RENATO V ETRATAVicepresidentPT$0--
ROSEMARIES E MANUELKey Officer-$0--
Filing and Contact Details

Filer

Filer Name
Renato & Maria Af Etrata Foundation
EIN
26-3870032
In Care Of
% MARIA F ETRATA
Phone
8083922962
Address
94-412 MAIKOIKO STREET, WAIPAHU, HI 96797

Signing Officer

Name
Maria F Etrata
Title
President
Phone
8083922962
Signed
2018-04-04
Discuss with paid preparer
No

Preparer

Firm
Villaruz Financial Services LLC
Address
POBox 29912, Honolulu, HI 96820
Preparer
Danny Villaruz
Phone
8087780233
Supplemental Narrative

Additional Explanations

Part I Line 10

“Grants and other assistance to domestic organizations and governments $38265.00”

Part I Line 16

“Other/miscellaneouse expense $8170.00”

Part III

“Expenses: $8170.00 including grants of: $0.00 Revenue: $0.00”

Part III

“Amdinistration/miscellaneous expenditures”

PART III-Line 4A

“Scholarship/Educational Expenditures - $ 21,465.00”

PART III-Line 4B

“Culture/Arts Expsnditures - $ 12,300.00”

PART III-Line 4C

“Humanitarian/Medical Mission - $ 4,500.00”

PART III-Line 4D

“Office/Miscellaneous Expenditures - $ 8,170.00”

Raw XML Appendix152 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
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/PersonNm0MARIA A ETRATA
IRS990EZ/BooksInCareOfDetail/PhoneNum08083922962
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt094-412 MAIKOIKO STREET
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0WAIPAHU
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0HI
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd096797
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt01633
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt086198
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt0131000
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt084565
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form720FiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt01633
IRS990EZ/Form990TotalAssetsGrp/EOYAmt086198
IRS990EZ/GrantsAndSimilarAmountsPaidAmt038265
IRS990EZ/GrossReceiptsAmt0131000
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt01633
IRS990EZ/NetAssetsOrFundBalancesEOYAmt086198
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt01633
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt086198
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt05
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt15
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0MARIA F ETRATA
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1RENATO V ETRATA
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2ROSEMARIES E MANUEL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1VICEPRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2KEY OFFICER
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationFiled990TInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt00
IRS990EZ/OtherAssetsTotalDetail/EOYAmt00
IRS990EZ/OtherExpensesTotalAmt08170
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PrimaryExemptPurposeTxt0PROMOTE AND SUPPORT EDUCSCHOLARSHIP ARTSCULTURE ETC
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0SCHOLARSHIPEDUCATIONAL PROGRAM
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1CULTUREARTS PROGRAM
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt2HUMANITARIAN HELPMEDICAL MISSIONS FOR THE POOR
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt3AMDINISTRATIONMISCELLANEOUS EXPENDITURES
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt021465
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt112300
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt24500
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt38170
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/RelatedOrgSect527OrgInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt046435
IRS990EZ/TotalProgramServiceExpensesAmt046435
IRS990EZ/TotalRevenueAmt0131000
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt0131000
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt0131000
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt0131000
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0131000
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct01.00000
IRS990ScheduleA/PublicSupportPY509Pct01.00000
IRS990ScheduleA/PublicSupportTotal170Amt00
IRS990ScheduleA/PublicSupportTotal509Amt0131000
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt0131000
IRS990ScheduleA/Total509Grp/TotalAmt0131000
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt0131000
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt0131000
IRS990ScheduleA/TotalSupportAmt0131000
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt0131000
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0131000
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Grants and other assistance to domestic organizations and governments $38265.00
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1OTHER/MISCELLANEOUSE EXPENSE $8170.00
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Expenses: $8170.00 including grants of: $0.00 Revenue: $0.00
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3AMDINISTRATION/MISCELLANEOUS EXPENDITURES
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4Scholarship/Educational Expenditures - $ 21,465.00
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5Culture/Arts Expsnditures - $ 12,300.00
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6Humanitarian/Medical Mission - $ 4,500.00
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7Office/Miscellaneous Expenditures - $ 8,170.00
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Part I Line 10
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Part I Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Part III
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Part III
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4PART III-Line 4a
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5PART III-Line 4b
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6PART III-Line 4c
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7PART III-Line 4d
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0false
ReturnHeader/BusinessOfficerGrp/PersonNm0MARIA F ETRATA
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum08083922962
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-04-04
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0RENATO & MARIA AF ETRATA FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0RENA
ReturnHeader/Filer/EIN0263870032
ReturnHeader/Filer/InCareOfNm0% MARIA F ETRATA
ReturnHeader/Filer/PhoneNum08083922962
ReturnHeader/Filer/USAddress/AddressLine1Txt094-412 MAIKOIKO STREET
ReturnHeader/Filer/USAddress/CityNm0WAIPAHU
ReturnHeader/Filer/USAddress/StateAbbreviationCd0HI
ReturnHeader/Filer/USAddress/ZIPCd096797
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0200669EE5D1A590211BADA1AAAA2EC9801EEA126
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0200669EE5D1A590211BADA1AAAA2EC9801EEA126
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId099187520180948843552
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02018-04-04
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt076.173.229.153
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0464488161
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0VILLARUZ FINANCIAL SERVICES LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0POBox 29912
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Honolulu
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0HI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd096820
ReturnHeader/PreparerPersonGrp/PhoneNum08087780233
ReturnHeader/PreparerPersonGrp/PreparationDt02018-04-04
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0DANNY VILLARUZ
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02018-04-04T12:46:00-06:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2017 • Form 990EZDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$86,198
Liabilities
$0
Net assets
$86,198
Revenue
$131,000
Expenses
$46,435
Net income
$84,565
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$1.73$0.00$1.76$0.60$0.29$0.31
2023Detailed filing. Detailed filing data is available for this year.$1.45$0.00$1.45$0.55$0.63$0.07
2022Detailed filing. Detailed filing data is available for this year.$1.52$0.00$1.52$0.64$0.35$0.29
2021Detailed filing. Detailed filing data is available for this year.$1.23$0.00$1.23$0.22$0.05$0.17
2020Detailed filing. Detailed filing data is available for this year.$1.07$0.00$1.07$0.42$0.18$0.23
2019Detailed filing. Detailed filing data is available for this year.$0.83$0.00$0.83$1.28$0.48$0.80
2018Detailed filing. Detailed filing data is available for this year.$0.62$0.00$0.62$0.60$0.84$0.24
2017Detailed filing. Detailed filing data is available for this year.$0.86$0.00$0.86$1.31$0.46$0.85