Civic Intelligence

Rexam Supplemental Unemployment Benefit Trust - Iam

990EZ • Fiscal year 2015 • EIN 13-5656486

Jan 01, 2015 to Dec 31, 2015 • Filed on Sep 19, 2016

8770 W Bryn Mawr AveChicago, IL 60631-3515

(773) 399-3000

Siviq Scores

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

Liabilities / Assets

78th percentile

0.07x

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

2015 filings • <$500k nonprofits • Source year 2015

Liabilities / Revenue

82nd percentile

0.09x

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

2015 filings • <$500k nonprofits • Source year 2015

Net Margin

93rd percentile

59%

Higher net margin than 93% of similar nonprofits.

2015 filings • <$500k nonprofits • Source year 2015

Top Officer Pay

76th percentile

$0

Higher top officer pay than 76% of similar nonprofits.

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

2015 filings • <$500k nonprofits • Source year 2015

Asset Growth

93rd percentile

102%

Faster asset growth than 93% of similar nonprofits.

2015 filings • <$500k nonprofits • Annualized from 2014 to 2015

Revenue Growth

14th percentile

-39%

Faster revenue growth than 14% of similar nonprofits.

2015 filings • <$500k nonprofits • Annualized from 2014 to 2015

Assets

Up

$21,243

Up $10,710 (+102%) from 2014

Net Assets

Up

$19,693

Up $9,930 (+102%) from 2014

Liabilities

Up

$1,550

Up $780 (+101%) from 2014

Revenue

Down

$16,780

Down $10,758 (-39%) from 2014

Expenses

Down

$6,850

Down $20,771 (-75%) from 2014

Net Income

Up

$9,930

Up $10,013 (+12064%) from 2014

Historical Trend

Balance Sheet Trend

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

$40K$30K$20K$10K$0Assets 2010: $18,409Liabilities 2010: $1,260Net Assets 2010: $17,1492010Assets 2011: $18,153Liabilities 2011: $4,827Net Assets 2011: $13,3262011Assets 2012: $16,030Liabilities 2012: $4,219Net Assets 2012: $11,8112012Assets 2013: $14,580Liabilities 2013: $4,734Net Assets 2013: $9,8462013Assets 2014: $10,533Liabilities 2014: $770Net Assets 2014: $9,7632014Assets 2015: $21,243Liabilities 2015: $1,550Net Assets 2015: $19,6932015Assets 2016: $24,095Liabilities 2016: $1,550Net Assets 2016: $22,5452016Assets 2017: $32,048Liabilities 2017: $5,300Net Assets 2017: $26,7482017Assets 2018: $20,033Liabilities 2018: $1,0602018Assets 2019: $21,543Liabilities 2019: $02019Assets 2020: $21,590Liabilities 2020: $02020Assets 2021: $21,593Liabilities 2021: $0Net Assets 2021: $21,5932021Assets 2022: $21,870Liabilities 2022: $0Net Assets 2022: $21,8702022Assets 2023: $19Liabilities 2023: $0Net Assets 2023: $192023Assets 2024: $0Liabilities 2024: $0Net Assets 2024: $02024

Highlighted filing

2015

Assets$21,243
Liabilities$1,550
Net Assets$19,693

Operations Trend

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

$150K$100K$50K$0-$50KRevenue 2010: $7,424Expenses 2010: $17,520Net Income 2010: -$10,0962010Revenue 2011: $114,479Expenses 2011: $118,302Net Income 2011: -$3,8232011Revenue 2012: $43,972Expenses 2012: $45,487Net Income 2012: -$1,5152012Revenue 2013: $8,036Expenses 2013: $10,001Net Income 2013: -$1,9652013Revenue 2014: $27,538Expenses 2014: $27,621Net Income 2014: -$832014Revenue 2015: $16,780Expenses 2015: $6,850Net Income 2015: $9,9302015Revenue 2016: $8,545Expenses 2016: $5,693Net Income 2016: $2,8522016Revenue 2017: $9,503Expenses 2017: $5,300Net Income 2017: $4,2032017Revenue 2018: $2,094Expenses 2018: $1,310Net Income 2018: $7842018Revenue 2019: $2,570Expenses 2019: $0Net Income 2019: $2,5702019Revenue 2020: $47Expenses 2020: $0Net Income 2020: $472020Revenue 2021: $3Expenses 2021: $0Net Income 2021: $32021Revenue 2022: $277Expenses 2022: $0Net Income 2022: $2772022Revenue 2023: $898Expenses 2023: $0Net Income 2023: $8982023Revenue 2024: $0Expenses 2024: $0Net Income 2024: $02024

Highlighted filing

2015

Revenue$16,780
Expenses$6,850
Net Income$9,930
Jump To
Filing Snapshot
Filing Period
Jan 1, 2015 to Dec 31, 2015
Signed
Sep 19, 2016
Return Version
2015v2.1
Gross Receipts
$16,780
Mission and Program Overview

Mission

To provide supplemental unemployment benefits.

Program Services

DescriptionGrantsExpenses
Provide supplemental unemployment benefits due to layoffs or short work weeks.--
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
Joshua MarkusTrustee-$0--
Michael MacGregorTrustee-$0--
Thomas HolzTrustee-$0--
Filing and Contact Details

Filer

Filer Name
Rexam Supplemental
EIN
13-5656486
In Care Of
% RICK FROHOCK
Phone
7733993000
Address
8770 W Bryn Mawr Ave, Chicago, IL 60631-3515

Signing Officer

Name
Michael Macgregor
Title
Trustee
Phone
7733993000
Signed
2016-09-19
Discuss with paid preparer
Yes

Preparer

Firm
Baker Tilly Virchow Krause LLP
Address
205 N Michigan Ave 28th Floor, Chicago, IL 60601-5927
Preparer
Mark Heroux
Phone
3127298000
Supplemental Narrative

Additional Explanations

Form 990EZ Part II Line 24

Description:COMPANY CONTRIBUTION RECEIVABL BOY Amount:2309 EOY Amount:

Form 990EZ Part II Line 26

Description:ACCRUED TRUST FEES BOY Amount:770

Form 990EZ Part II Line 26

Description:TRUSTEE FEES PAYABLE BOY Amount:EOY Amount:1550

Raw XML Appendix113 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/PersonNm0RICK FROHOCK
IRS990EZ/BooksInCareOfDetail/PhoneNum07733993000
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt08770 W BRYN MAWR AVE
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Chicago
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IL
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd0606313515
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt08224
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt021243
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt09930
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt06850
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt010533
IRS990EZ/Form990TotalAssetsGrp/EOYAmt021243
IRS990EZ/GainOrLossFromSaleOfAssetsAmt00
IRS990EZ/GrossProfitLossSlsOfInvntryAmt00
IRS990EZ/GrossReceiptsAmt016780
IRS990EZ/GrossReceiptsForPublicUseAmt00
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InitiationFeesAndCapContriAmt00
IRS990EZ/InvestmentIncomeAmt03
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt09763
IRS990EZ/NetAssetsOrFundBalancesEOYAmt019693
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt09763
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt019693
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00.25
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10.25
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt20.25
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0Joshua Markus
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1Michael MacGregor
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2Thomas Holz
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0Trustee
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Trustee
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Trustee
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt02309
IRS990EZ/OtherAssetsTotalDetail/EOYAmt00
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO PROVIDE SUPPLEMENTAL UNEMPLOYMENT BENEFITS.
IRS990EZ/ProgramServiceRevenueAmt016777
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0Provide supplemental unemployment benefits due to layoffs or short work weeks.
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt00
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/SpecialEventsNetIncomeLossAmt00
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt0770
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt01550
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt06850
IRS990EZ/TotalRevenueAmt016780
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationTrustInd0X
IRS990EZ/WebsiteAddressTxt0www.rexam.com
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Description:COMPANY CONTRIBUTION RECEIVABL BOY Amount:2309 EOY Amount:
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Description:ACCRUED TRUST FEES BOY Amount:770
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Description:TRUSTEE FEES PAYABLE BOY Amount:EOY Amount:1550
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990EZ PART II LINE 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990EZ PART II LINE 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990EZ PART II LINE 26
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0MICHAEL MACGREGOR
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Trustee
ReturnHeader/BusinessOfficerGrp/PhoneNum07733993000
ReturnHeader/BusinessOfficerGrp/SignatureDt02016-09-19
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Rexam Supplemental
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0Unemployment Benefit Trust - IAM
ReturnHeader/Filer/BusinessNameControlTxt0REXA
ReturnHeader/Filer/EIN0135656486
ReturnHeader/Filer/InCareOfNm0% RICK FROHOCK
ReturnHeader/Filer/PhoneNum07733993000
ReturnHeader/Filer/USAddress/AddressLine1Txt08770 W Bryn Mawr Ave
ReturnHeader/Filer/USAddress/CityNm0Chicago
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd0606313515
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Baker Tilly Virchow Krause LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0205 N Michigan Ave 28th Floor
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Chicago
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0606015927
ReturnHeader/PreparerPersonGrp/PhoneNum03127298000
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Mark Heroux
ReturnHeader/ReturnTs02016-10-07T10:01:50-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02015-01-01
ReturnHeader/TaxPeriodEndDt02015-12-31
ReturnHeader/TaxYr02015

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.00$0.00$0.00$0.00$0.00$0.00
2023Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.01$0.00$0.01
2022Detailed filing. Detailed filing data is available for this year.$0.22$0.00$0.22$0.00$0.00$0.00
2021Detailed filing. Detailed filing data is available for this year.$0.22$0.00$0.22$0.00$0.00$0.00
2020Summary only. Only limited summary data is available for this year.$0.22$0.00$0.00$0.00$0.00
2019Summary only. Only limited summary data is available for this year.$0.22$0.00$0.03$0.00$0.03
2018Summary only. Only limited summary data is available for this year.$0.20$0.01$0.02$0.01$0.01
2017Detailed filing. Detailed filing data is available for this year.$0.32$0.05$0.27$0.10$0.05$0.04
2016Detailed filing. Detailed filing data is available for this year.$0.24$0.02$0.23$0.09$0.06$0.03
2015Detailed filing. Detailed filing data is available for this year.$0.21$0.02$0.20$0.17$0.07$0.10
2014Detailed filing. Detailed filing data is available for this year.$0.11$0.01$0.10$0.28$0.28$0.00
2013Detailed filing. Detailed filing data is available for this year.$0.15$0.05$0.10$0.08$0.10$0.02
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.16$0.04$0.12$0.44$0.45$0.02
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.18$0.05$0.13$1.14$1.18$0.04
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.18$0.01$0.17$0.07$0.18$0.10