Chapter 3: Problems 3, 4, and 5
Chapter 7: Problems 3(a-d), 7(a-e), and 8
Do Not Use Online resources to get the answers a 0 will be given!!!
There are just a couple of housekeeping notes that I want to mention. As I’ve repeated several times, my requirement is for you to do the homework in Excel, showing me your formulas in the function ribbon. There is an excellent “Excel Toolkit” link in the left sidebar of the course shell just above the Class Introductions link, which you should all take a look at. It has some very good videos that will step you through the process.
Make sure that you follow my requirements when submitting homework. I want to remind you all that you are required to submit one Excel file with each question clearly labeled and cells must be formatted with formula they will be checked.
3. Using published sources (for example, The Wall Street Journal, Barron’s, Federal Reserve Bulletin), look up the exchange rate for U.S. dollars with Japanese yen for each of the past 10 years (you can use an average for the year or a specific time period each year). Based on these exchange rates, compute and discuss the yearly exchange rate effect on an investment in Japanese stocks by a U.S. investor. Discuss the impact of this exchange rate effect on the risk of Japanese stocks for a U.S. investor.
4. The following information is available concerning the historical risk and return relationships in the U.S. capital markets:
a Based on arithmetic mean.
a. Explain why the geometric and arithmetic mean returns are not equal and whether one or the other may be more useful for investment decision making.
b. For the time period indicated, rank these investments on a relative basis using the coefficient of variation from most to least desirable. Explain your rationale.
c. Assume the arithmetic mean returns in these series are normally distributed. Calculate the range of returns that an investor would have expected to achieve 95 percent of the time from holding common stocks.
5. You are given the following long-run annual rates of return for alternative investment instruments:
U.S. Government T-bills 3.50%
Large-cap common stock 11.75
Long-term corporate bonds 5.50
Long-term government bonds 4.90
Small-capitalization common stock 13.10
The annual rate of inflation during this period was 3 percent. Compute the real rate of return on these investment alternatives.
3.The following are the monthly rates of return for Madison Cookies and for Sophie Electric during a six-month period.
Compute the following.
a. Average monthly rate of return figure 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
What level of correlation did you expect? How did your expectations compare with the computed correlation? Would these two stocks be good choices for diversification? Why or why not?
7. The following are monthly percentage price changes for four market indexes.
Compute the following.
a. Average monthly rate of return for each index
b. Standard deviation for each index
c. Covariance between the rates of return for the following indexes:
S&P 500–Russell 2000
d. The correlation coefficients for the same four combinations
e. Using the answers from parts (a), (b), and (d), calculate the expected return and standard deviation of a portfolio consisting of equal parts of (1) the S&P and the Russell 2000 and (2) the S&P and the Nikkei. Discuss the two portfolios.
8. The standard deviation of Shamrock Corp. stock is 19 percent. The standard deviation of Cara Co. stock is 14 percent. The covariance between these two stocks is 100. What is the correlation between Shamrock and Cara stock?