Use the 96 months returns data in the calculations and use the Excel

Use the 96 months returns data in the calculations

This preview shows page 1 - 2 out of 2 pages.

(Use the 96 months returns data in the calculations and use the Excel function“COVARIANCE P”.) (3 Marks) 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 (12 Marks) 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. (10 Marks) 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.
Image of page 1
Comment on the implications of the estimated value of beta for investors and the cost of capital for the two companies
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes