From the course: Financial Modeling and Forecasting Financial Statements
Home Depot in 1985: Three weeks to live
From the course: Financial Modeling and Forecasting Financial Statements
Home Depot in 1985: Three weeks to live
In the 2025 Fortune 500 listing of the largest companies by revenue in the United States, Home Depot is number 24. Home Depot is by far the dominant home improvement retailer in the United States and in the world. Now most people don't know that Home Depot was close to death back in 1985. Now we know because for many years we've been teaching a Harvard Business School case about Home Depot. The case was written by Professor Krishna Palapu. An analysis of Home Depot's financial statement numbers from 1985 reveals that the company's income was down, but the income drop doesn't appear to be an immediate crisis. Not a crisis until you look at the cash flow numbers. During 1985, Home Depot's operations were burning through $4 million a month. This is the amount of cash paid to suppliers, to employees, and for other operating expenses that was in excess of the amount of cash collected from customers, $4 million per month. And there is additional bad cash flow news. During 1985, Home Depot also burned through an average of $8 million per month, building new stores and buying some stores from other companies. In total, Home Depot's 1985 cash burn rate was $12 million per month, $8 million burned through capital spending, and $4 million burned through daily operations. Startup companies often keep track of their cash burn rate. A startup company starts off with a pile of cash. Cash from the personal savings of the founders, usually not much, cash from early investors, and maybe some cash from a local bank loan. Now the goal of the startup company is to start generating cash from profitable business operations before burning through all of that initial pile of cash. The size of that initial pile of cash, combined with the cash burn rate, gives the company founders an idea of how long they can last before they have to go back out into the streets looking for additional financing. In Home Depot's case back in 1985, remember that the company was burning through cash at the rate of $12 million per month. In 1985, the company had borrowed $92 million. That was in addition to the $120 million the company had borrowed the year before. Could Home Depot just keep borrowing cash forever? Well, when 1986 started, Home Depot had a cash balance of $9 million. With a cash burn rate of $12 million per month, that left them with just three weeks of remaining cash? Three weeks to come up with a cash flow plan. Three weeks with the cash burning away at three million dollars per week. Three weeks to arrange new loans or get additional cash from investors. Or three weeks to come up with a plan to slow down or even reverse this cash burn rate. Okay, I'm on the edge of my seat. So what do they do? Well, not so fast. We first need some background in financial modeling and financial statement forecasting before we are ready to appreciate the beauty of what the managers of Home Depot did back in 1986 to save the company.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Home Depot in 1985: Three weeks to live3m 26s
-
Monitor financial statements to keep forecasts accurate4m 41s
-
Incorporate long-term planning into forecasts3m 6s
-
Revise financial forecasts based on financing options5m 1s
-
Use AI to conduct sensitivity analysis5m 32s
-
Excel: Forecast assets and sensitivity analysis11m 17s
-
-
-
-
-