Question: Using Excel; Calculating Returns and Variability [ LO1 ] You find a certain stock that had returns of 9 percent, 16 percent, 21 percent, and

Using Excel;

Calculating Returns and Variability [LO1] You find a certain stock that had returns of 9 percent, 16 percent, 21 percent, and 17 percent for four of the last five years. If the average return of the stock over this period was 10.3 percent, what was the stocks return for the missing year? What is the standard deviation of the stocks return?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

14. Calculating Returns and Variability (LO1) You find a certain stock that had returns of 9 percent, 16 percent, 21 percent, and 17 percent for four of the last five years. If the average return of...

Chapter 12 Some lessons from Capital Market History Calculating Returns and Variability [LO1] You find a certain stock that had re- turns of 9 percent, -16 percent, 21 percent, and 17 percent for...

Problem 12-14 Calculating Returns and Variability [LO1] You find a certain stock that had returns of 14 percent, -21 percent, 22 percent, and 11 percent for four of the last five years. The average...

Problem 12-14 Calculating Returns and Variability [LO1] You find a certain stock that had returns of 17 percent, 8 percent, 24 percent, and 25 percent for four of the last five years. The average...

Problem 12-14 Calculating Returns and Variability [LO1] You find a certain stock that had returns of 17 percent, 24 percent, 25 percent, and 8 percent for four of the last five years. The average...

Problem 12-14 Calculating Returns and Variability [LO1] You find a certain stock that had returns of 13 percent, 12 percent, 25 percent, and 21 percent for four of the last five years. The average...

Problem 12-14 Calculating Returns and Variability [LO1] You find a certain stock that had returns of 10 percent, 17 percent, 23 percent, and 15 percent for four of the last five years. The average...

512-14 Calculating Returns and Variability (LO1] You find a certain stock that had returns of 18 percent, -23 percent, 16 percent, and 9 percent for four of the last five years. The average return of...

Problem 12-14 Calculating Returns and Variability (LO1] You find a certain stock that had returns of 15 percent, -10 percent, 22 percent, and 23 percent for four of the last five years. The average...

Problem 12-14 Calculating Returns and Variability [LO1] You find a certain stock that had returns of 10 percent, -15 percent, 22 percent, and 18 percent for four of the last five years. The average...

One of the products that McDonalds Corp. sells is the Happy MealR, which consists of a McDonalds food entree, a small order of french fries, a small drink, and a toy. In the early 1990s, McDonalds...

What is cookie? Explain with example.

An investment will pay $15,000 annually. The first payment will start in 6 years and the last payment will end in 16 years. The rate is 12% compounded quarterly. What is the present value of these...

Five athletes were recruited for a research study to see if the time they drink Gatorade has an effect on how refreshing it tastes. They were each given a Gatorade before practice one day (X), and...

(LO 9-3) According to the textbook, an example of a tax risk KPI would be: a. employee turnover of the tax personnel. b. levels of technology/tax training. c. ETR (effective tax rate). d. levels of...

(LO 9-3) According to the textbook, an example of a tax cost KPI would be: a. employee turnover of the tax personnel. b. levels of technology/tax training. c. ETR (effective tax rate). d. levels of...

(LO 9-2) Explain why the needs of the tax accountant are different than the needs of the financial accountants. Why does this lead to a tax data warehouse or tax data mart?