Question
In: Finance
Using the data in the following table, estimate the average return and volatility for each stock....
Using the data in the following table, estimate the average return and volatility for each stock.
Year Stock A Stock b
2008 -5% 15%
2009 19% 31%
2010 10% 4%
2011 -4% .5%
2012 3% -9%
2013 15% 23%
What is the variance of stock a? Stock b?
Solutions
Expert Solution
| Year | Stock A | Stock B |
| 2008 | -5.00% | 15.00% |
| 2009 | 19.00% | 31.00% |
| 2010 | 10.00% | 4.00% |
| 2011 | -4.00% | 0.50% |
| 2012 | 3.00% | -9.00% |
| 2013 | 15.00% | 23.00% |
| Average Return for Stock A = | =SUM(B3:B8)/6 | = | 6.33% |
| Average Return for Stock B = | =SUM(C3:C8)/6 | = | 10.75% |
| Variance for Stock A = | =VAR.S(B3:B8) | = | 0.99% |
| Variance for Stock B = | =VAR.S(C3:C8) | = | 2.24% |
Please
Thumbs Up
Thanks
jeff jeffy answered 1 year agoRelated Solutions
Estimate the historical volatility of a stock using the following data. The data show the stock...
Estimate the historical volatility of a stock using the
following data. The data show the stock price at the end of each of
week over ten consecutive weeks.
12.0, 13.3 11.2, 12.0, 12.7, 13.1, 13.3, 14.5, 14.9, 14.1
2. What is the Black-Scholes-Merton price of a European call
option when the stock price is $75, the strike price is $80, the
risk-free rate is 2% (based on continuous compounding), the
volatility is 50% and the time to expiration is...
Using the data in the table, calculate the return for investing in the stock from January...
Using the data in the table, calculate the return for investing
in the stock from January 1 to December 31. Prices are after the
dividend has been paid. Date Price Dividend Jan 1 $ 34.96 minus
Feb 5 $ 30.19 $ 0.21 May 14 $ 28.61 $ 0.19 Aug 13 $ 32.06 $ 0.21
Nov 12 $ 37.48 $ 0.18 Dec 31 $ 42.57 minus Return for the entire
period is nothing%. (Round to two decimal places.
1. How to calculate the historical average return and the volatility of stock? 2. How to...
1. How to calculate the historical average return and the
volatility of stock?
2. How to calculate the correlation matrix among different
stocks? (can you show me with real examples)
how to Calculate monthly stock return volatility and monthly turnover ? How return volatility is associated...
how to Calculate monthly stock return volatility and monthly
turnover ?
How return volatility is associated with turnover? Suppose in
early January 2018 you start investing in one (and only one) of the
two stocks and sell in 3 months, which stock you choose?
The current price of stock is 20TRY. The volatility is estimated by using historical data and...
The current price of stock is 20TRY. The volatility is estimated
by using historical data and found to be %30. Use at two step
binomial tree approach to find the value of six month european put
option with strike price of 21TRY. The risk free rate is %10. Would
you exercise the option before expiration date if it were an
american one ?
Using the data in the table to the right, calculate the return for investing in the...
Using the data in the table to the right, calculate the return
for investing in the stock from January 1 to December 31. Prices
are after the dividend has been paid. Date Price Dividend Jan 1 $
31.43 minus Feb 5 $ 32.72 $ 0.17 May 14 $ 28.25 $ 0.18 Aug 13 $
32.98 $ 0.22 Nov 12 $ 39.59 $ 0.21 Dec 31 $ 43.76 minus Return for
the entire period is 31.17%. (Round to two decimal places.)
Using the data in the table to the right, calculate the return for investing in the...
Using the data in the table to the right, calculate the return
for investing in the stock from January 1 to December 31. Prices
are after the dividend has been paid. Date Price Dividend Jan 1 $
34.77 minus Feb 5 $ 31.62 $ 0.17 May 14 $ 28.37 $ 0.17 Aug 13 $
32.56 $ 0.17 Nov 12 $ 39.25 $ 0.18 Dec 31 $ 41.24 minus
Using the data in the table to the right, calculate the return for investing in the...
Using the data in the table to the right, calculate the return
for investing in the stock from January 1 to December 31. Prices
are after the dividend has been paid.
Date
Price
Dividend
Jan1
$34.21
-
Feb 5
$30.65
$0.18
May 14
$29.98
$0.18
Aug 13
$30.18
$0.18
Nov 12
$36.75
$0.21
Dec 31
$42.79
-
Using the data in the table to the right, calculate the return for investing in the...
Using the data in the table to the right, calculate the return
for investing in the stock from January 1 to December 31. Prices
are after the dividend has been paid. Date Price Dividend Jan 1
$33.86 − Feb 5 $32.48 $0.17 May 14 $30.53 $0.18 Aug 13 $32.08 $0.19
Nov 12 $39.18 $0.22 Dec 31 $42.72 -
Using the data in the following table, answer parts (i) – (v). Year Stock X Stock...
Using the data in the following table, answer parts (i) –
(v).
Year
Stock X
Stock Y
2012
-11%
-5%
2013
15%
25%
2014
10%
15%
2015
-5%
-15%
2016
5%
-5%
2017
8%
-2%
2018
7%
10%
2019
5%
15%
Average return
Standard deviation
Correlation between Stock X and Stock
Y
0.7567
Estimate the average return for each stock.
Calculate the standard deviation of returns for Stocks X and Y.
For a portfolio that is 75% weighted...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Java 1. public void writeJSON(PrintStream ps) { Write the member variables in JSON format to the...
- NASCAR CASE The term NASCAR referred both to the sanctioning body and to the whole sport...
- Slick Corporation is a small producer of synthetic motor oil. During May, the company produced 5,000...
- New Age Electronics manufactures surround sound systems and allocates overhead costs using direct-labor hours. They pay...
- A 210 g , 24-cm-diameter plastic disk is spun on an axle through its center by...
- Question (strategic management) What involves the strategic management function? (a) What does formulating a strategy reveals?...
- Calculate the hardness using the following concentrations: Na+=248mg/L K+=5.5mg/L Ca2+=54mg/L Mg2+=26mg/L
ADVERTISEMENT