Calculate the following ratios:

• Common Stockholders Equity Ratio
• Profit Margin Ratio
• Cash Ratio
• Debt to Equity Ratio
• Debt Ratio

Explain how the ratio is calculated and discuss and interpret the ratios that you calculated. Submit a screenshot of the company financial statements as an appendix. The analysis must show all formula calculations to support your results.

????

Transcribed Image Text:

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 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, $1.00 par value: authorized - 10,000,000 shares; issued-2,820,836 and 2,799,816 shares, respectively Class C Common Stock, $1.00 par value: authorized - 20,000,000 shares; issued - nor none Capital in excess of par value Retained earnings Accumulated other comprehensive loss Treasury stock, at cost: Common Stock - 3,062,374 shares Treasury stock, at cost: Class B Common Stock - 628,114 shares Total equity of Coca-Cola Bottling Co. Consolidated Noncontrolling interest Total equity Total liabilities and equity $ 16,902 S 396,022 (7,606) 65,996 38,960 183,618 100,646 794,538 1,031,388 29,837 116,209 8,221 S 197,049 171,042 185,530 72,484 5,126 169,316 913,352 18,320 3,072.960 S 2,449,484 639,452 112,364 118,392 620,579 35,248 1,088,018 2,614,053 10,204 2,819 120,417 388,718 (94,202) (60,845) (409) 21,850 271,661 366,702 92,205 458,907 3.072.960 (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 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 2,798 116,769 301,511 (92,897) (60,845) (409) 277,131 85,893 363,024 2.449.484 (in thousands) Cash Flows from Operating Activities: Net income Adjustments to reconcile net income to net cash provided by operating activities: Depreciation expense Amortization of intangible assets and deferred proceeds, net Deferred income taxes Loss on sale of property, plant and equipment Impairment of property, plant and equipment (Gain) loss on exchange transactions Gain on sale of business Bargain purchase gain, net of tax of $1,265 Proceeds from bottling agreements conversion Proceeds from Legacy Facilities Credit Amortization of debt costs Stock compensation expense Fair value adjustment of acquisition related contingent consideration System Transformation Transactions settlements Gain on acquisition of Southeastern Container preferred shares in CCR redistribution Change in current assets less current liabilities (exclusive of acquisitions) Change in other noncurrent assets (exclusive of acquisitions) Change in other noncurrent liabilities (exclusive of acquisitions) Other Total adjustments Net cash provided by operating activities Cash Flows from Investing Activities: Acquisition of Expansion Territories, net of cash acquired and settlements Additions to property, plant and equipment (exclusive of acquisitions) Net cash paid for exchange transactions Glacéau distribution agreement consideration Portion of Legacy Facilities Credit related to Mobile, Alabama facility Proceeds from cold drink equipment Investment in CONA Services LLC Proceeds from the sale of property, plant and equipment Proceeds from the sale of BYB Brands, Inc. Net cash used in investing activities Cash Flows from Financing Activities: Proceeds from issuance of Senior Notes Borrowings under Term Loan Facility Borrowing under Revolving Credit Facility Payments on Revolving Credit Facility Payments on Senior Notes Cash dividends paid Payment of acquisition related contingent consideration Principal payments on capital lease obligations Other Net cash provided by financing activities Net increase (decrease) in cash Cash at beginning of year Cash at end of year 2017 102,847 $ 150,422 18,419 (58,111) 4,492 (12,893) 91,450 30,647 1,082 7,922 3,226 (6,996) (6,012) 259 Fiscal Year 2016 (17,916) (1,100) 78 (39,909) (14,564) (10,850) 25 204,969 105,332 307,816 S 161,995 56,663 111,613 5,010 125,000 $ 448,000 (393,000) 42,942 2,892 382 692 (265,060) S (272,637) S (176,601) (172,586) (19,393) (15,598) 12,364 8,400 (3,615) 608 (9,328) (16,738) (7,485) (318) 146,131 S 1,855 7,154 (1,910) (4,948) S 21,850 16.902 (7,875) 1,072 300,000 410,000 (258,000) (164,757) (9,307) (13,550) (7,063) (940 256,383 S 2015 (33,648) S 55,498 21.850 65,044 78,096 2,800 10,408 1,268 148 (8,807) (22,651) (2,011) 1,891 26,360 (458,895) S (452,026) S (217,343) 2,011 7,300 3,576 (18,262) (4,292) (6,214) (124) 43,246 108,290 (71,209) (163,887) (10,498) 349,913 334,000 (405,000) (100,000) (9,287) (4,039) (6,555) (3,576) 155,456 46,403 9,095 55.498 (in thousands) Net income 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 Foreign currency translation adjustment Other comprehensive income (loss), net of tax Comprehensive income Less: Comprehensive income attributable to noncontrolling interest Comprehensive income attributable to Coca-Cola Bottling Co. Consolidated S 2017 102,847 $ (6,225) 18 592 (1,935) 6,220 25 (1,305) 101,542 6,312 95,230 Fiscal Year 2016 $ 56,663 S (4,150) 17 (4,286) (2,065) (10,490) 46,173 6,517 39,656 S 2015 65,044 6,624 21 2,934 (2,068) 7,507 72,551 6,042 66,509 Class B share Accumulated Other Retained Comprehensive Earnings Loss Common Common Total Equity Stock Stock (in thousands, except s data) Balance on December 28, 2014 $10.204 S 2,756 S110,860 $210,957 S (89,914) S(60,845) S (409) S 183.609 S 73.334 $256.943 Net income 59,002 59,002 6,042 65,044 Other comprehensive income (loss), net of tax 7,507 Cash dividends paid: Capital in Excess of Par Value Common ($1.00 per share) Class B Common ($1.00 per share) Issuance of 21,020 shares of Class B Common Stock (7,141) (2,146) Common ($1.00 per share) Class B Common ($1.00 per share) Issuance of 20,920 shares of Class B Common Stock 21 3,705 Balance on January 1, 2017 S10,204 $ 2,798 $116,769 $301,511 Net income 96,535 Other comprehensive income (loss), net of tax Cash dividends paid: Common ($1.00 per share) Class B Common ($1.00 per share) Issuance of 20,920 shares of Class B Common Stock 21 2,204 2,225 Balance on January 3, 2016 $10,204 $ 2,777 $113,064 $260,672 S (82,407) S(60,845) S (409) $ 243,056 S Net income 50,146 50,146 Other comprehensive income (loss), net of tax (10,490) Cash dividends paid: (7,141) (7,141) (2,166) (2,166) 3,726 3,726 (92,897) S(60,845) S (409) S 277,131 S 85,893 $363,024 96,535 6,312 102,847 (1,305) (1,305) (7,141) (2,166) 7,507 (7,141) (2,187) Treasury Total Treasury Stock- Equity Stock- Class B of Coca-Cola Common Common Bottling Co. Noncontrolling Stock Stock Consolidated Interest (10,490) (1,305) 7,507 (7,141) (2,146) (7,141) (2,187) (7,141) (2,146) 2,225 79,376 $322,432 6,517 56,663 (10,490) (7,141) (2,187) 21 3,648 3,669 3,669 Balance on December 31, 2017 S10,204 $ 2,819 $120,417 $388,718 S (94,202) S(60,845) S (409) S 366,702 S 92,205 $458,907 (in thousands, except per share data) Net sales Cost of sales 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) Net income Less: Net income attributable to noncontrolling interest Net income attributable to Coca-Cola Bottling Co. Consolidated 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 Class B Common Stock 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: Common Stock Weighted average number of Common Stock shares outstanding - assuming dilution Class B Common Stock Weighted average number of Class B Common Stock shares outstanding - assuming dilution $ 2017 2016 4,323,668 $ 3,156,428 S 2,782,721 1,940,706 1,540,947 1,444,768 96,179 41,869 (4,197) 12,893 63,006 (39,841) 102,847 6,312 96,535 S 10.35 $ 7,141 10.35 2,188 10.30 $ 9,369 10.29 $ 2,228 1,215,722 1,087,863 127,859 36,325 1,870 (692) 92,712 36,049 56,663 6,517 50,146 S 5.39 $ 7,141 5.39 2,168 5.36 9,349 5.35 2,208 S S S 2015 2,306,458 1,405,426 901,032 802,888 98,144 28,915 (3,576) 8,807 22,651 2,011 99,122 34,078 65,044 6,042 59,002 6.35 7,141 6.35 2,147 6.33 9,328 6.31 2,187 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 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, $1.00 par value: authorized - 10,000,000 shares; issued-2,820,836 and 2,799,816 shares, respectively Class C Common Stock, $1.00 par value: authorized - 20,000,000 shares; issued - nor none Capital in excess of par value Retained earnings Accumulated other comprehensive loss Treasury stock, at cost: Common Stock - 3,062,374 shares Treasury stock, at cost: Class B Common Stock - 628,114 shares Total equity of Coca-Cola Bottling Co. Consolidated Noncontrolling interest Total equity Total liabilities and equity $ 16,902 S 396,022 (7,606) 65,996 38,960 183,618 100,646 794,538 1,031,388 29,837 116,209 8,221 S 197,049 171,042 185,530 72,484 5,126 169,316 913,352 18,320 3,072.960 S 2,449,484 639,452 112,364 118,392 620,579 35,248 1,088,018 2,614,053 10,204 2,819 120,417 388,718 (94,202) (60,845) (409) 21,850 271,661 366,702 92,205 458,907 3.072.960 (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 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 2,798 116,769 301,511 (92,897) (60,845) (409) 277,131 85,893 363,024 2.449.484 (in thousands) Cash Flows from Operating Activities: Net income Adjustments to reconcile net income to net cash provided by operating activities: Depreciation expense Amortization of intangible assets and deferred proceeds, net Deferred income taxes Loss on sale of property, plant and equipment Impairment of property, plant and equipment (Gain) loss on exchange transactions Gain on sale of business Bargain purchase gain, net of tax of $1,265 Proceeds from bottling agreements conversion Proceeds from Legacy Facilities Credit Amortization of debt costs Stock compensation expense Fair value adjustment of acquisition related contingent consideration System Transformation Transactions settlements Gain on acquisition of Southeastern Container preferred shares in CCR redistribution Change in current assets less current liabilities (exclusive of acquisitions) Change in other noncurrent assets (exclusive of acquisitions) Change in other noncurrent liabilities (exclusive of acquisitions) Other Total adjustments Net cash provided by operating activities Cash Flows from Investing Activities: Acquisition of Expansion Territories, net of cash acquired and settlements Additions to property, plant and equipment (exclusive of acquisitions) Net cash paid for exchange transactions Glacéau distribution agreement consideration Portion of Legacy Facilities Credit related to Mobile, Alabama facility Proceeds from cold drink equipment Investment in CONA Services LLC Proceeds from the sale of property, plant and equipment Proceeds from the sale of BYB Brands, Inc. Net cash used in investing activities Cash Flows from Financing Activities: Proceeds from issuance of Senior Notes Borrowings under Term Loan Facility Borrowing under Revolving Credit Facility Payments on Revolving Credit Facility Payments on Senior Notes Cash dividends paid Payment of acquisition related contingent consideration Principal payments on capital lease obligations Other Net cash provided by financing activities Net increase (decrease) in cash Cash at beginning of year Cash at end of year 2017 102,847 $ 150,422 18,419 (58,111) 4,492 (12,893) 91,450 30,647 1,082 7,922 3,226 (6,996) (6,012) 259 Fiscal Year 2016 (17,916) (1,100) 78 (39,909) (14,564) (10,850) 25 204,969 105,332 307,816 S 161,995 56,663 111,613 5,010 125,000 $ 448,000 (393,000) 42,942 2,892 382 692 (265,060) S (272,637) S (176,601) (172,586) (19,393) (15,598) 12,364 8,400 (3,615) 608 (9,328) (16,738) (7,485) (318) 146,131 S 1,855 7,154 (1,910) (4,948) S 21,850 16.902 (7,875) 1,072 300,000 410,000 (258,000) (164,757) (9,307) (13,550) (7,063) (940 256,383 S 2015 (33,648) S 55,498 21.850 65,044 78,096 2,800 10,408 1,268 148 (8,807) (22,651) (2,011) 1,891 26,360 (458,895) S (452,026) S (217,343) 2,011 7,300 3,576 (18,262) (4,292) (6,214) (124) 43,246 108,290 (71,209) (163,887) (10,498) 349,913 334,000 (405,000) (100,000) (9,287) (4,039) (6,555) (3,576) 155,456 46,403 9,095 55.498 (in thousands) Net income 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 Foreign currency translation adjustment Other comprehensive income (loss), net of tax Comprehensive income Less: Comprehensive income attributable to noncontrolling interest Comprehensive income attributable to Coca-Cola Bottling Co. Consolidated S 2017 102,847 $ (6,225) 18 592 (1,935) 6,220 25 (1,305) 101,542 6,312 95,230 Fiscal Year 2016 $ 56,663 S (4,150) 17 (4,286) (2,065) (10,490) 46,173 6,517 39,656 S 2015 65,044 6,624 21 2,934 (2,068) 7,507 72,551 6,042 66,509 Class B share Accumulated Other Retained Comprehensive Earnings Loss Common Common Total Equity Stock Stock (in thousands, except s data) Balance on December 28, 2014 $10.204 S 2,756 S110,860 $210,957 S (89,914) S(60,845) S (409) S 183.609 S 73.334 $256.943 Net income 59,002 59,002 6,042 65,044 Other comprehensive income (loss), net of tax 7,507 Cash dividends paid: Capital in Excess of Par Value Common ($1.00 per share) Class B Common ($1.00 per share) Issuance of 21,020 shares of Class B Common Stock (7,141) (2,146) Common ($1.00 per share) Class B Common ($1.00 per share) Issuance of 20,920 shares of Class B Common Stock 21 3,705 Balance on January 1, 2017 S10,204 $ 2,798 $116,769 $301,511 Net income 96,535 Other comprehensive income (loss), net of tax Cash dividends paid: Common ($1.00 per share) Class B Common ($1.00 per share) Issuance of 20,920 shares of Class B Common Stock 21 2,204 2,225 Balance on January 3, 2016 $10,204 $ 2,777 $113,064 $260,672 S (82,407) S(60,845) S (409) $ 243,056 S Net income 50,146 50,146 Other comprehensive income (loss), net of tax (10,490) Cash dividends paid: (7,141) (7,141) (2,166) (2,166) 3,726 3,726 (92,897) S(60,845) S (409) S 277,131 S 85,893 $363,024 96,535 6,312 102,847 (1,305) (1,305) (7,141) (2,166) 7,507 (7,141) (2,187) Treasury Total Treasury Stock- Equity Stock- Class B of Coca-Cola Common Common Bottling Co. Noncontrolling Stock Stock Consolidated Interest (10,490) (1,305) 7,507 (7,141) (2,146) (7,141) (2,187) (7,141) (2,146) 2,225 79,376 $322,432 6,517 56,663 (10,490) (7,141) (2,187) 21 3,648 3,669 3,669 Balance on December 31, 2017 S10,204 $ 2,819 $120,417 $388,718 S (94,202) S(60,845) S (409) S 366,702 S 92,205 $458,907 (in thousands, except per share data) Net sales Cost of sales 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) Net income Less: Net income attributable to noncontrolling interest Net income attributable to Coca-Cola Bottling Co. Consolidated 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 Class B Common Stock 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: Common Stock Weighted average number of Common Stock shares outstanding - assuming dilution Class B Common Stock Weighted average number of Class B Common Stock shares outstanding - assuming dilution $ 2017 2016 4,323,668 $ 3,156,428 S 2,782,721 1,940,706 1,540,947 1,444,768 96,179 41,869 (4,197) 12,893 63,006 (39,841) 102,847 6,312 96,535 S 10.35 $ 7,141 10.35 2,188 10.30 $ 9,369 10.29 $ 2,228 1,215,722 1,087,863 127,859 36,325 1,870 (692) 92,712 36,049 56,663 6,517 50,146 S 5.39 $ 7,141 5.39 2,168 5.36 9,349 5.35 2,208 S S S 2015 2,306,458 1,405,426 901,032 802,888 98,144 28,915 (3,576) 8,807 22,651 2,011 99,122 34,078 65,044 6,042 59,002 6.35 7,141 6.35 2,147 6.33 9,328 6.31 2,187