Question
Some discussion is required for my financial analysis of Microsoft (MSFT) for financial statements reported June 30, 2020. Ratio Discussion Include your ratio discussion and
Some discussion is required for my financial analysis of Microsoft (MSFT) for financial statements reported June 30, 2020. Ratio Discussion Include your ratio discussion and a table of the results within the body of the Word document. All ratios must be calculated within Excel. After calculating the ratios, briefly explain whether the company is performing better, similar to, or worse in comparison to the prior year (FOR EACH RATIO). Do not just state that they are doing better, because it is higher, you must explain why. The goal is to demonstrate that you know what the ratio means not just state what happened to the numbers, which changed the ratio. If a ratio is not applicable, explain why.
Item/Year | 2020
| 2019 | 2018 |
Current Assets | 181,915,000 | 175,552,000 | 169,662,000 |
Current Liabilities | 72,310,000 | 69,420,000 | 58,488,000 |
Inventories | 1,895,000 | 2,063,000 | 2,662,000 |
Cash | 136,527,000 | 133,819,000 | 133,768,000 |
Receivables | 32,011,000 | 29,524,000 | 26,481,000 |
Total Assets | 301,311,000 | 286,556,000 | 258,848,000 |
Total Liabilities | 183,007,000 | 184,226,000 | 176,130,000 |
Total Equity | 118,304,000 | 102,330,000 | 82,718,000 |
Sales | 143,015,000 | 125,843,000 | 110,360,000 |
Cost of Goods Sold | 46,078,000 | 42,910,000 | 38,353,000 |
EBIT | 52,959,000 | 42,959,000 | 35,058,000 |
Interest |
| 2,686,000 | 2,733,000 |
Net Income | 44,281,000 | 39,240,000 | 16,571,000 |
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