Civic Intelligence

Carol a Mccollum Foundation Trust

990PF • Fiscal year 2012 • EIN 20-0292501

Jan 01, 2012 to Dec 31, 2012 • Filed on May 13, 2013

Organization Profile
3809 N 29th Street64506
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

50th percentile

0.0%

Faster asset growth than 50% 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

Flat

$107,550

Flat from 2011

Net Assets

Flat

$107,550

Flat from 2011

Liabilities

Flat

$0

Flat from 2011

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

Down

$250

Down $2,000 (-89%) from 2011

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth50th percentile

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

$150K$100K$50K$0Assets 2010: $109,550Liabilities 2010: $0Net Assets 2010: $109,5502010Assets 2011: $107,550Liabilities 2011: $0Net Assets 2011: $107,5502011Assets 2012: $107,550Liabilities 2012: $0Net Assets 2012: $107,5502012Assets 2013: $105,550Liabilities 2013: $0Net Assets 2013: $105,5502013Assets 2014: $103,910Liabilities 2014: $0Net Assets 2014: $103,9102014Assets 2015: $101,910Liabilities 2015: $0Net Assets 2015: $101,9102015Assets 2016: $101,910Liabilities 2016: $0Net Assets 2016: $101,9102016Assets 2017: $101,850Liabilities 2017: $0Net Assets 2017: $101,8502017Assets 2018: $112,153Liabilities 2018: $0Net Assets 2018: $112,1532018Assets 2019: $103,977Liabilities 2019: $0Net Assets 2019: $103,9772019

Highlighted filing

2012

Assets$107,550
Liabilities$0
Net Assets$107,550
Open 2012 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$10K$5.0K$0-$5.0K-$10KExpenses 2010: $2,2002010Expenses 2011: $2,2502011Expenses 2012: $2502012Revenue 2013: $250Expenses 2013: $2,250Net Income 2013: -$2,0002013Revenue 2014: $456Expenses 2014: $250Net Income 2014: $2062014Revenue 2015: $250Expenses 2015: $250Net Income 2015: $02015Revenue 2016: $250Expenses 2016: $9,250Net Income 2016: -$9,0002016Revenue 2017: $250Expenses 2017: $310Net Income 2017: -$602017Revenue 2018: $250Expenses 2018: $325Net Income 2018: -$752018Revenue 2019: $250Expenses 2019: $3,310Net Income 2019: -$3,0602019

Highlighted filing

2012

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

Employees

NameTitleFull / Part TimeBaseOtherTotal
CAROL A MCCOLUMTrustee-$0--
Filing and Contact Details

Filer

EIN
20-0292501
Raw XML Appendix186 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/AdjustedNetIncome0250
AccountingFeesSchedule/AccountingFees/Amount0250
AccountingFeesSchedule/AccountingFees/Category0ACCOUNTING
AccountingFeesSchedule/AccountingFees/DisbursementsCharitablePrps0250
AccountingFeesSchedule/AccountingFees/NetInvestmentIncome0250
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue0106050
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV0175434
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock0LINCOLN BENEFIT LIFE COMPANY
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesAdjNetIncm0250
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesDsbrsChrtblPrps0250
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncm0250
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnss0250
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncome00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidRevAndExpnss00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriReceivedRevAndExpnss0250
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessOfRevenueOverExpenses00
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncome00
IRS990PF/AnalysisOfRevenueAndExpenses/NotRequiredToAttachScheduleB0X
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncm0250
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblPrps0250
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncm0250
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnss0250
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvestmentIncome00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevenueAndExpenses0250
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncm0250
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblPrps0250
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncm0250
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnss0250
IRS990PF/BalanceSheets/CashBOY01500
IRS990PF/BalanceSheets/CashEOY01500
IRS990PF/BalanceSheets/CashEOYFMV01500
IRS990PF/BalanceSheets/InvestmentsCorpStockBOY0106050
IRS990PF/BalanceSheets/InvestmentsCorpStockEOY0106050
IRS990PF/BalanceSheets/InvestmentsCorpStockEOYFMV0175434
IRS990PF/BalanceSheets/OrgThatFollowSFAS1170X
IRS990PF/BalanceSheets/TotalAssetsBOY0107550
IRS990PF/BalanceSheets/TotalAssetsEOY0107550
IRS990PF/BalanceSheets/TotalAssetsEOYFMV0176934
IRS990PF/BalanceSheets/TotalLiabilitiesBOY00
IRS990PF/BalanceSheets/TotalLiabilitiesEOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsBOY0107550
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsEOY0107550
IRS990PF/BalanceSheets/TotalNetAssetsBOY0107550
IRS990PF/BalanceSheets/TotalNetAssetsEOY0107550
IRS990PF/BalanceSheets/UnrestrictedBOY0107550
IRS990PF/BalanceSheets/UnrestrictedEOY0107550
IRS990PF/ChangesInNetAssetsFundBalances/Subtotal0107550
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesBOY0107550
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesEOY0107550
IRS990PF/DistributableAmount/DistributableAmountAsAdjusted016158
IRS990PF/DistributableAmount/DistributableAmountBeforeAdj016158
IRS990PF/DistributableAmount/DistributableAmountBeforeDed016158
IRS990PF/DistributableAmount/MinimumInvestmentReturn016158
IRS990PF/ExciseTaxBasedOnInvestmentIncm/InvestmentIncomeExciseTax00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/SubtitleATax00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxBasedOnInvestmentIncome00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxUnderSection51100
IRS990PF/ExemptPF0X
IRS990PF/FMVAssetsEOY0176934
IRS990PF/MethodOfAccountingCash0X
IRS990PF/MinimumInvestmentReturn/AcquisitionIndebtedness00
IRS990PF/MinimumInvestmentReturn/AdjTotalFMVOfUnusedAssets0328090
IRS990PF/MinimumInvestmentReturn/AvgMonthlyCashBalances0149656
IRS990PF/MinimumInvestmentReturn/AvgMonthlyFMVOfSecurities0176934
IRS990PF/MinimumInvestmentReturn/CashDeemedCharitable04921
IRS990PF/MinimumInvestmentReturn/FMVAllOtherNoncharitableAssets01500
IRS990PF/MinimumInvestmentReturn/MinimumInvestmentReturn016158
IRS990PF/MinimumInvestmentReturn/NetNoncharitableAssets0323169
IRS990PF/MinimumInvestmentReturn/TotalFMVOfUnusedAssets0328090
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHighestPaidEmplNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition00.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName0CAROL A MCCOLUM
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title0TRUSTEE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine103809 N 29TH STREET
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City0SAINT JOSEPH
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State0MO
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode064506
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/TotNumberOfOthEmplPaidOver50k00
IRS990PF/QlfyUndSect4940eForReducedTax/AdjNonchrtblAssetsAndOnePct03694
IRS990PF/QlfyUndSect4940eForReducedTax/AdjustedNoncharitableAssets03694
IRS990PF/QlfyUndSect4940eForReducedTax/AverageDistributionRatio00.011432
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear100.018013
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear200.001694
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear300.001978
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear400.002973
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear500.032501
IRS990PF/QlfyUndSect4940eForReducedTax/LiableFor4942Tax0false
IRS990PF/QlfyUndSect4940eForReducedTax/NetNoncharitableAssets0323169
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear10124913
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear20118060
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear30101104
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear40100904
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear50123074
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributions0250
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear102250
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear20200
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear30200
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear40300
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear504000
IRS990PF/QlfyUndSect4940eForReducedTax/TotalDistributionRatio00.057159
IRS990PF/QualifyingDistributions/AdjQualifyingDistributions0250
IRS990PF/QualifyingDistributions/ExpensesAndContributions0250
IRS990PF/QualifyingDistributions/QualifyingDistributions0250
IRS990PF/RlnOfActyToAccomOfExemptPrps/RlnOfActyToAccomOfExemptPrps/LineNumber03
IRS990PF/RlnOfActyToAccomOfExemptPrps/RlnOfActyToAccomOfExemptPrps/RelationshipStatement0THE TRUST WAS ESTABLISHED FOR THE PURPOSE 0F ENABLING AREA STUDENTS TO ATTEND MISSOURI WESTERN STATE COLLEGE
IRS990PF/StatementsRegardingActivities/ActivitiesNotPrevReported0false
IRS990PF/StatementsRegardingActivities/ApplicableInsuranceContract0false
IRS990PF/StatementsRegardingActivities/AtLeast5000InAssets0true
IRS990PF/StatementsRegardingActivities/BooksInCareOfPersonName0CAROL A MCCOLUM
IRS990PF/StatementsRegardingActivities/BooksInCareOfPhoneNumber08162324343
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine103809 N 29TH STREET
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/City0SAINT JOSEPH
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/State0MO
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/ZIPCode064506
IRS990PF/StatementsRegardingActivities/ChangesToArticlesOrBylaws0false
IRS990PF/StatementsRegardingActivities/ComplyWithPublicInspectionRqr0true
IRS990PF/StatementsRegardingActivities/ForeignBank0false
IRS990PF/StatementsRegardingActivities/Form1120POLFiled0false
IRS990PF/StatementsRegardingActivities/Form990PFFiledWithAG0false
IRS990PF/StatementsRegardingActivities/InterestInControlledEntity0false
IRS990PF/StatementsRegardingActivities/LegislativePoliticalActivities0false
IRS990PF/StatementsRegardingActivities/MoreThan100Spent0false
IRS990PF/StatementsRegardingActivities/NewSubstantialContributors0false
IRS990PF/StatementsRegardingActivities/PrivateOperatingFoundation0false
IRS990PF/StatementsRegardingActivities/RequirementsOfSect508e0false
IRS990PF/StatementsRegardingActivities/TerminationEtc0false
IRS990PF/StatementsRegardingActivities/UnrelatedBusIncomeOver10000false
IRS990PF/SumOfProgramRelatedInvestments/Amount100
IRS990PF/SumOfProgramRelatedInvestments/Description10NONE
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/FormAndInfoAndMaterials0APPLICANT MUST SUBMIT PERSONAL LETTER TO SCHOLARSHIP COMMITTEE ALSO WITH LETTER OF INTRODUCTION
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientName0CAROL A MCCOLUMN
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientPhoneNumber08162324343
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/AddressLine103809 N 29TH STREET
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/City0Saint Joseph
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/State0MO
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/ZIPCode064506
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RestrictionsOnAwards0MUST BE FULL TIME STUDENT WITH GPA 2.5 OR GREATER
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/SubmissionDeadlines0APRIL 1
IRS990PF/SupplementaryInformation/ContributingManager0NONE
IRS990PF/SupplementaryInformation/ShareholderManager0NONE
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/AppliedToCurrentYear0250
IRS990PF/UndistributedIncome/DistributableAmountAsAdjusted016158
IRS990PF/UndistributedIncome/QualifyingDistributions0250
IRS990PF/UndistributedIncome/UndistributedIncomeCY015908
ReturnHeader/BuildTS02016-02-25 16:41:14Z
ReturnHeader/Filer/EIN0200292501
ReturnHeader/Filer/Name/BusinessNameLine10CAROL A MCCOLUM FOUNDATION TRUST
ReturnHeader/Filer/NameControl0CARO
ReturnHeader/Filer/USAddress/AddressLine103809 N 29TH STREET
ReturnHeader/Filer/USAddress/City0ST JOSEPH
ReturnHeader/Filer/USAddress/State0MO
ReturnHeader/Filer/USAddress/ZIPCode064506
ReturnHeader/Officer/AuthorizeThirdParty0true
ReturnHeader/Officer/DateSigned02013-05-13
ReturnHeader/Officer/Name0CAROL A MCCOLUM
ReturnHeader/Officer/Phone08162324343
ReturnHeader/Officer/Title0TRUSTEE
ReturnHeader/Preparer/DatePrepared02013-05-15
ReturnHeader/PreparerFirm/EIN0431534223
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10JACK D WATTENBARGER CPA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine101338 N BELT HWY STE B
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0Saint Joseph
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0MO
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode064506
ReturnHeader/Preparer/Name0JACK D WATTENBARGER
ReturnHeader/Preparer/Phone08162321116
ReturnHeader/Preparer/SelfEmployed0X
ReturnHeader/ReturnType0990PF
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-05-15T14:14:34-05: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
$107,550
Liabilities
$0
Net assets
$107,550
Revenue
-
Expenses
$250
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2019Detailed filing. Detailed filing data is available for this year.$1.04$0.00$1.04$0.00$0.03$0.03
2018Detailed filing. Detailed filing data is available for this year.$1.12$0.00$1.12$0.00$0.00$0.00
2017Detailed filing. Detailed filing data is available for this year.$1.02$0.00$1.02$0.00$0.00$0.00
2016Detailed filing. Detailed filing data is available for this year.$1.02$0.00$1.02$0.00$0.09$0.09
2015Detailed filing. Detailed filing data is available for this year.$1.02$0.00$1.02$0.00$0.00$0.00
2014Detailed filing. Detailed filing data is available for this year.$1.04$0.00$1.04$0.00$0.00$0.00
2013Detailed filing. Detailed filing data is available for this year.$1.06$0.00$1.06$0.00$0.02$0.02
2012Detailed filing. Detailed filing data is available for this year.$1.08$0.00$1.08$0.00
2011Detailed filing. Detailed filing data is available for this year.$1.08$0.00$1.08$0.02
2010Detailed filing. Detailed filing data is available for this year.$1.10$0.00$1.10$0.02