Civic Intelligence

Merced Union High School District Education Foundation

990EZ • Fiscal year 2017 • EIN 77-0312888

Jul 01, 2016 to Jun 30, 2017 • Filed on May 15, 2018

Organization ProfileN/A
P O Box 2147Merced, CA 95344

(209) 385-8026

Siviq Scores

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

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on this filing.

Source year 2017

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2017

Net Margin

93rd percentile

58%

Higher net margin than 93% 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

50th percentile

1.8%

Faster asset growth than 50% of similar nonprofits.

2017 filings • 501(c)3 • <$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

81st percentile

35%

Faster revenue growth than 81% of similar nonprofits.

2017 filings • 501(c)3 • <$500k nonprofits • Annualized from 2016 to 2017

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Up

$343,362

Up $6,170 (+1.8%) from 2016

Net Assets

Up

$343,362

Up $6,170 (+1.8%) from 2016

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin93rd percentile

Revenue

Up

$11,764

Up $3,043 (+35%) from 2016

Expenses

Up

$4,940

Up $4,091 (+482%) from 2016

Net Income

Down

$6,824

Down $1,048 (-13%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth50th percentile

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

$600K$400K$200K$0Assets 2010: $309,086Liabilities 2010: $309,086Net Assets 2010: $02010Assets 2011: $312,814Liabilities 2011: $0Net Assets 2011: $312,8142011Assets 2012: $308,831Liabilities 2012: $0Net Assets 2012: $308,8312012Assets 2013: $303,077Liabilities 2013: $0Net Assets 2013: $303,0772013Assets 2014: $326,626Net Assets 2014: $326,6262014Assets 2015: $329,320Liabilities 2015: $0Net Assets 2015: $329,3202015Assets 2016: $337,192Net Assets 2016: $337,1922016Assets 2017: $343,362Net Assets 2017: $343,3622017Assets 2018: $346,855Net Assets 2018: $346,8552018Assets 2019: $365,830Liabilities 2019: $02019Assets 2020: $352,129Net Assets 2020: $352,1292020Assets 2021: $407,937Net Assets 2021: $407,9372021Assets 2022: $376,611Net Assets 2022: $376,6112022Assets 2023: $391,356Liabilities 2023: $02023Assets 2024: $417,341Net Assets 2024: $417,3412024

Highlighted filing

2017

Assets$343,362
Liabilities-
Net Assets$343,362
Open 2017 Filing

Operations Trend

Revenue Growth81st percentile

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

$40K$20K$0-$20KExpenses 2010: $36,4312010Expenses 2011: $17,9712011Revenue 2012: $16,954Expenses 2012: $20,845Net Income 2012: -$3,8912012Expenses 2013: $10,0202013Revenue 2014: $12,211Expenses 2014: $5,469Net Income 2014: $6,7422014Revenue 2015: $14,492Expenses 2015: $4,578Net Income 2015: $9,9142015Revenue 2016: $8,721Expenses 2016: $849Net Income 2016: $7,8722016Revenue 2017: $11,764Expenses 2017: $4,940Net Income 2017: $6,8242017Revenue 2018: $15,280Expenses 2018: $5,716Net Income 2018: $9,5642018Revenue 2019: $15,542Expenses 2019: $5,197Net Income 2019: $10,3452019Revenue 2020: $16,325Expenses 2020: $4,746Net Income 2020: $11,5792020Revenue 2021: $15,553Expenses 2021: $4,795Net Income 2021: $10,7582021Revenue 2022: $16,461Expenses 2022: $5,172Net Income 2022: $11,2892022Revenue 2023: $18,174Expenses 2023: $5,482Net Income 2023: $12,6922023Revenue 2024: $20,395Expenses 2024: $5,655Net Income 2024: $14,7402024

Highlighted filing

2017

Revenue$11,764
Expenses$4,940
Net Income$6,824
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Signed
May 15, 2018
Return Version
2016v3.0
Gross Receipts
$11,764
Mission and Program Overview

Mission

Provide educational grants and scholarships

Program Services

DescriptionGrantsExpenses
GRANTS--
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
RAYBORD OWENSPresident-$0--
LIZ GUERREROVice President-$0--
RALPH CALDERONSecretary-$0--
DEBBIE PEREZTreasurer-$0--
Filing and Contact Details

Filer

Filer Name
Merced Union High School
EIN
77-0312888
Phone
2093858026
Address
P O BOX 2147, MERCED, CA 95344

Signing Officer

Name
Debbie Perez
Title
Treasurer
Signed
2018-05-15
Discuss with paid preparer
Yes

Preparer

Firm
Stapp Accountancy Inc
Address
110 W Alexander Ave, Merced, CA 95348-3410
Preparer
Elizabeth D Sousa
Phone
2093833955
Supplemental Narrative

Additional Explanations

Other Expenses.1

“BROKER FEES $4346”

Raw XML Appendix132 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/PersonNm0DEBBIE PEREZ
IRS990EZ/BooksInCareOfDetail/PhoneNum02093858026
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0P O BOX 2147
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0MERCED
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0CA
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd0953440147
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0337192
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0343362
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt06824
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0594
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form720FiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0337192
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0343362
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GrossReceiptsAmt011764
IRS990EZ/GrossReceiptsForPublicUseAmt00
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InfoInScheduleOPartVInd0X
IRS990EZ/InitiationFeesAndCapContriAmt00
IRS990EZ/InvestmentIncomeAmt011764
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0337192
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0343362
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0337192
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0343362
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt31.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0RAYBORD OWENS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1LIZ GUERRERO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2RALPH CALDERON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3DEBBIE PEREZ
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0President
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Vice President
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Secretary
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Treasurer
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationFiled990TInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherChangesInNetAssetsAmt0-654
IRS990EZ/OtherExpensesTotalAmt04346
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0PROVIDE EDUCATIONAL GRANTS AND SCHOLARSHIPS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0GRANTS
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/RelatedOrgSect527OrgInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt04940
IRS990EZ/TotalRevenueAmt011764
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/First5Years170Ind0X
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt0500
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt0463
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt01958
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt0372
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt03293
IRS990ScheduleA/GovtFurnSrvcFcltsVl170Grp/TotalAmt00
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus1YearAmt0776
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt012693
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus3YearsAmt010252
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus4YearsAmt01770
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt025491
IRS990ScheduleA/OtherIncome170Grp/TotalAmt00
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.00000
IRS990ScheduleA/PublicSupportTotal170Amt03293
IRS990ScheduleA/SubstantialContributorsTotAmt00
IRS990ScheduleA/TaxRevLeviedOrgnztnlBnft170Grp/TotalAmt00
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt0500
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt0463
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt01958
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt0372
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt03293
IRS990ScheduleA/TotalSupportAmt028784
IRS990ScheduleA/UnrelatedBusinessNetIncm170Grp/TotalAmt00
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0BROKER FEES $4346
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Other Expenses.1
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0DEBBIE PEREZ
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Treasurer
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-15
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0MERCED UNION HIGH SCHOOL
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0EDUCATION FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0MERC
ReturnHeader/Filer/EIN0770312888
ReturnHeader/Filer/PhoneNum02093858026
ReturnHeader/Filer/USAddress/AddressLine1Txt0P O BOX 2147
ReturnHeader/Filer/USAddress/CityNm0MERCED
ReturnHeader/Filer/USAddress/StateAbbreviationCd0CA
ReturnHeader/Filer/USAddress/ZIPCd095344
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Stapp Accountancy Inc
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0110 W Alexander Ave
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Merced
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0CA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0953483410
ReturnHeader/PreparerPersonGrp/PhoneNum02093833955
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Elizabeth D Sousa
ReturnHeader/ReturnTs02018-05-15T15:41:21-07:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-07-01
ReturnHeader/TaxPeriodEndDt02017-06-30
ReturnHeader/TaxYr02016

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
$343,362
Liabilities
-
Net assets
$343,362
Revenue
$11,764
Expenses
$4,940
Net income
$6,824
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.17$4.17$0.20$0.06$0.15
2023Summary only. Only limited summary data is available for this year.$3.91$0.00$0.18$0.05$0.13
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$3.77$3.77$0.16$0.05$0.11
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.08$4.08$0.16$0.05$0.11
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$3.52$3.52$0.16$0.05$0.12
2019Summary only. Only limited summary data is available for this year.$3.66$0.00$0.16$0.05$0.10
2018Detailed filing. Detailed filing data is available for this year.$3.47$3.47$0.15$0.06$0.10
2017Detailed filing. Detailed filing data is available for this year.$3.43$3.43$0.12$0.05$0.07
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$3.37$3.37$0.09$0.01$0.08
2015Summary only. Only limited summary data is available for this year.$3.29$0.00$3.29$0.14$0.05$0.10
2014Detailed filing. Detailed filing data is available for this year.$3.27$3.27$0.12$0.05$0.07
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.03$0.00$3.03$0.10
2012Summary only. Only limited summary data is available for this year.$3.09$0.00$3.09$0.17$0.21$0.04
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.13$0.00$3.13$0.18
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.09$3.09$0.00$0.36