Coca-Cola Accounting SEC 10-K Report & Presentation Case Study

User Generated

gurzef2h

Writing

Description

PowerPoint Requirements

  1. Prepare a brief PowerPoint file of no more than 10 slides (do not exceed) for the SEC-10K Report.
  2. Make sure you include a reference list in APA format.

Report SEC 10-K Requirements

Part I.

You will be asked to select a company that is publicly traded. You must research and secure the SEC 10-K Annual Report for the most recent year. This is often available at the company web site. Or the website for the Securities and Exchange Commission (SEC). Look for "Investor Information" or "Company Information". Save the file to your computer for easy access in future. There is no need to print as the report is usually 100 pages or more.

Write a paper, single spaced, one- inch margins, 12- point font, with double space between paragraphs.

Your paper should comment on the financial statements for your company as they relate to the information presented in this course. A prescribed format for presenting this paper with additional requirements is available at the end of this document. You MUST adhere to the format provided below; otherwise you will lose points

Take care to avoid academic dishonesty. Write your paper, read it, and edit. Use your own words.

If you choose to include tables from outside sources, portions of the financial statements, etc., they must be in the Appendix and not in the main body of the paper. If you create your own table, you can include them in the body of the paper.

You will also be required to include links to the Income Statement, Balance Sheet and Cash Flow Statement as an attachment to your report.

APA style is required for overall format and for citations unless superseded by other requirements noted in the instructions here.

Ask questions if any of the requirements are unclear

Additional guidance for your paper and resources:

Please include a title page (include your name on the title page)

Include in text citations (business classes use APA format)

Your paper should use one-inch margins on the left, right, top, and bottom of each page, and font set at 12 points.

Take care to comply with the UMUC policy for academic honesty

Write your paper, in your own words, using accounting words from our textbook and explaining how these relate to the financial statements of your company

Your discussion postings related to your company during the semester should assist you in completing this paper

Visit the Accounting Toolbox in the Course Content of our Leo Classroom

The Accounting Toolbox is a constant resource in our UMUC undergraduate accounting courses

Links and explanations to assist you with this paper may appear in this resource

Please make sure you review carefully and ask questions if you have any.

SEE BELOW FOR FORMAT AND ADDITIONAL PROJECT REQUIREMENTS

Draft

SEC Report: 100 points

Name of your Company

Your name:

Course Title and Number

Professor’s Name

THE ABOVE INFORMATION SHOULD BE IN YOUR TITLE PAGE

PAGE 2: This page is the start of the main body of your paper. Your paper must have the section headings in bold and follow the same numbering sequence as below.

  1. Introduction and Company Background Information (minimum ½ page) 5 points.
  1. Discussion on Income Statement (minimum ½ page) 12 points
  2. Discussion on Balance Sheet (minimum ½ page) 12 points

IV. Discussion on Statement of Cash Flows (minimum ½ page) 12 points

V. Ratio Analysis (need a minimum of 4 ratios) 16 points. Computational support must be shown. Alternatively, if you found the ratios on a website, you can use it with the condition that you must cite your source here in this section as well as at the end of the paper along with other citations.

(1) Current Ratio: 1.1

Comments: You must briefly interpret the results in 1-2 sentences.

(2) Accounts Receivable Turnover 2.5

Comments: You must briefly interpret the results in 1-2 sentences

Note: The above ratios were provided for illustrative purposes only. You decide which ratios you wish to use. You must follow the format provided in the sample Costco report to avoid loss of points.

VI. Horizontal Analysis (need a minimum of 4 items-2 from Balance Sheet and 2 from Income Statement) 16 points

Account 2016 2015 Difference $ Difference %

  1. Cash $1,050,000 1,000000 $50,000 5%
  2. Accounts Receivable etc.

Comments: You can briefly interpret the results of each item or comment on all 4 items together. If you choose to comment on each item, your comments must immediately follow each item.

Note: The above accounts were provided for illustrative purposes only. You decide which accounts to analyze. You must follow the format provided in the sample Costco report to avoid loss of points.

VII. Vertical Analysis (need a minimum of 4 items-2 from Balance Sheet and 2 from Income Statement) 16 points

Note: The base accounts Sales or Total Assets or Total Liabilities & Stockholders' Equity does not count as one of the two items although you need to include the base account used.

Eg. Income Statement

Base: Revenues $5,000,000

CGS $1,000,000/$5,000,000 =20%

Net Income: $2,000,000/$5,000,000=40%

Balance Sheet

Total Assets Base: 10,000,000.

1. Cash 1,000,000/10,000,000 = 10%.

2. Inventory: 2,000,000/10,000,000=20%.

Comments: You can briefly interpret the results of each item or comment on all 4 items together. If you choose to comment on each item, your comments must immediately follow each item.

Note: You must follow the format provided in the sample Costco report to avoid loss of points.

VIII. Conclusion (minimum ½ page) 5 points

IX. References: Minimum of three. 6 points

APA Format

Consult the library website for additional assistance

PS I have attached a sample report on Costco in the Discussion Board and will also email it to all with these instructions for you to get an idea of what the final product should look like.

Part 2. SEC 10-K Power Point Presentation

1. You will also be required to prepare a power point file of 11 slides. The first slide will be the title slide. Each slide excluding the title slide is worth 10 points.

2. Your PPT presentation must represent a cross section of your SEC Report (Word document). Post the power point presentation in the discussion area (Week 6) for peer review by other students. This submission for peer review and commenting on at least one other student's work will be the basis for your Week 6 Participation grade and it is required that you complete this assignment.

3. After you read the comments you may wish to make changes to your power point file before submitting it in the assignment folder in Week 7.

4. Do not include citations as you will be providing me with them in your SEC report. If you choose to do so, it must be in Slide 12 which is an additional slide you will need to create. However, you will not get any extra points for creating Slide 12. If you mistakenly include citations in Slide 11, you will lose all points associated with that slide which is 10 points.

5. The points noted above are for the PPT submission through Assignment link in Week 7. The basis for points are different when submitting them for peer review in the Discussion Board for Week 6. In Week 6, 25% of the Week 6 Discussion grade is allocated to your reviewing at least one other classmate’s unreviewed work; the balance 75% is allocated to your PPT presentation posted in Week 6 Discussion

6. Ask questions if any of the requirements are unclear.

7. You are required to post comments on the work of at least one other student who does not yet have comments so everyone has at least one set of comments. Do not wait until the last day to post your power point file so everyone has a chance to review the file.

8. Do not cut and paste from your SEC (Word) report.

9. Use visual cues such as color, graphics, bullets, etc. to enhance your presentation.

9. The amount of information contained in each slide should be roughly the same.

10. Do not cut and paste or integrate entire sections of the financial statements in to your presentation. If you do so, you will lose points associated with that slide.

11.Only 1 slide should contain background information about the company. This presentation is for an Accounting course. So, the emphasis of your presentation should be numerical. Present numerical information and explain what the numbers mean. Do not present numbers only.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Sec 10k Final Report: Coca-Cola Company
Name:
Course Title and Number:
Professor’s Name

Introduction
source: Coca-Cola History │ World of Coca-Cola.



The Coca-Cola company was started in 1886, headquarters
is situated in Atlanta, Georgia



It is the world’s biggest beverage company.



The company trades in new York stock exchange (NYSE) in
New York



The firm distributes more than 500 nonalcoholic beverage
brands.



However, it has an array of brands the main sources of
revenue is: Coca-Cola, diet coke, Fanta, and sprite.

Income Statement
sources: Coca-Cola Product Descriptions

Revenue

12/31/2018

12/31/2017

12/31/2016

12/31/2015

Total Revenue

31,856,000

35,410,000

41,863,000

44,294,000

Gross Profit

20,086,000

22,154,000

25,398,000

26,812,000

Total Operating
Expenses

22,048,000

25,800,000

32,001,000

34,054,000

Total Other
Income/Expenses
Net

-1,458,000

-2,868,000

-1,726,000

-635,000

Net Income From
Continuing Ops

6,727,000

1,182,000

6,550,000

7,366,000

Net Income

6,434,000

1,248,000

6,527,000

7,351,000

Net Income
Applicable To
Common Shares

6,434,000

1,248,000

6,527,000

7,351,000

Balance sheet
sources: O'Brien, S.

Period Ending

12/31/2018

12/31/2017

12/31/2016

12/31/2015

Total Current Assets

30,634,000

36,545,000

34,010,000

33,395,000

Long Term
Investments

20,274,000

23,281,000

18,569,000

16,868,000

Total Assets

83,216,000

87,896,000

87,270,000

89,996,000

Total Current
Liabilities

29,223,000

27,194,000

26,532,000

26,929,000

Long Term Debt

25,364,000

31,221,000

29,732,000

28,543,000

Other Liabilities

9,571,000

10,504,000

7,786,000

8,760,000

Total Liabilities

64,158,000

68,919,000

64,050,000

64,232,000

Total Stockholder
Equity

16,981,000

17,072,000

23,062,000

25,554,000

-289,000

436,000

1,934,000

1,422,000

Net Tangible Assets

Statement of Cash Flows
source: Coca-Cola Company
COCA-COLA CO (KO) Statement of CASH FLOW
Fiscal year ends in December. USD in millions except per
share data.
Net income

2013-12

2014-12

2015-12

2016-12

2017-12

TTM

8626

7124

7366

6550

1182

3117

Net cash provided by operating activities

10542

10615

10528

8796

7106

6934

Net cash used for investing activities

-4214

-7506

-6186

-999

-2450

1388

Net cash provided by (used for) financing activities

-3745

-3631

-5113

-6545

-7447

-11332

Effect of exchange rate changes

-611

-934

-878

-6

242

-317

Net change in cash

1972

-1456

-1649

1246

-2549

-3327

Operating cash flow

10542

10615

10528

8796

7106

6934

Capital expenditure

-2550

-2406

-2553

-2262

-1675

-1398

7992

8209

7975

6534

5431

5536

Free cash flow

Ratio Analysis


Current Ratios increased from 2014 to 2018 which indicates that the
firm’s current ratio is improving.



1.24 (33,395/ 26,930=1.24) in 2015, and 1.02 (32,986/ 32,374=1.02)
in 2014



In 2014 to 2015, Accounts receivable turnover improved from The
company was able to collect money faster from its average accounts
receivable in 2015 compared to 2



= (3,941+ 4,466)/2=4203.6. 014.

Statement of Cash Flows continuation


the business was more able to use its assets to produce sales in 2014
compared to 2015 for the Asset turnover was higher



=44,294 / (90,093+ 92,023/2) = 44294/91058= .49.



2014, = 45,998/ (92,023+ 90,055/2) = 45,998/91039= .51.



The industry Coca- Coca’s ROE is satisfactory hence it attracted allot of
investors.



Resulting from the increase Earnings per Share (EPS) the firm sold more stocks
at expensive rate.

Vertical Analysis for Coca Cola Co.


Coca cola Co total liabilities are at $27, 792 and $66, 960
stockholders stock compared.



Coca cola Co. has long term debts that add up to $29,213
compared to short-term debts that add up to $4,071.



Coca cola, its biggest profit comes from selling soda,
followed by juice, vitamin-water falls third, this makes it
less tax-burdened

Horizontal Analysis for Coca Cola Co.



Net revenue for coca cola co for 2015, 2014 and 2013 are (millions) $44,294,
$45,998 and 46,852 respectively, the company revenue has dropped by 3.7%
from the year 2014 the base year for analysis is 2014.



In the previous year fiscal year, the company made a loss of 1.8% in 2014,
with 2013 base year for analysis.



Coca cola co operating income for 2015, 2014 and 2013 is $8,728, $9,709 and
$10,228 in the order.



The company operating income growth has reduced by 10% in 2015 and 5%
decrease in 2014.



Coca cola total assets for 2015 and 2014...

Similar Content

Related Tags