Financial-Statement-Analysis-and-Decision-Making-Activity-

I-need-an-Excel-Assignment-Excel-Charts
April 13, 2021
Social Justice Project
April 13, 2021

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.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.