Civic Intelligence

Sehgal Foundation

990T • Fiscal year 2020 • EIN 42-1477858

Jan 01, 2020 to Dec 31, 2020 • Filed on Nov 03, 2021

Organization Profile
100 Court Ave Ste 211Des Moines, IA 50309-2213

(515) 288-0010

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.

$60M$40M$20M$0Assets 2011: $40,900,398Liabilities 2011: $7,6432011Assets 2012: $41,227,883Liabilities 2012: $5,0122012Assets 2013: $41,588,086Liabilities 2013: $7,8052013Assets 2014: $41,440,800Liabilities 2014: $5,7172014Assets 2015: $41,406,363Liabilities 2015: $2,8962015Assets 2019: $52,621,275Liabilities 2019: $14,9242019Assets 2020: $53,398,617Liabilities 2020: $11,721Net Assets 2020: $53,386,8962020Assets 2021: $54,060,488Liabilities 2021: $16,404Net Assets 2021: $54,044,0842021Assets 2022: $53,695,394Liabilities 2022: $12,804Net Assets 2022: $53,682,5902022Assets 2023: $53,087,961Liabilities 2023: $5,466Net Assets 2023: $53,082,4952023Assets 2024: $57,143,448Liabilities 2024: $1,583Net Assets 2024: $57,141,8652024

Latest loaded filing

2024

Assets$57,143,448
Liabilities$1,583
Net Assets$57,141,865
Open 2024 Filing

Operations Trend

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

$20M$15M$10M$5.0M$0-$5.0MRevenue 2011: $3,270,234Expenses 2011: $4,321,410Net Income 2011: -$1,051,1762011Revenue 2012: $4,242,709Expenses 2012: $3,913,520Net Income 2012: $329,1892012Revenue 2013: $4,196,756Expenses 2013: $3,839,558Net Income 2013: $357,1982013Revenue 2014: $3,633,694Expenses 2014: $3,855,154Net Income 2014: -$221,4602014Revenue 2015: $5,191,544Expenses 2015: $3,595,839Net Income 2015: $1,595,7052015Revenue 2019: $18,257,438Expenses 2019: $4,495,858Net Income 2019: $13,761,5802019Revenue 2020: $3,620,280Expenses 2020: $2,853,203Net Income 2020: $767,0772020Revenue 2021: $3,887,909Expenses 2021: $3,213,515Net Income 2021: $674,3942021Revenue 2022: $1,526,776Expenses 2022: $1,905,640Net Income 2022: -$378,8642022Revenue 2023: $3,094,839Expenses 2023: $3,670,706Net Income 2023: -$575,8672023Revenue 2024: $8,089,183Expenses 2024: $4,017,154Net Income 2024: $4,072,0292024

Latest loaded filing

2024

Revenue$8,089,183
Expenses$4,017,154
Net Income$4,072,029
Open 2024 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2020 to Dec 31, 2020
Signed
Nov 3, 2021
Return Version
2020v1.1
Filing and Contact Details

Filer

Filer Name
Sehgal Foundation
EIN
42-1477858
Phone
5152880010
Address
100 COURT AVE STE 211, DES MOINES, IA 50309-2213

Signing Officer

Name
Jay Sehgal
Title
Executive Vice President
Phone
5152880010
Signed
2021-11-03
Discuss with paid preparer
Yes

Preparer

Firm
Rsm US Llp
Address
400 LOCUST STREET SUITE 640, DES MOINES, IA 50309-2354
Preparer
Kathy Fairchild
Phone
5152848660
Raw XML Appendix82 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/PersonNm0JANET M GAGE
IRS990T/BooksInCareOfDetail/PhoneNum05152880010
IRS990T/BooksInCareOfDetail/USAddress/AddressLine1Txt0100 COURT AVENUE SUITE 211
IRS990T/BooksInCareOfDetail/USAddress/CityNm0DES MOINES
IRS990T/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IA
IRS990T/BooksInCareOfDetail/USAddress/ZIPCd050309
IRS990T/BookValueAssetsEOYAmt053398617
IRS990T/ChangeInMethodOfAccountingInd00
IRS990T/CharitableContributionsDedAmt00
IRS990T/ForeignAccountsQuestionInd00
IRS990T/ForeignTrustQuestionInd01
IRS990T/Form990TScheduleAAttachedCnt01
IRS990T/NetOperatingLossDeductionAmt00
IRS990T/Organization501cCorporationInd0X
IRS990T/Organization501IndicatorGrp/Organization501cTypeTxt0c3
IRS990T/Organization501IndicatorGrp/Organization501Ind0X
IRS990T/PaidTaxLiabilityAmt00
IRS990TScheduleA/NetOperatingLossDeductionAmt00
IRS990TScheduleA/PrincipalBusinessActivityCd0523000
IRS990TScheduleA/SequenceReferenceNum01
IRS990TScheduleA/SequenceTotalNum01
IRS990TScheduleA/TotalAllocableDeductionsAmt00
IRS990TScheduleA/TotalCtrlOrgDeductionAmt00
IRS990TScheduleA/TotalCtrlOrgPymtGrossIncmAmt00
IRS990TScheduleA/TotalDeductionsAmt00
IRS990TScheduleA/TotalDeductionSetAsidesAmt00
IRS990TScheduleA/TotalDirectAdvertisingCostAmt00
IRS990TScheduleA/TotalDividendsReceivedDedAmt00
IRS990TScheduleA/TotalGrossAdvertisingIncomeAmt00
IRS990TScheduleA/TotalGrossDebtFinancedIncmAmt00
IRS990TScheduleA/TotalInvestmentIncomeAmt00
IRS990TScheduleA/TotalRentDeductionsAmt00
IRS990TScheduleA/TotalRentIncomeAmt00
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt00
IRS990TScheduleA/TotExcessReadershipCostsDedAmt00
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt00
IRS990TScheduleA/TotUnrltTrdBusIncmAmt00
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt00
IRS990TScheduleA/TradeOrBusinessDesc0INCOME FROM PASSTHROUGHS
IRS990TScheduleA/UBIBeforeNOLDedAmt00
IRS990T/SpecificDeductionAmt01000
IRS990T/SubsidiaryCorporationInd00
IRS990T/TaxableCorporationAmt00
IRS990T/TaxLessCreditsAmt00
IRS990T/TotalDeductionAmt01000
IRS990T/TotalTaxAmt00
IRS990T/TotalTaxComputationAmt00
IRS990T/TotalUBTIAmt00
IRS990T/TotalUBTIComputedAmt00
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd00
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0JAY SEHGAL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0EXECUTIVE VICE PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum05152880010
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-11-03
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0SEHGAL FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0SEHG
ReturnHeader/Filer/EIN0421477858
ReturnHeader/Filer/PhoneNum05152880010
ReturnHeader/Filer/USAddress/AddressLine1Txt0100 COURT AVE STE 211
ReturnHeader/Filer/USAddress/CityNm0DES MOINES
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IA
ReturnHeader/Filer/USAddress/ZIPCd0503092213
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0420714325
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0RSM US LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0400 LOCUST STREET SUITE 640
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0DES MOINES
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0503092354
ReturnHeader/PreparerPersonGrp/PhoneNum05152848660
ReturnHeader/PreparerPersonGrp/PreparationDt02021-11-01
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0KATHY FAIRCHILD
ReturnHeader/ReturnTs02021-11-05T10:24:41-05:00
ReturnHeader/ReturnTypeCd0990T
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0JAY
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0SEHGAL
ReturnHeader/TaxPeriodBeginDt02020-01-01
ReturnHeader/TaxPeriodEndDt02020-12-31
ReturnHeader/TaxYr02020

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2020 • 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.$57.1$0.00$57.1$8.09$4.02$4.07
2023Detailed filing. Detailed filing data is available for this year.$53.1$0.01$53.1$3.09$3.67$0.58
2022Detailed filing. Detailed filing data is available for this year.$53.7$0.01$53.7$1.53$1.91$0.38
2021Detailed filing. Detailed filing data is available for this year.$54.1$0.02$54.0$3.89$3.21$0.67
2020Detailed filing. Detailed filing data is available for this year.$53.4$0.01$53.4$3.62$2.85$0.77
2020Facts available. Structured filing facts are available, but richer extracted sections are limited.
2019Summary only. Only limited summary data is available for this year.$52.6$0.01$18.3$4.50$13.8
2015Summary only. Only limited summary data is available for this year.$41.4$0.00$5.19$3.60$1.60
2014Summary only. Only limited summary data is available for this year.$41.4$0.01$3.63$3.86$0.22
2013Summary only. Only limited summary data is available for this year.$41.6$0.01$4.20$3.84$0.36
2012Summary only. Only limited summary data is available for this year.$41.2$0.01$4.24$3.91$0.33
2011Summary only. Only limited summary data is available for this year.$40.9$0.01$3.27$4.32$1.05