Calculate the blanks (Please show the Excel Formula) Report Date Y3 Y2 Y1 Horizontal Analysis (2016-2015) Horizontal
Fantastic news! We've Found the answer you've been seeking!
Question:
Calculate the blanks (Please show the Excel Formula)
Report Date | Y3 | Y2 | Y1 | Horizontal Analysis (2016-2015) | Horizontal Analysis (2016-2015) | Vertical Analysis Y3 | Vertical Analysis Y2 | |||
Scale | Thousands | Thousands | Thousands | |||||||
Cash & cash equivalents | 889,793 | 205,744 | 40,732 | 332.5% | 0 | 0 | 0 | |||
Accounts receivable, gross | 1,271,437 | 1,163,695 | 1,184,335 | 9.3% | 0 | 0 | 0 | |||
Less: allowance for doubtful accounts | 40,450 | 49,420 | 53,770 | -18.2% | 0 | 0 | 0 | |||
Accounts receivable, less allowance | 1,230,987 | 1,114,275 | 1,130,565 | 10.5% | 0 | 0 | 0 | |||
Finished goods | 898,627 | 840,603 | 841,784 | 6.9% | 0 | 0 | 0 | |||
Work in process & raw materials | 169,699 | 177,927 | 191,743 | -4.6% | 0 | 0 | 0 | |||
Inventories | 1,068,326 | 1,018,530 | 1,033,527 | 4.9% | 0 | 0 | 0 | |||
Deferred income taxes | 57,162 | 87,883 | 109,087 | -35.0% | 0 | 0 | 0 | |||
Other current assets | 381,030 | 232,442 | 252,869 | 63.9% | 0 | 0 | 0 | |||
Total current assets | 3,627,298 | 2,658,874 | 2,566,780 | 36.4% | 0 | 0 | 0 | |||
Goodwill | 1,126,892 | 1,143,333 | 1,158,346 | -1.4% | 0 | 0 | 0 | |||
Intangible assets | 255,010 | 255,371 | 289,127 | -0.1% | 0 | 0 | 0 | |||
Deferred pension assets | 225,529 | 244,882 | 250,144 | -7.9% | 0 | 0 | 0 | |||
Other assets | 421,904 | 447,533 | 420,625 | -5.7% | 0 | 0 | 0 | |||
Land | 115,555 | 119,530 | 125,691 | -3.3% | 0 | 0 | 0 | |||
Buildings | 714,815 | 696,202 | 698,202 | 2.7% | 0 | 0 | 0 | |||
Machinery & equipment | 2,153,437 | 2,026,617 | 1,952,037 | 6.3% | 0 | 0 | 0 | |||
Construction in progress | 117,126 | 81,082 | 59,330 | 44.5% | 0 | 0 | 0 | |||
Property, plant & equipment, gross | 3,100,933 | 2,923,431 | 2,835,260 | 6.1% | 0 | 0 | 0 | |||
Less: allowances for depreciation | 2,005,045 | 1,881,569 | 1,814,230 | 6.6% | 0 | 0 | 0 | |||
Property, plant & equipment, net | 1,095,888 | 1,041,862 | 1,021,030 | 5.2% | 0 | 0 | 0 | |||
Total assets | 6,752,521 | 5,791,855 | 5,706,052 | 16.6% | 0 | 0 | 0 | |||
Short-term borrowings | 40,739 | 39,462 | 679,436 | 3.2% | 0 | 0 | 0 | |||
Accounts payable | 1,034,608 | 1,157,561 | 1,042,182 | -10.6% | 0 | 0 | 0 | |||
Compensation & taxes withheld | 398,045 | 338,256 | 360,458 | 17.7% | 0 | 0 | 0 | |||
Accrued taxes | 76,765 | 81,146 | 86,744 | -5.4% | 0 | 0 | 0 | |||
Current portion of long-term debt | 700,475 | 3,154 | 3,265 | 22109.1% | 0 | 0 | 0 | |||
Other accruals | 578,547 | 522,280 | 508,581 | 10.8% | 0 | 0 | 0 | |||
Total current liabilities | 2,829,179 | 2,141,859 | 2,680,666 | 32.1% | 0 | 0 | 0 | |||
Senior notes | 1,086,473 | 1,795,696 | 998,055 | -39.5% | 0 | 0 | 0 | |||
Debentures | 122,436 | 122,872 | 122,869 | -0.4% | 0 | 0 | 0 | |||
Promissory notes | 2,417 | 1,628 | 1,791 | 48.5% | 0 | 0 | 0 | |||
Long-term debt | 1,211,326 | 1,920,196 | 1,122,715 | -36.9% | 0 | 0 | 0 | |||
Postretirement benefits other than pensions | 250,397 | 248,523 | 277,892 | 0.8% | 0 | 0 | 0 | |||
Other long-term liabilities | 583,178 | 613,367 | 628,309 | -4.9% | 0 | 0 | 0 | |||
Total Liabilities | 4,874,080 | 4,923,945 | 4,709,582 | -1.0% | 0 | 0 | 0 | |||
Common stock | 116,563 | 115,761 | 114,525 | 0.7% | 0 | 0 | 0 | |||
Convertible preferred stock | - | - | - | |||||||
Unearned ESOP compensation | - | - | - | |||||||
Other capital | 2,488,564 | 2,330,426 | 2,079,639 | 6.8% | 0 | 0 | 0 | |||
Retained earnings | 4,049,497 | 3,228,876 | 2,424,674 | 25.4% | 0 | 0 | 0 | |||
Treasury stock, at cost | (4,235,832) | (4,220,058) | (3,150,410) | 0.4% | 0 | 0 | 0 | |||
Foreign currency translation adjustment | - | (482,629) | (354,384) | 0 | ||||||
Net actuarial gains (losses) related to pension & other postretirement benefit plans | - | (104,346) | (118,167) | 0 | ||||||
Unrealized net gains on marketable equity securities | - | (120) | 593 | 0 | ||||||
Cumulative other comprehensive income (loss) | (540,351) | (587,095) | (471,958) | -8.0% | 0 | 0 | 0 | |||
Total shareholders' equity | 1,878,441 | 867,910 | 996,470 | 116.4% | 0 | 0 | 0 | |||
0 | 0 | 0 | ||||||||
4.2 | 4.2 | 4.5 |
Posted Date: