Linking Drivers to Variables
This article explains how to link drivers to variables in Model Reef.
You will learn:
The different ways drivers can feed variables.
How to configure links in presets and formulas.
How changes in drivers propagate to financial outputs.
Drivers only affect financial statements when they are linked to variables.
Linking via presets
Many variable presets allow you to link drivers directly, for example:
Selecting a volume driver to determine units sold.
Selecting a price driver to determine revenue per unit.
Selecting an inflation driver to escalate costs over time.
In these cases you choose the driver from a picker within the preset configuration. The preset then reads the driver values each period.
Linking via formulas
You can also link drivers using explicit formulas, for example:
Revenue variable = Units driver × Price driverCost variable = Base cost driver × Modifier driver
Here you enter the relationship in the Formula modal, and the variable's time series is entirely determined by the formula.
Propagation of driver changes
When you change a driver that is linked to variables:
The driver time series updates.
All variables that use that driver recalculate.
P&L, Balance Sheet, Cashflow and Cash Waterfall update in the active scenario.
Dashboards, charts and valuation outputs update automatically.
This is the core advantage of driver based modelling: a single assumption change can update many parts of the model coherently.
Related articles
Last updated