finance prob

profileSteven01U05K
Financials.xlsx
Home>Business & Finance homework help>Accounting homework help>finance prob

Income Statement

COLM_income-statement_Annual_Restated 2018 2019 2020 2021 2022 TTM
Gross Profit 1386348000 1515670000 1223889000 1612455000 1711078000 1711078000
Total Revenue 2802326000 3042478000 2501554000 3126402000 3464152000 3464152000
Business Revenue 2802326000 3042478000 2501554000 3126402000 3464152000 3464152000
Cost of Revenue -1415978000 -1526808000 -1277665000 -1513947000 -1753074000 -1753074000
Cost of Goods and Services -1415978000 -1526808000 -1277665000 -1513947000 -1753074000 -1753074000
Operating Income/Expenses -1035366000 -1120699000 -1086840000 -1161951000 -1282374000 -1282374000
Selling, General and Administrative Expenses -1051152000 -1136186000 -1098948000 -1180323000 -1304394000 -1304394000
Other Income/Expense, Operating 15786000 15487000 12108000 18372000 22020000 22020000
Other Income, Operating 15786000 15487000 12108000 18372000 22020000 22020000
Total Operating Profit/Loss 350982000 394971000 137049000 450504000 428704000 428704000
Non-Operating Income/Expense, Total 9735000 10458000 2474000 1007000 -31294000 -31294000
Total Net Finance Income/Expense 9876000 8302000 435000 1380000 2713000 2713000
Net Interest Income/Expense 9876000 8302000 435000 1380000 2713000 2713000
Interest Income 9876000 8302000 435000 1380000 2713000 2713000
Interest Expense Net of Capitalized Interest
Irregular Income/Expense 0 -35600000 -35600000
Goodwill Impairment/Write Off 0 -35600000 -35600000
Other Income/Expense, Non-Operating -141000 2156000 2039000 -373000 1593000 1593000
Pretax Income 360717000 405429000 139523000 451511000 397410000 397410000
Provision for Income Tax -85769000 -74940000 -31510000 -97403000 -85970000 -85970000
Net Income before Extraordinary Items and Discontinued Operations 274948000 330489000 108013000 354108000 311440000 311440000
Net Income after Extraordinary Items and Discontinued Operations 274948000 330489000 108013000 354108000 311440000 311440000
Net Income after Non-Controlling/Minority Interests 268256000 330489000 108013000 354108000 311440000 311440000
Net Income Available to Common Stockholders 268256000 330489000 108013000 354108000 311440000 311440000
Diluted Net Income Available to Common Stockholders 268256000 330489000 108013000 354108000 311440000 311440000
Income Statement Supplemental Section
Reported Normalized and Operating Income/Expense Supplemental Section
Total Revenue as Reported, Supplemental 2802326000 3042478000 2501554000 3126402000 3464152000 3464152000
Reported Total Operating Profit/Loss 350982000 394971000 137049000 450504000 393104000 393104000
Reported Effective Tax Rate 0.24 0.19 0.23 0.22 0.22 0.22
Reported Normalized Income 282044000
Reported Normalized Operating Profit 362431000
Operating Income/Expense, Supplemental Section
Depreciation, Amortization and Depletion, Supplemental -58200000 -62800000 -63400000
Depreciation and Amortization, Supplemental -58200000 -62800000 -63400000
Depreciation, Supplemental -58200000 -59800000 -60900000
Amortization, Supplemental -3000000 -2500000
Non-Controlling/Minority Interests -6692000
Basic EPS 3.85 4.87 1.63 5.37 4.96 4.96
Basic EPS from Continuing Operations 3.85 4.87 1.63 5.37 4.96 4.96
Diluted EPS 3.81 4.83 1.62 5.33 4.95 4.95
Diluted EPS from Continuing Operations 3.81 4.83 1.62 5.33 4.95 4.95
Basic Weighted Average Shares Outstanding 69614000 67837000 66376000 65942000 62754000 62754000
Diluted Weighted Average Shares Outstanding 70401000 68493000 66772000 66415000 62970000 62970000
Total Dividend Per Share 0.9 0.96 0.26 1.04 1.2 1.2
Regular Dividend Per Share Calc 0.9 0.96 0.26 1.04 1.2 1.2
Reported Normalized Basic EPS 4.05
Reported Normalized Diluted EPS 4.01
Basic EPS 3.85 4.87 1.63 5.37 4.96 4.96
Diluted EPS 3.81 4.83 1.62 5.33 4.95 4.95
Basic WASO 69614000 67837000 66376000 65942000 62754000 62754000
Diluted WASO 70401000 68493000 66772000 66415000 62970000 62970000
Fiscal year ends in Dec 31 | USD

Balance Sheet

COLM_balance-sheet_Annual_Restated 2018 2019 2020 2021 2022
Total Assets 2368721000 2931591000 2836571000 3067128000 3051546000
Total Current Assets 1765306000 1875746000 1855621000 2114037000 2136941000
Cash, Cash Equivalents and Short Term Investments 700627000 687677000 791949000 894549000 430963000
Cash and Cash Equivalents 437825000 686009000 790725000 763404000 430241000
Short Term Investments 262802000 1668000 1224000 131145000 722000
Inventories 521827000 605968000 556530000 645379000 1028545000
Trade and Other Receivables, Current 449382000 488233000 452945000 487803000 547561000
Trade/Accounts Receivable, Current 449382000 488233000 452945000 487803000 547561000
Gross Trade/Accounts Receivable, Current 460433000 497158000 474755000 496696000 553004000
Allowance/Adjustments for Trade/Accounts Receivable, Current -11051000 -8925000 -21810000 -8893000 -5443000
Other Current Assets 86306000 129872000
Prepayments and Deposits, Current 79500000 93868000 54197000
Cash Restricted or Pledged, Current 13970000
Deferred Tax Assets, Current
Total Non-Current Assets 603415000 1055845000 980950000 953091000 914605000
Net Property, Plant and Equipment 291596000 741152000 649036000 622016000 615623000
Gross Property, Plant and Equipment 780950000 1264244000 1223283000 1224676000 1239534000
Properties 323645000 378788000 395334000 398771000 406669000
Land and Improvements 20961000 26951000 33231000 33107000 32964000
Buildings and Improvements 170928000 204077000 209251000 209792000 211495000
Leasehold and Improvements 131756000 147760000 152852000 155872000 162210000
Machinery, Furniture and Equipment 415983000 480184000 485329000 482283000 490847000
Plant and Machinery 327678000 383881000 388808000 382337000 386657000
Furniture, Fixtures and Office Equipment 88305000 96303000 96521000 99946000 104190000
Construction in Progress and Advance Payments 41322000 10771000 3376000 12694000 17609000
Leased Property, Plant and Equipment 0 394501000 339244000 330928000 324409000
Accumulated Depreciation and Impairment -489354000 -523092000 -574247000 -602660000 -623911000
Accumulated Depreciation -489354000 -523092000 -574247000 -602660000 -623911000
Net Intangible Assets 195169000 192189000 172152000 170502000 133252000
Gross Goodwill and Other Intangible Assets 221213000 221213000 203713000 203713000 168113000
Goodwill 68594000 68594000 68594000 68594000 51694000
Intangibles other than Goodwill 152619000 152619000 135119000 135119000 116419000
Trademarks and Patents 14198000 14198000 14198000 14198000 14198000
Customer Relationships 23000000 23000000 23000000 23000000 23000000
Other Intangible Assets 115421000 115421000 97921000 97921000 79221000
Accumulated Amortization and Impairment -26044000 -29024000 -31561000 -33211000 -34861000
Accumulated Amortization of Intangible Assets -26044000 -29024000 -31561000 -33211000 -34861000
Accumulated Amortization of Intangibles other than Goodwill -26044000 -29024000 -31561000 -33211000 -34861000
Accumulated Amortization of Trademarks and Patents -11981000 -13311000 -14198000 -14198000 -14198000
Accumulated Amortization of Customer Relationships -14063000 -15713000 -17363000 -19013000 -20663000
Deferred Tax Assets, Non-Current 78155000 78849000 96126000 92121000 94162000
Other Non-Current Assets 38495000 43655000 63636000 68452000 71568000
Total Liabilities 678408000 1082144000 1003800000 1077876000 1115757000
Total Current Liabilities 572882000 630915000 552622000 680390000 738718000
Payables and Accrued Expenses, Current 461994000 441672000 389236000 500318000 540857000
Trade and Other Payables, Current 297198000 286669000 244880000 324406000 364536000
Trade/Accounts Payable, Current 274435000 255372000 206697000 283349000 322472000
Taxes Payable, Current 22763000 31297000 38183000 41057000 42064000
Accrued Expenses, Current 164796000 155003000 144356000 175912000 176321000
Financial Liabilities, Current 0 64019000 65466000 67429000 68685000
Current Debt and Capital Lease Obligation 0 64019000 65466000 67429000 68685000
Current Portion of Long Term Debt and Capital Lease 0 64019000 65466000 67429000 68685000
Capital Lease Obligations, Current 0 64019000 65466000 67429000 68685000
Current Debt
Bank/Credit Facilities, Current Debt
Provisions, Current 110888000 125224000 97920000 112643000 129176000
Other Provisions, Current 110888000 125224000 97920000 112643000 129176000
Tax Liabilities, Current
Deferred Tax Liabilities, Current
Total Non-Current Liabilities 105526000 451229000 451178000 397486000 377039000
Financial Liabilities, Non-Current 0 371507000 353181000 317666000 310625000
Long Term Debt and Capital Lease Obligation 0 371507000 353181000 317666000 310625000
Capital Lease Obligations, Non-Current 0 371507000 353181000 317666000 310625000
Long Term Debt
Notes Payables, Non-Current
Derivative and Hedging Liabilities, Non-Current
Tax Liabilities, Non-Current 9521000 6361000 5205000 0 143000
Deferred Tax Liabilities, Non-Current 9521000 6361000 5205000 0 143000
Payables and Accrued Expenses, Non-Current 50791000 48427000 49922000 44541000 33251000
Trade and Other Payables, Non-Current 50791000 48427000 49922000 44541000 33251000
Taxes Payable, Non-Current 50791000 48427000 49922000 44541000 33251000
Other Non-Current Liabilities 45214000 24934000 42870000 35279000 33020000
Provisions, Non-Current
Provision for Employee Entitlements, Non-Current
Provision for Asset Retirement Obligation/Site Restoration and Rehabilitation, Non-Current
Deferred Liabilities, Non-Current
Other Deferred Liabilities, Non-Current
Total Equity 1690313000 1849447000 1832771000 1989252000 1935789000
Equity Attributable to Parent Stockholders 1673857000 1849447000 1832771000 1989252000 1935789000
Paid in Capital 0 4937000 20165000 0 12692000
Capital Stock 0 4937000 20165000 0 12692000
Common Stock 0 4937000 20165000 0 12692000
Preferred Stock 0 0 0 0 0
Retained Earnings/Accumulated Deficit 1677920000 1848935000 1811800000 1993628000 1953734000
Reserves/Accumulated Comprehensive Income/Losses -4063000 -4425000 806000 -4376000 -30637000
Other Reserves/Accum.Comp.Inc -4376000 -30637000
Non-Controlling/Minority Interests in Equity 16456000
Operating Lease Obligation Maturity Schedule Total 451460000 435526000 418647000 385095000 379310000
Operating Lease due in Year 1 72280000 75833000 92756000 78228000 79832000
Operating Lease due in Year 2 65379000 73078000 73936000 72487000 73958000
Operating Lease due in Year 3 57460000 67424000 66328000 65678000 64814000
Operating Lease due in Year 4 52607000 60998000 58726000 55817000 57184000
Operating Lease due in Year 5 47837000 59216000 51134000 49095000 48000000
Operating Lease due Beyond 155897000 168996000 130429000 106326000 100685000
Operating Lease - Interests Charges and Other Adjustments -70019000 -54662000 -42536000 -45163000
Other Contractual Obligations Maturity Schedule Total 401456000 374875000 343194000 692600000 433000000
Other Contractual Obligations due in Year 1 363799000 337218000 307068000 660700000 409100000
Other Contractual Obligations due in Year 2 1531000 4250000 8000000 10600000
Other Contractual Obligations due in Year 3 1531000 4250000 7969000 10600000 13300000
Other Contractual Obligations due in Year 4 4250000 7969000 10625000 13300000
Other Contractual Obligations due in Year 5 7969000 10625000 13282000
Other Contractual Obligations due Beyond 23907000 13282000
Total Lease Liability 451460000 435526000 418647000 385095000 379310000
Total Lease Liability - Due in year 1 72280000 75833000 92756000 78228000 79832000
Total Lease Liability - Due in year 2 65379000 73078000 73936000 72487000 73958000
Total Lease Liability - Due in year 3 57460000 67424000 66328000 65678000 64814000
Total Lease Liability - Due in year 4 52607000 60998000 58726000 55817000 57184000
Total Lease Liability - Due in year 5 47837000 59216000 51134000 49095000 48000000
Total Lease Liability - Beyond 155897000 168996000 130429000 106326000 100685000
Total Lease Liability - Interest Charges and Other Adjustments -70019000 -54662000 -42536000 -45163000
Total Contractual Obligations 852916000 810401000 761841000 1077695000 812310000
Total Contractual Obligations due in year 1 436079000 413051000 399824000 738928000 488932000
Total Contractual Obligations due in year 2 65379000 74609000 78186000 80487000 84558000
Total Contractual Obligations due in year 3 58991000 71674000 74297000 76278000 78114000
Total Contractual Obligations due in year 4 56857000 68967000 69351000 69117000 57184000
Total Contractual Obligations due in year 5 55806000 69841000 64416000 49095000 48000000
Total Contractual Obligations due Beyond 179804000 182278000 130429000 106326000 100685000
Total Contractual Obligations - Interests Charges and Other Adjustments -70019000 -54662000 -42536000 -45163000
Fiscal year ends in Dec 31 | USD

Cash Flow

COLM_cash-flow_Annual_Restated 2018 2019 2020 2021 2022 TTM
Cash Flow from Operating Activities, Indirect 289569000 285452000 276077000 354406000 -25241000 -25241000
Net Cash Flow from Continuing Operating Activities, Indirect 289569000 285452000 276077000 354406000 -25241000 -25241000
Cash Generated from Operating Activities 289569000 285452000 276077000 354406000 -25241000 -25241000
Income/Loss before Non-Cash Adjustment 274948000 330489000 108013000 354108000 311440000 311440000
Total Adjustments for Non-Cash Items 82099000 143083000 203614000 115374000 166452000 166452000
Depreciation, Amortization and Depletion, Non-Cash Adjustment 58230000 121725000 146601000 115571000 117399000 117399000
Depreciation and Amortization, Non-Cash Adjustment 58230000 121725000 146601000 115571000 117399000 117399000
Stock-Based Compensation, Non-Cash Adjustment 14291000 17832000 17778000 19126000 21021000 21021000
Deferred Taxes, Non-Cash Adjustment 1462000 -1808000 -11263000 -9798000 -8118000 -8118000
Other Provisions, Non-Cash Adjustment 3908000 -108000 19156000 -10758000 -2044000 -2044000
Irregular Income/Loss, Non-Cash Adjustment 4208000 5442000 31342000 1233000 38194000 38194000
Gain/Loss on Disposals, Non-Cash Adjustment 4208000 5442000 31342000 1233000 38194000 38194000
Gain/Loss on Disposal/Sale of Fixed Assets, Non-Cash Adjustment 4208000 5442000 31342000 1233000 38194000 38194000
Excess Tax Benefit from Stock-Based Compensation, Non-Cash Adjustment
Changes in Operating Capital -67478000 -188120000 -35550000 -115076000 -503133000 -503133000
Change in Inventories -94716000 -84058000 64884000 -100261000 -399851000 -399851000
Change in Trade and Other Receivables -29509000 -37429000 22885000 -31622000 -64495000 -64495000
Change in Trade/Accounts Receivable -29509000 -37429000 22885000 -31622000 -64495000 -64495000
Change in Prepayments and Deposits -9771000 -15068000 33712000 -24858000 -25749000 -25749000
Change in Other Current Assets -12421000 -3547000 -21224000 1231000 -2475000 -2475000
Change in Payables and Accrued Expenses 82326000 -958000 -92308000 126722000 55241000 55241000
Change in Trade and Other Payables 15426000 -19821000 -40193000 60265000 34558000 34558000
Change in Trade/Accounts Payable 19384000 -10419000 -49275000 75513000 40429000 40429000
Change in Taxes Payable -3958000 -9402000 9082000 -15248000 -5871000 -5871000
Change in Accrued Expenses 66900000 18863000 -52115000 66457000 20683000 20683000
Change in Other Current Liabilities -3387000 7137000 8613000 -1112000 -3055000 -3055000
Change in Other Operating Capital 0 -54197000 -52112000 -85176000 -62749000 -62749000
Cash Flow from Investing Activities -232231000 140728000 -27171000 -163751000 72740000 72740000
Cash Flow from Continuing Investing Activities -232231000 140728000 -27171000 -163751000 72740000 72740000
Capital Expenditure, Reported -65622000 -123516000 -28758000 -34744000 -58467000 -58467000
Purchase/Sale of Investments, Net -166628000 264244000 1587000 -129007000 131207000 131207000
Purchase of Investments -518755000 -136257000 -35044000 -130191000 -44876000 -44876000
Sale of Investments 352127000 400501000 36631000 1184000 176083000 176083000
Purchase/Sale and Disposal of Property, Plant and Equipment, Net 19000
Sale and Disposal of Property, Plant and Equipment 19000
Purchase/Sale of Business, Net
Purchase/Acquisition of Business
Cash Flow from Financing Activities -270014000 -190722000 -151700000 -210889000 -360831000 -360831000
Cash Flow from Continuing Financing Activities -270014000 -190722000 -151700000 -210889000 -360831000 -360831000
Issuance of/Payments for Common Stock, Net -201600000 -121702000 -132889000 -165415000 -287443000 -287443000
Payments for Common Stock -201600000 -121702000 -132889000 -165415000 -287443000 -287443000
Issuance of/Repayments for Debt, Net 0 0 -724000 178000 -61000 -61000
Issuance of/Repayments for Short Term Debt, Net 0 0 -724000 178000 -61000 -61000
Proceeds from Issuance of Short Term Debt 70576000 78186000 402422000 38334000 52918000 52918000
Repayments for Short Term Debt -70576000 -78186000 -403146000 -38156000 -52979000 -52979000
Issuance of/Repayments for Long Term Debt, Net
Repayments for Long Term Debt
Proceeds from Issuance of Long Term Debt
Issue and Financing Costs 0 0 -3278000 0 -604000 -604000
Debt Issuance Costs 0 0 -3278000 0 -604000 -604000
Cash Dividends and Interest Paid -62664000 -65127000 -17195000 -68623000 -75082000 -75082000
Cash Dividends Paid -62664000 -65127000 -17195000 -68623000 -75082000 -75082000
Common Stock Dividends Paid -62664000 -65127000 -17195000 -68623000 -75082000 -75082000
Proceeds from Issuance/Exercising of Stock Options/Warrants 18484000 19793000 6919000 28783000 6588000 6588000
Other Financing Cash Flow -4285000 -5806000 -4533000 -5812000 -4229000 -4229000
Net Movement in Non-Controlling/Minority Interest 0 -17880000 0
Cash Dividends Paid to Non-Controlling/Minority Interests -19949000
Excess Tax Benefit from Share-Based Compensation, Financing Activities
Cash and Cash Equivalents, End of Period 451795000 686009000 790725000 763404000 430241000 430241000
Change in Cash -212676000 235458000 97206000 -20234000 -313332000 -313332000
Effect of Exchange Rate Changes -8695000 -1244000 7510000 -7087000 -19831000 -19831000
Cash and Cash Equivalents, Beginning of Period 673166000 451795000 686009000 790725000 763404000 763404000
Cash Flow Supplemental Section
Change in Cash as Reported, Supplemental -221371000 234214000 104716000 -27321000 -333163000 -333163000
Income Tax Paid, Supplemental -77408000 -99062000 -14687000 -129483000 -92110000 -92110000
Interest Paid, Supplemental
Fiscal year ends in Dec 31 | USD

Calculation

4 2018 2019 2020 2021 2022
Net Income 268256000 330489000 108013000 354108000 311440000
Total shareholder's equity 1690313000 1849447000 1832771000 1989252000 1935789000
ROE 15.87% 17.87% 5.89% 17.80% 16.09%
5-year Average ROE 14.70%
2018 2019 2020 2021 2022
Dividend Paid 62664000 65127000 17195000 68623000 75082000
Net Income 268256000 330489000 108013000 354108000 311440000
Dividend Payout Ratio 23.36% 19.71% 15.92% 19.38% 24.11%
5-year Average Payout Ratio 20.49%
5 Retention Rate 79.51%
Expected Return on New Investment 14.70%
5-year Dividend Growth Rate 11.69%
6
year
1
2
3
4
5