The Formula/Drivers value rule enables you to build out mathematical equations to calculate the values in your forecast’s Profit & Loss. Through formulas, you can acknowledge the relationship between P&L accounts and incorporate non-financial data into your forecast through drivers.
Drivers can be set up from the Fathom main grid and are essentially ‘non-financial’ metrics or leading indicators that are used to calculate the value of accounts.
You can use any chart of account line item, sub total, heading, driver, or typed value, combined with the 4 operators and parentheses to build out formulas for any chart of account line item on the Profit & Loss.
This article goes over:
Creating a Formula/Drivers Value Rule
To create a new 'Formula/Drivers' value rule or edit an existing one:
Click into the value cell for the account you wish to apply the formula.
Select the ‘Three dot’ icon to add a new rule or edit an existing rule.
Choose ‘Formula/Drivers’ from the dropdown menu to open the formula builder.
Enter in the formula you want to use to calculate the forecast values.
To include a driver in the formula or account in the formula, type in the name of the driver or account or use the ‘@’ symbol to choose a one from a menu.
Select the green ‘Save changes’ option to save the formula.
Click the green ‘Create Rule’ button to apply the ‘Formula/Driver’ value rule to your forecast.
💡Pro Tip: Formulas can be edited or overridden at any point, by opening the properties panel to the right of an account and using the ‘Three dot’ icon in the value rule section to bring up the editing options. You can edit the rule to change the formula or start a new rule to override it.
A couple of the many ways you can use the ‘Formula/Driver’ value rule to determine your forecast’s values, include:
Linking the performance of one account to another
With a 'Formula/Drivers' value rule, you can base the forecast performance of one account, heading, or classification off of another account, heading, or classification.
Example 1: A company knows that its ‘Materials’ expense account trends at 35% of its Sales. This can be represented in the forecast by building out the following formula for the 'Materials' account:
‘Sales’ x .35
Using a driver as a variable in your formula
You could set up and import data for drivers and use these drivers as variables in a formula. Some common forecast drivers include ‘Number of Units Sold’ and ‘Average Sales Price’. Using a formula you would be able to reference these drivers to forecast sales according to the following formula:
‘Number of Units Sold’ x ‘Average Sales Price’
Learn more about creating and adding drivers to the Drivers Grid by reading the 'Using Drivers in a Fathom Forecast' article.
Example 2: In the example of a coffee shop, the data for the number of 'Hot Coffee Purchases’ and ‘Iced Coffee Purchases’ could be entered into the Drivers Grid. Additionally, drivers for the ‘Average Price per Hot Coffee’ and ‘Average Price per Iced Coffee’ could be created. Then, using a ‘Formula/Driver’ value rule, the Sales account could be calculated according to the following formula:
(‘Hot Coffee Purchases’ x ‘Average Price of Hot Coffee’) + (‘Iced Coffee Purchases’ x ‘Average Price of Iced Coffee’)