Pls show calculation if using excel explain steps or formula Financial analysts have estimated the returnson shares of Drucker Corporation and theoverall market portfolio under variouseconomic conditions as follows. The returnfor Drucker in the following three economicstates of nature are forecasted to be: -15% inrecession, +9% in moderate growth, and +30%in a boom. Estimates for the market as awhole in the same economic states are -10%in recession, +10% in moderate growth, and+20% in boom. The analyst considers eachstate to be equally likely. Using these data,compute the beta of Drucker Corporation'sstock.Place your answer as a number with at leastthree decimal places.

State of economyReturn (Drucker)Market return Recession-15%-10%Moderate growth9%10%Boom30%20%

Financial analysts have estimated the return: on shares of Drucker Corporation and the overall market portfolio under various economic conditions as follows. The return for Drucker in the following three economic

Financial analysts have estimated the return: on shares of Drucker Corporation and the overall market portfolio under various economic conditions as follows. The return for Drucker in the following three economic

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?
Financial analysts have estimated the returns on shares of Drucker Corporation and the overall market portfolio under various economic conditions as follows. The return for Drucker in the following three economic states of nature are forecasted to be: -20% in recession, +11% in moderate growth, and +28% in a boom. Estimates for the market as a whole in the same economic states are -11% in recession, +9% in moderate growth, and +24% in boom. The analyst considers each state to be equally likely. Using these data, compute the beta of Drucker Corporation's stock.
Financial analysts have estimated the returns on shares of the Goldday Corporation and the overall market portfolio under two economic states nature as follows. For Goldday the state dependent returns are -0.04 in recession, and 0.10 in an economic boom. For the market the state dependent returns are -0.12 in recession,and 0.14 in boom. The analyst estimates that the probability of a recession is 0.50 while the probability of an economic boom is 0.50.Compute the standard deviation of the market.
Financial analysts have estimated the returns on shares of the Goldday Corporation and the overall market portfolio under two economic states nature as follows. For Goldday the state dependent returns are -0.06 in recession, and 0.10 in an economic boom. For the market the state dependent returns are -0.08 in recession,and 0.18 in boom. The analyst estimates that the probability of a recession is 0.50 while the probability of an economic boom is 0.50. Compute the standard deviation of the market._____________ * State your answer in decimal form, working your analysis using at least four decimal places of accuracy.
Financial analysts have estimated the returns on shares of the Goldday Corporation and the overall market portfolio under two economic states nature as follows. For Goldday the state dependent returns are -0.06 in recession, and 0.10 in an economic boom. For the market the state dependent returns are -0.12 in recession, and 0.16 in boom. The analyst estimates that the probability of a recession is 0.50 while the probability of an economic boom is 0.50. Compute the beta of Goldday. * State your answer in decimal form, working your analysis using at least four decimal places of accuracy.
The following four macro-economic factors were identified regarding a stock As returns, the stock sensitivity to each factor and the related risk premium associated with each factor have been calculated as follows: Gross domestic product (GDP) growth=0.6 RP=4% Inflation rate= 0.8, RP=2% Platinum prices=-0.7, RP= 5% Standard and Poor’s 500 index return= 1.3 RP=9% The risk free rate is 3% Calculate the expected rate of return using the Arbitrage pricing theory formula.
There are only shares of A and B companies in the market. Currently, the market value of A and B shares is $200 million and $300 million, respectively. In addition, the risk-free interest rate (Rf) is 5 per cent. The probability and rate of return for the future state of the two entities are given as follows: (Value values with a decimal place or higher to the fifth decimal place.) 1) Obtain the expected return and variance of Entity A and B, respectively. 2) When forming a market portfolio with two shares, obtain the expected return rate and variance and standard deviation of the market portfolio. 3) Calculate the beta of share A, and calculate the required yield of share A. state probability Ra Rb 1 0.3 0.30 0.20 2 0.4 0.15 -0.10 3 0.3 0.05 0.10
Please include the excel formula You’ve observed the following returns on Pine Computer’s stock over the past five years: 8 percent, −12 percent, 14 percent, 21 percent, and 16 percent. Suppose the average inflation rate over this period was 3.1 percent and the average T-bill rate over the period was 3.9 percent. What was the average real return on the company’s stock? What was the average nominal risk premium on the company’s stock over this period? Input area: Year Returns 1 8% 2 -12% 3 14% 4 21% 5 16% Average inflation 3.10% Average T-bill rate 3.90% (Use cells A6 to B13 from the given information to complete this question. You must use the built-in Excel function to answer this question. Make sure to use the “sample” Excel formula.)…
The stock of Jones Trucking is expected to return 16 percent annually with a standard deviation of 7 percent. The stock of Bush Steel Mills is expected to return 21 percent annually with a standard deviation of 13 percent. The correlation between the returns from the two securities has been estimated to be +0.4. The beta of the Jones stock is 1.1, and the beta of the Bush stock is 1.4. The risk-free rate of return is expected to be 6 percent, and the expected return on the market portfolio is 16 percent. The current dividend for Jones is $5. The current dividend for Bush is $7. What is the expected return from a portfolio containing the two securities if 30 percent of your wealth is invested in Jones and 70 percent is invested in Bush? Round your answer to one decimal place. % What is the expected standard deviation of the portfolio of the two stocks? Round your answer to two decimal places. % Which stock is the better buy in the current market? Round your answers to one decimal…
The stock of Jones Trucking is expected to return 16 percent annually with a standard deviation of 7 percent. The stock of Bush Steel Mills is expected to return 21 percent annually with a standard deviation of 13 percent. The correlation between the returns from the two securities has been estimated to be +0.4. The beta of the Jones stock is 1.1, and the beta of the Bush stock is 1.4. The risk-free rate of return is expected to be 6 percent, and the expected return on the market portfolio is 16 percent. The current dividend for Jones is $5. The current dividend for Bush is $7. What is the expected return from a portfolio containing the two securities if 30 percent of your wealth is invested in Jones and 70 percent is invested in Bush? Round your answer to one decimal place. % What is the expected standard deviation of the portfolio of the two stocks? Round your answer to two decimal places. % Which stock is the better buy in the current market? Round your answers to one decimal…
Consider historical data showing that the average annual rate of return on the S&P 500 portfolio over the past 85 years has averaged roughly 8% more than the Treasury bill return and that the S&P 500 standard deviation has been about 38% per year. Assume these values are representative of investors' expectations for future performance and that the current T-bill rate is 5%. Calculate the expected return and variance of portfolios invested in T-bills and the S&P 500 index with weights as shown below. (Enter your answers as decimals rounded to 4 places. Leave no cells blank - be certain to enter "0" wherever required.) WBills: WIndex: Expected Return: Variance: 0.0 1.0 0.1300 0.1444 Example 0.2 0.8 0.4 0.6 0.6 0.4 0.8 0.2 1.0 0.0
Financial analysts have estimated the returns on shares of the Goldday Corporation and the overall market portfolio under two economic states nature as follows. For Goldday the state dependent returns are 0.06 in recession, and 0.08 in an economic boom. For the market the state dependent returns are -0.12 in recession, and 0.16 in boom. The analyst consider each state to be equally likely. Compute the correlation coefficient between Goldday and the Market.