Civic Intelligence

Sequent Employee Benefit Trust (Veba)

990 • Fiscal year 2013 • EIN 31-1732659

Jul 01, 2012 to Jun 30, 2013 • Filed on Feb 12, 2014

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

86th percentile

0.54x

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

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

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2013

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2013

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2013

Asset Growth

99th percentile

367%

Faster asset growth than 99% of similar nonprofits.

2013 filings • 501(c)9 • $10M-$25M nonprofits • Annualized from 2012 to 2013

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / Assets86th percentile

Assets

Up

$1,749,887

Up $1,374,922 (+367%) from 2012

Net Assets

Up

$808,058

Up $468,954 (+138%) from 2012

Liabilities

Up

$941,829

Up $905,968 (+2526%) from 2012

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

Down

$12,420,415

Down $858,473 (-6.5%) from 2012

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth99th percentile

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

2013

Assets$1,749,887
Liabilities$941,829
Net Assets$808,058
Open 2013 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

2013

Revenue-
Expenses$12,420,415
Net Income-
Open 2013 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2012 to Jun 30, 2013
Signed
Feb 12, 2014
Return Version
2012v2.1
Gross Receipts
$12,889,369
Mission and Program Overview

Mission

Administers a multi-employer employee benefit plan

Filing and Contact Details

Filer

EIN
31-1732659
Raw XML Appendix291 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/BOY035485
IRS990/AccountsPayableAccruedExpenses/EOY0941829
IRS990/AccountsReceivable/BOY07515
IRS990/AccountsReceivable/EOY04454
IRS990/ActivitiesConductedPartnership00
IRS990/ActivityOrMissionDescription0HEALTH AND WELFARE BENEFIT PLAN
IRS990/AddressPrincipalOfficerUS/AddressLine104700 LAKEHURST COURT
IRS990/AddressPrincipalOfficerUS/City0DUBLIN
IRS990/AddressPrincipalOfficerUS/State0OH
IRS990/AddressPrincipalOfficerUS/ZIPCode043016
IRS990/Advertising/Total017374
IRS990/AllOtherExpenses/Total011456
IRS990/BenefitsPaidToMembersCY011653076
IRS990/BenefitsPaidToMembersPriorYear012614795
IRS990/BenefitsToMembers/Total011653076
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/ContributionsGrantsPriorYear00
IRS990/CreditCounseling00
IRS990/DecisionsSubjectToApproval00
IRS990/DeductibleContributionsOfArt00
IRS990/DeductibleNonCashContributions00
IRS990/DelegationOfManagementDuties00
IRS990/DescribedIn501C300
IRS990/Description0ADMINISTERED MULTIPLE EMPLOYEE BENEFIT PROGRAMS FOR AN ESTIMATED 1,002 FULL-TIME EMPLOYEES, AT APPROXIMATELY 218 WORKSITES. THE TOTAL NUMBER OF INSURED INDIVIDUALS IS CLOSE TO 1,953.
IRS990/DisregardedEntity00
IRS990/DocumentRetentionPolicy00
IRS990/DonorAdvisedFunds00
IRS990/DoNotFollowSFAS1170X
IRS990/ElectionOfBoardMembers00
IRS990/FamilyOrBusinessRelationship00
IRS990/FederalGrantAuditRequired00
IRS990/FeesForServicesAccounting/Total018155
IRS990/FeesForServicesLegal/Total045379
IRS990/FeesForServicesOther/Total0240425
IRS990/ForeignActivities00
IRS990/ForeignFinancialAccount00
IRS990/ForeignOffice00
IRS990/Form8282PropertyDisposedOf00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek00.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek10.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek20.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek340.00
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector0X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector1X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector2X
IRS990/Form990PartVIISectionA/NamePerson0JOHN E BOYER
IRS990/Form990PartVIISectionA/NamePerson1STEVEN KERBER
IRS990/Form990PartVIISectionA/NamePerson2JAMES CALDWELL
IRS990/Form990PartVIISectionA/NamePerson3DWIGHT SEELEY
IRS990/Form990PartVIISectionA/Officer0X
IRS990/Form990PartVIISectionA/OtherCompensation00
IRS990/Form990PartVIISectionA/OtherCompensation10
IRS990/Form990PartVIISectionA/OtherCompensation20
IRS990/Form990PartVIISectionA/OtherCompensation30
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization00
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization10
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization20
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization30
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs00
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs10
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs20
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs3139341
IRS990/Form990PartVIISectionA/Title0MEMBER TRUST OVERSIGHT COM
IRS990/Form990PartVIISectionA/Title1MEMBER TRUST OVERSIGHT COM
IRS990/Form990PartVIISectionA/Title2MEMBER TRUST OVERSIGHT COM
IRS990/Form990PartVIISectionA/Title3VP OF EMPLOYEE BENEFIT PRO
IRS990/Form990ProvidedToGoverningBody01
IRS990/FormersListed00
IRS990/FSAudited00
IRS990/FundraisingActivities00
IRS990/Gaming00
IRS990/GrantsAndSimilarAmntsCY00
IRS990/GrantsAndSimilarAmntsPriorYear00
IRS990/GrantsToIndividuals00
IRS990/GrantsToOrganizations00
IRS990/GrantToRelatedPerson00
IRS990/GrossReceipts012889369
IRS990/GroupReturnForAffiliates00
IRS990/Hospital00
IRS990/IndependentAuditFinancialStmt00
IRS990/IndoorTanningServices00
IRS990/InfoInScheduleOPartVI0X
IRS990/InvestmentIncomeCurrentYear00
IRS990/InvestmentIncomePriorYear0546
IRS990/InvestmentInJointVenture00
IRS990/LoanToOfficerOrDQP00
IRS990/LocalChapters00
IRS990/MaterialDiversionOrMisuse00
IRS990/MembersOrStockholders00
IRS990/MethodOfAccountingAccrual0X
IRS990/MinutesOfCommittees01
IRS990/MinutesOfGoverningBody01
IRS990/MissionDescription0ADMINISTERS A MULTI-EMPLOYER EMPLOYEE BENEFIT PLAN
IRS990/MoreThan5000KToIndividuals00
IRS990/MoreThan5000KToOrganizations00
IRS990/NameOfPrincipalOfficerPerson0DWIGHT SEELEY
IRS990/NbrIndependentVotingMembers03
IRS990/NbrVotingGoverningBodyMembers03
IRS990/NbrVotingMembersGoverningBody03
IRS990/NetAssetsOrFundBalancesBOY0339104
IRS990/NetAssetsOrFundBalancesEOY0808058
IRS990/NetUnrelatedBusinessTxblIncome00
IRS990/NonDeductibleContributions00
IRS990/NumberFormsTransmittedWith109600
IRS990/NumberIndependentVotingMembers03
IRS990/NumberIndividualsGT100K00
IRS990/NumberOfContractorsGT100K00
IRS990/NumberOfEmployees00
IRS990/NumberW2GIncluded00
IRS990/OfficerEntityWithBsnssRltnshp00
IRS990/OfficerMailingAddress00
IRS990/Organization501c0X
IRS990/OtherExpensePriorYear0664093
IRS990/OtherExpensesCurrentYear0767339
IRS990/OtherExpenses/Description0CONTRACT CHARGES - SEQU
IRS990/OtherExpenses/Description1ADMIN FEE EXPENSE
IRS990/OtherExpenses/Description2POSTAGE AND DELIVERY
IRS990/OtherExpenses/Description3OFFICE EQUIPMENT - LEAS
IRS990/OtherExpenses/Total0316489
IRS990/OtherExpenses/Total1105145
IRS990/OtherExpenses/Total24917
IRS990/OtherExpenses/Total34431
IRS990/OtherLiabilities/BOY0376
IRS990/OtherLiabilities/EOY00
IRS990/OtherRevenueCurrentYear00
IRS990/OtherRevenuePriorYear00
IRS990/PaidInCapSrplsLandBldgEqpFund/BOY00
IRS990/PaidInCapSrplsLandBldgEqpFund/EOY00
IRS990/PartialLiquidation00
IRS990/PoliticalActivities00
IRS990/ProfessionalFundraising00
IRS990/ProgramServiceRevenue/BusinessCode0525100
IRS990/ProgramServiceRevenueCY012889369
IRS990/ProgramServiceRevenue/Description0EMPLOYEE AND EMPLOYER CONTRIBUTIO
IRS990/ProgramServiceRevenuePriorYear012709682
IRS990/ProgramServiceRevenue/RelatedOrExemptFunctionIncome012889369
IRS990/ProgramServiceRevenue/TotalRevenueColumn012889369
IRS990/ProhibitedTaxShelterTrans00
IRS990/QuidProQuoContributions00
IRS990/ReconcilationOtherChanges00
IRS990/ReconcilationRevenueExpenses0468954
IRS990/RelatedEntity01
IRS990/RelatedOrgControlledEntity00
IRS990/ReportFin48Footnote00
IRS990/ReportInvestOthSecurities00
IRS990/ReportLandBldgEquip00
IRS990/ReportOtherAssets00
IRS990/ReportOtherLiabilities00
IRS990/ReportProgRelInvest00
IRS990/RetainedEarningsEndowmentEtc/BOY0176669
IRS990/RetainedEarningsEndowmentEtc/EOY0645623
IRS990/RevenuesLessExpensesCY0468954
IRS990/RevenuesLessExpensesPriorYear0-568660
IRS990/SalariesEtcCurrentYear00
IRS990/SalariesEtcPriorYear00
IRS990/SavingsAndTempCashInvestments/BOY0367450
IRS990/SavingsAndTempCashInvestments/EOY01745433
IRS990/ScheduleBRequired00
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/ReturnReference0FORM 990, PART VI, SECTION B, LINE 11
IRS990ScheduleO/GeneralExplanation/ReturnReference1FORM 990, PART VI, SECTION C, LINE 19
IRS990/ScheduleORequired01
IRS990ScheduleR/DividendsRelatedOrganization00
IRS990ScheduleR/ExchangeOfAssets00
IRS990ScheduleR/Form990ScheduleRPartIV/AddressUS/AddressLine104700 LAKEHURST COURT
IRS990ScheduleR/Form990ScheduleRPartIV/AddressUS/City0DUBLIN
IRS990ScheduleR/Form990ScheduleRPartIV/AddressUS/State0OH
IRS990ScheduleR/Form990ScheduleRPartIV/AddressUS/ZIPCode043016
IRS990ScheduleR/Form990ScheduleRPartIV/ControlledOrg00
IRS990ScheduleR/Form990ScheduleRPartIV/EIN0311428576
IRS990ScheduleR/Form990ScheduleRPartIV/LegalDomicileState0OH
IRS990ScheduleR/Form990ScheduleRPartIV/NameOfRelatedOrg/BusinessNameLine10SEQUENT INC
IRS990ScheduleR/Form990ScheduleRPartIV/PrimaryActivity0EMPLOYER SERVICES
IRS990ScheduleR/Form990ScheduleRPartIV/TypeOfEntity0C
IRS990ScheduleR/GiftGrantOrCapContrFrOtherOrg00
IRS990ScheduleR/GiftGrantOrCapContrToOtherOrg00
IRS990ScheduleR/LoansOrGuaranteesFromOtherOrg00
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/AmountInvolved0316489
IRS990ScheduleR/TransactionsRelatedOrgsTable/MethodOfAmtDetermination0CASH
IRS990ScheduleR/TransactionsRelatedOrgsTable/NameOfOtherOrganization/BusinessNameLine10SEQUENT INC
IRS990ScheduleR/TransactionsRelatedOrgsTable/TransactionType0P
IRS990/School00
IRS990/SignificantChange00
IRS990/SignificantNewProgramServices00
IRS990/StateLegalDomicile0OH
IRS990/SubjectToProxyTax00
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/BusinessNameLine10DWIGHT SEELEY
IRS990/TheBooksAreInCareOf/TelephoneNumber06144365880
IRS990/TotalAssets/BOY0374965
IRS990/TotalAssetsBOY0374965
IRS990/TotalAssets/EOY01749887
IRS990/TotalAssetsEOY01749887
IRS990/TotalCompGT150K00
IRS990/TotalExpensesCurrentYear012420415
IRS990/TotalExpensesPriorYear013278888
IRS990/TotalFunctionalExpenses/Total012420415
IRS990/TotalFundrsngExpCurrentYear00
IRS990/TotalGrossUBI00
IRS990/TotalLiabilities/BOY035861
IRS990/TotalLiabilitiesBOY035861
IRS990/TotalLiabilities/EOY0941829
IRS990/TotalLiabilitiesEOY0941829
IRS990/TotalLiabNetAssetsFundBalances/BOY0374965
IRS990/TotalLiabNetAssetsFundBalances/EOY01749887
IRS990/TotalNbrEmployees00
IRS990/TotalNbrVolunteers00
IRS990/TotalNetAssetsFundBalances/BOY0339104
IRS990/TotalNetAssetsFundBalances/EOY0808058
IRS990/TotalOtherCompensation00
IRS990/TotalProfFundrsngExpCY00
IRS990/TotalProfFundrsngExpPriorYear00
IRS990/TotalProgramServiceRevenue012889369
IRS990/TotalReportableCompFrmRltdOrgs0139341
IRS990/TotalReportableCompFromOrg00
IRS990/TotalRevenueCurrentYear012889369
IRS990/TotalRevenue/ExclusionAmount00
IRS990/TotalRevenuePriorYear012710228
IRS990/TotalRevenue/RelatedOrExemptFunctionIncome012889369
IRS990/TotalRevenue/TotalRevenueColumn012889369
IRS990/TotalRevenue/UnrelatedBusinessRevenue00
IRS990/Travel/Total03568
IRS990/TypeOfOrganizationTrust0X
IRS990/UnrelatedBusinessIncome00
IRS990/UponRequest0X
IRS990/WebSite0N/A
IRS990/WhistleblowerPolicy00
IRS990/YearFormation01999
ReturnHeader/BuildTS02016-03-07 17:11:31Z
ReturnHeader/Filer/EIN0311732659
ReturnHeader/Filer/Name/BusinessNameLine10SEQUENT EMPLOYEE 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/DateSigned02014-02-12
ReturnHeader/Officer/Name0DWIGHT SEELEY
ReturnHeader/Officer/Phone06144365880
ReturnHeader/Officer/Title0VP EMPLOYEE BENEFIT PROGRAMS
ReturnHeader/PreparerFirm/EIN0251408703
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/TaxPeriodBeginDate02012-07-01
ReturnHeader/TaxPeriodEndDate02013-06-30
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02014-02-15T11:15:44-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
$1,749,887
Liabilities
$941,829
Net assets
$808,058
Revenue
-
Expenses
$12,420,415
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
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$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