Question

In: Finance

Predict the net income for the period ending January​ 31, 2015, by determining the growth rates...

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.

Solutions

Expert Solution

If you have any doubt, ask me in the comment section.


Related Solutions

Eastwind Corp. had $1,000,000 net income in 2015. On January 1, 2015 there were 200,000 shares...
Eastwind Corp. had $1,000,000 net income in 2015. On January 1, 2015 there were 200,000 shares of common stock outstanding. On April 1, 20,000 shares were issued and on September 1, Adcock bought 30,000 shares of treasury stock. On October 1, the company declared a two-for-one stock split. On December 1, 20% stock dividend was issued. There are 30,000 options to buy common stock at $40 a share outstanding. The market price of the common stock averaged $50 during 2015....
Parks Inc. had the following data for the year ending 12/31/2x: Net income = $300; Net...
Parks Inc. had the following data for the year ending 12/31/2x: Net income = $300; Net operating profit after taxes (NOPAT) = $400; Total assets = $2,500; Short-term investments = $200; Shareholders’ equity = $1,800; NOWC = $1200; Operating long-term assets $1,100. What was its return on invested capital (ROIC)?
Tibbs Inc. had the following data for the year ending 12/31/18:Net income = $600; Net...
Tibbs Inc. had the following data for the year ending 12/31/18: Net income = $600; Net operating profit after taxes (NOPAT) = $610; Total assets = $2,500; Short-term investments = $200; Stockholders' equity = $1,800; Total debt = $700; and Total operating capital = $2,500. What was its return on invested capital (ROIC)?           a.         20.95%b.         24.40%c.         30.09%d.         34.66%11. LeCompte Corp. has $330,900 of assets, and it uses only common equity capital (zero debt). Its sales for the last year were $610,000,...
For the period ending December 31, 2020, the consignor will report a net loss from this consignment arrangement amounting to:
On September 1, 2020, a consignor consigned 10,000 units of inventory which costs P12 per unit and sells for P15 per unit. Freight charges of P15,000 were paid by the consignee. The consignee was able to sell 6,000 units from September 1 to November 30, 2020, and incurred. On December 1, 2020, the products were marked to sell for P13 per unit to accommodate the Christmas rush. During December, the consignee was able to sell 3,000 more units. The discounted...
Please Include excel formulas Income Statement for the Year Ending December 31 (Millions of Dollars) 2015...
Please Include excel formulas Income Statement for the Year Ending December 31 (Millions of Dollars) 2015 Net Sales $800.0 Costs (except depreciation) $576.0 Depreciation $60.0 Total operating costs $636.0 Earning before int. & tax $164.0 Less interest $32.0 Earning before taxes $132.0 Taxes (40%) $52.8 Net income before pref. div. $79.2 Preferred div. $1.4 Net income avail. for com. div. $77.9 Common dividends $31.1 Addition to retained earnings $46.7 Number of shares (in millions) 10 Dividends per share $3.11 Balance...
VALIUM’S MEDICAL SUPPLY CORPORATION Income Statement for Years Ending December 31, 2015 and 2014 (in thousands...
VALIUM’S MEDICAL SUPPLY CORPORATION Income Statement for Years Ending December 31, 2015 and 2014 (in thousands of dollars) 2015 2014 Net sales $ 926 $ 836 Less: Cost of goods sold 406 369 Gross profits $ 520 $ 467 Less: Other operating expenses 64 58 Earnings before interest, taxes, depreciation, and amortization (EBITDA) $ 456 $ 409 Less: Depreciation 50 48 Earnings before interest and taxes (EBIT) $ 406 $ 361 Less: Interest 65 59 Earnings before taxes (EBT) $...
Carla Corporation had a net income for the current year ending December 31, 2021 of $1,204,500....
Carla Corporation had a net income for the current year ending December 31, 2021 of $1,204,500. Throughout 2021 the following items were outstanding: ● 413,000 common shares ● 18,500 Class A $3 cumulative preferred shares that were convertible to common shares at a rate of 1:1 ● 49,500 Class B $4 non-cumulative preferred shares that were convertible at a rate of one common share for every two preferred shares. ● $551,000, 8% bonds that were convertible to 14,500 common shares...
The following data relates to Rogers Company for the year ending December 31, 2020: Net Income...
The following data relates to Rogers Company for the year ending December 31, 2020: Net Income for 2020= $920,000 Preferred Stock= 10,000 shares of $100 par 8% cumulative preferred stock were outstanding throughout the year. The preferred stock is non-convertible Common Stock= 300,000 shares of common stock were issued and outstanding throughout the year. No shares were issued or repurchased, and there were no stock splits or dividends. Convertible Bonds= 12% convertible bonds at $4,000,000 face amount. (These bonds were...
Culver Corporation had a net income for the current year ending December 31, 2018 of $1,150,000....
Culver Corporation had a net income for the current year ending December 31, 2018 of $1,150,000. Throughout 2018 the following items were outstanding: ? 440,000 common shares ? 21,000 Class A $3 cumulative preferred shares that were convertible to common shares at a rate of 1:1 ? 49,000 Class B $4 non-cumulative preferred shares that were convertible at a rate of two preferred shares to one common share. ? $470,000, 8% bonds that were convertible to 16,000 common shares ?...
Estimate multiples based on the following: High-growth period = 6 years, net income of $175 on...
Estimate multiples based on the following: High-growth period = 6 years, net income of $175 on sales of $1,350, with book value of equity of $1,125. During the high-growth period, the payout ratio will be 15%, and the firm’s beta of 1.25, risk-free rate of 2% and market risk premium of 5% will remain constant. After the 6-year high-growth period, the growth rate in earnings will drop to 3%. Determine the company’s P/E, PEG, Price to Book Value and Price...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT