Civic Intelligence

Elizabeth a Sproul Charitable Trust

EIN 20-7222190

1310 Prairieview Avenue50261
Siviq Scores

Precomputed percentiles relative to similar nonprofits. These scores are descriptive rather than judgmental.

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on the latest valid filing.

Source year 2011

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on the latest valid filing.

Source year 2011

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on the latest valid filing.

Source year 2011

Top Officer Pay

81st percentile

$0

Higher top officer pay than 81% of similar nonprofits.

<$500k nonprofits • Source year 2011

Asset Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2011

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

$0

No earlier filing loaded for comparison.

Liabilities

$0

No earlier filing loaded for comparison.

Net Assets

$0

No earlier filing loaded for comparison.

Operations
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

$136,603

No earlier filing loaded for comparison.

Net Income

-

No earlier filing loaded for comparison.

Trend Graphs

Balance Sheet Trend

Asset GrowthScore unavailable

Grouped bars show assets, liabilities, and net assets across loaded filings.

$0Assets 2011: $0Liabilities 2011: $0Net Assets 2011: $02011

Highlighted filing

2011

Assets$0
Liabilities$0
Net Assets$0
Open 2011 Filing

Operations Trend

Revenue GrowthScore unavailable

Revenue, expenses, and net income by year, with the latest filing highlighted.

$150K$100K$50K$0Expenses 2011: $136,6032011

Highlighted filing

2011

Revenue-
Expenses$136,603
Net Income-
Open 2011 Filing

Filings

Most recent year

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

Open filing
Assets
$0
Liabilities
$0
Net assets
$0
Revenue
-
Expenses
$136,603
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2011Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$1.37
Latest Filing Detail
Jump To
Filing Snapshot
Filing Period
Jan 1, 2011 to Dec 31, 2011
Signed
May 9, 2012
Return Version
2011v1.2
Compensation and Service Providers
Top Officer Pay81st percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
JOHN B CASHMANTrustee-$0--
Grants and Assistance

Foundation Grants and Related Investments

TypeRecipientPurposeStatusLocationAmount
Paid Grant-COLLEGE OF EDUCATIONTAX EXEMPDES MOINES, IA, US$132,130
Filing and Contact Details

Filer

EIN
20-7222190
Raw XML Appendix217 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/Amount01800
AccountingFeesSchedule/AccountingFees/Amount11800
AccountingFeesSchedule/AccountingFees/Category0TAX RETURN-2010
AccountingFeesSchedule/AccountingFees/Category1FINAL TAX RETURN - 2011
AccountingFeesSchedule/AccountingFees/DisbursementsCharitablePrps00
AccountingFeesSchedule/AccountingFees/DisbursementsCharitablePrps10
AccountingFeesSchedule/AccountingFees/NetInvestmentIncome00
AccountingFeesSchedule/AccountingFees/NetInvestmentIncome10
IRS990PF/AnalysisIncomeProducingActy/DividendsAndIntFromSecPartVII/RelatedOrExemptFunctionIncome01128
IRS990PF/AnalysisIncomeProducingActy/OtherInvestmentIncomePartVII/RelatedOrExemptFunctionIncome080
IRS990PF/AnalysisIncomeProducingActy/SubtotalsPartXVIA/RelatedOrExemptFunctionIncome01208
IRS990PF/AnalysisIncomeProducingActy/TotalPartXVIA01208
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnss03600
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncome01128
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidDsbrsChrtblPrps0132130
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidRevAndExpnss0132130
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsAdjNetIncm01128
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncm01128
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnss01128
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessOfRevenueOverExpenses0-135395
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesRevAndExpnss085
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncome01128
IRS990PF/AnalysisOfRevenueAndExpenses/NotRequiredToAttachScheduleB0X
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnss080
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnss0737
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnss051
IRS990PF/AnalysisOfRevenueAndExpenses/TotalAdjustedNetIncome01128
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblPrps0132130
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncm00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnss0136603
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvestmentIncome01128
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevenueAndExpenses01208
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncm00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnss04473
IRS990PF/BalanceSheets/OrgThatFollowSFAS1170X
IRS990PF/BalanceSheets/SavingsAndTempCashInvstBOY0134539
IRS990PF/BalanceSheets/TotalAssetsBOY0134539
IRS990PF/BalanceSheets/TotalAssetsEOY00
IRS990PF/BalanceSheets/TotalAssetsEOYFMV00
IRS990PF/BalanceSheets/TotalLiabilitiesEOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsBOY0134539
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsEOY00
IRS990PF/BalanceSheets/TotalNetAssetsBOY0134539
IRS990PF/BalanceSheets/TotalNetAssetsEOY00
IRS990PF/BalanceSheets/UnrestrictedBOY0134539
IRS990PF/ChangesInNetAssetsFundBalances/ExcessOfRevenueOverExpenses0-135395
IRS990PF/ChangesInNetAssetsFundBalances/OtherIncreases0856
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesBOY0134539
IRS990PF/DistributableAmount/DistributableAmountAsAdjusted00
IRS990PF/DistributableAmount/DistributableAmountBeforeAdj023
IRS990PF/DistributableAmount/DistributableAmountBeforeDed023
IRS990PF/DistributableAmount/TaxBasedOnInvestmentIncome023
IRS990PF/DistributableAmount/TotalTax023
IRS990PF/ExciseTaxBasedOnInvestmentIncm/AmountCreditedToNextYear00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/InvestmentIncomeExciseTax023
IRS990PF/ExciseTaxBasedOnInvestmentIncm/Subtotal023
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxBasedOnInvestmentIncome023
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxDue023
IRS990PF/ExemptPF0X
IRS990PF/FinalReturn0X
IRS990PF/FMVAssetsEOY00
IRS990PF/MethodOfAccountingCash0X
IRS990PF/MinimumInvestmentReturn/AdjTotalFMVOfUnusedAssets00
IRS990PF/MinimumInvestmentReturn/AvgMonthlyCashBalances00
IRS990PF/MinimumInvestmentReturn/AvgMonthlyFMVOfSecurities00
IRS990PF/MinimumInvestmentReturn/CashDeemedCharitable00
IRS990PF/MinimumInvestmentReturn/FMVAllOtherNoncharitableAssets00
IRS990PF/MinimumInvestmentReturn/MinimumInvestmentReturn00
IRS990PF/MinimumInvestmentReturn/NetNoncharitableAssets00
IRS990PF/MinimumInvestmentReturn/ReductionClaimed00
IRS990PF/MinimumInvestmentReturn/TotalFMVOfUnusedAssets00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHghstPaidCntrctNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHighestPaidEmplNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition00.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName0JOHN B CASHMAN
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title0Trustee
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine101310 PRAIRIEVIEW AVE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City0VAN METER
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State0IA
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode050261
IRS990PF/QualifyingDistributions/AdjQualifyingDistributions0132130
IRS990PF/QualifyingDistributions/ExpensesAndContributions0132130
IRS990PF/QualifyingDistributions/QualifyingDistributions0132130
IRS990PF/StatementsRegardingActivities/ActivitiesNotPrevReported0false
IRS990PF/StatementsRegardingActivities/ApplicableInsuranceContract0false
IRS990PF/StatementsRegardingActivities/AtLeast5000InAssets0true
IRS990PF/StatementsRegardingActivities/BooksInCareOfBusinessName/BusinessNameLine10JOHN B CASHMAN
IRS990PF/StatementsRegardingActivities/BooksInCareOfPhoneNumber05159962748
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine101310 PRAIRIEVIEW AVE
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/City0VAN METER
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/State0IA
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/ZIPCode050261
IRS990PF/StatementsRegardingActivities/ChangesToArticlesOrBylaws0false
IRS990PF/StatementsRegardingActivities/ComplyWithPublicInspectionRqr0true
IRS990PF/StatementsRegardingActivities/ForeignBank0false
IRS990PF/StatementsRegardingActivities/Form1120POLFiled0false
IRS990PF/StatementsRegardingActivities/Form990PFFiledWithAG0true
IRS990PF/StatementsRegardingActivities/Form990TFiled0false
IRS990PF/StatementsRegardingActivities/InterestInControlledEntity0false
IRS990PF/StatementsRegardingActivities/LegislativePoliticalActivities0false
IRS990PF/StatementsRegardingActivities/MoreThan100Spent0false
IRS990PF/StatementsRegardingActivities/NewSubstantialContributors0false
IRS990PF/StatementsRegardingActivities/PrivateOperatingFoundation0false
IRS990PF/StatementsRegardingActivities/RequirementsOfSect508e0false
IRS990PF/StatementsRegardingActivities/StatesFiledWith0IA
IRS990PF/StatementsRegardingActivities/TerminationEtc0true
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/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount0132130
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution0COLLEGE OF EDUCATION
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus0TAX EXEMP
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName0DRAKE UNIVERSITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship0NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine102507 UNIVERSITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City0DES MOINES
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State0IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode050311
IRS990PF/SupplementaryInformation/OnlyContributesToPreselected0X
IRS990PF/SupplementaryInformation/TotGrantOrContriPaidDuringYear0132130
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/DistributableAmountAsAdjusted00
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear1040000
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear2010000
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear3025000
IRS990PF/UndistributedIncome/ExcessDistriCyovToNextYear0207130
IRS990PF/UndistributedIncome/ExcessFromCurrentYear0132130
IRS990PF/UndistributedIncome/ExcessFromYear1040000
IRS990PF/UndistributedIncome/ExcessFromYear2010000
IRS990PF/UndistributedIncome/ExcessFromYear3025000
IRS990PF/UndistributedIncome/QualifyingDistributions0132130
IRS990PF/UndistributedIncome/RemainingDistriFromCorpus0132130
IRS990PF/UndistributedIncome/TotalCorpus0207130
IRS990PF/UndistributedIncome/TotalExcessDistriCarryover075000
IRS990PF/UndistributedIncome/TreatedAsDistriFromCorpus00
IRS990PF/UndistributedIncome/UndistributedIncomeCY00
LegalFeesSchedule/LegalFees/AdjustedNetIncome00
LegalFeesSchedule/LegalFees/Amount085
LegalFeesSchedule/LegalFees/Category0FINLEY, ALT, SMITH, ETAL
LegalFeesSchedule/LegalFees/DisbursementsCharitablePrps00
LegalFeesSchedule/LegalFees/NetInvestmentIncome00
LiquidationExplanationStmt/Statement0ALL ASSETS WERE DISTRIBUTED AS DESIGNATED BY THE FOUNDATION.
OtherIncomeSchedule2/OtherIncome/Description0Other Investment Income
OtherIncomeSchedule2/OtherIncome/RevenueAndExpensesPerBooks080
OtherIncreasesSchedule/OtherIncreases/Amount0856
OtherIncreasesSchedule/OtherIncreases/Description0ADJUST BOOK BALANCE TO MARKET (UNREALIZED GAINS)
OtherProfessionalFeesSchedule/OtherProfessionalFees/AdjustedNetIncome00
OtherProfessionalFeesSchedule/OtherProfessionalFees/Amount0737
OtherProfessionalFeesSchedule/OtherProfessionalFees/Category0FUND MGT FEES FIRST ALLIED
OtherProfessionalFeesSchedule/OtherProfessionalFees/DisbursementsCharitablePrps00
OtherProfessionalFeesSchedule/OtherProfessionalFees/NetInvestmentIncome00
TaxesSchedule/Taxes/Amount023
TaxesSchedule/Taxes/Amount128
TaxesSchedule/Taxes/Category0US TREASURY-2011
TaxesSchedule/Taxes/Category1US TREASURY-2010
ReturnHeader/BuildTS02016-02-24 21:20:13Z
ReturnHeader/Filer/EIN0207222190
ReturnHeader/Filer/Name/BusinessNameLine10ELIZABETH A SPROUL CHARITABLE TRUST
ReturnHeader/Filer/NameControl0ELIZ
ReturnHeader/Filer/USAddress/AddressLine101310 PRAIRIEVIEW AVENUE
ReturnHeader/Filer/USAddress/City0VAN METER
ReturnHeader/Filer/USAddress/State0IA
ReturnHeader/Filer/USAddress/ZIPCode050261
ReturnHeader/Officer/AuthorizeThirdParty0true
ReturnHeader/Officer/DateSigned02012-05-09
ReturnHeader/Officer/Name0JOHN B CASHMAN
ReturnHeader/Officer/Title0Trustee
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10John B Cashman CPA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine101310 Prairieview Ave
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0Van Meter
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0IA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode0502618573
ReturnHeader/Preparer/Name0JOHN B CASHMAN
ReturnHeader/Preparer/Phone05159962748
ReturnHeader/Preparer/SelfEmployed0X
ReturnHeader/ReturnType0990PF
ReturnHeader/TaxPeriodBeginDate02011-01-01
ReturnHeader/TaxPeriodEndDate02011-12-31
ReturnHeader/TaxYear02011
ReturnHeader/Timestamp02012-05-09T14:25:36-07:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.