No other documents or information was provided
Forecast Home Depots FY2016 income statement, balance sheet, and statement of cash flows using the set of assumptions and requirements outlined below.
FIN4035 FINANCIAL INFORMATION AND VALUATION DUE DATE: NoVEMBER 20 Instructions: This is an individual assignment. It consists of one problem and the points are indicated in parentheses. You are not allowed assignment at the beginning of class on the due date indicated above. In order to get any credit for this assignment you need to show your work. Please make sure that you write your name on top of each page of your submission. to work with your team or to discuss the assignment with anyone else. Please h and in your Problem 1 (20pts) Appendix A contains the financial statements of Home Depot Inc. for fiscal year ended January 31, 2016 Forecast Home Depot's FY2016 income statement, balance sheet, and statement of cash flows using the set of assumptions and requirements outlined below ound 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 forccast FY2016. HD's long-term debt footnote indicates maturities of long-term debt of $110 milion 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 Usc cash and cash equivalents as plug. . FIN4035 FINANCIAL INFORMATION AND VALUATION DUE DATE: NoVEMBER 20 Instructions: This is an individual assignment. It consists of one problem and the points are indicated in parentheses. You are not allowed assignment at the beginning of class on the due date indicated above. In order to get any credit for this assignment you need to show your work. Please make sure that you write your name on top of each page of your submission. to work with your team or to discuss the assignment with anyone else. Please h and in your Problem 1 (20pts) Appendix A contains the financial statements of Home Depot Inc. for fiscal year ended January 31, 2016 Forecast Home Depot's FY2016 income statement, balance sheet, and statement of cash flows using the set of assumptions and requirements outlined below ound 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 forccast FY2016. HD's long-term debt footnote indicates maturities of long-term debt of $110 milion 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 Usc cash and cash equivalents as plug
