Using the Coke Cola Company
Part A (Ratio Analysis - using Balance Sheet and Income Statement) - Assignment: (1) For your assigned company, compute the following ratios (see the Excel template) using the company's balance sheet and income statement for the three most current years. NOTE: download or insert the actual financial statements. a. Liquidity Ratios b. Debt or Solvency Ratios C. Asset Management Ratios d. Profitability Ratios (2) For each ratio, graph the three year trend. (3) Upload your MS Excel Spreadsheet (one file) via Canvas. Include your name and the company's name on the spreadsheet. You name and company must be on the spreadsheet to receive any points. NOTE: all this information may be on one tab of the spreadsheet. IN USD THOUSANDS ANNUAL V Period Ending: 12/31/2020 12/31/2019 12/31/2018 12/31/2017 Total Revenue Cost of Revenue $33,014,000 $37,266,000 $34,300,000 $36,212,000 $13,433,000 $14,619,000 $13,067,000 $13,721,000 $19,581,000 $22,647,000 $21,233,000 $22,491,000 Gross Profit Operating Expenses Research and Development Sales, General and Admin. $10,584,000 $12,561,000 $12,081,000 $14,736,000 Non-Recurring Items Other Operating Items Operating Income Add'l income/expense items Earnings Before Interest and Tax Interest Expense Earnings Before Tax Income Tax $8,997,000 $10,086,000 $9,152,000 $7,755,000 $1,211,000 $597,000 -$985,000 $1,084,000 $11,186,000 $11,732,000 $9,175,000 $7,743,000 $1,437,000 $946,000 $950,000 $853,000 $9,749,000 $10,786,000 $8,225,000 $6,890,000 $1,981,000 $1,801,000 $1,749,000 $5,607,000 $978,000 $1,049,000 $1,008,000 $1,072,000 Minority Interest Equity Earnings/Loss Unconsolidated Subsidiary Net Income-Cont. Operations -$21,000 -$65,000 -$42,000 -$35,000 Net Income $8,725,000 $9,969,000 $7,442,000 $7,747,000 $8,920,000 $6,434,000 $2,320,000 $1,248,000 Net Income Applicable to Common Shareholders $7,747,000 $8,920,000 $6,434,000 $1,248,000 Period Ending: 12/31/2020 12/31/2019 12/31/2018 12/31/2017 Current Assets Cash and Cash Equivalents Short-Term Investments Net Receivables $6,795,000 $6,480,000 $9,077,000 $6,006,000 $4,119,000 $4,695,000 $7,038,000 $14,669,000 $3,144,000 $3,971,000 $3,685,000 $3,667,000 $3,266,000 $3,379,000 $3,071,000 $2,655,000 $1,916,000 $1,886,000 $2,059,000 $9,548,000 $19,240,000 $20,411,000 $24.930,000 $36,545,000 Inventory Other Current Assets Total Current Assets Long-Term Assets Long-Term Investments Fixed Assets Goodwill Intangible Assets $20,085,000 $19,879,000 $20,279,000 $21,952,000 $10,777,000 $10,838,000 $9,598,000 $8,203,000 $17,506,000 $16,764,000 $14,109,000 $9,401,000 $11,044,000 $10,002,000 $7,478,000 $7,235,000 $6,184,000 $6,075,000 $4,148,000 $4,230,000 $2,460,000 $2,412,000 $2,674,000 $330,000 $87,296,000 $86,381,000 $83,216,000 $87,896,000 Other Assets Deferred Asset Charges Total Assets Current Liabilities $11,933,000 $11,726,000 $9,944,000 $9,158,000 Accounts Payable Short-Term Debt / Current Portion of Long- Term Debt Other Current Liabilities $2,668,000 $15,247,000 $18,838,000 $16,503,000 Total Current Liabilities $1,533,000 $14,601,000 $26,973,000 $28,782,000 $27,194,000 $40,125,000 $27,516,000 $25,376,000 $31,182,000 S9 453 On SA 5100 27 646 SA021 000 Long-Term Debt Other Ilahilities you agree to the storing of Other Assets Deferred Asset Charges $6,184,000 $6,075,000 $4,148,000 $4,230,000 $2,460,000 $2,412,000 $2,674,000 $330,000 $87,296,000 $86,381,000 $83,216,000 $87,896,000 Total Assets Current Liabilities $11,933,000 $11,726,000 $9,944,000 $9,158,000 Accounts Payable Short-Term Debt / Current Portion of Long- Term Debt $2,668,000 $15,247,000 $18,838,000 $16,503,000 Other Current Liabilities Total Current Liabilities, Long-Term Debt $1,533,000 $14,601,000 $26,973,000 $28,782,000 $27,194,000 $40,125,000 $27,516,000 $25,376,000 $31,182,000 $9,453,000 $8,510,000 $7,646,000 $8,021,000 $1,833,000 $2,284,000 $2,354,000 $2,522,000 $1,985,000 $2,117,000 $2,077,000 $1,905,000 Other Liabilities Deferred Liability Charges Misc, Stocks Minority Interest Total Liabilities $67,997,000 $67,400,000 $66,235,000 $70,824,000 Stock Holders Equity Common Stocks Capital Surplus Retained Earnings Treasury Stock Other Equity Total Equity Total Liabilities & Equity $1,760,000 $1,760,000 $1,760,000 $1,760,000 $66,555,000 $65,855,000 $63,234,000 $60,430,000 -$52,016,000 $52,244,000 $51,719,000-$50,677,000 $17,601,000 $17,154,000 $16,520,000 $15,864,000 -$14,601,000 $13,544,000 $12,814,000 $10,305,000 $19,299,000 $18,981,000 $16,981,000 $17,072,000 $87,296,000 $86,381,000 $83,216,000 $87,896,000 Part A (Ratio Analysis - using Balance Sheet and Income Statement) - Assignment: (1) For your assigned company, compute the following ratios (see the Excel template) using the company's balance sheet and income statement for the three most current years. NOTE: download or insert the actual financial statements. a. Liquidity Ratios b. Debt or Solvency Ratios C. Asset Management Ratios d. Profitability Ratios (2) For each ratio, graph the three year trend. (3) Upload your MS Excel Spreadsheet (one file) via Canvas. Include your name and the company's name on the spreadsheet. You name and company must be on the spreadsheet to receive any points. NOTE: all this information may be on one tab of the spreadsheet. IN USD THOUSANDS ANNUAL V Period Ending: 12/31/2020 12/31/2019 12/31/2018 12/31/2017 Total Revenue Cost of Revenue $33,014,000 $37,266,000 $34,300,000 $36,212,000 $13,433,000 $14,619,000 $13,067,000 $13,721,000 $19,581,000 $22,647,000 $21,233,000 $22,491,000 Gross Profit Operating Expenses Research and Development Sales, General and Admin. $10,584,000 $12,561,000 $12,081,000 $14,736,000 Non-Recurring Items Other Operating Items Operating Income Add'l income/expense items Earnings Before Interest and Tax Interest Expense Earnings Before Tax Income Tax $8,997,000 $10,086,000 $9,152,000 $7,755,000 $1,211,000 $597,000 -$985,000 $1,084,000 $11,186,000 $11,732,000 $9,175,000 $7,743,000 $1,437,000 $946,000 $950,000 $853,000 $9,749,000 $10,786,000 $8,225,000 $6,890,000 $1,981,000 $1,801,000 $1,749,000 $5,607,000 $978,000 $1,049,000 $1,008,000 $1,072,000 Minority Interest Equity Earnings/Loss Unconsolidated Subsidiary Net Income-Cont. Operations -$21,000 -$65,000 -$42,000 -$35,000 Net Income $8,725,000 $9,969,000 $7,442,000 $7,747,000 $8,920,000 $6,434,000 $2,320,000 $1,248,000 Net Income Applicable to Common Shareholders $7,747,000 $8,920,000 $6,434,000 $1,248,000 Period Ending: 12/31/2020 12/31/2019 12/31/2018 12/31/2017 Current Assets Cash and Cash Equivalents Short-Term Investments Net Receivables $6,795,000 $6,480,000 $9,077,000 $6,006,000 $4,119,000 $4,695,000 $7,038,000 $14,669,000 $3,144,000 $3,971,000 $3,685,000 $3,667,000 $3,266,000 $3,379,000 $3,071,000 $2,655,000 $1,916,000 $1,886,000 $2,059,000 $9,548,000 $19,240,000 $20,411,000 $24.930,000 $36,545,000 Inventory Other Current Assets Total Current Assets Long-Term Assets Long-Term Investments Fixed Assets Goodwill Intangible Assets $20,085,000 $19,879,000 $20,279,000 $21,952,000 $10,777,000 $10,838,000 $9,598,000 $8,203,000 $17,506,000 $16,764,000 $14,109,000 $9,401,000 $11,044,000 $10,002,000 $7,478,000 $7,235,000 $6,184,000 $6,075,000 $4,148,000 $4,230,000 $2,460,000 $2,412,000 $2,674,000 $330,000 $87,296,000 $86,381,000 $83,216,000 $87,896,000 Other Assets Deferred Asset Charges Total Assets Current Liabilities $11,933,000 $11,726,000 $9,944,000 $9,158,000 Accounts Payable Short-Term Debt / Current Portion of Long- Term Debt Other Current Liabilities $2,668,000 $15,247,000 $18,838,000 $16,503,000 Total Current Liabilities $1,533,000 $14,601,000 $26,973,000 $28,782,000 $27,194,000 $40,125,000 $27,516,000 $25,376,000 $31,182,000 S9 453 On SA 5100 27 646 SA021 000 Long-Term Debt Other Ilahilities you agree to the storing of Other Assets Deferred Asset Charges $6,184,000 $6,075,000 $4,148,000 $4,230,000 $2,460,000 $2,412,000 $2,674,000 $330,000 $87,296,000 $86,381,000 $83,216,000 $87,896,000 Total Assets Current Liabilities $11,933,000 $11,726,000 $9,944,000 $9,158,000 Accounts Payable Short-Term Debt / Current Portion of Long- Term Debt $2,668,000 $15,247,000 $18,838,000 $16,503,000 Other Current Liabilities Total Current Liabilities, Long-Term Debt $1,533,000 $14,601,000 $26,973,000 $28,782,000 $27,194,000 $40,125,000 $27,516,000 $25,376,000 $31,182,000 $9,453,000 $8,510,000 $7,646,000 $8,021,000 $1,833,000 $2,284,000 $2,354,000 $2,522,000 $1,985,000 $2,117,000 $2,077,000 $1,905,000 Other Liabilities Deferred Liability Charges Misc, Stocks Minority Interest Total Liabilities $67,997,000 $67,400,000 $66,235,000 $70,824,000 Stock Holders Equity Common Stocks Capital Surplus Retained Earnings Treasury Stock Other Equity Total Equity Total Liabilities & Equity $1,760,000 $1,760,000 $1,760,000 $1,760,000 $66,555,000 $65,855,000 $63,234,000 $60,430,000 -$52,016,000 $52,244,000 $51,719,000-$50,677,000 $17,601,000 $17,154,000 $16,520,000 $15,864,000 -$14,601,000 $13,544,000 $12,814,000 $10,305,000 $19,299,000 $18,981,000 $16,981,000 $17,072,000 $87,296,000 $86,381,000 $83,216,000 $87,896,000
