ReadyRatios Software Manual


Tutorial


How to add my own indicator (formula) to the report?

Let's see how to add your own indicator to the report on the following example.

Our task is to calculate Added Value Indicator / Total employees indicator.

Step 1. We need to use 2 indicators (variables) in formula (Added Value Indicator and Total employees) which are absent in the standard IFRS statements (i.e. in the form #1 Statement of financial position and in the form #2 Statement of comprehensive income. So we should add these indicators.

Go to Settings->Input Tables Customization and add these 2 indicators (see the manual for details).

Added Value Indicator is a period type indicator (i.e. is a type of P&L indicators), so select Input table option as Additional data – form 2. Let's assign code "AVI" to our variable:

After that add the second indicator Total employees. In contrast to Added Value Indicator Total employees indicator should belong to input table Additional data – form 1, because it nature is close to Balance sheet indicators (i.e. indicators on the exact date and not period as revenue or income):

Step 2. Insert new formula (see the manual for details). Go to section Settings->Formulas customization and add your formula:

The formula is

F2_u[AVI]/((F1_u[b][total_employees]+F1_u[e][total_employees])/2)

Why not just F2_u[AVI]/F1_u[total_employees]? Because it's correctly to use average value of Total employees indicator for each period. Average value is calculated as value at the beginning of the period ([b]) plus the value at the end of the period ([e]) divided by 2.

What mean F2_u and F1_u used in the formula above? F2_u means Additional data – form 2 to which we assigned our AVI indicator. F1_u is the reference for Additional data – form 1 to which Total employees indicator was assigned.

Step 3. Make your own report template.

Go to Settings->Templates customization (see the manual for details). Press Edit for Comprehensive Financial Analysis template and insert new table (use the button Insert indicators table):

Pay attention! For the first list you should select "table #1 & 2", because our Added Value Indicator / total employees formula consist of both form # 1 and form # 2 variables. After that you'll see our indicator at the end of the list. Just check it. Press Insert button and new table will appear on the template:

Press Template properties and give new name My Financial Analysis to the current template (it's optional action).

Press Save template. The template will be saved as users' template.

Step 4. Use created template to get comprehensive financial analyses plus calculate your Added Value Indicator / Total employees indicator. Go to Input tables and select My Financial Analysis template. You'll see our new fields Added Value Indicator and Total employees in the additional tables 1 & 2, use it:

So you'll see your table with Added Value Indicator to Total employees indicator in the ready report:

Look at the table. For the year 2010, added value per employee is 651.29. This figure is calculated as 2442344/((4000+3500)/2).

Attention! Filling the input tables don't forget to select your own template (My Financial Analysis), but not default template Comprehensive Financial Analysis which has no your result table.

Up

Login to ReadyRatios

 

Have you forgotten your password?

Are you a new user?

Login As
You can log in if you are registered at one of these services: