Civic Intelligence

Sequent Employee Benefit Trust (Veba)

990 • Fiscal year 2010 • EIN 31-1732659

Jul 01, 2009 to Jun 30, 2010 • Filed on May 05, 2011

Organization ProfileN/A

View Organization Page

4700 Lakehurst Court43016
Siviq Scores

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

Liabilities / Assets

98th percentile

1.35x

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

2010 filings • 501(c)9 • $10M-$25M nonprofits • Source year 2010

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2010

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2010

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2010

Asset Growth

Score unavailable

No value available

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

Source year 2010

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / Assets98th percentile

Assets

$1,420,005

No earlier filing loaded for comparison.

Net Assets

-$492,315

No earlier filing loaded for comparison.

Liabilities

$1,912,320

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

$20,812,995

No earlier filing loaded for comparison.

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset GrowthScore unavailable

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

$6.0M$4.0M$2.0M$0-$2.0MAssets 2010: $1,420,005Liabilities 2010: $1,912,320Net Assets 2010: -$492,3152010Assets 2011: $1,024,355Liabilities 2011: $116,591Net Assets 2011: $907,7642011Assets 2012: $374,965Liabilities 2012: $35,861Net Assets 2012: $339,1042012Assets 2013: $1,749,887Liabilities 2013: $941,829Net Assets 2013: $808,0582013Assets 2016: $2,887,492Liabilities 2016: $1,696,172Net Assets 2016: $1,191,3202016Assets 2017: $3,271,783Liabilities 2017: $2,403,095Net Assets 2017: $868,6882017Assets 2018: $4,245,637Liabilities 2018: $3,411,803Net Assets 2018: $833,8342018Assets 2019: $1,806,436Liabilities 2019: $947,133Net Assets 2019: $859,3032019Assets 2020: $0Liabilities 2020: $0Net Assets 2020: $02020

Highlighted filing

2010

Assets$1,420,005
Liabilities$1,912,320
Net Assets-$492,315
Open 2010 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$30M$20M$10M$0-$10MExpenses 2010: $20,812,9952010Expenses 2011: $12,548,2452011Expenses 2012: $13,278,8882012Expenses 2013: $12,420,4152013Revenue 2016: $13,975,950Expenses 2016: $14,307,279Net Income 2016: -$331,3292016Revenue 2017: $15,854,029Expenses 2017: $16,134,160Net Income 2017: -$280,1312017Revenue 2018: $16,261,439Expenses 2018: $16,296,293Net Income 2018: -$34,8542018Revenue 2019: $25,469Expenses 2019: $0Net Income 2019: $25,4692019Revenue 2020: $0Expenses 2020: $859,303Net Income 2020: -$859,3032020

Highlighted filing

2010

Revenue-
Expenses$20,812,995
Net Income-
Open 2010 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2009 to Jun 30, 2010
Signed
May 5, 2011
Return Version
2009v1.7
Gross Receipts
$21,135,653
Mission and Program Overview

Mission

Administers a multi-employer employee benefit plan

Filing and Contact Details

Filer

EIN
31-1732659
Raw XML Appendix283 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/BOY061879
IRS990/AccountsPayableAccruedExpenses/EOY061605
IRS990/AccountsReceivable/BOY0174580
IRS990/AccountsReceivable/EOY0383331
IRS990/ActivitiesConductedPartnership00
IRS990/ActivityOrMissionDescription0Health And Welfare BENEFIT PLAN
IRS990/AddressPrincipalOfficerUS/AddressLine104700 LAKEHURST COURT
IRS990/AddressPrincipalOfficerUS/City0DUBLIN
IRS990/AddressPrincipalOfficerUS/State0OH
IRS990/AddressPrincipalOfficerUS/ZIPCode043016
IRS990/Advertising/Total0121742
IRS990/AllOtherExpenses/Total0651
IRS990/AuditCommittee00
IRS990/BalanceSheetAmountsReported01
IRS990/BenefitsPaidToMembersCY020007363
IRS990/BenefitsPaidToMembersPriorYear025669803
IRS990/BenefitsToMembers/Total020007363
IRS990/BsnssRltnshpThruFamilyMember00
IRS990/BsnssRltnshpWithOrganization00
IRS990/CapStckTrstPrinCurrentFunds/BOY0162435
IRS990/CapStckTrstPrinCurrentFunds/EOY0162435
IRS990/ChangesToOrganizingDocs00
IRS990/CollectionsOfArt00
IRS990/CompensationFromOtherSources00
IRS990/CompensationProcessCEO00
IRS990/CompensationProcessOther00
IRS990/ConflictOfInterestPolicy00
IRS990/ConservationEasements00
IRS990/ConsolidatedAuditFinancialStmt00
IRS990/ContributionsGrantsCurrentYear00
IRS990/CreditCounseling00
IRS990/DecisionsSubjectToApproval00
IRS990/DeductibleContributionsOfArt00
IRS990/DeductibleNonCashContributions00
IRS990/DelegationOfManagementDuties00
IRS990/DescribedIn501C300
IRS990/Description0ADMINISTERED MULTIPLE EMPLOYEE BENEFIT PROGRAMS FOR AN ESTIMATED 2,547 FULL-TIME EMPLOYEES, AT APPROXIMATELY 317 WORKSITES. THE TOTAL NUMBER OF INSURED INDIVIDUALS IS CLOSE TO 3,745.
IRS990/DisregardedEntity00
IRS990/DocumentRetentionPolicy00
IRS990/DonorAdvisedFunds00
IRS990/DoNotFollowSFAS1170X
IRS990/ElectionOfBoardMembers00
IRS990/FamilyOrBusinessRelationship00
IRS990/FederalGrantAuditRequired00
IRS990/FeesForServicesAccounting/Total030720
IRS990/FeesForServicesLegal/Total053686
IRS990/FeesForServicesOther/Total0250895
IRS990/FinancialStatementSeparate0X
IRS990/ForeignActivities00
IRS990/ForeignFinancialAccount00
IRS990/ForeignOffice00
IRS990/Form8282PropertyDisposedOf00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek040.00
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector0X
IRS990/Form990PartVIISectionA/NamePerson0CHRISTIAN M MATZ
IRS990/Form990PartVIISectionA/OtherCompensation00
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization00
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs094654
IRS990/Form990PartVIISectionA/Title0TRUSTEE
IRS990/Form990ProvidedToGoverningBody01
IRS990/FormersListed00
IRS990/FSAudited01
IRS990/FundraisingActivities00
IRS990/Gaming00
IRS990/GrantsAndSimilarAmntsCY00
IRS990/GrantsToIndividuals00
IRS990/GrantsToOrganizations00
IRS990/GrantToRelatedPerson00
IRS990/GrossReceipts021135653
IRS990/GroupReturnForAffiliates00
IRS990/Hospital00
IRS990/IndependentAuditFinancialStmt01
IRS990/InformationTechnology/Total0679
IRS990/InvestmentIncomeCurrentYear0447
IRS990/InvestmentIncomePriorYear03673
IRS990/InvestmentIncome/RelatedOrExemptFunctionIncome0447
IRS990/InvestmentIncome/TotalRevenueColumn0447
IRS990/InvestmentInJointVenture00
IRS990/LoanToOfficerOrDQP00
IRS990/LocalChapters00
IRS990/MaterialDiversionOrMisuse00
IRS990/MembersOrStockholders00
IRS990/MethodOfAccountingAccrual0X
IRS990/MinutesOfCommittees01
IRS990/MinutesOfGoverningBody01
IRS990/MissionDescription0PROVIDING PREMIUM PAYMENTS FOR EMPLOYEE BENEFIT PLANS.
IRS990/MoreThan5000KToIndividuals00
IRS990/MoreThan5000KToOrganizations00
IRS990/MortNotesPyblSecuredInvestProp/BOY0949756
IRS990/MortNotesPyblSecuredInvestProp/EOY0651576
IRS990/NameOfPrincipalOfficerPerson0CHRISTIAN M MATZ
IRS990/NbrIndependentVotingMembers01
IRS990/NbrVotingGoverningBodyMembers01
IRS990/NbrVotingMembersGoverningBody01
IRS990/NetAssetsOrFundBalancesBOY0-814973
IRS990/NetAssetsOrFundBalancesEOY0-492315
IRS990/NetUnrelatedBusinessTxblIncome00
IRS990/NonDeductibleContributions00
IRS990/NumberFormsTransmittedWith109600
IRS990/NumberIndependentVotingMembers01
IRS990/NumberIndividualsGT100K00
IRS990/NumberOfContractorsGT100K00
IRS990/NumberOfEmployees00
IRS990/NumberW2GIncluded00
IRS990/OfficeExpenses/Total031730
IRS990/OfficerEntityWithBsnssRltnshp00
IRS990/OfficerMailingAddress00
IRS990/Organization501c0X
IRS990/OtherExpensePriorYear0650255
IRS990/OtherExpensesCurrentYear0805632
IRS990/OtherExpenses/Description0CONTRACT CHARGES - SEQU
IRS990/OtherExpenses/Description1OFFICE EQUIPMENT - LEAS
IRS990/OtherExpenses/Description2EMPLOYEE TRAINING
IRS990/OtherExpenses/Description3BANK CHARGES
IRS990/OtherExpenses/Description4DUES AND SUBSCRIPTIONS
IRS990/OtherExpenses/Total0299903
IRS990/OtherExpenses/Total15956
IRS990/OtherExpenses/Total24050
IRS990/OtherExpenses/Total33843
IRS990/OtherExpenses/Total41777
IRS990/OtherLiabilities/BOY00
IRS990/OtherLiabilities/EOY01199139
IRS990/OtherRevenueCurrentYear00
IRS990/PaidInCapSrplsLandBldgEqpFund/BOY00
IRS990/PaidInCapSrplsLandBldgEqpFund/EOY00
IRS990/PartialLiquidation00
IRS990/PoliticalActivities00
IRS990/ProfessionalFundraising00
IRS990/ProgramServiceRevenue/BusinessCode0525100
IRS990/ProgramServiceRevenueCY021135206
IRS990/ProgramServiceRevenue/Description0EMPLOYEE AND EMPLOYER
IRS990/ProgramServiceRevenuePriorYear026944688
IRS990/ProgramServiceRevenue/RelatedOrExemptFunctionIncome021135206
IRS990/ProgramServiceRevenue/TotalRevenueColumn021135206
IRS990/ProhibitedTaxShelterTrans00
IRS990/QuidProQuoContributions00
IRS990/RelatedEntity01
IRS990/RelatedOrgControlledEntity00
IRS990/RetainedEarningsEndowmentEtc/BOY0-977408
IRS990/RetainedEarningsEndowmentEtc/EOY0-654750
IRS990/RevenuesLessExpensesCY0322658
IRS990/RevenuesLessExpensesPriorYear0628303
IRS990/SalariesEtcCurrentYear00
IRS990/SavingsAndTempCashInvestments/BOY022082
IRS990/SavingsAndTempCashInvestments/EOY01036674
IRS990/ScheduleBRequired00
IRS990ScheduleD/ExcessOrDeficitForYear0322658
IRS990ScheduleD/ExcessOrDeficitPerFS0322658
IRS990ScheduleD/ExpensesNotRptdF99000
IRS990ScheduleD/ExpensesNotRptdOnFinStmt00
IRS990ScheduleD/ExpensesSubtotal020812995
IRS990ScheduleD/OtherLiabilities/Amount01199139
IRS990ScheduleD/OtherLiabilities/Description0accrued insurance premium expense
IRS990ScheduleD/RevenueNotRptdF99000
IRS990ScheduleD/RevenueNotRptdOnFinStmt00
IRS990ScheduleD/RevenueSubtotal021135653
IRS990ScheduleD/TotalAdjustments00
IRS990ScheduleD/TotalExpenses020812995
IRS990ScheduleD/TotalExpensesPerForm990020812995
IRS990ScheduleD/TotalOfAmounts01199139
IRS990ScheduleD/TotalOfBookValueLandBuildings00
IRS990ScheduleD/TotalRevenue021135653
IRS990ScheduleD/TotalRevenuePerForm990021135653
IRS990ScheduleD/TotExpensesEtcAuditedFinclStmt020812995
IRS990ScheduleD/TotRevenueEtcAuditedFinclStmt021135653
IRS990/ScheduleJRequired00
IRS990ScheduleO/GeneralExplanation/Explanation0THE FORM 990 IS REVIEWED BY THE TRUSTEE BEFORE BEING FILED.
IRS990ScheduleO/GeneralExplanation/Explanation1THESE DOCUMENTS ARE MADE AVAILABLE UPON REQUEST.
IRS990ScheduleO/GeneralExplanation/Identifier0Form 990, Part VI, Section B, line 11
IRS990ScheduleO/GeneralExplanation/Identifier1Form 990, Part VI, Section C, line 19
IRS990/ScheduleORequired01
IRS990ScheduleR/ExchangeOfAssets00
IRS990ScheduleR/Form990ScheduleRPartIV/AddressUS/AddressLine104700 LAKEHURST COURT
IRS990ScheduleR/Form990ScheduleRPartIV/AddressUS/City0DUBLIN
IRS990ScheduleR/Form990ScheduleRPartIV/AddressUS/State0OH
IRS990ScheduleR/Form990ScheduleRPartIV/AddressUS/ZIPCode043016
IRS990ScheduleR/Form990ScheduleRPartIV/EIN0311428576
IRS990ScheduleR/Form990ScheduleRPartIV/LegalDomicileState0OH
IRS990ScheduleR/Form990ScheduleRPartIV/NameOfRelatedOrg/BusinessNameLine10SEQUENT INC
IRS990ScheduleR/Form990ScheduleRPartIV/PrimaryActivity0Employer Services
IRS990ScheduleR/Form990ScheduleRPartIV/TypeOfEntity0C
IRS990ScheduleR/GiftGrantOrCapContrFrOtherOrg00
IRS990ScheduleR/GiftGrantOrCapContrToOtherOrg00
IRS990ScheduleR/LoansOrGuaranteesFromOtherOrg01
IRS990ScheduleR/LoansOrGuaranteesToOtherOrg00
IRS990ScheduleR/OtherTransferFromOtherOrg00
IRS990ScheduleR/OtherTransferToOtherOrg00
IRS990ScheduleR/PerformOfServicesByOtherOrgs00
IRS990ScheduleR/PerformOfServicesForOtherOrgs00
IRS990ScheduleR/PurchaseOfAssetsFromOtherOrg00
IRS990ScheduleR/ReceiptOfIntAnnRentsRoyalties00
IRS990ScheduleR/ReimbursementPaidByOtherOrg00
IRS990ScheduleR/ReimbursementPaidToOtherOrg01
IRS990ScheduleR/RentalOfFacilitiesFrOtherOrgs00
IRS990ScheduleR/RentalOfFacilitiesToOtherOrgs00
IRS990ScheduleR/SaleOfAssetsToOtherOrg00
IRS990ScheduleR/SharingOfFacilities00
IRS990ScheduleR/SharingOfPaidEmployees00
IRS990ScheduleR/TransactionsRelatedOrgsTable/AmountInvolved0651576
IRS990ScheduleR/TransactionsRelatedOrgsTable/AmountInvolved1331634
IRS990ScheduleR/TransactionsRelatedOrgsTable/NameOfOtherOrganization/BusinessNameLine10SEQUENT INC
IRS990ScheduleR/TransactionsRelatedOrgsTable/NameOfOtherOrganization/BusinessNameLine11SEQUENT INC
IRS990ScheduleR/TransactionsRelatedOrgsTable/TransactionType0E
IRS990ScheduleR/TransactionsRelatedOrgsTable/TransactionType1O
IRS990/School00
IRS990/SignificantChange00
IRS990/SignificantNewProgramServices00
IRS990/StateLegalDomicile0OH
IRS990/StatesWhereCopyOfReturnIsFiled0OH
IRS990/TaxablePartyNotification00
IRS990/TaxExemptBonds00
IRS990/Terminated00
IRS990/TermOrPermanentEndowments00
IRS990/TheBooksAreInCareOf/AddressUS/AddressLine104700 LAKEHURST COURT SUITE 200
IRS990/TheBooksAreInCareOf/AddressUS/City0DUBLIN
IRS990/TheBooksAreInCareOf/AddressUS/State0OH
IRS990/TheBooksAreInCareOf/AddressUS/ZIPCode043016
IRS990/TheBooksAreInCareOf/NameBusiness/BusinessNameLine10CHRISTIAN M MATZ
IRS990/TheBooksAreInCareOf/TelephoneNumber06144365880
IRS990/TotalAssets/BOY0196662
IRS990/TotalAssetsBOY0196662
IRS990/TotalAssets/EOY01420005
IRS990/TotalAssetsEOY01420005
IRS990/TotalCompGT150K00
IRS990/TotalExpensesCurrentYear020812995
IRS990/TotalExpensesPriorYear026320058
IRS990/TotalFunctionalExpenses/Total020812995
IRS990/TotalFundrsngExpCurrentYear00
IRS990/TotalGrossUBI00
IRS990/TotalLiabilities/BOY01011635
IRS990/TotalLiabilitiesBOY01011635
IRS990/TotalLiabilities/EOY01912320
IRS990/TotalLiabilitiesEOY01912320
IRS990/TotalLiabNetAssetsFundBalances/BOY0196662
IRS990/TotalLiabNetAssetsFundBalances/EOY01420005
IRS990/TotalNbrEmployees00
IRS990/TotalNbrVolunteers00
IRS990/TotalNetAssetsFundBalances/BOY0-814973
IRS990/TotalNetAssetsFundBalances/EOY0-492315
IRS990/TotalOtherCompensation00
IRS990/TotalProfFundrsngExpCY00
IRS990/TotalProgramServiceRevenue021135206
IRS990/TotalReportableCompFrmRltdOrgs094654
IRS990/TotalReportableCompFromOrg00
IRS990/TotalRevenueCurrentYear021135653
IRS990/TotalRevenue/ExclusionAmount00
IRS990/TotalRevenuePriorYear026948361
IRS990/TotalRevenue/RelatedOrExemptFunctionIncome021135653
IRS990/TotalRevenue/TotalRevenueColumn021135653
IRS990/TotalRevenue/UnrelatedBusinessRevenue00
IRS990/TypeOfOrganizationTrust0X
IRS990/UnrelatedBusinessIncome00
IRS990/UponRequest0X
IRS990/WebSite0N/A
IRS990/WhistleblowerPolicy00
IRS990/YearFormation01999
ReturnHeader/BuildTS02016-02-24 21:20:13Z
ReturnHeader/Filer/EIN0311732659
ReturnHeader/Filer/Name/BusinessNameLine10SEQUENT Welfare BENEFIT TRUST (VEBA)
ReturnHeader/Filer/NameControl0SEQU
ReturnHeader/Filer/Phone06144365880
ReturnHeader/Filer/USAddress/AddressLine104700 LAKEHURST COURT
ReturnHeader/Filer/USAddress/City0DUBLIN
ReturnHeader/Filer/USAddress/State0OH
ReturnHeader/Filer/USAddress/ZIPCode043016
ReturnHeader/Officer/AuthorizeThirdParty01
ReturnHeader/Officer/DateSigned02011-05-05
ReturnHeader/Officer/Name0CHRISTIAN M MATZ
ReturnHeader/Officer/Phone06144365880
ReturnHeader/Officer/Title0TRUSTEE
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10SCHNEIDER DOWNS & CO INC
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine1041 S HIGH ST STE 2100
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0COLUMBUS
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0OH
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode043215
ReturnHeader/Preparer/Name0Tod E Wilson
ReturnHeader/Preparer/Phone06146214060
ReturnHeader/ReturnType0990
ReturnHeader/TaxPeriodBeginDate02009-07-01
ReturnHeader/TaxPeriodEndDate02010-06-30
ReturnHeader/TaxYear02009
ReturnHeader/Timestamp02011-05-10T14:42:36-05:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$1,420,005
Liabilities
$1,912,320
Net assets
-$492,315
Revenue
-
Expenses
$20,812,995
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2020Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.00$0.00$0.00$0.00$0.86$0.86
2019Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.81$0.95$0.86$0.03$0.00$0.03
2018Facts available. Structured filing facts are available, but richer extracted sections are limited.$4.25$3.41$0.83$16.3$16.3$0.03
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$3.27$2.40$0.87$15.9$16.1$0.28
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.89$1.70$1.19$14.0$14.3$0.33
2013XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.75$0.94$0.81$12.4
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.37$0.04$0.34$13.3
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.02$0.12$0.91$12.5
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.42$1.91$0.49$20.8