Financial Statement Analysis and Decision Making Activity

profilecxa0cpq

Assignment Steps 

Resources: U.S. Securities and Exchange Commission (SEC)

Tutorial help on Excel® can be found on the Microsoft® Office website. There are also additional tutorials via the web offering support for Office products. 

Select two competing companies, Dr. Pepper and Coca-Cola both must be American and publicly traded and locate annual reports for these two companies on the company's website. DO NOT use summary sites-go directly to your company site.  

Research the two companies and download the Income Statement, Statement of Shareholders' Equity, Balance Sheet, and Statement of Cash Flows. 

Develop a maximum 200-word examination of the financial statements and include the following:

IN AN EXCEL SPREADSHEET:

 Compute for the two most recent years the:  

o Profit margin 

o Asset turnover 

o Return on assets 

o How would you evaluate each company's profitability?  

  • 8 years ago
  • 15
Answer(1)

Purchase the answer to view it

blurred-text
  • attachment
    COCA-COLARatioAnalysis.xlsx
  • attachment
    FinancialRatioAnalysis.docx
  • attachment
    DR.PEPPERRatioAnalysis.xlsx