Trends. Forecasting trends. Practical planning

To quickly fill in string values, it is recommended to use the specially designed tool that allows you to automatically fill in a series with the given settings of the forecast trend. Trends are used for Forecasting planning prices, the description of inflation risks associated with the implementation of the business plan of the project.

☛ Note, table "Forecasting trends" is available for common edit and to import rows if they were designed in other programs or spreadsheets. Accounting planning interface and populate the rows used in the plan "fixed costs".

Forecasting trends в Budget-Plan Express выполняют две основные функции:

1. Trends are part of the calculation methodology for price fluctuations;
2. Trends are used in reports when preparing business plans in Word: when you convert tables into one of the currencies, you use currency trends.

To call the planning form of the trend ("the trend to Build"), click (single click) left click active on the link, or F2.

To plan values, enter the values at the beginning and the end of the year, then use the tools interface to configure settings for the trend calculation. After setting the settings, click the "Calculate" button and the row will be filled in according to the settings.

An example of planning a number of with regard to the forecasting of the trend:

1. Default values . The value of all sliders (periods) equals zero.


2. Calculate the trend from the initial value . The initial value is the starting point for calculating the trend. The subsequent values of the trend are calculated as the initial multiplied by the seasonality factor, without taking into account the seasonality factor in the first period:




Trend value_i = C₁ + C₁ × (A_i - A₁)

Where:

A_i – values of seasonality in i period;
₁ – values at the beginning of the period.


3. Calculate the trend between the start and end values . Intermediate trend values are calculated as the moving average, multiplied by the seasonality factor:







Trend value_i = А_i × С'_i

Where:

А_i – values of seasonality in i period;
С'_i – values of the moving average at i period;
Read more on moving averages see Moving Averages and Budget Series Adjustments in Budget-Plan Express.


4. Seasonal values - for discrete trends . If the fluctuations in seasonality are "non-cyclic" (the "Seasonal values for discrete trends" check box is selected), the subsequent values of the sliders take the value of the current (editable), as shown in the figure:





In the example in 5 month is set to 76, the same value is corrected in subsequent periods.



5. Calculation start date . The period from which the trend is filled.

As the basis of forecasts, as a rule, expert ratings of various rating agencies, information from sites specializing in forecasting, and other sources are taken. In some cases these estimates are the boundaries of the projected risks.

☛ As of the beginning of 2015 – 34,50 руб.
☛ As of the beginning of 2016 – 36,20 руб.
☛ As of the beginning of 2017 – 37,90 руб.
☛ At the end of   2017 – 40,50 руб.

1. step. Enter the corresponding values in the data fields - at the beginning and end of each period, as shown in the figure:






2. step. Select the option "Calculate the trend between the start and end values".
3. step. Set the appropriate seasonality values (the flag "Seasonal values - for discrete trends" should be disabled).
4. step. Click "Calculate".


The result of the calculation is the "Forecast of gasoline prices of AI-95 brand" (36 months):

The import procedure is invoked from the main menu: Main menu → "Data → Import data" – follow the instructions. 

Select your Budget-Plan Express licenses and pay in your personal account - in rubles or other currency

1. If you deleted some data by mistake or performed the action, causing damage to data, exit the program without saving: "Main menu → Project file → quit without saving".


2. If you exit the program, save the changes: "Main menu → Project file → Save" (or Ctrl+S). Or use the program exit with saving.


3. Periodically back up the data: "Main menu → Project file → Save and backup" or Ctrl+Shift+S. File project saved in the folder "backup", the project name will display date and time of saving. To restore the file, just copy it in system folder («BPlanExpress»).


4. If you have several projects (or calculation options), create a template file and, starting a new project, open the template file where your settings or preliminary project calculations are saved, select the menu item: "Main menu → Project file → To create a new project". This will shorten the development time of projects.
☛ Note that a new project is created in the system folder ("BPlanExpress"), which opens by default.


5. Complete the final calculation: "Main menu → Data → Calculate". Same - F9.


6. Clear table (reset values): "Main menu → Data → Clear table".


7. Delete the table (delete all data and settings of the table settings): "Main menu → Data → Delete table".


8. Clear the string (reset value): "Context menu (right mouse button) → Clear line."


9. Translit: "Main menu → Settings → Translit text tables". Select the translation language.


10. Export: "Main menu → Reports → Export to Excel". In the same place - export to Word.


11. Financial and investment analysis. Settings parameters of project performance indicators:"Main menu → Settings → Investment analysis".


12. Quick graph: "Context menu (right mouse button) → Graph of a line." Before the call, place the cursor anywhere in the row with the desired data. See also «Preparation of reports and business plans. Graphics».