Chapter 1: Using Sensitivity Analysis

9 Topics | 1 Assessment Test
Chapter 2: Forecasting Structures

8 Topics
Chapter 3: Modelling Excercise And Assessment Test: Forecasting Calculations (I)

1 Topic | 1 Assessment Test
The classical corkscrew calculations described in the last section are useful to calculate the level of a stock item, where the logic used is that the stock level results from periodic inflows and outflows, and initial value.

There are many situations where it is the stock item that has already been forecast in some other way (i.e. not using the flows). For example, as in the earlier section, the amount owed by customers could have been forecasted using a ratio method (or days’ equivalent). In such cases, one would need to calculate the flow items from the stock levels (for, if each were forecast separately, then the forecasts would be inconsistent with each other, in general). For example, the change in the level of amount owed during a period is equivalent to the value of invoices issued to customers less the values invoices paid by customers within the period.

This calculation approach is sometimes called a reverse or implied corkscrew. The key differences with a classical corkscrew are:

- The inputs to the calculations in each period are the stock levels only (typically the period end value, with period starting values being brought forward from these).
- The flow item is calculated from the stock item.
- The flow item is a single net item (net increase, or increases less decreases), unless further assumptions are made as to how to split it between inflows and outflows).

These formulas can be copied across to the other time periods:

Note that the dependency arrows within the implied corkscrew in the above image do not form a single continuous set, but rather are disjointed.

From a visual perspective, the implied corkscrew can be used to create what looks more like a standard corkscrew: In the following image, the rows of the implied corkscrew are structured in the classical order. Note that the calculations are exactly the same (i.e. the ending values are still drawn from the main calculation area, the starting values are brought forward from these, and the net increase is calculated as the difference between them) – the only difference is the layout of the order of the calculations, in which the net increase is calculated from an item which is above it (top-to-bottom) as well as one that is below it (bottom-to-top):

Where the “net flow” figure that is derived from an implied corkscrew is implicitly composed of items that are of the same nature, it may be sufficient to stop the process at this point, and to work only with the net figure. However, in some cases it may be necessary to split the net item into its “inflow and outflow” or “gross” components (or one may simply wish to do so, for extra clarity and transparency). To do so requires additional information or an assumption.

For example, on the assumption that the gross increase in amounts owed by customers is – in each period – equal to the sales invoices issued, then – starting with the raw implied corkscrew (rows 20-23 in the following image), one could set the gross increase in sales invoices (row 25) as being equal to sales revenue (row 4), and then deduced the implied amount that customers must have paid (row 26) in order that the ending amount be as calculated originally:

In the case of net (capital) expenditure on plant and equipment, this is made up of cash and non-cash components: That is, net capital expenditure is “gross capital expenditure, less depreciation”, where gross expenditure is a cash item, but depreciation is not. Therefore, the splitting of the components would be necessary for many purposes (such as to perform cash flow analysis – from which depreciation should be excluded – as well as profitability analysis, where depreciation is included as a cost item, albeit not being cash).

Once again, to split the components requires an additional assumption. For example, if one assumed that the periodic depreciation was 20% of the value of equipment at the period start, then the calculations can be done in “top-to-bottom” format as shown in rows 19-22 (i.e. first the ending and starting values, then depreciation, then the gross capital expenditure):

This website uses cookies to improve your experience. We'll assume you accept this policy as long as you are using this websiteAcceptView Policy

Scroll to Top

Login

Accessing this course requires a login. Please enter your credentials below!