Compute the coefficient of variation for each stock

Assignment Help Financial Management

Reference no: EM131934730

REQUIRED to complete each assignment in a single EXCEL file with each problem clearly labeled in a separate worksheet within that file. You are required to SHOW ALL CALCULATIONS FORMULAS in the Excel function.

FIN550: Please complete ALL problems in Excel file with each problem calculated on a separate worksheet within that file, clearly labeled with the question number. All formulas are required to be linked in the respective function ribbons for the purpose of authenticating calculations.

Chapter 1: Problems 5(a-d), 7, 9, and 12

Chapter 2: Problems 4(a-b), 5(a-b), and 6(a-b)

Chapter 1 Problems: 5 (a-d), 7,9,12

FIN550 CH2 Problems 4(A-B), 5(A-B), 6

5. During the past five years, you owned two stocks that had the following annual rates of return:

Year	Stock T	Stock B
1	0.19	0.08
2	0.08	0.03
3	-0.12	-0.09
4	-0.03	0.02
5	0.15	0.04

a. Compute the arithmetic mean annual rate of return for each stock. Which stock is most desirable by this measure?

b. Compute the standard deviation of the annual rate of return for each stock. (Use Chapter 1 Appendix if necessary.) By this measure, which is the preferable stock?

c. Compute the coefficient of variation for each stock. (Use the Chapter 1 Appendix if necessary.) By this relative measure of risk, which stock is preferable?

d. Compute the geometric mean rate of return for each stock. Discuss the difference between the arithmetic mean return and the geometric mean return for each stock. Discuss the differences in the mean returns relative to the standard deviation of the return for each stock.

7. A stockbroker calls you and suggests that you invest in the Lauren Computer Company. After analyzing the firm's annual report and other material, you believe that the distribution of expected rates of return is as follows:

Lauren Computer Co.

Possible Rate of Return	Probability
-0.60	0.05
-0.30	0.20
-0.10	0.10
0.20	0.30
0.40	0.20
0.80	0.15

Compute the expected return [E(Ri)] on Lauren Computer stock.

9. During the past year, you had a portfolio that contained U.S. government T-bills, long-term government bonds, and common stocks. The rates of return on each of them were as follows:

U.S. government T-bills 5.50%

U.S. government long-term bonds 7.50

U.S. common stocks 11.60

During the year, the consumer price index, which measures the rate of inflation, went from 160 to 172 (1982 - 1984 = 100). Compute the rate of inflation during this year. Compute the real rates of return on each of the investments in your portfolio based on the inflation rate.

12. Assume that the consensus required rate of return on common stocks is 14 percent. In addition, you read in Fortune that the expected rate of inflation is 5 percent and the estimated long-term real growth rate of the economy is 3 percent. What interest rate would you expect on U.S. government T-bills? What is the approximate risk premium for common stocks implied by these data?

FIN550 CH2 Problems 4(A-B), 5(A-B), 6

4.a. Someone in the 36 percent tax bracket can earn 9 percent annually on her investments in a tax-exempt IRA account. What will be the value of a one-time $10,000 investment in 5 years? 10 years? 20 years?

b.Suppose the preceding 9 percent return is taxable rather than tax-deferred and the taxes are paid annually. What will be the after-tax value of her $10,000 investment after 5, 10, and 20 years?

5.a. Someone in the 15 percent tax bracket can earn 10 percent on his investments in a tax-exempt IRA account. What will be the value of a $10,000 investment in 5 years? 10 years? 20 years?

b.Suppose the preceding 10 percent return is taxable rather than tax-deferred. What will be the after-tax value of his $10,000 investment after 5, 10, and 20 years?

6.Assume that the rate of inflation during all these periods was 3 percent a year. Compute the real value of the two tax-deferred portfolios in problems 4a and 5a.

Reference no: EM131934730

Questions Cloud

What have i had in return for my loyalty and my faith : I placed my trust, even some love with these companies, and what have I had in return for my loyalty and my faith? Absolutely nothing.

What are gains from trade : What are "gains from trade"? What is the primary benefit of trade? Why is the idea that trade is beneficial counterintuitive?

What is the market value of company on last trading day : How many outstanding shares the company has? What is the market value of the company on the last trading day?

Increase in the value of the domestic currency : Explain the effects of an increase in the value of the domestic currency on a firm's revenue under each of the following conditions:

Compute the coefficient of variation for each stock : Compute the coefficient of variation for each stock. (Use the Chapter 1 Appendix if necessary.) By this relative measure of risk, which stock is preferable?

Analyze cases to either reject or not reject null hypothesis : Generate z scores for a variable in grades.sav and report and interpret them. Analyze cases to either reject or not reject a null hypothesis.

What is the uncollected balances schedule : What is the uncollected balances schedule? What advantages does it have over the days sales outstanding and the aging schedule for monitoring receivables?

Define free cash flow : Define free cash flow. Demonstrate whether it is or is not the same as economic profit.

Explain why david hume argues that we are not justified : Explain why David Hume argues that we are not justified in saying that there is a necessary connection between X (the so-called cause) and Y.

User Account

All Pages