Finance Modelling

 The main lesson is that financial modelling can identify the changes needed to improve a company’s cash flow, but the model itself cannot create the improvement. People and execution do.

Simple Summary

At the end of 1985, Home Depot had serious operating cash-flow problems. Forecasting showed that if the company continued operating as it had been, its cash position would deteriorate further.

Instead of looking for one magic solution, the exercise considers making several operational improvements simultaneously:

• Inventory: reduce days of inventory from 108 to 66 days
• Receivables: collect customer dues faster, from 14 to 9 days
• Payables: take slightly longer to pay suppliers, from 48 to 50 days
• Gross margin: improve from 26% to 28%
• Overheads: reduce from 22% to 20% of sales

When all these reasonable changes are incorporated into the financial model, the forecasted operating cash flow changes dramatically. Home Depot would generate enough internal cash to support growth and become more attractive to lenders. The actual 1986 results also showed improvements in margins and operating expenses.

The most important lesson

The spreadsheet makes the transformation look easy—but every number in the spreadsheet represents a real-world action by someone.

For example:

Reducing inventory requires better inventory management.
Collecting receivables faster requires people to follow up.
Reducing costs requires operational discipline.
Improving margins requires purchasing and pricing decisions.

So:

Financial modelling → identifies possible solutions
Management → chooses the solutions
People → execute them
Execution → creates the actual financial results

One-line takeaway

A financial model can show you what needs to change; only people can make those changes happen.

This is also a useful finance lesson: forecasting is not the end of financial analysis—it is the starting point for operational action.