W3P1 - Problem Scenario 1 - Financial Performance

PLEASE SHOW YOUR WORK!

Instructions:

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	10109	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!