1 from the information below compute the average annual

Reference no: EM13380670

1. From the information below, compute the average annual return, the variance, standard deviation, and coefficient of variation for each asset.

ASSET ANNUAL RETURNS
A 5%, 10%, 15%, 4%
B 6%, 20%, 2%, 5%, 10%
C 12%, 15%, 17%
D 10%, 10%, 20%, 15%, 8%, 7%

2. Based upon your answers to question 1, which asset appears riskiest based on standard deviation? Based on coefficient of variation?

3. RCMP, Inc. shares rose 10 percent in value last year while the inflation rate was 3.5 percent. What was the real return on the stock? If an investor sold the stock after one year and paid taxes on the investment at a 15 percent tax rate, what is the real after-tax return on the investment?

4. Given her evaluation of current economic conditions, Ima Nutt believes there is a 20 percent probability of recession, a 50 percent chance of continued steady growth, and a 30 percent probability of inflationary growth. For each possibility, Ima has developed an interest rate forecast for long-term Treasury bond interest rates:

ECONOMIC INTEREST RATE
FORECAST FORECAST
Recession 6 percent
Constant growth 9 percent
Inflation 14 percent

a. What is the expected interest rate under Ima's forecast?

b. What is the variance and standard deviation of Ima's interest rate forecast?

c. What is the coefficient of variation of Ima's interest rate forecast?

d. If the current long-term Treasury bond interest rate is 8 percent, should Ima consider purchasing a Treasury bond?

Why or why not?

5. Ima is considering a purchase of Wallnut Company stock. Using the same scenarios and probabilities as in problem 10, she estimates Wallnut's return is -5 percent in a recession, 20 percent in constant growth, and 10 percent in inflation.

a. What is Ima's expected return forecast for Wallnut stock?

b. What is the standard deviation of the forecast?

c. If Wallnut's current price is $20 per share and Wallnut is expected to pay a dividend of $0.80 per share next year, what price does Ima expect Wallnut to sell for in one year?

6. EXCEL Spreadsheets are useful for computing statistics: averages, standard deviation, variance, and correlation are included as built-in functions. Below is recent monthly stock return data for ExxonMobil (XOM) and Microsoft (MSFT). Using a spreadsheet and its functions, compute the average, variance, standard deviation, and correlation between the returns for these stocks. What does the correlation between the returns imply for a portfolio containing both stocks?

MONTH XOM RETURN MSFT RETURN
November 4.6% 10.4%
October 0.1% 13.6%
September 1.9% 10.3%
August 3.3% 13.8%
July 4.4% 9.3%
June 1.6% 5.5%
May 0.7% 2.1%
April 9.4% 23.9%
March 0.1% 7.3%
February 3.2% 3.4%

Reference no: EM13380670

Questions Cloud

Solve using excel formulas preferred or clearly write out : solve using excel formulas preferred or clearly write out the steps you took to calculate your answers. round any

Solve using excel formulas preferred or clearly write out : solve using excel formulas preferred or clearly write out the steps you took to calculate your answers.nbspnbsp round

Paper on raytheon corporationnbsp rtn with the following : paper on raytheon corporationnbsp rtn with the following questions that need to be answered find out on raytheon

Part 1 how should regulators verify and validate a banks : part 1 how should regulators verify and validate a banks internal ratings based models. what measures should they use

1 from the information below compute the average annual : 1. from the information below compute the average annual return the variance standard deviation and coefficient of

Your grandmother just died and left you 132500 in a trust : your grandmother just died and left you 132500 in a trust fund that pays 6.5 interest. you must spend the money on your

Magellen industries is analyzing a new project the data : magellen industries is analyzing a new project. the data they have gathered to date is as followsinitial requirement

Surgico a manufacturer of consumer plastic products is : surgico a manufacturer of consumer plastic products is evaluating its capital structure. the balance sheet of the

The managers of ponchoparts inc plan to manufacture engine : the managers of ponchoparts inc. plan to manufacture engine blocks for classic cars from the 1960s era. they expect

User Account

All Pages