Good evening,

(Strayer University FIN 550 Corporate Investment Analysis)

I need help with thisthis assignment please? For homework submissions, I require that all work be completed in Excel, which means that you will use the Excel functions to arrive at the answer. I should be able to click on the cell that holds your answer, and see the formula you used to arrive at this answer in the function ribbon.I have included the attachment and also copied it here.

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:

Picture in attachment

^a Based on arithmetic mean.

• 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.

• 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.

• 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.

Chapter 7

3.The following are the monthly rates of return for Madison Cookies and for Sophie Electric during a six-month period.

Picture in attachment

Compute the following.

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

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.

Picture in attachment

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: DJIA-S&P500 S&P500-Russell2000 S&P500-Nikkei Russell 2000-Nikkei

The correlation coefficients for the same four combinations

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?