Now calculate the beta for each stock using Excel's Slope or Linest function to use estimate...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Now calculate the beta for each stock using Excel's Slope or Linest function to use estimate the slope of the linear regression line, which is beta. Use the S&P 500 index as the market portfolio in finding beta. 5. Now use the CAPM/SML Equation to estimate each stock's required return. Use 8.5% as the required market return and the recent 10-year Treasury rate of 0.85% as the risk- free rate. Would you recommend buying BEST BUY and/or Home Depot if your APR average for each stock from #2 is your expected return? Explain your answer. 6. Construct a graph of the Security Market Line given by the parameters in #5. Point out the SML returns you calculated in #5 on your SML. Also, find and plot BEST BUY's and Home Depot's expected returns from the information given below gathered from their recent Yahoo Finance stock quotes against each stock's beta on your SML graph. Would you recommend buying BEST BUY and/or Home Depot based on this information? Explain your answers. Note: you are evaluating each stock individually, not in comparison in one another. Stock Current Price Estimated Price 1 year from now Annual Expected Dividend (D1) BEST BUY $116.00 Home Depot $280.00 $118.59 $2.20 $6.00 $302.72 7. Now, assume that Home Depot's current price is in equilibrium and is a constant growth stock. What is Home Depot's expected constant growth rate based on your CAPM return? Use price and dividend data from #6. 8. Use the variable dividend growth valuation model to value BEST BUY. Here are the projections. Year 1 dividend 2.40 Dividends are projected to grow 12% annually in years 2 through 4 After year 4, dividends have a projected constant growth rate of 10% Using your Best Buy CAPM required return from # 5, what is your valuation of BEST BUY's common stock today? Would you recommend buying BEST BUY's stock today and why? Use current price in #6 to help aid your recommendation. Now calculate the beta for each stock using Excel's Slope or Linest function to use estimate the slope of the linear regression line, which is beta. Use the S&P 500 index as the market portfolio in finding beta. 5. Now use the CAPM/SML Equation to estimate each stock's required return. Use 8.5% as the required market return and the recent 10-year Treasury rate of 0.85% as the risk- free rate. Would you recommend buying BEST BUY and/or Home Depot if your APR average for each stock from #2 is your expected return? Explain your answer. 6. Construct a graph of the Security Market Line given by the parameters in #5. Point out the SML returns you calculated in #5 on your SML. Also, find and plot BEST BUY's and Home Depot's expected returns from the information given below gathered from their recent Yahoo Finance stock quotes against each stock's beta on your SML graph. Would you recommend buying BEST BUY and/or Home Depot based on this information? Explain your answers. Note: you are evaluating each stock individually, not in comparison in one another. Stock Current Price Estimated Price 1 year from now Annual Expected Dividend (D1) BEST BUY $116.00 Home Depot $280.00 $118.59 $2.20 $6.00 $302.72 7. Now, assume that Home Depot's current price is in equilibrium and is a constant growth stock. What is Home Depot's expected constant growth rate based on your CAPM return? Use price and dividend data from #6. 8. Use the variable dividend growth valuation model to value BEST BUY. Here are the projections. Year 1 dividend 2.40 Dividends are projected to grow 12% annually in years 2 through 4 After year 4, dividends have a projected constant growth rate of 10% Using your Best Buy CAPM required return from # 5, what is your valuation of BEST BUY's common stock today? Would you recommend buying BEST BUY's stock today and why? Use current price in #6 to help aid your recommendation.
Expert Answer:
Answer rating: 100% (QA)
Calculations and Analysis 5 Beta and Required Returns Beta excel SLOPEB2B11A2A11 This formula uses the SLOPE function to calculate the beta for each s... View the full answer
Related Book For
Fundamentals of Corporate Finance
ISBN: 978-0077861704
11th edition
Authors: Stephen Ross, Randolph Westerfield, Bradford Jordan
Posted Date:
Students also viewed these accounting questions
-
1. If a project schedule needs to be adjusted, what trade-offs might have to occur? 2. Who can initiate a change to a project schedule? Why would they do so? When would they do so? Give examples....
-
Bella sells vacuums and shampooers. The vacuums each sell for $60 with variable costs of $20, and the shampooers each sell for $100 with variable costs of $60. Thefixed costs for the store are...
-
Assume that you recently graduated with a major in finance and that you just landed a job as a financial planner with Barney Smith Inc., a large financial services corporation. Your first assignment...
-
I am learning intermediate accounting and how to account for leases. I have a question about the calculation of present value for the right to use of the lease. my example specifically has a...
-
Given the electric flux density determine (a) pv by applying Eq. (4.26), (b) The total charge Q enclosed in a cube 2 m on a side, located in the first octant with three of its sides coincident with...
-
Consider the system shown in Figure, where? Sketch y c (j?) if X c (j?) is as shown in Figure 1. lwl < 1/L. 0. 7/L < lw
-
The relation between a bond's coupon rate and yield rate is known to influence a bond's issuance price. Presented below are coupon rates and yield rates for a selection of corporate bonds. Identity...
-
Everything about the deal was acceptable to PEMEX and Hyundai in September, 2010. The final negotiated price for 7500 new Hyundai Aguila automobiles was 58 Billion KRW (Korean Won). Payment was...
-
K O Points: 0 of 1 Save (Calculating free cash flows) You are considering new elliptical trainers and you feel you can sell 4,000 of these per year for 5 years (after which time this project is...
-
From the slide titled "Enhanced Processor w/PC Tester Circuit" from the lecture segment titled Programming a CPU with Machine Language - The Execution, implement the following division algorithm:...
-
Elite Lawn & Plowing (EL&P) Is a lawn and snow plowing service with both residential and commercial clients. The owner believes that the commercial sector has more growth opportunities and Is...
-
A stock is currently worth $50. Over the next month its price is expected to go up by 5% or down by 5%. Consider a 1-month at-the-money European call option on this stock. Suppose that you want to...
-
A treasury officer in an Australian-based investment bank is performing analysis of the risk of the institutions' financial statements based on the institutions' GAP and Duration GAP. She calculates...
-
Daily sales volume for Winters Convenience Store is shown in the following table: Day Sales Day Sales 1 $622 6 $656 2 $418 7 $689 3 $608 8 $675 4 $752 9 $706 5 $588 10 $725 Develop two-day,...
-
Companies A and B have been offered the following rates per annum on a $20 million 5-year loan, and a bank, acting as intermediary, will charge 0.10% per annum (10 basis points) to arrange and manage...
-
Weaver Corporation had the following stock issued and outstanding at January 1, Year 1: 86,000 shares of $13 par common stock. 10,000 shares of $80 par, 7 percent, noncumulative preferred stock. On...
-
Krysten has written 25 European put options on Ampol Ltd, which is currently trading at $33.72. The option premium received is $1.15 per option contract. The strike price is set at $30. What is the...
-
Decades after the event, Johnson & Johnson (J&J), the 130-year-old American multinational, is still praised for swiftly The company indicated that its response was based on the expectations set forth...
-
Ugh Inc.'s net income for the most recent year was $17,382. The tax rate was 34 percent. The firm paid $3,953 in total interest expense and deducted $4,283 in depreciation expense. What was the cash...
-
You've observed the following returns on Crash-n-Bum Computer's stock over the past five years: 7 percent, -13 percent, 21 percent, 34 percent, and 15 percent. a. What was the arithmetic average...
-
What are the four primary disadvantages of the sole proprietorship and partnership forms of business organization? What benefits are there to these types of business organization as opposed to the...
-
Four independent situations are given below. Assume partners of the existing partnership are Maria Heath and Lisa Curtis. The new partner is Wade Torres. For each situation, prepare the appropriate...
-
Four independent situations are given below. Assume that partners of the existing partnership are Kyle Bowen and Susan Wong. The new partner is Angie Mills. For each situation, prepare the...
-
A cash receipts journal is provided in the Working Papers. Work independently to complete the following problem. David Rice and Tanya Taylor agree to form a partnership on July 1 of the current year....
Study smarter with the SolutionInn App