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 to compute all the values in yellow highlighted areas. Do not hard copy. )
2. Based on your values, provide your investment recommendation and explain why.
3. Consider a 15% margin safety rule and provide your investment recommendation. 
AutoSave CIFE HW4 Valuation WMT Template AO2 C- Page Layout Formulas Home Insert Draw Data Review View Tell me Share Comments ) Calibri (Bady) 11 = = ab, Wrap Text General Y , , wo 27-O 0 Y Fy Conditional Format Call Formatting as Table Styles Paste BI I U E = = Merge & Center $ - % Insert Format Delete Sort Filter Find & Select Analyze Data J19 - X x x A C D E I K L . N 0 P O R S 1 Lint SM Price EV 3 WMT Target 5 Costa es Q2020) MV 144.15 175.53 3753 376.8 37.28 324,235.0 55.3350 153.720.0 2.317.4 394,086.7 57.2320 151.255.0 5.5784 G H Final Data (102020 5 EBITDA Earrings 141,671.00 9,393.00 3.986.00 23,398.00 1.888.00 866.CO 53,383.00 6.982.00 1.388.CO 3,472.30 622.20 SS.SO Farward EPS 1.26 1.53 2.50 0.57 Trwiling EPS 1.20 1.43 2.13 13 0.35 on t4 UHI EWEBITDA PIE 12.63 10.58 17.43 113 24.16 23.94 33.12 17.14 EVENTO PAL 40.2020 9455 5882 72431 9 Target Multiple 10 THB 11 cian 12 13 WMT 14 Cach & Equivalent 15 Prattered & Other 16 Tocal Debt 17 18 DE NATAC-4020211 19 urterly lacker 20 21 Target Multiple 22 BI EV 102022) 23 Bt. WV (1920211 24 ashr Outstanding 25 26 Targst Price:22020) ( 27 Target Price (102021) 9215 Quarterly Estimate 4 - 2.332.0 SV/EBITDA AL 11.1 29 OC Steck Pric/10/2011 30 31 32 33 35 Sheet1 Ready + 100% AutoSave CIFE HW4 Valuation WMT Template AO2 C- Page Layout Formulas Home Insert Draw Data Review View Tell me Share Comments ) Calibri (Bady) 11 = = ab, Wrap Text General Y , , wo 27-O 0 Y Fy Conditional Format Call Formatting as Table Styles Paste BI I U E = = Merge & Center $ - % Insert Format Delete Sort Filter Find & Select Analyze Data J19 - X x x A C D E I K L . N 0 P O R S 1 Lint SM Price EV 3 WMT Target 5 Costa es Q2020) MV 144.15 175.53 3753 376.8 37.28 324,235.0 55.3350 153.720.0 2.317.4 394,086.7 57.2320 151.255.0 5.5784 G H Final Data (102020 5 EBITDA Earrings 141,671.00 9,393.00 3.986.00 23,398.00 1.888.00 866.CO 53,383.00 6.982.00 1.388.CO 3,472.30 622.20 SS.SO Farward EPS 1.26 1.53 2.50 0.57 Trwiling EPS 1.20 1.43 2.13 13 0.35 on t4 UHI EWEBITDA PIE 12.63 10.58 17.43 113 24.16 23.94 33.12 17.14 EVENTO PAL 40.2020 9455 5882 72431 9 Target Multiple 10 THB 11 cian 12 13 WMT 14 Cach & Equivalent 15 Prattered & Other 16 Tocal Debt 17 18 DE NATAC-4020211 19 urterly lacker 20 21 Target Multiple 22 BI EV 102022) 23 Bt. WV (1920211 24 ashr Outstanding 25 26 Targst Price:22020) ( 27 Target Price (102021) 9215 Quarterly Estimate 4 - 2.332.0 SV/EBITDA AL 11.1 29 OC Steck Pric/10/2011 30 31 32 33 35 Sheet1 Ready + 100%
