need fo find the horizontal and vertical analysis using the data in the coca-cola annual report
need to find ratio analysis using the same data provided in the financial summary
found the balance sheet
Horizontal and Vertical Analysis Using the data from the Coca-Cola 2017 Annual Report financial statements, starting on page 60, prepare a horizontal analysis for the balance sheet for a 2-year period and a vertical analysis for the income statement for a 2-year period. Submit the company financial statements with your analysis. The analysis must show all formula calculations to support your results. Item 8 Financial Statements and Supplementary Data COCA-COLA BOTTLING CO. CONSOLIDATED CONSOLIDATED STATEMENTS OF OPERATIONS Fiscal Year (in thousands, except per share data) 2017 2016 2015 3,156,428 1,940,706 Net sales 4,323,668 S S 2,306,458 Cost of sales 2,782,721 1,540,947 1,405,426 901,032 Gross profit Selling, delivery and administrative expenses Income from operations Interest expense, net Other income (expense), net Gain (loss) on exchange transactions Gain on sale of business 1,215,722 1,444,768 1,087,863 127,859 802,888 98,144 28,915 96,179 36,325 41,869 (4,197) 12,893 1,870 (3,576) (692) 8,807 22,651 2,011 99,122 Bargain purchase gain, net of tax of S1,265 Income before taxes 63,006 92,712 Income tax expense (benefit) (39,841) 102,847 36,049 56,663 34,078 65,044 Net income Less: Net income attributable to noncontrolling interest Net income attributable to Coca-Cola Bottling Co. Consolidated 6,312 96,535 6,517 50,146 6,042 59,002 Basic net income per share based on net income attributable to Coca Cola Bottling Co. Consolidated: Common Stock 10.35 5.39 S 6.35 7.141 Weighted average number of Common Stock shares outstanding 7,14 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 S 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,187 See accompanying notes to consolidated financial statements. COCA-COLA BOTTLING CO. CONSOLIDATED CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME Fiscal Year in thousands) Net income 2017 2016 2015 102,847 56,663 S 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) Prior service costs Adjustment due to the divestiture of the Deep South and Somerset Exchange Business and the Florence and Laurel Distribution Business 592 (4,286) (2,065) 2,934 (1,935) (2,068) 6,220 Foreign currency translation adjustment Other comprehensive income (loss), net of tax 25 (4) 7,507 (6) (1,305) (10,490) Comprehensive income Less: Comprehensive income attributable to noncontrolling interest 72,551 6,042 66,509 101,542 46,173 6,312 95,230 6,517 39,656 Comprehensive income attributable to Coca-Cola Bottling Co. Consolidated S See accompanying notes to consolidated financial statements Ratio Analysis Using the data from the Coca-Cola 2017 Annual Report financial statements, starting on page 60, calculate the following ratios: Common Stockholders Equity Ratio Profit Margin Ratio Cash Ratio Debt to Equity Ratio Debt Ratio Financial Statements and Supplementary Data Item 8. COCA-COLA BOTTLING CO. CONSOLIDATED CONSOLIDATED STATEMENTS OF OPERATIONS Fiscal Year in thous ands, except per share data) Net sales 2017 4,323,668 S 2016 2015 2,306,458 1,405,426 901,032 802,888 3,156,428 1,940,706 1,215,722 1,087,863 127,859 36,325 Cost of sales 2,782,721 1,540,947 1,444,768 96,179 Gross profit Selling, delivery and administrative expenses Income from operations Interest expense, net Other income (expense), net Gain (loss) on exchange transactions Gain on sale of business Bargain purchase gain, net of tax of $1,265 Income before taxes Income tax expense (benefit) 98,144 28,915 (3,576) 41,869 (4,197) 12,893 1,870 (692) 8,807 22,651 2,011 99,122 34,078 65,044 63,006 39,841) 102,847 92,712 36,049 56,663 Net income Less: Net income attributable to noncontrolling interest Net income attributable to Coca-Cola Bottling Co. Consolidated 6,517 50,146 6,042 59,002 6312 96,535 Basic net income per share based on net income attributable to Coca- Cola Bottling Co. Consolidated: Common Stock Weighted average number of Common Stock shares outstanding 6.35 10.35 5.39 7,141 7,141 7,141 6.35 10.35 5.39 Class B Common Stock 2,147 2.188 2,168 Weighted average number of Class B Common Stock shares outstanding Diluted net income per share based on net income attributable to Coca- Cola Bottling Co. Consolidated: 10.30 S 5.36 S 6.33 Common Stock Weighted average number of Common Stock shares outstanding- assuming dilution 9,349 9,328 9.369 S 6.31 5.35 10.29 Class B Common Stock Weighted average number of Class B Common Stock shares outstanding- assuming dilution 2,187 2.228 2.208 See accompanying notes to consolidated financial statements 60 60 COCA-COLA BOTTLING CO. CONSOLIDATED CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME Fiscal Year 2016 fin thous ands) Net income 2017 2015 102,847 S 56.663 65,044 Other comprehensive income (loss), net of tax: Defined benefit plans reclassification including pension costs: Actuarial gain (loss) Prior service costs Postretirement benefits reclassification including benefit costs Actuarial gain (loss) Prior service costs Adjustment due to the divestiture of the Deep South and Somerset Exchange Business and the Florence and Laurel Distribution Business Forcign currency translation adjustment Other comprehensive income (loss) net of tax (6,225) (4,150) 6,624 21 18 17 592 (4,286) 2,934 (2,068) (1,935) (2,065) 6,220 25 (6 (4) 7,507 (1,305) (10,490) Comprehensive income Less: Comprehensive income attributable to noncontrolling interest Comprehensive income attributable to Coca-Cola Bottling Co. Consolidated 101,542 6,312 95,230 46,173 72.551 6517 39.656 S 6,042 $ 66,509 See accompanying notes to consolidated financial statements. 61 COCA-COLA BOTTLING CO. CONSOLIDATED CONSOLIDATED BALANCE SHEETS fin thousands, expt share data) ASSETS Current Assets: December 31, 2017 January 1, 2017 Cash and cash equivalents Accounts receivable, trade Allowance for doubtful accounts S 21,850 271,66 (4448) 67,591 29,770 143,553 16,902 396,022 (7,606) 65.996 Accounts receivable from The Coca-Colla Company Accounts receivable, other Inventories 38,960 183,618 Prepaid expenses and other current assets Total current assets 100,646 794,538 63,834 593,811 1,031,388 29,837 116,209 Property, plant and equipment, net Leased property under capital leases, net Other assets Franchise rights Goodwill 812,989 33,552 86,091 533,040 169,316 144,586 Distribution agreements, net Customer lists and other identifiable intangible asscts, net 913.352 234,988 18,320 3,072,960 10,427 Total assets 2,449,484 LIABILITIES AND EQUITY Current liabilities: Current portion of obligations under capital leases Accounts payable, trade Accounts payable to The Coca-Cola Company 8,221 7,527 116,821 135,155 133,885 197,049 171,042 185,530 72.484 Other accrued liabilities Accrued compensation Accrued interest payable Tetal current liabilities 60,880 3,639 5,126 639,452 457,907 112.364 118,392 620,579 Deferred income taxes Pension and postretirement benefit obligations Other liabilities 174,854 126,679 378,572 Obligations under capital leases Long-term debt Total liabilities 35.248 41,194 1,088,018 907.254 2,614,053 2.086,460 Commitments and Contingencies Equity: Convertible Preferred Stock, $100.00 par value: authorized- 50,000 shares; issued- noee Nonconvertible Preferred Stock, $100.00 par value: authorized - 50,000 shares; issued - none Prefered Stock, S.01 par value: authorized -20,000,000 shares; issued- none Common Stock, S1.00 par value: authorized - 30,000,000 shares; issued- 10,203,821 shares Class B Common Stock, $1.00 par value: authorized- 10,000,000 shares; issued-2,820,836 and 2.799,816 shares, respectively Class C Common Stock, S1.00 par value: authorized-20,000,000 shares; issued-none Capital in excess of par value Retained earmings Accumulated other comprehensive loss Treasury steck, at cost: Common Stock- 3,062,374 shares Treasury stock, at cost: Class B Common Stock- 628, 114 shares 10.204 10,204 2,798 2,819 120,417 116,769 301,511 (92897) (60,845) (409) 277,13 85.893 388,718 (94.202) (60,845) (409) 366,702 Total equity of Coca-Cola Bottling Co. Consolidated Noncontrolling interest Total equity Total liabilities and equity 92,205 458,907 3,072.960 363,024 2,449,484 See accompanying notes to consolidated financial statements. Horizontal and Vertical Analysis Using the data from the Coca-Cola 2017 Annual Report financial statements, starting on page 60, prepare a horizontal analysis for the balance sheet for a 2-year period and a vertical analysis for the income statement for a 2-year period. Submit the company financial statements with your analysis. The analysis must show all formula calculations to support your results. Item 8 Financial Statements and Supplementary Data COCA-COLA BOTTLING CO. CONSOLIDATED CONSOLIDATED STATEMENTS OF OPERATIONS Fiscal Year (in thousands, except per share data) 2017 2016 2015 3,156,428 1,940,706 Net sales 4,323,668 S S 2,306,458 Cost of sales 2,782,721 1,540,947 1,405,426 901,032 Gross profit Selling, delivery and administrative expenses Income from operations Interest expense, net Other income (expense), net Gain (loss) on exchange transactions Gain on sale of business 1,215,722 1,444,768 1,087,863 127,859 802,888 98,144 28,915 96,179 36,325 41,869 (4,197) 12,893 1,870 (3,576) (692) 8,807 22,651 2,011 99,122 Bargain purchase gain, net of tax of S1,265 Income before taxes 63,006 92,712 Income tax expense (benefit) (39,841) 102,847 36,049 56,663 34,078 65,044 Net income Less: Net income attributable to noncontrolling interest Net income attributable to Coca-Cola Bottling Co. Consolidated 6,312 96,535 6,517 50,146 6,042 59,002 Basic net income per share based on net income attributable to Coca Cola Bottling Co. Consolidated: Common Stock 10.35 5.39 S 6.35 7.141 Weighted average number of Common Stock shares outstanding 7,14 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 S 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,187 See accompanying notes to consolidated financial statements. COCA-COLA BOTTLING CO. CONSOLIDATED CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME Fiscal Year in thousands) Net income 2017 2016 2015 102,847 56,663 S 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) Prior service costs Adjustment due to the divestiture of the Deep South and Somerset Exchange Business and the Florence and Laurel Distribution Business 592 (4,286) (2,065) 2,934 (1,935) (2,068) 6,220 Foreign currency translation adjustment Other comprehensive income (loss), net of tax 25 (4) 7,507 (6) (1,305) (10,490) Comprehensive income Less: Comprehensive income attributable to noncontrolling interest 72,551 6,042 66,509 101,542 46,173 6,312 95,230 6,517 39,656 Comprehensive income attributable to Coca-Cola Bottling Co. Consolidated S See accompanying notes to consolidated financial statements Ratio Analysis Using the data from the Coca-Cola 2017 Annual Report financial statements, starting on page 60, calculate the following ratios: Common Stockholders Equity Ratio Profit Margin Ratio Cash Ratio Debt to Equity Ratio Debt Ratio Financial Statements and Supplementary Data Item 8. COCA-COLA BOTTLING CO. CONSOLIDATED CONSOLIDATED STATEMENTS OF OPERATIONS Fiscal Year in thous ands, except per share data) Net sales 2017 4,323,668 S 2016 2015 2,306,458 1,405,426 901,032 802,888 3,156,428 1,940,706 1,215,722 1,087,863 127,859 36,325 Cost of sales 2,782,721 1,540,947 1,444,768 96,179 Gross profit Selling, delivery and administrative expenses Income from operations Interest expense, net Other income (expense), net Gain (loss) on exchange transactions Gain on sale of business Bargain purchase gain, net of tax of $1,265 Income before taxes Income tax expense (benefit) 98,144 28,915 (3,576) 41,869 (4,197) 12,893 1,870 (692) 8,807 22,651 2,011 99,122 34,078 65,044 63,006 39,841) 102,847 92,712 36,049 56,663 Net income Less: Net income attributable to noncontrolling interest Net income attributable to Coca-Cola Bottling Co. Consolidated 6,517 50,146 6,042 59,002 6312 96,535 Basic net income per share based on net income attributable to Coca- Cola Bottling Co. Consolidated: Common Stock Weighted average number of Common Stock shares outstanding 6.35 10.35 5.39 7,141 7,141 7,141 6.35 10.35 5.39 Class B Common Stock 2,147 2.188 2,168 Weighted average number of Class B Common Stock shares outstanding Diluted net income per share based on net income attributable to Coca- Cola Bottling Co. Consolidated: 10.30 S 5.36 S 6.33 Common Stock Weighted average number of Common Stock shares outstanding- assuming dilution 9,349 9,328 9.369 S 6.31 5.35 10.29 Class B Common Stock Weighted average number of Class B Common Stock shares outstanding- assuming dilution 2,187 2.228 2.208 See accompanying notes to consolidated financial statements 60 60 COCA-COLA BOTTLING CO. CONSOLIDATED CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME Fiscal Year 2016 fin thous ands) Net income 2017 2015 102,847 S 56.663 65,044 Other comprehensive income (loss), net of tax: Defined benefit plans reclassification including pension costs: Actuarial gain (loss) Prior service costs Postretirement benefits reclassification including benefit costs Actuarial gain (loss) Prior service costs Adjustment due to the divestiture of the Deep South and Somerset Exchange Business and the Florence and Laurel Distribution Business Forcign currency translation adjustment Other comprehensive income (loss) net of tax (6,225) (4,150) 6,624 21 18 17 592 (4,286) 2,934 (2,068) (1,935) (2,065) 6,220 25 (6 (4) 7,507 (1,305) (10,490) Comprehensive income Less: Comprehensive income attributable to noncontrolling interest Comprehensive income attributable to Coca-Cola Bottling Co. Consolidated 101,542 6,312 95,230 46,173 72.551 6517 39.656 S 6,042 $ 66,509 See accompanying notes to consolidated financial statements. 61 COCA-COLA BOTTLING CO. CONSOLIDATED CONSOLIDATED BALANCE SHEETS fin thousands, expt share data) ASSETS Current Assets: December 31, 2017 January 1, 2017 Cash and cash equivalents Accounts receivable, trade Allowance for doubtful accounts S 21,850 271,66 (4448) 67,591 29,770 143,553 16,902 396,022 (7,606) 65.996 Accounts receivable from The Coca-Colla Company Accounts receivable, other Inventories 38,960 183,618 Prepaid expenses and other current assets Total current assets 100,646 794,538 63,834 593,811 1,031,388 29,837 116,209 Property, plant and equipment, net Leased property under capital leases, net Other assets Franchise rights Goodwill 812,989 33,552 86,091 533,040 169,316 144,586 Distribution agreements, net Customer lists and other identifiable intangible asscts, net 913.352 234,988 18,320 3,072,960 10,427 Total assets 2,449,484 LIABILITIES AND EQUITY Current liabilities: Current portion of obligations under capital leases Accounts payable, trade Accounts payable to The Coca-Cola Company 8,221 7,527 116,821 135,155 133,885 197,049 171,042 185,530 72.484 Other accrued liabilities Accrued compensation Accrued interest payable Tetal current liabilities 60,880 3,639 5,126 639,452 457,907 112.364 118,392 620,579 Deferred income taxes Pension and postretirement benefit obligations Other liabilities 174,854 126,679 378,572 Obligations under capital leases Long-term debt Total liabilities 35.248 41,194 1,088,018 907.254 2,614,053 2.086,460 Commitments and Contingencies Equity: Convertible Preferred Stock, $100.00 par value: authorized- 50,000 shares; issued- noee Nonconvertible Preferred Stock, $100.00 par value: authorized - 50,000 shares; issued - none Prefered Stock, S.01 par value: authorized -20,000,000 shares; issued- none Common Stock, S1.00 par value: authorized - 30,000,000 shares; issued- 10,203,821 shares Class B Common Stock, $1.00 par value: authorized- 10,000,000 shares; issued-2,820,836 and 2.799,816 shares, respectively Class C Common Stock, S1.00 par value: authorized-20,000,000 shares; issued-none Capital in excess of par value Retained earmings Accumulated other comprehensive loss Treasury steck, at cost: Common Stock- 3,062,374 shares Treasury stock, at cost: Class B Common Stock- 628, 114 shares 10.204 10,204 2,798 2,819 120,417 116,769 301,511 (92897) (60,845) (409) 277,13 85.893 388,718 (94.202) (60,845) (409) 366,702 Total equity of Coca-Cola Bottling Co. Consolidated Noncontrolling interest Total equity Total liabilities and equity 92,205 458,907 3,072.960 363,024 2,449,484 See accompanying notes to consolidated financial statements
