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 ...
Get The Fundamentals of Financial Statement Analysis as Applied to the Coca-Cola Company now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
