Question
1. Consider that 2 investment funds exist. ABC Fund(invested in 50% normal stock and 50% risky bonds) and 123 Fund(invested in 25% High risk stock
1. Consider that 2 investment funds exist. ABC Fund(invested in 50% normal stock and 50% risky bonds) and 123 Fund(invested in 25% High risk stock and 75% normal bonds). Assume you have the following historical data of annual returns:
Return | S.D. | |
Normal Stock | 8% | 20% |
Risky Bonds | 10% | 35% |
High Risk Stock | 14% | 40% |
Normal Bonds | 6% | 10% |
If Normal Stock and Risky Bonds have a correlation coefficient of 0.4 and High-Risk Stock and Normal Bonds have a correlation coefficient of 0 .2. Find the expected return and standard deviation of each Fund.
2. Go to http://mba.tuck.dartmouth.edu/pages/faculty/ken.french/data_library.html
Download 5 Industry Portfolios. Import this data into excel.
- Put the return in annualized decimal form. (multiply each observation by 12/100, do this first) Calculate the mean, variance and standard deviation for each of the five Industries returns.
- Construct covariance and correlation coefficient tables between all five portfolios. Turn in your end results only with homework(not all your excel sheets), save your work, you will come back to this.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started