Do the work and show calculations on this Excel doc A stock has a beta of 1 25 The expected return on the market is 14 , and the risk free rate is 5 2 What must the expected return on this stock be

Question: Do the work and show calculations on this Excel doc. A stock has a beta of 1.25. The expected return on the market is 14%,

Do the work and show calculations on this Excel doc. A stock has a beta of 1.25. The on the market is 14%, and the risk-free rate is 5.2%. What must the on this stock be?

Step by Step Solution

★★★★★

3.46 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

CAPM states the relationship bet... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

1258-B-M-A-C-B(3488).docx

120 KBs Word File

Students Have Also Explored These Related Managerial Accounting Questions!

Phonetex is a medium- size manufacturer of telephone sets and switching equipment. Its primary business is government contracts, especially defense contracts, which are very profitable. The com-pany...

The Weston Company produces gas grills. This years expected production is 20,000 units. Currently, Weston makes the side burners for its grills. Each grill includes two side burners. Westons...

Use the folwing data to answer the requirements in the cells Do not use PV tables or financial calculators. Make all your calculations on the Excel worksheet, including Excel functions. Use cell...

how to use the IF in excel? Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula...

C D 9.50% 0.80 35.00% 12.50% 1.20 20.00% 6.00% 5.00% Evaluating risk and return 2 3 Expected return of Stock X 4 Beta coefficient of Stock X Standard deviation of Stock X returns 6 7 Expected return...

Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 40% standard deviation of expected returns. Stock Y has a 12.5% expected return, a beta coefficient of 1.2, and a 30.0% standard...

show all work and use excel and other graphs if needed thank you ! Excel Online Structured Activity: Evaluating risk and return Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a...

ty: Evaluating risk and return Excel Online Structured Activity: Evaluating risk and return Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 40% standard deviation of expected...

Excel Online Structured Activity: Evaluating risk and return Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 30 % standard deviation of expected returns. Stock Y has a 12.5%...

Excel Online Structured Activity: Evaluating risk and return Stock X has a 10.0% expected return, a beta coefficient of 0.9, and a 35% standard deviation of expected returns. Stock Y has a 12.5%...

Use the data from Exercise 11.7 and find Bonferroni-corrected intervals for all three comparisons assuming an overall confidence level of 95%, that is, an individual confidence level of 98.33%. Then...

Vulcan Molding has three production departments: A, B, and C. At the start of the year, the company estimated that it would incur $2,500,000 of direct labor cost and $8,000,000 of manufacturing...

What is organizational learning strategy?

11. Is fiscal or monetary policy more effective in combating unemployment under the flexible money price system? Give reasons for your answer.

Using Mohrs circle, prove that the expression Ix Iy I2x'y' is independent of the orientation of the x and y axes, where Ix' , Iy , and Ixy represent the moments and product of inertia, respectively,...

Using the invariance property established in the preceding problem, express the product of inertia Ixy of an area A with respect to a pair of rectangular axes through O in terms of the moments of...

A thin semicircular plate has a radius a and a mass m. Determine the mass moment of inertia of the plate with respect to (a) The centroidal al axis BB′, (b) The centroidal axis CC′ that...

14 The contingency table below shows the results of a survey of video viewing habits by age. Video Viewing Platfunl Preferred MubilelLaptnp Run Viewer ge Device TV Screen Total 13 to 34 32 28 60 55...

Developing pro forma financial statements and cash flow forecasts depends heavily upon sales forecasts. Imagine you are a financial analyst working for a major stockbroker, and you are trying to...

Find the present value of $500 due in 3 years at a discount rate of 6%. $595.51 $470.00 $590.00 $419.81 $1,500.00 Find the present value of $500 due in 3 years at a discount rate of 6%. $595.51...