Question

What is the Days to Sell Average Inventory for Hasbro, must provide excel formula.

Hasbro, Inc. Consolidated Balance Sheets - USD (S) $ in Thousands Dec. 31, 2018 Dec. 31, 2017 Current assets Cash and cash equivalents $1,182,371 S1,581,234 Accounts receivable, less allowance for doubtful accounts of $9,100 in 2018 and $31,400 in 2017 1,405,399 1,188,052 443,383 Inventories 433,293 214,000 3,633,926 Prepaid expenses and other current assets 268,698 3,082,504 Total current assets Property, plant and equipment, net 256,473 259,710 Other assets Goodwill 485,881 573,063 Other intangibles, net Other 693,842 217,382 744,288 605,902 Total other assets 1,924,011 1,396,347 Total assets 5,289,983 5,262,988 Current liabilities Short-term borrowings 9,740 154,957 Accounts payable 333,521 348,476 748,264 Accrued liabilities Total current liabilities Long-term debt Other liabilities Total liabilities Shareholders' equity 931,063 1,274,324 1,251,697 1,695,092 1,693,609 539,086 514,720 3,508,502 3,460,026 Preference stock of $2.50 par value. Authorized 5,000,000 shares; none issued Common stock of $0.50 par value. Authorized 600,000,000 shares; issued 209,694,630 shares in 2018 and 2017 104,847 104,847 Additional paid-in capital 1,275,059 1,050,605 Retained earnings 4,260,222 4,184,374 Accumulated other comprehensive loss Treasury stock, at cost, 83,565,598 shares in 2018 and 85,244,923 shares in 2017 (294,514) (239,425) (3,515,280) (3,346,292) Total shareholders' equity 1,754,486 1,829,957 $ 5,262,988 $ 5,289,983 Total liabilities, redeemable noncontrolling interests and shareholders' equity

Answer 1

Days to sell average inventory = 365*Average Inventory/Cost of Sales

Excel Formula = 365*Average(Cell containing inventory value for 2018, Cell containing inventory value for 2017)/ Cell containing Cost of sales for Dec 31,2018

=365*438338/1850678

=86.45 days