Civic Intelligence

Vermont Automobile Insurance Plan

990EZ • Fiscal year 2017 • EIN 23-7234308

Jan 01, 2017 to Dec 31, 2017 • Filed on May 11, 2018

c/o AIPSO 302 CENTRAL AVENUEJohnston, RI 02919-4932

(401) 946-2310

Siviq Scores

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

Liabilities / Assets

99th percentile

3.33x

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

2017 filings • 501(c)6 • <$500k nonprofits • Source year 2017

Liabilities / Revenue

95th percentile

0.53x

Higher debt load relative to revenue than 95% of similar nonprofits.

2017 filings • 501(c)6 • <$500k nonprofits • Source year 2017

Net Margin

74th percentile

13%

Higher net margin than 74% of similar nonprofits.

2017 filings • 501(c)6 • <$500k nonprofits • Source year 2017

Top Officer Pay

70th percentile

$0

Higher top officer pay than 70% of similar nonprofits.

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

2017 filings • 501(c)6 • <$500k nonprofits • Source year 2017

Asset Growth

10th percentile

-32%

Faster asset growth than 10% of similar nonprofits.

2017 filings • 501(c)6 • <$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

16th percentile

-21%

Faster revenue growth than 16% of similar nonprofits.

2017 filings • 501(c)6 • <$500k nonprofits • Annualized from 2016 to 2017

Assets

Down

$17,631

Down $8,260 (-32%) from 2016

Net Assets

Down

-$41,052

Down $14,308 (-53%) from 2016

Liabilities

Up

$58,683

Up $6,048 (+11%) from 2016

Revenue

Down

$110,923

Down $29,568 (-21%) from 2016

Expenses

Down

$96,869

Down $18,341 (-16%) from 2016

Net Income

Down

$14,054

Down $11,227 (-44%) from 2016

Historical Trend

Balance Sheet Trend

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

$100K$50K$0-$50KAssets 2010: $47,976Liabilities 2010: $42,958Net Assets 2010: $5,0182010Assets 2011: $40,720Liabilities 2011: $58,334Net Assets 2011: -$17,6142011Assets 2012: $39,756Liabilities 2012: $86,585Net Assets 2012: -$46,8292012Assets 2013: $36,961Liabilities 2013: $20,941Net Assets 2013: $16,0202013Assets 2014: $28,063Liabilities 2014: $72,640Net Assets 2014: -$44,5772014Assets 2015: $23,751Liabilities 2015: $50,915Net Assets 2015: -$27,1642015Assets 2016: $25,891Liabilities 2016: $52,635Net Assets 2016: -$26,7442016Assets 2017: $17,631Liabilities 2017: $58,683Net Assets 2017: -$41,0522017Assets 2018: $14,921Liabilities 2018: $44,611Net Assets 2018: -$29,6902018Assets 2019: $20,374Liabilities 2019: $54,805Net Assets 2019: -$34,4312019Assets 2020: $21,321Liabilities 2020: $65,258Net Assets 2020: -$43,9372020Assets 2021: $22,938Liabilities 2021: $43,407Net Assets 2021: -$20,4692021Assets 2022: $25,374Liabilities 2022: $36,442Net Assets 2022: -$11,0682022Assets 2023: $14,361Liabilities 2023: $33,991Net Assets 2023: -$19,6302023Assets 2024: $17,381Liabilities 2024: $27,924Net Assets 2024: -$10,5432024

Highlighted filing

2017

Assets$17,631
Liabilities$58,683
Net Assets-$41,052

Operations Trend

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

$200K$150K$100K$50K$0Revenue 2010: $143,285Expenses 2010: $130,002Net Income 2010: $13,2832010Revenue 2011: $150,249Expenses 2011: $136,948Net Income 2011: $13,3012011Revenue 2012: $148,504Expenses 2012: $145,510Net Income 2012: $2,9942012Revenue 2013: $152,696Expenses 2013: $151,491Net Income 2013: $1,2052013Revenue 2014: $150,347Expenses 2014: $117,926Net Income 2014: $32,4212014Revenue 2015: $133,025Expenses 2015: $115,158Net Income 2015: $17,8672015Revenue 2016: $140,491Expenses 2016: $115,210Net Income 2016: $25,2812016Revenue 2017: $110,923Expenses 2017: $96,869Net Income 2017: $14,0542017Revenue 2018: $109,315Expenses 2018: $96,569Net Income 2018: $12,7462018Revenue 2019: $103,657Expenses 2019: $84,715Net Income 2019: $18,9422019Revenue 2020: $92,410Expenses 2020: $72,009Net Income 2020: $20,4012020Revenue 2021: $92,784Expenses 2021: $76,965Net Income 2021: $15,8192021Revenue 2022: $86,221Expenses 2022: $66,886Net Income 2022: $19,3352022Revenue 2023: $75,810Expenses 2023: $70,603Net Income 2023: $5,2072023Revenue 2024: $73,547Expenses 2024: $66,446Net Income 2024: $7,1012024

Highlighted filing

2017

Revenue$110,923
Expenses$96,869
Net Income$14,054
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
May 11, 2018
Return Version
2017v2.2
Gross Receipts
$110,923
Mission and Program Overview

Mission

see note below

Program Services

DescriptionGrantsExpenses
TO MAKE MOTOR VEHICLE INSURANCE AVAILABLE FOR PERSONS NOT ABLE TO OBTAIN COVERAGE IN THE VOLUNTARY MARKET.--
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
-Gov Comm Member-$0--
ERIN ODELLGov Comm Member-$0--
-Gov Comm Member-$0--
-Gov Comm Member-$0--
-Gov Comm Member-$0--
-Gov Comm Member-$0--
RONALD BIXBYGov Comm Member-$0--
-Gov Comm Member-$0--
-Gov Comm Member-$0--
Filing and Contact Details

Filer

Filer Name
Vermont Automobile Insurance Plan
EIN
23-7234308
Phone
4019462310
Address
c/o AIPSO 302 CENTRAL AVENUE, JOHNSTON, RI 02919-4932

Signing Officer

Name
David Maynard
Title
Accounting Manager
Phone
4019462310
Signed
2018-05-11
Supplemental Narrative

Additional Explanations

Form 990EZ, Part I, Line 16

Insurance 347.

Form 990EZ, Part I, Line 16

Travel 656.

Form 990EZ, Part I, Line 16

Payroll processing 204.

Form 990EZ, Part I, Line 16

Equipment Rental 341.

Form 990EZ, Part I, Line 16

Miscellaneous 22.

Form 990EZ, Part I, Line 20

Reapportionment of prior year's excess -22901.

Form 990EZ, Part I, Line 20

Reallocation adjustment 1168.

Form 990EZ, Part I, Line 20

pension related changes other thna net periodic cost -6629.

Form 990EZ, Part II, Line 24

Accounts Receivable 6091. 3334.

Form 990EZ, Part II, Line 24

Prepaid Expenses 0. 0.

Form 990EZ, Part II, Line 26

Accounts Payable & Accrued Expenses 4195. 2882.

Form 990EZ, Part II, Line 26

Due to AIPSO - pension 46543. 54151.

Form 990EZ, Part II, Line 26

Due to AIPSO - vacation 1897. 1650.

Form 990, Part IX, Line 24E

Miscellaneous

Form 990, Part IX, Line 24E

Bad debt

Raw XML Appendix155 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/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0AIPSO
IRS990EZ/BooksInCareOfDetail/PhoneNum04019462310
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0302 CENTRAL AVENUE
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0JOHNSTON
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0RI
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd0029194932
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt019800
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt014297
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt00
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt014054
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt017914
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt025891
IRS990EZ/Form990TotalAssetsGrp/EOYAmt017631
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GainOrLossFromSaleOfAssetsAmt00
IRS990EZ/GamingGrossIncomeAmt00
IRS990EZ/GrossProfitLossSlsOfInvntryAmt00
IRS990EZ/GrossReceiptsAmt0110923
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0167
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt0110756
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0-26744
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0-41052
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0-26744
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0-41052
IRS990EZ/OccupancyRentUtltsAndMaintAmt04541
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt31.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt41.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt51.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt61.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt71.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt81.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/BusinessName/BusinessNameLine1Txt0Concord General Mut Ins Co
IRS990EZ/OfficerDirectorTrusteeEmplGrp/BusinessName/BusinessNameLine1Txt1Nationwide Mutual Ins Co
IRS990EZ/OfficerDirectorTrusteeEmplGrp/BusinessName/BusinessNameLine1Txt2State Farm Mut Auto Ins Co
IRS990EZ/OfficerDirectorTrusteeEmplGrp/BusinessName/BusinessNameLine1Txt3The Travelers Co's Inc
IRS990EZ/OfficerDirectorTrusteeEmplGrp/BusinessName/BusinessNameLine1Txt4Allstate Insurance Co
IRS990EZ/OfficerDirectorTrusteeEmplGrp/BusinessName/BusinessNameLine1Txt5Amica Mut Ins Co
IRS990EZ/OfficerDirectorTrusteeEmplGrp/BusinessName/BusinessNameLine1Txt6Progressive Cas Ins Co
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt70
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt80
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0ERIN ODELL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1RONALD BIXBY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0Gov Comm Member
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Gov Comm Member
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Gov Comm Member
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Gov Comm Member
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4Gov Comm Member
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5Gov Comm Member
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6Gov Comm Member
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt7Gov Comm Member
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt8Gov Comm Member
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt06091
IRS990EZ/OtherAssetsTotalDetail/EOYAmt03334
IRS990EZ/OtherChangesInNetAssetsAmt0-28362
IRS990EZ/OtherExpensesTotalAmt01570
IRS990EZ/PrimaryExemptPurposeTxt0see note below
IRS990EZ/PrintingPublicationsPostageAmt0242
IRS990EZ/ProgramServiceRevenueAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0TO MAKE MOTOR VEHICLE INSURANCE AVAILABLE FOR PERSONS NOT ABLE TO OBTAIN COVERAGE IN THE VOLUNTARY MARKET.
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt072602
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/SpecialEventsNetIncomeLossAmt00
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt052635
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt058683
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt096869
IRS990EZ/TotalRevenueAmt0110923
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationAssocInd0X
IRS990EZ/WebsiteAddressTxt0www.aipso.com/vt
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Insurance 347.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Travel 656.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Payroll processing 204.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Equipment Rental 341.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4Miscellaneous 22.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5Reapportionment of prior year's excess -22901.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6Reallocation adjustment 1168.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7pension related changes other thna net periodic cost -6629.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt8Accounts Receivable 6091. 3334.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt9Prepaid Expenses 0. 0.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt10Accounts Payable & Accrued Expenses 4195. 2882.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt11Due to AIPSO - pension 46543. 54151.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt12Due to AIPSO - vacation 1897. 1650.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt13Miscellaneous
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt14Bad debt
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Form 990EZ, Part I, Line 20
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6Form 990EZ, Part I, Line 20
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7Form 990EZ, Part I, Line 20
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc8Form 990EZ, Part II, Line 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc9Form 990EZ, Part II, Line 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc10Form 990EZ, Part II, Line 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc11Form 990EZ, Part II, Line 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc12Form 990EZ, Part II, Line 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc13Form 990, Part IX, Line 24e
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc14Form 990, Part IX, Line 24e
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/PersonNm0DAVID MAYNARD
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0ACCOUNTING MANAGER
ReturnHeader/BusinessOfficerGrp/PhoneNum04019462310
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-11
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0VERMONT AUTOMOBILE INSURANCE PLAN
ReturnHeader/Filer/BusinessNameControlTxt0VERM
ReturnHeader/Filer/EIN0237234308
ReturnHeader/Filer/PhoneNum04019462310
ReturnHeader/Filer/USAddress/AddressLine1Txt0c/o AIPSO 302 CENTRAL AVENUE
ReturnHeader/Filer/USAddress/CityNm0JOHNSTON
ReturnHeader/Filer/USAddress/StateAbbreviationCd0RI
ReturnHeader/Filer/USAddress/ZIPCd0029194932
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0C90AFD6DC90ACA4F5CB076DBBBFEC717CF36B374
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0C90AFD6DC90ACA4F5CB076DBBBFEC717CF36B374
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0165.225.38.71
ReturnHeader/FilingSecurityInformation/IPDt02018-09-19
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0PD
ReturnHeader/FilingSecurityInformation/IPTm005:16:15
ReturnHeader/ReturnTs02018-09-19T05:16:20-07:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$0.17$0.28$0.11$0.74$0.66$0.07
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.14$0.34$0.20$0.76$0.71$0.05
2022Detailed filing. Detailed filing data is available for this year.$0.25$0.36$0.11$0.86$0.67$0.19
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.23$0.43$0.20$0.93$0.77$0.16
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.21$0.65$0.44$0.92$0.72$0.20
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.20$0.55$0.34$1.04$0.85$0.19
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.15$0.45$0.30$1.09$0.97$0.13
2017Detailed filing. Detailed filing data is available for this year.$0.18$0.59$0.41$1.11$0.97$0.14
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.26$0.53$0.27$1.40$1.15$0.25
2015XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.24$0.51$0.27$1.33$1.15$0.18
2014Detailed filing. Detailed filing data is available for this year.$0.28$0.73$0.45$1.50$1.18$0.32
2013Detailed filing. Detailed filing data is available for this year.$0.37$0.21$0.16$1.53$1.51$0.01
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.40$0.87$0.47$1.49$1.46$0.03
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.41$0.58$0.18$1.50$1.37$0.13
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.48$0.43$0.05$1.43$1.30$0.13