How to Create a Scenario Based on Actual Data
When creating Scenarios, Futrli allows you to use previous months data to create an accurate Forecast. There is no need to create a Formula to calculate this, it can be done using a monthly Growth Rate method (which can be copied to other Accounts) in the Scenario’s Forecast Methods.
Once in the Scenarios section of Futrli, select the Scenario that requires the Forecast, then add an Account Line to any Account Group by clicking the green cross:
This will bring up the Forecast Method builder. Name your Forecast and select ‘Set Monthly Growth Rate’ as the Method type. You then enter the Forecast details. You will need to enter a Increase/Decrease amount, you cannot enter zero. 0.01% is the smallest number you can go forward with. You then select ‘An average of the last 3 months data for the account’ to base calculations on. There is also an option for 6 and 12 months. Then complete the rest of the Forecast details as you like:
Once you save changes, the Forecast will appear in the Account Group. Click on the green cog to open the options, which will include the option to copy this Forecast Method to other Accounts:
By clicking on the green cog, you will be able to copy this Forecast to other Account Lines that are searched for in the search engine adjacent to Copy to: