Busi570 ade week 2 dropbox 2 end-point analysis data case – coca-cola


Coca-Cola Analysis

Below you will find financial data for Coca-Cola for the years 2006 and 2016. This data includes the following:

1. Raw numbers for the balance sheet and income statements

2. Common-size balance sheets (all entries expressed as a percent of Total Assets)

3. Common-size income statement (all entries expressed as a percent of Total Sales)

4. Ratios—including liquidity, profitability, leverage, asset management, and market ratios

5. DuPont equations 

6. Working Capital

7. Cash Conversion Cycle

Your assignment is to analyze this data. Your analysis should include the following:

1. An ‘eye-ball’ assessment of the changes in Coke’s financial statements between 2006and 2016—e.g., overall growth in assets, revenues, equity, debt, etc.

2. Analysis of the Common-size statements—i.e., what changed and why. That is, describe the changes in these statements and analyze the cause of the changes. Include: a) mix of assets, b) split between current assets and fixed assets, c) mix of debt, d) split between current liabilities and LT liabilities, capital structure (i.e., debt and equity), e) profitability at all levels, f) changes in expenses, etc. This section must include evidence of research indicating what events had substantive effects on Coke’s financial profile during the 10 year period. In other words, profitability may have increased due to introduction of new product lines, leverage may have increased due to the issuance of bonds, and assets may have increased due to acquisitions. These are offered as examples, and your research should indicate what occurred and how it affected Coke from a financial perspective.

3. Analysis of the ratios by category—include in this an explanation of the cause of the change—e.g., liquidity increased due to the increase in CAs and decrease in CLs. In addition to discussing each of the individual ratios, this section must include an overall conclusion regarding the direction of the four major categories of ratios. In other words, you must draw conclusions regarding the overall trends in 1) liquidity, 2) efficiency, profitability, and 4) leverage over the 10 year period. You must also provide industry averages where available so that you can compare Coke’s ratios to those of its industry competitors.

4. Analysis of the DuPont equation and discussion of the underlying reasons for the changes in ROI (ROA) and ROE.

5. Analysis of working capital and discussion of the implication of a positive or negative WC level. Is Coke’s WC policy conservative, moderate, aggressive? Why?

6. Analysis of the Cash Conversion Cycle and discussion of its implications.

7. Summary and conclusion concerning the major changes in Coke’s financial situation.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 20% with the discount code RESEARCH