Question: please help me this question , using excel A stock has a beta of 1.15 , the expected return on the market is 10.3 percent,

please help me this question , using excel

A stock has a beta of 1.15 , the expected return on the market is 10.3 percent, and the risk-free rate is 3.8 percent. What must the expected return on this stock be? Complete the following analysis. Do not hard code values in your calculations

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!

Please help solve problem 12 and 13 12. Using CAPM A stock has a beta of.93, the expected return on the market is 10.9 percent, and the 13. Using CAPM A stock has an expected return of 11.3 percent,...

Question 2 1 point possible Depending on the market convention, yields can be quoted on a yield (Y) or discount (D) basis. For the same instrument, which of the following is true? (Hint: if you don't...

Indicate whether each statement is true or false, and provide an explanation for your answer. a. A stock is completely uncorrelated with the overall market. This stock will have an expected return...

QUESTION 1 The common stock of Flavorful Teas has an expected return of 20.4 percent. The return on the market is 14 percent and the risk-free rate of return is 3.6 percent. Calculate the beta of...

Please use Excel and show formulas used to solve. 12. Using CAPM A stock has a beta of.93, the expected return on the market is 10.9 percent, and the risk-free rate is 2.7 percent. What must the...

Pre-Course Quiz Online Financial Market Analysis Course--FMAX May 11 - June 29, 2016 Enter the information given in the question in the blue cells, and the intermediate calculations and answers in...

You are given the following information concering MISid Enterprise: a Common Stock: 325,000 shares of common stock selling for $39.97 per share. The stock has a beta of 0.67 and will pay a dividend...

Unless mentioned otherwise, assume: 1) EBIT is a level perpetuity. 2) Tax rate is zero. 3) Market is efficient. 4) CAPM is valid. 5) Bonds are perpetual. Prob1) IBM has a beta of 1. Expected return...

I am having a difficult time on hospitality finance how to solve the formula Question 1 1. One of the first steps in the life of any business is the conversion of the initial cash (contributed by the...

Page 1 of 2 > Note: Please create your own Excel file to conduct the project analysis and make sure of showing all necessary calculation processes to receive credits. Turn-in your Excel file via...

You are saving for retirement. To live comfortably, you decide you will need to save $2 million by the time you are 65. Today is your twenty-second birthday, and you decide, starting today and...

Natural gas is sold by volume. In the United States, the price charged is usually per cubic foot. Given the price per cubic foot, what other information would you need in order to calculate the price...

mgmt of internationsl cookwares believes that delivery performance measures... what is delivery cycle time?

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...