please show excel work, detailed formulas and on paper. ...
80.2K
Verified Solution
Link Copied!
Question
Finance
please show excel work, detailed formulas and on paper.
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!