Market Price = $103.18 # Shares (mm, or millions) = 2,897 Long term debt ($mm from balance sheet) = $45,396 Tax rate (T) = 25% Walmart beta () = 0.66…

Market Price = $103.18

# Shares (mm, or millions) = 2,897

Long term debt ($mm from balance sheet) = $45,396

Tax rate (T) = 25%

Walmart beta (β) = 0.66 

Current risk free rate (rf) = 2.59%

Estimated market risk premium = 6.00%

Estimated underwriter spread = 1.0%

Estimated additional flotation costs = 0.5%

Estimated total flotation cost (as a % of debt face value) = 1.50%

Dividend payout ratio (dividends paid out as a % of net income)2015 = 38.02% 2016= 42.89% 2017= 45.59% 2018= 62.04% 2019 = 91.68%

Net income ($ millions) 2015 = $16363 2016= $14694 2017= $13643 2018= $9862 2019 = 6670

Common equity $ (millions, book value) 2015 = $85937 2016= $83611 2017= $80535 2018= $80822 2019 = 79634

ROE (net income/common equity or NI/CE) 2015 = 19.04% 2016= 17.57% 2017= 16.94% 2018= 12.20% 2019 = 8.38%

Dividend history ($/share) 2015 = $1.91  2016= $1.96  2017= $2.00  2018= $2.04  2019 = $2.08 

Dividend estimates ($/share) 2020 = $2.142021= $2.05 2022= $2.40 2023= $2.48 

Value of equity (market capitalization) = $298912.46

Value of long term debt (use book value) = $45396

Weight of equity = 0.87

Weight of debt = 0.13

The cost of equity can be calculated with the dividend discount model or using CAPM. 

We will start with the dividend discount model: r = D1/P0 + g      We have D1 (2020 expected dividend) and P0 (current stock price), it is g that must be calculated.

The growth rate (assumed constant) for dividends can be calculated two different ways, 1) Calculate “g” using historic or projected trends in dividends per share or 2) Calculating “g” from ROE and reinvestment in the firm:   g = ROE * (1-payout ratio). Read the following questions and clearly answer the question as asked, using the appropriate estimation method for the growth rate. 

Answer below

1)        What is the 3 year growth rate (2020-2023) of expecteddividends? 

Calculate and describe how you arrived at your answer (what were the inputs).

2)         What is the 4 year growth rate (2015-2019) of actualdividends? 

Calculate and describe how you arrived at your answer (what were the inputs).

3)   DISCUSS: Do either of these values seem appropriate? If so, which one and why?

Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more