MSFT has been removed from your Stock Email Alerts list.
Please enter Portfolio Name for new portfolio.
As of today, Microsoft Corp's current share price is $42.03. Microsoft Corp's E10 for the quarter that ended in Jun. 2015 was $2.36. Microsoft Corp's Shiller P/E Ratio for today is 17.81.
During the past 13 years, Microsoft Corp's highest Shiller P/E Ratio was 38.42. The lowest was 11.32. And the median was 18.27.
E10 is a concept invented by Prof. Robert Shiller, who uses E10 for his Shiller P/E calculation. E10 is the average of the inflation adjusted earnings of a company over the past 10 years.
Microsoft Corp's adjusted earnings per share data for the three months ended in Jun. 2015 was $-0.396. Since most companies do not have as long as 10 years history, here we use 6 years to calculate. Add all the adjusted EPS for the past 6 years together and divide 6 will get our E10, which is $2.36 for the trailing six years ended in Jun. 2015.
For the Shiller P/E, the earnings of the past 10 years are inflation-adjusted and averaged. The result is used for P/E calculation. Since it looks at the average over the last 10 years, the Shiller P/E is also called PE10.
The Shiller P/E was first used by professor Robert Shiller to measure the valuation of the overall market. The same calculation is applied here to individual companies.
Microsoft Corp's Shiller P/E Ratio for today is calculated as
|Shiller P/E Ratio||=||Share Price||/||E10|
* All numbers are in millions except for per share data and ratio. All numbers are in their own currency.
Microsoft Corp's E10 for the fiscal year that ended in Jun15 is calculated as:
For example, Microsoft Corp's adjusted earnings per share data for the three months ended in Jun. 2015 was:
|Adj_EPS||=||Earnigns per Share||/||CPI of Jun. 2015||*||CPI of Current|
Since most companies do not have as long as 10 years history, GuruFocus uses 6 years to do the calculation.
Current CPI = 238.662.
Microsoft Corp Quarterly Data
|per share eps||0.720||0.587||0.620||0.780||0.680||0.551||0.540||0.710||0.610||-0.396|
|per share eps||0.620||0.770||0.610||0.687||0.680||0.780||0.600||-0.059||0.530||0.760|
|per share eps||0.400||0.740||0.450||0.511|
Add all the adjusted EPS together and divide 6 will get our E10.
Compared with the regular P/E ratio, which works poorly for cyclical businesses, the Shiller P/E smoothed out the fluctuations of profit margins during business cycles. Therefore it is more accurate in reflecting the valuation of the company.
If a company has consistent business performance, the Shiller P/E should give similar results to regular P/E.
Compared with the P/S ratio, the Shiller P/E makes the comparison between different industries more meaningful.
The Shiller P/E assumes that over the long term, businesses and profitability revert to their means. If a companys business model does not work in the future compared with the past, the Shiller P/E and P/S ratio will give false valuations.
Microsoft Corp Annual Data
Microsoft Corp Quarterly Data