Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Home Depot, Inc. and Subsidiaries Consolidated Statement of Earnings (amounts in millions, except per share data) ProForma Fiscal Year Ended Forecasted 2010 2011 2012

image text in transcribed

The Home Depot, Inc. and Subsidiaries Consolidated Statement of Earnings (amounts in millions, except per share data) ProForma Fiscal Year Ended Forecasted 2010 2011 2012 2013 2014 2015 ASSUMPTIONS % Net sales $ 66,176 $ 67,997 $ 70,395 2012 growth rate Cost of sales 43,764 44,693 46,133 2012 % of sales Gross profit 22,412 23,304 24,262 Operating expenses: SG&A 15,902 15,849 16,028 2012 % of sales Depreciation 1,707 1,616 1,573 3.5% of Total PP&E Total operating expenses 17,609 17,465 17,601 Total income from operations 4,803 5,839 6,661 Other (income) expense: Interest income (18) (15) (13) 2012 growth rate Interest expense 839 581 606 6% of LT debt Other (income) expense, net 821 566 593 Pre-tax earnings 3,982 5,273 6,068 Provision for income tax 1,362 1,935 2,185 2012 tax rate Net income $2,620 $3,338 $3,883 The Home Depot, Inc. and Subsidiaries Statement of Financial Position (amounts in millions, except per share data) ProForma Fiscal Year Ended Forecasted 2011 2012 2013 2014 2015 ASSUMPTIONS % Assets Cash $ 545 $ 1,987 Plug Accounts receivable, net 1,085 1,245 2012 % of sales Inventories 10,625 10,325 2012 % of sales Other current 1,224 963 2012 % of sales Total current 13,479 14,520 Property and equipment, cost Land 8,497 8,480 Assume no change Buildings 17,606 17,737 Assume no change Furniture & equipment 12,282 12,758 2012 growth rate 38,385 38,975 Less accumulated depreciation 13,325 14,527 PY accumulated depreciation + CY forecasted depreciation expense PP&E, net 25,060 24,448 Goodwill 1,326 1,255 4.5% decrease Other assets 260 295 2012 % of sales Total assets $ 40,125 $ 40,518 Current liabilities: Accounts payable $ 4,717 $ 4,856 2012 % of sales Accrued salaries 1,290 1,372 2012 % of sales Current portion of LT debt 1,042 30 2012 % of sales Other accrued expenses 3,073 3,118 2012 % of sales Total current liabilities 10,122 9,376 LT debt, excluding current portion 8,707 10,758 2012 % of sales Other long-term liabilities 2,407 2,486 2012 % of sales Total liabilities 21,236 22,620 Stockholders' equity: Common stock 86 87 No common stock issued Paid-in capital 7,001 7,259 No common stock issued Retained earnings 14,995 17,246 50% dividend payout rate Treasury stock (3,193) (6,694) No repurchase of stock Total stockholders' equity 18,889 17,898 Total liabilities and stockholders' equity $40,125 $40,518

image text in transcribed The Home Depot, Inc. and Subsidiaries Consolidated Statement of Earnings (amounts in millions, except per share data) Fiscal Year Ended Net sales Cost of sales Gross profit Operating expenses: SG&A Depreciation Total operating expenses Total income from operations Other (income) expense: Interest income Interest expense Other (income) expense, net Pre-tax earnings Provision for income tax Net income $ $ 2010 66,176 43,764 22,412 $ 2011 67,997 44,693 23,304 $ ProForma 2012 70,395 46,133 24,262 15,902 1,707 17,609 4,803 15,849 1,616 17,465 5,839 16,028 1,573 17,601 6,661 (18) 839 821 3,982 1,362 2,620 (15) 581 566 5,273 1,935 3,338 (13) 606 593 6,068 2,185 3,883 $ $ 2013 Assets Cash Accounts receivable, net Inventories Other current Total current Property and equipment, cost Land Buildings Furniture & equipment Less accumulated depreciation PP&E, net Goodwill Other assets Total assets Current liabilities: Accounts payable Accrued salaries Current portion of LT debt Other accrued expenses Total current liabilities LT debt, excluding current portion Other long-term liabilities Total liabilities Stockholders' equity: $ $ $ 545 1,085 10,625 1,224 13,479 8,497 17,606 12,282 38,385 13,325 25,060 1,326 260 40,125 4,717 1,290 1,042 3,073 10,122 8,707 2,407 21,236 2012 $ $ $ 2015 ASSUMPTIONS 2012 growth rate 2012 % of sales % 2012 % of sales 3.5% of Total PP&E 2012 growth rate 6% of LT debt 2012 tax rate The Home Depot, Inc. and Subsidiaries Statement of Financial Position (amounts in millions, except per share data) Fiscal Year Ended 2011 Forecasted 2014 ProForma 2013 Forecasted 2014 2015 ASSUMPTIONS 1,987 1,245 10,325 963 14,520 Plug 2012 % of sales 2012 % of sales 2012 % of sales 8,480 17,737 12,758 38,975 14,527 24,448 1,255 295 40,518 Assume no change Assume no change 2012 growth rate 4,856 1,372 30 3,118 9,376 10,758 2,486 22,620 2012 % of sales 2012 % of sales 2012 % of sales 2012 % of sales % PY accumulated depreciation + CY forecasted depreciation expense 4.5% decrease 2012 % of sales 2012 % of sales 2012 % of sales Common stock Paid-in capital Retained earnings Treasury stock Total stockholders' equity Total liabilities and stockholders' equity $ 86 7,001 14,995 (3,193) 18,889 40,125 $ 87 7,259 17,246 (6,694) 17,898 40,518 No common stock issued No common stock issued 50% dividend payout rate No repurchase of stock

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Basic Finance An Introduction to Financial Institutions, Investments and Management

Authors: Herbert B. Mayo

11th Edition

1285425790, 1285425795, 9781305464988 , 978-1285425795

More Books

Students also viewed these Finance questions

Question

HOW DO ABSORPTION AND VARIABLE COSTING DIFFER?LO.1

Answered: 1 week ago