Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

1. Investing in the stock market:

Johnson & Johnson (JNJ) is trading at 68.15 (Sep 12th 2012 close). JNJ is a large health care conglomerate. It has done well so far this year (though not as well as the market) and may continue to do well. You believe that it is less vulnerable to the risks of the “fiscal cliff” and decide to take a closer look at it.
After careful analysis you conclude that in one year the price will be (44, 58, 71, 76, 91) with associated probabilities of (0.1, 0.2, 0.4, 0.2, 0.1). Looking at the company’s past record you determine that JNJ will pay a dividend of 2.52 (two quarterly dividends of 0.61 and two quarterly dividends of 0.65). If you invest your funds risk-free in the money market you will receive 1%.

a. What is the expected return of JNJ stock? What is the risk premium of JNJ stock?

b. find out the standard deviation of the return of JNJ stock (remember that you are using probabilities to do this, not historical data).
You become convinced that this investment opportunity is a good one. In the current conditions JNJ seems like a safe investment. You decide to buy JNJ stock on margin. You purchase 200 shares, financing half with your own investment and borrowing half from your broker.

c. How much do you borrow from your broker? What is your initial margin?
Tomorrow bad news reaches the economy and the price of JNJ stock drops to 44 immediately.

d. What is the new margin on the account? Do you receive a margin call? If you do, assume that you close your position immediately.

e. find out the return on your investment. What would the return have been if you had not borrowed any funds (Hint: what is the return on JNJ stock)?

2. Different choices: Risk-free investment and inflation:

You decide to invest 1000 in a 5-year Treasury Inflation protected bond that each year offers a return of -1.5% plus the rate of inflation. You assume 1-year inflation rates over the next five years of (1.5%, 2%, 2.5%, 2.75%, 3%). This means that the rate of return in the first year is zero.

a. What is the total value of your investment in five years?

b. What is the constant nominal interest rate that would lead to the same value in five years?

c. How would your answers to a. and b. change if inflation is higher than you expected?

3. Stock market investment and average excess returns:

Download annual NYSE stock return (holding period return) data from CRSP. The data is accessible through WRDS. Follow the steps in “Access CRSP on WRDS” (on LATTE). Choose the date range 1960 to 2011. Add this data to the data in “PS1.xls” on LATTE which contains annual risk-free returns (from Ken French’s website).

a. What was the average and standard deviation of NYSE stock returns?

b. What was the average and standard deviation of risk-free returns? What was the average  excess return (the average difference between the stock return and the risk-free return)?

c. Imagine that at the beginning of 1960 you invested 100 each in stocks and the risk-free security. What are the values of your two investments at the end of 2011?

d. What are the two values when starting with 100 in 2001 and investing until the end of 2008?

4. Collect stock return data and analyze it using Excel:

You are interested in analyzing historical stock return data for four U.S. companies that are included in the S&P500: Microsoft, IBM, Exxon Mobil, and Chevron. The ticker symbols for these companies are (MSFT IBM XOM CVX). You can enter them directly like this (no comma).
Download monthly stock return (holding period return) data from CRSP, which is accessible through WRDS. Follow the steps in “Access CRSP on WRDS” (see above). Choose a date range of Jan 1990 to Dec 2011. Open the file in Excel. Note that the output data uses “PERMNO” to identify the firms. These numbers are: MSFT: 10107, IBM: 12490, XOM: 11850, CVX: 14541.

a. For the four series, find out the monthly sample average return. Multiply by 12 to get the annual average return. Which company has the highest, which the lowest return?

b. For the four series, what is the standard deviation of the monthly returns? Multiply by the square root of 12 (3.464) to get the annual standard deviations. How does the standard deviation of these stocks compare to the standard deviation of returns on a portfolio of large stocks (Hint: look at the lecture notes)?

c. Looking at the numbers, do you think it would be a good idea to invest all of your money in one of these stocks?

d. find out the correlations between all pairs of stock returns (a total of six correlations). Which correlations are high, which are low? Why could this be the case?

Some useful Excel commands:

Suppose you have data in cell ranges A1:A10 and B1:B10.
Mean of series A: = AVERAGE(A1:A10)
Variance of series A: =VAR(A1:A10)
Standard deviation of series A: =STDEV(A1:A10)
Covariance between series A and B: =COVAR(A1:A10, B1:B10)
Coefficient of correlation between series A and B: =CORREL(A1:A10, B1:B10)
Square root of a number: SQRT()

5. VaR – value at risk:

Using the data on the four stock return series you downloaded in the previous problem, compare VaR using the normal distribution and VaR from the monthly return data.

a. Based on the monthly sample average returns and standard deviations, what are the values at risk of the monthly stock returns based on the normal distribution? That is, what are the 5th percentiles of the return distributions if you assume that returns are normally distributed?

b. For each series rank the monthly observations (a total of 264 numbers, 5% of which is close to 13.2). Find the 5th percentile of the return distribution by finding the 13th smallest returns.

c. What do you conclude regarding using the normal distribution as an approximation when calculating the size of a large loss (VaR)?

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M91983

Have any Question? 


Related Questions in Basic Finance

1 what are some of the common characteristics of those

1. What are some of the common characteristics of those entrepreneurial growth companies that are able to attract venture capital investment? In which industries and states is the majority of venture capital invested? 2. ...

A student remarks 135000000 shares of general electric were

A student remarks: "135,000,000 shares of General Electric were sold yesterday on the New York Stock Exchange, at an average price of $15 per share. That means General Electric just received a little over $2 billion from ...

Finance stock markettwo pages reponse base on my stock

Finance, stock market Two pages reponse base on my stock portfolio. Choose( Apple Inc.) to write the journal and use the S&P 500 data. ASAP !! Your Module 4 assignment will have two parts: 1. Discuss your stock performan ...

Why can forward rates be viewed as hedgeable rates consider

Why can forward rates be viewed as hedgeable rates? Consider the following yields to maturity: a. Graph the yield to maturity against the time to maturity. b. Is this yield curve consistent with any of the yield curve th ...

People are tempted to spend much more money on a car than

People are tempted to spend much more money on a car than they need to because credit is so easily available. Some students make decisions based on whether they can cover the monthly payment rather than what they need. D ...

Ne at least three ways to reduce the possibility of scc

Name at least three ways to reduce the possibility of SCC ? Which is better, a relatively small anode or a large one and why? Is coating a fastener always helpful in fighting corrosion resistance, even if there are minor ...

Question 1 diane carter is interested in buying a five-year

Question 1: Diane Carter is interested in buying a five-year zero coupon bond with a face value is $1,000. She understands that the market interest rate for similar investments is 9 percent. Assume annual coupon payments ...

Empirical studies have established that the betas of

Empirical studies have established that the betas of conglomerate firms have been significantly above 1. What does this imply about diversification as a strong motive for conglomerate mergers? Over a long period of time ...

How are the payment terms of an fra different from those of

How are the payment terms of an FRA different from those of most other interest rate derivatives? Explain how FRAs are like swaps and how they are different? Compare the use of interest rate options with forward rate agr ...

1 what is the federal agency underwriting function and what

1. What is the federal agency underwriting function and what does it do for the mortgage market, and ultimately for the borrower? 2. Compare and contrast the two categories of bonds and how they differ from mortgage- bac ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro