Reference no: EM13897938
Question 1 Part A: Using the file Stock Prices, CAPM and ROE.xlsx posted on Blackboard
1) Generate the variance covariance matrix and correlation matrix for all stocks (ignore the portfolio column)
2) Make sure that the variance covariance matrix is fully symmetric
3) Build a variance minimizing portfolio choice model with expected returns and summing up constraints.
4) Assuming non-negativity, generate the EV-Frontier using a strict equality on the income constraint for returns starting at 7%, 10%, 13% up to 40%. a. Record the portfolio standard deviation for each return b. Graph the EV frontier
5) Relax non-negativity and regenerate the model as in (4).
6) Compare and interpret the two graphs in the context of say a mutual fund versus a hedge fund.
7) Assuming that short selling is allowed, add a riskless asset to the mix with a risk free return of 4%. Generate solutions from 4% to 40% and record portfolio standard deviations for each.
8) Plot this curve along with the results in (5). (You can invert the x and y axis if you like).
9) Summarize the stock portfolio solutions for an expected return of 25% for each of the three models (4,5,7). Compare the solutions along with their respective standard deviations.
10) What does the comparison in (8) show? How does this relate to the Capital Asset Pricing Model?
11) Using the correlation matrix develop a model to simulate portfolio returns for solutions at 25% without risk free borrowing and without short-selling (i.e. questions 4). What is the probability that portfolio returns will fall below 20% or rise above 30%?. Question 2. Option Pricing You have been asked by a client to price out a number of possible options on a stock over a six-month period (125 days). The current stock price is $25, and its expected risk neutral drift rate is 5%/year. It is also known that the annual volatility is 35%.
12) The first option is a straight forward vanilla European put option that will pay your client if the stock price falls below $20 as at the last trading day at the end of 6 months.
A) What is the expected payoff to this option?______________.
B) What price would you charge the client for this protection before any transaction fees?__________
13) Your client then asked you to price an option that would payoff only if the average price over the 6 months was less than $20 (e.g. an Asian option).
A) What is the expected payoff to this option?______________. B) What price would you charge the client for this protection before any transaction fees?__________
14) The next option considered was even more exotic. Your client asked you to price an option which would trigger a European put option, with a strike price of $25, if and only if the lowest price observed in the last 30 days of trading was below $20.
A) What is the expected payoff to this option?______________.
B) What price would you charge the client for this protection before any transaction fees?__________
C) What is the probability that the option will be exercised? ___________________
Find the total interest earned
: An investment today of $2,850 will earn 1.5% compounded monthly for the first 21/2 years and 1.75% compounded semi-annually for the next 3 years. Find the total interest earned.
|
What single payment today would settle
: Loan payments of $1,000 that was due 3 MONTHS AGO (and was not paid) and $1,500 due in 6 MONTHS. What single payment today would settle the debt, if money is worth 7% compounded quarterly?
|
Carbon dioxide is a criteria pollutant
: Explain the misconception below with a short essay-Carbon dioxide is a criteria pollutant.
|
Determine impeller diameter
: A lime-soda softening plant treats a flow of 150 MGD, and the water has 86 mg/l CO2. The commercial grade of quicklime has a purity of 85% and the soda ash has a purity of 95%. Determine: The pounds of quicklime and soda ash required per million ga..
|
What is the probability that the option will be exercised?
: What is the probability that the option will be exercised?
|
What is the present worth the given investment
: Uncle Wilbur's trout ranch is now for sale for $30,000. Annual property taxes, maintenance, supplies, and so on are estimated to continue to be $3,000/year. What is the present worth the investment?
|
What sort of transactions should mary undertake in order
: What sort of transactions should Mary undertake in order to hedge
|
Prepare a cash budget for the months of january and february
: Prepare a cash budget for the months of January, February, and March. Determine the amount of additional bank borrowings necessary to maintain a cash balance of $50,000 at all times.
|
What is the npv of the given investment
: Rocky Mountain's tax rate is 34 percent, and its opportunity cost of capital is 10 percent. What is the NPV of this investment?
|