Question: please explain formulas use and excel instructions beturis to the varket returns from the table below Security Security Year B Market Returns Returns Returns 1

please explain formulas use and excel instructions

beturis to the varket returns from the table below Security Security Year B Market Returns Returns Returns 1 6.00% 11.00% 10.00% 2 5.00% 8.60% 8.50% 3 1.00% 8.20% 7.00% 4 0.00% -3.00% -2.00% 5 -2.00% -7.00% -3.40% 6 5.00% 9.00% 8.25% 7 7.00% 13.90% 14.00% ElR;)=Rf +6 X (E(km) 3. Assume the risk free rate = 2.5% and using the betas from above and market returns from the above table, calculate the following: a. Security Market Line for security A 6,50 25 b. Security Market line for security B C. Security risk premium of security A d. Security risk premium of security B .6.us 15.33 o returns List Istock return-risk free rate 1. Assume the following information: Expected market return -15.23%, market standard deviation - 11.31%, portfolio standard deviation = 8.5%, and the risk-free rate = 4.62%. a. Calculate the expected portfolio return using the Capital Market Line equation b. Calculate the Sharpe ratio C. What is the slope of the Capital Market Line? 2. Calculate the Beta of each security's returns to the Market returns from the table below Market Year Security Security A B Returns Returns Returns 1 6.00% 11.00% 10.00% 2 5.00% 8.60% 8.50% 3 1.00% 8.20% 7.00% 4 0.00% -3.00% -2.00% 5 -2.00% -7.00% -3.40% 6 5.00% 9.00% 8.25% 7 7.00% 13.90% 14.00% 3. Assume the risk free rate = 2.5% and using the betas from above and market returns from the E(Ri)=Rf +6, X (E(Rom) Re above table, calculate the following: a. Security Market Line for security A b. Security Market line for security B c. Security risk premium of security A 25 4.05 - 2.5 15.23

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!

1. On March 1, 2022, Crane Company accepted a two-month, 10%, $9,000 note from Bulldozer, Inc.. in settlement of its open account. The note is due April 30, 2022. Crane appropriately accrued the...

1. Assume the following information: Expected market return = 15.23%, market standard deviation = 11.31%, portfolio standard deviation = 8.5%, and the risk-free rate : 4.62%. a. Calculate the...

- Please provide EXCEL instructions/Explanation _ The person that tried to answer earlier had system issues and could not provide Excel directions/formulas. Thanks! Part 3 1. Assume the following...

please provise excel insructions on how you arrived to answer please and thank you Part 3 1. Assume the following information: Expected market return = 15.23%, market standard deviation 11.31%,...

I want to double-check my answers on this. Getting two different answers. Can you use a spreadsheet so I can try to follow along? Part 3 1. Assume the following information: Expected market return =...

Part 3 1. Assume the following information: Expected market return = 15.23%, market standard deviation = 11.31%, portfolio standard deviation = 8.5%, and the risk-free rate = 4.62%. a. Calculate the...

2. Calculate the Beta of each security's returns to the Market returns from the table below Security Security A B Market Year Returns Returns Returns 1 6.00% 11.00% 10.00% 2 5.00% 8.60% 8.50% 3 1.00%...

You have recently graduated with a major in finance and landed a financial planner job with Barney Smith Inc., a large financial services corporation. Your first assignment is to invest $100,000 for...

The chandelier is supported by three chains which are concurrent at point O. If the resultant force at O has a magnitude of 130 lb and is directed along the negative z axis, determine the force in...

Create a new file singleton_tuple.py. Copy the following code and paste it into the file. Print out the type of singleton_tuple and singleton. What difference did you notice? singleton tuple=...

Given these costs, compute Shannon's projected contribution margin in dollars. Round your answer to the nearest one dollar. DO NOT INCLUDE THE DOLLAR SIGN IN YOUR ANSWER. Assume that projected...

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...