Question

Can I get help preparing a horizontal analysis for this financial statement.
COCA-COLA BOTTLING CO. CONSOLIDATED CONSOLIDATED BALANCE SHEETS December 31, 2017 January 1, 2017 $ $ (in thousands, except share data) ASSETS Current Assets: Cash and cash equivalents Accounts receivable, trade Allowance for doubtful accounts Accounts receivable from The Coca-Cola Company Accounts receivable, other Inventories Prepaid expenses and other current assets Total current assets Property, plant and equipment, net Leased property under capital leases, net Other assets Franchise rights Goodwill Distribution agreements, net Customer lists and other identifiable intangible assets, net Total assets 16,902 396,022 (7,606) 65,996 38,960 183,618 100,646 794,538 1,031,388 29,837 116,209 21,850 271,661 (4,448) 67,591 29,770 143,553 63.834 593,811 812,989 33,552 86,091 533,040 144,586 234,988 10.427 2,449,484 169,316 913,352 18,320 3,072,960 $ $ LIABILITIES AND EQUITY Current liabilities: Current portion of obligations under capital leases Accounts payable, trade Accounts payable to The Coca-Cola Company Other accrued liabilities Accrued compensation Accrued interest payable Total current liabilities Deferred income taxes Pension and postretirement benefit obligations Other liabilities Obligations under capital leases Long-term debt Total liabilities Commitments and Contingencies Equity: Convertible Preferred Stock, $100.00 par value: authorized - 50,000 shares, issued - none Nonconvertible Preferred Stock, $100.00 par value: authorized - 50,000 shares, issued - none Preferred Stock, $.01 par value: authorized - 20,000,000 shares; issued - none Common Stock, $1.00 par value: authorized - 30,000,000 shares; issued - 10,203,821 shares Class B Common Stock S100 nar valuer authorized - 10.000.000 shares: issued-2.820.836 and 8,221 197,049 171,042 185,530 72,484 5,126 639,452 112,364 118,392 620,579 35,248 1,088,018 2,614,053 7,527 116,821 135,155 133,885 60,880 3,639 457,907 174,854 126,679 378,572 41,194 907,254 2,086,460 10,204 10,204

Answer 1

COCA-COLA BOTTLING CO. CONSOLIDATED
Horizontal Analysis of Balance Sheet
Years ending December 31, 2017 and 2016
(in thousands, except share data)
	December 31, 2017	January 1, 2017	Amount of Increase/(decrease)	Percentage
ASSETS
Current Assets:
Cash and cash equivalents	$          16,902.00	$      21,850.00	$       (4,948.00)	-22.65%
Accounts receivable, trade	$        396,022.00	$    271,661.00	$     124,361.00	45.78%
Allowance for doubtful accounts	$          (7,606.00)	$      (4,448.00)	$       (3,158.00)	71.00%
Accounts receivable from The Coca-Cola Company	$          65,996.00	$      67,591.00	$       (1,595.00)	-2.36%
Accounts receivable, other	$          38,960.00	$      29,770.00	$         9,190.00	30.87%
Inventories	$        183,618.00	$    143,553.00	$       40,065.00	27.91%
Prepaid expenses and other current assets	$        100,646.00	$      63,834.00	$       36,812.00	57.67%
Total current assets	$        794,538.00	$    593,811.00	$     200,727.00	33.80%
Property, plant and equipment, net	$     1,031,388.00	$    812,989.00	$     218,399.00	26.86%
Leased property under capital leases, net	$          29,837.00	$      33,552.00	$       (3,715.00)	-11.07%
Other assets	$        116,209.00	$      86,091.00	$       30,118.00	34.98%
Franchise rights	$                       -	$    533,040.00	$   (533,040.00)	-100.00%
Goodwill	$        169,316.00	$    144,586.00	$       24,730.00	17.10%
Distribution agreements, net	$        913,352.00	$    234,988.00	$     678,364.00	288.68%
Customer lists and other identifiable intangible assets, net	$          18,320.00	$      10,427.00	$         7,893.00	75.70%
Total assets	$     3,072,960.00	$ 2,449,484.00	$     623,476.00	25.45%
LIABILITIES AND EQUITY
Current liabilities :
Current portion of obligations under capital lease	$            8,221.00	$        7,527.00	$            694.00	9.22%
Accounts payable, trade	$        197,049.00	$    116,821.00	$       80,228.00	68.68%
Accounts payable to The Coca-Cola Company	$        171,042.00	$    135,155.00	$       35,887.00	26.55%
Other accrued liabilities	$        185,530.00	$    133,885.00	$       51,645.00	38.57%
Accrued compensation	$          72,484.00	$      60,880.00	$       11,604.00	19.06%
Accrued interest payable	$            5,126.00	$        3,639.00	$         1,487.00	40.86%
Total current liabilities	$        639,452.00	$    457,907.00	$     181,545.00	39.65%
Deferred income taxes	$        112,364.00	$    174,854.00	$     (62,490.00)	-35.74%
Pension and postretirement benefit obligations	$        118,392.00	$    126,679.00	$       (8,287.00)	-6.54%
Other liabilities	$        620,579.00	$    378,572.00	$     242,007.00	63.93%
Obligations under capital leases	$          35,248.00	$      41,194.00	$       (5,946.00)	-14.43%
Long-term debt	$     1,088,018.00	$    907,254.00	$     180,764.00	19.92%
Total liabilities	$     2,614,053.00	$ 2,086,460.00	$     527,593.00	25.29%
Commitments and Contingencies
Equity :
Convertible Preferred Stock, $100.00 par value: authorized - 50,000 shares; issued - none
Nonconvertible Preferred Stock, $100.00 par value: authorized - 50,000 shares; issued - none
Preferred Stock, $.01 par value: authorized - 20,000,000 shares; issued - none - 20,000,000 shares; issued - none
Common Stock, $1.00 par value: authorized - 30,000,000 shares; issued - 10,203,821	$          10,204.00	$      10,204.00	$                    -	0.00%
Class B Common Stock, $1.00 par value: authorized - 10,000,000 shares; issued-2,820,836	$            2,819.00	$        2,798.00	$              21.00	0.75%
Class C Common Stock, $1.00 par value: authorized - 20,000,000 shares; issued - none			$                    -
Capital in excess of par value	$        120,417.00	$    116,769.00	$         3,648.00	3.12%
Retained earnings	$        388,718.00	$    301,511.00	$       87,207.00	28.92%
Accumulated other comprehensive loss	$        (94,202.00)	$    (92,897.00)	$       (1,305.00)	1.40%
Treasury stock, at cost: Common Stock - 3,062,374 shares	$        (60,845.00)	$    (60,845.00)	$                    -	0.00%
Treasury stock, at cost: Class B Common Stock - 628,114 shares	$             (409.00)	$         (409.00)	$                    -	0.00%
Total equity of Coca-Cola Bottling Co. consolidated	$        366,702.00	$    277,131.00	$       89,571.00	32.32%
Noncontrolling interest	$          92,205.00	$      85,893.00	$         6,312.00	7.35%
Total equity	$        458,907.00	$    363,024.00	$       95,883.00	26.41%
Total liabilities and equity	$     3,072,960.00	$ 2,449,484.00	$     623,476.00	25.45%