Civic Intelligence

Pepsi-Cola Bottling Company

990 • Fiscal year 2013 • EIN 42-1210714

Nov 01, 2012 to Oct 31, 2013 • Filed on Jul 25, 2014

Organization ProfileN/A

View Organization Page

PO Box 5052577
Siviq Scores

Scores are not available for this record yet.

Balance Sheet

Assets

Flat

$123,414

Flat from 2013

Net Assets

Flat

$123,414

Flat from 2013

Liabilities

Flat

$0

Flat from 2013

Revenue And Expenses

Revenue

-

No earlier filing loaded for comparison.

Expenses

Flat

$1,305,290

Flat from 2013

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.

$400K$300K$200K$100K$0-$100KAssets 2010: $94,723Liabilities 2010: $0Net Assets 2010: $94,7232010Assets 2011: $73,999Liabilities 2011: $0Net Assets 2011: $73,9992011Assets 2012: $85,993Liabilities 2012: $53,288Net Assets 2012: $32,7052012Assets 2013: $123,414Liabilities 2013: $0Net Assets 2013: $123,4142013Assets 2013: $123,414Liabilities 2013: $0Net Assets 2013: $123,4142013Assets 2014: $45,134Liabilities 2014: $17,806Net Assets 2014: $27,3282014Assets 2015: $75,031Liabilities 2015: $46,204Net Assets 2015: $28,8272015Assets 2016: $234,364Liabilities 2016: $0Net Assets 2016: $234,3642016Assets 2017: $300,302Liabilities 2017: $0Net Assets 2017: $300,3022017Assets 2018: $230,579Liabilities 2018: $0Net Assets 2018: $230,5792018Assets 2019: $116,116Liabilities 2019: $105,909Net Assets 2019: $10,2072019Assets 2020: $212,849Liabilities 2020: $6,977Net Assets 2020: $205,8722020Assets 2021: $71,375Liabilities 2021: $114,416Net Assets 2021: -$43,0412021Assets 2022: $194,293Liabilities 2022: $1,090Net Assets 2022: $193,2032022Assets 2023: $277,433Liabilities 2023: $5,093Net Assets 2023: $272,3402023Assets 2024: $164,189Liabilities 2024: $47,968Net Assets 2024: $116,2212024

Highlighted filing

2013

Assets$123,414
Liabilities$0
Net Assets$123,414
Open 2013 Filing

Operations Trend

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

$3.0M$2.0M$1.0M$0-$1.0MExpenses 2010: $1,534,6372010Expenses 2011: $1,321,7982011Expenses 2012: $1,444,7162012Expenses 2013: $1,305,2902013Revenue 2013: $1,395,999Expenses 2013: $1,305,290Net Income 2013: $90,7092013Revenue 2014: $1,305,830Expenses 2014: $1,401,916Net Income 2014: -$96,0862014Revenue 2015: $1,721,232Expenses 2015: $1,719,733Net Income 2015: $1,4992015Revenue 2016: $2,400,842Expenses 2016: $2,195,305Net Income 2016: $205,5372016Revenue 2017: $1,653,650Expenses 2017: $1,587,712Net Income 2017: $65,9382017Revenue 2018: $1,654,208Expenses 2018: $1,723,931Net Income 2018: -$69,7232018Revenue 2019: $1,512,745Expenses 2019: $1,733,117Net Income 2019: -$220,3722019Revenue 2020: $1,984,673Expenses 2020: $1,789,008Net Income 2020: $195,6652020Revenue 2021: $1,645,213Expenses 2021: $1,894,126Net Income 2021: -$248,9132021Revenue 2022: $2,086,981Expenses 2022: $1,850,737Net Income 2022: $236,2442022Revenue 2023: $2,114,850Expenses 2023: $2,035,713Net Income 2023: $79,1372023Revenue 2024: $2,279,908Expenses 2024: $2,436,027Net Income 2024: -$156,1192024

Highlighted filing

2013

Revenue-
Expenses$1,305,290
Net Income-
Open 2013 Filing
Jump To
Filing Snapshot
Filing Period
Nov 1, 2012 to Oct 31, 2013
Signed
Jul 25, 2014
Return Version
2012v2.1
Gross Receipts
$1,395,999
Mission and Program Overview

Mission

Voluntary employees' beneficiary association to provide health and short term disability benefits

Filing and Contact Details

Filer

EIN
42-1210714
Raw XML Appendix273 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/ActivitiesConductedPartnership00
IRS990/ActivityOrMissionDescription0VOLUNTARY EMPLOYEES' BENEFICIARY ASSOCIATION TO PROVIDE HEALTH AND SHORT TERM DISABILITY BENEFITS
IRS990/AddressPrincipalOfficerUS/AddressLine10PO BOX 50
IRS990/AddressPrincipalOfficerUS/City0OSKALOOSA
IRS990/AddressPrincipalOfficerUS/State0IA
IRS990/AddressPrincipalOfficerUS/ZIPCode052577
IRS990/AuditCommittee01
IRS990/BenefitsPaidToMembersCY0974158
IRS990/BenefitsPaidToMembersPriorYear01124110
IRS990/BenefitsToMembers/ProgramServices0974158
IRS990/BenefitsToMembers/Total0974158
IRS990/BsnssRltnshpThruFamilyMember00
IRS990/BsnssRltnshpWithOrganization00
IRS990/CapStckTrstPrinCurrentFunds/BOY00
IRS990/CapStckTrstPrinCurrentFunds/EOY00
IRS990/CashNonInterestBearing/BOY033462
IRS990/CashNonInterestBearing/EOY033462
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/Description0PROVIDES SHORT TERM DISABILITY AND HEALTH CARE BENEFITS TO AN AVERAGE OF 153 COVERED EMPLOYEES AND THEIR DEPENDENTS
IRS990/DisregardedEntity00
IRS990/DocumentRetentionPolicy00
IRS990/DonorAdvisedFunds00
IRS990/DoNotFollowSFAS1170X
IRS990/ElectionOfBoardMembers00
IRS990/EmploymentTaxReturnsFiled01
IRS990/Expense01305290
IRS990/FamilyOrBusinessRelationship00
IRS990/FederalGrantAuditRequired00
IRS990/ForeignActivities00
IRS990/ForeignFinancialAccount00
IRS990/ForeignOffice00
IRS990/Form1098CFiled00
IRS990/Form8282PropertyDisposedOf00
IRS990/Form8899Filed00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek00.10
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector0X
IRS990/Form990PartVIISectionA/NamePerson0BRADLEY MUHL
IRS990/Form990PartVIISectionA/OtherCompensation00
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization00
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs00
IRS990/Form990PartVIISectionA/Title0TRUSTEE
IRS990/Form990ProvidedToGoverningBody00
IRS990/FormersListed00
IRS990/FSAudited01
IRS990/FSAuditedBasis/FinancialStatementSeparate0X
IRS990/FundraisingActivities00
IRS990/FundsToPayPremiums00
IRS990/Gaming00
IRS990/GrantsAndSimilarAmntsCY00
IRS990/GrantsAndSimilarAmntsPriorYear00
IRS990/GrantsToIndividuals00
IRS990/GrantsToOrganizations00
IRS990/GrantToRelatedPerson00
IRS990/GrossReceipts01395999
IRS990/GroupReturnForAffiliates00
IRS990/Hospital00
IRS990/IndependentAuditFinancialStmt01
IRS990/IndoorTanningServices00
IRS990/InfoInScheduleOPartVI0X
IRS990/InfoInScheduleOPartXII0X
IRS990/InvestmentIncomeCurrentYear00
IRS990/InvestmentIncomePriorYear00
IRS990/InvestmentInJointVenture00
IRS990/InvestmentsOtherSecurities/EOY02790
IRS990/LoanToOfficerOrDQP00
IRS990/LocalChapters00
IRS990/MaterialDiversionOrMisuse00
IRS990/MembersOrStockholders00
IRS990/MethodOfAccountingOther0X
IRS990/MinutesOfCommittees00
IRS990/MinutesOfGoverningBody00
IRS990/MissionDescription0VOLUNTARY EMPLOYEES' BENEFICIARY ASSOCIATION TO PROVIDE HEALTH AND SHORT TERM DISABILITY BENEFITS
IRS990/MoreThan5000KToIndividuals00
IRS990/MoreThan5000KToOrganizations00
IRS990/NameOfPrincipalOfficerPerson0BRADLEY MUHL
IRS990/NbrIndependentVotingMembers00
IRS990/NbrVotingGoverningBodyMembers01
IRS990/NbrVotingMembersGoverningBody01
IRS990/NetAssetsOrFundBalancesBOY032705
IRS990/NetAssetsOrFundBalancesEOY0123414
IRS990/NetUnrelatedBusinessTxblIncome00
IRS990/NoListedPersonsCompensated0X
IRS990/NonDeductibleContributions00
IRS990/NumberFormsTransmittedWith109600
IRS990/NumberIndependentVotingMembers00
IRS990/NumberIndividualsGT100K00
IRS990/NumberOfContractorsGT100K00
IRS990/NumberOfEmployees04
IRS990/NumberW2GIncluded00
IRS990/OfficerEntityWithBsnssRltnshp00
IRS990/OfficerMailingAddress00
IRS990/Organization501c0X
IRS990/OtherAssetsTotal/BOY024992
IRS990/OtherAssetsTotal/EOY00
IRS990/OtherExpensePriorYear0320606
IRS990/OtherExpensesCurrentYear0331132
IRS990/OtherExpenses/Description0INSURANCE PREMIUMS
IRS990/OtherExpenses/Description1CONTRACT ADMINISTRATOR
IRS990/OtherExpenses/ProgramServices0212316
IRS990/OtherExpenses/ProgramServices1118816
IRS990/OtherExpenses/Total0212316
IRS990/OtherExpenses/Total1118816
IRS990/OtherLiabilities/BOY053288
IRS990/OtherLiabilities/EOY00
IRS990/OtherRevenueCurrentYear059582
IRS990/OtherRevenueMisc/BusinessCode0900099
IRS990/OtherRevenueMisc/Description0OTHER INCOME
IRS990/OtherRevenueMisc/ExclusionAmount059582
IRS990/OtherRevenueMisc/TotalRevenueColumn059582
IRS990/OtherRevenuePriorYear094994
IRS990/PaidInCapSrplsLandBldgEqpFund/BOY00
IRS990/PaidInCapSrplsLandBldgEqpFund/EOY00
IRS990/PartialLiquidation00
IRS990/PoliticalActivities00
IRS990/PremiumsPaid00
IRS990/ProfessionalFundraising00
IRS990/ProgramServiceRevenue/BusinessCode0900099
IRS990/ProgramServiceRevenue/BusinessCode1900099
IRS990/ProgramServiceRevenueCY01336417
IRS990/ProgramServiceRevenue/Description0EMPLOYER CONTRIBUTIONS
IRS990/ProgramServiceRevenue/Description1EMPLOYEE / PARTICIPANTS CONTRIBUT
IRS990/ProgramServiceRevenue/ExclusionAmount01093000
IRS990/ProgramServiceRevenue/ExclusionAmount1243417
IRS990/ProgramServiceRevenuePriorYear01308428
IRS990/ProgramServiceRevenue/TotalRevenueColumn01093000
IRS990/ProgramServiceRevenue/TotalRevenueColumn1243417
IRS990/ProhibitedTaxShelterTrans00
IRS990/QuidProQuoContributions00
IRS990/ReconcilationOtherChanges00
IRS990/ReconcilationRevenueExpenses090709
IRS990/RelatedEntity00
IRS990/RelatedOrgControlledEntity00
IRS990/ReportFin48Footnote00
IRS990/ReportInvestOthSecurities00
IRS990/ReportLandBldgEquip00
IRS990/ReportOtherAssets00
IRS990/ReportOtherLiabilities00
IRS990/ReportProgRelInvest00
IRS990/RetainedEarningsEndowmentEtc/BOY032705
IRS990/RetainedEarningsEndowmentEtc/EOY0123414
IRS990/RevenuesLessExpensesCY090709
IRS990/RevenuesLessExpensesPriorYear0-41294
IRS990/SalariesEtcCurrentYear00
IRS990/SalariesEtcPriorYear00
IRS990/SavingsAndTempCashInvestments/BOY027539
IRS990/SavingsAndTempCashInvestments/EOY087162
IRS990/ScheduleBRequired00
IRS990ScheduleD/ExpensesNotRptdF99000
IRS990ScheduleD/ExpensesNotRptdOnFinStmt00
IRS990ScheduleD/ExpensesSubtotal01305290
IRS990ScheduleD/RevenueNotRptdF99000
IRS990ScheduleD/RevenueNotRptdOnFinStmt00
IRS990ScheduleD/RevenueSubtotal01395999
IRS990ScheduleD/TotalExpensesPerForm99001305290
IRS990ScheduleD/TotalOfBookValueLandBuildings00
IRS990ScheduleD/TotalRevenuePerForm99001395999
IRS990ScheduleD/TotExpensesEtcAuditedFinclStmt01305290
IRS990ScheduleD/TotRevenueEtcAuditedFinclStmt01395999
IRS990/ScheduleJRequired00
IRS990ScheduleO/GeneralExplanation/Explanation0THE ORGANIZATION DID NOT CONTEMPORANEOUSLY DOCUMENT THE GOVERNING BODY'S MEETINGS HELD OR WRITTEN ACTIONS TAKEN DURING THE YEAR BECAUSE THE EMPLOYEE HEALTH PLAN DID NOT REQUIRE A MEETING OF THE GOVERNING BODY.
IRS990ScheduleO/GeneralExplanation/Explanation1THE ORGANIZATION DID NOT CONTEMPORANEOUSLY DOCUMENT COMMITTEE MEETINGS HELD OR WRITTEN ACTIONS TAKEN DURING THE YEAR BECAUSE THE EMPLOYEE HEALTH PLAN DOES NOT HAVE COMMITTEES OR COMMITTEE MEETINGS.
IRS990ScheduleO/GeneralExplanation/Explanation2A COPY OF THE FORM 990 WAS PROVIDED TO THE ORGANIZATION'S TRUSTEE BEFORE IT WAS FILED. UPON APPROVAL OF THE RETURN, THE FORM 990 WAS PROCESSED AND SENT TO THE INTERNAL REVENUE SERVICE.
IRS990ScheduleO/GeneralExplanation/Explanation3THE ORGANIZATION MAKES ITS GOVERNING DOCUMENTS AND FINANCIAL STATEMENTS AVAILABLE TO THE PUBLIC UPON REQUEST. THE ORGANIZATION DOES NOT CURRENTLY HAVE A CONFLICT OF INTEREST POLICY.
IRS990ScheduleO/GeneralExplanation/Explanation4THE ORGANIZATION UTILIZES THE MODIFIED CASH BASIS OF ACCOUNTING.
IRS990ScheduleO/GeneralExplanation/Explanation5THE ORGANIZATION HAS AN INFORMAL COMMITTEE (CHIEF EXECUTIVE OFFICER AND CHIEF FINANCIAL OFFICER) THAT ASSUMES RESPONSIBILITY FOR OVERSIGHT OF THE AUDIT OF ITS FINANCIAL STATEMENTS AND SELECTION OF AN INDEPENDENT ACCOUNTANT. THIS PROCESS HAS NOT CHANGED FROM THE PRIOR YEAR.
IRS990ScheduleO/GeneralExplanation/ReturnReference0FORM 990, PART VI, SECTION A, LINE 8A
IRS990ScheduleO/GeneralExplanation/ReturnReference1FORM 990, PART VI, SECTION A, LINE 8B
IRS990ScheduleO/GeneralExplanation/ReturnReference2FORM 990, PART VI, SECTION B, LINE 11
IRS990ScheduleO/GeneralExplanation/ReturnReference3FORM 990, PART VI, SECTION C, LINE 19
IRS990ScheduleO/GeneralExplanation/ReturnReference4FORM 990, PART XI, LINE 1:
IRS990ScheduleO/GeneralExplanation/ReturnReference5FORM 990, PART XII, LINE 2C:
IRS990/ScheduleORequired01
IRS990/School00
IRS990/SignificantChange00
IRS990/SignificantNewProgramServices00
IRS990/StateLegalDomicile0IA
IRS990/SubjectToProxyTax00
IRS990/TaxablePartyNotification00
IRS990/TaxExemptBonds00
IRS990/Terminated00
IRS990/TermOrPermanentEndowments00
IRS990/TheBooksAreInCareOf/AddressUS/AddressLine10PO BOX 50
IRS990/TheBooksAreInCareOf/AddressUS/City0OSKALOOSA
IRS990/TheBooksAreInCareOf/AddressUS/State0IA
IRS990/TheBooksAreInCareOf/AddressUS/ZIPCode052577
IRS990/TheBooksAreInCareOf/NameBusiness/BusinessNameLine10MAHASKA BOTTLING COMPANY
IRS990/TheBooksAreInCareOf/TelephoneNumber08007473481
IRS990/TotalAssets/BOY085993
IRS990/TotalAssetsBOY085993
IRS990/TotalAssets/EOY0123414
IRS990/TotalAssetsEOY0123414
IRS990/TotalCompGT150K00
IRS990/TotalExpensesCurrentYear01305290
IRS990/TotalExpensesPriorYear01444716
IRS990/TotalFunctionalExpenses/Fundraising00
IRS990/TotalFunctionalExpenses/ManagementAndGeneral00
IRS990/TotalFunctionalExpenses/ProgramServices01305290
IRS990/TotalFunctionalExpenses/Total01305290
IRS990/TotalFundrsngExpCurrentYear00
IRS990/TotalGrossUBI00
IRS990/TotalLiabilities/BOY053288
IRS990/TotalLiabilitiesBOY053288
IRS990/TotalLiabilities/EOY00
IRS990/TotalLiabilitiesEOY00
IRS990/TotalLiabNetAssetsFundBalances/BOY085993
IRS990/TotalLiabNetAssetsFundBalances/EOY0123414
IRS990/TotalNbrEmployees04
IRS990/TotalNbrVolunteers00
IRS990/TotalNetAssetsFundBalances/BOY032705
IRS990/TotalNetAssetsFundBalances/EOY0123414
IRS990/TotalOtherCompensation00
IRS990/TotalOtherRevenue059582
IRS990/TotalProfFundrsngExpCY00
IRS990/TotalProfFundrsngExpPriorYear00
IRS990/TotalProgramServiceExpense01305290
IRS990/TotalProgramServiceRevenue01336417
IRS990/TotalReportableCompFrmRltdOrgs00
IRS990/TotalReportableCompFromOrg00
IRS990/TotalRevenueCurrentYear01395999
IRS990/TotalRevenue/ExclusionAmount01395999
IRS990/TotalRevenuePriorYear01403422
IRS990/TotalRevenue/RelatedOrExemptFunctionIncome00
IRS990/TotalRevenue/TotalRevenueColumn01395999
IRS990/TotalRevenue/UnrelatedBusinessRevenue00
IRS990/TypeOfOrganizationCorporation0X
IRS990/UnrelatedBusinessIncome00
IRS990/UponRequest0X
IRS990/WebSite0N/A
IRS990/WhistleblowerPolicy00
IRS990/YearFormation01984
ReturnHeader/BuildTS02015-11-30 17:44:51Z
ReturnHeader/Filer/EIN0421210714
ReturnHeader/Filer/Name/BusinessNameLine10PEPSI-COLA BOTTLING COMPANY EMPLOYEES HEALTH PLAN
ReturnHeader/Filer/NameControl0PEPS
ReturnHeader/Filer/Phone08007473481
ReturnHeader/Filer/USAddress/AddressLine10PO BOX 50
ReturnHeader/Filer/USAddress/City0OSKALOOSA
ReturnHeader/Filer/USAddress/State0IA
ReturnHeader/Filer/USAddress/ZIPCode052577
ReturnHeader/Officer/AuthorizeThirdParty01
ReturnHeader/Officer/DateSigned02014-07-25
ReturnHeader/Officer/Name0BRADLEY MUHL
ReturnHeader/Officer/Phone08007473481
ReturnHeader/Officer/Title0TRUSTEE
ReturnHeader/PreparerFirm/EIN0481238645
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10MARKSNELSON VOHLAND CAMPBELL RADETIC LLC
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine101310 E 104TH ST SUITE 300
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0KANSAS CITY
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0MO
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode064131
ReturnHeader/Preparer/Name0LAWRENCE W VOHLAND
ReturnHeader/Preparer/Phone08167437700
ReturnHeader/ReturnType0990
ReturnHeader/TaxPeriodBeginDate02012-11-01
ReturnHeader/TaxPeriodEndDate02013-10-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02014-08-25T14:07:30-05: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
$123,414
Liabilities
$0
Net assets
$123,414
Revenue
-
Expenses
$1,305,290
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.16$0.05$0.12$2.28$2.44$0.16
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.28$0.01$0.27$2.11$2.04$0.08
2022Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.19$0.00$0.19$2.09$1.85$0.24
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.07$0.11$0.04$1.65$1.89$0.25
2020Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.21$0.01$0.21$1.98$1.79$0.20
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.12$0.11$0.01$1.51$1.73$0.22
2018Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.23$0.00$0.23$1.65$1.72$0.07
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.30$0.00$0.30$1.65$1.59$0.07
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.23$0.00$0.23$2.40$2.20$0.21
2015XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.08$0.05$0.03$1.72$1.72$0.00
2014Detailed filing. Detailed filing data is available for this year.$0.05$0.02$0.03$1.31$1.40$0.10
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.12$0.00$0.12$1.31
2013Summary only. Only limited summary data is available for this year.$0.12$0.00$0.12$1.40$1.31$0.09
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.09$0.05$0.03$1.44
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.07$0.00$0.07$1.32
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.09$0.00$0.09$1.53