Hi! I need some help for a group project.
I need to create ratios and find answers based for Asset Management of the years of 2018 and 2019
I have managed to make some ratios and label some amounts but I am unsure
We are using the Cola Cola Company Balance Sheet to get the numbers since its for the project:
The ratios I need to find and their formulas for Asset Management
This is what I have come up with so far
Can I please have some help/guidance on on how to find the exact amounts? I am also going to include the pictures of the Balance Sheet I am getting the numbers from.
Asset Management Inventory turnover Days sales outstanding (DSO) Sales Inventories Receivables Annual sales/365 Sales Net fixed assets Sales Total assets Fixed assets turnover Total assets turnover INV Turnover =Sales/Inventory Days Sales Outstanding = Accounts Recievable/AVG Sales Fixed Assets Turnover = Sales/Fixed Assets Total Assets Turnover = Sales/Total Assets NOTE: Numbers are from the Cola Cola Annual Report page 70 2018 INV Turnover = 31,856,000/3,071,000 = Days Sales Outstanding = 3,685,000/ Fixed Assets Turnover = 31,856,000/ Total Assets Turnover = 31,856,000/ 2019 INV Turnover = 37,266,000/3,379,000 = Days Sales Outstanding = 3,971,000/ Fixed Assets Turnover = 37,266,000/ Total Assets Turnover = 37,266,000/ THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (In millions except par value) December 31. 2019 2018 ASSETS $ 6,480 S 1,467 7,947 3,228 3,971 3,379 1,886 Current Assets Cash and cash equivalents Short-term investments Total Cash, Cash Equivalents and Short-Term Investments Marketable securities Trade accounts receivable, less allowances of $524 and $501, respectively Inventories Prepaid expenses and other assets Total Current Assets Equity method investments Other investments Other assets Deferred income tax assets Property, plant and equipment - net Trademarks with indefinite lives Bottlers' franchise rights with indefinite lives Goodwill Other intangible assets Total Assets 20,411 19,025 854 6,075 2,412 10,838 9,266 109 16,764 627 86,381 $ 9,077 2,025 11,102 5,013 3,685 3,071 2,059 24,930 19,412 867 4,148 2,674 9,598 6,682 51 14,109 745 83,216 $ $ 11,312 S 10,994 4,253 414 9,533 13,835 5,003 411 28,782 25,376 7,646 2,354 26,973 27,516 8,510 2,284 LIABILITIES AND EQUITY Current Liabilities Accounts payable and accrued expenses Loans and notes payable Current maturities of long-term debt Accrued income taxes Total Current Liabilities Long-term debt Other liabilities Deferred income tax liabilities The Coca-Cola Company Shareowners' Equity Common stock, $0.25 par value; authorized 11,200 shares; issued 7,040 shares Capital surplus Reinvested earnings Accumulated other comprehensive income (loss) Treasury stock, at cost - 2,760 and 2,772 shares, respectively Equity Attributable to Shareowners of The Coca-Cola Company Equity attributable to noncontrolling interests Total Equity Total Liabilities and Equity 1,760 17,154 65,855 (13,544) (52,244) 18,981 2,117 21,098 86,381 S 1,760 16,520 63,234 (12,814) (51,719) 16,981 2,077 19,058 83,216 $ THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF CASH FLOWS (In millions) 2019 2018 2017 $ 8,985 $ 1,365 201 (280) (421) 91 (467) 127 504 366 10,471 6,476 $ 1,086 225 (413) (457) (50) 743 558 1,283 1,260 219 (1,252) (628) 292 1,459 1,218 (252) Year Ended December 31, Operating Activities Consolidated net income Depreciation and amortization Stock-based compensation expense Deferred income taxes Equity (income) loss-net of dividends Foreign currency adjustments Significant (gains) losses - net Other operating charges Other items Net change in operating assets and liabilities Net Cash Provided by Operating Activities Investing Activities Purchases of investments Proceeds from disposals of investments Acquisitions of businesses, equity method investments and nonmarketable securities Proceeds from disposals of businesses, equity method investments and nonmarketable securities Purchases of property, plant and equipment Proceeds from disposals of property, plant and equipment Other investing activities Net Cash Provided by (Used in) Investing Activities 699 3,442 (1,240) 7,627 7,041 (4,704) 6,973 (5,542) 429 (2,054) 978 (56) (3,976) (7,789) 14,977 (1,263) 1,362 (1,548) 248 (60) 5,927 (17,296) 16,694 (3,809) 3,821 (1,750) 108 (80) (2,312) 23,009 (24,850) 1,012 (1,103) (6,845) (227) (9,004) 27,605 (30,600) 1,476 (1,912) (6,644) (272) (10,347) 29,926 (28,871) 1,595 (3,682) (6,320) (95) (7.447) Financing Activities Issuances of debt Payments of debt Issuances of stock Purchases of stock for treasury Dividends Other financing activities Net Cash Provided by (Used in) Financing Activities Effect of Exchange Rate Changes on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents Net increase (decrease) in cash, cash equivalents, restricted cash and restricted cash equivalents during the year Cash, cash equivalents, restricted cash and restricted cash equivalents at beginning of year Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents at End of Year Less: Restricted cash and restricted cash equivalents at end of year Cash and Cash Equivalents at End of Year (72) (262) 241 (2,477) 8,850 (2,581) 9,318 6,737 257 6,480 $ 2.945 6,373 9,318 241 9,077 $ 6,373 271 $ 6,102 Refer to Notes to Consolidated Financial Statements. THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF SHAREOWNERS' EQUITY (In millions except per share data) 2019 2018 2017 4.259 48 4,268 33 (21) 4,280 (39) 4,268 4,288 53 (82) 4,259 1,760 S 1,760 $ 1,760 $ Year Ended December 31, Equity Attributable to Shareowners of The Coca-Cola Company Number of Common Shares Outstanding Balance at beginning of year Treasury stock issued to employees related to stock-based compensation plans Purchases of stock for treasury Balance at end of year Common Stock Capital Surplus Balance at beginning of year Stock issued to employees related to stock-based compensation plans Stock-based compensation expense Other activities Balance at end of year Reinvested Earnings Balance at beginning of year Adoption of accounting standards! Net income attributable to shareowners of The Coca-Cola Company Dividends (per share $1.60, $1.56 and $1.48 in 2019, 2018 and 2017, respectively) Balance at end of year 16,520 433 15,864 467 14,993 655 201 219 225 (36) 16,520 17,154 15,864 65,502 63,234 546 8,920 (6,845) 65,855 60,430 3,014 6,434 (6,644) 1,248 (6,320) 60,430 63,234 (11,205 Accumulated Other Comprehensive Income (Loss) Balance at beginning of year Adoption of accounting standards! Net other comprehensive income (loss) Balance at end of year Treasury Stock (12,814) (564) (166) (13,544) (10,305) (409) (2,100) (12,814) 900 (10,305 (47,988 909 (51,719) 501 (1,026) (52.244) 18,981 $ (50,677) 704 (1,746) (51,719) 16,981 $ (3,598 (50,677 17,072 S S 1,905 S 158 35 42 Balance at beginning of year Treasury stock issued to employees related to stock-based compensation plans Purchases of stock for treasury Balance at end of year Total Equity Attributable to Shareowners of The Coca-Cola Company Equity Attributable to Noncontrolling Interests Balance at beginning of year Net income attributable to noncontrolling interests Net foreign currency translation adjustments Dividends paid to noncontrolling interests Acquisition of interests held by noncontrolling owners Contributions by noncontrolling interests Business combinations Deconsolidation of certain entities Other activities Total Equity Attributable to Noncontrolling Interests 2,077 $ 65 45 (48) (84) 38 53 (31) (15 3 59 101 1,805 (157 41 7 S 2,117 $ 2,077 $ 1,905 Asset Management Inventory turnover Days sales outstanding (DSO) Sales Inventories Receivables Annual sales/365 Sales Net fixed assets Sales Total assets Fixed assets turnover Total assets turnover INV Turnover =Sales/Inventory Days Sales Outstanding = Accounts Recievable/AVG Sales Fixed Assets Turnover = Sales/Fixed Assets Total Assets Turnover = Sales/Total Assets NOTE: Numbers are from the Cola Cola Annual Report page 70 2018 INV Turnover = 31,856,000/3,071,000 = Days Sales Outstanding = 3,685,000/ Fixed Assets Turnover = 31,856,000/ Total Assets Turnover = 31,856,000/ 2019 INV Turnover = 37,266,000/3,379,000 = Days Sales Outstanding = 3,971,000/ Fixed Assets Turnover = 37,266,000/ Total Assets Turnover = 37,266,000/ THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (In millions except par value) December 31. 2019 2018 ASSETS $ 6,480 S 1,467 7,947 3,228 3,971 3,379 1,886 Current Assets Cash and cash equivalents Short-term investments Total Cash, Cash Equivalents and Short-Term Investments Marketable securities Trade accounts receivable, less allowances of $524 and $501, respectively Inventories Prepaid expenses and other assets Total Current Assets Equity method investments Other investments Other assets Deferred income tax assets Property, plant and equipment - net Trademarks with indefinite lives Bottlers' franchise rights with indefinite lives Goodwill Other intangible assets Total Assets 20,411 19,025 854 6,075 2,412 10,838 9,266 109 16,764 627 86,381 $ 9,077 2,025 11,102 5,013 3,685 3,071 2,059 24,930 19,412 867 4,148 2,674 9,598 6,682 51 14,109 745 83,216 $ $ 11,312 S 10,994 4,253 414 9,533 13,835 5,003 411 28,782 25,376 7,646 2,354 26,973 27,516 8,510 2,284 LIABILITIES AND EQUITY Current Liabilities Accounts payable and accrued expenses Loans and notes payable Current maturities of long-term debt Accrued income taxes Total Current Liabilities Long-term debt Other liabilities Deferred income tax liabilities The Coca-Cola Company Shareowners' Equity Common stock, $0.25 par value; authorized 11,200 shares; issued 7,040 shares Capital surplus Reinvested earnings Accumulated other comprehensive income (loss) Treasury stock, at cost - 2,760 and 2,772 shares, respectively Equity Attributable to Shareowners of The Coca-Cola Company Equity attributable to noncontrolling interests Total Equity Total Liabilities and Equity 1,760 17,154 65,855 (13,544) (52,244) 18,981 2,117 21,098 86,381 S 1,760 16,520 63,234 (12,814) (51,719) 16,981 2,077 19,058 83,216 $ THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF CASH FLOWS (In millions) 2019 2018 2017 $ 8,985 $ 1,365 201 (280) (421) 91 (467) 127 504 366 10,471 6,476 $ 1,086 225 (413) (457) (50) 743 558 1,283 1,260 219 (1,252) (628) 292 1,459 1,218 (252) Year Ended December 31, Operating Activities Consolidated net income Depreciation and amortization Stock-based compensation expense Deferred income taxes Equity (income) loss-net of dividends Foreign currency adjustments Significant (gains) losses - net Other operating charges Other items Net change in operating assets and liabilities Net Cash Provided by Operating Activities Investing Activities Purchases of investments Proceeds from disposals of investments Acquisitions of businesses, equity method investments and nonmarketable securities Proceeds from disposals of businesses, equity method investments and nonmarketable securities Purchases of property, plant and equipment Proceeds from disposals of property, plant and equipment Other investing activities Net Cash Provided by (Used in) Investing Activities 699 3,442 (1,240) 7,627 7,041 (4,704) 6,973 (5,542) 429 (2,054) 978 (56) (3,976) (7,789) 14,977 (1,263) 1,362 (1,548) 248 (60) 5,927 (17,296) 16,694 (3,809) 3,821 (1,750) 108 (80) (2,312) 23,009 (24,850) 1,012 (1,103) (6,845) (227) (9,004) 27,605 (30,600) 1,476 (1,912) (6,644) (272) (10,347) 29,926 (28,871) 1,595 (3,682) (6,320) (95) (7.447) Financing Activities Issuances of debt Payments of debt Issuances of stock Purchases of stock for treasury Dividends Other financing activities Net Cash Provided by (Used in) Financing Activities Effect of Exchange Rate Changes on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents Net increase (decrease) in cash, cash equivalents, restricted cash and restricted cash equivalents during the year Cash, cash equivalents, restricted cash and restricted cash equivalents at beginning of year Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents at End of Year Less: Restricted cash and restricted cash equivalents at end of year Cash and Cash Equivalents at End of Year (72) (262) 241 (2,477) 8,850 (2,581) 9,318 6,737 257 6,480 $ 2.945 6,373 9,318 241 9,077 $ 6,373 271 $ 6,102 Refer to Notes to Consolidated Financial Statements. THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF SHAREOWNERS' EQUITY (In millions except per share data) 2019 2018 2017 4.259 48 4,268 33 (21) 4,280 (39) 4,268 4,288 53 (82) 4,259 1,760 S 1,760 $ 1,760 $ Year Ended December 31, Equity Attributable to Shareowners of The Coca-Cola Company Number of Common Shares Outstanding Balance at beginning of year Treasury stock issued to employees related to stock-based compensation plans Purchases of stock for treasury Balance at end of year Common Stock Capital Surplus Balance at beginning of year Stock issued to employees related to stock-based compensation plans Stock-based compensation expense Other activities Balance at end of year Reinvested Earnings Balance at beginning of year Adoption of accounting standards! Net income attributable to shareowners of The Coca-Cola Company Dividends (per share $1.60, $1.56 and $1.48 in 2019, 2018 and 2017, respectively) Balance at end of year 16,520 433 15,864 467 14,993 655 201 219 225 (36) 16,520 17,154 15,864 65,502 63,234 546 8,920 (6,845) 65,855 60,430 3,014 6,434 (6,644) 1,248 (6,320) 60,430 63,234 (11,205 Accumulated Other Comprehensive Income (Loss) Balance at beginning of year Adoption of accounting standards! Net other comprehensive income (loss) Balance at end of year Treasury Stock (12,814) (564) (166) (13,544) (10,305) (409) (2,100) (12,814) 900 (10,305 (47,988 909 (51,719) 501 (1,026) (52.244) 18,981 $ (50,677) 704 (1,746) (51,719) 16,981 $ (3,598 (50,677 17,072 S S 1,905 S 158 35 42 Balance at beginning of year Treasury stock issued to employees related to stock-based compensation plans Purchases of stock for treasury Balance at end of year Total Equity Attributable to Shareowners of The Coca-Cola Company Equity Attributable to Noncontrolling Interests Balance at beginning of year Net income attributable to noncontrolling interests Net foreign currency translation adjustments Dividends paid to noncontrolling interests Acquisition of interests held by noncontrolling owners Contributions by noncontrolling interests Business combinations Deconsolidation of certain entities Other activities Total Equity Attributable to Noncontrolling Interests 2,077 $ 65 45 (48) (84) 38 53 (31) (15 3 59 101 1,805 (157 41 7 S 2,117 $ 2,077 $ 1,905
