Forecast Home Depots FY2016 income statement, balance sheet, and statement of cash flows using the set of assumptions and requirements

Round all $ forecasts to millions.

Use average historical revenue growth rate to forecast revenue (round the rate to nearest whole percent).

Assume no change for goodwill, interest and investment income, interest expense, short-term debt, common stock and paid-in capital, and accumulated other comprehensive loss.

Capital expenditures were $1,503 million, and dividends were $3,031 million for 2015.

Forecast depreciation as a percentage of net PP&E at the start of the year. Use the historical FY2015 (FY ended January, 2016) rate to forecast FY2016.

HDs long-term debt footnote indicates maturities of long-term debt of $110 million for fiscal 2017.

Assume that Income Taxes Payable is 0.

Assume the company will repurchase $4 billion of common stock in the coming year.

Estimate forecast assumptions for balance sheet and income statement items (other than the long-term debt, provision for income taxes, dividends, and the above-mentioned assumptions) as percentage of revenues, rounded to 3 decimal places (for example, Merchandise inventoryet sales is .1334 or 13.3%). Use the most recent (FY ended January, 2016) and not average rates for the forecasting.

Use cash and cash equivalents as plug

Appendix A Consolidated Statements of Earnings - USD (S) 12 Months Ended shares in Millions, $ in Millions an. 31, 2016 $ 88,519 58,254 30,265 Feb. 01, 2015Feb. 02, 2014 $78,812 51,897 26,915 Net Sales Cost of Sales Gross Profit Operating Expenses: Selling, General and Administrative epreciation Total Operating Expenses Operating Income Interest and Other (Income) Expense: Interest and Investment Income Interest Expensc Interest and Other, net Earnings before provision for income taxes Provision for Income Taxes Net Earnings $ 83,176 54,787 28,389 16,801 1,690 18,491 11,774 16,280 1,640 17,920 10,469 16,122 1,627 17,749 9,166 (12) (166) 919 753 11,021 4,012 7,009 (337) 830 493 9,976 3,631 $ 6,345 699 8,467 3,082 S 5,385 Appendix A Consolidated Statements of Earnings - USD (S) 12 Months Ended shares in Millions, $ in Millions an. 31, 2016 $ 88,519 58,254 30,265 Feb. 01, 2015Feb. 02, 2014 $78,812 51,897 26,915 Net Sales Cost of Sales Gross Profit Operating Expenses: Selling, General and Administrative epreciation Total Operating Expenses Operating Income Interest and Other (Income) Expense: Interest and Investment Income Interest Expensc Interest and Other, net Earnings before provision for income taxes Provision for Income Taxes Net Earnings $ 83,176 54,787 28,389 16,801 1,690 18,491 11,774 16,280 1,640 17,920 10,469 16,122 1,627 17,749 9,166 (12) (166) 919 753 11,021 4,012 7,009 (337) 830 493 9,976 3,631 $ 6,345 699 8,467 3,082 S 5,385