Question

In: Finance

Obtain monthly close prices of Microsoft (symbol: MSFT) adjusted for stock splits and dividends during December...

Obtain monthly close prices of Microsoft (symbol: MSFT) adjusted for stock splits and dividends during December 1989 – December 2019 from Yahoo Finance (finance.yahoo.com). Using Excel, compute monthly returns during January 1990 – December 2019. From these returns, compute arithmetic and geometric return averages over the entire period. Report your answers and confirm that arithmetic average is greater than geometric average.

Guideline:

1. Yahoo Finance allows you to download the data in a spreadsheet.

2. At Yahoo Finance, go to Historical Prices and use Adj. Close to compute returns.

3. When you download monthly data from Yahoo Finance, you will see first days of each month appearing under the "Date" variable. The Adj. Close on the same row is the adj. close at the end of that month. For example, the adj. close price for Microsoft that appears in the row where the Data is 2019-12-01 is the adj. close price for December 2019

Solutions

Expert Solution

Return in each month = (current month price - previous month price) / previous month price

Arithmetic average is calculated using AVERAGE function in Excel

Geometric average is calculated by adding 1 to each month's return, calculating the average of that series using GEOMEAN function in Excel, and subtracting 1 to get the geometric average return for the period.

Arithmetic average is 2.0684%

Geometric average is 1.6822%


Related Solutions

Obtain monthly adjusted close prices of S&P500 Index (symbol: ^GSPC) and Microsoft (symbol: MSFT) during December...
Obtain monthly adjusted close prices of S&P500 Index (symbol: ^GSPC) and Microsoft (symbol: MSFT) during December 2006 – December 2019 from Yahoo Finance. Then, using Excel, compute monthly returns during January 2007 – December 2019. From these returns, compute and report beta of Microsoft using the formula we learned in class. Suppose today’s Treasury bill rate is 2% per annum. Historically, market risk premium is estimated to be 8% per annum. What is today’s expected return per annum of Microsoft,...
Obtain monthly adjusted close prices of Microsoft (symbol: MSFT) and Exxon Mobil Corporation (symbol: XOM) during...
Obtain monthly adjusted close prices of Microsoft (symbol: MSFT) and Exxon Mobil Corporation (symbol: XOM) during December 1989 – December 2019 from Yahoo Finance. Using Excel, compute monthly returns of each company during January 1990 – December 2019. Also, compute and report the arithmetic average and the standard deviation of each company’s returns. Compute and report the correlation coefficient between these two stock returns. Next, form a portfolio that combines Microsoft and Exxon Mobil Corporation with equal weight. Compute monthly...
The annual data on stock prices and dividends for Microsoft Corporation(MSFT) is as follows: Year Price...
The annual data on stock prices and dividends for Microsoft Corporation(MSFT) is as follows: Year Price (Beginning of the Year) Price (End of the Year) Dividends (End of the Year ) 2005 26.28 28.15 0.29 2006 28.15 30.86 0.33 2007 30.86 32.60 0.37 2008 32.60 17.10 0.41 2009 17.10 28.18 0.46 2010 28.18 27.73 0.55 2011 27.73 29.53 0.68 2012 29.53 27.45 0.83 2013 27.45 37.84 0.97 2014 37.84 46.45 1.15 What will be the IRR if the stock is...
The following table contains closing monthly stock prices for Oracle Corporation (ORCL), Microsoft Corporation (MSFT), and...
The following table contains closing monthly stock prices for Oracle Corporation (ORCL), Microsoft Corporation (MSFT), and NVidia (NVDA) for the first half of 2017. Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 ORCL 50.14 45.39 44.96 44.61 42.59 40.11 MSFT 68.93 69.84 68.46 65.86 63.98 64.65 NVDA 144.56 144.35 104.3 108.93 101.48 109.18 Create a formula to calculate the monthly rate of return during the first semester of 2017 and for each company. Format the results as percentages with two decimal...
1.    The following table contains closing monthly stock prices for Oracle Corporation (ORCL), Microsoft Corporation (MSFT), and...
1.    The following table contains closing monthly stock prices for Oracle Corporation (ORCL), Microsoft Corporation (MSFT), and NVidia (NVDA) for the first half of 2017. Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 ORCL 50.14 45.39 44.96 44.61 42.59 40.11 MSFT 68.93 69.84 68.46 65.86 63.98 64.65 NVDA 144.56 144.35 104.3 108.93 101.48 109.18 a)    Enter the data, as shown, into a worksheet and format the table as shown. b)   Create a formula to calculate the monthly rate of return during the first semester...
What are stock dividends and stock splits? What are the advantages and disadvantages of stock dividends...
What are stock dividends and stock splits? What are the advantages and disadvantages of stock dividends and splits? When should a stock dividend as opposed to a stock split be used?
Find below monthly levels of the S&P 500 Index and monthly Microsoft stock prices for the...
Find below monthly levels of the S&P 500 Index and monthly Microsoft stock prices for the last five years. Any dividends paid are acoounted for in the closing monthly indices and prices. Follow the instructions below to make estimations and to answer all questions. Date Adj Close S&P 500 Index Adj Close MSFT Stock Price Monthly Return S&P 500 Monthly Return MSFT 4/1/13 1597.57 29.09 5/1/13 1630.74 30.67 6/1/13 1606.28 30.56 7/1/13 1685.73 28.17 8/1/13 1632.97 29.56 9/1/13 1681.55 29.66...
Below table2 shows monthly closing share prices (adjusted to include dividends) of 5 companies, and the...
Below table2 shows monthly closing share prices (adjusted to include dividends) of 5 companies, and the adjusted closing prices for the ASX200 index. Table 1 is the dividends per share of the 5 companies in the past 5 years. Calculate the average annual growth in dividends over the last five years. Use this information, along with Gordon’s Growth Model to estimate the implied expected return for each REIT at the current market price(use past 12 months as an example). Show...
Discuss Apple's (AAPL) and Microsoft (MSFT) beta and relate to the volatility of the stock and...
Discuss Apple's (AAPL) and Microsoft (MSFT) beta and relate to the volatility of the stock and its returns over a six month period.
Corporations can execute stock transactions other than cash dividends, such as stock dividends and stock splits....
Corporations can execute stock transactions other than cash dividends, such as stock dividends and stock splits. First, briefly explain these two transactions in your own words. Second, offer an explanation as to why a corporation would want to issue a stock dividend or stock split? Third, search the internet and list a corporation you recognize that has issued either a stock dividend or a stock split in the past couple of years.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT