Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a dashboard that allows you to evaluate how a company's ratios change between 2014 and 2015. The dashboard should show the ratios for 2014

image text in transcribed
image text in transcribed
Create a dashboard that allows you to evaluate how a company's ratios change between 2014 and 2015. The dashboard should show the ratios for 2014 and 2015, the percentage change from one year to the next, and the percentage change for the company's industry. Choose three different companies and discuss what you learn about the company based on these metrics. Apple Inc. Apple belongs to the technology industry. From 2014 to 2015, all ratios of Apple met the increase, contrast those of the whole industry. In overall technology industry, the ROE stabilized in 0.09, the asset turnover decreased from 0.69 to 0.64, the profit margin experienced a big increase, turning to a positive ratio, and the financial leverage raised from 1.89 to 2.11. By comparing the ratios of Apple and technology industry, no matter the number or the trend, it's easy to find Apple's leading position in whole industry and Apple would keep its advantages in the following period. Amazon.com Inc. Amazon.com Inc. belongs to the consumer services industry. From 2014 to 2015, all ratios of industry experienced an increase, and the increases of ROE and profit margins are more obvious. For Amazon, its ROE and profit margins raised to positive, its asset turnover stay stable at 1.58, and its financial leverage decreased slightly. Compared with the industry ROE and profit margins, ROE and profit margins of Amazon were far behind the industry median. Contrast with ROE and profit margins, the asset turnover and financial leverage of Amazon were far beyond the industry median. Though Amazon's profitability couldn't meet the industry median level in 2014 and 2015, its high asset turnover assured its stable operation. Also, Amazon adjusted its financial leverage to a lower level, showing Amazon's risk management. With the control of risk and asset turn over, Amazon has enough time to improve profitability in the future

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Driven Technology

Authors: Paige Baltzan

8th Edition

1259924920, 978-1259924927

More Books

Students also viewed these Economics questions

Question

Discuss the systematic or tree diagram.

Answered: 1 week ago

Question

Explain all drawbacks of the application procedure.

Answered: 1 week ago