Step 14: Create a Simple Revenue Forecast

Use Assumptions & Drivers to create a simple revenue forecast

You can reference historical trends and assume a multiplier to create a high level revenue forecast.


Be Aware: The example below is a simple methodology used for revenue planning. This example should be adapted as needed to fit your business planning requirements.

 

To configure a simple revenue forecast for product revenue by looking at last year and assuming a 5% increase, follow the steps below.

  1. Define the Assumption Table & Multiplier 
    Setup > Assumptions > Manage Tables > Add Assumption Table > Name the table Revenue Assumptions > + Add Assumption for Revenue Multiplier
  2. Populate the Assumption in the Plan
    Plans > Assumption > Populate the Revenue Multiplier and Save
  3. Add a Driver for Revenue
    Plans > Drivers > Revenue > ... > +Add Driver
  4. Configure the Revenue Driver
    • Populate the Name with "LY + 5%"
    • Populate the Output of the Driver to point to the Sales & Marketing Department & Product Revenue account
    • Populate the Driver to refer to the value of the Product Revenue account for the same month the previous year
    • Populate the Rate to refer to the Multiplier Assumption created in step 1
    • Leave ƒx, Start & End with the default settings.

This driver will now return the Product Revenue for the same month from the previous year in your plan. For example, if Product Revenue for February 2020 was $10,000, the forecast for February 2021 will also be $10,500. 

Helpful Hints:

  • This example assumes that the Product Revenue has seasonality so it makes sense to look at the same month from the previous year. Explore using other Ranges & Reductions, for example you could use a Trailing 3 Month Average. 
  • The Driver Category Output is a shortcut to refer to the same account & department you are adding the driver to, i.e., S&M Product Revenue 
  • The Range This Month Last Year in Step 4 is not a default range - to add this range select +ADD from the Ranges window, select the settings in the screenshot below and Save.

 

Continue to Step 15: Create a Detailed Revenue Model with a Custom Table