These formulas are used in various calculations in the consolidation process by assigning them to the formula field in the repartition rules. For example, they define how to calculate the parent's share non controlling interest, share of associate, eliminations, etc.
Access the form
To access the form:
- Select the Maintain module.
- Select Consolidation Formulas from the Consolidation card.
Use the toolbar in the upper right to create, delete, import, export, refresh, or save consolidation formulas.
The pre-configured formulas included in your Financial Consolidation model:
| Formula | Explanation |
[Pown] | Represents the ownership percentage of the entity. This is generally used to calculate the group share. |
1-[Pown] | Calculates the Non-Controlling Interest (NCI) share, which is the portion of the subsidiary not owned by the parent. |
[IntercoPown] | Represents the ownership percentage of the intercompany entity. |
1-[IntercoPown] | Represents the percentage of an intercompany entity that is not owned by the parent entity. |
0% | A fixed value used to assign zero ownership, effectively excluding an amount from a specific calculation. |
[IntercoPown]*(1-[Pown]) | Calculates the portion of an intercompany holding that is attributable to non-controlling interest. |
[Pown]*[IntercoPown] | This calculation is used when internal gain is generated and must be neutralized when the transaction is done between two equity methods or one proportional and one equity method entities. |
CASE when [Pown] < [IntercoPown]... | A conditional formula that returns the smaller of two ownership percentages, Pown or IntercoPown. |
[Pown]*(1-[IntercoPown]) | Calculates the portion of the parent's ownership that is held directly, separate from any indirect intercompany ownership. |
PCON | Determines the consolidation method. |
MIN([Pown], [IntercoPown]) | A function that returns the minimum, or smallest value between the entity and intercompany ownership percentages. This is used when internal gain is generated in consolidation and must be neutralized. It occurs when the transaction is between two proportional entities. The amount to be neutralized equals the Bases times the lowest between Pown and IntercoPown. |
MAX([Pown], [IntercoPown]) | A function that returns the maximum, or largest value between the entity and intercompany ownership percentages. |
[SharesPOWN] | Represents the ownership percentage specifically derived from the shares calculation method. |
[Direct] | Represents the direct ownership percentage, often used as a clear input for direct holdings in a subsidiary. |
Create a formula
- Select the Create icon from the toolbar.
- Add the formula.
- Select the Save icon from the toolbar.
