You will be able to forecast revenue, margins and reinvestment from their drivers instead of a straight-line growth rate.
Marcus is an analyst building a forecast for Larkspur, a manufacturer that sells parts to equipment makers, most of them to two big customers. His first version took last year's revenue and added 10% a year, which gave revenue of about S$640 million five years out, a 14% margin, and almost no extra spending on machines or stock. All Larkspur figures here are invented and, from now on, in S$ millions.
A fixed growth rate is the easiest forecast to build, and it looks precise because every year gets a number. The 10% is still a guess, and nothing in the spreadsheet explains why it should be 10% and not 7% or 13%. A driver-based forecast is also uncertain, but every number in it has a reason you or anyone else can check and change.
Revenue is the result of underlying causes, called drivers. For a retailer, the drivers might be stores and sales per store. For a subscription business, they are subscribers and revenue per subscriber. For a bank, they are loans and the interest margin. Many manufacturers come down to volume and price. You find a company's drivers in its operating review and segment notes, then forecast each driver and let the total follow from them.
Larkspur's revenue depends on how much its equipment-maker customers spend on new machines, and on the share of that spending Larkspur wins through new parts. The customers' own results and guidance inform the first driver. Larkspur's announcements about newly qualified parts inform the second.
Marcus starts from FY5 revenue of 400. The latest guidance from the two big customers points to their spending rising about 6% in FY6, and new parts Larkspur has already announced add about 2%. Revenue growth for FY6 is therefore 8%, giving revenue of 432.
For FY7 to FY10 he fades growth to 6%, 5%, 4% and 3%, so revenue reaches about 515 by FY10, well short of the 640 in his first version. Each number has a source, so if a big customer cuts its guidance, Marcus knows which cell to change and why.
Unusually high profitability draws in competitors and gives customers a reason to push back on prices, and fast growth runs into the size of the market. Unusually low profitability pushes companies to cut costs or leave the business. Researchers have documented that company margins and growth rates drift towards industry averages over several years, a pattern called mean reversion. How fast it happens varies by industry and by company. Forecasts that ignore it are usually too optimistic about good companies and too pessimistic about bad ones.
Larkspur's operating margin ranged from about 11% to 16% over the past five years, with an average of about 13.4%, and FY5 came in at 14%. Marcus could have carried 14% forward or extended the trend towards the 16% peak. He sets 13.5% for every forecast year, close to the full-cycle average.
The margin is a judgment, so Marcus writes down his reasoning next to it. If Larkspur is building a lasting edge over competitors, 13.5% is too low. If its biggest customer is qualifying a second supplier, the risk raised in lesson 6.2, it may be too high.
A growing manufacturer needs more machines, more stock and more credit for its customers, and it pays for these before the extra profit comes in. A forecast that grows revenue without growing the capital behind it shows free cash flow the business could never produce, which was the problem with Marcus's first version. To avoid it, tie each reinvestment line (capital spending, depreciation and working capital) to revenue.
Larkspur spent 34 on capital equipment in FY5, about 8.5% of revenue, and its average across the cycle is close to 8%. Marcus sets capital spending at 8% of revenue. Depreciation was 24 in FY5, and he sets it at 6% of revenue. With capital spending above depreciation, the asset base grows along with the business.
Working capital was about 26% of revenue, as calculated in lesson 7.3, "Balance sheet: working capital, goodwill, leases and debt". Marcus keeps it at 26%, so every 10 of extra revenue ties up about 2.6 of extra cash in receivables and inventory.
For tax, take the effective rate from the company's tax note, since the headline rate can differ. Marcus uses 17% of profit before tax, close to Larkspur's recent effective rate.
FY6 then shows operating profit of about 58, capital spending of about 35, depreciation of about 26 and an increase in working capital of about 7. The working capital figure is a little below 26% of the 32 of extra revenue, which only works if FY5 working capital was slightly above 26% of revenue, so check it against the balance sheet when you build your own. Lesson 7.8 turns these FY6 numbers into a full forecast.
Every assumption sits on a single tab called Inputs. The Inputs tab has one row per driver and one column per forecast year, and each row carries a short note with the value, the reason and the source. Marcus's has six rows with five yearly values each, and it fits on one screen:
Revenue growth Operating margin Depreciation Capital spending Working capital Tax rate
The statement tabs hold only formulas that read from Inputs and from each other, and no number is typed directly into a statement tab.
Anyone opening the file, including you in six months, can read the assumptions without hunting through formulas. When you change one driver, the change carries through all three statements. Module 8 uses the same structure to build sensitivity tables and scenarios.
For the activity, write your own company's forecast drivers for revenue, margin, capital spending and working capital, each with a value, a reason and a source.
Write down your forecast drivers for revenue, margin, capital spending and working capital, with a reason and a source for each.
Junxiong-WFG Organisation is an authorised representative of AIA Financial Advisers Private Limited (Reg. No. 201715016G).