Solved by verified expert:Please read the instructions carefully, I attached apple and Samsung report below. I also include a sample of how my excel template should be. Also for the word, please include the heading topic for each bullet listed below. ThanksThe activity requires students to perform research and analysis on competing companies and the potential implications of international standards. This real-world analysis is key to understanding how a company’s profitability, liquidity, and solvency can be useful for all users. Students also learn to analyze financial statements and use managerial tools to make decisions from an investor’s and creditor’s standpoint. Assignment Steps Resources: Apple, Inc. and Samsung, Inc. Annual Reports provided (see links at right).Review the two companies Annual Reports. Prepare an analysis in Excel that consists of the following:Compute for 2016 and 2015 the: Profit margin.Asset turnover.Return on assets.Return on common stockholders’ equity.Earnings per share.Write a detailed analysis in Word that consisting of the followingEvaluate the financial state of each company. How do they compare?How would you evaluate each company’s profitability?Research and discuss global implications for the companies selected. How might changing global factors affect these businesses and their financials? (Stephanie)Companies such as Apple and Samsung often encounter ethical problems that affect their business. Apple, Inc. has been in the news in recent years regarding it’s treatment of overseas workers. Samsung has been in the news in recent years over it’s exploding phone batteries. Discuss these ethical situations and what impact they may or may not have on the financial statements. What should companies do to protect themselves and their financial position in these situations?Your paper should include at least 3 credible references Format the written portion of your assignment consistent with APA guidelines.sample of what my excel information should include below:(4) Return on common stockholders’ equity. 20162015 20162015 Common Stockholders’ equity, beginning yearValueValue ValueValue Common Stockholders’ equity, ending yearValueValue ValueValue Average Stockholders’ equity#VALUE!#VALUE! #VALUE!#VALUE! 20162015 20162015 Net income – Pfd. DividendsValueValue ValueValue Average Stockholders’ equity#VALUE!#VALUE! #VALUE!#VALUE! Return on common stockholders’ equity#VALUE!#VALUE! #VALUE!#VALUE! (5) Earnings per share. 20162015 20162015 Common shares outstanding, beginning yearValueValue ValueValue Common shares outstanding, ending yearValueValue ValueValue Weighted-Average common shares outstanding#VALUE!#VALUE! #VALUE!#VALUE! 20162015 20162015 Net income – Pfd. DividendsValueValue ValueValue Weighted-Average common shares outstanding#VALUE!#VALUE! #VALUE!#VALUE! Earnings per share #VALUE!#VALUE! #VALUE!#VALUE! Words: 128
You will get a plagiarism-free paper and you can get an originality report upon request.
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more