Calculate the following ratios: Common Stockholders Equity Ratio Profit Margin Ratio Cash Ratio Debt to Equity Ratio
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Related Book For
Calculus Early Transcendentals
ISBN: 978-0321947345
2nd edition
Authors: William L. Briggs, Lyle Cochran, Bernard Gillett
Posted Date:
Students also viewed these accounting questions
-
In the experiment of Figure 23.2, explain how the ratio of red-to-green fluorescence provides information regarding gene regulation.
-
Financial information from fiscal year 2016 for two companies competing in the cosmetics industryThe Este Lauder Companies and e.l.f. Beauty Inc.appears in the table below. All dollar values are in...
-
Question no. 1 Current assets Cash and cash equivalents Accounts receivable (net) Inventories Prepaid expenses Total current assets Property, plant, and equipment Investments Intangibles and other...
-
Light Sweet Petroleum, Inc., is trying to evaluate a generation project with the following cash flows: Year Cash Flow 0 %u2013$ 39,200,000 1 63,200,000 2 %u2013 12,200,000 a-1 What is the NPV for the...
-
A home insurance application consists of two forms: F1, which relates to the home owner, and F2, which relates to the property. On receipt, each application is processed, recorded, and separated into...
-
The Analytics Department was asked to help analyze which of these issues?
-
Assume the same information in Exercise 15-61, except that the warranty is for three years and has a separate purchase price. The company collected \(\$ 20,000\), and \(\$ 35,000\) for this extended...
-
Jerry Smith (Problem 3-36) has done some analysis about the profitability of the bicycle shop. If Jerry builds the large bicycle shop, he will earn $60,000 if the market is favorable, but he will...
-
October 23 LO 1 No. 3 Prepare the payroll for the last pay period of October from Time Clerk's Report Nos. 40 and 41. The proper procedure in recording the payroll follows: ? Complete the payroll...
-
When measuring small pressure differences with a manometer, often one arm of the manometer is inclined to improve the accuracy of reading. (The pressure difference is still proportional to the...
-
A what range of unsigned numbers can be represented by a 16-bit ALU? (a) 0 to 65536 (b) 1 to 65536 (c) 0 to 65535 (d) 1 to 65535 (e) None of the above
-
The following are the transactions relating to the formation of Gray Mowing Services Incorporated and its first month of operations. a. The firm was organized and the initial stockholders invested...
-
Distinguish between the four kinds of organizational change that can be promoted with information technology. Explain how you have been impacted by one of these kinds of organizational change. What...
-
Suppose that initially Switzerland is in the long-run equilibrium. Suppose further that the Swiss central bank decreases the money supply. Use the IS-LM model together with the AD-AS model to...
-
Programmers frequently need to debug code. Sometimes it's their own code, but often its code written by other programmers. In this exercise you will be given an IntelliJ project containing a program...
-
1 . Based on your research, assume that you are fraud investigator assigned to coordinate an investigation of the fraudster. Determine how you would implement this investigation without the...
-
To illustrate an accounting system, we use an _____________ approach. This approach facilitates analyzing, recording, and summarizing transactions by expanding the accounting equation
-
a. What is the cost of borrowing if Amarjit borrows $28 500 and repays it over a four-year period? b. How many shares of each stock would he get if he used the $28 500 and invested equally in all...
-
Solve the following equations. ln y = 3
-
Evaluate each limit and justify your answer. lim (x 4 + Vx 9) x-1
-
Evaluate and simplify the following derivatives. d/d (4 tan ( 2 + 3 + 2))
-
Draw up a consolidated balance sheet as at 31 December \(19 \times 9\) from the following information. Investment in subsidiary: 30,000 shares bought 31.12.19X8 Fixed assets Current assets Share...
-
A The balance sheets of P Ltd and S$ Ltd are as follows: Investment in subsidiary: 120,000 shares bought 31.12.19X3 Fixed assets Current assets Share capital Profit and loss account: As at 31.12.19X3...
-
The following are the summarised balance sheets of P Ltd and S Ltd at 31 December 19X6. There were no additions or disposals of fixed assets by the group during the year. (b) P Limited acquired its...
Study smarter with the SolutionInn App