O'Reilly logo

The Fundamentals of Financial Statement Analysis as Applied to the Coca-Cola Company by Carl McGowan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 1

Internet Data Collection

Course Outcomes

Find and collect data

oYahoo! Finance

oEDGAR

Process data

oExcel

oPowerPoint

oWord

Present (communicate) data

oWord

oPowerPoint

Financial Statement Analysis

Collect ticker symbol from Yahoo! Finance©

Collect stock prices from Yahoo! Finance©

Collect financial data from the EDGAR (SEC) Online Database

Download financial statements to spreadsheet(s)

Consolidate the input data into a single spreadsheet

Compute and graph financial ratios

Consolidated Statement of Income

Sales

Operating income

EBIT

Interest expense

Net income

Shares outstanding

Consolidated Balance Sheets

Accounts receivable

Inventory

Current assets

Net fixed assets

Accounts payable

Current ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required