please show excel work, detailed formulas and on paper. ...

80.2K

Verified Solution

Question

Finance

please show excel work, detailed formulas and on paper.
image
image
Q3. Portfolio Returns (20 points) i stock has mean of 8% and stdey of 18%; ili bond has mean of 6% and stdey of 12%; il correlation b/w stock and bond of -0.4; iv. Risk free rate for cash lending and borrowing is at 2%. a. What is the mean and stdey of a portfolio of that is 60% in stock and 40% In bond (4 points)? I I b. What is the mean and stdey of a fully invested yet unleveraged portfolio in stock and bond, that assign weights based on inverse of VARIANCE risk (4 points)? c. How do you combine portfolio in Q3b with cash to match mean return in Q3a portfolio? What is your cash position? What is the stdey risk of this portfolio? (4 points) d. You want to mix portfolio in Q3b with cash, In order to match the stder risk of portfolio in Q3a. What is your cash position? What is the resulting mean return of the portfolio? (4 points) I e. if you want to target 12% stdey risk per year, how would you combine Q3b risk parity portfolio with cash? What are the portfolio weights in cash, stock, and bond respectively? What are the mean returns for portfolio? (4 point) Q3. Portfolio Returns (20 points) i stock has mean of 8% and stdey of 18%; ili bond has mean of 6% and stdey of 12%; il correlation b/w stock and bond of -0.4; iv. Risk free rate for cash lending and borrowing is at 2%. a. What is the mean and stdey of a portfolio of that is 60% in stock and 40% In bond (4 points)? I I b. What is the mean and stdey of a fully invested yet unleveraged portfolio in stock and bond, that assign weights based on inverse of VARIANCE risk (4 points)? c. How do you combine portfolio in Q3b with cash to match mean return in Q3a portfolio? What is your cash position? What is the stdey risk of this portfolio? (4 points) d. You want to mix portfolio in Q3b with cash, In order to match the stder risk of portfolio in Q3a. What is your cash position? What is the resulting mean return of the portfolio? (4 points) I e. if you want to target 12% stdey risk per year, how would you combine Q3b risk parity portfolio with cash? What are the portfolio weights in cash, stock, and bond respectively? What are the mean returns for portfolio? (4 point)

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students