Civic Intelligence

Minnesota Automobile Insurance Plan

990EZ • Fiscal year 2016 • EIN 41-6037496

Jan 01, 2016 to Dec 31, 2016 • Filed on Jul 26, 2017

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

89th percentile

0.43x

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

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

Liabilities / Revenue

97th percentile

0.80x

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

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

Net Margin

82nd percentile

18%

Higher net margin than 82% of similar nonprofits.

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

Top Officer Pay

69th percentile

$200

Higher top officer pay than 69% of similar nonprofits.

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

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

Asset Growth

65th percentile

9.8%

Faster asset growth than 65% of similar nonprofits.

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

Revenue Growth

28th percentile

-9.7%

Faster revenue growth than 28% of similar nonprofits.

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

Assets

Up

$145,613

Up $12,981 (+9.8%) from 2015

Net Assets

$82,902

No earlier filing loaded for comparison.

Liabilities

Up

$62,711

Up $2,851 (+4.8%) from 2015

Revenue

Down

$77,950

Down $8,401 (-9.7%) from 2015

Expenses

Down

$63,559

Down $5,881 (-8.5%) from 2015

Net Income

Down

$14,391

Down $2,520 (-15%) from 2015

Historical Trend

Balance Sheet Trend

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

$200K$100K$0-$100KAssets 2010: $33,345Liabilities 2010: $2,075Net Assets 2010: $31,2702010Assets 2011: $30,835Liabilities 2011: $5,973Net Assets 2011: $24,8622011Assets 2012: $34,782Liabilities 2012: $6,394Net Assets 2012: $28,3882012Assets 2013: $90,336Liabilities 2013: $9,220Net Assets 2013: $81,1162013Assets 2014: $70,302Liabilities 2014: $4,2172014Assets 2015: $132,632Liabilities 2015: $59,8602015Assets 2016: $145,613Liabilities 2016: $62,711Net Assets 2016: $82,9022016Assets 2017: $163,327Liabilities 2017: $74,4302017Assets 2018: $145,690Liabilities 2018: $65,829Net Assets 2018: $79,8612018Assets 2019: $187,671Liabilities 2019: $73,620Net Assets 2019: $114,0512019Assets 2020: $83,218Liabilities 2020: $98,553Net Assets 2020: -$15,3352020

Highlighted filing

2016

Assets$145,613
Liabilities$62,711
Net Assets$82,902

Operations Trend

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

$200K$100K$0-$100K-$200KRevenue 2010: $87,977Expenses 2010: $79,001Net Income 2010: $8,9762010Revenue 2011: $88,238Expenses 2011: $76,832Net Income 2011: $11,4062011Revenue 2012: $85,873Expenses 2012: $75,052Net Income 2012: $10,8212012Revenue 2013: $90,964Expenses 2013: $80,484Net Income 2013: $10,4802013Revenue 2014: $78,621Expenses 2014: $61,039Net Income 2014: $17,5822014Revenue 2015: $86,351Expenses 2015: $69,440Net Income 2015: $16,9112015Revenue 2016: $77,950Expenses 2016: $63,559Net Income 2016: $14,3912016Revenue 2017: $81,212Expenses 2017: $72,640Net Income 2017: $8,5722017Revenue 2018: $72,478Expenses 2018: $41,668Net Income 2018: $30,8102018Revenue 2019: $75,721Expenses 2019: $58,972Net Income 2019: $16,7492019Revenue 2020: $5,619Expenses 2020: $126,546Net Income 2020: -$120,9272020

Highlighted filing

2016

Revenue$77,950
Expenses$63,559
Net Income$14,391
Jump To
Filing Snapshot
Filing Period
Jan 1, 2016 to Dec 31, 2016
Signed
Jul 26, 2017
Return Version
2016v3.0
Gross Receipts
$77,950
Mission and Program Overview

Mission

see note below

Program Services

DescriptionGrantsExpenses
To make motor vehicle insurance available to those persons not able to obtain coverage in the voluntary market.--
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
FEDERICK RAMOSGov Comm Member-$200-$200
WILLIAM HARPERGov Comm Member-$200-$200
MATTHEW BRENENGENGov Comm Member-$200-$200
ANDREW WHITMANGov Comm Member-$200-$200
-Gov Comm Member-$0--
-Gov Comm Member-$0--
-Gov Comm Member-$0--
-Gov Comm Member-$0--
Filing and Contact Details

Filer

Filer Name
Minnesota Automobile Insurance Plan
EIN
41-6037496
Phone
4019462310
Address
c/o AIPSO 302 CENTRAL AVENUE, JOHNSTON, RI 02919-4932

Signing Officer

Name
David Maynard
Title
Accounting Manager
Phone
4019462310
Signed
2017-07-26
Supplemental Narrative

Additional Explanations

Form 990EZ, Part I, Line 16

Insurance 150.

Form 990EZ, Part I, Line 16

Travel 3168.

Form 990EZ, Part I, Line 16

Bank charges 432.

Form 990EZ, Part I, Line 16

Bad debt 930.

Form 990EZ, Part I, Line 16

Miscellaneous 82.

Form 990EZ, Part I, Line 20

Reapportionment of prior year's excess -7379.

Form 990EZ, Part I, Line 20

Reallocation adjustment 3608.

Form 990EZ, Part I, Line 20

Pension related changes other than net periodic cost -490.

Form 990EZ, Part II, Line 24

Accounts Receivable net 4583. 4009.

Form 990EZ, Part II, Line 24

Prepaid Pension 118302. 129827.

Form 990EZ, Part II, Line 26

Accounts Payable & Accrued Expenses 4294. 2384.

Form 990EZ, Part II, Line 26

Due to AIPSO - pension 35007. 36310.

Form 990EZ, Part II, Line 26

Due to plans - pension 20559. 24017.

Raw XML Appendix147 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/BOYAmt09747
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt011777
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt00
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt014391
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt020185
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0132632
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0145613
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GainOrLossFromSaleOfAssetsAmt00
IRS990EZ/GamingGrossIncomeAmt00
IRS990EZ/GrossProfitLossSlsOfInvntryAmt00
IRS990EZ/GrossReceiptsAmt077950
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt027
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt077923
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt072772
IRS990EZ/NetAssetsOrFundBalancesEOYAmt082902
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt072772
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt082902
IRS990EZ/OccupancyRentUtltsAndMaintAmt0939
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/BusinessName/BusinessNameLine1Txt0Employers Mutual Companies
IRS990EZ/OfficerDirectorTrusteeEmplGrp/BusinessName/BusinessNameLine1Txt1Farmers Insurance Group
IRS990EZ/OfficerDirectorTrusteeEmplGrp/BusinessName/BusinessNameLine1Txt2State Farm Mut Auto Ins Co
IRS990EZ/OfficerDirectorTrusteeEmplGrp/BusinessName/BusinessNameLine1Txt3Austin Mutual Ins Co
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt4200
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt5200
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt6200
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt7200
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0FEDERICK RAMOS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1WILLIAM HARPER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2MATTHEW BRENENGEN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3ANDREW WHITMAN
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/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt0122885
IRS990EZ/OtherAssetsTotalDetail/EOYAmt0133836
IRS990EZ/OtherChangesInNetAssetsAmt0-4261
IRS990EZ/OtherExpensesTotalAmt04762
IRS990EZ/PrimaryExemptPurposeTxt0see note below
IRS990EZ/PrintingPublicationsPostageAmt0716
IRS990EZ/ProgramServiceRevenueAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0To make motor vehicle insurance available to those persons not able to obtain coverage in the voluntary market.
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt036957
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/SpecialEventsNetIncomeLossAmt00
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt059860
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt062711
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt063559
IRS990EZ/TotalRevenueAmt077950
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationAssocInd0X
IRS990EZ/WebsiteAddressTxt0www.aipso.com/mn
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Insurance 150.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Travel 3168.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Bank charges 432.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Bad debt 930.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4Miscellaneous 82.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5Reapportionment of prior year's excess -7379.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6Reallocation adjustment 3608.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7Pension related changes other than net periodic cost -490.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt8Accounts Receivable net 4583. 4009.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt9Prepaid Pension 118302. 129827.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt10Accounts Payable & Accrued Expenses 4294. 2384.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt11Due to AIPSO - pension 35007. 36310.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt12Due to plans - pension 20559. 24017.
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
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/PersonNm0DAVID MAYNARD
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0ACCOUNTING MANAGER
ReturnHeader/BusinessOfficerGrp/PhoneNum04019462310
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-07-26
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0MINNESOTA AUTOMOBILE INSURANCE PLAN
ReturnHeader/Filer/BusinessNameControlTxt0MINN
ReturnHeader/Filer/EIN0416037496
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/AtSubmissionCreationDeviceId02A0955F98B5687D8F32B58D4D08A8C2C40F71CCC
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId02A0955F98B5687D8F32B58D4D08A8C2C40F71CCC
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0199.168.151.172
ReturnHeader/FilingSecurityInformation/IPDt02017-07-26
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0PD
ReturnHeader/FilingSecurityInformation/IPTm007:07:40
ReturnHeader/ReturnTs02017-07-26T07:07:45-07:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-01-01
ReturnHeader/TaxPeriodEndDt02016-12-31
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings