Civic Intelligence

Unknown Organization

990PF • Fiscal year 2013 • EIN 83-0451380

Jan 01, 2013 to Dec 31, 2013 • Filed on Mar 07, 2014

7150 Fairhill Place28270

(704) 366-2893

Siviq Scores

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

Liabilities / Assets

69th percentile

0.02x

Higher debt load relative to assets than 69% of similar nonprofits.

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

Liabilities / Revenue

60th percentile

0.00x

Higher debt load relative to revenue than 60% of similar nonprofits.

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

Net Margin

35th percentile

-3.8%

Higher net margin than 35% of similar nonprofits.

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

Top Officer Pay

75th percentile

$0

Higher top officer pay than 75% of similar nonprofits.

Top officer pay equals 0.0% of source-year revenue.

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

Asset Growth

3rd percentile

-83%

Faster asset growth than 3% of similar nonprofits.

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

Revenue Growth

89th percentile

70%

Faster revenue growth than 89% of similar nonprofits.

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

Assets

Down

$55

Down $262 (-83%) from 2012

Net Assets

$55

No earlier filing loaded for comparison.

Liabilities

Up

$1

Up $1 from 2012

Revenue

Up

$6,854

Up $2,829 (+70%) from 2012

Expenses

Up

$7,116

Up $3,393 (+91%) from 2012

Net Income

Down

-$262

Down $564 (-187%) from 2012

Historical Trend

Balance Sheet Trend

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

$400$300$200$100$0Assets 2011: $15Liabilities 2011: $02011Assets 2012: $317Liabilities 2012: $02012Assets 2013: $55Liabilities 2013: $1Net Assets 2013: $552013Assets 2014: $21Liabilities 2014: $0Net Assets 2014: $212014

Highlighted filing

2013

Assets$55
Liabilities$1
Net Assets$55

Operations Trend

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

$8.0K$6.0K$4.0K$2.0K$0-$2.0KRevenue 2011: $3,022Expenses 2011: $3,030Net Income 2011: -$82011Revenue 2012: $4,025Expenses 2012: $3,723Net Income 2012: $3022012Revenue 2013: $6,854Expenses 2013: $7,116Net Income 2013: -$2622013Revenue 2014: $400Expenses 2014: $434Net Income 2014: -$342014

Highlighted filing

2013

Revenue$6,854
Expenses$7,116
Net Income-$262
Jump To
Filing Snapshot
Filing Period
Jan 1, 2013 to Dec 31, 2013
Signed
Mar 7, 2014
Return Version
2013v3.1
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
MARK S COLTRINPresident-$0--
SHERRY COLTRINVice Pres-$0--
LAURA COLTRINVice Pres-$0--
Filing and Contact Details

Filer

EIN
83-0451380
Phone
7043662893

Signing Officer

Name
Mark S Coltrin
Title
President
Phone
7043662893
Signed
2014-03-07

Preparer

Preparer
Mary G Langhorne
Phone
7046515290
Raw XML Appendix178 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
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt07116
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt06854
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-262
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt07116
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt06854
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-262
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt055
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0317
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt055
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt02
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt02
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt02
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt02
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/FMVAssetsEOYAmt055
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0317
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt055
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt0317
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt055
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt055
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0317
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt055
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt055
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0317
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt055
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0317
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt055
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt050
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt050
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt01
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt02
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt049
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt050
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0MARK S COLTRIN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1SHERRY COLTRIN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm2LAURA COLTRIN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0PRESIDENT
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1VICE PRES
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt2VICE PRES
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine107150 FAIRHILL PLACE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine117150 FAIRHILL PLACE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine127150 FAIRHILL PLACE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/City0CHARLOTTE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/City1CHARLOTTE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/City2CHARLOTTE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/State0NC
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/State1NC
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/State2NC
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCode028270
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCode128270
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCode228270
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt00
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0false
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0MARK S COLTRIN
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine107150 FAIRHILL PLACE
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/City0CHARLOTTE
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/State0NC
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCode0282702838
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PhoneNum07043662893
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0false
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt02
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt02
IRS990ScheduleB/ContributorInformationGrp/ContributorNum01
IRS990ScheduleB/ContributorInformationGrp/ContributorPersonNm0MARK S COLTRIN
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine107150 FAIRHILL PLACE
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/City0CHARLOTTE
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/State0NC
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCode028270
IRS990ScheduleB/ContributorInformationGrp/PersonContributionInd0X
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt06854
IRS990ScheduleB/GeneralRuleInd0X
IRS990ScheduleB/Organization501c3ExemptPFInd0X
ReturnHeader/BuildTS02015-12-30 17:16:21Z
ReturnHeader/BusinessOfficerGrp/PersonNm0MARK S COLTRIN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum07043662893
ReturnHeader/BusinessOfficerGrp/SignatureDt02014-03-07
ReturnHeader/Filer/BusinessName/BusinessNameLine10COLTRIN FAMILY FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0COLT
ReturnHeader/Filer/EIN0830451380
ReturnHeader/Filer/PhoneNum07043662893
ReturnHeader/Filer/USAddress/AddressLine107150 FAIRHILL PLACE
ReturnHeader/Filer/USAddress/City0CHARLOTTE
ReturnHeader/Filer/USAddress/State0NC
ReturnHeader/Filer/USAddress/ZIPCode028270
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine10MGL Financial LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1012118 Ulsten Ln
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/City0HUNTERSVILLE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/State0NC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCode028078
ReturnHeader/PreparerPersonGrp/PhoneNum07046515290
ReturnHeader/PreparerPersonGrp/PreparationDt02014-03-14
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0MARY G LANGHORNE
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02014-03-14T09:42:58-07:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02013-01-01
ReturnHeader/TaxPeriodEndDt02013-12-31
ReturnHeader/TaxYr02013

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings