130 likes | 238 Views
Simple Analysis and Parsimonious Forecasting: An Illustration of Microsoft. Di (Wendy) Wang. Return on Enterprise Operations. EPAT. EPAT. Sales. RNEA=. =. Avg (NEA). Sales. Avg (NEA). =. EPM*EATO. Disaggregating Return on Net Enterprise Assets. Three Steps.
E N D
Simple Analysis and Parsimonious Forecasting: An Illustration of Microsoft Di (Wendy) Wang
Return on Enterprise Operations EPAT EPAT Sales RNEA= = Avg(NEA) Sales Avg(NEA) = EPM*EATO Disaggregating Return on Net Enterprise Assets
Parsimonious-Revenues We assume that the expected sales growth rate should be an average of the last three years 7.65% reduced to 6.16% due to expected increasing competition.
Parsimonious-EPM (from Sales) We assume that the expected EPM should be an average of the last two years 29.56% reduced to 27% due to expected increasing competition.
Parsimonious-EATO We assume that the expected EATO should be an average of the last two years 8.66 reduced slightly to 8.56 due to expected increasing competition.
Sources: • Microsoft Form10-K For the Fiscal Year Ended June 30, 2011 • http://apps.shareholder.com/sec/viewerContent.aspx?companyid=MSFT&docid=8062497 • Microsoft Form10-K For the Fiscal Year Ended June 30, 2012 • http://apps.shareholder.com/sec/viewerContent.aspx?companyid=MSFT&docid=8733512 • Microsoft Form10-K For the Fiscal Year Ended June 30, 2013 • http://apps.shareholder.com/sec/viewerContent.aspx?companyid=MSFT&docid=9422625