Civic Intelligence

Alexander S Hewitt Charitable Foundation

990PF • Fiscal year 2012 • EIN 20-2278991

Jan 01, 2012 to Dec 31, 2012 • Filed on Jul 25, 2013

Organization Profile
201 South Phillips Avenuesuite 20057104
Siviq Scores

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

Liabilities / Assets

58th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2012 filings • <$500k nonprofits • Source year 2012

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2012

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2012

Top Officer Pay

82nd percentile

$0

Higher top officer pay than 82% of similar nonprofits.

2012 filings • <$500k nonprofits • Source year 2012

Asset Growth

6th percentile

-56%

Faster asset growth than 6% of similar nonprofits.

2012 filings • <$500k nonprofits • Annualized from 2011 to 2012

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / Assets58th percentile

Assets

Down

$1,045

Down $1,327 (-56%) from 2011

Net Assets

$1,045

No earlier filing loaded for comparison.

Liabilities

Down

$0

Down $1 (-100%) from 2011

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

Up

$1,327

Up $123 (+10%) from 2011

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth6th percentile

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

$3.0K$2.0K$1.0K$0Assets 2010: $1Liabilities 2010: $0Net Assets 2010: $12010Assets 2011: $2,372Liabilities 2011: $12011Assets 2012: $1,045Liabilities 2012: $0Net Assets 2012: $1,0452012Assets 2013: $0Liabilities 2013: $0Net Assets 2013: $02013Assets 2014: $0Liabilities 2014: $0Net Assets 2014: $02014Assets 2015: $0Liabilities 2015: $0Net Assets 2015: $02015Assets 2016: $0Liabilities 2016: $0Net Assets 2016: $02016Assets 2017: $0Liabilities 2017: $0Net Assets 2017: $02017Assets 2018: $0Liabilities 2018: $0Net Assets 2018: $02018Assets 2019: $0Liabilities 2019: $0Net Assets 2019: $02019Assets 2020: $0Liabilities 2020: $0Net Assets 2020: $02020Assets 2021: $0Liabilities 2021: $0Net Assets 2021: $02021Assets 2022: $0Liabilities 2022: $0Net Assets 2022: $02022Assets 2023: $0Liabilities 2023: $0Net Assets 2023: $02023Assets 2024: $0Liabilities 2024: $0Net Assets 2024: $02024

Highlighted filing

2012

Assets$1,045
Liabilities$0
Net Assets$1,045
Open 2012 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$4.0K$2.0K$0-$2.0KExpenses 2010: $3012010Revenue 2011: $3,575Expenses 2011: $1,204Net Income 2011: $2,3712011Expenses 2012: $1,3272012Revenue 2013: $0Expenses 2013: $1,045Net Income 2013: -$1,0452013Revenue 2014: $0Expenses 2014: $0Net Income 2014: $02014Revenue 2015: $0Expenses 2015: $0Net Income 2015: $02015Revenue 2016: $0Expenses 2016: $0Net Income 2016: $02016Revenue 2017: $0Expenses 2017: $0Net Income 2017: $02017Revenue 2018: $0Expenses 2018: $0Net Income 2018: $02018Revenue 2019: $0Expenses 2019: $0Net Income 2019: $02019Revenue 2020: $0Expenses 2020: $0Net Income 2020: $02020Revenue 2021: $0Expenses 2021: $0Net Income 2021: $02021Revenue 2022: $0Expenses 2022: $0Net Income 2022: $02022Revenue 2023: $0Expenses 2023: $0Net Income 2023: $02023Revenue 2024: $0Expenses 2024: $0Net Income 2024: $02024

Highlighted filing

2012

Revenue-
Expenses$1,327
Net Income-
Open 2012 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2012 to Dec 31, 2012
Signed
Jul 25, 2013
Return Version
2012v2.0
Compensation and Service Providers
Top Officer Pay82nd percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
SOUTH DAKOTA TRUST COMPANYTrustee-$0--
Filing and Contact Details

Filer

EIN
20-2278991
Raw XML Appendix193 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
AccountingFeesSchedule/AccountingFees/AdjustedNetIncome00
AccountingFeesSchedule/AccountingFees/AdjustedNetIncome10
AccountingFeesSchedule/AccountingFees/Amount01250
AccountingFeesSchedule/AccountingFees/Amount177
AccountingFeesSchedule/AccountingFees/Category0TAX PREPARATION FEES
AccountingFeesSchedule/AccountingFees/Category1PROFESSIONAL FEES
AccountingFeesSchedule/AccountingFees/DisbursementsCharitablePrps00
AccountingFeesSchedule/AccountingFees/DisbursementsCharitablePrps10
AccountingFeesSchedule/AccountingFees/NetInvestmentIncome00
AccountingFeesSchedule/AccountingFees/NetInvestmentIncome10
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnss01327
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidRevAndExpnss00
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessOfRevenueOverExpenses0-1327
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncome00
IRS990PF/AnalysisOfRevenueAndExpenses/NotRequiredToAttachScheduleB0X
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncm00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnss01327
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvestmentIncome00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevenueAndExpenses00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncm00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnss01327
IRS990PF/BalanceSheets/OrgThatDoNotFollowSFAS1170X
IRS990PF/BalanceSheets/RetainedEarningsBOY02372
IRS990PF/BalanceSheets/RetainedEarningsEOY01045
IRS990PF/BalanceSheets/SavingsAndTempCashInvstBOY02372
IRS990PF/BalanceSheets/SavingsAndTempCashInvstEOY01045
IRS990PF/BalanceSheets/TotalAssetsBOY02372
IRS990PF/BalanceSheets/TotalAssetsEOY01045
IRS990PF/BalanceSheets/TotalAssetsEOYFMV01045
IRS990PF/BalanceSheets/TotalLiabilitiesEOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsBOY02372
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsEOY01045
IRS990PF/BalanceSheets/TotalNetAssetsBOY02372
IRS990PF/BalanceSheets/TotalNetAssetsEOY01045
IRS990PF/ChangesInNetAssetsFundBalances/ExcessOfRevenueOverExpenses0-1327
IRS990PF/ChangesInNetAssetsFundBalances/Subtotal01045
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesBOY02372
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesEOY01045
IRS990PF/DistributableAmount/DistributableAmountAsAdjusted0102
IRS990PF/DistributableAmount/DistributableAmountBeforeAdj0102
IRS990PF/DistributableAmount/DistributableAmountBeforeDed0102
IRS990PF/DistributableAmount/MinimumInvestmentReturn0102
IRS990PF/ExciseTaxBasedOnInvestmentIncm/InvestmentIncomeExciseTax00
IRS990PF/ExemptPF0X
IRS990PF/FMVAssetsEOY01045
IRS990PF/MethodOfAccountingCash0X
IRS990PF/MinimumInvestmentReturn/AdjTotalFMVOfUnusedAssets02065
IRS990PF/MinimumInvestmentReturn/AvgMonthlyCashBalances00
IRS990PF/MinimumInvestmentReturn/AvgMonthlyFMVOfSecurities02065
IRS990PF/MinimumInvestmentReturn/CashDeemedCharitable031
IRS990PF/MinimumInvestmentReturn/FMVAllOtherNoncharitableAssets00
IRS990PF/MinimumInvestmentReturn/MinimumInvestmentReturn0102
IRS990PF/MinimumInvestmentReturn/NetNoncharitableAssets02034
IRS990PF/MinimumInvestmentReturn/ReductionClaimed00
IRS990PF/MinimumInvestmentReturn/TotalFMVOfUnusedAssets02065
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHghstPaidCntrctNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHighestPaidEmplNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition01.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName0SOUTH DAKOTA TRUST COMPANY
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title0Trustee
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine10201 S PHILLIPS AVE STE 200
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City0SIOUX FALLS
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State0SD
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode057104
IRS990PF/QlfyUndSect4940eForReducedTax/AdjNonchrtblAssetsAndOnePct045485
IRS990PF/QlfyUndSect4940eForReducedTax/AdjustedNoncharitableAssets045485
IRS990PF/QlfyUndSect4940eForReducedTax/AverageDistributionRatio022.36230
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear100.12376
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear2030.55556
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear3066.66667
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear407.58294
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear506.88259
IRS990PF/QlfyUndSect4940eForReducedTax/LiableFor4942Tax0false
IRS990PF/QlfyUndSect4940eForReducedTax/NetNoncharitableAssets02034
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear10404
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear209
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear309
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear40211
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear50247
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear1050
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear20275
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear30600
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear401600
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear501700
IRS990PF/QlfyUndSect4940eForReducedTax/TotalDistributionRatio0111.81151
IRS990PF/QualifyingDistributions/ExpensesAndContributions00
IRS990PF/StatementsRegardingActivities/ActivitiesNotPrevReported0false
IRS990PF/StatementsRegardingActivities/ApplicableInsuranceContract0false
IRS990PF/StatementsRegardingActivities/AtLeast5000InAssets0false
IRS990PF/StatementsRegardingActivities/BooksInCareOfBusinessName/BusinessNameLine10SOUTH DAKOTA TRUST COMPANY
IRS990PF/StatementsRegardingActivities/BooksInCareOfPhoneNumber06052715132
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine10201 S PHILLIPS AVE STE 200
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/City0SIOUX FALLS
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/State0SD
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/ZIPCode057104
IRS990PF/StatementsRegardingActivities/ChangesToArticlesOrBylaws0false
IRS990PF/StatementsRegardingActivities/ComplyWithPublicInspectionRqr0true
IRS990PF/StatementsRegardingActivities/ForeignBank0false
IRS990PF/StatementsRegardingActivities/Form1120POLFiled0false
IRS990PF/StatementsRegardingActivities/Form990PFFiledWithAG0false
IRS990PF/StatementsRegardingActivities/Form990TFiled0false
IRS990PF/StatementsRegardingActivities/InterestInControlledEntity0false
IRS990PF/StatementsRegardingActivities/LegislativePoliticalActivities0false
IRS990PF/StatementsRegardingActivities/MoreThan100Spent0false
IRS990PF/StatementsRegardingActivities/NewSubstantialContributors0false
IRS990PF/StatementsRegardingActivities/PrivateOperatingFoundation0false
IRS990PF/StatementsRegardingActivities/RequirementsOfSect508e0true
IRS990PF/StatementsRegardingActivities/StatesFiledWith0SD
IRS990PF/StatementsRegardingActivities/TerminationEtc0false
IRS990PF/StatementsRegardingActivities/UnrelatedBusIncomeOver10000false
IRS990PF/StatementsRegardingActivities/WebsiteAddress0N/A
IRS990PF/StatementsRegardingActy4720/ActsFailToQualifyAsExceptions0false
IRS990PF/StatementsRegardingActy4720/BorrowOrLendWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/BusinessHoldings0false
IRS990PF/StatementsRegardingActy4720/ExcessBusinessHoldings0false
IRS990PF/StatementsRegardingActy4720/FurnishedGoodsWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/GrantsToIndividuals0false
IRS990PF/StatementsRegardingActy4720/GrantsToOrganizations0false
IRS990PF/StatementsRegardingActy4720/InfluenceElection0false
IRS990PF/StatementsRegardingActy4720/InfluenceLegislation0false
IRS990PF/StatementsRegardingActy4720/JeopardyInvestments0false
IRS990PF/StatementsRegardingActy4720/MaintExpendResponsibility0false
IRS990PF/StatementsRegardingActy4720/NoncharitablePurpose0false
IRS990PF/StatementsRegardingActy4720/PayCompensationToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/PaymentToGovernmentOffical0false
IRS990PF/StatementsRegardingActy4720/PayPremiumsPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/ProceedsOrNetIncome0false
IRS990PF/StatementsRegardingActy4720/ProhibitedTaxShelterTransactn0false
IRS990PF/StatementsRegardingActy4720/RcvFundsToPayPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/SaleOrExchangeWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/TransferAssetsToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/TrFailToQualifyAsExceptions0false
IRS990PF/StatementsRegardingActy4720/UncorrectedJeopardyInvestments0false
IRS990PF/StatementsRegardingActy4720/UncorrectedPriorActs0false
IRS990PF/StatementsRegardingActy4720/UndistributedIncomePriorYears0false
IRS990PF/StatementsRegardingActy4720/UndistrIncome4942a2NotApplied0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/LoansOrLoanGuarantees0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PerformanceOfServicesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PurchaseAssetsNoncharitableEO0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/ReimbursementArrangements0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RelationshipsNoncharitableEOs0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RentalOfFacilitiesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SalesOrExchangesOfAssets0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SharingOfFacilitiesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOfCashToNoncharitableEO0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOthAssetsNoncharitableEO0false
IRS990PF/UndistributedIncome/DistributableAmountAsAdjusted0102
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear1030
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear20275
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear30590
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear401589
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear501688
IRS990PF/UndistributedIncome/ExcessDistriCyovAppCYCorpus0102
IRS990PF/UndistributedIncome/ExcessDistriCyovAppliedCY0102
IRS990PF/UndistributedIncome/ExcessDistriCyovFromYear501586
IRS990PF/UndistributedIncome/ExcessDistriCyovToNextYear02484
IRS990PF/UndistributedIncome/ExcessFromYear1030
IRS990PF/UndistributedIncome/ExcessFromYear20275
IRS990PF/UndistributedIncome/ExcessFromYear30590
IRS990PF/UndistributedIncome/ExcessFromYear401589
IRS990PF/UndistributedIncome/TotalCorpus04070
IRS990PF/UndistributedIncome/TotalExcessDistriCarryover04172
IRS990PF/UndistributedIncome/TreatedAsDistriFromCorpus00
IRS990PF/UndistributedIncome/UndistributedIncomeCY00
ReturnHeader/BuildTS02016-02-25 16:41:14Z
ReturnHeader/Filer/EIN0202278991
ReturnHeader/Filer/Name/BusinessNameLine10ALEXANDER S HEWITT CHARITABLE FOUNDATION
ReturnHeader/Filer/NameControl0ALEX
ReturnHeader/Filer/Phone06052715132
ReturnHeader/Filer/USAddress/AddressLine10201 SOUTH PHILLIPS AVENUESUITE 200
ReturnHeader/Filer/USAddress/City0SIOUX FALLS
ReturnHeader/Filer/USAddress/State0SD
ReturnHeader/Filer/USAddress/ZIPCode057104
ReturnHeader/Officer/AuthorizeThirdParty0true
ReturnHeader/Officer/DateSigned02013-07-25
ReturnHeader/Officer/Name0SOUTH DAKOTA TRUST COMPANY
ReturnHeader/Officer/Title0Trustee
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10ROCK RIVER FAMILY OFFICE
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine10102 South Harrison Suite 200
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0Davenport
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0IA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode052801
ReturnHeader/Preparer/Name0ADAM M KUNKEL
ReturnHeader/Preparer/Phone05638234400
ReturnHeader/ReturnType0990PF
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-07-25T07:30:00-07:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2012 • Form 990PFDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$1,045
Liabilities
$0
Net assets
$1,045
Revenue
-
Expenses
$1,327
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$0$0$0$0$0$0
2023Detailed filing. Detailed filing data is available for this year.$0$0$0$0$0$0
2022Detailed filing. Detailed filing data is available for this year.$0$0$0$0$0$0
2021Detailed filing. Detailed filing data is available for this year.$0$0$0$0$0$0
2020Detailed filing. Detailed filing data is available for this year.$0$0$0$0$0$0
2019Detailed filing. Detailed filing data is available for this year.$0$0$0$0$0$0
2018Detailed filing. Detailed filing data is available for this year.$0$0$0$0$0$0
2017Detailed filing. Detailed filing data is available for this year.$0$0$0$0$0$0
2016Detailed filing. Detailed filing data is available for this year.$0$0$0$0$0$0
2015Detailed filing. Detailed filing data is available for this year.$0$0$0$0$0$0
2014Detailed filing. Detailed filing data is available for this year.$0$0$0$0$0$0
2013Detailed filing. Detailed filing data is available for this year.$0$0$0$0$1,045$1,045
2012Detailed filing. Detailed filing data is available for this year.$1,045$0$1,045$1,327
2011Summary only. Only limited summary data is available for this year.$2,372$1$3,575$1,204$2,371
2010Detailed filing. Detailed filing data is available for this year.$1$0$1$301