The monthly Dividend Adjusted Share Pricing data are the end-of-month stock prices adjusted for stock splits,...

   

Transcribed Image Text:

The monthly Dividend Adjusted Share Pricing data are the end-of-month stock prices adjusted for stock splits, cash dividends, and other capital events, which makes it easier to compute monthly percentage returns with. For example, the monthly stock return in January 2020 can be computed using the formula: rt = Pt Pt-1 - 1 where rt denotes the holding period return over the entire month of January 2020, and Pt and Pt-1 represent the dividend-adjusted stock prices at the end of January 2020 and December 2019, respectively. Using the above formula, you would be able to generate a new column in Excel containing the monthly returns for the stock. Date AAPL Adj. Price Jun-30-2010 7.69 Jul-31-2010 7.87 Aug-31-2010 7.43 Sep-30-2010 8.90 Oct-31-2010 9.33 Nov-30-2010 9.63 Dec-31-2010 9.95 Jan-31-2011 10.28 Feb-28-2011 10.65 Mar-31-2011 10.72 calculate monthly stock return? The monthly Dividend Adjusted Share Pricing data are the end-of-month stock prices adjusted for stock splits, cash dividends, and other capital events, which makes it easier to compute monthly percentage returns with. For example, the monthly stock return in January 2020 can be computed using the formula: rt = Pt Pt-1 - 1 where rt denotes the holding period return over the entire month of January 2020, and Pt and Pt-1 represent the dividend-adjusted stock prices at the end of January 2020 and December 2019, respectively. Using the above formula, you would be able to generate a new column in Excel containing the monthly returns for the stock. Date AAPL Adj. Price Jun-30-2010 7.69 Jul-31-2010 7.87 Aug-31-2010 7.43 Sep-30-2010 8.90 Oct-31-2010 9.33 Nov-30-2010 9.63 Dec-31-2010 9.95 Jan-31-2011 10.28 Feb-28-2011 10.65 Mar-31-2011 10.72 calculate monthly stock return?