Civic Intelligence

Ellen H Hicklin Charitable Lead Unitrust

990 • Fiscal year 2012 • EIN 57-6220347

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

Organization Profile
P O Box 172429304
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

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2012

Asset Growth

36th percentile

-4.6%

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

$450,863

Down $21,941 (-4.6%) from 2011

Net Assets

Down

$450,863

Down $21,941 (-4.6%) 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

$42,438

Down $3,912 (-8.4%) from 2011

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth36th percentile

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

$600K$400K$200K$0Assets 2011: $472,804Liabilities 2011: $0Net Assets 2011: $472,8042011Assets 2012: $450,863Liabilities 2012: $0Net Assets 2012: $450,8632012Assets 2013: $447,984Liabilities 2013: $0Net Assets 2013: $447,9842013

Highlighted filing

2012

Assets$450,863
Liabilities$0
Net Assets$450,863
Open 2012 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$60K$40K$20K$0-$20KExpenses 2011: $46,3502011Expenses 2012: $42,4382012Revenue 2013: $40,938Expenses 2013: $43,817Net Income 2013: -$2,8792013

Highlighted filing

2012

Revenue-
Expenses$42,438
Net Income-
Open 2012 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2012 to Dec 31, 2012
Signed
May 14, 2013
Return Version
2012v2.1
Gross Receipts
$116,951
Mission and Program Overview

Mission

To invest funds and donate 7% of the net fair market value of the trust assets as of the first day of each taxable year to the trust's charitable beneficiaries. To be paid annually on the last day of the trusts fiscal year.

Filing and Contact Details

Filer

EIN
57-6220347
Raw XML Appendix264 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/ActivityOrMissionDescription0TO INVEST FUNDS AND DONATE 7% OF THE NET FAIR MARKET VALUE OF THE TRUST ASSETS AS OF THE FIRST DAY OF EACH TAXABLE YEAR TO THE TRUST'S CHARITABLE BENEFICIARIES. TO BE PAID ANNUALLY ON THE LAST DAY OF THE TRUSTS FISCAL YEAR.
IRS990/AddressPrincipalOfficerUS/AddressLine10P O BOX 1724
IRS990/AddressPrincipalOfficerUS/City0SPARTANBURG
IRS990/AddressPrincipalOfficerUS/State0SC
IRS990/AddressPrincipalOfficerUS/ZIPCode029304
IRS990/AmountOfTaxExemptInterest05
IRS990/BenefitsPaidToMembersCY00
IRS990/BsnssRltnshpThruFamilyMember0false
IRS990/BsnssRltnshpWithOrganization0false
IRS990/CashNonInterestBearing/BOY055637
IRS990/CashNonInterestBearing/EOY018201
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/Description0DONATIONS MADE TO BOTH CHARITABLE BENEFICIARIES AS REQUIRED.
IRS990/DisregardedEntity0false
IRS990/DocumentRetentionPolicy0false
IRS990/DonorAdvisedFunds0false
IRS990/ElectionOfBoardMembers0false
IRS990/ExcessBenefitTransaction0false
IRS990/Expense036402
IRS990/FamilyOrBusinessRelationship0false
IRS990/FeesForServicesAccounting/ManagementAndGeneral0550
IRS990/FeesForServicesAccounting/Total0550
IRS990/FeesForServicesManagement/ManagementAndGeneral05486
IRS990/FeesForServicesManagement/Total05486
IRS990/FiledLieu10410true
IRS990/FollowSFAS1170X
IRS990/ForeignActivities0false
IRS990/ForeignFinancialAccount0false
IRS990/ForeignOffice0false
IRS990/Form990PartVIISectionA/InstitutionalTrustee0X
IRS990/Form990PartVIISectionA/NameBusiness/BusinessNameLine10COLONIAL TRUST COMPANY INC
IRS990/Form990PartVIISectionA/NameBusiness/BusinessNameLine20COLONIAL TRUST COMPANY INC
IRS990/Form990PartVIISectionA/OtherCompensation00
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization00
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs00
IRS990/Form990PartVIISectionA/Title0TRUSTEE
IRS990/Form990ProvidedToGoverningBody0false
IRS990/FormersListed0false
IRS990/FSAudited0false
IRS990/FundraisingActivities0false
IRS990/GainOrLoss/Securities06243
IRS990/Gaming0false
IRS990/Grants036402
IRS990/GrantsAndSimilarAmntsCY036402
IRS990/GrantsAndSimilarAmntsPriorYear040258
IRS990/GrantsToDomesticOrgs/ProgramServices036402
IRS990/GrantsToDomesticOrgs/Total036402
IRS990/GrantsToIndividuals0false
IRS990/GrantsToOrganizations0true
IRS990/GrantToRelatedPerson0false
IRS990/GrossAmountSalesAssets/Securities0102697
IRS990/GrossReceipts0116951
IRS990/GroupReturnForAffiliates0false
IRS990/Hospital0false
IRS990/IndependentAuditFinancialStmt0false
IRS990/IndoorTanningServices0false
IRS990/InfoInScheduleOPartIII0X
IRS990/InvestmentIncomeCurrentYear019041
IRS990/InvestmentIncome/ExclusionAmount05
IRS990/InvestmentIncomePriorYear0332
IRS990/InvestmentIncome/RelatedOrExemptFunctionIncome012793
IRS990/InvestmentIncome/TotalRevenueColumn012798
IRS990/InvestmentInJointVenture0false
IRS990/InvestmentsPubTradedSecurities/BOY0417167
IRS990/InvestmentsPubTradedSecurities/EOY0432662
IRS990/LessCostOthBasisSalesExpenses/Securities096454
IRS990/LoanToOfficerOrDQP0false
IRS990/LobbyingActivities0false
IRS990/LocalChapters0false
IRS990/MaterialDiversionOrMisuse0false
IRS990/MembersOrStockholders0false
IRS990/MethodOfAccountingCash0X
IRS990/MinutesOfCommittees0true
IRS990/MinutesOfGoverningBody0true
IRS990/MissionDescription0TO INVEST FUNDS AND DONATE 7% OF THE NET FAIR MARKET VALUE OF THE TRUST ASSETS AS OF THE FIRST DAY OF EACH TAXABLE YEAR TO THE TRUST'S CHARITABLE BENEFICIARIES. TO BE PAID ANNUALLY ON THE LAST DAY OF THE TRUSTS FISCAL YEAR.
IRS990/MoreThan5000KToIndividuals0false
IRS990/MoreThan5000KToOrganizations0false
IRS990/NameOfPrincipalOfficerPerson0COLONIAL TRUST COMPANY
IRS990/NbrIndependentVotingMembers00
IRS990/NbrVotingGoverningBodyMembers00
IRS990/NbrVotingMembersGoverningBody00
IRS990/NetAssetsOrFundBalancesBOY0472804
IRS990/NetAssetsOrFundBalancesEOY0450863
IRS990/NetGainOrLossInvestments/RelatedOrExemptFunctionIncome06243
IRS990/NetGainOrLossInvestments/TotalRevenueColumn06243
IRS990/NoListedPersonsCompensated0X
IRS990/NonDeductibleContributions0false
IRS990/NumberFormsTransmittedWith109600
IRS990/NumberIndependentVotingMembers00
IRS990/NumberOfEmployees00
IRS990/NumberW2GIncluded00
IRS990/OfficerEntityWithBsnssRltnshp0false
IRS990/OfficerMailingAddress0false
IRS990/Organization4947a10X
IRS990/OtherExpensePriorYear06092
IRS990/OtherExpensesCurrentYear06036
IRS990/OtherRevenueCurrentYear01456
IRS990/OtherRevenueMisc/Description0MISCELLANEOUS
IRS990/OtherRevenueMisc/RelatedOrExemptFunctionIncome01456
IRS990/OtherRevenueMisc/TotalRevenueColumn01456
IRS990/OtherRevenuePriorYear035
IRS990/PartialLiquidation0false
IRS990/PoliticalActivities0false
IRS990/PriorExcessBenefitTransaction0false
IRS990/ProfessionalFundraising0false
IRS990/ProgramServiceRevenueCY00
IRS990/ProhibitedTaxShelterTrans0false
IRS990/ReconcilationRevenueExpenses0-21941
IRS990/RelatedEntity0false
IRS990/RelatedOrgControlledEntity0false
IRS990/ReportFin48Footnote0false
IRS990/ReportInvestOthSecurities0false
IRS990/ReportLandBldgEquip0false
IRS990/ReportOtherAssets0false
IRS990/ReportOtherLiabilities0false
IRS990/ReportProgRelInvest0false
IRS990/RevenuesLessExpensesCY0-21941
IRS990/RevenuesLessExpensesPriorYear0-45983
IRS990/SalariesEtcCurrentYear00
IRS990ScheduleA/CertificationCheckbox0X
IRS990ScheduleA/ContribBy35ControlledEntity0false
IRS990ScheduleA/ContribByControllingIndividual0false
IRS990ScheduleA/ContributionByRelatedParty0false
IRS990ScheduleA/SumOfAmounts036402
IRS990ScheduleA/SupportedOrgInformation/Amount018201
IRS990ScheduleA/SupportedOrgInformation/Amount118201
IRS990ScheduleA/SupportedOrgInformation/EIN0570351398
IRS990ScheduleA/SupportedOrgInformation/EIN1570314408
IRS990ScheduleA/SupportedOrgInformation/ListedInGoverningDoc0true
IRS990ScheduleA/SupportedOrgInformation/ListedInGoverningDoc1true
IRS990ScheduleA/SupportedOrgInformation/Name/BusinessNameLine10SPARTANBURG COUNTY FOUNDATION
IRS990ScheduleA/SupportedOrgInformation/Name/BusinessNameLine11PRESBYTERIAN COLLEGE
IRS990ScheduleA/SupportedOrgInformation/OrganizedInUS0true
IRS990ScheduleA/SupportedOrgInformation/OrganizedInUS1true
IRS990ScheduleA/SupportedOrgInformation/SupportedOrganizationNotified0true
IRS990ScheduleA/SupportedOrgInformation/SupportedOrganizationNotified1true
IRS990ScheduleA/SupportedOrgInformation/TypeOfOrganization09
IRS990ScheduleA/SupportedOrgInformation/TypeOfOrganization19
IRS990ScheduleA/SupportingOrg509a3Type10X
IRS990ScheduleA/SupportingOrganization509a30X
IRS990ScheduleA/TotalNumberOfSupportedOrgs02
IRS990/ScheduleBRequired0false
IRS990ScheduleI/RecipientTable/AddressUS/AddressLine10424 E KENNEDY ST
IRS990ScheduleI/RecipientTable/AddressUS/AddressLine11503 S BROAD ST
IRS990ScheduleI/RecipientTable/AddressUS/City0SPARTANBURG
IRS990ScheduleI/RecipientTable/AddressUS/City1CLINTON
IRS990ScheduleI/RecipientTable/AddressUS/State0SC
IRS990ScheduleI/RecipientTable/AddressUS/State1SC
IRS990ScheduleI/RecipientTable/AddressUS/ZIPCode029302
IRS990ScheduleI/RecipientTable/AddressUS/ZIPCode129325
IRS990ScheduleI/RecipientTable/AmountOfCashGrant018201
IRS990ScheduleI/RecipientTable/AmountOfCashGrant118201
IRS990ScheduleI/RecipientTable/EINOfRecipient0570351398
IRS990ScheduleI/RecipientTable/EINOfRecipient1570314408
IRS990ScheduleI/RecipientTable/RecipientNameBusiness/BusinessNameLine10SPARTANBURG COUNTY FOUNDATION
IRS990ScheduleI/RecipientTable/RecipientNameBusiness/BusinessNameLine11PRESBYTERIAN COLLEGE
IRS990ScheduleI/RecordsMaintained0false
IRS990/ScheduleJRequired0false
IRS990ScheduleO/GeneralExplanation/Explanation0TO INVEST FUNDS AND DONATE 7% OF THE NET FAIR MARKET VALUE OF THE TRUST ASSETS AS OF THE FIRST DAY OF EACH TAXABLE YEAR TO THE TRUST'S CHARITABLE BENEFICIARIES. TO BE PAID ANNUALLY ON THE LAST DAY OF THE TRUSTS FISCAL YEAR.
IRS990ScheduleO/GeneralExplanation/Explanation1NO REVIEW WAS OR WILL BE CONDUCTED.
IRS990ScheduleO/GeneralExplanation/Explanation2NO DOCUMENTS AVAILABLE TO THE PUBLIC
IRS990ScheduleO/GeneralExplanation/Identifier0ORGANIZATION'S MISSION
IRS990ScheduleO/GeneralExplanation/Identifier1ORGANIZATION'S PROCESS USED TO REVIEW FORM 990
IRS990ScheduleO/GeneralExplanation/Identifier2GOVERNING DOCUMENTS DISCLOSURE EXPLANATION
IRS990ScheduleO/GeneralExplanation/ReturnReference0FORM 990 - ORGANIZATION'S MISSION
IRS990ScheduleO/GeneralExplanation/ReturnReference1FORM 990, PAGE 6, PART VI, LINE 11B
IRS990ScheduleO/GeneralExplanation/ReturnReference2FORM 990, PAGE 6, PART VI, LINE 19
IRS990/ScheduleORequired0false
IRS990/School0false
IRS990/SignificantChange0false
IRS990/SignificantNewProgramServices0false
IRS990/StateLegalDomicile0SC
IRS990/SubjectToProxyTax0false
IRS990/TaxablePartyNotification0false
IRS990/TaxExemptBonds0false
IRS990/Terminated0false
IRS990/TermOrPermanentEndowments0false
IRS990/TheBooksAreInCareOf/AddressUS/AddressLine10PO BOX 1724
IRS990/TheBooksAreInCareOf/AddressUS/City0SPARTANBURG
IRS990/TheBooksAreInCareOf/AddressUS/State0SC
IRS990/TheBooksAreInCareOf/AddressUS/ZIPCode029304
IRS990/TheBooksAreInCareOf/NameBusiness/BusinessNameLine10COLONIAL TRUST CO INC
IRS990/TheBooksAreInCareOf/TelephoneNumber08645823356
IRS990/TotalAssets/BOY0472804
IRS990/TotalAssetsBOY0472804
IRS990/TotalAssets/EOY0450863
IRS990/TotalAssetsEOY0450863
IRS990/TotalCompGT150K0false
IRS990/TotalExpensesCurrentYear042438
IRS990/TotalExpensesPriorYear046350
IRS990/TotalFunctionalExpenses/Fundraising00
IRS990/TotalFunctionalExpenses/ManagementAndGeneral06036
IRS990/TotalFunctionalExpenses/ProgramServices036402
IRS990/TotalFunctionalExpenses/Total042438
IRS990/TotalFundrsngExpCurrentYear00
IRS990/TotalGrossUBI00
IRS990/TotalLiabilities/BOY00
IRS990/TotalLiabilities/EOY00
IRS990/TotalLiabilitiesEOY00
IRS990/TotalLiabNetAssetsFundBalances/BOY0472804
IRS990/TotalLiabNetAssetsFundBalances/EOY0450863
IRS990/TotalNbrEmployees00
IRS990/TotalNetAssetsFundBalances/BOY0472804
IRS990/TotalNetAssetsFundBalances/EOY0450863
IRS990/TotalOtherRevenue01456
IRS990/TotalProfFundrsngExpCY00
IRS990/TotalProgramServiceExpense036402
IRS990/TotalRevenueCurrentYear020497
IRS990/TotalRevenue/ExclusionAmount05
IRS990/TotalRevenuePriorYear0367
IRS990/TotalRevenue/RelatedOrExemptFunctionIncome020492
IRS990/TotalRevenue/TotalRevenueColumn020497
IRS990/TransfersToExemptNonChrtblOrg0false
IRS990/TypeOfOrganizationTrust0X
IRS990/UnrelatedBusinessIncome0false
IRS990/UnrestrictedNetAssets/BOY0472804
IRS990/UnrestrictedNetAssets/EOY0450863
IRS990/WhistleblowerPolicy0false
IRS990/YearFormation02004
ReturnHeader/BuildTS02016-02-25 16:41:14Z
ReturnHeader/Filer/EIN0576220347
ReturnHeader/Filer/Name/BusinessNameLine10ELLEN H HICKLIN CHARITABLE LEAD
ReturnHeader/Filer/Name/BusinessNameLine20UNITRUST
ReturnHeader/Filer/NameControl0ELLE
ReturnHeader/Filer/Phone08645823356
ReturnHeader/Filer/USAddress/AddressLine10P O BOX 1724
ReturnHeader/Filer/USAddress/City0SPARTANBURG
ReturnHeader/Filer/USAddress/State0SC
ReturnHeader/Filer/USAddress/ZIPCode029304
ReturnHeader/Officer/AuthorizeThirdParty0true
ReturnHeader/Officer/DateSigned02013-05-14
ReturnHeader/Officer/Name0COLONIAL TRUST COMPANY
ReturnHeader/Officer/Phone08645823356
ReturnHeader/Officer/Title0TRUSTEE
ReturnHeader/Preparer/DatePrepared02013-05-15
ReturnHeader/PreparerFirm/EIN0205063807
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10LEE BROOME MACBAY & ASSOCIATES LLC
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine10PO BOX 5476
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0SPARTANBURG
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0SC
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode0293045476
ReturnHeader/Preparer/Name0H DEAN LEE
ReturnHeader/Preparer/Phone08645743620
ReturnHeader/ReturnType0990
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-05-15T12:38:44-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
$450,863
Liabilities
$0
Net assets
$450,863
Revenue
-
Expenses
$42,438
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2013Detailed filing. Detailed filing data is available for this year.$4.48$0.00$4.48$0.41$0.44$0.03
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$4.51$0.00$4.51$0.42
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$4.73$0.00$4.73$0.46