Question

ACT 5140 – Accounting for Decision Makers HW #1 Directions: Answer all the questions. Please submit your work in Word or PDF formats only. You can submit an Excel file to support calculations, but please “cut and paste” your solutions into the Word or PDF file. Be sure to show how you did your calculations. Also, please be sure to include your name at the top of the first page of your file. Question #1 • Using the accompanying financial statements (Excel Workbook), assess The Home Depot concerning liquidity, solvency, profitability, and stock performance. For each area, you should calculate the ratios from the “Ratios for Home Depot file “ and provide a brief analysis of the ratios calculated. You do not need to perform vertical analysis for this assignment. I include historical stock price information and outstanding common share information below. You do not need to look beyond the financial statements to complete this assignment. Fiscal Year Ended 2/1/2015 2/2/2014 2/3/2013 1/29/2012 Adjusted Closing Price $103.34 $74.44 $63.87 $41.67 Common Shares Outstanding (millions) 1,307 1,380 1,486 1,523 HOME DEPOT INC $ in millions Year Ending 2/1/2015 2/2/2014 2/3/2013 1/29/2012 OPERATING ACTIVITIES: Net earnings $6,345 $5,385 $4,535 $3,883 Adjustments to reconcile net earnings to net cash provided by operating activities: Depreciation and amortization 1,786 1,757 1,684 1,682 Stock-based compensation expense 225 228 218 215 Goodwill impairment (323) 0 97 0 Changes in Assets and Liabilities, net of the effects of acquisition and disposition Receivables, net (81) (15) (143) (170) Merchandise inventories (124) (455) (350) 256 Other current assets (199) (5) 93 159 Accounts payable and accrued expenses 244 605 698 422 Deferred revenue 146 75 121 (29) Income taxes payable 168 119 87 14 Deferred income taxes 159 (31) 107 170 Other long-term liabilities (152) 13 (180) (2) Other 48 (48) 8 51 Net cash provided by operating activities $8,242 $7,628 $6,975 $6,651 INVESTING ACTIVITIES: Capital expenditures (1,442) (1,389) (1,312) (1,221) Proceeds from sales of investments 323 0 0 0 Proceeds from sale of business 0 0 0 101 Payments for business acquired (200) (206) (170) (65) Proceeds from sales of property & equipment 48 88 50 56 Net cash used by investing activities ($1,271) ($1,507) ($1,432) ($1,129) FINANCING ACTIVITIES: Proceeds from short-term borrowings, net 290 0 0 0 Proceeds from long-term borrowings, net of discount 1,981 5,222 0 1,994 Repayments of long-term debt (39) (1,289) (32) (1,028) Repurchases of common stock (7,000) (8,546) (3,984) (3,470) Proceeds from sales of common stock 252 241 784 306 Cash dividends paid to stockholders (2,530) (2,243) (1,743) (1,632) Other financing activities (25) (37) (59) (218) Net cash used by financing activities ($7,071) ($6,652) ($5,034) ($4,048) Change in Cash and Cash Equivalents ($100) ($531) $509 $1,474 Effect of exchange rate changes on cash and cash equivalents (106) (34) (2) (32) Cash and cash equivalents at beginning of year 1,929 2,494 1,987 545 Cash and cash equivalents at end of year $1,723 $1,929 $2,494 $1,987 SUPPLEMENTAL DISCLOSURE OF CASH PAYMENTS MADE FOR Interest, net of capitalized interest $782 $639 $617 $580 Income taxes $3,435 $2,839 $2,482 $1,865 HOME DEPOT INC $ in millions Year Ending 2/1/2015 2/2/2014 2/3/2013 1/29/2012 OPERATING ACTIVITIES: Net earnings $6,345 $5,385 $4,535 $3,883 Adjustments to reconcile net earnings to net cash provided by operating activities: Depreciation and amortization 1,786 1,757 1,684 1,682 Stock-based compensation expense 225 228 218 215 Goodwill impairment (323) 0 97 0 Changes in Assets and Liabilities, net of the effects of acquisition and disposition Receivables, net (81) (15) (143) (170) Merchandise inventories (124) (455) (350) 256 Other current assets (199) (5) 93 159 Accounts payable and accrued expenses 244 605 698 422 Deferred revenue 146 75 121 (29) Income taxes payable 168 119 87 14 Deferred income taxes 159 (31) 107 170 Other long-term liabilities (152) 13 (180) (2) Other 48 (48) 8 51 Net cash provided by operating activities $8,242 $7,628 $6,975 $6,651 INVESTING ACTIVITIES: Capital expenditures (1,442) (1,389) (1,312) (1,221) Proceeds from sales of investments 323 0 0 0 Proceeds from sale of business 0 0 0 101 Payments for business acquired (200) (206) (170) (65) Proceeds from sales of property & equipment 48 88 50 56 Net cash used by investing activities ($1,271) ($1,507) ($1,432) ($1,129) FINANCING ACTIVITIES: Proceeds from short-term borrowings, net 290 0 0 0 Proceeds from long-term borrowings, net of discount 1,981 5,222 0 1,994 Repayments of long-term debt (39) (1,289) (32) (1,028) Repurchases of common stock (7,000) (8,546) (3,984) (3,470) Proceeds from sales of common stock 252 241 784 306 Cash dividends paid to stockholders (2,530) (2,243) (1,743) (1,632) Other financing activities (25) (37) (59) (218) Net cash used by financing activities ($7,071) ($6,652) ($5,034) ($4,048) Change in Cash and Cash Equivalents ($100) ($531) $509 $1,474 Effect of exchange rate changes on cash and cash equivalents (106) (34) (2) (32) Cash and cash equivalents at beginning of year 1,929 2,494 1,987 545 Cash and cash equivalents at end of year $1,723 $1,929 $2,494 $1,987 SUPPLEMENTAL DISCLOSURE OF CASH PAYMENTS MADE FOR Interest, net of capitalized interest $782 $639 $617 $580 Income taxes $3,435 $2,839 $2,482 $1,865 HOME DEPOT INC $ in millions Year Ending 2/1/2015 2/2/2014 2/3/2013 1/29/2012 OPERATING ACTIVITIES: Net earnings $6,345 $5,385 $4,535 $3,883 Adjustments to reconcile net earnings to net cash provided by operating activities: Depreciation and amortization 1,786 1,757 1,684 1,682 Stock-based compensation expense 225 228 218 215 Goodwill impairment (323) 0 97 0 Changes in Assets and Liabilities, net of the effects of acquisition and disposition Receivables, net (81) (15) (143) (170) Merchandise inventories (124) (455) (350) 256 Other current assets (199) (5) 93 159 Accounts payable and accrued expenses 244 605 698 422 Deferred revenue 146 75 121 (29) Income taxes payable 168 119 87 14 Deferred income taxes 159 (31) 107 170 Other long-term liabilities (152) 13 (180) (2) Other 48 (48) 8 51 Net cash provided by operating activities $8,242 $7,628 $6,975 $6,651 INVESTING ACTIVITIES: Capital expenditures (1,442) (1,389) (1,312) (1,221) Proceeds from sales of investments 323 0 0 0 Proceeds from sale of business 0 0 0 101 Payments for business acquired (200) (206) (170) (65) Proceeds from sales of property & equipment 48 88 50 56 Net cash used by investing activities ($1,271) ($1,507) ($1,432) ($1,129) FINANCING ACTIVITIES: Proceeds from short-term borrowings, net 290 0 0 0 Proceeds from long-term borrowings, net of discount 1,981 5,222 0 1,994 Repayments of long-term debt (39) (1,289) (32) (1,028) Repurchases of common stock (7,000) (8,546) (3,984) (3,470) Proceeds from sales of common stock 252 241 784 306 Cash dividends paid to stockholders (2,530) (2,243) (1,743) (1,632) Other financing activities (25) (37) (59) (218) Net cash used by financing activities ($7,071) ($6,652) ($5,034) ($4,048) Change in Cash and Cash Equivalents ($100) ($531) $509 $1,474 Effect of exchange rate changes on cash and cash equivalents (106) (34) (2) (32) Cash and cash equivalents at beginning of year 1,929 2,494 1,987 545 Cash and cash equivalents at end of year $1,723 $1,929 $2,494 $1,987 SUPPLEMENTAL DISCLOSURE OF CASH PAYMENTS MADE FOR Interest, net of capitalized interest $782 $639 $617 $580 Income taxes $3,435 $2,839 $2,482 $1,865

Answer 1

Contribution per unit selling price per unit - variable cost per unit $100 (46+14) $40 per unit Contribution margin ratio Contribution per unit/selling price per unit $40/ $100 0.40 Fixed Cost - Fixed manufacturing costs Fixed selling and administrative costs -$602000 $802000 -$1404000 a) Break Even Units Fixed cost/ contribution per unit $1404000 S40/unit 35100 units b) Break Even Sales Fixed cost/contribution margin ratio $1404000/0.40 S3510000 C) Number of units to be sold - (Fixed cost+ profit) Contribution per unit ($1404000 $546000) $40/unit - 48750 units d) required net income after tax $273800 Required net income before tax $273800(1-tax rate) $273800/(1-0.375) $438080 Required revenue - (fixed cost+required before tax income)/Contribution margin ratio ($1404000+$438080)/ 0.40 -$4605200 e) Increase in sales volume 15% of 100000 units 15000 units Increase in income before tax Increase in contribution (as fixed cost remains same) 15000 units x $40/unit - $600000 2) Contribution per ticket $175- $25 $150 Number of tickets required to be sold to break even - Fixed cost/contribution per unit $180000/$150 per unit -1200 As the theatre can accommodate only 1000 people, the company should not go for this project. Because by selling 100 tickets the company will incur loss as the minimum number of tickets required to break eve s 1200.

3) Product 1 Product 2 selling price per unit 45.00 S100.00 Less: variable cost per unit: direct material 8.00 14.00 Direct labour 13.00 2200 Selling & administrative costs S 4.00 4.00 Manufacturing overhead costs S 6.00 6.00 31.00 S 46.00 Contribution per unit 14.00 S 54.00 product 1 product 2 Total Number of units sold 80000 20000 contribution per unit 14.00 54.00 Total contribution 11,20,000.00 S10,80,000.00 $ 2200,000.00 Selling price per unit 45.00 100.00 Total sales S 36,00,000.00 S 20,00,000.00 S56,00,000.00 Weighted contribution per unit of sales mix - total contribution/ total number of units sold $2200000 (80000+20000) $22 Fixed selling and administration cost - total cost - variable cost $865000 100000 units x $4/unit $865000 $400000 -$465000 Fixed Manufacturing Overhead $701000 Total fixed cost 465000 701000 $1166000 Breakeven point of the sales mix S1166000 / S22 = 53000 for one sales mix unit Sales mix Product 1 product 2 80000: 20000 4:1 Units of product 1 to be sold to break even (4/5)53000 42400 units Units of product 2 to be sold to break even (1/5)*53000 10600 units Notes: calculation of variable manufacturing overhead cost (1301000-701000)/(80000 20000) $6/unit