We've looked at the 'Last Year's Actuals' method of creating a Forecast and how easy it is to build a Forecast based upon prior performance, but what happens when you wish to factor in growth, or a reduction in costs? In this guide, we’re going to look at how we can tailor our projections so that they tally with our expectations for the future.
Video: Using the 'Advanced Create' method within the 'Create from Last Year's Actuals' option to add a 10% increase to last year's income
To do so, we’re first going to navigate to the Forecasting section of Futrli Advisor and select 'New' adjacent to our Organisation of choice. When pressed, this displays the list of Forecast creation methods available to us:
Using 'Quick Create', we simply selected a Forecast start date, length and name. With 'Advanced Create', we also have the opportunity to flex the details. We could set variant VAT rates, apply growth projections or set our expected Credit Terms:
For example, to forecast an increase in Income and a reduction in Costs, we first need to toggle off ‘Every account category’. This will allow us to enter different growth rates for each category rather than applying one for all. We can then simply add a ten per cent increase in Income and a two per cent reduction in Cost of Sales:
Once happy, it’s time to press 'Build'. Futrli will then generate our Forecast, looking at our past performance month-by-month and factoring in how we expect to vary from that in the future.