Question: Stock valuation using the 2-stage dividend discount method: Relevant data is provided below for a public company. Walmart Inc. Expected Annual Dividends Year $2.25 2023

Stock valuation using the 2-stage dividend discount method: Relevant data is provided below for a public company. Walmart Inc. Expected Annual Dividends Year $2.25 2023 $2.29 2024 $2.33 2025 $2.37 2026 1.81% Stage1 dividend growth (g1) 2.00% Stage2 dividend growth (g2) 0.530 Stock Beta () 2.377% Risk-free Rate (Rf) 6.00% Market Risk Premium (MRP) $148.92 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 format:12.34 Hint1: Refer to the video 'Stock Valuation: Dividend discount model' and the Excel template on Blackboard. Hint2: Answer is between 56.64 and 68.60 Hint3: Compute R, CF1, CF2, CF3, and CF4 as shown in the video and then compute NPV; R=5.557%; CF4=$70.47 Note: There is no need to change any underlying Excel formulas.

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!