Question

Profitability -

Must provide Percentage Changes in Net Sales and Net Income or Loss, percentage change in net sales and percentage change in net income. Must provide excel formulas.

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

Answer 1

Percentage change in Net sales = (net sales of current year/net sales of previous year) - 1

Percentage change in Net Income = (net income of current year/net income of previous year) - 1

	Dec.31, 2018	Dec.31, 2017
Net Sales or revenues	$4,579,646	$5,209,782
% change in net sales	-12.10%
Net Earnings or Income	$220,434	$396,607
% change in net Income	-44.42%

Calculation and excel formula

Dec.31, 2017 5209782 2 3 4 5 6 Dec 31, 2018 Net Sales or revenues 4579646 % change in net sales =(B3/C3)-1 Net Earnings or Income 220434 % change in net Income =(B5/C5)-1 396607