Civic Intelligence

Unknown Organization

990 • Fiscal year 2013 • EIN 41-1355543

Feb 01, 2012 to Jan 31, 2013 • Filed on Dec 02, 2013

Organization ProfileN/A
1000 Nicollet Mall TPN-094555403
Siviq Scores

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

Liabilities / Assets

99th percentile

6.52x

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

2013 filings • 501(c)9 • $250M-$1B nonprofits • Source year 2013

Liabilities / Revenue

81st percentile

0.25x

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

2013 filings • 501(c)9 • $250M-$1B nonprofits • Source year 2013

Net Margin

23rd percentile

-2.4%

Higher net margin than 23% of similar nonprofits.

2013 filings • 501(c)9 • $250M-$1B nonprofits • Source year 2013

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2013

Asset Growth

1st percentile

-61%

Faster asset growth than 1% of similar nonprofits.

2013 filings • 501(c)9 • $250M-$1B nonprofits • Annualized from 2012 to 2013

Revenue Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2013

Balance Sheet
Liabilities / Assets99th percentile

Assets

Down

$31,218,362

Down $48,119,694 (-61%) from 2012

Net Assets

Down

-$172,209,661

Down $41,890,717 (-32%) from 2012

Liabilities

Down

$203,428,023

Down $6,228,977 (-3.0%) from 2012

Revenue And Expenses
Liabilities / Revenue81st percentileNet Margin23rd percentile

Revenue

$822,704,107

No earlier filing loaded for comparison.

Expenses

Up

$842,112,982

Up $16,573,167 (+2.0%) from 2012

Net Income

-$19,408,875

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth1st percentile

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

$300M$200M$100M$0-$100M-$200MAssets 2011: $71,102,901Liabilities 2011: $200,985,359Net Assets 2011: -$129,882,4582011Assets 2012: $79,338,056Liabilities 2012: $209,657,000Net Assets 2012: -$130,318,9442012Assets 2013: $31,218,362Liabilities 2013: $203,428,023Net Assets 2013: -$172,209,6612013Assets 2014: $0Liabilities 2014: $0Net Assets 2014: $02014

Highlighted filing

2013

Assets$31,218,362
Liabilities$203,428,023
Net Assets-$172,209,661
Open 2013 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$1.0B$500M$0-$500MExpenses 2011: $787,459,1002011Expenses 2012: $825,539,8152012Revenue 2013: $822,704,107Expenses 2013: $842,112,982Net Income 2013: -$19,408,8752013Revenue 2014: $828,869,122Expenses 2014: $825,505,856Net Income 2014: $3,363,2662014

Highlighted filing

2013

Revenue$822,704,107
Expenses$842,112,982
Net Income-$19,408,875
Open 2013 Filing
Jump To
Filing Snapshot
Filing Period
Feb 1, 2012 to Jan 31, 2013
Signed
Dec 2, 2013
Return Version
2012v2.1
Gross Receipts
$822,704,107
Mission and Program Overview

Mission

Provides medical, dental, life and long-term disability benefits to employees and retired employees.

Filing and Contact Details

Filer

EIN
41-1355543
Raw XML Appendix295 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/AccountantCompileOrReview00
IRS990/AccountsPayableAccruedExpenses/BOY0486556
IRS990/AccountsPayableAccruedExpenses/EOY03443946
IRS990/AccountsReceivable/BOY030819135
IRS990/AccountsReceivable/EOY026182324
IRS990/ActivitiesConductedPartnership00
IRS990/ActivityOrMissionDescription0Provides medical, dental, life & long-term disability benefits to employees & retired employees.
IRS990/AddressPrincipalOfficerUS/AddressLine101000 Nicollet Mall TPN-0945
IRS990/AddressPrincipalOfficerUS/City0Minneapolis
IRS990/AddressPrincipalOfficerUS/State0MN
IRS990/AddressPrincipalOfficerUS/ZIPCode055403
IRS990/AuditCommittee01
IRS990/BenefitsPaidToMembersCY0726341482
IRS990/BenefitsPaidToMembersPriorYear0653513210
IRS990/BenefitsToMembers/Total0726341482
IRS990/BsnssRltnshpThruFamilyMember00
IRS990/BsnssRltnshpWithOrganization00
IRS990/CapStckTrstPrinCurrentFunds/BOY00
IRS990/CapStckTrstPrinCurrentFunds/EOY00
IRS990/CashNonInterestBearing/BOY01703000
IRS990/CashNonInterestBearing/EOY01829000
IRS990/ChangesToOrganizingDocs00
IRS990/CollectionsOfArt00
IRS990/CompCurrentOfficersDirectors/Total06141
IRS990/CompensationFromOtherSources00
IRS990/CompensationProcessCEO00
IRS990/CompensationProcessOther00
IRS990/ConflictOfInterestPolicy00
IRS990/ConservationEasements00
IRS990/ConsolidatedAuditFinancialStmt00
IRS990/ContributionsGrantsCurrentYear00
IRS990/ContributionsGrantsPriorYear00
IRS990/CreditCounseling00
IRS990/DecisionsSubjectToApproval00
IRS990/DeductibleContributionsOfArt00
IRS990/DeductibleNonCashContributions00
IRS990/DelegationOfManagementDuties00
IRS990/DescribedIn501C300
IRS990/Description0Effective February 1, 2005, The Target Corporation comprehensive Medical Plan, The Target Corporation HMO Plan, The Target Corporation Group Life Insurance Plan, The Target Corporation Dental Plan, The Target Corporation Long-Term Disability Plan - Exempt, and the Target Corporation Long-Term Disability Plan - Non-Exempt were merged to create The Target Corporation Employee Umbrella Trusteed Benefit Plan (The Plan). The Plan generally covers eligible employees and retirees of Target Corporation (the Plan Sponsor) and its wholly owned subsidiaries (the Companies).The Plan provides medical, dental, life and long-term disability benefits to eligible employees and eligible retired employees of the Companies. Eligibility is determined on the basis of position and/or hours worked or scheduled per week, depending on the operating company, after a specified length of service. Specific plan designs vary somewhat among companies. Benefits provided under the Plan are provided through both self-insured and fully insured benefit arrangements. The Plan is subject to the provisions of the Employee Retirement Income Security Act of 1974 (ERISA), as amended.Employees, retirees and the Companies share in the cost of the Plan. Employee contributions are based on rates determined in advance of the plan year in accordance with the historical claims experience and expected future claims experience. The Plan's excess of benefit obligations over net assets available for benefits at January 31, 2013, is expected to be funded by the Companies' and participants' contributions under the plan agreement.There are 197,460 participants in the plan.
IRS990/DisregardedEntity00
IRS990/DocumentRetentionPolicy00
IRS990/DonorAdvisedFunds00
IRS990/DoNotFollowSFAS1170X
IRS990/ElectionOfBoardMembers00
IRS990/FamilyOrBusinessRelationship00
IRS990/FederalGrantAuditRequired00
IRS990/FeesForServicesAccounting/Total092500
IRS990/ForeignActivities00
IRS990/ForeignFinancialAccount00
IRS990/ForeignOffice00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek01.00
IRS990/Form990PartVIISectionA/InstitutionalTrustee0X
IRS990/Form990PartVIISectionA/NamePerson0State Street Bank and Trust Company
IRS990/Form990PartVIISectionA/OtherCompensation00
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization06141
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs00
IRS990/Form990PartVIISectionA/Title0Trustee
IRS990/Form990ProvidedToGoverningBody00
IRS990/FormersListed00
IRS990/FSAudited01
IRS990/FSAuditedBasis/FinancialStatementSeparate0X
IRS990/FundraisingActivities00
IRS990/Gaming00
IRS990/GrantsAndSimilarAmntsCY00
IRS990/GrantsAndSimilarAmntsPriorYear00
IRS990/GrantsToIndividuals00
IRS990/GrantsToOrganizations00
IRS990/GrantToRelatedPerson00
IRS990/GrossReceipts0822704107
IRS990/GroupReturnForAffiliates00
IRS990/Hospital00
IRS990/IndependentAuditFinancialStmt01
IRS990/IndoorTanningServices00
IRS990/InfoInScheduleOPartIII0X
IRS990/InfoInScheduleOPartVI0X
IRS990/InfoInScheduleOPartX0X
IRS990/InfoInScheduleOPartXI0X
IRS990/InvestmentIncomeCurrentYear084
IRS990/InvestmentIncome/ExclusionAmount084
IRS990/InvestmentIncomePriorYear0471
IRS990/InvestmentIncome/TotalRevenueColumn084
IRS990/InvestmentInJointVenture00
IRS990/InvestmentsPubTradedSecurities/BOY06907096
IRS990/InvestmentsPubTradedSecurities/EOY03111974
IRS990/LoanToOfficerOrDQP00
IRS990/LocalChapters00
IRS990/MaterialDiversionOrMisuse00
IRS990/MembersOrStockholders00
IRS990/MethodOfAccountingAccrual0X
IRS990/MinutesOfCommittees01
IRS990/MinutesOfGoverningBody01
IRS990/MissionDescription0Provides medical, dental, life and long-term disability benefits to employees and retired employees.
IRS990/MoreThan5000KToIndividuals00
IRS990/MoreThan5000KToOrganizations00
IRS990/NameOfPrincipalOfficerPerson0Jeffery V Bailey
IRS990/NbrIndependentVotingMembers00
IRS990/NbrVotingGoverningBodyMembers01
IRS990/NbrVotingMembersGoverningBody01
IRS990/NetAssetsOrFundBalancesBOY0-130318944
IRS990/NetAssetsOrFundBalancesEOY0-172209661
IRS990/NetUnrelatedBusinessTxblIncome00
IRS990/NonDeductibleContributions00
IRS990/NumberFormsTransmittedWith109600
IRS990/NumberIndependentVotingMembers00
IRS990/NumberIndividualsGT100K00
IRS990/NumberOfContractorsGT100K00
IRS990/NumberOfEmployees00
IRS990/NumberW2GIncluded00
IRS990/OfficerEntityWithBsnssRltnshp00
IRS990/OfficerMailingAddress01
IRS990/Organization501c0X
IRS990/OtherExpensePriorYear0172026605
IRS990/OtherExpensesCurrentYear0115765359
IRS990/OtherExpenses/Description0Administrative Fees
IRS990/OtherExpenses/Description1Premium Expenses
IRS990/OtherExpenses/Total070296244
IRS990/OtherExpenses/Total145376615
IRS990/OtherLiabilities/BOY0177502435
IRS990/OtherLiabilities/EOY0199984077
IRS990/OtherRevenueCurrentYear00
IRS990/OtherRevenuePriorYear00
IRS990/PaidInCapSrplsLandBldgEqpFund/BOY00
IRS990/PaidInCapSrplsLandBldgEqpFund/EOY00
IRS990/PartialLiquidation00
IRS990/PoliticalActivities00
IRS990/PrepaidExpensesDeferredCharges/BOY08240816
IRS990/PrepaidExpensesDeferredCharges/EOY095064
IRS990/ProfessionalFundraising00
IRS990/ProgramServiceRevenue/BusinessCode0525100
IRS990/ProgramServiceRevenueCY0822704023
IRS990/ProgramServiceRevenue/Description0Premiums
IRS990/ProgramServiceRevenue/ExclusionAmount0822704023
IRS990/ProgramServiceRevenuePriorYear0834702806
IRS990/ProgramServiceRevenue/TotalRevenueColumn0822704023
IRS990/ProhibitedTaxShelterTrans00
IRS990/ReconcilationOtherChanges0-22481842
IRS990/ReconcilationRevenueExpenses0-19408875
IRS990/RelatedEntity01
IRS990/RelatedOrgControlledEntity00
IRS990/ReportFin48Footnote00
IRS990/ReportInvestOthSecurities00
IRS990/ReportLandBldgEquip00
IRS990/ReportOtherAssets00
IRS990/ReportOtherLiabilities01
IRS990/ReportProgRelInvest00
IRS990/RetainedEarningsEndowmentEtc/BOY0-130318944
IRS990/RetainedEarningsEndowmentEtc/EOY0-172209661
IRS990/RevenuesLessExpensesCY0-19408875
IRS990/RevenuesLessExpensesPriorYear09163462
IRS990/SalariesEtcCurrentYear06141
IRS990/SalariesEtcPriorYear00
IRS990/ScheduleBRequired00
IRS990ScheduleD/ExpensesNotRptdF99000
IRS990ScheduleD/ExpensesNotRptdOnFinStmt00
IRS990ScheduleD/ExpensesSubtotal0842112982
IRS990ScheduleD/OtherLiabilities/Amount084711077
IRS990ScheduleD/OtherLiabilities/Amount18982000
IRS990ScheduleD/OtherLiabilities/Amount222995000
IRS990ScheduleD/OtherLiabilities/Amount383296000
IRS990ScheduleD/OtherLiabilities/Description0Claims Incurred but not Reported
IRS990ScheduleD/OtherLiabilities/Description1Retirees
IRS990ScheduleD/OtherLiabilities/Description2Fully Eligible Active Plan Participants
IRS990ScheduleD/OtherLiabilities/Description3Other Active Plan Participants
IRS990ScheduleD/RevenueNotRptdF99000
IRS990ScheduleD/RevenueNotRptdOnFinStmt00
IRS990ScheduleD/RevenueSubtotal0822704107
IRS990ScheduleD/TotalExpensesPerForm9900842112982
IRS990ScheduleD/TotalOfAmounts0199984077
IRS990ScheduleD/TotalOfBookValueLandBuildings00
IRS990ScheduleD/TotalRevenuePerForm9900822704107
IRS990ScheduleD/TotExpensesEtcAuditedFinclStmt0842112982
IRS990ScheduleD/TotRevenueEtcAuditedFinclStmt0822704107
IRS990/ScheduleJRequired00
IRS990ScheduleO/GeneralExplanation/Explanation0The Form 990 is prepared by Deloitte and reviewed by Deloitte and representatives of the Target Corporation Income Tax Department. The answers to certain questions are reviewed with representatives of the Target Corporation legal and human resources departments both before and after the filing of the Form 990 to ensure that complete and accurate information is provided.
IRS990ScheduleO/GeneralExplanation/Explanation1Plan documents available to plan participants as required by ERISA.
IRS990ScheduleO/GeneralExplanation/Explanation2State Street Bank and Trust Company - One Enterprise Drive, North Quincy, MA 02171.
IRS990ScheduleO/GeneralExplanation/Explanation3The audited financial statements for the year ended January 31, 2012 have been restated to correct an error in the accounting for certain benefit obligations of the Plan. The assets at the beginning of the year in Part X have been adjusted to match the restated audited financial statements. In addition, the prior year details included on Form 990, Part 1, have been adjusted to match the restated audited financial statements.
IRS990ScheduleO/GeneralExplanation/Explanation4Benefit Obligation Adjustment -22,481,842.
IRS990ScheduleO/GeneralExplanation/Identifier0Contact Addresses for Officers, Directors, Etc
IRS990ScheduleO/GeneralExplanation/Identifier1Changes in Net Assets or Fund Balances:
IRS990ScheduleO/GeneralExplanation/ReturnReference0Form 990, Part VI, Section B, line 11
IRS990ScheduleO/GeneralExplanation/ReturnReference1Form 990, Part VI, Section C, line 19
IRS990ScheduleO/GeneralExplanation/ReturnReference2Form 990, Part VII
IRS990ScheduleO/GeneralExplanation/ReturnReference3Form 990, Part X Change in the Audited Financial Statements:
IRS990ScheduleO/GeneralExplanation/ReturnReference4Form 990, Part XI, line 9:
IRS990/ScheduleORequired01
IRS990ScheduleR/DividendsRelatedOrganization00
IRS990ScheduleR/ExchangeOfAssets00
IRS990ScheduleR/Form990ScheduleRPartIV/AddressUS/AddressLine101000 Nicollet Mall
IRS990ScheduleR/Form990ScheduleRPartIV/AddressUS/City0Minneapolis
IRS990ScheduleR/Form990ScheduleRPartIV/AddressUS/State0MN
IRS990ScheduleR/Form990ScheduleRPartIV/AddressUS/ZIPCode055403
IRS990ScheduleR/Form990ScheduleRPartIV/ControlledOrg00
IRS990ScheduleR/Form990ScheduleRPartIV/EIN0410215170
IRS990ScheduleR/Form990ScheduleRPartIV/LegalDomicileState0MN
IRS990ScheduleR/Form990ScheduleRPartIV/NameOfRelatedOrg/BusinessNameLine10Target Corporation
IRS990ScheduleR/Form990ScheduleRPartIV/PrimaryActivity0Retail
IRS990ScheduleR/Form990ScheduleRPartIV/TypeOfEntity0C
IRS990ScheduleR/GiftGrantOrCapContrFrOtherOrg00
IRS990ScheduleR/GiftGrantOrCapContrToOtherOrg00
IRS990ScheduleR/LoansOrGuaranteesFromOtherOrg00
IRS990ScheduleR/LoansOrGuaranteesToOtherOrg00
IRS990ScheduleR/OtherTransferFromOtherOrg01
IRS990ScheduleR/OtherTransferToOtherOrg00
IRS990ScheduleR/PerformOfServicesByOtherOrgs00
IRS990ScheduleR/PerformOfServicesForOtherOrgs00
IRS990ScheduleR/PurchaseOfAssetsFromOtherOrg00
IRS990ScheduleR/ReceiptOfIntAnnRentsRoyalties00
IRS990ScheduleR/ReimbursementPaidByOtherOrg00
IRS990ScheduleR/ReimbursementPaidToOtherOrg00
IRS990ScheduleR/RentalOfFacilitiesFrOtherOrgs00
IRS990ScheduleR/RentalOfFacilitiesToOtherOrgs00
IRS990ScheduleR/SaleOfAssetsToOtherOrg00
IRS990ScheduleR/SharingOfFacilities00
IRS990ScheduleR/SharingOfPaidEmployees00
IRS990/School00
IRS990/SignificantChange00
IRS990/SignificantNewProgramServices00
IRS990/StateLegalDomicile0MN
IRS990/SubjectToProxyTax00
IRS990/TaxablePartyNotification00
IRS990/TaxExemptBonds00
IRS990/Terminated00
IRS990/TermOrPermanentEndowments00
IRS990/TheBooksAreInCareOf/AddressUS/AddressLine101000 Nicollet MallTPN-0945
IRS990/TheBooksAreInCareOf/AddressUS/City0Minneapolis
IRS990/TheBooksAreInCareOf/AddressUS/State0MN
IRS990/TheBooksAreInCareOf/AddressUS/ZIPCode055403
IRS990/TheBooksAreInCareOf/NameBusiness/BusinessNameLine10Target Corporation Income Tax Department
IRS990/TheBooksAreInCareOf/TelephoneNumber06127619212
IRS990/TotalAssets/BOY047670047
IRS990/TotalAssetsBOY047670047
IRS990/TotalAssets/EOY031218362
IRS990/TotalAssetsEOY031218362
IRS990/TotalCompGT150K00
IRS990/TotalExpensesCurrentYear0842112982
IRS990/TotalExpensesPriorYear0825539815
IRS990/TotalFunctionalExpenses/Total0842112982
IRS990/TotalFundrsngExpCurrentYear00
IRS990/TotalGrossUBI00
IRS990/TotalLiabilities/BOY0177988991
IRS990/TotalLiabilitiesBOY0177988991
IRS990/TotalLiabilities/EOY0203428023
IRS990/TotalLiabilitiesEOY0203428023
IRS990/TotalLiabNetAssetsFundBalances/BOY047670047
IRS990/TotalLiabNetAssetsFundBalances/EOY031218362
IRS990/TotalNbrEmployees00
IRS990/TotalNbrVolunteers00
IRS990/TotalNetAssetsFundBalances/BOY0-130318944
IRS990/TotalNetAssetsFundBalances/EOY0-172209661
IRS990/TotalOtherCompensation00
IRS990/TotalProfFundrsngExpCY00
IRS990/TotalProfFundrsngExpPriorYear00
IRS990/TotalProgramServiceRevenue0822704023
IRS990/TotalReportableCompFrmRltdOrgs00
IRS990/TotalReportableCompFromOrg06141
IRS990/TotalRevenueCurrentYear0822704107
IRS990/TotalRevenue/ExclusionAmount0822704107
IRS990/TotalRevenuePriorYear0834703277
IRS990/TotalRevenue/RelatedOrExemptFunctionIncome00
IRS990/TotalRevenue/TotalRevenueColumn0822704107
IRS990/TotalRevenue/UnrelatedBusinessRevenue00
IRS990/TypeOfOrganizationTrust0X
IRS990/UnrelatedBusinessIncome00
IRS990/UponRequest0X
IRS990/WebSite0N/A
IRS990/WhistleblowerPolicy00
IRS990/YearFormation02005
ReturnHeader/BuildTS02015-11-30 17:44:51Z
ReturnHeader/Filer/EIN0411355543
ReturnHeader/Filer/Name/BusinessNameLine10Target Corporation Employee Benefit Trust
ReturnHeader/Filer/NameControl0TARG
ReturnHeader/Filer/Phone06127619212
ReturnHeader/Filer/USAddress/AddressLine101000 Nicollet Mall TPN-0945
ReturnHeader/Filer/USAddress/City0Minneapolis
ReturnHeader/Filer/USAddress/State0MN
ReturnHeader/Filer/USAddress/ZIPCode055403
ReturnHeader/Officer/AuthorizeThirdParty01
ReturnHeader/Officer/DateSigned02013-12-02
ReturnHeader/Officer/Name0Jeffery V Bailey
ReturnHeader/Officer/Phone06127619212
ReturnHeader/Officer/Title0Director, Fin Benefits & Analysis
ReturnHeader/PreparerFirm/EIN0861065772
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10Deloitte Tax LLP
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine1050 South Sixth Street
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0Minneapolis
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0MN
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode0554021538
ReturnHeader/Preparer/Name0Kristina Rasmussen
ReturnHeader/Preparer/Phone06123974000
ReturnHeader/ReturnType0990
ReturnHeader/TaxPeriodBeginDate02012-02-01
ReturnHeader/TaxPeriodEndDate02013-01-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-12-09T17:12:08-06:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$31,218,362
Liabilities
$203,428,023
Net assets
-$172,209,661
Revenue
$822,704,107
Expenses
$842,112,982
Net income
-$19,408,875
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2014Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$829$826$3.36
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$31.2$203$172$823$842$19.4
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$79.3$210$130$826
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$71.1$201$130$787