10.4 Obtain at least 5 years’ worth of daily or weekly stock price data for a stock of your choice. a. Compute annual volatility using all the data. b.Compute annual volatility for each calendar year in your data. How does volatility vary over time? c.Compute annual volatility for the first and second half of each year in your data. How much variation is there in your estimate? how do I do these in excel?

10.4 Obtain at least 5 years’ worth of daily or weekly stock price data for a stock of your choice. a. Compute annual volatility using all the data. b.Compute annual volatility for each calendar year in your data. How does volatility vary over time? c.Compute annual volatility for the first and second half of each year in your data. How much variation is there in your estimate? how do I do these in excel?

International Financial Management

14th Edition

ISBN:9780357130698

Author:Madura

Publisher:Madura

Chapter13: Direct Foreign Investment

Section: Chapter Questions

Problem 1IEE

See similar textbooks

Similar questions

(Computing rates of return) From the following price data, compute the annual rates of return for Asman and Salinas. Time 1 2 3 12 4 14 (Click on the icon in order to copy its contents into a spreadsheet.) How would you interpret the meaning of the annual rates of return? Asman $9 11 Salinas $30 27 32 36 The rate of return you would have earned on Asman stock from time 1 to time 2 is %. (Round to two decimal places.)
The annual rate of return on any given stock can be found as the stock's dividend for the year plus the change in the stock's price during the year, divided by its beginning-of-year price. If you obtain such data on a large portfolio of stocks, like those in the S&P 500, find the rate of return on each stock, and then average those returns, this would give you an idea of stock market returns for the year in question. true/false
Using the data in the table:, a. What was the average annual return of Microsoft stock from 2005-2017? b. What was the annual volatility for Microsoft stock from 2005-2017? a. What was the average annual return of Microsoft stock from 2005-2017? The average annual return is %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Realized Return for the S&P 500, Microsoft, and Treasury Bills, 2005-2017 S&P 500 Realized Return Microsoft Realized Return Dividends Paid* Year End 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 S&P 500 Index 1211.92 1248.29 3.00% 4.80% 1418.30 1468.36 903.25 4.70% 1.50% 0.10% 0.10% 1115.10 1257.64 1257.61 0.00% 1426.19 0.10% 1848.36 0.00% 0.00% 2058.90 2043.94 0.00% 0.20% 2238.83 2673.61 0.80% *Total dividends paid by the 500 stocks in the portfolio, based on the number of shares of each stock in the index, adjusted until the end of the year, assuming they were…
During the past five years, you owned two stocks that had the following annual rates of return: Stock B: a. Compute the arithmetic mean annual rate of return for each stock. Round your answers to one decimal place. Stock T: % Stock B: % Which stock is most desirable by this measure? -Select- is more desirable because the arithmetic mean annual rate of return is -Select- C b. Compute the standard deviation of the annual rate of return for each stock. (Use Chapter 1 Appendix if necessary.) Do not round intermediate calculations. Round your answers to three decimal places. Answer with the population standard deviation. Stock T: % By this measure, which is the preferable stock? -Select- is the preferable stock. Stock B: % Year 1 2 3 4 5 Stock T 0.16 0.05 -0.15 -0.06 0.15 By this relative measure of risk, which stock is preferable? -Select- is the preferable stock. Stock B: Stock B 0.10 0.02 -0.10 0.04 0.02 c. Compute the coefficient of variation for each stock. (Use the Chapter 1 Appendix…
(Computing rates of return) From the following price data, compute the annual rates of return for Asman and Salinas. Time Asman Salinas 1 $10 $30 2 12 27 3 11 32 4 13 34 (Click on the icon in order to copy its contents into a spreadsheet.) How would you interpret the meaning of the annual rates of return? Question content area bottom Part 1 The rate of return you would have earned on Asman stock from time 1 to time 2 is enter your response here%. (Round to two decimal places.)
. You have observed the following returns over time: Stock X Stock Y Year Price Div Price Div Market Returns 2005 20 0 11 0 0 2006 24 1.2 13 1.6 0.25 2007 26 0.5 17 0.5 0.18 2008 31 1 20 0.9 0.11 2009 33 1.5 23 1.2 0.12 2010 40 2 27 1.5 0.15 a. Calculate the annual returns for each stock (2006-2010) b. Calculate the average returns for each of the stocks and the market c. Calculate the covariance between the stocks d. Compute the portfolio return and portfolio risk if the Stock A and Stock B are combined equally in a portfolio.
> Access image details O O RETURN ON STOCK O O D O O O Oo O RETURN ON MARKET This graph plots the monthly returns for a given company against the monthly returns for the market. Every dot corresponds to a month and the associated returns for the market and the company during that month. Looking at this graph, where do you think you can find the Beta? Remember that a Beta roughly measures the correlation between a given company's returns and the market's returns.
If you look at stock prices over any year, you will find a high and low stock price for the year. Instead of a single benchmark PE ratio, we have a high and low PE ratio for each year. We can use these ratios to calculate a high and a low stock price for the next year. Suppose we have the following information on a particular company: High price Low price EPS Year 1 $ 62.18 40.30 2.35 a. High target price b. Low target price Year 2 $ 67.29 43.18 2.58 Year 3 $74.18 39.27 2.73 Year 4 $ 78.27 46.21 2.89 Earnings are expected to grow at 9 percent over the next year. a. What is the high target stock price in one year? Note: Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. b. What is the low target stock price in one year? Note: Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.
You want to check if GRBH stock is fairly priced in the markets by using the fundamental analysis. For this purpose, you have gathered the following information: GRBH pays dividends once a year and the next dividend payment is expected to be made in one year. You project the EPS of the first and second year to be $5 and $7 respectively. The company dividend payout ratio is stable at 0.2. At the end of the second year, you assume that the company would become the average company in the industry. The industry average PE ratio is 8. You believe that the appropriate required rate of return on GRBH stock is 10% (CCR per annum). And the current market price of GRBH stock is $45. ind the present value of GRBH stock based on the information above. Is the stock over- or under-priced?
You want to check if GRBH stock is fairly priced in the markets by using the fundamental analysis. For this purpose, you have gathered the following information: GRBH pays dividends once a year and the next dividend payment is expected to be made in one year. You project the EPS of the first and second year to be $5 and $7 respectively. The company dividend payout ratio is stable at 0.2. At the end of the second year, you assume that the company would become the average company in the industry. The industry average PE ratio is 8. You believe that the appropriate required rate of return on GRBH stock is 10% (CCR per annum). And the current market price of GRBH stock is $45. Find the present value of GRBH stock based on the information above. Is the stock over- or under-priced? Find the alpha ( Expected abnormal rate of return, c ) assuming the mispriced figure would be corrected in a year.
You want to check if GRBH stock is fairly priced in the markets by using the fundamental analysis. For this purpose, you have gathered the following information: GRBH pays dividends once a year and the next dividend payment is expected to be made in one year. You project the EPS of the first and second year to be $5 and $7 respectively. The company dividend payout ratio is stable at 0.2. At the end of the second year, you assume that the company would become the average company in the industry. The industry average PE ratio is 8. You believe that the appropriate required rate of return on GRBH stock is 10% (CCR per annum). And the current market price of GRBH stock is $45 Find the alpha ( Expected abnormal rate of return, c ) assuming the mispriced figure would be corrected in a year.
If you look at stock prices over any year, you will find a high and low stock price for the year. Instead of a single benchmark PE ratio, we have a high and low PE ratio for each year. We can use these ratios to calculate a high and a low stock price for the next year. Suppose we have the following information on a particular company. Year 1 $ 62.18 40.30 2.35 a. High target price b. Low target price Year 2 $67.29 43.18 2.58 Year 3- $74.18 39.27 2.73 Year 4 $78.27 46.21 High price Low price EPS Earnings are expected to grow at 9 percent over the next year. 6. What is the high target stock price in one year? 32.16. Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g.. b. What is the low target stock price in one year? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. 2.890