G45 x fx =F45*(1+G46) A B 33 31 Drift Forecasting 32 Aforecast is always based on a 'hypothesized scenario' As we said earlier in this Workbook, developing a hypothesized scenario is highly judgmental and is a combination of art and science. 34 As discussed in 'Intro to Forecasting'a Judemental Forecast may also include some 'Drift'as an alternative to a naive forecast. 35 The Drift assumes a modest improvement or degradation of the recent figures over time, i.e., a positive or negative drift in the model's driver. 36 This is similar to following a trendline, although the trendline may also be created using a statistically derived figure applying Regression. 37 In addition to a 'Naive' or 'Drift'forecast, the financial analyst may also simply use the average of values of the previous several years. 38 39 If the financial analyst were to create a drift forecast for 2021E, what values should you insert in the yellow cells in 2021E? 40 In the yellow cells below in column G, insert your drift forecast. EXHIBT: Simplest Company Model with a Drift Forecast 2018 2019 2020E 2021E 100 123.2 123.2 12% 69 60 54 Revenues Growth Cost of Revenues Gross Profits Gross Margin Operating Expenses (Opex) OpEx Percent of Revenues EBIT Source: Marianne Wok & Richard Horwitz 40 40% 110 10% 6400.0% 4600.0% 42% 1700.0% 15% 29 44% 15 14% 15% 25 37 55 Forecasting Using a Basic Hypothesis 56 As we indicated in Intro to Forecasting', even a Judgmental Forecast includes a point of view. 57 Though it is not thoroughly analyzed, the forecast always includes somejudgement about the future which reflects a basic hypothesis. 58 As a reminder, 'Fundamental Forecasting involves conducting in-depth analyses to support the hypothesis and will be explored in the next Workbook. 59 Let's start by hypothesizing that the company will do exceptionally well with the following results in 2020E. 60 Growth accelerating to 20%, Gross Margin increasing to 50% 62 OpEx Percent of Revenues staying flat. 63 What would the EBIT be in 2020E be? 61