Civic Intelligence

School Administrator'S Welfare Trust

990 • Fiscal year 2012 • EIN 88-0232390

Jul 01, 2011 to Jun 30, 2012 • Filed on May 05, 2013

Organization ProfileCCASA.NET
4055 Spencer89119
Siviq Scores

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

Liabilities / Assets

71st percentile

0.20x

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

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

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2012

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2012

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2012

Asset Growth

28th percentile

-2.9%

Faster asset growth than 28% of similar nonprofits.

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

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / Assets71st percentile

Assets

Down

$5,500,222

Down $164,619 (-2.9%) from 2011

Net Assets

Down

$4,377,448

Down $160,289 (-3.5%) from 2011

Liabilities

Down

$1,122,774

Down $4,330 (-0.4%) from 2011

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

Up

$16,444,304

Up $58,753 (+0.4%) from 2011

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth28th percentile

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

$8.0M$6.0M$4.0M$2.0M$0Assets 2010: $6,045,924Liabilities 2010: $1,059,799Net Assets 2010: $4,986,1252010Assets 2011: $5,664,841Liabilities 2011: $1,127,104Net Assets 2011: $4,537,7372011Assets 2012: $5,500,222Liabilities 2012: $1,122,774Net Assets 2012: $4,377,4482012Assets 2013: $5,048,055Liabilities 2013: $1,160,424Net Assets 2013: $3,887,6312013Assets 2014: $3,698,911Liabilities 2014: $1,194,836Net Assets 2014: $2,504,0752014Assets 2015: $3,877,189Liabilities 2015: $1,215,697Net Assets 2015: $2,661,4922015Assets 2016: $4,123,204Liabilities 2016: $1,224,412Net Assets 2016: $2,898,7922016Assets 2017: $3,885,212Liabilities 2017: $1,250,409Net Assets 2017: $2,634,8032017Assets 2018: $3,532,792Liabilities 2018: $1,274,849Net Assets 2018: $2,257,9432018Assets 2019: $3,546,173Liabilities 2019: $1,390,856Net Assets 2019: $2,155,3172019Assets 2020: $4,049,189Liabilities 2020: $1,461,017Net Assets 2020: $2,588,1722020Assets 2021: $4,394,008Liabilities 2021: $1,452,851Net Assets 2021: $2,941,1572021Assets 2022: $4,655,060Liabilities 2022: $1,781,224Net Assets 2022: $2,873,8362022Assets 2023: $5,427,888Liabilities 2023: $1,934,962Net Assets 2023: $3,492,9262023Assets 2024: $7,082,784Liabilities 2024: $2,209,665Net Assets 2024: $4,873,1192024

Highlighted filing

2012

Assets$5,500,222
Liabilities$1,122,774
Net Assets$4,377,448
Open 2012 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$40M$30M$20M$10M$0-$10MExpenses 2010: $15,348,0612010Expenses 2011: $16,385,5512011Expenses 2012: $16,444,3042012Expenses 2013: $17,128,8572013Revenue 2014: $17,103,025Expenses 2014: $18,469,412Net Income 2014: -$1,366,3872014Revenue 2015: $18,497,564Expenses 2015: $18,334,608Net Income 2015: $162,9562015Revenue 2016: $19,458,483Expenses 2016: $19,215,105Net Income 2016: $243,3782016Revenue 2017: $20,372,790Expenses 2017: $20,591,189Net Income 2017: -$218,3992017Revenue 2018: $22,537,203Expenses 2018: $22,845,432Net Income 2018: -$308,2292018Revenue 2019: $23,818,191Expenses 2019: $23,963,166Net Income 2019: -$144,9752019Revenue 2020: $25,372,154Expenses 2020: $24,999,920Net Income 2020: $372,2342020Revenue 2021: $26,243,506Expenses 2021: $25,838,632Net Income 2021: $404,8742021Revenue 2022: $27,258,047Expenses 2022: $27,173,762Net Income 2022: $84,2852022Revenue 2023: $29,658,042Expenses 2023: $28,982,763Net Income 2023: $675,2792023Revenue 2024: $32,718,119Expenses 2024: $31,294,136Net Income 2024: $1,423,9832024

Highlighted filing

2012

Revenue-
Expenses$16,444,304
Net Income-
Open 2012 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2011 to Jun 30, 2012
Signed
May 5, 2013
Return Version
2011v1.2
Gross Receipts
$17,576,135
Mission and Program Overview

Mission

To provide insurance for members.

Filing and Contact Details

Filer

EIN
88-0232390
Raw XML Appendix270 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/AccountantCompileOrReview0true
IRS990/AccountsPayableAccruedExpenses/BOY011168
IRS990/AccountsPayableAccruedExpenses/EOY05572
IRS990/ActivitiesConductedPartnership0false
IRS990/ActivityOrMissionDescription0TO PROVIDE INSURANCE FOR MEMBERS.
IRS990/AddressPrincipalOfficerUS/AddressLine104055 SPENCER 230
IRS990/AddressPrincipalOfficerUS/City0LAS VEGAS
IRS990/AddressPrincipalOfficerUS/State0NV
IRS990/AddressPrincipalOfficerUS/ZIPCode089119
IRS990/AnnualDisclosureCoveredPersons0true
IRS990/AuditCommittee0true
IRS990/BenefitsPaidToMembersCY016146075
IRS990/BenefitsPaidToMembersPriorYear016030868
IRS990/BenefitsToMembers/Total016146075
IRS990/BsnssRltnshpThruFamilyMember0false
IRS990/BsnssRltnshpWithOrganization0false
IRS990/CashNonInterestBearing/EOY03628
IRS990/ChangesToOrganizingDocs0false
IRS990/CollectionsOfArt0false
IRS990/CompensationFromOtherSources0false
IRS990/CompensationProcessCEO0true
IRS990/CompensationProcessOther0true
IRS990/ConflictOfInterestPolicy0true
IRS990/ConservationEasements0false
IRS990/ConsolidatedAuditFinancialStmt0false
IRS990/ContributionsGrantsCurrentYear00
IRS990/CreditCounseling0false
IRS990/DecisionsSubjectToApproval0false
IRS990/DeductibleContributionsOfArt0false
IRS990/DeductibleNonCashContributions0false
IRS990/DelegationOfManagementDuties0false
IRS990/DescribedIn501C30false
IRS990/Description0THE PLAN RECEIVES AND DISBURSES FUNDS FROM THE CLARK COUNTY SCHOOL DISTRICT FOR THE PURPOSE OF INSURANCE AND TO PROVIDE REIMBURSEMENT FOR UNUSED SICK PAY AND RETIRED MEDICAL DISTRIBUTIONS AT RETIREMENT.
IRS990/DisregardedEntity0false
IRS990/DocumentRetentionPolicy0true
IRS990/DonorAdvisedFunds0false
IRS990/ElectionOfBoardMembers0false
IRS990/EmploymentTaxReturnsFiled0true
IRS990/ExcessBenefitTransaction0false
IRS990/FamilyOrBusinessRelationship0false
IRS990/FederalGrantAuditRequired0false
IRS990/FeesForServicesAccounting/Total013865
IRS990/FeesForServicesInvstMgmntFees/Total011734
IRS990/FeesForServicesLegal/Total03963
IRS990/FinancialStatementSeparate0X
IRS990/FollowSFAS1170X
IRS990/ForeignActivities0false
IRS990/ForeignFinancialAccount0false
IRS990/ForeignOffice0false
IRS990/Form8282PropertyDisposedOf0false
IRS990/Form990PartVIISectionA/AverageHoursPerWeek02.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek12.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek22.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek32.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek42.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek52.00
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector0X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector1X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector2X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector3X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector4X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector5X
IRS990/Form990PartVIISectionA/NamePerson0STEPHEN AUGSPURGER
IRS990/Form990PartVIISectionA/NamePerson1ALLIN CHANDLER
IRS990/Form990PartVIISectionA/NamePerson2PAMELA HICKS
IRS990/Form990PartVIISectionA/NamePerson3RJ LAPUZ
IRS990/Form990PartVIISectionA/NamePerson4HILARY ENGEL
IRS990/Form990PartVIISectionA/NamePerson5PATRICIA ROSALES
IRS990/Form990PartVIISectionA/Title0CHAIRMAN
IRS990/Form990PartVIISectionA/Title1TRUSTEE
IRS990/Form990PartVIISectionA/Title2TRUSTEE
IRS990/Form990PartVIISectionA/Title3TRUSTEE
IRS990/Form990PartVIISectionA/Title4TRUSTEE
IRS990/Form990PartVIISectionA/Title5TRUSTEE
IRS990/Form990ProvidedToGoverningBody0true
IRS990/FormersListed0false
IRS990/FSAudited0false
IRS990/FundraisingActivities0false
IRS990/FundsToPayPremiums0false
IRS990/GainOrLoss/Securities0-19525
IRS990/Gaming0false
IRS990/GrantsAndSimilarAmntsCY00
IRS990/GrantsToIndividuals0false
IRS990/GrantsToOrganizations0false
IRS990/GrantToRelatedPerson0false
IRS990/GrossAmountSalesAssets/Securities01219738
IRS990/GrossReceipts017576135
IRS990/GroupReturnForAffiliates0false
IRS990/Hospital0false
IRS990/IndependentAuditFinancialStmt0false
IRS990/IndoorTanningServices0false
IRS990/InfoInScheduleOPartVI0X
IRS990/InfoInScheduleOPartXI0X
IRS990/Insurance/Total013163
IRS990/InvestmentIncomeCurrentYear097664
IRS990/InvestmentIncomePriorYear0127943
IRS990/InvestmentIncome/TotalRevenueColumn0117189
IRS990/InvestmentInJointVenture0false
IRS990/InvestmentsPubTradedSecurities/BOY05181709
IRS990/InvestmentsPubTradedSecurities/EOY0748235
IRS990/LessCostOthBasisSalesExpenses/Securities01239263
IRS990/LoanToOfficerOrDQP0false
IRS990/LobbyingActivities0false
IRS990/LocalChapters0false
IRS990/MaterialDiversionOrMisuse0false
IRS990/MembersOrStockholders0false
IRS990/MethodOfAccountingAccrual0X
IRS990/MinutesOfCommittees0true
IRS990/MinutesOfGoverningBody0true
IRS990/MissionDescription0TO PROVIDE INSURANCE FOR MEMBERS.
IRS990/MoreThan5000KToIndividuals0false
IRS990/MoreThan5000KToOrganizations0false
IRS990/NameOfPrincipalOfficerPerson0STEPHEN AUGSPURGER
IRS990/NbrIndependentVotingMembers06
IRS990/NbrVotingGoverningBodyMembers06
IRS990/NbrVotingMembersGoverningBody06
IRS990/NetAssetsOrFundBalancesBOY04537737
IRS990/NetAssetsOrFundBalancesEOY04377448
IRS990/NetGainOrLossInvestments/RelatedOrExemptFunctionIncome0-19525
IRS990/NetGainOrLossInvestments/TotalRevenueColumn0-19525
IRS990/NoListedPersonsCompensated0X
IRS990/NonDeductibleContributions0false
IRS990/NumberFormsTransmittedWith10960216
IRS990/NumberIndependentVotingMembers06
IRS990/NumberOfEmployees01
IRS990/NumberW2GIncluded00
IRS990/OfficeExpenses/Total0154733
IRS990/OfficerEntityWithBsnssRltnshp0false
IRS990/OfficerMailingAddress0false
IRS990/Organization501c0X
IRS990/OtherAssetsTotal/BOY020041
IRS990/OtherAssetsTotal/EOY06
IRS990/OtherExpensePriorYear0258067
IRS990/OtherExpensesCurrentYear0197458
IRS990/OtherLiabilities/BOY01115936
IRS990/OtherLiabilities/EOY01117202
IRS990/OtherRevenueCurrentYear0198093
IRS990/OtherRevenueMisc/BusinessCode0900099
IRS990/OtherRevenueMisc/Description0ERRP REIMBURSEMENT
IRS990/OtherRevenueMisc/RelatedOrExemptFunctionIncome0198093
IRS990/OtherRevenueMisc/TotalRevenueColumn0198093
IRS990/OtherRevenuePriorYear064109
IRS990/OtherSalariesAndWages/Total092475
IRS990/PartialLiquidation0false
IRS990/PayrollTaxes/Total08296
IRS990/PoliticalActivities0false
IRS990/PremiumsPaid0false
IRS990/PrepaidExpensesDeferredCharges/BOY013163
IRS990/PriorExcessBenefitTransaction0false
IRS990/ProfessionalFundraising0false
IRS990/ProgramServiceRevenue/BusinessCode0525100
IRS990/ProgramServiceRevenue/BusinessCode1525100
IRS990/ProgramServiceRevenueCY016041115
IRS990/ProgramServiceRevenue/Description0EMPLOYER CONTRIBUTIONS
IRS990/ProgramServiceRevenue/Description1SELF-PAY CONTRIBUTIONS
IRS990/ProgramServiceRevenuePriorYear015824740
IRS990/ProgramServiceRevenue/TotalRevenueColumn015950999
IRS990/ProgramServiceRevenue/TotalRevenueColumn190116
IRS990/ProhibitedTaxShelterTrans0false
IRS990/QuidProQuoContributions0false
IRS990/ReconcilationOtherChanges0-52857
IRS990/ReconcilationRevenueExpenses0-107432
IRS990/RegularMonitoringEnforcement0true
IRS990/RelatedEntity0false
IRS990/RelatedOrgControlledEntity0false
IRS990/ReportFin48Footnote0false
IRS990/ReportInvestOthSecurities0false
IRS990/ReportLandBldgEquip0true
IRS990/ReportOtherAssets0false
IRS990/ReportOtherLiabilities0true
IRS990/ReportProgRelInvest0false
IRS990/RevenuesLessExpensesCY0-107432
IRS990/RevenuesLessExpensesPriorYear0-368759
IRS990/SalariesEtcCurrentYear0100771
IRS990/SalariesEtcPriorYear096616
IRS990/SavingsAndTempCashInvestments/BOY0449928
IRS990/SavingsAndTempCashInvestments/EOY04748353
IRS990/ScheduleBRequired0false
IRS990ScheduleD/OtherLiabilities/Amount01117202
IRS990ScheduleD/OtherLiabilities/Description0BENEFIT OBLIGATIONS
IRS990ScheduleD/OtherLiabilities/Description1OVERDRAFT
IRS990ScheduleD/TotalOfAmounts01117202
IRS990/ScheduleJRequired0false
IRS990ScheduleO/GeneralExplanation/Explanation0FORM 990 WAS PROVIDED TO TRUSTEES FOR REVIEW PRIOR TO FILING.
IRS990ScheduleO/GeneralExplanation/Explanation1TRUSTEES AND STAFF REVIEW THE CONFLICT OF INTEREST POLICY ON AN ANNUAL BASIS TO
IRS990ScheduleO/GeneralExplanation/Explanation2DETERMINE COMPLIANCE WITH THE STATED POLICY. POLICY PROVISIONS ARE DISCUSSED AT TRUST MEETINGS.
IRS990ScheduleO/GeneralExplanation/Explanation3SALARY SURVEYS AND A COMPARISON OF SIMILAR POSITIONS IN OTHER PUBLIC AND PRIVATE ORGANIZATIONS
IRS990ScheduleO/GeneralExplanation/Explanation4WERE CONDUCTED AND REVIEWED BY THE APPOINTED MEMBERS OF THE TRUST.
IRS990ScheduleO/GeneralExplanation/Explanation5PLAN PARTICIPANTS ARE INFORMED OF THE GOVERNING DOCUMENTS THROUGH THE NEWSLETTER.
IRS990ScheduleO/GeneralExplanation/Explanation6LINE 5 CONSISTS OF $14,299 IN UNREALIZED GAINS AND $67,156 IN CHANGE OF ESTIMATED LIABILITY.
IRS990ScheduleO/GeneralExplanation/Identifier0Pt VI, Line 11a
IRS990ScheduleO/GeneralExplanation/Identifier1Pt VI, Line 12c
IRS990ScheduleO/GeneralExplanation/Identifier2Pt VI, Line 15
IRS990ScheduleO/GeneralExplanation/Identifier3Pt VI, Line 19
IRS990ScheduleO/GeneralExplanation/Identifier4Pt XI
IRS990/ScheduleORequired0true
IRS990/School0false
IRS990/SignificantChange0false
IRS990/SignificantNewProgramServices0false
IRS990/StateLegalDomicile0NV
IRS990/SubjectToProxyTax0false
IRS990/TaxablePartyNotification0false
IRS990/TaxExemptBonds0false
IRS990/Terminated0false
IRS990/TermOrPermanentEndowments0false
IRS990/TheBooksAreInCareOf/AddressUS/AddressLine104055 SPENCER 230
IRS990/TheBooksAreInCareOf/AddressUS/City0LAS VEGAS
IRS990/TheBooksAreInCareOf/AddressUS/State0NV
IRS990/TheBooksAreInCareOf/AddressUS/ZIPCode089119
IRS990/TheBooksAreInCareOf/NamePerson0STEPHEN AUGSPURGER
IRS990/TheBooksAreInCareOf/TelephoneNumber07027969602
IRS990/TotalAssets/BOY05664841
IRS990/TotalAssetsBOY05664841
IRS990/TotalAssets/EOY05500222
IRS990/TotalAssetsEOY05500222
IRS990/TotalCompGT150K0false
IRS990/TotalExpensesCurrentYear016444304
IRS990/TotalExpensesPriorYear016385551
IRS990/TotalFunctionalExpenses/Total016444304
IRS990/TotalFundrsngExpCurrentYear00
IRS990/TotalGrossUBI00
IRS990/TotalLiabilities/BOY01127104
IRS990/TotalLiabilitiesBOY01127104
IRS990/TotalLiabilities/EOY01122774
IRS990/TotalLiabilitiesEOY01122774
IRS990/TotalLiabNetAssetsFundBalances/BOY05664841
IRS990/TotalLiabNetAssetsFundBalances/EOY05500222
IRS990/TotalNbrEmployees01
IRS990/TotalNbrVolunteers00
IRS990/TotalNetAssetsFundBalances/BOY04537737
IRS990/TotalNetAssetsFundBalances/EOY04377448
IRS990/TotalOtherRevenue0198093
IRS990/TotalProfFundrsngExpCY00
IRS990/TotalProgramServiceRevenue016041115
IRS990/TotalRevenueCurrentYear016336872
IRS990/TotalRevenuePriorYear016016792
IRS990/TotalRevenue/RelatedOrExemptFunctionIncome016336872
IRS990/TotalRevenue/TotalRevenueColumn016336872
IRS990/TransactionRelatedEntity0false
IRS990/TypeOfOrganizationTrust0X
IRS990/UnrelatedBusinessIncome0false
IRS990/UnrestrictedNetAssets/BOY04537737
IRS990/UnrestrictedNetAssets/EOY04377448
IRS990/UponRequest0X
IRS990/WebSite0CCASA.NET
IRS990/WhistleblowerPolicy0true
IRS990/YearFormation01987
ReturnHeader/BuildTS02016-02-25 16:41:14Z
ReturnHeader/Filer/EIN0880232390
ReturnHeader/Filer/Name/BusinessNameLine10SCHOOL ADMINISTRATOR'S WELFARE TRUST
ReturnHeader/Filer/NameControl0SCHO
ReturnHeader/Filer/Phone07027969602
ReturnHeader/Filer/USAddress/AddressLine104055 SPENCER
ReturnHeader/Filer/USAddress/City0LAS VEGAS
ReturnHeader/Filer/USAddress/State0NV
ReturnHeader/Filer/USAddress/ZIPCode089119
ReturnHeader/Officer/DateSigned02013-05-05
ReturnHeader/Officer/Name0STEPHEN AUGSPURGER
ReturnHeader/Officer/Phone07027969602
ReturnHeader/Officer/Title0CHAIRMAN
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10BERRY & CO CPAS LTD
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine107030 SMOKE RANCH RD
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0LAS VEGAS
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0NV
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode0891281202
ReturnHeader/ReturnType0990
ReturnHeader/TaxPeriodBeginDate02011-07-01
ReturnHeader/TaxPeriodEndDate02012-06-30
ReturnHeader/TaxYear02011
ReturnHeader/Timestamp02013-05-13T09:40:45-07:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$5,500,222
Liabilities
$1,122,774
Net assets
$4,377,448
Revenue
-
Expenses
$16,444,304
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$7.08$2.21$4.87$32.7$31.3$1.42
2023Detailed filing. Detailed filing data is available for this year.$5.43$1.93$3.49$29.7$29.0$0.68
2022Detailed filing. Detailed filing data is available for this year.$4.66$1.78$2.87$27.3$27.2$0.08
2021Detailed filing. Detailed filing data is available for this year.$4.39$1.45$2.94$26.2$25.8$0.40
2020Detailed filing. Detailed filing data is available for this year.$4.05$1.46$2.59$25.4$25.0$0.37
2019Detailed filing. Detailed filing data is available for this year.$3.55$1.39$2.16$23.8$24.0$0.14
2018Detailed filing. Detailed filing data is available for this year.$3.53$1.27$2.26$22.5$22.8$0.31
2017Detailed filing. Detailed filing data is available for this year.$3.89$1.25$2.63$20.4$20.6$0.22
2016Summary only. Only limited summary data is available for this year.$4.12$1.22$2.90$19.5$19.2$0.24
2015Summary only. Only limited summary data is available for this year.$3.88$1.22$2.66$18.5$18.3$0.16
2014Summary only. Only limited summary data is available for this year.$3.70$1.19$2.50$17.1$18.5$1.37
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$5.05$1.16$3.89$17.1
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$5.50$1.12$4.38$16.4
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$5.66$1.13$4.54$16.4
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$6.05$1.06$4.99$15.3