Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on the picture below why is this stock undervalued or overvalued? P/E Band - Valuation (PEBD): WMT US Equity Export- Settings Equity Relative Valuation

Based on the picture below why is this stock undervalued or overvalued?

P/E Band - Valuation (PEBD):

image text in transcribed

WMT US Equity Export- Settings Equity Relative Valuation Comp Source BICS Best Fit (Algo) Region Global Mkt Cap > Curr USD vs Comps Group Dynamics vs Self Price Bands Valuation Metric Bands Current 2Yr Avg Band (x) Avg+x Avg-x Est (USD) Metric Current Price LTM P/E LTM P/BV LTM P/CF LTM P/S 3M 6M 1Yr 2Yr 5Yr 10Yr 12M Fwd Implied Price a 2Yr Avg Avg+x Avg-x 118.91 118.91 118.91 108.95 118.77 99.12 110.64 124.55 96.73 97.86 109.03 86.69 108.63 127.59 89.67 O 23.9x 4.7x 13.7x 0.7x 21.1x 4.0x 10.5x 0.6x 1.9 0.5 1.2 0.1 23.0x 4.5x 11.7x 0.7x 19.2x 3.5x 9.3x 0.5x 5.17 27.82 9.31 189.58 Price Bands Based On LTM PE Chart Table Track Annotate Zoom M 120 Px = 118.91 (Actual) @ P/E of 23.9x Px = 123.63 @ P/E of 24.9x IPX = 114.19 @ P/E of 23x Px = 104.75 @ P/E of 21.1x IPx = 95.3 @ P/E of 19.2x PX = 85.86 @ P/E of 17.3x Nov Jan Feb Mar Apr May Jun Jul Aug Sep Dec 2017 Oct Nov Dec Jan Feb Mar Apr May Jun 2019 Jul Aug Sep Oct Nov 2018 Suggested Functions DRSK Assess a company's risk health GP Chart securities & technical studies WMT US Equity Export- Settings Equity Relative Valuation Comp Source BICS Best Fit (Algo) Region Global Mkt Cap > Curr USD vs Comps Group Dynamics vs Self Price Bands Valuation Metric Bands Current 2Yr Avg Band (x) Avg+x Avg-x Est (USD) Metric Current Price LTM P/E LTM P/BV LTM P/CF LTM P/S 3M 6M 1Yr 2Yr 5Yr 10Yr 12M Fwd Implied Price a 2Yr Avg Avg+x Avg-x 118.91 118.91 118.91 108.95 118.77 99.12 110.64 124.55 96.73 97.86 109.03 86.69 108.63 127.59 89.67 O 23.9x 4.7x 13.7x 0.7x 21.1x 4.0x 10.5x 0.6x 1.9 0.5 1.2 0.1 23.0x 4.5x 11.7x 0.7x 19.2x 3.5x 9.3x 0.5x 5.17 27.82 9.31 189.58 Price Bands Based On LTM PE Chart Table Track Annotate Zoom M 120 Px = 118.91 (Actual) @ P/E of 23.9x Px = 123.63 @ P/E of 24.9x IPX = 114.19 @ P/E of 23x Px = 104.75 @ P/E of 21.1x IPx = 95.3 @ P/E of 19.2x PX = 85.86 @ P/E of 17.3x Nov Jan Feb Mar Apr May Jun Jul Aug Sep Dec 2017 Oct Nov Dec Jan Feb Mar Apr May Jun 2019 Jul Aug Sep Oct Nov 2018 Suggested Functions DRSK Assess a company's risk health GP Chart securities & technical studies

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions