Obtain the copies of Annual Financial Reports for financial year ending on Dec. 31st of 2011, 2012 and 2013 for the three information technology (IT) firms listed on S&P 500 - Intel Corp. (deals in semiconductors), Google Inc. (deals in internet software and services) and Motorola Solutions Inc. (deals in telecommunication equipment) which although being in the same sector, deals in a completely different aspect of the information technology industry. They should be easily accessible online on the firm's website. Based on the data and information given in these reports, address the following issues aforementioned:
Download the monthly stock prices for the period stated above i.e. Jan. 2011 to Dec. 2013 and use them to estimate the monthly stock return and standard deviation of the return for these three firms for the same sample period for which you have downloaded their annual report. You can access the stock prices from either Google Finance or Yahoo Finance. Based on your monthly return data and financial and accounting variables used in Question 1 above, prepare a terse investment report to be presented to the CFO of an investment firm commenting upon the investment potential and expected risk exposure in these three multinational IT giants indicating which firm will provide a better investment opportunity in short term (6 months) to long term (3 years) for their investors.