Question
1) You are given the following information from a well known corporation. Conduct an analysis of the data. This analysis should include year-over-year changes in
1) You are given the following information from a well known corporation. Conduct an analysis of the data. This analysis should include year-over-year changes in terms of percentage and absolute/net for:
- Revenues
- Operating Income
- Net Income
Calculate the following ratios for each year:
Net Profit Margin
Operating Profit Margin
Net Return on Total Assets (ROA)
Return on Stockholders Equity
Here's the data:
2017 2016 2015 2014 2013
Sales (Sales Revenue) 12917 11699 10108 9006 8032
Operating Income 883 743 548 438 284
Profit After Taxes 551 466 343 246 147
Total Assets 5538 5294 4292 3987 3783
Total Stockholders Equity 3878 3802 2991 2373 1628
Be sure include a summary on your assessment. What was the trend with Revenues? Operating Income? Net Income? Using the Appendix, did the ratios meet the criteria for good performance? Is the trend positive, negative, about the same?
You must show the work! Present your completed problem demonstrating the analysis in a table or chart format!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started