Days Sales in InventoryAccounts Receivable TurnoverCalcute each ratio from the data for 2019 and 2020 COLUMBIA SPORTSWEAR COMPANYCONSOLIDATED STATEMENTS OF OPERATIONSYear Ended Decenber 31,n housanda, encapt per shar amaunta209 2013$ 2,501,554 $ 3,042,478 $ 2 802 3262000Net salesCost of sales1,277,6651415.9781,526,8081515 670 1 386 348Gross profitSeling, general and administrative expensesNet licensing incomeIncome from operations.1,223.8891,098.9481,136, 1861,051,15212.10815,48715786137.049394,971350.982Interest income, net.4358,3029.876Other non operating income (expense). net2.0392,156(141)....Income before income tax139,523405,429360717Income tax expense(31,510)(74,940)(85.769Net income108.013330.489274.948Net income attrbutable to non-controlling interestNet income attributable to Columbia Spartswear Company6.692268 256$108.013$30,489Earrings per share attributable to Columbia Sportswear CompanyBasic1.63 $487 S3.85Diluted1.62 $483 $3.81Weighted average shares outstandingBasic66,37667,83769,614Diuted66.77268.49370,401COLUMBIA SPORTSWEAR COMPANYCONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOMEYear Ended Decenber 31,in hosanda200020192018Net income330,489 $ 274.948Other comprehensive income (loss):Unrealized holding gains (losses) on available for sale securies, netUnrealized holding gains (losses) on derivative transacions (net oftax effects of $6,271, $830, and $(7,782), respedively)Foreign aurrency translation adjustments (net of tax effects of S(388).$2188, and $1,557, respectively)Other comprehensive income (loss)Comprehensive income4.56(56)(18.851)(2,383)24.26224.0782,064(18.0795.231(263)6.127113.244330,226281.075Comprehensive income atributable to non-controling interest7.480$113.244$ 330,226 S 273.595Comprehensive income atributable to Columbia Sportswear Company December 31,(in thousands)20192020ASSETSCurrent Assets:Cash and cash equivalents.790,725 $686,009Short-term investments1,2241,668Accounts receivable, net of allowance of $21,810 and $8,925, respectively .Inventories, net452,945488,233556,530605,968Prepaid expenses and other current assets54,19793,868Total current assets1,855,6211,875,746Property, plant and equipment, net .Operating lease right-of-use assetsIntangible assets, net309,792346,651339,244394,501103,558123,595Goodwill68,59468,594Deferred income taxes.96,12678,849Other non-current assets63,63643,655Total assets$ 2,836,571 $ 2,931,591LIABILITIES AND EQUITYCurrent Liabilities:Accounts payable206,697 $255,372Accrued liabilities257,278295,723Operating lease liabilities65,46664,019Income taxes payable23,18115,801Total current liabilities552,622630,915Non-current operating lease liabilitiesIncome taxes payable353,181371,50749,92248,427Deferred income taxes5,2056,361Other long-term liabilities42,87024,934Total liabities1,003,8001,082,144Commitments and contingencies (Note 12)Shareholders' Equity:Preferred stock; 10,000 shares authorized; none issued and outstandingCommon stock (no par value); 250,000 shares authorized; 66,252 and 67,561 issuedand outstanding, respectively20,1654,937Retained earnings1,811,8001,848,935Accumulated other comprehensive income (loss)806(4,425)Total shareholders' equityTotal liabilities and shareholders' equity1,832,7711,849,447$ 2,836,571 $ 2,931,591

Day sales in inventory= Average inventory/COGS*365 days Average inventory = (Beginning inventory+…

Answered: Days Sales in Inventory Accounts…

Business

Accounting

Days Sales in Inventory Accounts Receivable Turnover Calcute each ratio from the data for 2019 and 2020

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Inventory Analysis The following data were extracted from the income statement of Keever Inc.: Current Year Previous Year Sales $1,168,000 $1,222,000 Beginning inventories 84,800 75,984 Cost of goods sold 584,000 678,900 Ending inventories 76,800 84,800 a. Determine for each year (1) the inventory turnover and (2) the number of days' sales in inventory. Round interim calculations to the nearest dollar and the final answers to one decimal place. Assume 365 days a year. Current Year Previous Year 1. Inventory turnover fill in the blank 1 fill in the blank 2 2. Number of days' sales in inventory fill in the blank 3 days fill in the blank 4 days
Inventory Analysis A company reports the following: Cost of goods sold $478,150 Average inventory 95,630 Determine (a) the inventory turnover and (b) the number of days' sales in inventory. Round interim calculations to the nearest dollar and final answers to one decimal place. Assume 365 days a year. a. Inventory turnover b. Number of days' sales in inventory days
Question Content Area Based on the following data for the current year, what is the number of days' sales in receivables (rounded to one decimal place)? Assume 365 days a year. Sales on account during year $461,647 Cost of merchandise sold during year 196,997 Accounts receivable, beginning of year 41,839 Accounts receivable, end of year 52,205 Merchandise inventory, beginning of year 85,575 Merchandise inventory, end of year 109,714 a.155.7 days b.37.2 days c.77.2 days d.86.7 days
Suppose the 2022 financial statements of 3M Company report net sales of $23.1 billion. Accounts receivable (net) are $3.2 billion at the beginning of the year and $3.25 billion at the end of the year. Compute 3M’s accounts receivable turnover. - Accounts Recievable turnover ratio=? (times) Compute 3M’s average collection period for accounts receivable in days - Average collection period =? (days)
The financial statements of the Sunland Company report net sales of $384000 and accounts receivable of $50400 and $33600 at the beginning of the year and the end of the year, respectively. What is the average collection period for accounts receivable in days?
Inventory Analysis A company reports the following: Cost of goods sold $543,120 Average inventory 67,890 Determine (a) the inventory turnover and (b) the number of days' sales in inventory. Round interim calculations to the nearest dollar and final answers to one decimal place. Assume 365 days a year.
Inventory Turnover Calculate the company's inventory turnover for 2020 and compare the result to the industry average.
Cost of goods sold Average inventory 2020 2021 2022 $923,550 $980,640 126,290 Inventory Turnover 7.3 2021 6.3 5.3 156,510 2022 (a) Do a trend analysis of the inventory turnover for each year. Also calculate the days to sell invento (Round inventory turnover to 2 decimal places, e.g. 18.42 and number of days to 1 decimal place, e.g. 13.6., $1,149,910 $1,329,510 208,410 Number of Days 2023 321,820 days days days 2024 $1,408,530 451,860
A company reports the following: Cost of merchandise sold $3,120,750Average merchandise inventory 182,500 Determine (a) the inventory turnover and (b) the number of days' sales in inventory. Assume a 365-day year. Round your answers to one decimal place.
You are provided with the following data: inventory - to -sale conversion period = 100days Sale - to - cash conversionperiod = 46 days Purchase - to -payment conversion period30 days What is the operatingcycle?
Sales Cost of goods sold Accounts receivable Numerator: 2021 $ 446,762 225,881 21,623 Numerator: Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable. Numerator: 1 1 1 1 1 1 1 2021: 2020: 2019: 2018: 2017: Is the trend percent for Net Sales favorable or unfavorable? 2020 $ 290,105 146,803 16,913 Trend Percent for Net Sales: 2019 $ 232,084 119,092 15,828 2021: 2020: 2019: 2018: 2017: Is the trend percent for Cost of Goods Sold favorable or unfavorable? Trend Percent for Cost of Goods Sold: 1 Denominator: 7 1 1 1 1 1 I 1 Denominator: Trend Percent for Accounts Receivable: Denominator: 1 1 1 1 2021: 2020: 2019: 2018: 2017: Is the trend percent for Accounts Receivable favorable or unfavorable? 2018 $ 167,570 84,885 9,820 = = = = = = = = = = 2017 $ 128,900 64,450 8,804 = Trend percent Trend percent Trend percent % % % % % % % % % % % % %…
Using the weighted mean method, determine the valuation of ending inventory on December. Assume 35 FitBits in inventory at the end of the year. (Round to the nearest whole dollar.) b. What was the Cost of Goods Sold (COGS)?