Home Depot Questions for Case Discussion 1. Look at page 16 of the case (Selected Financial Data). Note that fiscal 1985 ends on February 2, 1986 (there is a typo on this page; the far left numbers column should be February 2, 1986 instead of February 2, 1985). Evaluate Home Depot’s performance in the following areas: •Growth in Sales •Growth in Total Assets •Change in Net Income •Growth in Long-term Debt 2. Look at page 17 of the case (Management Discussion). Compare 1985 to 1983. Why has return on sales decreased from 4. 0 percent to 1.
percent? What factors might explain the individual category changes from 1983 to 1985? Remember that these are changes in percentage of sales, not in absolute amount. 3. Look at Exhibit A (page 3 of these case questions). Why is Home Depot’s cash flow from operations negative? Where has Home Depot been getting the money to finance acquisition of stores? What would happen to Home Depot if the cash flows for operating, investing, and financing activities for fiscal 1986 (year ending February 1987) were to be exactly the same as for fiscal 1985? 4.
Go back to page 16 and compute debt ratio (total liabilities/total assets) for the most recent five years. Use the accounting equation (Assets = Liabilities + Equities) to compute total liabilities. What do you think about the mix between short-term debt and long-term debt? Note: Total liabilities = Short-term liabilities + long-term liabilities. 5. From the data on page 4, it appears that Home Depot will need approximately $75 million to finance its 1986 expansion plans. Can Home Depot borrow the whole $75 million without violating existing debt covenants? Take a look at their debt covenant on pages 21 and 22 (Note 3 to he Consolidated Financial Statements). As of the end of fiscal 1985, is Home Depot in compliance with: a)the $150,000,000 minimum tangible net worth covenant? b)the 2-to-1 minimum interest coverage covenant (earnings before interest and taxes/net interest expense)? 6. How can Home Depot use leasing to circumvent the debt covenant restrictions? What is the approximate value of property, plant, and equipment that Home Depot is currently using under operating leases? See pages 23 and 24 (Note 5 to the Consolidated Financial Statements) and use present value estimates.
How does the total value of PPE used under operating leases compare to the Net Property and Equipment amount reported on the balance sheet? 7. Consider the pros and cons of the following options for Home Depot regarding 1986: a)Go ahead and build the new stores. Borrow the money to do it. b)Build the new stores. Issue stock to finance the construction. c)Lease the new stores from someone else. d)Slow down, don’t grow so fast. e)Are there any other options??? 8. The questions below require you to work with an Excel spreadsheet; that spreadsheet file will be posted in the Course Documents Blackboard folder. . Using the ratio values in sheet Home Depot A, what is projected Cash Flow From Operations for the 5 years 1986 through 1990? b. In sheet Home Depot A, change the sales growth rate to 10%. Now, what is projected Cash Flow From Operations for the 5 years 1986 through 1990? Are the values higher or lower than those in (a)? Why? c. In sheet Home Depot A, change the sales growth rate back to 40%. Change the value of the Number of Days’ Sales in Inventory ratio from 107. 6 to 66. 2. What is projected Cash Flow From Operations for the 5 years 1986 through 1990? Are the values higher or lower than those in (a)?
Why? d. In sheet Home Depot A, reset Number of Days’ Sales in Inventory to 107. 6. Change the value of Fixed Asset Turnover from 3. 518 to 6. 000. What is projected Cash Flow From Operations for the 5 years 1986 through 1990? Are the values higher or lower than those in (a)? Why? e. In sheet Home Depot A, reset Fixed Asset Turnover to 3. 518. Change the value of Gross Profit Percentage from 25. 86% to 30. 00%. i. What is projected Cash Flow From Operations for the 5 years 1986 through 1990? Are the values higher or lower than those in (a)? Why? ii. What is projected Return on Equity in 1990? iii.
With such a high Return on Equity, why aren’t the projected Cash Flow From Operations numbers better? 6. In sheet Home Depot A, reset Gross Profit Percentage to 25. 86% (just to put everything back to the way it was in the beginning). Now, switch to sheet Home Depot B. i. What is projected Cash Flow From Operations for the 5 years 1986 through 1990? Are the values higher or lower than those in (a)? Why? ii. What is the projected balance in Short-term Loans Payable at the end of each year for the 5 years 1986 through 1990? iii. What is the projected current ratio at the end of each year for the 5 years 1986 through 1990? iv.
What is the projected balance in Paid-in Capital at the end of each year for the 5 years 1986 through 1990? 7. As of the beginning of fiscal 1986, would you loan Home Depot $75 million? Note: The numbers in the spreadsheet are in millions. The loan would replace existing long-term debt, so the total long-term as indicated in the spreadsheet would not change. Assume: i. That the ratios in sheet Home Depot A are expected to prevail. ii. That the ratios in sheet Home Depot B are expected to prevail. For both situations, A and B, briefly justify your loan decision using your projected financial statement data. THE HOME DEPOT Questions 1.
Home Depot’s Stock Price Dropped 23% between January 1985 and February 1986. What Were the Reasons for this Decline? 2. Should the Company Change its Strategy? THE HOME DEPOT Strategic Analysis The Home Depot Pioneered the Concept of Warehouse Retailing in the Home Centre Industry. The Company’s Strategy Consists of: 1. Focusing on the Do-It-Yourself Segment of the Market; 2. Keeping Costs through Low Overhead, Purchase Discounts, and High Turnover; 3. Attracting Customers through Aggressive Advertising and Competitive Pricing; 4. Providing High Service to the Target Customer Group through Well-Trained Employees and Well-Stocked Stores;
THE HOME DEPOT Financial Analysis (1) 1. The Home Depot Is Experiencing Declining ROEs (AVG): 45. 5% in 1982; 24. 5% in 1983; 19. 4% in 1984; 9. 7% in 1985; 2. This Decline in ROEs Is Explained by Declining ROAs and Obtains in Spite of Increasing Financial Leverage: ROA (AVG) FL (AVG) 1983 14. 8% 1. 7 1984 8. 0% 2. 4 1985 2. 6% 3. 7 3. The Decline in ROAs Is Explained by Both Declines in ROSs and Declines in ATs: ROS AT (AVG) 1983 4. 0% 3. 7 1984 3. 3% 2. 4 1985 1. 2% 2. 2 THE HOME DEPOT Financial Analysis (2) 1983 1984 1985 Sales Growth (%) +117. 8 +68. 9 +61. 9 Earnings Growth (%) +93. 1 +37. 6 (41. 8) Assets Growth (AVG %) 176. 9 +156. 5 +77. 5 Asset Growth (%) 1983 1984 1985 BY +218. 7 +137. 0 +52. 5 AVG +176. 9 +156. 5 +77. 5 EY +137. 0 +218. 7 +137. 0 ?The Company Has Been Increasing its Asset Base by Adding New Stores; ? This Expansion Is Financed to a Large Extent through Debt Leading to Increased Leverage; ? Sales Growth Is However Not Keeping Up with the Rate of Increase in the Asset Base; ? The Lower Asset Turnover Coupled with the Reduced Profitability of Sales Has Led to a Substantial Decline in the Company’s ROE; 4. The Decrease in ROSs (Sales Profitability) Results from Higher COGS, SGA, and NIE as a Percent of Sales;
Fiscal Year 1983 1984 1985 Return on Sales Return on Sales (%) 4. 0 3. 3 1. 2 = Gross Margin (%) 27. 3 26. 4 25. 9 – SGA/Sales (%) 20. 8 20. 6 23. 2 – NIE/Sales (%) – (0. 3) 1. 2 – Tax Expense/Sales (%) 3. 4 2. 8 0. 5 THE HOME DEPOT Financial Analysis (3) 5. The Decrease in Asset Turnover Can Be Explained by: An Increase in Inventory: 75 Days in 1983? 83 Days in 1985; A Decreasing Average Amount of Sales per Square Foot Explained by: A Fairly Steady Number of Transactions per Store; A Fairly Steady Amount of Sales per Transaction; An Increase in the Average Size of Stores; Fiscal Year 1983 1984 1985
Working Capital Ratios Days’ Inventory (365*AVG Inventory/Cost of Sales) 75 82 83 Days’ Receivables (365*Accounts Receivables/Sales) 3 8 4 Days’ Payable (365*Accounts Receivables/Purchases) 35 34 33 Stores Productivity Sales/Store ($ million) 13. 5 13. 9 14. 0 Transactions/Store (000) 446 460 467 Sales/Transaction ($) 30 30 30 Square Feet/Store (000) 74 77 80 Sales/Square Foot 183 180 175 Summary of Financial Analysis The Home Depot Has Been Able to Increase Sales through an Increase in the Number of Stores; The Productivity of these Stores is However Declining, Resulting in Lower Turnover and Profitability; ?
The Company’s Profits Are Not Keeping Pace with its Sales! THE HOME DEPOT Performance Relative to Hechinger Co (1) While Hechinger Appears to Be Experiencing a Decline in Performance, the Decline Is Relatively Small Compared to that of the Home Depot. In General: •Hechinger’s Ratios Are Strong Relative to The Home Depot’s; •Hechinger’s ROSs Are Significantly Better than the Home Depot’s Margins; •Hechinger’s Gross Profit Margins Are Higher and Selling Costs Are Lower; •The Home Depot Has a Higher Turnover; THE HOME DEPOT The Home Depot vs Hechinger Home Depot Hechinger Fiscal Year 83 84 85 83 84 85 ROE (%) 24. 5 19. 4 9. 7 19. 1 8. 9 15. 8 ROA (%) 14. 8 8. 0 2. 6 10. 7 8. 9 7. 1 ROS (%) 4. 0 3. 3 1. 2 5. 3 5. 2 4. 8 AT 3. 7 2. 4 2. 2 2. 0 1. 7 1. 5 FL 1. 7 2. 4 3. 7 1. 8 2. 1 2. 2 •These Differences Could Be Attributed to the Differences in the Two Companies’ Strategies: The Home Depot Follows a Low Margin and High Volume Strategy; Hechinger Seems to Pursue a High Margin Strategy; •Hechinger Is Financially Much Stronger than The Home Depot as Indicated by the Differences in the Two Companies’ Financial Leverage. This Could Become a Competitive Liability for The Home Depot if There Is a Price War in the Industry; THE HOME DEPOT Cash Flow Analysis (1) The Company Has a Negative Cash Flow from Operations in Each of the Three Years: This Need Not Necessarily Be Alarming as the Home Depot Is a Growth Company; However What Is Potentially Alarming Is the Huge Increase in the Negative Cash Flow from Operations between 1984 and 1985, Primarily Due to a Large Inventory Increase; The Negative Cash Flow from Operations Is Exacerbated by the Decline in Margins; •The Significant Investment in Property and Equipment Was a Second Reason for the Company’s Cash Deficit: In 1985, the Company’s Expansion Required an Investment of $90m; Since the Company’s Operations Generated Negative Cash Flow, this Investment Had to Be Funded through External Sources; •Most of the Company’s Cash Needs Are Financed through Long-Term Debt: In 1984, the Company Borrowed $120m, and an Additional $92m Was Borrowed in 1985; The Company Used Convertible Debt in Both Years, which Is Unlikely to Get Converted into Equity Any Time Soon; •In Contrast to the Home Depot, Hechinger Had a Positive Cash Flow from Operations in Each of the Three Years; •Hechinger Did Not Rely on Debt Financing but Used Equity Financing to Fund its Capital Expansion; •Hence Hechinger’s Debt-Equity Ratio in 1985 Was only 1. 2 while the Home Depot Has a Debt-Equity Ratio of 2. 7; THE HOME DEPOT Total Cash Flow Analysis (1) ($000) 1983 1984 1985 Net Earnings 10261 14122 8219 Depreciation and Amortization 903 2275 4376 Deferred Income Taxes 713 1508 3612 Goodwill Amortization 93 637 Net Gain in Disposals (1317) Other 180 Increase in Receivables (1567) (7170) (15799) Increase in Inventories (41137) (25334) (68654) Increase in Prepaid Expenses (227) (1206) (587) Increase in Accounts Payable 17150 10505 1525 Increase in Accrued Expenses 2865 2731 5314 Increase/(Decrease) in Income Taxes Payable 406 (657) (626) Cash from Operations (10574) (3056) (43120) THE HOME DEPOT Total Cash Flow Analysis (2) ($000) 1983 1984 1985 Cash from Operations (10574) (3056) (43120) Addition to Property and Equipment (16081) (50769) (99767) Disposals of Property and Equipment 3 861 9469 Other (252) (2554) (1728) Cash before Investments, Dividends, and External Financing (26904) (55518) (135146) Acquisition of Bowater (29193) Cash before Dividends and External Financing (26904) (84711) (135146) Dividends Cash before External Financing (26904) (84711) (135146) ($000) 983 1984 1985 Cash before External Financing (26904) (84711) (135146) Increase in Current Portion of Long-Term Debt 10 233 10095 Repayment of Long-Term Debt (52) (6792) (10399) Proceeds from Long-Term Borrowings 4200 120350 92400 Proceeds from Sale of Common Stocks 36663 814 659 Cash from External Financing 40821 114605 92755 Net Change in Cash 13917 29894 (42391) THE HOME DEPOT Summary of Financial Analysis •The Home Depot Is Expanding Fast; •In Doing So, It Is Losing Control of its Costs; •Furthermore, the Company Is Relying Heavily on Debt Financing; •The Above Analysis Raises the Following Questions: Is the Company on the Verge of Trouble? Can It Continue to Implement its Growth Plans without Making Modifications to its Operating and Financial Strategies? THE HOME DEPOT The Story So Far •From January 2nd 1985 to February 3rd 1986, the Home Depot’s stock price fell by 23. 4% while the S 500 composite index increased by 29. 4%; •In the financial year ending February 2nd 1986, EPS fell by 41%. As of February 1985, managers confidently predicted an increase of 30% in EPS; •In the same financial year, bottom-line performance, as measured by ROE, fell to 9. 7% from 19. 4% in the previous year. ROEs have been declining for at least the past three years (45. 5% in 1982); •This decline reflects a strong decline in business profitability, as measured by ROA, to 2. 6% from 8. % in the previous year, attenuated by an increase in financial leverage from 2. 4 to 3. 7; •The decline in business profitability comes in the form of: An increase in operating expenses relative to sales from 20. 6% to 23. 2%; A decrease in gross margin from 26. 4% to 25. 9%; A decrease in asset turnover from 2. 4 to 2. 2; •The decline in business profitability comes in a period of rapid expansion. Over the last financial year: Sales grew by 62%; Assets grew by 78%; •Expansion in new markets requires aggressive pricing and promotions, adversely affecting gross margins, heavy spending on advertising, adversely affecting operating expenses, and time to achieve critical mass, adversely affecting asset turnover; As management did not achieve (and fell way short of) its earnings target, the cost of expanding in new markets may have been much higher than expected; •Rapid expansion may also have led the Home Depot to lose control of its costs; Cash Required for Expansion •The company plans to open 9 stores during the next year; •The financing requirement per store is estimated to be $8. 4m: $6. 6m for PPE; $1. 8m for inventories; ?The cash required for expansion in 1986 is $75. 6m; Assumptions Related To The Projected Income Statement Let us assume no changes in operating performance: •Sales to grow to $943m in 1986: ?$17. 3m of sales for AVG number of stores in use during the year; ?
The projected growth rate Is 35% compared to 62% in 1985; ? This lower growth rate is justified by the opening of fewer stores; •EBIT are to remain at 2. 7% of sales; •NIE is to remain at $8. 7m; •The tax rate is to increase to its “normal” level of 46%; ? The tax rate in 1985 was reduced by one-time tax credits; Projected Income Statement ($m) Net Sales 943. 0 EBIT 25. 5 Net Interest Expense (8. 7) Profit Before Taxes 16. 8 Taxes (7. 7) Net Income 9. 1 Assumptions Related To The Projected Cash From Operations •Depreciation and amortization expense is assumed to be $6. 5m: Depreciation of $108,000 per warehouse in use in 1985 (40. 5 warehouses): ? Depreciation expense of $5. 9m; Amortization expense of cost in excess of the fair value of net assets required equal to prior year expense: $0. 6m; •Deferred taxes are assumed to remain at the 1985 level; •Days of Inventories (83), Receivables (11), and Payables (34) Are Assumed to Remain at the 1985 Level; •Cost of Sales as a Percentage of Sales Is Assumed to Remain at the 1985 Level (74. 1%); Workings Related To The Projected Change in Inventories •Projected sales of $943m; ?Projected COGS of $699m; ?Projected average inventory: $699*83/365= $159. 3m; •With a beginning inventory of $152. 7m, the projected ending inventory has thus to be $165. 9m, leading to an increase of $13. 2m; •As $13. 2m ; $1. 8 * 9 = $16. 2m, the projected increase in inventory is $16. 2m;
Workings Related To The Projected Change in Accounts Receivable Beginning receivables are: $21. 5m; ?Since ending receivables are estimated to remain at 11 days of sales, expected ending receivables are: $943*11/365 = $28. 9m; ?The expected increase in receivables is $7. 4m; Workings Related To The Projected Change in Accounts Payable •Expected COGS: $699m; •Expected increase in inventory: $16. 2m; ?Expected purchases: $715. 2m; ?Since ending payables are estimated to remain at 33. 5 days of purchases, expected ending payables are: $715. 2*33. 5/365 = $65. 6m ?Since beginning payables are $53. 9m, the expected increase in payables is $11. 7m;
Projected Cash From Operations ($m) Net Income 9. 1 Depreciation 6. 5 Deferred Taxes 3. 6 Increase in Inventory (16. 2) Increase in Receivables (7. 4) Increase in Payables 11. 7 Net Cash from Operations 7. 3 The Financing Story So Far Assuming no change in business performance, the Home Depot is unlikely to be able to fund the planned expansion via internally generated funds: •The cash flow generated by the operations is expected to be positive in the forthcoming financial year, $7. 3m, but not large enough to fund the CAPEX requirements for the 9 incremental warehouses amounting to $59. 4m; ?Can the planned expansion be funded from issues of debt? Debt Capacity Under the current revolving credit agreement, the company has $112m in unused debt; •However, the agreement’s interest coverage is likely to limit the total additional borrowing to strictly less than this amount: •Total net interest expense cannot exceed 50% of EBIT; •Since the projected EBIT are $25. 5m, the maximum allowed net interest is $12. 8m; •Assuming interest on current debt of $8. 7m, the maximum incremental net interest is $4. 1m; •If the interest rate on the new borrowing is 9%, this implies maximum possible borrowings of $45. 6m ; Conclusion •Given the level of current performance, the previous analysis shows that it is difficult to rely exclusively on debt financing to fund its planned expansion; Another option worth considering is to sell and lease back some of the Home Depot’s fixed assets: -Management states in its letter to shareholders that it is considering this option to raise $50m; -While this is a possible solution, it is likely to be a temporary one; •A third option is to issue equity: -As February 1986, the company’s stock price was $13. 125; -To raise $59. 4m, the company has to issue approximately 4. 5m new shares, severely diluting the ownership interests of current shareholders; •A fourth option is to improve the company’s cash flow from operations. Can this be accomplished soon enough to avoid adversely affecting the firm’s growth plans?
Cite this The Home Depot Case
The Home Depot Case. (2018, Mar 01). Retrieved from https://graduateway.com/the-home-depot-case/