Answer:
Average return=Sum of HPR/4=106.30%/4=26.58%
Variance=10.23%
Standard Deviation= =31.98%
Year | HPR X | P=X-R | B=P*P |
2014 | |||
2015 | 40% | 13.42% | 1.80% |
2016 | -14.29% | -40.86% | 16.70% |
2017 | 70.83% | 44.26% | 19.59% |
2018 | 9.76% | -16.82% | 2.83% |
Average return R | 26.58% | Variance | 10.23% |
Standard deviation | 31.98% |
Coefficient of variation= Standard deviation /Average return=31.98%/26.58%=120.34%
I need to know how to do the standard deviation and the coefficient of variation using...
Given the following year end stock closing prices for Long Tech Inc. calculate the annual holding period returns for each year from 2015 to 2018. Please Show all work with formulas! Year Price HPR 2018 $45 _________ 2017 $41 _________ 2016 $24 _________ 2015 $28 _________ 2014 $20 _________ b. For the above holding period returns, what is the effective annual return if you purchased the stock in 2014 and sold it in 2018 at the prices listed? c....
(Expected return, standard deviation, and capital asset pricing model) The following are the end-of-month prices for both the Standard & Poor's 500 index and Nike's common stock a. Using the data in the popup window, calculate the holding period returns for each of the months b. Calculate the average monthly return and the standard deviation for both the S&P 500 and Nike c. Develop a graph that shows the relationship between the Nike stock returns and the S&P 500 Index...
REALIZED RATES OF RETURN NEED TO BE DONE USING EXCEL!!!! Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2011 - 24.00% - 12.10% 2012 20.50 23.70 2013 17.75 31.90 2014 - 5.25 - 11.70 2015 25.75 2.95 Calculate the average rate of return for stock A during the period 2011 through 2015. Round your answer to two decimal places. % Calculate the average rate of return for stock B during...
QUESTIONS Consider the performance of two securities and k over the five year period from 2014 to 2018. The annual return earned on each one of them is as provided in the table below Year 379 28.4 -15 a 2014 2015 2016 2017 2018 19.8 128 -208 58.6 -500 31.7 Required: Compute the following: a) Assume your organization had K150 million to invest on 01st January, 2014. If 70% was invested in security J over the holding period, the annual...
Suppose you remembered that the coefficient of variation (CV) is generally regarded as being a better measure of stand-alone risk than standard deviation when alternatives being considered have widely differing expected returns. Calculate the missing CVS. (2.5 pts) Standard Deviation Coefficient of Variation (CV) High Tech = 20.0% OT-bills = 0.0% Collections = 11.2% OU.S. Rubber = 18.8 OM = 15.2% Chapter 8 Risk and Rates of Return 311 INTEGRATED CASE MERRILL FINCH INC. 8-23 RISK AND RETURN Asume that...
P8-13 (similar to) Question Help Portfolio return and standard deviation Personal Finance Problem Jamie Wong is thinking of building an investment portfolio containing two stocks, L and M. Stock Lwill represent 75% of the dollar value of the portfolio, and stock M will account for the other 25%. The historical returns over the next 6 years, 2013 - 2018, for each of these stocks are shown in the following table: a. Calculate the actual portfolio return, fp, for each of...
Risk and return You are considering an investment in the stock market and have identified three potential stocks, they are Shanghai Fosun Pharmaceutical Group (HKG: 2196), China Petroleum & Chemical Corporation (HKG: 386) and Commonwealth Bank (ASX: CBA). The historical prices between 2013 and 2020 in the table below, note that these prices are recorded on the 1st day of the year, for example, 1st of January 2020. Students assume no dividend is distributed during this period and ignore the...
You are considering an investment in the stock market and have identified three potential stocks, they are Crown (ASX: CWN), Tencent (HKG: 0700) and Commonwealth Bank (ASX: CBA). The historical prices for the past 10 years are shown in the table below. Assume no dividend is distributed during this period.YearCrownTencentCommonwealth (CBA)20107.7629.0453.6320118.5740.4052.1520128.0937.9450.39201311.5954.2864.10201416.68108.7073.83201513.6113288.85201612.27144.9078.67201711.4204.4081.66201813.25463.6078.87201911.9534669.911. (6 marks)Calculate the return and risk (standard deviation) of each stock. 2. (3 marks)Explain the relation (positive or negative) between risk and return based on your answers in part (1). 3. ...
i must need excel formula
Spreadsheet Exercise: Chapter 8 Jane is considering investing in three different stocks or creating three distinct twostock portfolios. Jane views herself as a rather conservative investor. She is able to obtain historical returns for the three securities for the years 2012 through 2018. The data are given in the following table. Stock C 129 13 Year 2012 2013 2014 2015 2016 2017 2018 Stock A 10% 13% 15% 14% 16% 1496 12 Stock B 10%...
17.30 Mini Case This Mini Case is available in MyFinanceLab. Note: Although not absolutely necessary, you are advised to use a computer spread- sheet to work the following problem. a. Use the price data from the table that follows for the Standard & Poor's 500 Index, Wal-Mart, and Target to calculate the holding period returns for the 24 months from May 2013 through May 2015 MONT SEP 500 TAASET 2013 May $1,631 $74.84 $69.50 June 1,606 74.49 68.86 July 1,686...