Purchase Solution

Risk Assessment, Portfolio Management

Not what you're looking for?

Ask Custom Question

Assignment #2: Risk Assessment, Portfolio Management

1. You are given the following long-run annual rates of return for alternative investment instruments:
? US Government T-Bills 3.5%
? Large-cap common stocks 12.1%
? Long-term corporate bonds 6.2%
? Long-term government bonds 5.6%
? Small-capitalization common stock 14.6%
The annual rate of inflation during the period was 2.9%. Compute the real rate of return on these investment alternatives.

2. The following are the monthly rates of return for TECO Electric and Gold Hill

Using an excel spreadsheet, compute the following:
a. Average monthly rate of return for each stock
b. Standard deviation of returns for each stock
c. Covariance between the rates of return
d. The correlation coefficient between the rates of return
3. Based on five years of monthly data, you derive the following information for the companies listed:

a. Compute the beta coefficient for each stock
b. Assuming a risk free rate of 5 percent and an expected return for the market portfolio of 12 percent, compute the expected (required) return for all the stocks.
c. Plot the following estimated returns for the next year on the SML and indicate which stocks are undervalued or overvalued.
? Johnson and Johnson-15%
? Exxon Mobil-10%
? Pfizer-13%
? Microsoft-20%
4. The following are the historic returns for the Columbia Sportswear Company (COLM) and the General Index:

Based on this information, and using an excel software, compute the following:
a. The correlation coefficient between COLM and the General Index.
b. The standard deviation for the company and the Index
c. The beta for the COLM.

Purchase this Solution

Solution Summary

This post has multiple queries. It shows how to calculate real rate, average monthly rate and standard deviation of return. It shows how to calculate correlation coefficient, beta coefficient etc.

Solution Preview

See the attached file. Thanks

1.      You are given the following long-run annual rates of return for alternative investment instruments:
·         US Government T-Bills 3.50%
·         Large-cap common stocks 12.10%
·         Long-term corporate bonds 6.20%
·         Long-term government bonds 5.60%
·         Small-capitalization common stock 14.60%
The annual rate of inflation during the period was 2.9%. Compute the real rate of return on these investment alternatives.

Inflation 2.90%
Real rate of return = r real=(1+rnominal)/(1+inflation)-1
·         US Government T-Bills 0.5831%
·         Large-cap common stocks 8.9407%
·         Long-term corporate bonds 3.2070%
·         Long-term government bonds 2.6239%
·         Small-capitalization common stock 11.3703%

2.      The following are ...

Purchase this Solution


Free BrainMass Quizzes
Learning Lean

This quiz will help you understand the basic concepts of Lean.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Basics of corporate finance

These questions will test you on your knowledge of finance.

Motivation

This tests some key elements of major motivation theories.