Building Quarterly Forecasts
- 02:57
How to create appropriate quarterly assumptions for revenue growth, margins and working capital.
Downloads
No associated resources to download.
Transcript
building quarterly forecasts historic Trend analysis can help us understand and forecast businesses analogy, but how should we build our quarterly forecasts? In the income statement analysts typically forecast revenues using year-on-year Revenue growth rates, and then sends check these using quarter on quarter Revenue growth. This sense check is particularly important if there are significant changes during the year which inhibit comparability with the previous year. for example, if a company makes an acquisition during Q4 then year on year Revenue growth will increase for Q4 but also for q1 Q2 and Q3 of the next year because all of these quarters reflect revenues from the acquired business, but the same quarter in the previous year does not an alternative sense check in this situation is to exclude the acquired revenues from our year-on-year Revenue growth analysis, and this is referred to as organic year-on-year Revenue growth. Margins are then forecast on a quarterly basis using quarterly revenues. These margin forecasts will need to reflect both seasonal variations and also latest business developments. So if a company's margins are expected to peak in the next quarter, but the previous quarters margins were squeezed because of cost inflation. Then the next quarter's margins will need to reflect both of these effects. Analysts, sometimes use 12-month rolling margins to monitor the overall trend in margins excluding seasonality effects.
In the balance sheet analysts typically forecast working capital using working capital days ratios that's receivable days inventory days and payable days. These are usually calculated using information from the same quarter in the previous year adjusted for any recent business developments. For example, let's say that we're forecasting working capital for an apparel company whose receivable days usually peak in Q4. Yet when we look back over the last year receivable days for each quarter are lower when compared with the same quarter in the previous year because of growth in their direct consumer business. This would mean attack Q4 forecasts need to reflect the expected seasonal peak in receivables. But also the gradual reduction and receivable days from the change in business mix. When calculating receivable days inventory days and payable days for quarterly forecasts. It's important to adjust the day count fraction in your calculation to reflect the actual number of days in each quarter. For a company with a calendar fiscal year q1 is the shortest quarter at 90 days or 91 days in a leap year whilst Q2 has 91 days and Q3 and Q4 have 92 days.