EXCEL PROJECT AND EXCEL SOLUTION Consider the following stocks, all of which will paya liquidating dividend in a year and nothing in the interim:StockAStockBStockсStockDMarket Capitalization(5 million)800750950900Expected LiquidatingDividend ($ million)1000100010001000BetaPLEASE SHOW SOLUTIONS IN EXCEL0.771.461.251.07a. Calculate the expected return of each stock.b. What is the sign of correlation between the expected return and marketcapitalization of the stocks?In Problem 20, assume the risk-free rate is 3% and the market risk premium is 7%.a. What does the CAPM predict the expected return for each stock should be?b. Clearly, the CAPM predictions are not equal to the actual expected returns, so the CAPMdoes not hold. You decide to investigate this further. To see what kind of mistakes the CAPMis making, you decide to regress the actual expected return onto the expected returnpredicted by the CAPM.49 What is the intercept and slope coefficient of this regression?49. The Excel function SLOPE will produce the desired answersc. What are the residuals of the regression in part (b)? That is, for each stock compute thedifference between the actual expected return and the best-fitting line given by theintercept and slope coefficient in part (b).d. What is the sign of the correlation between the residuals you calculated in part (c) andmarket capitalization?e. What can you conclude from your answers to part (b) of the previous problem and part(d) of this problem about the relation between firm size (market capitalization) and returns?(The results do not depend on the particular numbers in this problem. You are welcome toverify this for yourself by redoing the problems with another value for the market riskpremium, and by picking the stock betas and market capitalizations randomly.50. The Excel command RAND will produce a random number between 0 and 1.

Note : Since you have posted too many questions, I am solving only first question with two…

Answered: EXCEL PROJECT AND EXCEL SOLUTION…

Fundamentals Of Financial Management, Concise Edition (mindtap Course List)

10th Edition

ISBN:9781337902571

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter8: Risk And Rates Of Return

Section: Chapter Questions

Problem 22SP

See similar textbooks

Similar questions

Consider the following security: Applegate Aeronautical, Incorporated Earnings Per Share, Next Year $2.50 Dividend Payout Rate 0.400 Return on Equity 0.150 Beta 1.250 Market Data Market Risk Premium 0.075 Risk-free Rate 0.025 Required: Using the information in the tables above, please calculate the dividend per share, the retained earnings, and the intrinsic value of this stock. (Use cells A5 to B12 from the given information to complete this question.) Applegate Aeronautical, Incorporated Market Capitalization Rate Dividends per share (Next Year) Sustainable Growth Rate Intrinsic Value
Calculate the correlation between the expected return and market capitalization for the following stocks, all of which will pay a liquidating dividend in one year and no interim dividends: Market cap (SMM) Expected dividend (SMM) Stock A 500 1000 Stock B 800 1000 Stock C 600 1000 Stock D 900 1000
Answer the multiple-choice question below: 1. A stock price P0=$23, and is expected to pay D1 = $1.242 one year from now and to grow at a constant rate of g=8% in the future. Suppose this analysis was conducted in January 1, 2002, what is the expected price at the end of 2002 and what is the Capital gains yield? Select one: a. P 12/31/02 = $34.24; Capital gains Yield 2002 = $4.50% b. P 12/31/02 = $24.84; Capital gains Yield 2002 = $8.4% c. P 12/31/02 = $21.40; Capital gains Yield 2002 = $18.4% d. P 12/31/02 = $24.84; Capital gains Yield 2002 = $8.0%
The following table shows the expected dividend payments and required rate of return of Globex Corp. Clearly explain the assumptions, if any, you are using to solve below question(s). 2021 2023 20244 2022 $4 Yeara 2025 20264 20274 ket Dividend $ 0.40 0.44 0.48 $ 0.53 $ 0.59 $ 0.61 $ 0.63 12%e i. Calculate value of Globex Corp share in 2021. ww mm
Use the following information to answer the question(s) below. Expected Liquidating Dividend Market Stock Capitalization Beta Taggart Transcontinental $800 $920 1.10 Rearden Metal $600 $720 1.20 Wyatt Oil $1000 $1100 0.80 Nielson Motors $400 $500 1.40 All amounts are in millions. If the risk - free rate is 3% and the market risk premium is 5%, then the CAPM's predicted expected return for Nielson Motors is closest to: A. 10.0% O B. 9.0% Oc. 9.5% O D. 8.5%
An analyst has gathered the following information for the Oudin Corporation: Expected earnings per share = €5.49 Expected dividends per share = €2.13 Dividends are expected to grow at 2.53 percent per year indefinitely The required rate of return is 7.74 percent Based on the information provided, compute the price/earnings multiple for Oudin (Enter your answer as a number with two decimal places, like this: 12.34)
Using the equity asset valuation model (CAPM) equation, determine the required return for the shares of the following companies, if the market return is 7.50% (Rm = 7.50%) and the risk-free asset return is 1.25% (RF = 1.25%). You must show all counts. Stock Beta SKT 0.65 COST 0.90 SU 1.42 AMZN 1.57 V 0.94
1. An analyst estimates that a stock will pay a $1 dividend next year and that it will sell for $40 at year-end. If the required rate of return is 14%, what is the value of the stock? A. $34.60. B. $35.52. C. $35.96. Please provide an accurte answer.
An analyst produces the following series of annual dividend forecasts for company D: Expected dividend (end of) year t+1 = 10 euros; Expected dividend (end of) year t+2 = 20 euros; Expected dividend (end of) year t+3 = 10 euros. The analyst further expects that company D dividend will grow indefinitely at a rate of 2 percent after year t+3. Company D cost of equity equals 10 percent. Under these assumptions, calculate the analysts estimate of company D equity value at the end of year t.
Use the price and dividend information in the following table for stock ABC to answer the following questions. a) Assuming dividends are fully reinvested (at the ex-div stock price), what is the geometric average annual return for an investment in stock ABC from 26/4/2017 to 31/12/2020? Give your answer as a discrete annual rate. b) What is the IRR of an investment in stock ABC from 26/4/2017 to 31/12/2020 assuming you do not reinvest dividends? Give your answer as an annual continuously compounding rate. c) What is the IRR of an investment in stock ABC from 26/4/2017 to 31/12/2020 assuming you do not reinvest dividends and you liquidate half of your shareholding on 31/12/2019 at a stock price of $34.22? Give your answer as an annual continuously compounding rate. I need Quality solution. U will get up vote for quality answer
PLEASE SOLVE THIS QUESTION, ASAP: Q: Suppose a company estimates following one year returns from investing in the common stock of Leopard Corporation: Possibility of Occurrence .1 .25 .1 .15 .1 .2 .1 Possible returns 15% 30% 15% -10% -5% 20% 10% Required: Calculate Expected return & Risk {Standard Deviation)
The following table shows the expected dividend payments and required rate of return of Globex Corp. Clearly explain the assumptions, if any, you are using to solve below question(s). Year 2021 2022 2023 2024 2025 2026 2027 ke Dividend $ 0.40 $ 0.44 $ 0.48 $ 0.53 $ 0.59 $ 0.61 $0.63 12% 1,Calculate value of Globex Corp share in 2021. 2.The market price of Globex Corp share is $8.50. Based on your answer in (i), is Globex Corp share overvalued, undervalued or fairly priced? Explain clearly.

SEE MORE QUESTIONS

Recommended textbooks for you

Fundamentals Of Financial Management, Concise Edi…

Finance

ISBN:

9781337902571

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning