Civic Intelligence

John Sperling Foundation

990T • Fiscal year 2022 • EIN 32-0284165

Sep 01, 2021 to Aug 31, 2022 • Filed on Jun 30, 2023

Organization Profile
5115 N Dysart Road Suite 202 305Litchfield Park, AZ 85340

(602) 364-8000

Siviq Scores

Scores are not available for this record yet.

Balance Sheet

Assets

-

No earlier filing loaded for comparison.

Net Assets

-

No earlier filing loaded for comparison.

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses

Revenue

-

No earlier filing loaded for comparison.

Expenses

-

No earlier filing loaded for comparison.

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

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

$100M$50M$0Assets 2016: $1,588,892Liabilities 2016: $0Net Assets 2016: $1,588,8922016Assets 2017: $2,262,194Liabilities 2017: $0Net Assets 2017: $2,262,1942017Assets 2020: $67,949,269Liabilities 2020: $0Net Assets 2020: $67,949,2692020Assets 2021: $77,288,509Liabilities 2021: $0Net Assets 2021: $77,288,5092021Assets 2022: $63,403,300Liabilities 2022: $0Net Assets 2022: $63,403,3002022Assets 2023: $73,594,521Liabilities 2023: $0Net Assets 2023: $73,594,5212023Assets 2024: $80,243,940Liabilities 2024: $0Net Assets 2024: $80,243,9402024

Latest loaded filing

2024

Assets$80,243,940
Liabilities$0
Net Assets$80,243,940
Open 2024 Filing

Operations Trend

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

$10M$5.0M$0-$5.0MRevenue 2016: $850,000Expenses 2016: $70,327Net Income 2016: $779,6732016Revenue 2017: $850,000Expenses 2017: $176,698Net Income 2017: $673,3022017Revenue 2020: $4,083,052Expenses 2020: $3,325,321Net Income 2020: $757,7312020Revenue 2021: $3,080,219Expenses 2021: $3,601,086Net Income 2021: -$520,8672021Revenue 2022: $3,071,599Expenses 2022: $4,360,825Net Income 2022: -$1,289,2262022Revenue 2023: $773,167Expenses 2023: $5,415,701Net Income 2023: -$4,642,5342023Revenue 2024: $2,715,432Expenses 2024: $5,176,927Net Income 2024: -$2,461,4952024

Latest loaded filing

2024

Revenue$2,715,432
Expenses$5,176,927
Net Income-$2,461,495
Open 2024 Filing
Jump To
Filing Snapshot
Filing Period
Sep 1, 2021 to Aug 31, 2022
Signed
Jun 30, 2023
Return Version
2021v4.3
Filing and Contact Details

Filer

Filer Name
John Sperling Foundation
EIN
32-0284165
Phone
6023648000
Address
5115 N DYSART ROAD SUITE 202 305, LITCHFIELD PARK, AZ 85340

Signing Officer

Name
Darby Shupp
Title
Treasurer
Phone
6023648000
Signed
2023-06-30
Discuss with paid preparer
Yes

Preparer

Firm
Pricewaterhousecoopers Llp
Address
1850 N CENTRAL AVE STE 700, PHOENIX, AZ 85004-4563
Preparer
Chad Thurston
Phone
6023648000
Raw XML Appendix163 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
IRS990T/BooksInCareOfDetail/PersonNm0DARBY SHUPP
IRS990T/BooksInCareOfDetail/PhoneNum06023648000
IRS990T/BooksInCareOfDetail/USAddress/AddressLine1Txt05115 N DYSART RD STE 202 305
IRS990T/BooksInCareOfDetail/USAddress/CityNm0LITCHFIELD PARK
IRS990T/BooksInCareOfDetail/USAddress/StateAbbreviationCd0AZ
IRS990T/BooksInCareOfDetail/USAddress/ZIPCd085340
IRS990T/BookValueAssetsEOYAmt063403300
IRS990T/ChangeInMethodOfAccountingInd00
IRS990T/CharitableContributionsDedAmt00
IRS990T/EstimatedTaxPaymentsAmt0286132
IRS990T/ExtsnRequestIncomeTaxPaidAmt0660000
IRS990T/ForeignAccountsQuestionInd00
IRS990T/ForeignTrustQuestionInd00
IRS990T/Form990TScheduleAAttachedCnt02
IRS990T/Organization501cCorporationInd0X
IRS990T/Organization501IndicatorGrp/Organization501cTypeTxt0c3
IRS990T/Organization501IndicatorGrp/Organization501Ind0X
IRS990T/OverpaymentSection/AppliedToESTaxAmt0657298
IRS990T/OverpaymentSection/OverpaymentAmt0657298
IRS990T/OverpaymentSection/RefundAmt00
IRS990T/PaidTaxLiabilityAmt00
IRS990T/Post2017NOLCarryoverGrp/AvlblPost2017NOLCarryoverAmt0226443
IRS990T/Post2017NOLCarryoverGrp/PrincipalBusinessActivityCd0710000
IRS990T/PriorYearOverpaymentCreditAmt04895
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/DeductionSetAsidesAmt00
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/DeductionSetAsidesAmt10
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/IncomeTypeDesc0PROPERTY MANAGEMENT
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/IncomeTypeDesc1GOLF COURSE
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/InvestmentIncomeAmt00
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/InvestmentIncomeAmt10
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/InvestmentIncomeDeductionAmt00
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/InvestmentIncomeDeductionAmt10
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/InvestmentIncomeSetAsidesAmt00
IRS990TScheduleA/InvestmentIncmSect501c7917Grp/InvestmentIncomeSetAsidesAmt10
IRS990TScheduleA/NetOperatingLossDeductionAmt00
IRS990TScheduleA/NetOperatingLossDeductionAmt1144702
IRS990TScheduleA/OtherIncomeAmt00
IRS990TScheduleA/PrincipalBusinessActivityCd0530000
IRS990TScheduleA/PrincipalBusinessActivityCd1710000
IRS990TScheduleA/RentIncomePropertyGrp/DeductionsConnectedRentIncmAmt00
IRS990TScheduleA/RentIncomePropertyGrp/DeductionsConnectedRentIncmAmt10
IRS990TScheduleA/RentIncomePropertyGrp/RentPersonalPropertyAmt00
IRS990TScheduleA/RentIncomePropertyGrp/RentPersonalPropertyAmt10
IRS990TScheduleA/RentIncomePropertyGrp/RentRealPersonalPropertyAmt00
IRS990TScheduleA/RentIncomePropertyGrp/RentRealPersonalPropertyAmt10
IRS990TScheduleA/RentIncomePropertyGrp/TotalRentsByPropertyAmt00
IRS990TScheduleA/RentIncomePropertyGrp/TotalRentsByPropertyAmt10
IRS990TScheduleA/RentIncomePropertyGrp/USAddress/AddressLine1Txt04148 NORTH ARCADIA DRIVE
IRS990TScheduleA/RentIncomePropertyGrp/USAddress/AddressLine1Txt14148 NORTH ARCADIA DRIVE
IRS990TScheduleA/RentIncomePropertyGrp/USAddress/CityNm0PHOENIX
IRS990TScheduleA/RentIncomePropertyGrp/USAddress/CityNm1PHOENIX
IRS990TScheduleA/RentIncomePropertyGrp/USAddress/StateAbbreviationCd0AZ
IRS990TScheduleA/RentIncomePropertyGrp/USAddress/StateAbbreviationCd1AZ
IRS990TScheduleA/RentIncomePropertyGrp/USAddress/ZIPCd085018
IRS990TScheduleA/RentIncomePropertyGrp/USAddress/ZIPCd185018
IRS990TScheduleA/SequenceReferenceNum01
IRS990TScheduleA/SequenceReferenceNum12
IRS990TScheduleA/SequenceTotalNum02
IRS990TScheduleA/SequenceTotalNum12
IRS990TScheduleA/TotalAllocableDeductionsAmt00
IRS990TScheduleA/TotalAllocableDeductionsAmt10
IRS990TScheduleA/TotalCtrlOrgDeductionAmt00
IRS990TScheduleA/TotalCtrlOrgDeductionAmt10
IRS990TScheduleA/TotalCtrlOrgPymtGrossIncmAmt00
IRS990TScheduleA/TotalCtrlOrgPymtGrossIncmAmt10
IRS990TScheduleA/TotalDeductionsAmt00
IRS990TScheduleA/TotalDeductionsAmt10
IRS990TScheduleA/TotalDeductionSetAsidesAmt00
IRS990TScheduleA/TotalDeductionSetAsidesAmt10
IRS990TScheduleA/TotalDirectAdvertisingCostAmt00
IRS990TScheduleA/TotalDirectAdvertisingCostAmt10
IRS990TScheduleA/TotalDividendsReceivedDedAmt00
IRS990TScheduleA/TotalDividendsReceivedDedAmt10
IRS990TScheduleA/TotalGrossAdvertisingIncomeAmt00
IRS990TScheduleA/TotalGrossAdvertisingIncomeAmt10
IRS990TScheduleA/TotalGrossDebtFinancedIncmAmt00
IRS990TScheduleA/TotalGrossDebtFinancedIncmAmt10
IRS990TScheduleA/TotalInvestmentIncomeAmt00
IRS990TScheduleA/TotalInvestmentIncomeAmt10
IRS990TScheduleA/TotalPrtshpSCorpIncomeAmt01363535
IRS990TScheduleA/TotalPrtshpSCorpIncomeAmt1180878
IRS990TScheduleA/TotalRentDeductionsAmt00
IRS990TScheduleA/TotalRentDeductionsAmt10
IRS990TScheduleA/TotalRentIncomeAmt00
IRS990TScheduleA/TotalRentIncomeAmt10
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt00
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt10
IRS990TScheduleA/TotExcessReadershipCostsDedAmt00
IRS990TScheduleA/TotExcessReadershipCostsDedAmt10
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt01363535
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt1180878
IRS990TScheduleA/TotUnrltTrdBusIncmAmt01363535
IRS990TScheduleA/TotUnrltTrdBusIncmAmt1180878
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt00
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt10
IRS990TScheduleA/TradeOrBusinessDesc0PARTNERSHIP ACTIVITY
IRS990TScheduleA/TradeOrBusinessDesc1GOLF CLUB OPERATIONS
IRS990TScheduleA/UBIBeforeNOLDedAmt01363535
IRS990TScheduleA/UBIBeforeNOLDedAmt1180878
IRS990TScheduleA/UnrelatedBusinessTaxblIncmAmt01363535
IRS990TScheduleA/UnrelatedBusinessTaxblIncmAmt136176
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AllocableDeductionAmt00
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AllocableDeductionAmt10
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAcquisitionAdjBasisPct00.00000
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAcquisitionAdjBasisPct10.00000
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAcquisitionDebtAmt00
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAcquisitionDebtAmt10
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAdjustedBasisAmt00
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAdjustedBasisAmt10
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/GrossIncomeAmt00
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/GrossIncomeAmt10
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/GrossIncomeReportableAmt00
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/GrossIncomeReportableAmt10
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/OtherDebtFinancedDeductionAmt00
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/OtherDebtFinancedDeductionAmt10
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/PropertyDesc0PROPERTY MANAGEMENT -
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/PropertyDesc1GOLF COURSE -4148 NOR
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/StraightLineDepreciationDedAmt00
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/StraightLineDepreciationDedAmt10
IRS990T/SpecificDeductionAmt01000
IRS990T/SubsidiaryCorporationInd00
IRS990T/TaxableCorporationAmt0293729
IRS990T/TaxLessCreditsAmt0293729
IRS990T/TotalDeductionAmt01000
IRS990T/TotalPaymentsAmt0951027
IRS990T/TotalTaxAmt0293729
IRS990T/TotalTaxComputationAmt0293729
IRS990T/TotalUBTIAmt01398711
IRS990T/TotalUBTIBeforeNOLSpecificAmt01399711
IRS990T/TotalUBTIBeforeSection199AAmt01399711
IRS990T/TotalUBTIComputedAmt01399711
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd00
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0DARBY SHUPP
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum06023648000
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-06-30
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0JOHN SPERLING FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0JOHN
ReturnHeader/Filer/EIN0320284165
ReturnHeader/Filer/PhoneNum06023648000
ReturnHeader/Filer/USAddress/AddressLine1Txt05115 N DYSART ROAD SUITE 202 305
ReturnHeader/Filer/USAddress/CityNm0LITCHFIELD PARK
ReturnHeader/Filer/USAddress/StateAbbreviationCd0AZ
ReturnHeader/Filer/USAddress/ZIPCd085340
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0134008324
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0PRICEWATERHOUSECOOPERS LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01850 N CENTRAL AVE STE 700
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0PHOENIX
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0AZ
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0850044563
ReturnHeader/PreparerPersonGrp/PhoneNum06023648000
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0CHAD THURSTON
ReturnHeader/ReturnTs02023-06-30T14:41:20-05:00
ReturnHeader/ReturnTypeCd0990T
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0DARBY
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0SHUPP
ReturnHeader/TaxPeriodBeginDt02021-09-01
ReturnHeader/TaxPeriodEndDt02022-08-31
ReturnHeader/TaxYr02021

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2022 • Form 990TFacts available. Structured filing facts are available, but richer extracted sections are limited.

Open filing
Assets
-
Liabilities
-
Net assets
-
Revenue
-
Expenses
-
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$80.2$0.00$80.2$2.72$5.18$2.46
2023Detailed filing. Detailed filing data is available for this year.$73.6$0.00$73.6$0.77$5.42$4.64
2022Detailed filing. Detailed filing data is available for this year.$63.4$0.00$63.4$3.07$4.36$1.29
2022Facts available. Structured filing facts are available, but richer extracted sections are limited.
2021Detailed filing. Detailed filing data is available for this year.$77.3$0.00$77.3$3.08$3.60$0.52
2020Detailed filing. Detailed filing data is available for this year.$67.9$0.00$67.9$4.08$3.33$0.76
2017Detailed filing. Detailed filing data is available for this year.$2.26$0.00$2.26$0.85$0.18$0.67
2016Detailed filing. Detailed filing data is available for this year.$1.59$0.00$1.59$0.85$0.07$0.78