Question

In: Finance

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

  1. 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 places.
  2. Calculate the total return for the entire holding period, the compound average monthly rate of return, the average monthly rate of return using the AVERAGE function, and the average monthly rate of return using the GEOMEAN function.

Solutions

Expert Solution

a]

monthly rate of return = (current month price - previous month price) / previous month price

b]

Total return = (ending price - beginning price) / beginning price

Compound average monthly return = (ending price / beginning price)1/6 - 1 (we do this because ending price = beginning price * (1 + r)6, where r is the compound average monthly return, and 6 is the number of months of compounding)

GEOMEAN function will not work for MSFT and NVDA as there are negative returns in some months


Related Solutions

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...
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...
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...
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 table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple three-month moving average for each month for both companies. (Input all amounts as positive values. Do not round intermediate calculations. Round your answers to 2 decimal places.) IBM AMZN January $ 172.04 $ 606.16 February 174.89 617.72 March 185.17 581.12 April 201.13 545.70 May 194.77 520.70 June 206.33 501.58 July 227.84 604.89 August 210.31 539.16 September 218.15 514.00 October 213.99 596.68 November 194.09 595.91...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the exponential...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the exponential three-month moving average for both stocks where two-thirds of the average weight is placed on the most recent price. (Do not round intermediate calculations. Round your answers to 2 decimal places.) IBM AMZN January $ 177.44 $ 619.21 February 178.49 627.44 March 196.51 568.43 April 213.10 549.30 May 190.45 501.98 June 210.47 490.78 July 239.81 607.59 August 199.24 535.11 September 222.47 511.66 October 215.07...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple three-month moving average for each month for both companies. (Input all amounts as positive values. Do not round intermediate calculations. Round your answers to 2 decimal places.) IBM AMZN January $ 181.04 $ 627.91 February 180.89 633.92 March 204.07 559.97 April 221.08 551.70 May 187.57 489.50 June 213.23 483.58 July 247.79 609.39 August 191.86 532.41 September 225.35 510.10 October 215.79 611.83 November 200.84 582.86...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple three-month moving average for each month for both companies. (Input all amounts as positive values. Do not round intermediate calculations. Round your answers to 2 decimal places.) IBM AMZN January $ 180.44 $ 626.46 February 180.49 632.84 March 202.81 561.38 April 219.75 551.30 May 188.05 491.58 June 212.77 484.78 July 246.46 609.09 August 193.09 532.86 September 224.87 510.36 October 215.67 610.82 November 200.39 583.73...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple three-month moving average for each month for both companies. (Input all amounts as positive values. Do not round intermediate calculations. Round your answers to 2 decimal places.) IBM AMZN January $ 170.24 $ 601.81 February 173.69 614.48 March 181.39 585.35 April 197.14 544.50 May 196.21 526.94 June 204.95 505.18 July 223.85 603.99 August 214.00 540.51 September 216.71 514.78 October 213.63 593.65 November 192.74 598.52...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple three-month moving average for each month for both companies. (Input all amounts as positive values. Do not round intermediate calculations. Round your answers to 2 decimal places.) IBM AMZN January $ 181.04 $ 627.91 February 180.89 633.92 March 204.07 559.97 April 221.08 551.70 May 187.57 489.50 June 213.23 483.58 July 247.79 609.39 August 191.86 532.41 September 225.35 510.10 October 215.79 611.83 November 200.84 582.86...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT