Question: 1. Using the P/E and EV/EBITDA multiple, estimate a fundamental value of Walmart. (ONLY COMPUTE VALUES IN YELLOW ) 2. Based on the values, provide

1. Using the P/E and EV/EBITDA multiple, estimate a fundamental value of Walmart. (ONLY COMPUTE VALUES IN YELLOW )

2. Based on the values, provide an investment recommendation and explain why.

3. Consider a 15% margin safety rule and give an investment recommendation.

*Below are screenshots of an excel sheet- PLEASE ANSWER ASAP, trying to check answers*

1. Using the P/E and EV/EBITDA multiple, estimate a fundamental value of

Walmart. (ONLY COMPUTE VALUES IN YELLOW ) 2. Based on the values,

Trailing EPS 1.20 Financial Data (4Q 2020) Sales (Revenue) EBITDA 141,671.00 9,393.00 23,398.00 1,888.00 53,383.00 6,982.00 3,472.30 622.20 Earnings 3,956.90 866.00 1,389.00 55.50 Forward EPS 1.26 1.53 2.50 0.57 Valuation (last 4 QTR) EV/EBITDA P/E 12.63 10.58 17.43 11.31 1.48 2.13 0.36 24.16 23.94 33.12 17.14 Unit: $M EV WMT Target Costco BJ's Market Data (4Q 2020) Price MV 144.15 176.53 376.8 37.28 324,235.0 55,835.0 153,720.0 2,817.4 394,086.7 67,232.0 151,265.0 6,578.4 EV/EBITDA P/E Target Multiple Average Median 4Q 2020 WMT Cash & Equivalent Preffered & Other Total Debt 9465 6883 72433 9215

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!

Course Textbook Lasher, W. R. (2011). Practical financial management (6th ed.). Mason, OH: South-Western. question1 1) Valuation options The following information refers to a six-month call option on...

Problem 2 Emma Li successfully finished her MBA and now works as the CFO of the Freelancer.com, a major player in the world of online IT outsourcing, with more than 2.9 million projects posted on its...

Need help with a assignment/project. Please prepare a write-up detailing the results of your analysis. You do not need to include a separate section detailing the background of the case in the...

1. Develop an IPS for the following client with the relevant information requested below. Ashley (38) and John (40) Anderson live in West Fargo. Ashley stays home to care for their newbom twins. She...

annssw Consider a two person exchange economy with preferences for person i {1,2} being u(c) and endowments being w, where c = (cc) and the endowment for person 1 is wi (w1,0) with w > 0, and for...

Corporate Finance Course it's about Whole Foods purchase by Amazon. below are the questions need to be answered, also the documents are attached. QUESTIONS: 1.The investment thesis on AMZN has ALWAYS...

1. Using P/E and EV/EBITDA multiple, estimate a fundamental value of Walmart. (You only need to compute all the values in the yellow highlighted areas) 2. Based on your values, provide an investment...

I need help with these SecurityAnalysisFINC questions. This is all the Information provided by prof. 1. Using P/E and EV/EBITDA multiple, estimate a fundamental value of Walmart. (Note: you only need...

6-7; 6-9; 6-12 . I need help with these finance questions. PROBLEM 6-1 Cash provided by operations (CPBO) differs from free cash flow for the following reasons: 1. Solution Legend = Value given in...

Hello there, I need help with my project and homework assignments. Please see attached templates and work problems for more details. Problem 9-4: Traditional WACC Valuation Given Solution Legend Debt...

United Merchants Company sells 32,000 units at $10 per unit. Variable costs are $8.10 per unit, and fixed costs are $18,800. Determine (a) the contribution margin ratio, (b) the unit contribution...

Charter sports Equipment manufactures round, rectangular and octagonal trampolines. Data on sales expenses for the past month follow: Charter sports Equipment manufactures round, rectangular and...

2 To multiply a number by 0.2 divide the number by 10, then multiply by 2 OR multiply the number by 2, then divide by 10. Copy and complete the workings. 30 10 3 and 3x2= -40 and x2= a 300.2 b -400.2...

A citizen-decedent died in 2020 with the following data: Philippines Germany Gross estate P14,200,000 P4,400,000 Allowable deductions 6,400,000 2,200,000 (excluding standard deductions) Estate tax...