Civic Intelligence

Robert E and Patricia a Schmidt Foundation

990T • Fiscal year 2022 • EIN 48-1077463

Dec 01, 2021 to Nov 30, 2022 • Filed on Apr 13, 2023

1011 W 27th St F-2 F-2Hays, KS 67601

(785) 625-1772

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 2022

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2022

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2022

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2022

Asset Growth

Score unavailable

No value available

No valid filing value is available for this score.

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Assets

-

No earlier filing loaded for comparison.

Net Assets

-

No earlier filing loaded for comparison.

Liabilities

-

No earlier filing loaded for comparison.

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.

$80M$60M$40M$20M$0Assets 2011: $7,313,601Liabilities 2011: $02011Assets 2012: $9,902,864Liabilities 2012: $0Net Assets 2012: $9,902,8642012Assets 2013: $10,052,882Liabilities 2013: $02013Assets 2014: $12,593,174Liabilities 2014: $02014Assets 2015: $12,926,483Liabilities 2015: $02015Assets 2017: $18,834,186Liabilities 2017: $0Net Assets 2017: $18,834,1862017Assets 2018: $33,543,565Liabilities 2018: $0Net Assets 2018: $33,543,5652018Assets 2019: $39,981,349Liabilities 2019: $1Net Assets 2019: $39,981,3492019Assets 2020: $63,510,811Liabilities 2020: $1Net Assets 2020: $63,510,8112020Assets 2021: $62,642,391Liabilities 2021: $1Net Assets 2021: $62,642,3912021Assets 2022: $62,190,844Liabilities 2022: $1Net Assets 2022: $62,190,8442022Assets 2023: $61,657,273Liabilities 2023: $1Net Assets 2023: $61,657,2732023Assets 2024: $64,178,631Liabilities 2024: $25,000Net Assets 2024: $64,153,6312024

Latest loaded filing

2024

Assets$64,178,631
Liabilities$25,000
Net Assets$64,153,631

Operations Trend

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

$30M$20M$10M$0-$10MRevenue 2011: $367,689Expenses 2011: $416,046Net Income 2011: -$48,3572011Expenses 2012: $425,9272012Revenue 2013: $557,359Expenses 2013: $485,479Net Income 2013: $71,8802013Revenue 2014: $3,205,975Expenses 2014: $582,370Net Income 2014: $2,623,6052014Revenue 2015: $964,086Expenses 2015: $630,775Net Income 2015: $333,3112015Revenue 2017: $6,513,251Expenses 2017: $610,800Net Income 2017: $5,902,4512017Revenue 2018: $15,698,759Expenses 2018: $989,380Net Income 2018: $14,709,3792018Revenue 2019: $8,296,212Expenses 2019: $1,858,428Net Income 2019: $6,437,7842019Revenue 2020: $26,330,056Expenses 2020: $2,800,594Net Income 2020: $23,529,4622020Revenue 2021: $3,187,235Expenses 2021: $4,087,655Net Income 2021: -$900,4202021Revenue 2022: $4,179,897Expenses 2022: $4,577,328Net Income 2022: -$397,4312022Revenue 2023: $4,318,117Expenses 2023: $4,684,524Net Income 2023: -$366,4072023Revenue 2024: $7,121,017Expenses 2024: $4,500,345Net Income 2024: $2,620,6722024

Latest loaded filing

2024

Revenue$7,121,017
Expenses$4,500,345
Net Income$2,620,672
Jump To
Filing Snapshot
Filing Period
Dec 1, 2021 to Nov 30, 2022
Signed
Apr 13, 2023
Return Version
2021v4.3
Filing and Contact Details

Filer

Filer Name
Robert E and Patricia Schmidt Foundatio
EIN
48-1077463
Phone
7856251772
Address
1011 W 27TH ST F-2 F-2, HAYS, KS 67601

Signing Officer

Name
Gary Shorman
Title
Trustee/president
Phone
7856251772
Signed
2023-04-13
Discuss with paid preparer
Yes

Preparer

Firm
Adamsbrown LLC
Address
PO BOX 1186, HAYS, KS 67601
Preparer
David a Herl
Phone
7856283046
Raw XML Appendix109 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
IRS1120ScheduleD/CapitalGainNetIncomeAmt028578
IRS1120ScheduleD/Form4797GainOrLossAmt028578
IRS1120ScheduleD/NetCapitalGainAmt028578
IRS1120ScheduleD/NetLTCapitalGainOrLossAmt028578
IRS990T/AvlblPre2018NOLCarryoverAmt013413
IRS990T/BalanceDueAmt046854
IRS990T/BooksInCareOfDetail/PersonNm0ANN GASCHLER
IRS990T/BooksInCareOfDetail/PhoneNum07856251772
IRS990T/BooksInCareOfDetail/USAddress/AddressLine1Txt01011 W 27TH ST F-3
IRS990T/BooksInCareOfDetail/USAddress/CityNm0HAYS
IRS990T/BooksInCareOfDetail/USAddress/StateAbbreviationCd0KS
IRS990T/BooksInCareOfDetail/USAddress/ZIPCd067601
IRS990T/BookValueAssetsEOYAmt062190844
IRS990T/ChangeInMethodOfAccountingInd00
IRS990T/CharitableContributionsDedAmt0514
IRS990T/ESPenaltyAmt01999
IRS990T/ForeignAccountsQuestionInd00
IRS990T/ForeignTrustQuestionInd00
IRS990T/Form990TScheduleAAttachedCnt01
IRS990T/NetOperatingLossDeductionAmt013413
IRS990T/Organization501cCorporationInd0X
IRS990T/Organization501IndicatorGrp/Organization501cTypeTxt0c3
IRS990T/Organization501IndicatorGrp/Organization501Ind0X
IRS990T/PaidTaxLiabilityAmt00
IRS990T/Post2017NOLCarryoverGrp/AvlblPost2017NOLCarryoverAmt0136056
IRS990T/Post2017NOLCarryoverGrp/PrincipalBusinessActivityCd0901101
IRS990TScheduleA/AdditionalSection263ACostsAmt00
IRS990TScheduleA/BeginningOfYearInventoryAmt00
IRS990TScheduleA/CostOfGoodsSoldAmt0518037
IRS990TScheduleA/CostOfLaborAmt00
IRS990TScheduleA/DepletionAmt0337141
IRS990TScheduleA/EndOfYearInventoryAmt00
IRS990TScheduleA/GrossProfitAmt0621603
IRS990TScheduleA/GrossReceiptsOrSalesAmt01139640
IRS990TScheduleA/NetGrossReceiptsOrSalesAmt01139640
IRS990TScheduleA/NetOperatingLossDeductionAmt0136056
IRS990TScheduleA/OtherCostsAmt00
IRS990TScheduleA/OtherIncomeAmt0108677
IRS990TScheduleA/PrincipalBusinessActivityCd0901101
IRS990TScheduleA/PurchasesAmt0518037
IRS990TScheduleA/SalariesAndWagesAmt028560
IRS990TScheduleA/Section263ARulesApplyInd00
IRS990TScheduleA/SequenceReferenceNum01
IRS990TScheduleA/SequenceTotalNum01
IRS990TScheduleA/TotalAllocableDeductionsAmt00
IRS990TScheduleA/TotalCostGoodsSoldAmt0518037
IRS990TScheduleA/TotalCtrlOrgDeductionAmt00
IRS990TScheduleA/TotalCtrlOrgPymtGrossIncmAmt00
IRS990TScheduleA/TotalDeductionsAmt0365701
IRS990TScheduleA/TotalDeductionSetAsidesAmt00
IRS990TScheduleA/TotalDirectAdvertisingCostAmt00
IRS990TScheduleA/TotalDividendsReceivedDedAmt00
IRS990TScheduleA/TotalGrossAdvertisingIncomeAmt00
IRS990TScheduleA/TotalGrossDebtFinancedIncmAmt00
IRS990TScheduleA/TotalInvestmentIncomeAmt00
IRS990TScheduleA/TotalRentDeductionsAmt00
IRS990TScheduleA/TotalRentIncomeAmt00
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt00
IRS990TScheduleA/TotExcessReadershipCostsDedAmt00
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt0730280
IRS990TScheduleA/TotUnrltTrdBusIncmAmt0730280
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt00
IRS990TScheduleA/TradeOrBusinessDesc0INVESTMENTS IN VARIOUS LOCAL ENTITIES
IRS990TScheduleA/UBIBeforeNOLDedAmt0364579
IRS990TScheduleA/UnrelatedBusinessTaxblIncmAmt0228523
IRS990T/SpecificDeductionAmt01000
IRS990T/SubsidiaryCorporationInd00
IRS990T/TaxableCorporationAmt044855
IRS990T/TaxLessCreditsAmt044855
IRS990T/TotalDeductionAmt01000
IRS990T/TotalTaxAmt044855
IRS990T/TotalTaxComputationAmt044855
IRS990T/TotalUBTIAmt0213596
IRS990T/TotalUBTIBeforeNOLSpecificAmt0228009
IRS990T/TotalUBTIBeforeSection199AAmt0214596
IRS990T/TotalUBTIComputedAmt0228523
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd00
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0GARY SHORMAN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE/PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum07856251772
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-04-13
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ROBERT E AND PATRICIA SCHMIDT FOUNDATIO
ReturnHeader/Filer/BusinessNameControlTxt0ROBE
ReturnHeader/Filer/EIN0481077463
ReturnHeader/Filer/PhoneNum07856251772
ReturnHeader/Filer/USAddress/AddressLine1Txt01011 W 27TH ST F-2 F-2
ReturnHeader/Filer/USAddress/CityNm0HAYS
ReturnHeader/Filer/USAddress/StateAbbreviationCd0KS
ReturnHeader/Filer/USAddress/ZIPCd067601
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0843541096
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0ADAMSBROWN LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0PO BOX 1186
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0HAYS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0KS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd067601
ReturnHeader/PreparerPersonGrp/PhoneNum07856283046
ReturnHeader/PreparerPersonGrp/PreparationDt02023-03-28
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0DAVID A HERL
ReturnHeader/ReturnTs02023-04-15T12:31:45-05:00
ReturnHeader/ReturnTypeCd0990T
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0GARY
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0SHORMAN
ReturnHeader/TaxPeriodBeginDt02021-12-01
ReturnHeader/TaxPeriodEndDt02022-11-30
ReturnHeader/TaxYr02021

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$64.2$0.03$64.2$7.12$4.50$2.62
2023Detailed filing. Detailed filing data is available for this year.$61.7$0.00$61.7$4.32$4.68$0.37
2022Detailed filing. Detailed filing data is available for this year.$62.2$0.00$62.2$4.18$4.58$0.40
2022Facts available. Structured filing facts are available, but richer extracted sections are limited.
2021Detailed filing. Detailed filing data is available for this year.$62.6$0.00$62.6$3.19$4.09$0.90
2020Detailed filing. Detailed filing data is available for this year.$63.5$0.00$63.5$26.3$2.80$23.5
2019Detailed filing. Detailed filing data is available for this year.$40.0$0.00$40.0$8.30$1.86$6.44
2018Detailed filing. Detailed filing data is available for this year.$33.5$0.00$33.5$15.7$0.99$14.7
2017Detailed filing. Detailed filing data is available for this year.$18.8$0.00$18.8$6.51$0.61$5.90
2015Summary only. Only limited summary data is available for this year.$12.9$0.00$0.96$0.63$0.33
2014Summary only. Only limited summary data is available for this year.$12.6$0.00$3.21$0.58$2.62
2013Summary only. Only limited summary data is available for this year.$10.1$0.00$0.56$0.49$0.07
2012Detailed filing. Detailed filing data is available for this year.$9.90$0.00$9.90$0.43
2011Summary only. Only limited summary data is available for this year.$7.31$0.00$0.37$0.42$0.05