Question

Common-Size and Rate of Change Analyses: Hershey

The Hershey Company is one of the world's leading producers of chocolates, candies, and confections. It sells chocolates and candies, mints and gums, baking ingredients, toppings, and beverages. Hershey's consolidated balance sheets for 2012 and 2013 follow.

Hershey: Consolidated Balance Sheets
	Dollar Amounts in Millions
	2012	2013
Assets
Current Assets
Cash and Equivalents	$ 728.3	$ 1,118.5
Receivables	461.4	477.9
Inventories	633.3	659.5
Deferred Income Taxes	122.2	52.5
Prepaid Expenses and Other Assets	168.3	178.9
Total Current Assets	$ 2,113.5	$ 2,487.3
Property, Plant and Equipment, Net	1,674.1	1,805.3
Goodwill	588.0	576.6
Other Intangible Assets, net	214.7	195.2
Other Assets	164.5	293.0
Total Assets	$ 4,754.8	$ 5,357.5
Liabilities and Shareholders' Equity
Current Liabilities
Accounts Payable	$ 442.0	$ 461.5
Accrued Liabilities	650.9	699.7
Accrued Income Taxes	2.3	79.9
Short-Term Debt	118.2	166.0
Current Portion of Long-Term Debt	257.7	0.9
Total Current Liabilities	$ 1,471.1	$ 1,408.0
Long-Term Debt	1,531.0	1,795.1
Other Long-Term Liabilities	668.7	434.1
Deferred Income Taxes	35.7	104.2
Total Liabilities	$ 3,706.5	$ 3,741.4
Shareholders' Equity
Common Stock	359.9	359.9
Additional Paid-In Capital	593.0	664.9
Retained Earnings	5,027.6	5,454.3
Treasury Stock (at cost)	(4,558.7)	(4,707.7)
Accumulated Other Comprehensive Loss	(385.1)	(166.6)
Noncontrolling interests	11.6	11.2
Total Shareholders' Equity	$ 1,048.4	$ 1,616.1
Total Liabilities and Shareholders' Equity	$ 4,754.8	$ 5,357.5

Required:

Compute the common-size balance sheet for 2013 and the rate of change balance sheet for 2013. Round your answers to one decimal place. Indicate decreasing percentages with a minus sign.

Hershey: Consolidated Balance Sheets
	Common- Sized 2013	Rates of Change
Assets
Current Assets:
Cash and Equivalents	20.9%	53.6%
Receivables	8.9%	3.6%
Inventories	12.3%	4.1%
Deferred Income Taxes	1.0%	%
Prepaid Expenses and Other Assets	3.3%	6.3%
Total Current Assets	46.4%	17.7%
Property, Plant and Equipment, Net	33.7%	7.8%
Goodwill	10.8%	-1.9%
Other Intangible Assets, net	3.6%	-9.1%
Other Assets	5.5%	78.1%
Total Assets	100%	12.7%
Liabilities and Shareholders' Equity
Current Liabilities:
Accounts Payable	%	%
Accrued Liabilities	%	%
Accrued Income Taxes	%	%
Short-Term Debt	3.10%	%
Current Portion of Long-Term Debt	%	%
Total Current Liabilities	%	%
Long-Term Debt	%	%
Other Long-Term Liabilities	8.1%	%
Deferred Income Taxes	%	%
Total Liabilities	%	%
Shareholders' Equity:
Common Stock	%	0%
Additional Paid-In Capital	%	%
Retained Earnings	%	%
Treasury Stock (at cost)	%	%
Accumulated Other Comprehensive Loss	%	%
Noncontrolling interests	%	%
Total Shareholders' Equity	%	%
Total Liabilities and Shareholders' Equity	100%	%

Please fill out those empty percentages.. I really need help.

Answer 1

Hershey Cosolidated Balance Sheets
	2012	2013	Incease/(Decrease)	Rate of Change	Common Sized -2013
Current Liabilities	(a)	(b)	c=(a-b)	(c/a)	(Relevant Head 0f 2013/ Total Liabilities & Equities
Accounts Payable	$442.00	$461.50	$19.50	4.4%	8.6%
Accrued Liabilities	650.9	699.7	$48.80	7.5%	13.1%
Accrued Income Taxes	2.3	79.9	$77.60	3373.9%	1.5%
Short-Term Debt	118.2	166	$47.80	40.4%	3.1%
Current Portion of Long-Term Debt	257.7	0.9	($256.80)	-99.7%	0.0%
Total Current Liabilities	$1,471.10	$1,408.00	($63.10)	-4.3%	26.3%
Long-Term Debt	1,531.00	1,795.10	$264.10	17.3%	33.5%
Other Long-Term Liabilities	668.7	434.1	($234.60)	-35.1%	8.1%
Deferred Income Taxes	35.7	104.2	$68.50	191.9%	1.9%
Total Liabilities	$3,706.50	$3,741.40	$34.90	0.9%	69.8%
Shareholders' Equity
Common Stock	359.9	359.9	$0.00	0.0%	6.7%
Additional Paid-In Capital	593	664.9	$71.90	12.1%	12.4%
Retained Earnings	5,027.60	5,454.30	$426.70	8.5%	101.8%
Treasury Stock (at cost)	-4,558.70	-4,707.70	($149.00)	3.3%	-87.9%
Accumulated Other Comprehensive Loss	-385.1	-166.6	$218.50	-56.7%	-3.1%
Noncontrolling interests	11.6	11.2	($0.40)	-3.4%	0.2%
Total Shareholders' Equity	$1,048.40	$1,616.10	$567.70	54.1%	30.2%
Total Liabilities and Shareholders' Equity	$4,754.80	$5,357.50	$602.70	12.7%	100.0%