Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PER Predicting net income. Abbreviated income statements for Walmart, Inc. are in the popup window Predict the net income for the period ending January 31,

image text in transcribed
image text in transcribed
PER Predicting net income. Abbreviated income statements for Walmart, Inc. are in the popup window Predict the net income for the period ending January 31, 2015, by determining the growth rates of sales, COGS, SG&A, and interest expense Use a tax rate of 37% Note Enter all expenses as regitive numbers wire The interest expense growth is 0323% (Round to three decimal places) The projected sales for 2015 is $ 491921 million (Round to the nearest million dollars) The projected cost of goods sold for 2015 is $-370590) mallion (Round to the nearest million dolas) The projected selling, general, and administrative expenses for 2015 s 5-00693 milion (Round to the nearest mulion dollars) The projected interest expense for 2015 is $ -2343 million (Round to the nearest milion dollars) Complete the table below. Note: Use parentheses or a minus sign for numbers to be subtracted (Round to the nearest milion dollars) Walmart Inc Abbreviated Income Statements for the Years Ending January 31, 2012-2015 15 in Millions) Account 1/31/2012 1/31/2013 1/31/2014 1/31/2015 Sales $ 446,509 5 468 0515 476.294 Cost of goods sold $ 334 393 -352 297 $ 358,000 $ S 89.1485 86.17315 Selling general, and administrative expenses 91.7635 S 27 206 25 943 EBIT 26.40215 $ 2.320 S 22495 23355 interest expense 5 92345 8.74115 89275 Taxes $ 14.8825 15,723 5 15.2008 Net Income lei di capens ds llegar 9 Data Table or st Sell x Walmart, Inc. Abbreviated Income Statements for the Years Ending January 31, 2012-2015 (5 in Millions) Account 1/31/2012 1/31/2013 1/31/2014 1/31/2015 Sales S 446,509 $ 468,651 S 476,294 Cost of goods sold -334,393 $ -352,297 S -358,069 Selling, general and administrative expenses $ -86, 1731$ -89,148$ -91,763 EBIT S 25,943 $ 27 206$ 26.462 interest expense $ 2.320 $ -2.249 $ 2,335 Taxes $ 8.741 $ -9.2345 8.927 Net income $ 14,882 $ 15,723 15,200 Right click on the table and select Copy to Clipboard and then night-click the highlighted texts in the popup dialogue box and select Copy in order to paste its contents into a spreadsheet AB $ nda Print Done TOT TOUT

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Financial management theory and practice

Authors: Eugene F. Brigham and Michael C. Ehrhardt

13th edition

1439078106, 111197375X, 9781439078105, 9781111973759, 978-1439078099

More Books

Students also viewed these Finance questions