Question

In: Finance

Assignment: Finance and Operations: This week we look at finance and operations, and apply a bit...

Assignment: Finance and Operations: This week we look at finance and operations, and apply a bit of quantitative analysis to the effort. Your assignment this week is to analyze current financial ratios for a given business. APA formatting required.

1. Think of a specific business you find interesting, i.e. Apple, UTC, Southwest Airlines, etc.

2. Search the web for that business’ “Financial Statement”. (You will find many hits for the data.)

3. Select the “http://www.morningstar.com/” site offering your company’s financial statement.

4. You will now see a number of financial ratios for your company. Below is an example for Apple: http://financials.morningstar.com/ratios/r.html?t=AAPL

5. Now, define the following ratios, note the ratio for your business, and explain what the ratio means for the business moving forward:

a) Return on Assets

b) Return on Equity

c) Return on Capital

d) Gross Margin

e) SG&A Margin

f) Current Ratio

g) Quick Ratio

h) Total Debt/Equity

i) Total Revenue

j) Gross Profit Here are some additional sources as well. You can always do a quick search on Google using the appropriate keywords in your search. Apple (Return on Assets): https://ycharts.com/companies/AAPL/return_on_assets https://www.stock-analysis-on.net/NASDAQ/Company/Apple-Inc/Ratios/Profitability/Quarterly-Data#Ratios-Summary

Solutions

Expert Solution

Apple Inc
2017 2016 2015 2014 2013
Return on Assets 12.88% 14.20% 18.38% 17.04% 17.89%
Return on Equity 36.07% 35.62% 44.74% 35.42% 29.98%
Return on Capital 101.74% 114.24% 141.93% 108.84% 104.50%
Gross Margin 38.47% 39.08% 40.06% 38.59% 37.62%
SG&A Margin 17.31% 16.84% 15.30% 17.00% 16.84%
Current Ratio 1.28 1.35 1.11 1.08 1.68
Quick Ratio 1.09 1.22 0.89 0.82 1.4
Total Debt/Equity 0.86 0.68 0.54 0.32 0.14
Total Revenue 229234 215639 233715 182795 170910
Gross Profit 88186 84263 93626 70537 64304
Ratio Analysis
Ratio Description Analysis Remarks
1 Return on Assets A Profitability ratio calculated as net income divided by total assets ROA decreased from 2015 to 2016 and from 2016 to 2017
2 Return on Equity Net Income divided by Shareholders Equity ROE Decreased form 2015 to 2016 and slightly improved from 2016 to 2017
3 Retrun on Capital A measure of the periodic,after tax ,Cash on yield earned in the business ROC decreased from 2015 to 2016 and also decreased from 2016 to 2017
4 Gross Margin Percentage of revenue available to cover operating and other Expenditures Gross Margin decreased from 2015 to 2016 and also decreased from 2016 to 2017
5 SG&A Margin SG & A Expensesdivided by Gross Profit Increased form 2015 to 2016 and also form 2016 to 2017 SG & A Margin shall be lower than the Gross Margin
6 Current Ratio Current Assets divided by Current Liabilities Increased from 2015 to 2016 but slightly decreased from 2016 to 2017
7 Quick Ratio (Cash plus short term marketable securities plus receivables) divided by current liabilities Increased from 2015 to 2016 and slightly decreased from 2016 to 2017
8 Total Debt/Equity Total Debt divided by Equity Increased fro, 2015 to 2016 and also from 2016 to 2017
9 Total Revenue Total Sales revenue Decreased from 2015 to 2016 but increased from 2016 to 2017
10 Gross Profit Revenue minus Costs Decreased from 2015 to 2016 and aincreased from 2016 to 2017

Related Solutions

Assignment: Finance and Operations This week we look at finance and operations, and apply a bit...
Assignment: Finance and Operations This week we look at finance and operations, and apply a bit of quantitative analysis to the effort. Your assignment is to analyze current financial ratios for a given business. 1. i want amazon.com Inc 2. Search the web for that business’ “Financial Statement.” (You will find many hits for the data.) 3. Select the http://www.morningstar.com/ site offering your company’s financial statement. 4. You will now see a number of financial ratios for your company. Below...
Assignment: Finance and Operations This week we look at finance and operations, and apply a bit...
Assignment: Finance and Operations This week we look at finance and operations, and apply a bit of quantitative analysis to the effort. Your assignment is to analyze current financial ratios for a given business. 1. Think of a specific business you find interesting, i.e. Apple, UTC, Southwest Airlines, etc. 2. Search the web for that business’ “Financial Statement.” (You will find many hits for the data.) 3. Select the http://www.morningstar.com/ site offering your company’s financial statement. 4. You will now...
Assignment: Finance and Operations This week we look at finance and operations, and apply a bit...
Assignment: Finance and Operations This week we look at finance and operations, and apply a bit of quantitative analysis to the effort. Your assignment is to analyze current financial ratios for a given business. 1. Think of a specific business you find interesting, i.e. Apple, UTC, Southwest Airlines, etc. 2. Search the web for that business’ “Financial Statement.” (You will find many hits for the data.) 3. Select the http://www.morningstar.com/ site offering your company’s financial statement. 4. You will now...
Assignment: Finance and Operations: This week we look at finance and operations, and apply a bit...
Assignment: Finance and Operations: This week we look at finance and operations, and apply a bit of quantitative analysis to the effort. Your assignment this week is to analyze current financial ratios for a given business. APA FORMATTING REQUIRED. 1. Think of a specific business you find interesting, i.e. Apple, UTC, Southwest Airlines, etc. 2. Search the web for the business' "Financial Statement". (You will find many hits for the data.) 3. Select the "http://www.morningstar.com/" site offering your company's financial...
Java Programming Assignment 6-1 We have covered the “Methods” this week. Apply the concepts that we...
Java Programming Assignment 6-1 We have covered the “Methods” this week. Apply the concepts that we have learnt in class and come up with a “problem scenario” for which you can create a “solution”. Utilize any/all of the examples from the book and class that we discussed. You program should be interactive and you should give a detailed statement about what the “description of the program – purpose and how to use it”. You should also use a “good bye”...
The concept of an asymptote is presented this week. In studying this topic we look at...
The concept of an asymptote is presented this week. In studying this topic we look at limits and study as a function gets closer and closer to a value. We are not concerned about what happens at that value but as we get closer and closer. For example, it is not important for hospital personnel to be in the room while a patient is having a stroke. At that point, it is too late. By the time that the hospital...
This week we will look at the test for goodness of fit. In order to complete...
This week we will look at the test for goodness of fit. In order to complete this discussion board, you will need a small bag of plain m&m’s.   M&m’s have six colors, listed below. The Mars Candy Company has published the percentage of each color that we should see in any given bag of m&m’s. We are going to determine if our purchases m&m’s are significantly different from what we should expect. Our Null Hypothesis is that our percentages will...
This week we covered the details of Cellular Respiration. Your assignment this week is in two...
This week we covered the details of Cellular Respiration. Your assignment this week is in two parts. Using Excel (or some other Table creating program) create a table that describes the four sub-steps of cellular respiration. Insert the table into a Word document and provide a discussion of how each sub part contributes to overall process of cellular respiration.
This week we are going to look at aspects of mental illness, stigma and the manner...
This week we are going to look at aspects of mental illness, stigma and the manner in which society treats those who suffer from mental illness.Look at one or two of the resources posted in the assignment folder. Discuss your opinion as to how your chosen case was handled either by the court system, by mental health professionasl, or by the mental health system or society or schools.
This week we are going to look at how benchmarking is used in the current day...
This week we are going to look at how benchmarking is used in the current day health care industry! Please find a current events (within the past year) news article from a reputable news source (MSN, New York Times, Chicago Tribune, etc) that discusses the use of benchmarking by a health care organization. For your original post, please provide a 150+ word summary of your article. Be sure that you demonstrate your understanding of benchmarking by discussing how the benchmarking...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT