Question: I was tasked with comparing and running a regression between Walmart (WMT) and the S&P500. I have already calculated for the return (adjusted price now

I was tasked with comparing and running a regression between Walmart (WMT) and the S&P500. I have already calculated for the return (adjusted price now - adjusted price)/adjusted priceold) and found the equity beta = 0.38 using Excel. The following questions in italics is what I need help with.

1.Get the Risk-Free Rate.

Find the current yield on a U.S. Treasury instrument that you feel represents the risk-free asset for a long-horizon project analysis.

You may get use one of the Treasury constant maturities from the website below:

https://www.federalreserve.gov/releases/h15/

Q: What is the best one to choose, if Walmart's risk free rate on Google is 0.7% , which would be make the most sense? Do I want a longer maturity date that leads to a higher rate of return or one that matches Walmarts risk free rate best? What is the best logic to use when selecting a yield in this case?

2.Get an estimate of the Market Risk Premium from the web site below (use implied equity premium):

http://pages.stern.nyu.edu/~adamodar/

Q: Is the implied equity premium the same as the market risk premium? (In this case, the 5.29% stated for October?

Q: When executing the CAPM equation, ERi= Rf + Bi * (ERm-Rf)

Would it be ERi = Rf + 0.38 * (.0529) OR ERi=Rf + 0.38 * (.0529 - Rf)

Q: How do you tell if a stock is over or underpriced against the cost of equity, what variables do you compare?

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!