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