Percent-of-Sales Forecasting
The percent-of-sales method forecasts an income-statement or balance-sheet item by holding it at a constant fraction of revenue. Once forecast sales are set, each variable line such as cost of goods sold, receivables or inventory is projected as its historical percentage of sales. The method is fast and transparent, and it is the natural first pass for a pro-forma. Its validity rests on one assumption, that the item actually scales with sales. Genuinely fixed costs such as rent and salaried headcount break the rule, so the analyst must separate the lines that move with revenue from the lines that do not.
Why it matters
The idea is that a business has a stable cost and asset structure, so if you know next year’s sales you can read off most other lines as a steady percentage. A retailer that historically spends 65 cents of cost for every dollar sold will, absent a change, keep doing so. The trap is treating every line this way. Rent on a signed lease does not rise just because you sold more, and full-time salaries are largely fixed in the short run. Scaling a truly fixed cost up with sales overstates it and quietly distorts the whole forecast, so the first job is to sort variable lines from fixed ones.
Formulas
Worked examples
A firm’s cost of goods sold has run at 64.8 percent of sales and its accounts receivable reflect an average collection period of 30 days. Forecast sales are US$106m. Estimate forecast cost of goods sold and forecast receivables, and name one line you would not forecast this way.
Cost of goods sold is 0.648 times US$106m, which is about US$68.7m. Receivables are 30 times US$106m divided by 365, which is roughly US$8.7m. Both lines plausibly scale with sales, so the percent-of-sales shortcut is reasonable. Office rent is the line to exclude. It is set by a lease and stays the same whether sales rise or fall, so forecasting it as a fixed percentage of revenue would wrongly inflate it as the business grows.
Common mistakes
- ✗Every line on the statements can be forecast as a percent of sales. Only lines that genuinely scale with volume qualify. Fixed costs such as rent and salaried pay must be held flat or forecast separately.
- ✗A constant percentage means a constant dollar amount. The ratio is held constant, so the dollar figure grows exactly in step with forecast sales, which is the whole point of the method.
- ✗The method captures economies of scale. A flat percentage assumes no margin change with size. Real scale effects must be modelled by deliberately flexing the ratio, not by leaving it fixed.
- ✗Percent-of-sales replaces judgement. It is a starting scaffold. The analyst still has to decide which ratios hold, which drift, and which lines need a separate driver.
Revision bullets
- •Forecasts each variable line as a fixed historical fraction of sales
- •Set forecast sales first, then read off cost of goods sold, receivables and inventory
- •Valid only for lines that genuinely scale with revenue
- •Fixed costs such as rent and salaried headcount break the assumption
- •Receivables can be sharpened using the average collection period
- •A fast first pass for the pro-forma, not a substitute for judgement
Quick check
The percent-of-sales method works best for forecasting
A firm with a 45-day average collection period forecasts sales of US$73m for the year. Forecast accounts receivable are about
Connected topics
Sources
- Titman & Martin, Ch. 6Titman, S., & Martin, J. D. Valuation: The Art and Science of Corporate Investment Decisions. Pearson.Presents the percent-of-sales method, the average collection period for receivables, and the limitation when accounts do not scale with sales.
- Koller, Goedhart & Wessels (2020), Ch. 13Koller, T., Goedhart, M., & Wessels, D. Valuation: Measuring and Managing the Value of Companies. 7th ed. McKinsey & Company / Wiley, 2020.Treats ratio-based forecasting and the need to separate variable from fixed cost behaviour.