Problem 10-14 Spreadsheet Problem: Portfolio Beta and Return (LG10-3) You own the portfolio of five stocks shown below: A B C 1 Value Beta 2 3 Human Genome Frozen Food Express $ 10,600 0.92 $ 12,100 1.34 4 Molecular Device $ 7,800 1.24 5 Pandemic Busters $ 10,200 1.27 6 Zoom Technologies $ 15,100 0.59 Given the amount owned of each stock and their respective betas, what is the beta of your portfolio? If the market return is expected to be 9.5 percent and the risk-free rate is 2 percent, what is the required rate of return for the portfolio? Note: Do not round intermediate calculations and round your answers to 2 decimal places.

Problem 10-14 Spreadsheet Problem: Portfolio Beta and Return (LG10-3) You own the portfolio of five stocks shown below: A B C 1 Value Beta 2 3 Human Genome Frozen Food Express $ 10,600 0.92 $ 12,100 1.34 4 Molecular Device $ 7,800 1.24 5 Pandemic Busters $ 10,200 1.27 6 Zoom Technologies $ 15,100 0.59 Given the amount owned of each stock and their respective betas, what is the beta of your portfolio? If the market return is expected to be 9.5 percent and the risk-free rate is 2 percent, what is the required rate of return for the portfolio? Note: Do not round intermediate calculations and round your answers to 2 decimal places.

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)

8th Edition

ISBN:9781285065137

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter8: Risk And Rates Of Return

Section: Chapter Questions

Problem 4DQ: Select one of the four stocks listed in Question 3 by entering the companys ticker symbol on the...

See similar textbooks

Similar questions

Question content area top Part 1 (Capital asset pricing model) Anita, Inc. is considering the following investments. The current rate on Treasury bills is 7 percent, and the expected return for the market is 12.5 percent. Using the CAPM, what rates of return should Anita require for each individual security? Stock Beta H 0.71 T 1.62 P 0.89 W 1.37 (Click on the icon in order to copy its contents into a spreadsheet.) Question content area bottom Part 1 a. The expected rate of return for security H, which has a beta of 0.71, is enter your response here%. (Round to two decimal places.) Part 2 b. The expected rate of return for security T, which has a beta of 1.62, is enter your response here%. (Round to two decimal places.) Part 3 c. The expected rate of return for security P, which has a beta of 0.89, is enter your response here%. (Round to two decimal places.) Part 4 d. The expected rate of return for…
11. You hold the positions in the table below.COMPANY PRICE # SHARES BETAGoodmonth $25.00 200 + 3.0Icestone $20.00 750 – 1.0Bridgerock $50.00 600 + 2.0A. What is the beta of your portfolio?
Q1) Find the beta of a portfolio of three stocks. One third of the portfolio is invested in each of the stocks. The stocks and their betas are as follows: Mallmart, beta 1.10; Peak Power Co., beta 0.85; and Micro Ease, beta 1.40.
Excel Online Structured Activity: Historical Return: Expected and Required Rates of Return You have observed the following returns over time: Year Stock X Stock Y Market 2011 14 % 12 % 10 % 2012 20 7 9 2013 -13 -2 -13 2014 3 1 2 2015 19 9 12 Assume that the risk-free rate is 4% and the market risk premium is 6%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet What is the beta of Stock X? Do not round intermediate calculations. Round your answer to two decimal places. fill in the blank 2 What is the beta of Stock Y? Do not round intermediate calculations. Round your answer to two decimal places. fill in the blank 3 What is the required rate of return on Stock X? Do not round intermediate calculations. Round your answer to one decimal place. fill in the blank 4 % What is the required rate of return on Stock…
Question Workspace Check My Work (1 remaining) eBook Problem Walk-Through Consider the following information for stocks A, B, and C. The returns on the three stocks are positively correlated, but they are not perfectly correlated. (That is, each of the correlation coefficients is between 0 and 1.) Stock Expected Return Standard Deviation Beta A 9.28% 14% 0.8 B 11.33 14 1.3 C 12.97 14 1.7 Fund P has one-third of its funds invested in each of the three stocks. The risk-free rate is 6%, and the market is in equilibrium. (That is, required returns equal expected returns.) What is the market risk premium (rM - rRF)? Round your answer to two decimal places. % What is the beta of Fund P? Do not round intermediate calculations. Round your answer to two decimal places. What is the required return of Fund P? Do not round intermediate calculations. Round your answer to two decimal places. %
Question 7 The Amelia Knight investment fund has a total capital of R120 000 invested in three shares: SharesReturnInvestedTechnological Sector25%R60 000Education Sector13%R30 000Mining Sector20%R30 000 The current risk-free rate is 5,5%. Market returns have the following estimated probability distribution for the next period: ProbabilityMarket return0,3–10%0,1 14%0,2 15%0,4 18% What is the beta coefficient of the investment fund? 1. 0,52 2. 0,80 3. 1,82 4. 4,92
1. Calculate the value of a preferred stock with a fixed annual dividend of $2.45, assuming a discount rate of 9.5%. Solve the problem two different ways: first by using the algebraic formula for a constant dividend preferred stock, then by using the built-in Excel function PV. hint: Use the Preferred Stock example in the posted DDM Excel Examples file as a guide. Feel free to copy the worksheet and make the minor necessary changes to answer this question. 2. Calculate the value of a stock with an expected annual dividend of $2.00 next year and estimated annual dividend growth of 2% per year indefinitely. Assume a discount rate of 8%. Solve the problem two different ways: first by using the algebraic formula for the Gordon Growth Model, then by using Excel to calculate and sum the dividends and their respective present values for the next 150 years. hint: Use the PV Const Growth Dividend example in the posted DDM Excel Examples file as a guide. Feel free to copy the worksheet and make…
Start with the partial model in the file Ch09 P18 Build a Model.xlsx on the textbook’s Web site. The stock of Gao Computing sells for $50, and last year’s dividend was $2.10. A flotation cost of 10% would be required to issue new common stock. Gao’s preferred stock pays a dividend of $3.30 per share, and new preferred stock could be sold at a price to net the company $30 per share. Security analysts are projecting that the common dividend will grow at a rate of 7% a year. The firm can issue additional long-term debt at an interest rate (or a before-tax cost) of 10%, and its marginal tax rate is 35%. The market risk premium is 6%, the risk-free rate is 6.5%, and Gao’s beta is 0.83. In its cost-of-capital calculations, Gao uses a target capital structure with 45% debt, 5% preferred stock, and 50% common equity.
Start with the partial model in the file Ch09 P18 Build a Model.xlsx on the textbook’s Web site. The stock of Gao Computing sells for $50, and last year’s dividend was $2.10. A flotation cost of 10% would be required to issue new common stock. Gao’s preferred stock pays a dividend of $3.30 per share, and new preferred stock could be sold at a price to net the company $30 per share. Security analysts are projecting that the common dividend will grow at a rate of 7% a year. The firm can issue additional long-term debt at an interest rate (or a before-tax cost) of 10%, and its marginal tax rate is 35%. The market risk premium is 6%, the risk-free rate is 6.5%, and Gao’s beta is 0.83. In its cost-of-capital calculations, Gao uses a target capital structure with 45% debt, 5% preferred stock, and 50% common equity. A: Calculate the cost of each capital component—in other words, the after-tax cost of debt, the cost of preferred stock (including flotation costs), and the cost of equity…
A4 5c Consider the following information on three stocks in four possible future states of the economy: State of economy Probability of state of economy Stock A Stock B Stock C Boom 0.3 0.35 0.45 0.38 Good 0.3 0.15 0.20 0.12 Poor 0.3 0.05 –0.10 –0.05 Bust 0.1 0.00 –0.30 –0.10 stock A: State of economy Probability Rate of return Average (a) (b) (c) (d = b × c)(d = b × c) Boom 0.3 0.35 0.105 Good 0.3 0.15 0.045 Poor 0.3 0.05 0.015 Bust 0.1 0 0 Expected rate of return 0.165 stock B: State of economy Probability Rate of return Average (a) (b) (c) (d = b × c)(d = b × c) Boom 0.3 0.45 0.135 Good 0.3 0.2 0.06 Poor 0.3 -0.1 -0.03 Bust 0.1 -0.3 -0.03 Expected rate of return 0.135 Stock C: State of economy Probability Rate of return Average (a) (b) (c) (d = b × c)(d = b…
You post a portfolio. What's the beta of the portfolio? STOCK AMOUNT BETA EXPECTED RETURN Mac $5,910 1.6 10.50% Microsoft $1,779 1.72 16.90% Ford $4,629 2.48 15.75% Time $2,724 1.8 11.80%
Using the information below, your Facebook/Burger King/JetBlue portfolio has a beta of: Stock Amount Invested Company's Beta Facebook $5,200 1.68 Burger King $6,200 1.79 JetBlue $8,700 1.00 a. 1.680 b. 1.790 c. 1.420 d. 1.000 e. 1.490