Case Study Apple Inc

Two files are to be submitted for this assignment. Please see instructions below.
1. Memorandum as PDF
2. Excel File

Please see attached files as well.

Assignment Questions
1. Prepare common-size balance sheets and income statements for the years 2003 to 2018. What do these summary ratios convey about the company in the current year and over time?
2. What do you observe about the changes in Apple’s performance, liquidity, solvency, and capital structure over the years presented? Use whatever relations and ratios you feel are appropriate for this task. Do your observations fit with what you know about the company’s business model and strategy? What surprised you?
[Requirement A] Demonstrate understanding of calculations and interpretations of key fundamental financial ratios (profitability, liquidity, and solvency) and financial data along with the ability to accurately present the analysis based on your own findings. (60.0%)
1) Use three ratios from each category (profitability, liquidity, and solvency) to justify your analysis.
2) In addition, use the DuPont analysis of ROE and ROA.
3) Evaluate the company’s current financial performance, liquidity, solvency and capital structure – both for an individual period and across time.
· Unsatisfactory
A basic understanding of financial ratios and supporting financial data is not demonstrated. The approach to the decision-making process not presented. No conclusion is presented.
· Less than Satisfactory
A basic understanding of financial ratios and supporting financial data is not demonstrated. The approach to decision making is not presented, or it is illogical. Conclusions drawn are not valid or are not presented.
· Satisfactory
A basic understanding of financial ratios and supporting financial data is demonstrated. A logical approach to the decision is presented. A valid conclusion is made.
· Good
An understanding of financial ratios and supporting financial data is demonstrated. A logical approach to the decision is presented. A valid conclusion is made and well-supported by facts from the case.
· Excellent
A superior understanding of financial ratios and supporting financial data is demonstrated. A logical approach to the decision is presented. A valid conclusion is made and well-supported by facts from the case.
[Requirement B] Assessing and presenting the other sources of information given within the case to tap into the financial story. (20.0%)
· Unsatisfactory
A basic understanding of how to access and present additional financial data is not presented. The approach to the decision-making process is not presented. No conclusion is presented.
· Less than Satisfactory
A basic understanding of how to access and present additional financial data is not demonstrated. The approach to decision making is not presented, or it is illogical. Conclusions drawn are not valid or are not presented.
· Satisfactory
A basic understanding of how to access and present additional financial data is demonstrated. A logical approach to the decision is presented. A valid conclusion is made.
· Good
An understanding of how to access and present additional financial data is demonstrated. A logical approach to the decision is presented. A valid conclusion is made and well-supported by facts from the case.
· Excellent
A superior understanding of how to access and present additional financial data is demonstrated. A logical approach to the decision is presented. A valid conclusion is made and well-supported by facts from the case.
[Requirement C] Memorandum – Mechanics of Writing (includes spelling, punctuation, grammar, language use) (20.0%)
· Unsatisfactory
Surface errors are pervasive enough that they impede communication of meaning. Inappropriate word choice and/or sentence construction are employed.
· Less than Satisfactory
Frequent and repetitive mechanical errors distract the reader. Inconsistencies in language choice (register) and/or word choice are present.
· Satisfactory
Some mechanical errors or typos are present but are not overly distracting to the reader. Audience-appropriate language is employed.
· Good
Prose is largely free of mechanical errors, although a few may be present. The writers use a variety of sentence structures and effective figures of speech.
· Excellent
The writers are clearly in command of standard, written academic English.

Last Completed Projects