Civic Intelligence

Rexam Supplemental Unemployment Benefit Trust - Iam

990EZ • Fiscal year 2017 • EIN 13-5656486

Jan 01, 2017 to Dec 31, 2017 • Filed on Oct 25, 2018

10 Longs Peak DriveBroomfield, CO 80021

(303) 460-2376

Siviq Scores

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

Liabilities / Assets

83rd percentile

0.17x

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

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

Liabilities / Revenue

93rd percentile

0.56x

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

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

Net Margin

90th percentile

44%

Higher net margin than 90% of similar nonprofits.

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

Top Officer Pay

77th percentile

$0

Higher top officer pay than 77% of similar nonprofits.

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

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

Asset Growth

82nd percentile

33%

Faster asset growth than 82% of similar nonprofits.

2017 filings • <$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

65th percentile

11%

Faster revenue growth than 65% of similar nonprofits.

2017 filings • <$500k nonprofits • Annualized from 2016 to 2017

Assets

Up

$32,048

Up $7,953 (+33%) from 2016

Net Assets

Up

$26,748

Up $4,203 (+19%) from 2016

Liabilities

Up

$5,300

Up $3,750 (+242%) from 2016

Revenue

Up

$9,503

Up $958 (+11%) from 2016

Expenses

Down

$5,300

Down $393 (-6.9%) from 2016

Net Income

Up

$4,203

Up $1,351 (+47%) from 2016

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

2017

Assets$32,048
Liabilities$5,300
Net Assets$26,748

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

2017

Revenue$9,503
Expenses$5,300
Net Income$4,203
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Oct 25, 2018
Return Version
2017v2.3
Gross Receipts
$9,503
Mission and Program Overview

Mission

To provide supplemental unemployment benefits.

Program Services

DescriptionGrantsExpenses
PROVIDE SUPPLEMENTAL UNEMPLOYMENT BENEFITS DUE TO LAYOFFS OR SHORT WORK WEEKS.$0$0
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
SCOTT MORRISONTrustee-$0--
NATE CAREYVP & Controller-$0--
JOHN KOELLINGTrustee-$0--
Filing and Contact Details

Filer

Filer Name
Rexam Supplemental Unemployment
EIN
13-5656486
Phone
3034602376
Address
10 LONGS PEAK DRIVE, BROOMFIELD, CO 80021

Signing Officer

Name
John Wells
Title
VP Global Tax
Phone
3034602376
Signed
2018-10-25
Discuss with paid preparer
Yes

Preparer

Firm
Anton Collins Mitchell Llp
Address
303 EAST 17TH AVENUE SUITE 600, DENVER, CO 80203
Preparer
Jeffrey W Barker CPA
Phone
3038301120
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 4 - Other Investment Income

Description: investment income. Amount: 153.

Form 990-ez, Part II, Line 24 - Other Assets

Description: other receivables. Beg. Of year amount: 6. End of year amount: 21. Description: employer contributions receivable. Beg. Of year amount: 0. End of year amount: 5,300.

Form 990-ez, Part II, Line 26 - Other Liabilities

Description: trustee fees payable. Beg. Of year amount: 1,550. End of year amount: 5,300.

Raw XML Appendix116 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/BenefitsPaidToOrForMembersAmt00
IRS990EZ/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0MORGEN BANES
IRS990EZ/BooksInCareOfDetail/PhoneNum03034602376
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt010 LONGS PEAK DRIVE
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0BROOMFIELD
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0CO
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd080021
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt024089
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt026727
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd00
IRS990EZ/DirectIndirectPltclExpendAmt00
IRS990EZ/DonorAdvisedFndsInd00
IRS990EZ/ExcessOrDeficitForYearAmt04203
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt05300
IRS990EZ/ForeignFinancialAccountInd00
IRS990EZ/ForeignOfficeInd00
IRS990EZ/Form990TotalAssetsGrp/BOYAmt024095
IRS990EZ/Form990TotalAssetsGrp/EOYAmt032048
IRS990EZ/GrossReceiptsAmt09503
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InfoInScheduleOPartVInd0X
IRS990EZ/InvestmentIncomeAmt0153
IRS990EZ/MadeLoansToFromOfficersInd00
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt022545
IRS990EZ/NetAssetsOrFundBalancesEOYAmt026748
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt022545
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt026748
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/PersonNm0SCOTT MORRISON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1NATE CAREY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2JOHN KOELLING
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1VP & CONTROLLER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2TRUSTEE
IRS990EZ/OperateHospitalInd00
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd00
IRS990EZ/OrganizationHadUBIInd00
IRS990EZ/OtherAssetsTotalDetail/BOYAmt06
IRS990EZ/OtherAssetsTotalDetail/EOYAmt05321
IRS990EZ/OtherChangesInNetAssetsAmt00
IRS990EZ/PoliticalCampaignActyInd00
IRS990EZ/PrimaryExemptPurposeTxt0TO PROVIDE SUPPLEMENTAL UNEMPLOYMENT BENEFITS.
IRS990EZ/ProgramServiceRevenueAmt09350
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PROVIDE SUPPLEMENTAL UNEMPLOYMENT BENEFITS DUE TO LAYOFFS OR SHORT WORK WEEKS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt00
IRS990EZ/ProhibitedTaxShelterTransInd00
IRS990EZ/RelatedOrganizationCtrlEntInd00
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SubjectToProxyTaxInd00
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt01550
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt05300
IRS990EZ/TanningServicesProvidedInd00
IRS990EZ/TotalExpensesAmt05300
IRS990EZ/TotalRevenueAmt09503
IRS990EZ/TransactionWithControlEntInd00
IRS990EZ/TypeOfOrganizationTrustInd0X
IRS990EZ/WebsiteAddressTxt0WWW.REXAM.COM
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0DESCRIPTION: INVESTMENT INCOME. AMOUNT: 153.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1DESCRIPTION: OTHER RECEIVABLES. BEG. OF YEAR AMOUNT: 6. END OF YEAR AMOUNT: 21. DESCRIPTION: EMPLOYER CONTRIBUTIONS RECEIVABLE. BEG. OF YEAR AMOUNT: 0. END OF YEAR AMOUNT: 5,300.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2DESCRIPTION: TRUSTEE FEES PAYABLE. BEG. OF YEAR AMOUNT: 1,550. END OF YEAR AMOUNT: 5,300.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 4 - OTHER INVESTMENT INCOME
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART II, LINE 24 - OTHER ASSETS
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART II, LINE 26 - OTHER LIABILITIES
TransferPrsnlBnftContractsDecl/DeclarationDesc0THE ORGANIZATION DID NOT, DURING THE YEAR, RECEIVE ANY FUNDS, DIRECTLY,OR INDIRECTLY, TO PAY PREMIUMS ON A PERSONAL BENEFIT CONTRACT.THE ORGANIZATION, DID NOT, DURING THE YEAR, PAY ANY PREMIUMS, DIRECTLY,OR INDIRECTLY, ON A PERSONAL BENEFIT CONTRACT.
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0JOHN WELLS
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0VP GLOBAL TAX
ReturnHeader/BusinessOfficerGrp/PhoneNum03034602376
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-10-25
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0REXAM SUPPLEMENTAL UNEMPLOYMENT
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0BENEFIT TRUST - IAM
ReturnHeader/Filer/BusinessNameControlTxt0REXA
ReturnHeader/Filer/EIN0135656486
ReturnHeader/Filer/PhoneNum03034602376
ReturnHeader/Filer/USAddress/AddressLine1Txt010 LONGS PEAK DRIVE
ReturnHeader/Filer/USAddress/CityNm0BROOMFIELD
ReturnHeader/Filer/USAddress/StateAbbreviationCd0CO
ReturnHeader/Filer/USAddress/ZIPCd080021
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0D15B1461A316A41821681D71F45409B04D1EA1A8
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId06C9B1A35775087DBDB8A6D25ECA509C7F6C27838
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt038.140.185.74
ReturnHeader/FilingSecurityInformation/IPDt02018-10-25
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0MD
ReturnHeader/FilingSecurityInformation/IPTm012:44:06
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0010724563
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0ANTON COLLINS MITCHELL LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0303 EAST 17TH AVENUE SUITE 600
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0DENVER
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0CO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd080203
ReturnHeader/PreparerPersonGrp/PhoneNum03038301120
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JEFFREY W BARKER CPA
ReturnHeader/ReturnTs02018-11-12T09:13:31-06: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.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