A manager has a $200.0 million portfolio with a beta of 1.40. The risk-free rate is 4.0%, and the market risk premium is 5.0%. The manager expects to receive an additional $50.0 million which they plan to invest in several stocks. After investing the additional funds, they wants the fund's required return to be 12%. What is the required return on their portfolio (before they receive the additional funds)? If they want the fund's required return to be 12% (after they invest the additional $50 million), what must be the beta of the new portfolio? What must the average beta of the new stocks added to the portfolio be to achieve the desired required rate of return?

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter8: Analysis Of Risk And Return
Section: Chapter Questions
Problem 5P
icon
Related questions
Question

A manager has a $200.0 million portfolio with a beta of 1.40. The risk-free rate is 4.0%, and the market risk premium is 5.0%. The manager expects to receive an additional $50.0 million which they plan to invest in several stocks. After investing the additional funds, they wants the fund's required return to be 12%.

What is the required return on their portfolio (before they receive the additional funds)?

If they want the fund's required return to be 12% (after they invest the additional $50 million), what must be the beta of the new portfolio?

What must the average beta of the new stocks added to the portfolio be to achieve the desired required rate of return?

please solve in excel. 

Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Risk and Return
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning