Following are the financial statements of Home Depot, Inc.

Required

Forecast Home Depot's fiscal year ended 2014 income statement, balance sheet, and statement of cash flows. Round the revenue growth rate to the nearest whole percent and forecasts to \(\$\) millions. Estimate forecasted income statement relations to 3 decimal places, for example, Accounts payable/Net sales is \(7.2 \%\) (assume no change for: notes receivable, goodwill, interest income and expense, deferred income taxes, common stock and additional paid-in capital, treasury stock, and accumulated other comprehensive income). Capital expenditures were \(\$ 1,312\) million and dividends were \(\$ 1,743\) million for fiscal year ended 2013. Home Depot's long-term debt footnote indicates maturities of long-term debt of \(\$ 32\) million for 2014. What is our assessment of Home Depot's financial condition over the next year?

Transcribed Image Text:

Amounts in millions Net sales.... Cost of sales.. Consolidated Statements of Earnings Gross profit... Operating expenses Selling, general and administrative. Depreciation and amortization .. Total operating expenses Operating income..... Interest and other (income) expense Interest and investment income. Interest expense... Other..... Interest and other, net Earnings before provision for income taxes. Provision for income taxes.. Net earnings.... February January 3, 2013 29, 2012 $74,754 48,912 25,842 16,508 1,568 18,076 7,766 (20) 632 (67) $70,395 $67,997 46,133 44,693 24,262 23,304 16,028 1,573 15,849 1,616 17,601 17,465 6,661 5,839 (13) 606 January 30, 2011 545 7,221 2,686 $4,535 $3,883 593 6,068 2,185 (15) 530 51 566 5,273 1,935 $3,338