Civic Intelligence

Helen Mcmillan Charitable Trust

990 • Fiscal year 2012 • EIN 37-6331248

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

Organization ProfileN/A
127 S Side Square61455
Siviq Scores

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

Liabilities / Assets

12th percentile

0.00x

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

2012 filings • 501(c)3 • $1M-$5M 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

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2012

Asset Growth

46th percentile

-0.0%

Faster asset growth than 46% of similar nonprofits.

2012 filings • 501(c)3 • $1M-$5M 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 / Assets12th percentile

Assets

Down

$1,208,309

Down $442 (-0.0%) from 2011

Net Assets

Down

$1,208,309

Down $442 (-0.0%) from 2011

Liabilities

Flat

$0

Flat from 2011

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

Up

$26,664

Up $207 (+0.8%) from 2011

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth46th percentile

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

$1.5M$1.0M$500K$0Assets 2011: $1,208,751Liabilities 2011: $0Net Assets 2011: $1,208,7512011Assets 2012: $1,208,309Liabilities 2012: $0Net Assets 2012: $1,208,3092012Assets 2013: $1,205,502Liabilities 2013: $0Net Assets 2013: $1,205,5022013Assets 2014: $1,207,310Liabilities 2014: $0Net Assets 2014: $1,207,3102014Assets 2015: $1,208,000Liabilities 2015: $0Net Assets 2015: $1,208,0002015Assets 2016: $1,208,103Liabilities 2016: $0Net Assets 2016: $1,208,1032016Assets 2017: $1,009,572Liabilities 2017: $0Net Assets 2017: $1,009,5722017Assets 2018: $1,001,810Liabilities 2018: $0Net Assets 2018: $1,001,8102018Assets 2019: $994,328Liabilities 2019: $0Net Assets 2019: $994,3282019Assets 2020: $980,189Liabilities 2020: $0Net Assets 2020: $980,1892020Assets 2021: $996,500Liabilities 2021: $0Net Assets 2021: $996,5002021Assets 2022: $986,984Liabilities 2022: $0Net Assets 2022: $986,9842022Assets 2023: $983,436Liabilities 2023: $0Net Assets 2023: $983,4362023

Highlighted filing

2012

Assets$1,208,309
Liabilities$0
Net Assets$1,208,309
Open 2012 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$400K$200K$0-$200KExpenses 2011: $26,4572011Expenses 2012: $26,6642012Revenue 2013: $21,185Expenses 2013: $23,992Net Income 2013: -$2,8072013Revenue 2014: $21,674Expenses 2014: $19,866Net Income 2014: $1,8082014Revenue 2015: $22,985Expenses 2015: $22,295Net Income 2015: $6902015Revenue 2016: $22,730Expenses 2016: $22,627Net Income 2016: $1032016Revenue 2017: $21,503Expenses 2017: $220,034Net Income 2017: -$198,5312017Revenue 2018: $24,542Expenses 2018: $32,304Net Income 2018: -$7,7622018Revenue 2019: $28,066Expenses 2019: $35,090Net Income 2019: -$7,0242019Revenue 2020: $23,073Expenses 2020: $37,375Net Income 2020: -$14,3022020Revenue 2021: $51,631Expenses 2021: $35,645Net Income 2021: $15,9862021Revenue 2022: $28,562Expenses 2022: $36,960Net Income 2022: -$8,3982022Revenue 2023: $42,535Expenses 2023: $46,977Net Income 2023: -$4,4422023

Highlighted filing

2012

Revenue-
Expenses$26,664
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
Gross Receipts
$26,222
Mission and Program Overview

Mission

To provide financial support for the camp creek presbyterian church, n/k/a scotland trinity presbyterian church.

Filing and Contact Details

Filer

EIN
37-6331248
Raw XML Appendix249 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
IRS990/AccountantCompileOrReview0false
IRS990/ActivitiesConductedPartnership0false
IRS990/ActivityOrMissionDescription0THE GRANTOR CREATED THE CHARITABLE TRUST TO PROVIDE FINANCIAL SUPPORT FOR THE CAMP CREEK PRESBYTERIAN CHURCH N/K/A SCOTLAND TRINITY PRESBYTERIAN CHURCH. THE CHURCH IS A PROTESTANT PRESBYTERIAN CHURCH THAT HAS EXISTED FOR OVER 100 YEARS AND THE CHURCH PERFORMS TRADITIONAL
IRS990/BenefitsPaidToMembersCY00
IRS990/BsnssRltnshpThruFamilyMember0false
IRS990/BsnssRltnshpWithOrganization0false
IRS990/CapStckTrstPrinCurrentFunds/BOY01208751
IRS990/CapStckTrstPrinCurrentFunds/EOY01208309
IRS990/ChangesToOrganizingDocs0false
IRS990/CollectionsOfArt0false
IRS990/CompensationFromOtherSources0false
IRS990/CompensationProcessCEO0false
IRS990/CompensationProcessOther0false
IRS990/ConflictOfInterestPolicy0false
IRS990/ConservationEasements0false
IRS990/ConsolidatedAuditFinancialStmt0false
IRS990/ContributionsGrantsCurrentYear00
IRS990/CreditCounseling0false
IRS990/DecisionsSubjectToApproval0false
IRS990/DeductibleContributionsOfArt0false
IRS990/DeductibleNonCashContributions0false
IRS990/DelegationOfManagementDuties0false
IRS990/DescribedIn501C30true
IRS990/Description0THE GRANTOR CREATED THE CHARITABLE TRUST TO PROVIDE FINANCIAL SUPPORT FOR THE CAMP CREEK PRESBYTERIAN CHURCH N/K/A SCOTLAND TRINITY PRESBYTERIAN CHURCH. THE CHURCH IS A PROTESTANT PRESBYTERIAN CHURCH THAT HAS EXISTED FOR OVER 100 YEARS AND THE CHURCH PERFORMS TRADITIONAL CHURCH FUNCTIONS.
IRS990/DisregardedEntity0false
IRS990/DocumentRetentionPolicy0false
IRS990/DoingBusinessAs/BusinessNameLine10CITIZENS A DIVISION OF MORTON
IRS990/DonorAdvisedFunds0false
IRS990/DoNotFollowSFAS1170X
IRS990/ElectionOfBoardMembers0false
IRS990/ExcessBenefitTransaction0false
IRS990/Expense021423
IRS990/FamilyOrBusinessRelationship0false
IRS990/FederalGrantAuditRequired0false
IRS990/ForeignActivities0false
IRS990/ForeignFinancialAccount0false
IRS990/ForeignOffice0false
IRS990/Form8282PropertyDisposedOf0false
IRS990/Form990PartVIISectionA/AverageHoursPerWeek01.00
IRS990/Form990PartVIISectionA/InstitutionalTrustee0X
IRS990/Form990PartVIISectionA/NamePerson0CITIZENS A DIV OF MORT TRUSTE
IRS990/Form990PartVIISectionA/OtherCompensation00
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization00
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs00
IRS990/Form990PartVIISectionA/Title0INSTITUTIONAL TRUSTEE
IRS990/Form990ProvidedToGoverningBody0false
IRS990/FormersListed0false
IRS990/FSAudited0false
IRS990/FundraisingActivities0false
IRS990/FundsToPayPremiums0false
IRS990/Gaming0false
IRS990/GrantsAndSimilarAmntsCY021423
IRS990/GrantsAndSimilarAmntsPriorYear020532
IRS990/GrantsToDomesticOrgs/ProgramServices021423
IRS990/GrantsToDomesticOrgs/Total021423
IRS990/GrantsToIndividuals0false
IRS990/GrantsToOrganizations0true
IRS990/GrantToRelatedPerson0false
IRS990/GrossReceipts026222
IRS990/GroupReturnForAffiliates0false
IRS990/Hospital0false
IRS990/IndependentAuditFinancialStmt0false
IRS990/IndoorTanningServices0false
IRS990/InfoInScheduleOPartVI0X
IRS990/InvestmentIncomeCurrentYear026222
IRS990/InvestmentIncomePriorYear025830
IRS990/InvestmentIncome/RelatedOrExemptFunctionIncome026222
IRS990/InvestmentIncome/TotalRevenueColumn026222
IRS990/InvestmentInJointVenture0false
IRS990/InvestmentsOtherSecurities/BOY01208751
IRS990/InvestmentsOtherSecurities/EOY01208309
IRS990/LoanToOfficerOrDQP0false
IRS990/LobbyingActivities0false
IRS990/LocalChapters0false
IRS990/MaterialDiversionOrMisuse0false
IRS990/MembersOrStockholders0false
IRS990/MethodOfAccountingCash0X
IRS990/MinutesOfCommittees0true
IRS990/MinutesOfGoverningBody0true
IRS990/MissionDescription0THE GRANTOR CREATED THE CHARITABLE TRUST TO PROVIDE FINANCIAL SUPPORT FOR THE CAMP CREEK PRESBYTERIAN CHURCH N/K/A SCOTLAND TRINITY PRESBYTERIAN CHURCH. THE CHURCH IS A PROTESTANT PRESBYTERIAN CHURCH THAT HAS EXISTED FOR OVER 100 YEARS AND THE CHURCH PERFORMS TRADITIONAL
IRS990/MoreThan5000KToIndividuals0false
IRS990/MoreThan5000KToOrganizations0false
IRS990/NbrIndependentVotingMembers00
IRS990/NbrVotingGoverningBodyMembers01
IRS990/NbrVotingMembersGoverningBody01
IRS990/NetAssetsOrFundBalancesBOY01208751
IRS990/NetAssetsOrFundBalancesEOY01208309
IRS990/NetUnrelatedBusinessTxblIncome00
IRS990/NoListedPersonsCompensated0X
IRS990/NonDeductibleContributions0false
IRS990/NumberFormsTransmittedWith109600
IRS990/NumberIndependentVotingMembers00
IRS990/NumberIndividualsGT100K00
IRS990/NumberOfEmployees00
IRS990/NumberW2GIncluded00
IRS990/OfficerEntityWithBsnssRltnshp0false
IRS990/OfficerMailingAddress0false
IRS990/Organization501c30X
IRS990/OtherExpensePriorYear05925
IRS990/OtherExpensesCurrentYear05241
IRS990/OtherExpenses/Description0FIDUCIARY FEES
IRS990/OtherExpenses/Description1PROF FEES
IRS990/OtherExpenses/Description2FILING FEES ST IL
IRS990/OtherExpenses/ManagementAndGeneral04851
IRS990/OtherExpenses/ManagementAndGeneral1375
IRS990/OtherExpenses/ManagementAndGeneral215
IRS990/OtherExpenses/Total04851
IRS990/OtherExpenses/Total1375
IRS990/OtherExpenses/Total215
IRS990/OtherRevenueCurrentYear00
IRS990/PartialLiquidation0false
IRS990/PoliticalActivities0false
IRS990/PremiumsPaid0false
IRS990/PriorExcessBenefitTransaction0false
IRS990/ProfessionalFundraising0false
IRS990/ProgramServiceRevenueCY00
IRS990/ProhibitedTaxShelterTrans0false
IRS990/QuidProQuoContributions0false
IRS990/ReconcilationOtherChanges00
IRS990/ReconcilationRevenueExpenses0-442
IRS990/RelatedEntity0false
IRS990/RelatedOrgControlledEntity0false
IRS990/ReportFin48Footnote0false
IRS990/ReportInvestOthSecurities0true
IRS990/ReportLandBldgEquip0false
IRS990/ReportOtherAssets0false
IRS990/ReportOtherLiabilities0false
IRS990/ReportProgRelInvest0false
IRS990/RevenuesLessExpensesCY0-442
IRS990/RevenuesLessExpensesPriorYear0-627
IRS990/SalariesEtcCurrentYear00
IRS990ScheduleA/ContribBy35ControlledEntity0false
IRS990ScheduleA/ContribByControllingIndividual0false
IRS990ScheduleA/ContributionByRelatedParty0false
IRS990ScheduleA/SupportedOrgInformation/Amount00
IRS990ScheduleA/SupportedOrgInformation/EIN0363844885
IRS990ScheduleA/SupportedOrgInformation/ListedInGoverningDoc0false
IRS990ScheduleA/SupportedOrgInformation/Name/BusinessNameLine10SCOTLAND TRINITY PRESBYTERIAN
IRS990ScheduleA/SupportedOrgInformation/OrganizedInUS0true
IRS990ScheduleA/SupportedOrgInformation/SupportedOrganizationNotified0false
IRS990ScheduleA/SupportedOrgInformation/TypeOfOrganization0501 C 3
IRS990ScheduleA/SupportingOrg509a3Type3NonFunc0X
IRS990ScheduleA/SupportingOrganization509a30X
IRS990ScheduleA/TotalNumberOfSupportedOrgs01
IRS990/ScheduleBRequired0false
IRS990ScheduleD/OtherSecurities/BookValue01208309
IRS990ScheduleD/OtherSecurities/Description0CITIZENS DIV OF MORTON INVE
IRS990ScheduleD/OtherSecurities/MethodOfValuation0C
IRS990ScheduleD/TotalOfBookValueSecurities01208309
IRS990ScheduleI/RecipientTable/AddressUS/AddressLine1014950 N 900TH RD
IRS990ScheduleI/RecipientTable/AddressUS/City0MACOMB
IRS990ScheduleI/RecipientTable/AddressUS/State0IL
IRS990ScheduleI/RecipientTable/AddressUS/ZIPCode061455
IRS990ScheduleI/RecipientTable/PurposeOfGrant0TRADITIONAL
IRS990ScheduleI/RecipientTable/RecipientNameBusiness/BusinessNameLine10SCOTLAND TRINITY CHURCH
IRS990ScheduleI/RecordsMaintained0false
IRS990/ScheduleJRequired0false
IRS990ScheduleO/GeneralExplanation/Explanation0NO REVIEW WAS OR WILL BE CONDUCTED
IRS990ScheduleO/GeneralExplanation/Explanation1NO DOCUMENTS AVAILABLE TO THE PUBLIC.
IRS990ScheduleO/GeneralExplanation/Explanation2NO DOCUMENTS AVAILABLE TO THE PUBLIC.
IRS990ScheduleO/GeneralExplanation/Explanation3END OF YEAR CHANGE IN FUND BALANCE.
IRS990ScheduleO/GeneralExplanation/Identifier0O01
IRS990ScheduleO/GeneralExplanation/Identifier1O02
IRS990ScheduleO/GeneralExplanation/Identifier2O03
IRS990ScheduleO/GeneralExplanation/Identifier3O04
IRS990ScheduleO/GeneralExplanation/ReturnReference0Form 990 governing body review Part VI line 11
IRS990ScheduleO/GeneralExplanation/ReturnReference1Form 990 availability to public Part VI line 18
IRS990ScheduleO/GeneralExplanation/ReturnReference2Governing documents etc available to public Part VI line 19
IRS990ScheduleO/GeneralExplanation/ReturnReference3Explanation of other changes in net assets or fund balances Part XI line 9
IRS990/ScheduleORequired0true
IRS990/School0false
IRS990/SignificantChange0false
IRS990/SignificantNewProgramServices0false
IRS990/StateLegalDomicile0IL
IRS990/TaxablePartyNotification0false
IRS990/TaxExemptBonds0false
IRS990/Terminated0false
IRS990/TermOrPermanentEndowments0false
IRS990/TheBooksAreInCareOf/AddressUS/AddressLine10127 S SIDE SQUARE
IRS990/TheBooksAreInCareOf/AddressUS/City0MACOMB
IRS990/TheBooksAreInCareOf/AddressUS/State0IL
IRS990/TheBooksAreInCareOf/AddressUS/ZIPCode061455
IRS990/TheBooksAreInCareOf/NamePerson0CITIZENS A DIV OF MORT TRUSTEE
IRS990/TheBooksAreInCareOf/TelephoneNumber03098370622
IRS990/TotalAssets/BOY01208751
IRS990/TotalAssetsBOY01208751
IRS990/TotalAssets/EOY01208309
IRS990/TotalAssetsEOY01208309
IRS990/TotalCompGT150K0false
IRS990/TotalExpensesCurrentYear026664
IRS990/TotalExpensesPriorYear026457
IRS990/TotalFunctionalExpenses/Fundraising00
IRS990/TotalFunctionalExpenses/ManagementAndGeneral05241
IRS990/TotalFunctionalExpenses/ProgramServices021423
IRS990/TotalFunctionalExpenses/Total026664
IRS990/TotalFundrsngExpCurrentYear00
IRS990/TotalGrossUBI00
IRS990/TotalLiabilities/BOY00
IRS990/TotalLiabilities/EOY00
IRS990/TotalLiabilitiesEOY00
IRS990/TotalLiabNetAssetsFundBalances/BOY01208751
IRS990/TotalLiabNetAssetsFundBalances/EOY01208309
IRS990/TotalNbrEmployees00
IRS990/TotalNetAssetsFundBalances/BOY01208751
IRS990/TotalNetAssetsFundBalances/EOY01208309
IRS990/TotalOtherCompensation00
IRS990/TotalProfFundrsngExpCY00
IRS990/TotalProgramServiceExpense021423
IRS990/TotalReportableCompFrmRltdOrgs00
IRS990/TotalReportableCompFromOrg00
IRS990/TotalRevenueCurrentYear026222
IRS990/TotalRevenue/ExclusionAmount00
IRS990/TotalRevenuePriorYear025830
IRS990/TotalRevenue/RelatedOrExemptFunctionIncome026222
IRS990/TotalRevenue/TotalRevenueColumn026222
IRS990/TotalRevenue/UnrelatedBusinessRevenue00
IRS990/TransactionRelatedEntity0false
IRS990/TransfersToExemptNonChrtblOrg0false
IRS990/TypeOfOrganizationTrust0X
IRS990/UnrelatedBusinessIncome0false
IRS990/WebSite0N/A
IRS990/WhistleblowerPolicy0false
IRS990/YearFormation01994
ReturnHeader/BuildTS02016-02-24 21:20:13Z
ReturnHeader/Filer/EIN0376331248
ReturnHeader/Filer/Name/BusinessNameLine10HELEN MCMILLAN CHARITABLE TRUST
ReturnHeader/Filer/NameControl0HELE
ReturnHeader/Filer/USAddress/AddressLine10127 S SIDE SQUARE
ReturnHeader/Filer/USAddress/City0MACOMB
ReturnHeader/Filer/USAddress/State0IL
ReturnHeader/Filer/USAddress/ZIPCode061455
ReturnHeader/Officer/AuthorizeThirdParty0true
ReturnHeader/Officer/DateSigned02013-05-13
ReturnHeader/Officer/Name0CITIZENS DIV OF MORTON COMM BANK
ReturnHeader/Officer/Title0TRUSTEE
ReturnHeader/Preparer/DatePrepared02013-05-14
ReturnHeader/PreparerFirm/EIN0453778599
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10OLIVER & CAREY TAX ACCTING PAYROLL
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine10427 W JACKSON ST
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0Macomb
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0IL
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode061455
ReturnHeader/Preparer/Name0CYNTHIA L CAREY
ReturnHeader/Preparer/Phone03098368299
ReturnHeader/ReturnType0990
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-05-14T09:59:24-05:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2012 • Form 990Facts available. Structured filing facts are available, but richer extracted sections are limited.

Open filing
Assets
$1,208,309
Liabilities
$0
Net assets
$1,208,309
Revenue
-
Expenses
$26,664
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024XML pending. An XML filing is linked for this year, but detailed extraction is still pending.
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.98$0.00$0.98$0.04$0.05$0.00
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.99$0.00$0.99$0.03$0.04$0.01
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.00$0.00$1.00$0.05$0.04$0.02
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.98$0.00$0.98$0.02$0.04$0.01
2019Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.99$0.00$0.99$0.03$0.04$0.01
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.00$0.00$1.00$0.02$0.03$0.01
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.01$0.00$1.01$0.02$0.22$0.20
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.21$0.00$1.21$0.02$0.02$0.00
2015Import issue. A filing source exists for this year, but detailed import did not complete cleanly.$1.21$0.00$1.21$0.02$0.02$0.00
2014XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.21$0.00$1.21$0.02$0.02$0.00
2013Detailed filing. Detailed filing data is available for this year.$1.21$0.00$1.21$0.02$0.02$0.00
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.21$0.00$1.21$0.03
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.21$0.00$1.21$0.03