Question: I need this question solved using excel please: Sun Dept Store, a well-known retailer company in the world, has a beta of 1.3 for its

I need this question solved using excel please:

 I need this question solved using excel please: Sun Dept Store,

Sun Dept Store, a well-known retailer company in the world, has a beta of 1.3 for its asset. The risk free rates of 8% include a 2% real rate of interest and 6% inflation premium. The market return is 12%. a. Draw the security market line (SML) and use CAPM to calculate the required return on Sun Dept Store's Asset, and depict the result in the SML drawn. b. Assume that as a result of recent economic event, inflationary expectations have decline by 2%. Compare the new SML below this condition to the SML in part a then calculate and show the new required return for Sun Dept Store's asset. c. Assume that as a result of unstable political condition during the president election; investors have become more risk-averse, causing the market return to rise by 1%. Compare the new SML below this condition to the SML in part a then calculate and show the new required return for Sun Dept Store's asset

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!