How do you prepare a horizontal analysis for the balance sheet fora 2-year period, and a vertical analysis for the income statement for a 2-year period using the 2017 Coca-Cola Company (KO) annual report? And what are the formulas used for each?

What the formulas for each of the following ratios and what are they using the 2017 Coca-Cola Company (KO) annual report?

Common Stockholders Equity Ratio

Profit Margin Ratio

Cash Ratio

Debt to Equity Ratio

Debt Ratio

COCA-COLA BOTTLING CO. CONSOLIDATED CONSOLIDATED STATEMENTS OF OPERATIONS Fiscal Year (in thousands, except per share data) 2017 2016 2015 Net sales $ 4,323,668 $ 3,156,428 $ 2,306,458 Cost of sales 2,782,721 1,940, 706 1,405,426 Gross profit 1,540,947 1,215,722 901,032 Selling, delivery and administrative expenses 1,444,768 1,087,863 802,888 Income from operations 96, 179 127,859 98,144 Interest expense, net 41,869 36,325 28,915 Other income (expense), net (4,197) 1,870 (3,576) Gain (loss) on exchange transactions 12,893 (692) 8,807 Gain on sale of business 22,651 Bargain purchase gain, net of tax of $1,265 2,011 Income before taxes 63,006 92,712 99,122 Income tax expense (benefit) (39,841 ) 36,049 34,078 Net income 102,847 56,663 65,044 Less: Net income attributable to noncontrolling interest 6,312 6,517 6,042 Net income attributable to Coca-cola Bottling Co. Consolidated S 96,535 50,146 S 59,002 Basic net income per share based on net income attributable to Coca- Cola Bottling Co. Consolidated: Common Stock $ 10.35 $ 5.39 $ 6.35 Weighted average number of Common Stock shares outstanding 7,141 7,141 7,141 Class B Common Stock $ 10.35 $ 5.39 $ 6.35Bargain purchase gain, net of tax of $1,265 2,011 Income before taxes 63,006 92, 712 99,122 Income tax expense (benefit) (39,841 ) 36,049 34,078 Net income 102,847 56,663 65,044 Less: Net income attributable to noncontrolling interest 6,312 6,517 6,042 Net income attributable to Coca-cola Bottling Co. Consolidated 96,535 $ 50,146 S 59,002 Basic net income per share based on net income attributable to Coca- Cola Bottling Co. Consolidated: Common Stock $ 10.35 $ 5.39 $ 6.35 Weighted average number of Common Stock shares outstanding 7,141 7,141 7,141 Class B Common Stock $ 10.35 $ 5.39 $ 6.35 Weighted average number of Class B Common Stock shares outstanding 2, 188 2,168 2,147 Diluted net income per share based on net income attributable to Coca- Cola Bottling Co. Consolidated: Common Stock $ 10.30 $ 5.36 $ 6.33 Weighted average number of Common Stock shares outstanding - assuming dilution 9,369 9,349 9,328 Class B Common Stock $ 10.29 $ 5.35 $ 6.31 Weighted average number of Class B Common Stock shares outstanding - assuming dilution 2,228 2,208 2, 187COCA-COLA BOTTLING CO. CONSOLIDATED CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME Fiscal Year (in thousands) 2017 2016 2015 Net income $ 102,847 $ 56,663 65,044 Other comprehensive income (loss), net of tax: Defined benefit plans reclassification including pension costs: Actuarial gain (loss) (6,225) (4,150) 6,624 Prior service costs 18 17 21 Postretirement benefits reclassification including benefit costs: Actuarial gain (loss) 592 (4,286) 2,934 Prior service costs (1,935) (2,065) (2,068) Adjustment due to the divestiture of the Deep South and Somerset Exchange Business and the Florence and Laurel Distribution Business 6,220 Foreign currency translation adjustment 25 6 (4) Other comprehensive income (loss), net of tax (1,305) (10,490) 7,507 Comprehensive income 101,542 46,173 72,551 Less: Comprehensive income attributable to noncontrolling interest 6,312 6,517 6,042 Comprehensive income attributable to Coca-cola Bottling Co. Consolidated S 95,230 $ 39,656 $ 66,509COCA-COLA BOTTLING CO. CONSOLIDATED CONSOLIDATED BALANCE SHEETS (in thousands, except share data) December 31, 2017 January 1, 2017 ASSETS Current Assets: Cash and cash equivalents $ 16,902 $ 21,850 Accounts receivable, trade 396,022 271,661 Allowance for doubtful accounts (7,606) (4,448) Accounts receivable from The Coca-Cola Company 65,996 67,591 Accounts receivable, other 38,960 29,770 Inventories 183,618 143,553 Prepaid expenses and other current assets 100,646 63,834 Total current assets 794,538 593,811 Property, plant and equipment, net 1,031,388 812,989 Leased property under capital leases, net 29,837 33,552 Other assets 116,209 86,091 Franchise rights 533,040 Goodwill 169,316 144,586 Distribution agreements, net 913,352 234,988 Customer lists and other identifiable intangible assets, net 18,320 10,427 Total assets S 3,072,960 S 2,449,484 LIABILITIES AND EQUITY Current liabilities: Current portion of obligations under capital leases 8,221 $ 7,527 Accounts payable, trade 197,049 116,821 Accounts payable to The Coca-cola Company 171,042 135,155LIABILITIES AND EQUITY Current liabilities: Current portion of obligations under capital leases 8,221 $ 7,527 Accounts payable, trade 197,049 116,821 Accounts payable to The Coca-cola Company 171,042 135,155 Other accrued liabilities 185,530 133,885 Accrued compensation 72,484 60,880 Accrued interest payable 5,126 3,639 Total current liabilities 639,452 457,907 Deferred income taxes 112,364 174,854 Pension and postretirement benefit obligations 1 18,392 126,679 Other liabilities 620,579 378,572 Obligations under capital leases 35,248 41,194 Long-term debt 1,088,018 907,254 Total liabilities 2,614,053 2,086,460 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 10,204 10,204 Class B Common Stock, $1.00 par value: authorized - 10,000,000 shares; issued-2,820,836 and 2,799,816 shares, respectively 2,819 2,798 Class C Common Stock, $1.00 par value: authorized - 20,000,000 shares; issued - none Capital in excess of par value 120,417 116,769 Retained earnings 388,718 301,511 Accumulated other comprehensive loss (94,202) (92,897) Treasury stock, at cost: Common Stock - 3,062,374 shares (60,845) (60,845)Total liabilities 2,614,053 2,086,460 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 10,204 10,204 Class B Common Stock, $1.00 par value: authorized - 10,000,000 shares; issued-2,820,836 and 2,799,816 shares, respectively 2,819 2,798 Class C Common Stock, $1.00 par value: authorized - 20,000,000 shares; issued - none Capital in excess of par value 120,417 116,769 Retained earnings 388,718 301,511 Accumulated other comprehensive loss (94,202) (92,897) Treasury stock, at cost: Common Stock - 3,062,374 shares (60,845) (60,845) Treasury stock, at cost: Class B Common Stock - 628,114 shares (409) (409) Total equity of Coca-cola Bottling Co. Consolidated 366,702 277,131 Noncontrolling interest 92,205 85,893 Total equity 458,907 363,024 Total liabilities and equity S 3,072,960 2,449,484 See lid statenCOCA-COLA BOTTLING CO. CONSOLIDATED CONSOLIDATED STATEMENTS OF CASH FLOWS Fiscal Year (in thousands) 2017 2016 2015 Cash Flows from Operating Activities: Net income $ 102,847 $ 56,663 $ 65,044 Adjustments to reconcile net income to net cash provided by operating activities: Depreciation expense 150,422 111,613 78,096 Amortization of intangible assets and deferred proceeds, net 18,419 5,010 2,800 Deferred income taxes (58,111 ) 42,942 10,408 Loss on sale of property, plant and equipment 4,492 2,892 1,268 Impairment of property, plant and equipment 382 148 (Gain) loss on exchange transactions (12,893) 692 (8,807) Gain on sale of business (22,651) Bargain purchase gain, net of tax of $1,265 (2,011) Proceeds from bottling agreements conversion 91,450 Proceeds from Legacy Facilities Credit 30,647 Amortization of debt costs 1,082 1,855 2,011 Stock compensation expense 7,922 7,154 7,300 Fair value adjustment of acquisition related contingent consideration 3,226 (1,910) 3,576 System Transformation Transactions settlements (6,996) Gain on acquisition of Southeastern Container preferred shares in CCR redistribution (6,012) Change in current assets less current liabilities (exclusive of acquisitions) 259 (39,909) (18,262) Change in other noncurrent assets (exclusive of acquisitions) (17,916) (14,564) (4,292) Change in other noncurrent liabilities (exclusive of acquisitions) (1,100) (10,850) (6,214) Other 78 25 (124) Total adjustments 204,969 105,332 43,246 Net cash provided by operating activities 307,816 $ 161,995 $ 108,290Cash Flows from Investing Activities: Acquisition of Expansion Territories, net of cash acquired and settlements $ (265,060) $ (272,637) $ (71,209) Additions to property, plant and equipment (exclusive of acquisitions) (176,601 ) (172,586) (163,887) Net cash paid for exchange transactions (19,393) (10,498) Glaceau distribution agreement consideration (15,598 ) Portion of Legacy Facilities Credit related to Mobile, Alabama facility 12,364 Proceeds from cold drink equipment 8,400 Investment in CONA Services LLC (3,615) (7,875) Proceeds from the sale of property, plant and equipment 608 1,072 1,891 Proceeds from the sale of BYB Brands, Inc. 26,360 Net cash used in investing activities S (458,895 S (452,026) $ (217,343) Cash Flows from Financing Activities: Proceeds from issuance of Senior Notes $ 125,000 $ $ 349,913 Borrowings under Term Loan Facility 300,000 Borrowing under Revolving Credit Facility 448,000 410,000 334,000 Payments on Revolving Credit Facility (393,000 ) (258,000 ) (405,000 ) Payments on Senior Notes (164,757) (100,000) Cash dividends paid (9,328) (9,307) (9,287) Payment of acquisition related contingent consideration (16,738) (13,550) (4,039) Principal payments on capital lease obligations (7,485 ) (7,063) (6,555) Other (318 (940) (3,576) Net cash provided by financing activities S 146,131 $ 256,383 $ 155,456 Net increase (decrease) in cash $ (4,948) $ (33,648) $ 46,403 Cash at beginning of year 21,850 55,498 9,095 Cash at end of year S 16,902 21,850 $ 55,498COCACOLA BOTTLING CO. CONSOLIDATED CONSOLIDATED STATEMENTS OF CHANGES IN STOCKHOLDERS' EQUITY Treasury Total Accumulated Treasury Stock 7 Equity Class B Capital in Other Stock , Class B of CocaACola (in 1'}30"fsa'lr*'d-Sl: except Share Common Common Excess of Retained Comprehensive Common Common Bottling Co. Noucontrolling Total daft! Stock Stock Par Value Earnin 5 Loss Stock Stock Consolidated Interest E ui Net Income - - 59 002 - - 59 002 6 042 65 044 Cash dividends paid: Class B Common ($1.00 per share - - - 2,146 - - - 2,146 - 2,146 Balance on January 3,2016 $10,204 S 2,777 $113,064 $260,672 $ 82,407 S 60,845 S 409 $ 243,056 $ 79,376 $322,462 Other comprehensive income (loss), net of tax - - - - 10,490 - - 10,490 - 10,490 Common ($1.00 per share) - - - 7,141 - - - 7,141 - 7,141 Issuance of 20,920 shares of Class B Common Stock 3,705 - 3,726 - 3,726 Net Income - 96, 535 - 96, 535 6, 312 102 8,47 Issuance of 20,920 shares of Class B Common Stock 21 2,204 2,225 2,225 Balance on January 3, 2016 $10,204 $ 2,777 $113,064 $260,672 $ (82,407) $(60,845) $ (409) $ 243,056 $ 79,376 $322,432 Net income 50,146 50,146 6,517 56,663 Other comprehensive income (loss), net of tax (10,490) (10,490) (10,490) Cash dividends paid: Common ($1.00 per share) (7,141) (7,141 ) (7,141 ) Class B Common ($1.00 per share) (2,166) (2,166) (2, 166) Issuance of 20,920 shares of Class B Common Stock 21 3,705 3,726 3,726 Balance on January 1, 2017 $10,204 $ 2,798 $116,769 $301,511 $ (92,897) $(60,845) $ (409) $ 277,131 $ 85,893 $363,024 Net income 96,535 96,535 6,312 102,847 Other comprehensive income (loss), net of tax (1,305) (1,305) (1,305) Cash dividends paid: Common ($1.00 per share) (7,141) (7,141) (7,141) Class B Common ($1.00 per share) (2,187) (2,187) (2, 187) Issuance of 21,020 shares of Class B Common Stock 21 3,648 3,669 3,669 Balance on December 31, 2017 $10,204 $ 2,819 $120,417 $388,718 (94,202) $(60,845) $ (409) $ 366,702 S 92,205 $458,907 See accompanying notes to consolidated financial statements