Financial-Statement-Analysis-and-Decision-Making-Activity-
Resources: U.S. Securities and Exchange Commission (SEC), websites such as Annual Reports (AnnualReports.com)
Tutorial help on Excel® and Word functions can be found on the Microsoft® Office website. There are also additional tutorials via the web offering support for Office products.
Research the the Coke and Pepsi companies on the Internet and download the Income Statement, Statement of Shareholders’ Equity, Balance Sheet, and Statement of Cash Flows.
Develop a minimum 200 word examination of the financial statements and include the following:
- Make a 5-year trend analysis for each company, using 2011 as the base year, of:
- Net sales.
- Net income. Discuss the significance of the trend results.
- Compute for 2015 and 2014 the:
- Debt to assets ratio.
- Times interest earned. How would you evaluate each company’s solvency?
Show your work in Microsoft® Word or Excel®. Complete calculations/computations using Microsoft® Word or Excel®. Include the four financial statements along with your assignment.Format your assignment consistent with APA guidelines.