Civic Intelligence

Ahwatukee Foothills Prep Inc

990EZ • Fiscal year 2017 • EIN 90-0144759

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

Organization ProfileWWW.MOSAICAPREP.ORG
2929 N Central Ave No 2100Phoenix, AZ 85012

(877) 496-1011

Siviq Scores

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

Liabilities / Assets

100th percentile

1220.52x

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

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

Liabilities / Revenue

100th percentile

97246.37x

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

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

Net Margin

1st percentile

-15994%

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

2nd percentile

-97%

Faster asset growth than 2% of similar nonprofits.

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

Revenue Growth

1st percentile

-100%

Faster revenue growth than 1% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets100th percentile

Assets

Down

$8,366

Down $306,141 (-97%) from 2016

Net Assets

Down

-$10,202,503

Down $16,794 (-0.2%) from 2016

Liabilities

Down

$10,210,869

Down $289,347 (-2.8%) from 2016

Revenue And Expenses
Liabilities / Revenue100th percentileNet Margin1st percentile

Revenue

Down

$105

Down $397,025 (-100%) from 2016

Expenses

Down

$16,899

Down $356,005 (-95%) from 2016

Net Income

Down

-$16,794

Down $41,020 (-169%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth2nd percentile

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

$20M$10M$0-$10M-$20MAssets 2010: $514,321Liabilities 2010: $7,011,211Net Assets 2010: -$6,496,8902010Assets 2011: $738,475Liabilities 2011: $8,018,716Net Assets 2011: -$7,280,2412011Assets 2012: $453,527Liabilities 2012: $8,009,475Net Assets 2012: -$7,555,9482012Assets 2013: $357,520Liabilities 2013: $8,995,926Net Assets 2013: -$8,638,4062013Assets 2014: $276,768Liabilities 2014: $10,098,969Net Assets 2014: -$9,822,2012014Assets 2015: $73,113Liabilities 2015: $10,283,048Net Assets 2015: -$10,209,9352015Assets 2016: $314,507Liabilities 2016: $10,500,216Net Assets 2016: -$10,185,7092016Assets 2017: $8,366Liabilities 2017: $10,210,869Net Assets 2017: -$10,202,5032017

Highlighted filing

2017

Assets$8,366
Liabilities$10,210,869
Net Assets-$10,202,503
Open 2017 Filing

Operations Trend

Revenue Growth1st percentile

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

$4.0M$2.0M$0-$2.0MExpenses 2010: $3,480,8972010Expenses 2011: $3,585,7582011Expenses 2012: $3,331,7742012Revenue 2013: $1,951,524Expenses 2013: $3,033,982Net Income 2013: -$1,082,4582013Revenue 2014: $1,984,196Expenses 2014: $3,167,991Net Income 2014: -$1,183,7952014Revenue 2015: $1,828,990Expenses 2015: $2,216,724Net Income 2015: -$387,7342015Revenue 2016: $397,130Expenses 2016: $372,904Net Income 2016: $24,2262016Revenue 2017: $105Expenses 2017: $16,899Net Income 2017: -$16,7942017

Highlighted filing

2017

Revenue$105
Expenses$16,899
Net Income-$16,794
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Signed
May 14, 2018
Return Version
2016v3.0
Gross Receipts
$105
Mission and Program Overview

Mission

Charter school providing education to students in kindergarten through the eighth grade.

Charter school providing education to students in kindergarten through eighth grade.

Program Services

DescriptionGrantsExpenses
PROVIDE EDUCATIONAL SERVICES TO STUDENTS IN KINDERGARTEN THROUGH EIGHTH GRADES IN ARIZONA.$0$16,899
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
BRIAN BISSELLPresident-$0--
LEW TAYLORDirector-$0--
CAITLIN ALEXANDERTreasurer-$0--
Filing and Contact Details

Filer

Filer Name
Ahwatukee Foothills Prep
EIN
90-0144759
In Care Of
% Caitlin Alexander
Phone
8774961011
Address
2929 N Central Ave No 2100, Phoenix, AZ 85012

Signing Officer

Name
Caitlin Alexander
Title
Treasurer
Phone
8777778582
Signed
2018-05-14
Supplemental Narrative

Additional Explanations

Part I, line 16

“| Other Expenses:, Amount:| Insurance, $4742.00| Bank Fees, $447.00|”

Part II, line 24

“| Asset Name:, BOY Amount:, EOY Amount:| Prepaid Expenses, $33107, $5826|”

Part II, line 26

“| Liabilities Name:, BOY Amount:, EOY Amount:| Accounts Payable, $393038, $103691| Mortgages or other loans payable, $10107178, $10107178|”

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/PersonNm0CAITLIN ALEXANDER
IRS990EZ/BooksInCareOfDetail/PhoneNum08777778582
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0165 S UNION BLVD STE 777
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0LAKEWOOD
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0CO
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd080228
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0281400
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt02540
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-16794
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt011710
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0314507
IRS990EZ/Form990TotalAssetsGrp/EOYAmt08366
IRS990EZ/GrossProfitLossSlsOfInvntryAmt00
IRS990EZ/GrossReceiptsAmt0105
IRS990EZ/GrossSalesOfInventoryAmt00
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0105
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0-10185709
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0-10202503
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0-10185709
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0-10202503
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11
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/PersonNm0BRIAN BISSELL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1LEW TAYLOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2CAITLIN ALEXANDER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2TREASURER
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt033107
IRS990EZ/OtherAssetsTotalDetail/EOYAmt05826
IRS990EZ/OtherChangesInNetAssetsAmt00
IRS990EZ/OtherExpensesTotalAmt05189
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0CHARTER SCHOOL PROVIDING EDUCATION TO STUDENTS IN KINDERGARTEN THROUGH EIGHTH GRADE.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PROVIDE EDUCATIONAL SERVICES TO STUDENTS IN KINDERGARTEN THROUGH EIGHTH GRADES IN ARIZONA.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt016899
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0true
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0AZ
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt010500216
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt010210869
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt016899
IRS990EZ/TotalProgramServiceExpensesAmt016899
IRS990EZ/TotalRevenueAmt0105
IRS990EZ/TypeOfOrganizationCorpInd0X
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/PlcyPblczdViaBroadcastMediaInd0false
IRS990ScheduleE/PolicyStmtInBrochuresEtcInd0true
IRS990ScheduleE/SupplementalInformationDetail/ExplanationTxt0INTERNAL PUBLICATIONS ONLY.
IRS990ScheduleE/SupplementalInformationDetail/FormAndLineReferenceDesc0Part 1, line 3
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0| Other Expenses:, Amount:| Insurance, $4742.00| Bank Fees, $447.00|
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1| Asset Name:, BOY Amount:, EOY Amount:| Prepaid Expenses, $33107, $5826|
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2| Liabilities Name:, BOY Amount:, EOY Amount:| Accounts Payable, $393038, $103691| Mortgages or other loans payable, $10107178, $10107178|
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Part I, line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Part II, line 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Part II, line 26
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/PersonNm0CAITLIN ALEXANDER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum08777778582
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-14
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Ahwatukee Foothills Prep
ReturnHeader/Filer/BusinessNameControlTxt0AHWA
ReturnHeader/Filer/EIN0900144759
ReturnHeader/Filer/InCareOfNm0% Caitlin Alexander
ReturnHeader/Filer/PhoneNum08774961011
ReturnHeader/Filer/USAddress/AddressLine1Txt02929 N Central Ave No 2100
ReturnHeader/Filer/USAddress/CityNm0Phoenix
ReturnHeader/Filer/USAddress/StateAbbreviationCd0AZ
ReturnHeader/Filer/USAddress/ZIPCd085012
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt050.224.146.110
ReturnHeader/FilingSecurityInformation/IPDt02018-05-14
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0ES
ReturnHeader/ReturnTs02018-05-14T14:07:46-04: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
$8,366
Liabilities
$10,210,869
Net assets
-$10,202,503
Revenue
$105
Expenses
$16,899
Net income
-$16,794
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2017Detailed filing. Detailed filing data is available for this year.$0.01$10.2$10.2$0.00$0.02$0.02
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.31$10.5$10.2$0.40$0.37$0.02
2015Detailed filing. Detailed filing data is available for this year.$0.07$10.3$10.2$1.83$2.22$0.39
2014Detailed filing. Detailed filing data is available for this year.$0.28$10.1$9.82$1.98$3.17$1.18
2013Summary only. Only limited summary data is available for this year.$0.36$9.00$8.64$1.95$3.03$1.08
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.45$8.01$7.56$3.33
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.74$8.02$7.28$3.59
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.51$7.01$6.50$3.48