Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Compare each firms ratios to the available industry ratios for the most recent year. Analyse the performance of your company vs the industry. It is

Compare each firms ratios to the available industry ratios for the most recent year. Analyse the performance of your company vs the industry. It is also acceptable if you choose the major competitor instead of industry data. Identify and explain any strengths or weaknesses you find for your company of study. It could be that for some ratios, industry averages are not available (such as for EBITDA). You may look for alternative sources or skip industry comparison for that data.

The financial ratios you will need to compute are listed below:

a) Current ratio and quick ratio
b) Net working capital and change in net working capital for the most recent year.
c) EBITDA (or EBITD) margin, net profit margin (PM) andROE.
d) Total asset turnover ratio
e) Total debt (liabilities) to asset (D/A), times interest earned (TIE) ratios and Net debt/EBITDA ratio.
f) P/E and EV/EBITDA ratios only for the most recent year (with current market price). Note: For debt, include long-term and short-term debt; for cash, include marketable securities.).
g) Three more ratios of your choice (explain shortly what motivated you to choose these ratios e.g. choose wiselyJ).

Do all calculations in Excel by linking formulas directly to the statements.

Start your report with a description of the company you have been assigned to analyse. Please write your interpretations for the ratios you have calculated and a separate conclusion highlighting your main findings. Note that, in order to receive full points it is not enough to present the calculations and comments such as good, bad or smth. alike. Note that I am pretty sure that you can calculate the values for the ratios, therefore your main contribution should be your comments and interpretations. The assignment should end with the conclusion of main findings.

image text in transcribed
image text in transcribed
2015-12 2016-12 2017-12 2018-12 2019-12 TTM 44294 41863 35410 31856 37266 34326 17482 16465 13256 11770 14619 13717 26812 25398 22154 20086 22647 20609 16427 15262 10971 10307 598 -600 10305 9781 COCA-COLA CO (KO) CashFlowFlag INCOME STATEMENT Fiscal year ends in December. USD in millions except per share data. Revenue Cost of revenue Gross profit Operating expenses Sales, General and administrative Restructuring, merger and acquisition Other operating expenses Total operating expenses Operating income Interest Expense Other income (expense) Income before taxes Provision for income taxes Net income from continuing operations Net income from discontinuing ops Other Net income Net income available to common shareholders Earnings per share Basic Diluted Weighted average shares outstanding Basic Diluted EBITDA 1657 18084 8728 856 1733 9605 2239 7366 1510 16772 8626 733 243 8136 1586 6550 12496 1088 -857 12727 9427 841 - 1844 6742 5560 1182 101 -35 1248 1248 12103 405 -394 12114 10533 946 1199 10786 1801 8985 919 -512 8350 1623 6727 -251 -42 6434 6434 167 11138 9471 932 2180 10719 1511 9208 -15 7351 7351 6527 6527 -65 8920 8920 -19 9189 9189 1,69 1.51 1.49 0,29 0.29 1,51 1,5 2.09 2.07 2.15 2.12 1.67 4352 4405 12431 4317 4367 10656 4272 4324 8843 4259 4299 10355 4276 4314 13097 4287 4322 13162 2015-12 2016-12 2017-12 2018-12 2019-12 7309 12591 19900 3941 2902 2752 3900 33395 8555 13646 22201 3856 2675 2481 2797 34010 6006 14669 20675 3667 2655 2000 7548 36545 8926 7038 15964 3396 2766 1962 6546 30634 6480 4695 11175 3971 3379 1886 20411 22354 -9783 12571 15788 11289 12843 21256 -10621 10635 17249 10629 10499 16449 -8246 8203 21952 9401 7235 16245 -8013 8232 20274 10263 7007 2667 4139 52582 83216 18921 -8083 10838 19879 16764 10002 2412 6075 65970 86381 4207 56698 90093 4248 53260 87270 4560 51351 87896 COCA-COLA CO (KO) CashFlowFlag BALANCE SHEET Fiscal year ends in December. USD in millions except per share data. Assets Current assets Cash Cash and cash equivalents Short-term investments Total cash Receivables Inventories Prepaid expenses Other current assets Total current assets Non-current assets Property, plant and equipment Gross property, plant and equipment Accumulated Depreciation Net property, plant and equipment Equity and other investments Goodwill Intangible assets Deferred income taxes Other long-term assets Total non-current assets Total assets Liabilities and stockholders' equity Liabilities Current liabilities Short-term debt Accounts payable Deferred income taxes Taxes payable Accrued liabilities Other current liabilities Total current liabilities Non-current liabilities Long-term debt Deferred taxes liabilities Minority interest Other long-term liabilities Total non-current liabilities Total liabilities Stockholders' equity Common stock Additional paid in capital Retained earnings Treasury stock Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity 15806 2795 16503 2288 18191 2498 15247 3804 16025 2682 692 679 4887 1567 26532 5485 2069 26930 757 5259 2387 27194 693 5225 2616 29223 6045 1021 26973 28407 4691 210 4301 37609 64539 29684 3753 158 4081 37676 64208 31182 2522 1905 8021 43630 70824 25364 1933 2077 7638 37012 66235 27516 2284 2117 8510 40427 67400 1760 14016 65018 -45066 -10174 25554 90093 1760 14993 65502 -47988 -11205 23062 87270 1760 15864 60430 -50677 -10305 17072 87896 1760 16520 63234 -51719 -12814 16981 83216 1760 17154 65855 -52244 -13544 18981 86381

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Finance Transactions Policy And Regulation

Authors: Hal Scott, Anna Gelpern

21st Edition

1634602048, 978-1634602044

More Books

Students also viewed these Finance questions

Question

Understand employee mentoring

Answered: 1 week ago

Question

Appreciate the importance of new-employee orientation

Answered: 1 week ago