Closing prices for Sillech and New Mines for the years 1999-2014 are shown below. a. Calculate the total returns for each stock for the years 2000-2014 to three decimal places. Note that the price for 1999 is used to calculate the return for 2000. b. Assume that similar returns will continue in the future (i.e., average returns= expected returns). Calculate the expected return, variance, and standard deviation for both stocks and insert these values in the spreadsheet. Use Average, Var, and STDEV functions.

Closing prices for Sillech and New Mines for the years 1999-2014 are shown below. a. Calculate the total returns for each stock for the years 2000-2014 to three decimal places. Note that the price for 1999 is used to calculate the return for 2000. b. Assume that similar returns will continue in the future (i.e., average returns= expected returns). Calculate the expected return, variance, and standard deviation for both stocks and insert these values in the spreadsheet. Use Average, Var, and STDEV functions.

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter15: Decision Analysis

Section: Chapter Questions

Problem 4P: Investment advisors estimated the stock market returns for four market segments: computers,...

See similar textbooks

Similar questions

Investment advisors estimated the stock market returns for four market segments: computers, financial, manufacturing, and pharmaceuticals. Annual return projections vary depending on whether the general economic conditions are improving, stable, or declining. The anticipated annual return percentages for each market segment under each economic condition are as follows: Assume that an individual investor wants to select one market segment for a new investment. A forecast shows improving to declining economic conditions with the following probabilities: improving (0.2), stable (0.5), and declining (0.3). What is the preferred market segment for the investor, and what is the expected return percentage? At a later date, a revised forecast shows a potential for an improvement in economic conditions. New probabilities are as follows: improving (0.4), stable (0.4), and declining (0.2). What is the preferred market segment for the investor based on these new probabilities? What is the expected return percentage?
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. (Show the Nike returns on the vertical axis and the S&P 500 Index returns on the horizontal axis.) d. From your graph, describe the nature of the relationship between Nike stock returns and the returns for the S&P 500 Index.
If the return on stock A in year 1 was 10 %, in year 2 was -6 %, in year 3 was -2 % and in year 4 was 10 %, what was the standard deviation of returns for stock A over this four year period? (Round your answer to 1 decimal place and record without a percent sign. If your final answer is negative, place a minus sign before the number with no space between the sign and the number).
You’ve observed the following returns on Pine Computer’s stock over the past five years: −26.4 percent, 14.6 percent, 32.2 percent, 2.8 percent, and 21.8 percent. What was the arithmetic average return on the stock over this five-year period? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. What was the variance of the returns over this period? Note: Do not round intermediate calculations and round your answer to 6 decimal places, e.g., .161616. What was the standard deviation of the returns over this period? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.
You find a certain stock that had returns of 16 percent, −23 percent, 24 percent, and 9 percent for four of the last five years. The average return of the stock over this period was 10.2 percent. a. What was the stock’s return for the missing year? (Do not round intermediate calculations and enter your answer as a percent rounded to 1 decimal place, e.g., 32.1.) b. What is the standard deviation of the stock’s returns? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
Each stock's rate of return in a given year consists of a dividend yield (which might be zero) plus a capital gains yield (which could be positive, negative, or zero). Such returns are calculated for all the stocks in the S&P 500. A weighted average of those returns, using each stock's total market value, is then calculated, and that average return is often used as an indicator of the "return on the market."
he last four years of returns for a stock are as shown here: LOADING... . a. What is the average annual return? b. What is the variance of the stock's returns? c. What is the standard deviation of the stock's returns? Note: Notice that the average return and standard deviation must be entered in percentage format. The variance must be entered in decimal format. Question content area bottom Part 1 a. What is the average annual return? The average return is enter your response here%. (Round to two decimal places.) Part 2 b. What is the variance of the stock's returns? The variance of the returns is enter your response here. (Round to five decimal places.) Part 3 c. What is the standard deviation of the stock's returns? The standard deviation is enter your response here%. (Round to two decimal places.) Time Remaining: 00:26:16 pop-up content starts Data table (Click on the following icon in order…
You’ve observed the following returns on Pine Computer’s stock over the past five years: 13 percent, −13 percent, 20 percent, 25 percent, and 10 percent. a. What was the arithmetic average return on the company’s stock over this five-year period? (Do not round intermediate calculations and enter your answer as a percent rounded to 1 decimal place, e.g., 32.1.) b-1. What was the variance of the company’s returns over this period? (Do not round intermediate calculations and round your answer to 5 decimal places, e.g., .16161.) b-2. What was the standard deviation of the company’s returns over this period? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) a. Average return % b-1. Variance b-2. Standard deviation %
The last four years of returns for a stock are as shown here: LOADING... . a. What is the average annual return? b. What is the variance of the stock's returns? c. What is the standard deviation of the stock's returns? Note: Notice that the average return and standard deviation must be entered in percentage format. The variance must be entered in decimal format. Question content area bottom Part 1 a. What is the average annual return? The average return is enter your response here%. (Round to two decimal places.) Part 2 b. What is the variance of the stock's returns? The variance of the returns is enter your response here. (Round to five decimal places.) Part 3 c. What is the standard deviation of the stock's returns? The standard deviation is enter your response here%. (Round to two decimal places.) figure Year: 1, 2, 3, 4 Return: -4.2%, +27.9%, +11.8%, +3.8%
Using the data shown in the table below that contains historical monthly prices and dividends (paid at the end of themonth) for Ford Motor Company stock (Ticker: F) from August 1994 to August 1998, compute the: a. Average monthly return over this period is --%. (Round to two decimal places.) b. Monthly volatility (or standard deviation) over this period. (Round to two decimal places.)c. compute 95% confidence interval of the estimate of the average monthly return. Date Stock Price Dividend Return 1+RtAug-94 $29.250 $0.000 Sep-94 $27.750 $0.000 -5.13% 0.949Oct-94 $29.500 $0.260 7.24% 1.072Nov-94 $27.125 $0.000 -8.05% 0.919Dec-94 $27.875 $0.000 2.76% 1.028Jan-95 $25.250 $0.260 -8.48% 0.915Feb-95 $26.125 $0.000 3.47% 1.035Mar-95 $26.875 $0.000 2.87% 1.029Apr-95 $27.125 $0.310 2.08% 1.021May-95 $29.250 $0.000 7.83% 1.078Jun-95 $29.750 $0.000…
The data below consist of the closing price of the common stock of the American Telephone and Telegraph Corporation on 10 recent trading days. Time(t) Price Time(t) Price 1 $24.10 6 $22.73 2 23.80 7 22.60 3 23.39 8 21.76 4 22.90 9 22.14 5 22.10 10 21.69 a. Using a five-period moving average, forecast the price of the stock for period 10. b. What is the error of the forecast in #1-a? c. Using a five-period moving average, forecast the price of the stock for period 11.
The following information is for the next three problems.. Over the last four years ending July 1, the 1-year holding periodtotal returns (i.e., annual returns) for Netflix common stock (ticker symbol NFLX) were:2020: 51.36% 2021: 5.87% 2022: -56.55% 2023: 100.11%2. Calculate the arithmetic average annual return.3. Calculate the geometric average annual return.4. Calculate the volatility (standard deviation) of the annual returns.