Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Financial Management

Authors: William R. Lasher

6th Edition

1439080496, 978-1439080498

More Books

Students also viewed these Finance questions