Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Columbia Sportswear Company (COLM) COLM:Turnover RatiosTime Period:What's Unusual for COLM: salesInv TO: COGSARTO: InventoryAP TO: A/R A/POperating Cycle = Cash Cycle= *** Note from student:
Columbia Sportswear Company (COLM)
COLM:Turnover RatiosTime Period:What's Unusual for COLM:
salesInv TO:
COGSARTO:
InventoryAP TO:
A/R
A/POperating Cycle =
Cash Cycle=
***Note from student: Please show me how you were able to answer this in excel with the cell formulas please!**
Breakdown TTM 12/31/2019 Total Revenue 3,042,478 3,042,478 Cost of Revenue 1,526,808 1,526,808 Gross Profit 1,515,670 1,515,670 Operating Expenses Selling General and Administr... 1,136,186 1,136,186 Total Operating Expenses 1,120,699 1,120,699 Operating Income or Loss 394,971 394,971 Interest Expense Total Other Income/Expenses Net 2,156 2,156 Income Before Tax 405,429 405,429 Income Tax Expense 74,940 74,940 Income from Continuing Operati... 330,489 330,489 Breakdown 12/31/2019 12/31/2018 Assets > Current Assets 1,875,746 1,765,306 Non-current assets Property, plant and equi... Gross property, plant an... 1,264,244 780,950 Accumulated Depreciati... -523,092 -489,354 Net property, plant and... 741,152 291,596 Goodwill 68,594 68,594 Intangible Assets 123,595 126,575 Other long-term assets 43,655 38,495 Total non-current assets 1,055,845 603,415 Total Assets 2,931,591 2,368,721 Liabilities and stockholders' ... Breakdown TTM 12/31/2019 Total Revenue 3,042,478 3,042,478 Cost of Revenue 1,526,808 1,526,808 Gross Profit 1,515,670 1,515,670 Operating Expenses Selling General and Administr... 1,136,186 1,136,186 Total Operating Expenses 1,120,699 1,120,699 Operating Income or Loss 394,971 394,971 Interest Expense Total Other Income/Expenses Net 2,156 2,156 Income Before Tax 405,429 405,429 Income Tax Expense 74,940 74,940 Income from Continuing Operati... 330,489 330,489 Breakdown 12/31/2019 12/31/2018 Assets > Current Assets 1,875,746 1,765,306 Non-current assets Property, plant and equi... Gross property, plant an... 1,264,244 780,950 Accumulated Depreciati... -523,092 -489,354 Net property, plant and... 741,152 291,596 Goodwill 68,594 68,594 Intangible Assets 123,595 126,575 Other long-term assets 43,655 38,495 Total non-current assets 1,055,845 603,415 Total Assets 2,931,591 2,368,721 Liabilities and stockholdersStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started