Civic Intelligence

Coon Rapids Bayard Community School District Veba Trust

EIN 42-6039185 • 501(c)9 • Coon Rapids, IA

Profile

Voluntary employees beneficiary association. The trust was formed for the sole purpose of funding retiree health care benefits to eligible plan participants.

905 North StreetCoon Rapids, IA 50058-0297

www.crbcrusaders.org

Siviq Scores

Precomputed percentiles relative to similar nonprofits. These scores are descriptive rather than judgmental.

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on the latest valid filing.

Source year 2023

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on the latest valid filing.

Source year 2023

Net Margin

45th percentile

-23%

Higher net margin than 45% of similar nonprofits.

501(c)9 • <$500k nonprofits • Source year 2023

Top Officer Pay

75th percentile

$0

Higher top officer pay than 75% of similar nonprofits.

Top officer pay equals 0.0% of source-year revenue.

501(c)9 • <$500k nonprofits • Source year 2023

Asset Growth

Score unavailable

No value available

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

Source year 2023

Revenue Growth

Score unavailable

No value available

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

Source year 2023

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

$30,456

No earlier filing loaded for comparison.

Liabilities

-

No earlier filing loaded for comparison.

Net Assets

$30,457

No earlier filing loaded for comparison.

Operations
Liabilities / RevenueScore unavailableNet Margin45th percentile

Revenue

$18,804

No earlier filing loaded for comparison.

Expenses

$23,172

No earlier filing loaded for comparison.

Net Income

-$4,368

No earlier filing loaded for comparison.

Trend Graphs

Balance Sheet Trend

Asset GrowthScore unavailable

Grouped bars show assets, liabilities, and net assets across loaded filings.

$40K$30K$20K$10K$0Assets 2023: $30,456Net Assets 2023: $30,4572023

Highlighted filing

2023

Assets$30,456
Liabilities-
Net Assets$30,457
Open 2023 Filing

Operations Trend

Revenue GrowthScore unavailable

Revenue, expenses, and net income by year, with the latest filing highlighted.

$30K$20K$10K$0-$10KRevenue 2023: $18,804Expenses 2023: $23,172Net Income 2023: -$4,3682023

Highlighted filing

2023

Revenue$18,804
Expenses$23,172
Net Income-$4,368
Open 2023 Filing

Filings

Most recent year

2023 • Form 990EZDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$30,456
Liabilities
-
Net assets
$30,457
Revenue
$18,804
Expenses
$23,172
Net income
-$4,368
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023Detailed filing. Detailed filing data is available for this year.$30.5$30.5$18.8$23.2$4.37
Latest Filing Detail
Jump To
Filing Snapshot
Filing Period
Jan 1, 2023 to Dec 31, 2023
Signed
Aug 15, 2024
Return Version
2023v5.1
Gross Receipts
$18,804
Mission and Program Overview

Mission

Voluntary employees beneficiary association. The trust was formed for the sole purpose of funding retiree health care benefits to eligible plan participants.

Program Services

DescriptionGrantsExpenses
TOTAL EXPENSE IS COMPRISED OF HEALTH CARE BENEFITS PAID TO ELIGIBLE PARTICIPANTS. TOTAL REVENUE REPRESENTS THE ORGANIZATION S PROGRAM-RELATED CONTRIBUTIONS TO THE VEBA TRUST FOR THE PURPOSE OF FUNDING RETIREE HEALTH CARE BENEFITS TO ELIGIBLE PARTICIPANTS.-$23,172
Compensation and Service Providers
Top Officer Pay75th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
PAIGE HUNTLEYSchool Business Official-$0--
Filing and Contact Details

Filer

Filer Name
Coon Rapids Bayard Community School District Veba Trust
EIN
42-6039185
Phone
7129992207
Address
905 NORTH STREET, COON RAPIDS, IA 50058-0297

Signing Officer

Name
Paige Huntley
Title
School Business Official
Phone
7129992207
Signed
2024-08-15
Discuss with paid preparer
Yes

Preparer

Firm
Midamerica Admin & Ret Solutions
Address
2855 INTERSTATE DRIVE 115, SUITE 115, LAKELAND, FL 33805
Preparer
David Schuler
Phone
8136676077
Raw XML Appendix83 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
IRS990EZ/ActivitiesNotPreviouslyRptInd00
IRS990EZ/BenefitsPaidToOrForMembersAmt023172
IRS990EZ/BooksInCareOfDetail/PersonNm0MIDAMERICA ADMIN AND RETIREMENT SOL
IRS990EZ/BooksInCareOfDetail/PhoneNum08636884500
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt02855 INTERSTATE DR STE 115
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0LAKELAND
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0FL
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd033805
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt034825
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt030456
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd00
IRS990EZ/DonorAdvisedFndsInd00
IRS990EZ/ExcessOrDeficitForYearAmt0-4368
IRS990EZ/ForeignFinancialAccountInd00
IRS990EZ/ForeignOfficeInd00
IRS990EZ/Form1120PolFiledInd00
IRS990EZ/Form990TotalAssetsGrp/BOYAmt034825
IRS990EZ/Form990TotalAssetsGrp/EOYAmt030456
IRS990EZ/GrossReceiptsAmt018804
IRS990EZ/GroupExemptionNum07829
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InvestmentIncomeAmt0499
IRS990EZ/MadeLoansToFromOfficersInd00
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt034825
IRS990EZ/NetAssetsOrFundBalancesEOYAmt030457
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt034825
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt030456
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0PAIGE HUNTLEY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0SCHOOL BUSINESS OFFICIAL
IRS990EZ/OperateHospitalInd00
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd00
IRS990EZ/OrganizationHadUBIInd00
IRS990EZ/PoliticalCampaignActyInd00
IRS990EZ/PrimaryExemptPurposeTxt0VOLUNTARY EMPLOYEES BENEFICIARY ASSOCIATION. THE TRUST WAS FORMED FOR THE SOLE PURPOSE OF FUNDING RETIREE HEALTH CARE BENEFITS TO ELIGIBLE PLAN PARTICIPANTS.
IRS990EZ/ProgramServiceRevenueAmt018305
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0TOTAL EXPENSE IS COMPRISED OF HEALTH CARE BENEFITS PAID TO ELIGIBLE PARTICIPANTS. TOTAL REVENUE REPRESENTS THE ORGANIZATION S PROGRAM-RELATED CONTRIBUTIONS TO THE VEBA TRUST FOR THE PURPOSE OF FUNDING RETIREE HEALTH CARE BENEFITS TO ELIGIBLE PARTICIPANTS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt023172
IRS990EZ/ProhibitedTaxShelterTransInd00
IRS990EZ/RelatedOrganizationCtrlEntInd00
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0IA
IRS990EZ/SubjectToProxyTaxInd00
IRS990EZ/TanningServicesProvidedInd00
IRS990EZ/TotalExpensesAmt023172
IRS990EZ/TotalProgramServiceExpensesAmt023172
IRS990EZ/TotalRevenueAmt018804
IRS990EZ/TransactionWithControlEntInd00
IRS990EZ/WebsiteAddressTxt0www.crbcrusaders.org
ReturnHeader/BuildTS02024-10-15 13:58:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0PAIGE HUNTLEY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0School Business Official
ReturnHeader/BusinessOfficerGrp/PhoneNum07129992207
ReturnHeader/BusinessOfficerGrp/SignatureDt02024-08-15
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0COON RAPIDS BAYARD COMMUNITY SCHOOL DISTRICT VEBA TRUST
ReturnHeader/Filer/BusinessNameControlTxt0COON
ReturnHeader/Filer/EIN0426039185
ReturnHeader/Filer/PhoneNum07129992207
ReturnHeader/Filer/USAddress/AddressLine1Txt0905 NORTH STREET
ReturnHeader/Filer/USAddress/CityNm0COON RAPIDS
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IA
ReturnHeader/Filer/USAddress/ZIPCd0500580297
ReturnHeader/IRSResponsiblePrtyInfoCurrInd01
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0593526224
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0MIDAMERICA ADMIN & RET SOLUTIONS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02855 INTERSTATE DRIVE 115
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine2Txt0SUITE 115
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0LAKELAND
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0FL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd033805
ReturnHeader/PreparerPersonGrp/PhoneNum08136676077
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0DAVID SCHULER
ReturnHeader/ReturnTs02024-11-14T21:00:47-06:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02023-01-01
ReturnHeader/TaxPeriodEndDt02023-12-31
ReturnHeader/TaxYr02023

Document Assets

No mirrored PDF or thumbnail assets are attached yet.