In: Finance
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 negative numbers. (Hint: Use the compounded growth rate method to calculate all of the growth rates.)
The sales growth is __%. (Round to three decimal places.)
The cost of goods sold growth is __%. Round to three decimal places.)
The selling, general, and administrative expenses growth is __%. (Round to three decimal places.)
The interest expense growth is __%. (Round to three decimal places)
The projected sales for 2015 is $__ million. (Round to the nearest million dollars.)
The projected cost of goods sold for 2015 is $__million. (Round to the nearest million dollars.)
The projected selling, general, and administrative expenses for 2015 is $__million. (Round to the nearest million dollars.)
The projected interest expense for 2015 is $__ million. (Round to the nearest million dollars.)
Complete the table below. Note: Use parentheses or a minus sign for numbers to be subtracted. (Round to the nearest million dollars.)
Walmart, Inc. |
|||||
Abbreviated Income Statements for the Years Ending January 31, 2012-2015 |
|||||
($ in Millions) |
|||||
Account |
1/31/2012 |
1/31/2013 |
1/31/2014 |
1/31/2015 |
|
Sales |
$446,411 |
$468,651 |
$476,191 |
$ |
|
Cost of goods sold |
$-334,341 |
$-352,168 |
$-357,948 |
$ |
|
Selling, general, and administrative expenses |
$-86,154 |
$-89,074 |
$-91,692 |
$ |
|
EBIT |
$25,916 |
$27,409 |
$26,551 |
$ |
|
Interest expense |
$-2,278 |
$-2,279 |
$-2,251 |
$ |
|
Taxes |
$-8,746 |
$-9,298 |
$-8,991 |
$ |
|
Net income |
$14,892 |
$15,832 |
$15,309 |
$ |
Enter any number in the edit fields and then continue to the next question.