Question
I need to know how to do the standard deviation and the coefficient of variation using the data from question 3. Please show all work using formulas not financial calculators.
2. (5 points) During the early 1980s interest rates were much higher. Suppose an APR of 1 1.25% 10.00% with monthly compounding, which would you prefer (all else equal)? the effective annual rates. Bark o.. EAR, 1.75% Cwo.twK Bank One offered Show this with Two o with annual compounding on a deposit, while Bank Two offered an APR of 3. (8 points) Given the following year end stock closing prices for Mobile Tech Inc., calculate the annual holding period returns for each year from 2015 to 2018. Year 2018 2017 2016 2015 2014 HPR 474,2。 Price $45 $41 $24 $28 $20 2 5. (5 points) 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? 6. (14 points) From question 4, what is the average annual HPR, the standard deviation of HP and the coefficient of variation? v Aane Irk - 31.257 Rs,
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer:

Average return=Sum of HPR/4=106.30%/4=26.58%

variance- -R74

Variance=10.23%

Standard Deviation= V varance=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%

Add a comment
Know the answer?
Add Answer to:
I need to know how to do the standard deviation and the coefficient of variation using...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Given the following year end stock closing prices for Long Tech Inc. calculate the annual holding...

    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...

    (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 S...

    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...

    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...

    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...

    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

    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...

  • Financial principle

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT