Question: PLEASE ANSWER USING EXCEL A stock is expected to return 35% in a boom, 15% in a normal economy, and lose 65% in a recession.

PLEASE ANSWER USING EXCEL

A stock is expected to return 35% in a boom, 15% in a normal economy, and lose 65% in a recession. The probabilities of a boom, normal economy, and a recession are 5%, 90%, and 5%, respectively. What is the standard deviation of the returns on this stock?

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!

In Excel Place your answer in the corresponding green answer cell for each question. The answer cell must contain a formula that references one or more cells in the work box or -- no hard-coded...

Place your answer in the corresponding green answer cell for each question. The answer cell must contain a formula that references one or more cells in the work box or - no hard-coded numbers in the...

A stock is expected to return 35% In a boom, 15% In a normal economy, and lose 65% in a recession. The probabilities of a boom, normal economy, and a recession are 5%, 90%, and 5%, respectively. What...

A stock is expected to return 35% in a boom, 15% In a normal economy, and lose 65% In a recession. The probabilities of a boom, normal economy, and a recession are 5%, 90%, and 5%, respectively. What...

7. A stock is expected to return 35% in a boom, 15% in a normal economy, and lose 65% in a recession. The probabilities of a boom, normal economy, and a recession are 5%90% and 5%, respectively. What...

18. A stock is expected to return 35% in a boom, 15% in a normal economy, and lose 65% in a recession. The probabilities of a boom, normal economy, and a recession are 5%, 90%, and 5%, respectively....

7. A stock is expected to return 35% in a boom, 15% in a normal economy, and lose 65% in a recession. The probabilities of a boom, normal economy, and a recession are 5%, 90%, and 5%, respectively....

one question please answer quickly 30. Westover stock is expected to return 36 percent in a boom, 14 percent in a normal economy, and lose 75 percent in a recession. The probabilities of a boom,...

Based on Belfry's earnings history over the past 15 years, which have covered various states of the economy, the venture capital execs want Belfry to estimate their overall returns. Given the...

need a little help with these questions thanks! Assume that the economy has an 35% chance of booming, a 37% chance of being normal, and being recessionary the remainder of the time. A stock is...

The supplies and supplies expense accounts at December 31, after adjusting entries have been posted at the end of the first year of operations, are shown in the following T accounts: Determine the...

Benefits of computer networks?

E17.5 (LO 2) (Determine Transaction Price) Jeff Heun, president of Concrete Always, agrees to construct a concrete cart path at Dakota Golf Club. Concrete Always enters into a contract with Dakota to...

Section 2.3: Load and Store Instructions in ARM 26. Show a simple code to load the value 0x55 into locations 0x20000030-0x20000038