Question: Walmart ROIC Tree Outside Assignment Walmart ROIC Tree Outside Assignment Step One: Use Walmart's financial statements to fill in the 2018 data, To calculate the

Walmart ROIC Tree Outside Assignment

Walmart ROIC Tree Outside Assignment Walmart ROICWalmart ROIC Tree Outside Assignment Walmart ROICWalmart ROIC Tree Outside Assignment Walmart ROIC
Walmart ROIC Tree Outside Assignment Step One: Use Walmart's financial statements to fill in the 2018 data, To calculate the tax rate for 2018, divide the income taxes paid for that year by that year's net income. Step Two: Calculate the averages for the years 2013 - 2018. Step Three: Use the attached template format to fill in the average data.EBIT/Sales = COGSIS 1 - 5 (COGS/Sales + Depreciation/Sales + SGA Expense/Sales ) T- PreTax ROIG = EBIT/Sales * Sales/Invested Capital SGA EXPFA SALE Pretax ROID 10.1718 Operating Working ROIC Capital/ Sales invested 1 0.227. 0, 1 150 isepiaI Net PIONA property ROIC = Cash MILIPPE PreTaxROIC * tax rate Sales/Invested Capital = (1- Cash rate on EBIT) On EBIT 1/ X(Operating Working Capital/Sales + NetPPE/Sales + Other Assets/Sales) Other assets/ Sales 0.025%WalMart ROIC Tree Date 2013 2014 2015 2016 2017 2018 Averages COGS/Sales 0.733204 0.733167 0.732853 0.729119 0.723874 Depr/Sales 0.018117 0.018623 0.018882 0.19497 0.020778 SGA Exp/Sales 0.189424 0.191795 0.192361 0.201274 0.209939 Total 0.940745 0.943585 0.944096 1.125363 1.134028 1-Total 0.059255 0.056412 0.055904 -0.12536 -0.13403 OPER WC/Sales -0.02532 -0.01503 -0.0041 -0.00909 -0.19046 Net PPE/Sales 0.2487 0.247559 0.240194 0.241657 0.235355 Other Assets/Sales 0.005691 0.005123 0.000803| 0.000975 0.007317 Total 0.229069 0.237649 0.236899 0.233547 0.216509 1/Total 4.365479 4.207886 4.221208 4.281793 4.618746 Pre-Tax ROIC 0.258678 0.237388 0.235982 -0.12536 -0.61904 1-TxRate 0,779614 0.758543 0.765694 0.774136 0.830012 ROIC 0.201669 0.180069 0.18069 -0.12536 -0.51381 DEADIOUS PROPERANY

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!