Civic Intelligence

Unknown Organization

990PF • Fiscal year 2012 • EIN 37-6339916

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

18573 Pennington Road61081
Siviq Scores

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

Liabilities / Assets

92nd percentile

0.61x

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

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

61st percentile

5.0%

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

Assets

Up

$243,581

Up $11,665 (+5.0%) from 2011

Net Assets

Down

$93,979

Down $9,972 (-9.6%) from 2011

Liabilities

Up

$149,602

Up $21,637 (+17%) from 2011

Revenue

-

No earlier filing loaded for comparison.

Expenses

Flat

$7,210

Flat from 2011

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

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

$600K$400K$200K$0Assets 2010: $402,538Liabilities 2010: $259,178Net Assets 2010: $143,3602010Assets 2011: $231,916Liabilities 2011: $127,965Net Assets 2011: $103,9512011Assets 2012: $243,581Liabilities 2012: $149,602Net Assets 2012: $93,9792012Assets 2013: $235,834Liabilities 2013: $141,582Net Assets 2013: $94,2522013

Highlighted filing

2012

Assets$243,581
Liabilities$149,602
Net Assets$93,979

Operations Trend

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

$15K$10K$5.0K$0-$5.0KExpenses 2010: $13,1052010Expenses 2011: $7,2102011Expenses 2012: $7,2102012Revenue 2013: $3,634Expenses 2013: $7,344Net Income 2013: -$3,7102013

Highlighted filing

2012

Revenue-
Expenses$7,210
Net Income-
Jump To
Filing Snapshot
Filing Period
Jan 1, 2012 to Dec 31, 2012
Signed
Aug 13, 2013
Return Version
2012v2.0
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
CHRISTOPHER PROPHETERTrustee-$0--
NANCY E PASSINITrustee-$0--
FLORENCE L PROPHETERTrustee-$0--
Filing and Contact Details

Filer

EIN
37-6339916
Raw XML Appendix219 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/AnalysisIncomeProducingActy/DividendsAndIntFromSecPartVII/RelatedOrExemptFunctionIncome03366
IRS990PF/AnalysisIncomeProducingActy/GainSalesAssetsOthThanInvntry/RelatedOrExemptFunctionIncome0-9560
IRS990PF/AnalysisIncomeProducingActy/OtherInvestmentIncomePartVII/RelatedOrExemptFunctionIncome081
IRS990PF/AnalysisIncomeProducingActy/SubtotalsPartXVIA/RelatedOrExemptFunctionIncome0-6113
IRS990PF/AnalysisIncomeProducingActy/TotalPartXVIA0-6113
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncome03366
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidDsbrsChrtblPrps03000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidRevAndExpnss03000
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsAdjNetIncm03366
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncm03366
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnss03366
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessOfRevenueOverExpenses0-13323
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPrice0389846
IRS990PF/AnalysisOfRevenueAndExpenses/InterestRevAndExpnss04110
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAssetsRevAndExpnss0-9560
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncome03266
IRS990PF/AnalysisOfRevenueAndExpenses/NotRequiredToAttachScheduleB0X
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnss081
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncm0100
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnss0100
IRS990PF/AnalysisOfRevenueAndExpenses/TotalAdjustedNetIncome03366
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblPrps03000
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncm0100
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnss07210
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvestmentIncome03366
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevenueAndExpenses0-6113
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncm0100
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnss04210
IRS990PF/BalanceSheets/CapitalStockBOY061930
IRS990PF/BalanceSheets/CapitalStockEOY064930
IRS990PF/BalanceSheets/InvestmentsOtherBOY0231916
IRS990PF/BalanceSheets/InvestmentsOtherEOY0243581
IRS990PF/BalanceSheets/InvestmentsOtherEOYFMV0233580
IRS990PF/BalanceSheets/OrgThatDoNotFollowSFAS1170X
IRS990PF/BalanceSheets/OtherLiabilitiesBOY0127965
IRS990PF/BalanceSheets/OtherLiabilitiesEOY0149602
IRS990PF/BalanceSheets/RetainedEarningsBOY042021
IRS990PF/BalanceSheets/RetainedEarningsEOY029049
IRS990PF/BalanceSheets/TotalAssetsBOY0231916
IRS990PF/BalanceSheets/TotalAssetsEOY0243581
IRS990PF/BalanceSheets/TotalAssetsEOYFMV0233580
IRS990PF/BalanceSheets/TotalLiabilitiesBOY0127965
IRS990PF/BalanceSheets/TotalLiabilitiesEOY0149602
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsBOY0231916
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsEOY0243581
IRS990PF/BalanceSheets/TotalNetAssetsBOY0103951
IRS990PF/BalanceSheets/TotalNetAssetsEOY093979
IRS990PF/CapitalGainsAndLosses/CapitalGainNetIncome0-9213
IRS990PF/CapitalGainsAndLosses/NetShortTermCapitalGainOrLoss0-9243
IRS990PF/ChangesInNetAssetsFundBalances/ExcessOfRevenueOverExpenses0-13323
IRS990PF/ChangesInNetAssetsFundBalances/OtherIncreases03351
IRS990PF/ChangesInNetAssetsFundBalances/Subtotal093979
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesBOY0103951
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesEOY093979
IRS990PF/DistributableAmount/DistributableAmountAsAdjusted04071
IRS990PF/DistributableAmount/DistributableAmountBeforeAdj04071
IRS990PF/DistributableAmount/DistributableAmountBeforeDed04071
IRS990PF/DistributableAmount/MinimumInvestmentReturn04136
IRS990PF/DistributableAmount/TaxBasedOnInvestmentIncome065
IRS990PF/DistributableAmount/TotalTax065
IRS990PF/ExciseTaxBasedOnInvestmentIncm/InvestmentIncomeExciseTax065
IRS990PF/ExciseTaxBasedOnInvestmentIncm/Subtotal065
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxBasedOnInvestmentIncome065
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxDue065
IRS990PF/FMVAssetsEOY0233580
IRS990PF/InitialReturnFormerPublicChrty0X
IRS990PF/MethodOfAccountingAccrual0X
IRS990PF/MinimumInvestmentReturn/AcquisitionIndebtedness0149601
IRS990PF/MinimumInvestmentReturn/AdjTotalFMVOfUnusedAssets083979
IRS990PF/MinimumInvestmentReturn/AvgMonthlyCashBalances00
IRS990PF/MinimumInvestmentReturn/AvgMonthlyFMVOfSecurities0233580
IRS990PF/MinimumInvestmentReturn/CashDeemedCharitable01260
IRS990PF/MinimumInvestmentReturn/FMVAllOtherNoncharitableAssets00
IRS990PF/MinimumInvestmentReturn/MinimumInvestmentReturn04136
IRS990PF/MinimumInvestmentReturn/NetNoncharitableAssets082719
IRS990PF/MinimumInvestmentReturn/ReductionClaimed00
IRS990PF/MinimumInvestmentReturn/TotalFMVOfUnusedAssets0233580
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHghstPaidCntrctNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHighestPaidEmplNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition00.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition10.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition20.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation20
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName0CHRISTOPHER PROPHETER
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName1NANCY E PASSINI
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName2FLORENCE L PROPHETER
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title0Trustee
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title1Trustee
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title2Trustee
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine104843 SNAPJACK CIRCLE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine118007 BLUE BELL DRIVE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine121901 AVE G
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City0NAPERVILLE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City1WAUSAU
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City2STERLING
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State0IL
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State1WI
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State2IL
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode060564
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode154401
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode261081
IRS990PF/QualifyingDistributions/AdjQualifyingDistributions03000
IRS990PF/QualifyingDistributions/ExpensesAndContributions03000
IRS990PF/QualifyingDistributions/QualifyingDistributions03000
IRS990PF/StatementsRegardingActivities/ActivitiesNotPrevReported0false
IRS990PF/StatementsRegardingActivities/ApplicableInsuranceContract0false
IRS990PF/StatementsRegardingActivities/AtLeast5000InAssets0true
IRS990PF/StatementsRegardingActivities/BooksInCareOfBusinessName/BusinessNameLine10MICHAEL R PROBHETER
IRS990PF/StatementsRegardingActivities/BooksInCareOfPhoneNumber08156253077
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine1018573 PENNINGTON ROAD
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/City0STERLING
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/State0IL
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/ZIPCode061081
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/TerminationEtc0false
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/AppicationSubmissionInfo/FormAndInfoAndMaterials0WRITTEN REQUEST STATING USES THE FUNDS BEING REQUESTED WILL BE USED. MATERIAL TO SUPPORT PAST ENDEAVORS
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientName0BOB PROPHETER CONSTRUCTION LLC
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientPhoneNumber08156253077
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/AddressLine1018573 PENNINGTON RD
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/City0STERLING
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/State0IL
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/ZIPCode061081
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RestrictionsOnAwards0TO BE USED FOR THE STATED CHARITABLE PURPOSES OF THE ORIGINATION
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/SubmissionDeadlines0NONE
IRS990PF/TaxablePF0X
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/AppliedToCurrentYear080
IRS990PF/UndistributedIncome/AppliedToYear102920
IRS990PF/UndistributedIncome/DistributableAmountAsAdjusted04071
IRS990PF/UndistributedIncome/QualifyingDistributions03000
IRS990PF/UndistributedIncome/TreatedAsDistriFromCorpus00
IRS990PF/UndistributedIncome/UndistributedIncomeCY03991
IRS990PF/UndistributedIncome/UndistributedIncomePriorYear02920
OtherIncomeSchedule2/OtherIncome/Description0Other Investment Income
OtherIncomeSchedule2/OtherIncome/RevenueAndExpensesPerBooks081
OtherIncreasesSchedule/OtherIncreases/Amount03351
OtherIncreasesSchedule/OtherIncreases/Description0ASSET VALUE ADJUSTMENTS
OtherLiabilitiesSchedule/OtherLiabilities/BOYBookValue0127965
OtherLiabilitiesSchedule/OtherLiabilities/Description0Rounding
OtherLiabilitiesSchedule/OtherLiabilities/Description1MARGIN ACCOUNT LOAN
OtherLiabilitiesSchedule/OtherLiabilities/EOYBookValue01
OtherLiabilitiesSchedule/OtherLiabilities/EOYBookValue1149601
TaxesSchedule/Taxes/Amount0100
TaxesSchedule/Taxes/Category0FEES
TaxesSchedule/Taxes/NetInvestmentIncome0100
ReturnHeader/BuildTS02016-03-07 17:11:31Z
ReturnHeader/Filer/EIN0376339916
ReturnHeader/Filer/Name/BusinessNameLine10ROBERT PROPHETER & FLORENCE PROPHETER
ReturnHeader/Filer/NameControl0ROBE
ReturnHeader/Filer/USAddress/AddressLine1018573 PENNINGTON ROAD
ReturnHeader/Filer/USAddress/City0STERLING
ReturnHeader/Filer/USAddress/State0IL
ReturnHeader/Filer/USAddress/ZIPCode061081
ReturnHeader/Officer/AuthorizeThirdParty0true
ReturnHeader/Officer/DateSigned02013-08-13
ReturnHeader/Officer/Name0FLORENCE PROPHETER
ReturnHeader/Officer/Title0Trustee
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10TR CONSULTING
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine10470 Deer Chase
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0DIXON
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0IL
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode061021
ReturnHeader/Preparer/Name0JOE RUDOLPHI
ReturnHeader/Preparer/Phone08156317050
ReturnHeader/ReturnType0990PF
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-08-13T19:00:50-07:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings