Question: Please answer using excel!! Suppose MGM has a beta of 3.32 and AEP has a beta of 0.28. If the risk-free interest rate = 4.0%

Please answer using excel!!

Suppose MGM has a beta of 3.32 and AEP has a beta of 0.28. If the risk-free interest rate = 4.0% and the market risk premium = 10%, according to the CAPM:

What is the expected return of MGM stock?

What is the expected return of AEP stock?

What is the beta of a portfolio that consists of 60% of MGM and 40% of AEP?

What is the expected return of that portfolio with the beta that you found in part c.?

What is the beta of a portfolio that consists of 40% of MGM and 60% of AEP?

Please answer using excel!!

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!

SHOW Calculations clearly in Excel Suppose MGM has a beta of 3.32 and AEP has a beta of 0.28.If the risk-free interest rate = 4.0% and the market risk premium = 10%, according to the CAPM: a.What is...

Please submit in Excel Suppose MGM has a beta of 3.32 and AEP has a beta of 0.28.If the risk-free interest rate = 4.0% and the market risk premium = 10%, according to the CAPM: a.What is the expected...

Question: *****Risk and Return, PLEASE SHOW WORK IN EXCEL SO THAT I CAN LEARN**** I need all answers done..... *****Risk and Return, PLEASE SHOW WORK IN EXCEL SO THAT I CAN LEARN**** I need all...

*****Risk and Return, PLEASE SHOW WORK IN EXCEL SO THAT I CAN LEARN**** I need all answers done... Please number 1, 2, 3, 4, 5 Note on reading Ch. 11: you will not calculate standard...

****Risk and Return, PLEASE SHOW WORK IN EXCEL SO THAT I CAN LEARN**** Note on reading Ch. 11: you will not calculate standard deviation/variance using formulas you will use Excel. You can skim over...

1. The Terrapins Investment Fund has a total investment of $500 million in five stocks. Stock Investment (millions) Beta 1 $150 .6 2 120 1.2 3 80 3.0 4 90 1.8 5 60 1.0 Total $500 What is the funds...

3. The Terrapins Investment Fund has a total investment of $500 million in five stocks. Stock Investment (millions) Beta 1 $150 .6 2 120 1.2 3 80 3.0 4 90 1.8 5 60 1.0 Total $500 What is the funds...

Show excel forumla Show excel forumla Suppose MGM has a beta of 3.32 and AEP has a beta of 0.28. If the risk-free interest rate = 4.0% and the market risk premium = 10%, according to the CAPM: a....

Some peopleare notfunctionallyimpairednow,buttheirpulmonaryfunction usuallydeclineswithageandtheyeventually willbefunctionallyimpaired.Assumethat thedecline in...

Read the passage from The Rmyan of Vlmiki His brother, fell before his feet, And cried, "Thy claim all men allow: O come, our lord and king be thou." But Rma nobly chose to be Observant of his sire's...

What does Present Value ( PV ) represent in TVM ? Question 3 options: The future worth of a sum of money The compounded value of an investment The current worth of a future sum of money The total...

The person known as the father of business wrote that "Leadership is about charisma not a set of personality traits. It is about integrity, not responsitlity, but it is also about adherence to goals...

Describe voluntary benefits.

Describe the major job evaluation systems.

Identify the various factors that influence the setting of pay levels.