Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 points Save Am Stock valuation using the 2-stage dividend discount method: Relevant data for Walmart Inc. is provided below. Currently, the Walmart Inc, stock

image text in transcribed
1 points Save Am Stock valuation using the 2-stage dividend discount method: Relevant data for Walmart Inc. is provided below. Currently, the Walmart Inc, stock is trading in the market at $146.81 Walmart Inc. Expected Annual Dividends Year 2.23 2022 2.28 2023 2.32 2024 2.36 2025 - 0000 1.93% Stage 1 dividend growth (91) 2.00% Stage2 dividend growth (92) 0.500 Stock Beta (B) 1.655% Risk-free Rate (RD) 6.00% Market Risk Premium (MRP) $ 146.81 Current Stock Price How much is the value of this company's stock using the 2-stage dividend discount method? Enter your answer in the following format12.34 Hinti: Refer to the video 'Stock Valuation: Dividend discount model and the Excel template. Answer is between 73.85 and 94 Hint2: Compute R. CF1, CF2, CF3, and CF4 as shown in the video and then compute NPV, R=4.655%, CF4=$93 20 Note: There is no need to change any underlying Excel formulas

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_2

Step: 3

blur-text-image_3

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

Regulation Of Securities Markets And Transactions

Authors: Patrick S. Collins

1st Edition

0470601965, 978-0470601969

More Books

Students also viewed these Finance questions