Stock A: Stock B: Market Index Stock Price Dividend Stock Price Dividend 2016 $25.88 $1.73 $73.13 $4.50 $17.09 2015 $22.93 $1.59 $78.45 $4.35 $13.27 2014 $24.75 $1.50 $73.13 $4.13 $13.01 2013 $16.13 $1.43 $85.88 $3.75 $9.96 2012 $17.16 $1.35 $90.00 $3.38 $8.40 2011 $11.44 $1.28 $86.33 $3.00 $7.05 1.Use the data given to calculate annual returns for Stock A, Stock B, and...

80.2K

Verified Solution

Question

Finance

StockA: StockB: MarketIndex
Stock Price Dividend Stock Price Dividend
2016 $25.88 $1.73 $73.13 $4.50 $17.09
2015 $22.93 $1.59 $78.45 $4.35 $13.27
2014 $24.75 $1.50 $73.13 $4.13 $13.01
2013 $16.13 $1.43 $85.88 $3.75 $9.96
2012 $17.16 $1.35 $90.00 $3.38 $8.40
2011 $11.44 $1.28 $86.33 $3.00 $7.05
1.Use the data given tocalculate annual returns for Stock A, Stock B, and the MarketIndex, and then calculate average annual returns for the two stocksand the index. (Hint: Remember, returns are calculated bysubtracting the beginning price from the ending price to get thecapital gain or loss, adding the dividend to the capital gain orloss, and then dividing the result by the beginning price. Assumethat dividends are already included in the index. Also, you cannotcalculate the rate of return for 2011 because you do not have 2010data.)
2. Calculate the standarddeviations of the returns for Stock A, Stock B, and the MarketIndex. (Hint: Use the sample standard deviation formula given inthe chapter, which corresponds to the STDEV function in Excel.)
3. What dividends do you expectfor Stock A over the next three years if you expect the dividend togrow at the rate of 3% per year for the next three years? In otherwords, calculate D1, D2, and D3. Note that D0 = $1.50.
4. Assume that Stock A has arequired return of 13%. You will use this required return rate todiscount the dividends calculated earlier. If you plan to buy thestock, hold it for three years, and then sell it for $27.05, whatis the most you should pay for it?

	StockA:	StockB:	MarketIndex
Stock Price	Dividend	Stock Price	Dividend
2016	$25.88	$1.73	$73.13	$4.50	$17.09
2015	$22.93	$1.59	$78.45	$4.35	$13.27
2014	$24.75	$1.50	$73.13	$4.13	$13.01
2013	$16.13	$1.43	$85.88	$3.75	$9.96
2012	$17.16	$1.35	$90.00	$3.38	$8.40
2011	$11.44	$1.28	$86.33	$3.00	$7.05

Answer & Explanation Solved by verified expert

4.5 Ratings (646 Votes)

1annual return current year stock price previous year stockprice current year dividend previous year See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

StockA:StockB:MarketIndexStock PriceDividendStock PriceDividend2016$25.88$1.73$73.13$4.50$17.092015$22.93$1.59$78.45$4.35$13.272014$24.75$1.50$73.13$4.13$13.012013$16.13$1.43$85.88$3.75$9.962012$17.16$1.35$90.00$3.38$8.402011$11.44$1.28$86.33$3.00$7.051.Use the data given tocalculate annual returns for Stock A, Stock B, and the MarketIndex, and then calculate average annual returns for the two stocksand the index. (Hint: Remember, returns are calculated bysubtracting the beginning price from the ending price to get thecapital gain or loss, adding the dividend to the capital gain orloss, and then dividing the result by the beginning price. Assumethat dividends are already included in the index. Also, you cannotcalculate the rate of return for 2011 because you do not have 2010data.)2. Calculate the standarddeviations of the returns for Stock A, Stock B, and the MarketIndex. (Hint: Use the sample standard deviation formula given inthe chapter, which corresponds to the STDEV function in Excel.)3. What dividends do you expectfor Stock A over the next three years if you expect the dividend togrow at the rate of 3% per year for the next three years? In otherwords, calculate D1, D2, and D3. Note that D0 = $1.50.4. Assume that Stock A has arequired return of 13%. You will use this required return rate todiscount the dividends calculated earlier. If you plan to buy thestock, hold it for three years, and then sell it for $27.05, whatis the most you should pay for it?