Civic Intelligence

Mercer School

990EZ • Fiscal year 2017 • EIN 20-2931688

Jan 01, 2017 to Dec 31, 2017 • Filed on Aug 07, 2018

Organization ProfileN/A
2801 E MissouriLas Cruces, NM 88011

(575) 522-6900

Siviq Scores

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

Liabilities / Assets

100th percentile

227.49x

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

2017 filings • NTEE B • <$500k nonprofits • Source year 2017

Liabilities / Revenue

92nd percentile

0.30x

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

2017 filings • NTEE B • <$500k nonprofits • Source year 2017

Net Margin

17th percentile

-20%

Higher net margin than 17% of similar nonprofits.

2017 filings • NTEE B • <$500k nonprofits • Source year 2017

Top Officer Pay

84th percentile

$0

Higher top officer pay than 84% of similar nonprofits.

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

2017 filings • NTEE B • <$500k nonprofits • Source year 2017

Asset Growth

2nd percentile

-76%

Faster asset growth than 2% of similar nonprofits.

2017 filings • NTEE B • <$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

48th percentile

0.0%

Faster revenue growth than 48% of similar nonprofits.

2017 filings • NTEE B • <$500k nonprofits • Annualized from 2016 to 2017

Balance Sheet
Liabilities / Assets100th percentile

Assets

Down

$186

Down $590 (-76%) from 2016

Net Assets

Down

-$42,127

Down $28,020 (-199%) from 2016

Liabilities

Up

$42,313

Up $27,430 (+184%) from 2016

Revenue And Expenses
Liabilities / Revenue92nd percentileNet Margin17th percentile

Revenue

Up

$142,190

Up $41 (+0.0%) from 2016

Expenses

Up

$170,212

Up $17,438 (+11%) from 2016

Net Income

Down

-$28,022

Down $17,397 (-164%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth2nd percentile

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

$100K$50K$0-$50KAssets 2010: $0Liabilities 2010: $6,554Net Assets 2010: -$6,5542010Assets 2011: $0Liabilities 2011: $02011Assets 2012: $1Liabilities 2012: $7,7672012Assets 2013: $1Liabilities 2013: $10,9522013Assets 2014: $1Liabilities 2014: $38,0172014Assets 2015: $640Liabilities 2015: $4,1232015Assets 2016: $776Liabilities 2016: $14,883Net Assets 2016: -$14,1072016Assets 2017: $186Liabilities 2017: $42,313Net Assets 2017: -$42,1272017Assets 2018: $1,815Liabilities 2018: $46,400Net Assets 2018: -$44,5852018Assets 2019: $1,391Liabilities 2019: $48,793Net Assets 2019: -$47,4022019Assets 2020: $2,846Liabilities 2020: $43,522Net Assets 2020: -$40,6762020Assets 2021: $1,356Liabilities 2021: $48,590Net Assets 2021: -$47,2342021Assets 2022: $1,844Liabilities 2022: $50,114Net Assets 2022: -$48,2702022Assets 2023: $9,114Liabilities 2023: $36,870Net Assets 2023: -$27,7562023Assets 2024: $3,980Liabilities 2024: $32,812Net Assets 2024: -$28,8322024

Highlighted filing

2017

Assets$186
Liabilities$42,313
Net Assets-$42,127
Open 2017 Filing

Operations Trend

Revenue Growth48th percentile

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

$200K$150K$100K$50K$0-$50KRevenue 2010: $144,015Expenses 2010: $140,598Net Income 2010: $3,4172010Revenue 2011: $93,176Expenses 2011: $94,043Net Income 2011: -$8672011Revenue 2012: $100,712Expenses 2012: $101,925Net Income 2012: -$1,2132012Revenue 2013: $87,596Expenses 2013: $90,781Net Income 2013: -$3,1852013Revenue 2014: $108,109Expenses 2014: $135,174Net Income 2014: -$27,0652014Revenue 2015: $155,221Expenses 2015: $123,401Net Income 2015: $31,8202015Revenue 2016: $142,149Expenses 2016: $152,774Net Income 2016: -$10,6252016Revenue 2017: $142,190Expenses 2017: $170,212Net Income 2017: -$28,0222017Revenue 2018: $148,831Expenses 2018: $151,289Net Income 2018: -$2,4582018Revenue 2019: $149,858Expenses 2019: $152,675Net Income 2019: -$2,8172019Revenue 2020: $135,174Expenses 2020: $128,448Net Income 2020: $6,7262020Revenue 2021: $123,614Expenses 2021: $130,173Net Income 2021: -$6,5592021Revenue 2022: $146,238Expenses 2022: $147,274Net Income 2022: -$1,0362022Revenue 2023: $171,771Expenses 2023: $151,257Net Income 2023: $20,5142023Revenue 2024: $148,697Expenses 2024: $149,772Net Income 2024: -$1,0752024

Highlighted filing

2017

Revenue$142,190
Expenses$170,212
Net Income-$28,022
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Aug 7, 2018
Return Version
2017v2.3
Gross Receipts
$142,190
Mission and Program Overview

Mission

Learning center/private school for children age 4-19

Program Services

DescriptionGrantsExpenses
SCHOOL FOR CHILDREN AGE 4-19-$170,212
Compensation and Service Providers
Top Officer Pay84th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
ANN S MERCERPresident-$0--
EILEEN NEVAREZSecretary-$0--
Filing and Contact Details

Filer

Filer Name
Mercer School
EIN
20-2931688
Phone
5755226900
Address
2801 E MISSOURI, LAS CRUCES, NM 88011

Signing Officer

Name
Ann S Mercer
Title
President
Phone
5755226900
Signed
2018-08-07
Discuss with paid preparer
Yes

Preparer

Firm
Schwalm Martos & Co Pc
Address
560 N WATER ST, LAS CRUCES, NM 88001
Preparer
Manuel R Martos
Phone
5755252282
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

“Expenses bank charges 566 misc 8 penalties 1,444 repairs 211 sewing class 2,700 supples 9,181 utilies 2,263 storage 55 teachers and subs 9,090 total 25,518”

Form 990-ez, Part I, Line 20

“Changes to net assets prior year 0”

Form 990-ez, Part II, Line 24

“Other loans receivable 0 186 total 0 186”

Form 990-ez, Part II, Line 26

“Other liabilities 2,800 2,800 payroll taxes 12,083 36,073 overdraft 0 3,440”

Raw XML Appendix130 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/PersonNm0ANN MERCER
IRS990EZ/BooksInCareOfDetail/PhoneNum05755226918
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt02801 E MISSOURI
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0LAS CRUCES
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0NM
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd088011
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0778
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt066379
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-28022
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt01000
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0778
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0186
IRS990EZ/GrossReceiptsAmt0142190
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0-14105
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0-42127
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0-14105
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0-42127
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0ANN S MERCER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1EILEEN NEVAREZ
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1SECRETARY
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/EOYAmt0186
IRS990EZ/OtherExpensesTotalAmt025518
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0LEARNING CENTER/PRIVATE SCHOOL FOR CHILDREN AGE 4-19
IRS990EZ/ProgramServiceRevenueAmt075811
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0SCHOOL FOR CHILDREN AGE 4-19
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt0170212
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt0143694
IRS990EZ/SchoolOperatingInd0true
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt014883
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt042313
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0170212
IRS990EZ/TotalProgramServiceExpensesAmt0170212
IRS990EZ/TotalRevenueAmt0142190
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/SchoolInd0X
IRS990ScheduleE/ComplianceWithRevProc7550Ind0true
IRS990ScheduleE/DiscriminateRaceAdmissPlcyInd0false
IRS990ScheduleE/DiscriminateRaceAthltProgInd0false
IRS990ScheduleE/DiscriminateRaceEducPlcyInd0false
IRS990ScheduleE/DiscriminateRaceEmplmFcultyInd0false
IRS990ScheduleE/DiscriminateRaceOtherActyInd0false
IRS990ScheduleE/DiscriminateRaceSchsInd0false
IRS990ScheduleE/DiscriminateRaceStdntsRghtsInd0false
IRS990ScheduleE/DiscriminateRaceUseOfFcltsInd0false
IRS990ScheduleE/GovernmentFinancialAidRcvdInd0false
IRS990ScheduleE/GovernmentFinancialAidRvkdInd0false
IRS990ScheduleE/MaintainCpyOfAllSolInd0true
IRS990ScheduleE/MaintainCpyOfBrochuresEtcInd0true
IRS990ScheduleE/MaintainRacialCompRecsInd0true
IRS990ScheduleE/MaintainScholarshipsRecsInd0true
IRS990ScheduleE/NondiscriminatoryPolicyStmtInd0true
IRS990ScheduleE/PlcyPblczdViaBroadcastMediaInd0true
IRS990ScheduleE/PolicyStmtInBrochuresEtcInd0true
IRS990ScheduleE/SupplementalInformationDetail/ExplanationTxt0ADVERTISING IN LAS CRUCES PAPER
IRS990ScheduleE/SupplementalInformationDetail/FormAndLineReferenceDesc0SCHEDULE E, LINE 3
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES BANK CHARGES 566 MISC 8 PENALTIES 1,444 REPAIRS 211 SEWING CLASS 2,700 SUPPLES 9,181 UTILIES 2,263 STORAGE 55 TEACHERS AND SUBS 9,090 TOTAL 25,518
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1CHANGES TO NET ASSETS PRIOR YEAR 0
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2OTHER LOANS RECEIVABLE 0 186 TOTAL 0 186
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3OTHER LIABILITIES 2,800 2,800 PAYROLL TAXES 12,083 36,073 OVERDRAFT 0 3,440
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 20
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART II, LINE 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART II, LINE 26
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0ANN S MERCER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum05755226900
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-08-07
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0MERCER SCHOOL
ReturnHeader/Filer/BusinessNameControlTxt0MERC
ReturnHeader/Filer/EIN0202931688
ReturnHeader/Filer/PhoneNum05755226900
ReturnHeader/Filer/USAddress/AddressLine1Txt02801 E MISSOURI
ReturnHeader/Filer/USAddress/CityNm0LAS CRUCES
ReturnHeader/Filer/USAddress/StateAbbreviationCd0NM
ReturnHeader/Filer/USAddress/ZIPCd088011
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId096200C9BDA4B4AA75EBE49A09F5D941F617E0ECE
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId03D462B1B422E448D2DF2153B26D72EC4F72FFD3B
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0167.68.16.49
ReturnHeader/FilingSecurityInformation/IPDt02018-08-21
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm009:29:49
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0850427233
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0SCHWALM MARTOS & CO PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0560 N WATER ST
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0LAS CRUCES
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0NM
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd088001
ReturnHeader/PreparerPersonGrp/PhoneNum05755252282
ReturnHeader/PreparerPersonGrp/PreparationDt02018-08-07
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0MANUEL R MARTOS
ReturnHeader/ReturnTs02018-08-21T08:29:49-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
$186
Liabilities
$42,313
Net assets
-$42,127
Revenue
$142,190
Expenses
$170,212
Net income
-$28,022
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$0.04$0.33$0.29$1.49$1.50$0.01
2023Detailed filing. Detailed filing data is available for this year.$0.09$0.37$0.28$1.72$1.51$0.21
2022Detailed filing. Detailed filing data is available for this year.$0.02$0.50$0.48$1.46$1.47$0.01
2021Detailed filing. Detailed filing data is available for this year.$0.01$0.49$0.47$1.24$1.30$0.07
2020Detailed filing. Detailed filing data is available for this year.$0.03$0.44$0.41$1.35$1.28$0.07
2019Detailed filing. Detailed filing data is available for this year.$0.01$0.49$0.47$1.50$1.53$0.03
2018Detailed filing. Detailed filing data is available for this year.$0.02$0.46$0.45$1.49$1.51$0.02
2017Detailed filing. Detailed filing data is available for this year.$0.00$0.42$0.42$1.42$1.70$0.28
2016Detailed filing. Detailed filing data is available for this year.$0.01$0.15$0.14$1.42$1.53$0.11
2015Summary only. Only limited summary data is available for this year.$0.01$0.04$1.55$1.23$0.32
2014Summary only. Only limited summary data is available for this year.$0.00$0.38$1.08$1.35$0.27
2013Summary only. Only limited summary data is available for this year.$0.00$0.11$0.88$0.91$0.03
2012Summary only. Only limited summary data is available for this year.$0.00$0.08$1.01$1.02$0.01
2011Summary only. Only limited summary data is available for this year.$0.00$0.00$0.93$0.94$0.01
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.00$0.07$0.07$1.44$1.41$0.03