Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Continuous Time Finance

Authors: Robert C. Merton

1st Edition

0631185089, 978-0631185086

More Books

Students also viewed these Finance questions