Microsoft Corporation Financial Analysis
Microsoft Corporation
Income Statement
The Year Ended June 29, 2020
| Information | The amount in Millions (in dollars) |
| Total Revenue | 143,015 |
| Lower Revenue Costs | (46,078) |
| Gross Profit | 96,937 |
| Less: Operating Expenses | (43,978) |
| The total operating income | 52,959 |
| Inflation Income | 2,668 |
| Recalibrated Depreciation | 12,796 |
| EBIDT | 68,423 |
| Weaker Depreciation | (12796) |
| EBIT | 55,627 |
| Less: Interest expense | (2,591) |
| Pretax income | 53,036 |
| Preparation of an Annual Tax | (8,755) |
| Common Stockholders Have Access To Net Income | 44,281 |
Data Source: (Yahoo Finance – 2020).
Microsoft Corporation
Bilanz
June 29, 2020
| Information | The amount in Millions ($). |
| The net tangible assets | 67,915 |
| Other Assets (Net). | 233,398 |
| Total Assets | 301,311 |
| Liabilities and Equities | |
| Obligation to Capital Lease | 7,671 |
| Total Debt | 70,998 |
| Additional Liabilities | 104,338 |
| Total Liabilities | 183,007 |
| Common Stock Equity | 118,304 |
| Equity and Total Liabilities | 301,311 |
Data Source: (Yahoo Finance – 2020).
Retrieve the data on the company’s historical data Add to cart the annual rate of return Use the adjusted closing prices for the Past 20 years
The rate of return is the Net loss or gain over a time period for an investment.
Rate of Return = (Adjusted Closing Prices – Opening Prices) ÷ Adjusted Closing Prices × 100 (Kenton, 2020)
| Jahr | Adj. Closing bal. | Opening Bal. | Annual Return Rate |
| 2020 | 215.81 | 160.62 | (215.81- 160.62) ÷ 215.81= 25.57% |
| 2019 | 157.7 | 101.12 | (157.7- 101.12) ÷ 157.7= 35.88% |
| 2018 | 101.57 | 85.95 | (101.57-85.95) ÷101.57= 15.38% |
| 2017 | 85.54 | 62.58 | (85.54-62.58) ÷85.54= 26.84% |
| 2016 | 62.14 | 54.8 | (62.14-54.8) ÷62.14= 11.81% |
| 2015 | 55.48 | 46.76 | (55.48-46.76) ÷55.48= 15.72% |
| 2014 | 46.45 | 37.16 | (46.45-37.16) ÷46.45= 20% |
| 2013 | 37.41 | 27.62 | (37.41-27.62) ÷37.41= 26.17% |
| 2012 | 26.71 | 26.77 | (26.71-26.77) ÷26.71= -15.20% |
| 2011 | 25.96 | 27.98 | (25.96-27.98) ÷25.96= -7.78% |
| 2010 | 27.91 | 30.95 | (27.91-30.95) ÷27.91= -10.89% |
| 2009 | 30.48 | 20.33 | (30.48-20.33) ÷30.48= 33.30% |
| 2008 | 19.44 | 35.22 | (19.44-35.22) ÷19.44= -81.17% |
| 2007 | 35.6 | 29.86 | (35.6-29.86) ÷35.6=16.12% |
| 2006 | 29.86 | 26.84 | (29.86-26.84) ÷29.86= 10.11% |
| 2005 | 26.15 | 26.74 | (26.15-26.74) ÷26.15= -2.26% |
| 2004 | 26.72 | 27.45 | (26.72-27.45) ÷26.72= -2.73% |
| 2003 | 27.37 | 26.86 | (27.37-26.86) ÷27.37=1.86% |
| 2002 | 25.85 | 33.52 | (25.85-33.52) ÷25.85= -26.59% |
| 2001 | 33.13 | 21.69 | (33.13-21.69) ÷33.13= 34.53% |
The positive rate of return refers to an increase in the value. A decline indicates that it has decreased. Rate The decline in stock value (Chen 2020). The company’s stock lost its value in the Year 2002, 2004, 2005 and 2008; year 2010, 2011, 2011; year 2012. In all other years, the company saw an increase in its value at a positive annual rate.
Using the data on the company’s stock rate of return And the index’s rate of return, estimate beta of the corporation. Compare the Value to that given by the source.
Beta = (Expected Return From the stock – Risk-free return) ÷ (Expected Market Return – Risk-free Return)
Beta = (0.2557 – 0.0275) ÷ (0.2683 – 0.0275) = 0.95
Microsoft has a beta of 0.92 according to Yahoo Finance 2020. It has a beta of less than one. Microsoft’s security is less volatile than the Market (Kenton, 2020).
The annual interest rate on US treasuries is the risk-free rate. Based on these values, estimate the expected annual rate of return of the corporation’s security. Comparing your estimated return with Part b of your data, you can see how it compares to your actual estimate.
Expected return = Risk-free rate + (Beta × Market Risk premium)
Or Expected Return SUM =Return i × Probability). This formula is based on historical data. It cannot be guaranteed to be accurate. Future (Chen, 2020).
These are the probabilities and expected returns. However, they cannot be known. As These are the outcomes, the expected return.
Expected return = 0.0078 + (0.92 × (0.2557 – 0.0078)) = 0.2359 = 23.59%
This is the Value of 2020 Part B: 25.57%. Both Positivity and Negativity have a Positive Effect Above 20%. Therefore, it’s safe to make investments in this industry. Microsoft Corporation.
| Jahr | Expected ROR(b). | ER = Risk-free rate + (Beta × Market Risk premium) |
| 2020 | 0.2557 | 0.0078 + (0.92 ×(0.2557 – 0.0078)) = 0.2359 |
| 2019 | 0.3588 | 0.0078 + (0.92 × (0.3588– 0.0078))=0.3307 |
| 2018 | 0.1538 | 0.0078 + (0.92 × (0.1538– 0.0078))=0.1421 |
| 2017 | 0.2684 | 0.0078 + (0.92 × (0.2684– 0.0078))=0.2475 |
| 2016 | 0.1181 | 0.0078 + (0.92 × (0.1181– 0.0078))=0.1093 |
| 2015 | 0.1572 | 0.0078 + (0.92 × (0.1572– 0.0078))=0.1452 |
| 2014 | 0.2 | 0.0078 + (0.92 × (0.2– 0.0078))=0.1846 |
| 2013 | 0.2617 | 0.0078 + (0.92 × (0.2617– 0.0078))=0.2414 |
| 2012 | -0.1520 | 0.0078 + (0.92 × (-0.1520– 0.0078))=-0.1392 |
| 2011 | -0.0778 | 0.0078 + (0.92 × (-0.0778– 0.0078))=-0.0710 |
| 2010 | -0.1089 | 0.0078 + (0.92 × (-0.1089– 0.0078))=-0.0996 |
| 2009 | 0.333 | 0.0078 + (0.92 × (0.333– 0.0078))= 0.3070 |
| 2008 | -0.8117 | 0.0078 + (0.92 × (-0.8117– 0.0078))=-0.7461 |
| 2007 | 0.1612 | 0.0078 + (0.92 × (0.1612– 0.0078))= 0.1489 |
| 2006 | 0.1011 | 0.0078 + (0.92 × (0.1011– 0.0078))= 0.0936 |
| 2005 | -0.0226 | 0.0078 + (0.92 × (-0.0226– 0.0078))= -0.0202 |
| 2004 | -0.0273 | 0.0078 + (0.92 × (-0.0273– 0.0078))= -0.0245 |
| 2003 | 0.0186 | 0.0078 + (0.92 × (0.0186– 0.0078))= 0.0177 |
| 2002 | -0.2659 | 0.0078 + (0.92 × (-0.2659– 0.0078))= -0.2440 |
| 2001 | 0.3453 | 0.0078 + (0.92 × (0.3453– 0.0078))=0.3183 |