In this guide, we’ll go through how to adjust numbers in the budget using a coefficient.
Adjusting budget figures by coefficient allows you to quickly and easily calculate percentage changes for large totals at once. It enables you to adjust numbers based on anticipated growth or negative trends without having to manually calculate each value individually.
Using a coefficient, you can easily simulate various scenarios, such as turnover growth, rising costs, or significant cost reductions.
Let’s hop in to the instructions!
Generating figures by coefficient compared to the reference period
1. Go to the Plan tab and click on Budgeting.
2. Open the budget you have created. If you haven't created a new budget yet, first follow this guide and then continue with the steps in this article.
3. Activate the input mode by clicking the "Input mode" button, and then press "Generate".
4. Select the period for which you want to generate figures.
From the dropdown menu, choose "By coefficient" as the generation method.
Select the accounts to be generated. You can also select all accounts at once by clicking "Select all."
Enter the coefficient.
Finally, click "Save."
5. StatBun has now automatically generated the new figures using the coefficient for the period you selected!
Example of using a coefficient
Let’s look at an example of using a coefficient. In this example, we’ll focus only on the turnover for January (1/2024). As shown in the image below, the currently budgeted turnover is the same as last year’s actual result, which is 673 720 €.
If the turnover is expected to increase by 10%, a coefficient of 1,10 is used. This means the original turnover is multiplied by the coefficient of 1,10, resulting in a new projected revenue of 741 092 €.
If the turnover is to be reduced by 10%, a coefficient of 0,90 is used. This means the original turnover is multiplied by the coefficient of 0,90, resulting in a new, lower revenue of 606 348 €.
Comments
0 comments
Please sign in to leave a comment.