Reference no: EM131088051
Jane is considering investing in three different securities or creating three distinctive two-factor portfolios. She is able to obtain the monthly returns of securities A, B & C for the years 2007 to 2014 (The attached file (Stock returns 2007-14) gives 96 monthly returns for three securities along with the returns of the NZX all share index for the period January 2007 and December 2014).
In any of the possible two factor portfolios, the weight of each security in the portfolio will be 50%. The three possible portfolio combinations are AB, AC and BC.
Required:
a) Determine, using the appropriate Excel function (see fx) the average monthly return, the standard deviation and variance for each of the companies. (Use the 96 months returns data in the calculations and use the Excel functions identified as “Variance P” and “Standard Deviation P”.)
b) Determine, using the appropriate Excel function the covariances between securities A&B; B&C; A&C. (Use the 96 months returns data in the calculations and use the Excel function“COVARIANCE P”.)
c) Calculate using the two-factor portfolio equations, the portfolio returns and risks (standard deviation and variance) for the following portfolios:
a.A and B
b.B and C
c.C and A
d)Would you recommend that Jane invest in the single securities of A, B or C or the portfolios consisting of securities A&B or A&C or B&C? Explain your answer from a risk-return view point.
e)Determine the betas Security A, a utility company, security B, a construction company, and security C, a manufacturing company by regressing the returns foreach of the companies on the returns for the NZX ALL Share Index (the first column in the spread-sheet).
(Regression Calculation: Go to Data Analysis - far right under Data- and choose regression. If Data Analysis does not appear it must be added, it will be available in Excel. Go to Options under File and choose Add-ins and then Data Analysis the company returns constitute the Y input and the index returns the X input. Alternatively, the “slope” found in f(x) also represents Beta).
a. Explain what the values of the betas (the slope coefficients in the regression) indicate and discuss the factors that might explain the differences in the values of the betas of the three companies.
b. Comment on the implications of the estimated value of beta for investors and the cost of capital for the two
|
Discount glassmakers free cash flows-interest tax savings
: Best Window & Door Corporation is considering the acquisition of Glassmakers Inc. Glassmakers has a capital structure consisting of $5 million (market value) of 11% bonds and $10 million (market value) of common stock. What discount rate should you u..
|
|
Determines the chains average occupancy rate
: Five Seasons Hotel is a chain with 10 hotels. Strategically, the chain implements a cookie-cutter approach to building and running its hotels, in that all hotels are practically identical. determines the chain’s average occupancy rate—the percent of ..
|
|
What is the total rate of return on the stock
: A stock is selling today for $40 per share. At the end of the year, it pays a dividend of $2 per share and sells for $48. a.) What is the total rate of return on the stock? b.) What are the dividend yield and percentage capital gain?
|
|
Operating cash flow of the project using tax shield approach
: A project will increase sales by $60,000 and cash expenses by $41,000. The project will cost $40,000 and be depreciated using straight-line depreciation to a zero book value over the 4-year life of the project. The company has a marginal tax rate of ..
|
|
Securities or creating distinctive two-factor portfolios
: Jane is considering investing in three different securities or creating three distinctive two-factor portfolios. Determine, using the appropriate Excel function the covariances between securities A&B; B&C; A&C. Determine the betas Security A, a utili..
|
|
What is its self-supporting growth rate
: Maggie's Muffins, Inc., generated $2,000,000 in sales during 2013, and its year-end total assets were $1,100,000. Also, at year-end 2013, current liabilities were $1,000,000, consisting of $300,000 of notes payable, $500,000 of accounts payable, and ..
|
|
Vehicle expected life of three years as delivery vehicle
: You are trying to pick the least-expensive car for your new delivery service. You have two choices: the Scion xA, which will cost $18,000 to purchase and which will have OCF of –$2,000 annually throughout the vehicle’s expected life of three years as..
|
|
Cash flows for three mutually exclusive projects
: Consider the following cash flows for three mutually exclusive projects. What is the IRR of the project you should accept? Assume an interest rate of 12% Year A B C 0 −$950,000 −$1,790,000 -$1,000,000 1 370,000 800,000 660,000 2 510,000 800,000 550,0..
|
|
What is the project payback period if the initial cost
: An investment project provides cash inflows of 200, 400, 670, 890, 1130, 1040, 880, 740, 530, 200, 110, 30 each year starting in year 1. What is the project payback period if the initial cost is $5,600? this must done in excel.
|