# Finance homework in Excel

**NicholasHawkins**

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.

- 5 years ago
- 20

**Answer(1)**

Purchase the answer to view it

- chapter_8_and_9.xlsx

**Bids(0)**

**other Questions(10)**

- POST FOR HANDSHAKE
- presentation slide/ read thorough before responding
- Operations Management
- FIN-534-Homework-Chapter-2
- Discussion: Computer Ethics in the Workplace
- Just For Peter Arthur Only
- BUS 311 Week 4 Multimedia activity Business Organization. Get an A++.
- A Restaurant Offers Dinners With A Choice Each Of Two Salads , Six Entrees , And Five Desserts. Find The Total...
- Assignment 7
- PHILOSOPHY EXAM

### HOMEWORK

CHAPTER 8

QUESTION 6

The following are the historic returns for the Chelle Computer Company:

…

6 years ago### FIN 550 Week 4 Homework

**Do Not Use Online resources to get the answers a 0 will be given!!!****Make sure that you follow my requirements when submitting homework. I want to remind you all that you are required to submit …**4 years ago### Homework Week 4 Due 7/28/2018 Saturday 9pm EST

Please see attached file and use work or excel as necessary. Please make sure to show all work. Please include the questions in your answers as well .DO NOT delete the questions.

3 years ago### Finance Homework - Week 4

NOT RATEDI am attaching the questions as an excel file. Each question is on a separate sheet.

9 years ago### Homework in excel with formulas 12pm.

NOT RATEDThe homework has to be completed in the excel workbook provided. calculations have to be completed using formulas.

5 years ago### FIN 550 WEEK 4 HOMEWORK

NOT RATED**PLEASE COMPLETE IN****:****SEE ATTACHED PROBLEMS**Chapter 8: Problems 6(a-c), 8(a-c), and 10(a-c)

Chapter 9: Problems 3(a-d), 5(a-b), and 7(a-d)

3 years ago