finance homework excel 0
This assignment must be completed in excel. Each problem must have there own sheet and it all goes into one workbook. You can not just state the answer you must use formulas to complete.
6)The following are the historic returns for the Chelle Computer Company:
Based on this information, compute the following:
a.The correlation coefficient between Chelle Computer and the General Index.
b.The standard deviation for the company and the index.
c.The beta for the Chelle Computer Company.
8) As an equity analyst, you have developed the following return forecasts and risk estimates for two different stock mutual funds (Fund T and Fund U):
a.If the risk-free rate is 3.9 percent and the expected market risk premium (i.e., E(R_{M}) ? RFR) is 6.1 percent, calculate the expected return for each mutual fund according to the CAPM.
b.Using the estimated expected returns from Part a along with your own return forecasts, demonstrate whether Fund T and Fund U are currently priced to fall directly on the security market line (SML), above the SML, or below the SML.
c.According to your analysis, are Funds T and U overvalued, undervalued, or properly valued?
10.Draw the security market line for each of the following conditions:
a.(1) RFR = 0.08; R_{M}(proxy) = 0.12
(2) R_{z} = 0.06; R_{M}(true) = 0.15
b.Rader Tire has the following results for the last six periods. Calculate and compare the betas using each index.
c.If the current period return for the market is 12 percent and for Rader Tire it is 11 percent, are superior results being obtained for either index beta?
3.You have been assigned the task of estimating the expected returns for three different stocks: QRS, TUV, and WXY. Your preliminary analysis has established the historical risk premiums associated with three risk factors that could potentially be included in your calculations: the excess return on a proxy for the market portfolio (MKT), and two variables capturing general macroeconomic exposures (MACRO1 and MACRO2). These values are: ?_{MKT}= 7.5%, ?MACRO1 = ?0.3%, and ?MACRO2 = 0.6%. You have also estimated the following factor betas (i.e., loadings) for all three stocks with respect to each of these potential risk factors:
a.Calculate expected returns for the three stocks using just the MKT risk factor. Assume a risk-free rate of 4.5%.
b.Calculate the expected returns for the three stocks using all three risk factors and the same 4.5% risk-free rate.
c.Discuss the differences between the expected return estimates from the single-factor model and those from the multifactor model. Which estimates are most likely to be more useful in practice?
d.What sort of exposure might MACRO2 represent? Given the estimated factor betas, is it really reasonable to consider it a common (i.e., systematic) risk factor?
5.Suppose that three stocks (A, B, and C) and two common risk factors (1 and 2) have the following relationship:
a.If ?_{1} = 4% and ?_{2} = 2%, what are the prices expected next year for each of the stocks? Assume that all three stocks currently sell for $30 and will not pay a dividend in the next year.
b.Suppose that you know that next year the prices for Stocks A, B, and C will actually be $31.50, $35.00, and $30.50. Create and demonstrate a riskless, arbitrage investment to take advantage of these mispriced securities. What is the profit from your investment? You may assume that you can use the proceeds from any necessary short sale.
a. Using regression analysis, calculate the factor betas of each stock associated with each of the common risk factors. Which of these coefficients are statistically significant?
b.How well does the factor model explain the variation in portfolio returns? On what basis can you make an evaluation of this nature?
c.Suppose you are now told that the three factors in Exhibit 9.12 represent the risk exposures in the Fama-French characteristic-based model (i.e., excess market, SMB, and HML). Based on your regression results, which one of these factors is the most likely to be the market factor? Explain why.
d.Suppose it is further revealed that Factor 3 is the HML factor. Which of the two portfolios is most likely to be a growth-oriented fund and which is a value-oriented fund? Explain why.
7)a. Using regression analysis, calculate the factor betas of each stock associated with each of the common risk factors. Which of these coefficients are statistically significant?
b.How well does the factor model explain the variation in portfolio returns? On what basis can you make an evaluation of this nature?
c.Suppose you are now told that the three factors in Exhibit 9.12 represent the risk exposures in the Fama-French characteristic-based model (i.e., excess market, SMB, and HML). Based on your regression results, which one of these factors is the most likely to be the market factor? Explain why.
d.Suppose it is further revealed that Factor 3 is the HML factor. Which of the two portfolios is most likely to be a growth-oriented fund and which is a value-oriented fund? Explain why.
Looking for solution of this Assignment?
WHY CHOOSE US?
We deliver quality original papers |
Our experts write quality original papers using academic databases. |
Free revisions |
We offer our clients multiple free revisions just to ensure you get what you want. |
Discounted prices |
All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount |
100% originality |
We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity |
On-time delivery |
We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay |