View source for Step-by-step computation for Macro-step 1

== Purpose ==
The purpose of the Scope and Perimeter analysis is to construct the GloBE perimeter by identifiying all the Constituent Entities and fixing their legal characteristic, thus allowing further treatment. It also allows to define the different sub-groups and sub-perimeters (JVs, MOMNEs, Investment entities...) in each jurisdiction that will be the basis of the next computational steps.

== General Logic ==
In order to perform the Perimeter analysis a serie of computations on the shareholding graph needs to be perform. This will allow to finalize the direct and indirect ownership interests as well as the controlling interest necessary to draw the limits of the different sub-perimeters. Moreover a series of graph transversal will be necessary to qualify certain entities as member of Joint Ventures, Excluded Entities and or Investment entities.

== Data Input ==
The Data input for Macro-step 1 consists in :

* The list of all potential entities and their characteristics;
* The list of all direct shareholdings and their characteristics or the ownership and controlling interest links

The detailed matrix is available in the relevant section of the [[Pillar 2 Data Structure]].

== Data Output ==
The Data output for Macro-step 1 consists in :

* The final characterization of each Constituent Entity and out of group entity with regard to GloBE rules, ready for input in the GIR;
* The final ownership and controlling interest matrices for use in Macro-step 3.'s re-allocations and various elections, as well as the Charging Mechanisms of Macro-step 5
* The final list of JVs and Minority-Owned sub-groups in each Jurisdictions as well as groups of Investment entities

The detailed matrix is available in the relevant section of the [[Pillar 2 Data Structure]].

== Detailed Step by step approach ==

=== Step 1.1. - Sanity checks on Ownership and Controlling interests ===

==== Purpose ====
The purpose of the Santity checks is identify and report all the data structure issues in the shareholding structure of the group, before computing the indirect ownership interests. It serves as an important reminder that the group's perimeter is at the basis of the Pillar 2 computation and that no accurate result can be achieved without ensuring its quality.

==== General Logic ====
This Step 1.1. will consist in a sequence of computations, checks and controls aiming at ensuring that depending on the level of input, the data provided is coherent and usable.

==== Data Input ====
The Data input for Step 1.1. consists in :

* The list of Entities for which legal characteristics are provided (within or outside the future GloBE Perimeter);
* The list of pre-calculated shareholding interests both ownership and controlling interests if links are available for each shareholding relationships as percentages;
* The list of shares, characteristics of these shares with regards to financial and control rights, for each Entity in the perimeter as well as outside;
* The list of [[Fall-back elections]] for the MNE group : assumptions for undocumented shares, ownership or controlling interests (re-normalization; auto-filling with either UPE or generic out-of-group entity or UPE)

The detailed matrix is available in the relevant section of the [[Pillar 2 Data Structure]].

==== Data Output ====
The Data output for Step 1.1. consists in :

* The list of subsidiary entities absent from the list of Entities for which legal characteristics have been defined;
* The list of parent entities absent from the list of Entities for which legal characteristics have been defined;
* The list entities with Legal characteristics completely absent from the shareholding structure;
* The list of subsidiaries with incoherent shareholding structures : incoherent single values (negative, not numerical; higher than 100 for percentages...); incoherent aggregates values (totals not equal to 100%; computational errors...)
* The list of auto-cleaned elements of the structure using the fall-back mechanisms
* The list of errors for each faulty elements
** unknown subsidiaries
** unknown parents
** unknown shareholding relations
** typing errors
** constraints errors
** coherence controls

The detailed matrix is available in the relevant section of the [[Pillar 2 Data Structure]].

==== Detailed computations ====
The list of Micro-Step is a follows :

* Micro-Step 1.1.1. Unknown subsidiaries
* Micro-Step 1.1.2. Unknown parents
* Micro-Step 1.1.3. Entity absent from the shareholding structure
* Micro-Step 1.1.4. Typing and constraints controls
* Micro-Step 1.1.5. Shareholding coherence controls

===== Micro-Step 1.1.1. Unknown subsidiaries =====
This step is pretty simple as it basically corresponds to a VLOOKUP between the matrix of shareholdings and the list of entities with characteristics to verify that any entity present as the target of a shareholding relationship from at least one parent entity is also present in the list of legal entities.

===== Micro-Step 1.1.2. Unknown parents =====
This step is pretty simple as it basically corresponds to a VLOOKUP between the matrix of shareholdings and the list of entities with characteristics to verify that any parent entity present as the owner of a shareholding relationship to any subsidiary entity is also present in the list of legal entities.

===== Micro-Step 1.1.3. Entity absent from the shareholding structure =====
This step is pretty simple as it basically corresponds to 2 VLOOKUPs between the matrix of shareholdings and the list of entities with characteristics to verify that any entity present in the list of entities is also present as the owner or the target of at least one shareholding link.

===== Micro-Step 1.1.4. Typing and constraints controls =====
This step is pretty simple as it basically corresponds to a verification of the different values according to their definition, typing and constraints.

The current list of these controls are as :

* percentages need to be doubles between 0 and 1;
* integers and doubles need to be positive or null;

===== Micro-Step 1.1.5. Shareholding coherence controls =====
This step requires to add the shareholding relationships to verify that the aggregates add-up to the given totals or percentages for each subsidiary entity and apply the fall-back mechanisms.

The current list of these controls and corrections are as follows :

* In any case, an error is returned containing the type of error and the correction made
* do the sum of percentages for both ownership and/or controlling interest sum to 100%, for each subsidiary entity;
** If the fall-back election has been taken, the percentages are corrected to the choice made : 
*** re-normalization (for total values strictly positive and lower or higher than 1): values are put back to 100%, by dividing to the total percentage reached;
*** automated allocation of the missing shareholding interests (for total values positive and lower than 1) to either :
**** a generic independent third party owner;
**** the UPE;
* do the sum of each Share type for the subsidiary entity and compre to the provided total (if not provided at all, or equal to 0, this test is skipped);
** If the fall-back election has been taken, the numbers of shares are corrected according to the choice made : 
*** re-normalization (for a total of different from the total provided): the new total is considered as true, unless equal to 0;
*** automated allocation of the missing shares (for positive totals lower than the total provided) to either :
**** a generic independent third party owner;
**** the UPE;

=== Step 1.2. - Generation of the Ownership Interests and Control matrices ===

==== Purpose ====
The purpose of this step is to build the necessary input for the various computations that will follow and may require matrix computations.

==== General Logic ====
This Step 1.2. will consist in the application of a few transformation of the data cleaned or checked at the Step 1.1. and form the initial ownership interest matrix and the controlling interest matrix if the data is available.

==== Data Input ====
The Data input for Step 1.2. consists in :

* The same input as the Step 1.1.
* The output of the Step 1.1.

The detailed matrix is available in the relevant section of the [[Pillar 2 Data Structure]].

==== Data Output ====
The Data output for Step 1.2. consists in :

* The final direct ownership interest matrix;
* The final direct controlling interest matrix;

The detailed matrix is available in the relevant section of the [[Pillar 2 Data Structure]].

==== Detailed computations ====
The list of Micro-Step is a follows :

* Micro-Step 1.2.1. Transformation of Shares data into percentages
* Micro-Step 1.2.2. Initial construction of the matrices
* Micro-Step 1.2.3. Removal of direct auto-circular rights

===== Micro-Step 1.2.1. Transformation of Shares data into percentages =====
This step applies to both financial and controlling rights, and consists in the computation of the ownership and controlling interests as percentages for each subsidiary-parent relationship present in the output data of Step 1.1. when the information provided is not directly provided as ownership and controlling interests but with detailed shares and share types.

====== Logic ======
The computation is quite straight forward :

* for each subsidiary entity, the total of financial rights (and controlling rights respectively) are computed as the sum for all share types of the produce of the number of shares of a given type across all of its shareholders multiplied by the financial (or control rights respectively) of the given type;
* for each shareholder of this entity, the financial rights (and controlling rights respectively) are computed as the sum for all share types of the produce of the number of shares of a given type owned by this specific shareholder multiplied by the financial (or control rights respectively) of the given type;
* for each shareholder of a given we can then generate a unique ownership interest (and controlling interest) value that corresponds to the ratio of the values determined in the previous two bullet points.

====== Example ======

* Input data

Entity: XYZ Corporation

Shareholders: Entity 1, Entity 2, Entity 3

Share Types: Type A, Type B

Share Types and Rights:
{| class="wikitable"
!Share Type
!Financial Rights
!Controlling Rights
|-
|Type A
|1.5
|1.2
|-
|Type B
|0.8
|1.8
|}
Share Distribution:
{| class="wikitable"
!Shareholder
!Type A Shares
!Type B Shares
|-
|Entity 1
|10
|20
|-
|Entity 2
|15
|5
|-
|Entity 3
|5
|15
|}

* Computation of Total Financial and Controlling Rights for XYZ Corporation:

Formula: ''TotalRights''=∑(Number of shares of each type×Rights of that type)
{| class="wikitable"
!Total Financial Rights
!Total Controlling Rights
|-
|77.0
|108.0
|}

* Computation of Financial and Controlling Rights for Each Shareholder:

Formula: ''RightsforShareholder''=∑(Number of shares of each type owned by shareholder×Rights of that type)
{| class="wikitable"
!Shareholder
!Financial Rights
!Controlling Rights
|-
|Entity 1
|31.0
|48.0
|-
|Entity 2
|26.5
|27.0
|-
|Entity 3
|19.5
|33.0
|}

* Computation of % interests

''Formula: Interest''=Shareholder’s Rights/Total Rights
{| class="wikitable"
!Shareholder
!Financial Rights
!Controlling Rights
!Ownership Interest (%)
!Controlling Interest (%)
|-
|Entity 1
|31.0
|48.0
|40.26
|44.44
|-
|Entity 2
|26.5
|27.0
|34.42
|25.00
|-
|Entity 3
|19.5
|33.0
|25.32
|30.56
|-
|Total
|77.0
|108.0
|100.00
|100.00
|}

===== Micro-Step 1.2.2. Initial construction of the matrices =====
This step applies to both ownership and controlling interests, when already described as unique percentage values qualifying the rights of a given shareholder over one of its subsidiaries. At this stage there is a single value for a given couple entity-shareholder.

This may require to aggregate ownership and controlling interests that may have been expressed as multiple links even under their percentage form.

Once this preparation step is over, it consists in the construction of the [[Adjacency Matrix of the Shareholding Graph]].

===== Micro-Step 1.2.3. Removal of direct auto-circular rights =====
Some Entities may hold ownership and/or controlling interests in themselves. It may make sense in the context of the management of shares in a legal entity, this makes the computation of indirect links impossible.

Therefore Micro-Step 1.2.3. empties the diagonal of the adjacency matrices of the shareholding graphs to remove of such links.

Once this is done, the matrices need to be re-normalized to reallocate the rights based on a total of rights that exclude the rights that were "self-owned" by the various entities. This normalization does not treat entities that have 0 parents in the shareholding structures to avoid division by 0.

=== Step 1.3. - Indirect ownership computation ===

==== Purpose ====
The purpose of this stage is to compute the Indirect ownership matrix, to allow all the computation that require indirect ownership values between entities.

==== General Logic ====
This Step 1.3. will be based on the [[Indirect ownership computation using Baldone ownership]].

==== Data Input ====
The Data input for Step 1.3. consists in :

* The Ownership Interest Matrix computed in Step 1.2. 

The detailed matrix is available in the relevant section of the [[Pillar 2 Data Structure]].

==== Data Output ====
The Data output for Step 1.3. consists in :

* The Indirect Ownership Interest Matrix

The detailed matrix is available in the relevant section of the [[Pillar 2 Data Structure]].

==== Detailed computations ====
The detailed computation is detailed in the [[Indirect ownership computation using Baldone ownership]].
=== Step 1.4. - Controlling interest matrix computation ===

==== Purpose ====
The purpose of the the Step 1.4. is to compute the Controlling interest matrix. The ability to identify the shareholder having a direct or indirect Controlling interest in a given Entity is key at several stages of the Pillar 2 computation.

==== General Logic ====
This Step 1.4. will consist alternatively in the application of quality controls using the Share of Voting and/or ownership interest matrices, or in the computation of the controlling interests using majority rules along the shareholding chain.

==== Data Input ====
The Data input for Step 1.4. consists in :

* The precise Controlling Interest matrix;
* or alternatively the Indirect Share of Voting Rights matrix;
* or as a minimal requirement the Indirect ownership Matrix from Step 1.3.

The detailed matrix is available in the relevant section of the [[Pillar 2 Data Structure]].

==== Data Output ====
The Data output for Step 1.4. consists in :

* The list of final Controlling Interest matrix;

The detailed matrix is available in the relevant section of the [[Pillar 2 Data Structure]].

==== Detailed computations ====
The list of Micro-Step is a follows :

* Micro-Step 1.4.1. Verification of the unicity of the shareholder having a controlling interest at each level of the shareholding chain
* Micro-Step 1.4.2. Computation of the Controlling interest matrix using majority rules

===== Micro-Step 1.4.1. Verification of the unicity of the shareholder having a controlling interest at each level of the shareholding chain =====
This step .

===== Micro-Step 1.4.2. Computation of the Controlling interest matrix using majority rules =====
This .
=== Step 1.5. - Definition of the MNE Group ===

==== Purpose ====
The purpose of the Step 1.5. is to draw the perimeter of the MNE Group at the basis of the GloBE Perimeter, using the Controlling Interest Matrix and either the UPE or the Consolidation method.

==== General Logic ====
This Step 1.2. will consist in .

==== Data Input ====
The Data input for Step 1.2. consists in :

* The list of

The detailed matrix is available in the relevant section of the [[Pillar 2 Data Structure]].

==== Data Output ====
The Data output for Step 1.2. consists in :

* The list of

The detailed matrix is available in the relevant section of the [[Pillar 2 Data Structure]].

==== Detailed computations ====
The list of Micro-Step is a follows :

* Micro-Step 1.2.1.

===== Micro-Step 1.5.1. UPE identification or control =====
This step is used to identify the UPE as either :

* the only entities with:
** either :
*** no Controlling interests or,
*** which shareholder with Controlling Interest is not consolidated with no reasons listed in article 1.2.2.b),
** and that has full consolidation as consolidation method;
* the only entities
** marked "In group",
** with no Controlling Interests of shareholders also marked "In group",
** with consolidation method = full
If one or several entities are marked as UPE, errors should be returned in the following cases :

* Consolidation method for UPE is not full,
* UPE is has Controlling Interests, either
** among the entities marked "in group"
** that have a consolidation method different from "not consolidated" or that have selected one of the reasons listed in article 1.2.2.b)

===== Micro-Step 1.2.2. Unknown parents =====
This .

===== Micro-Step 1.2.3. Entity absent from the shareholding structure =====
This .
===== Case 1 : Using Controlling interests and consolidation method =====
UPE identification : entity with

* consolidation "full"
* no parent entity with
** controlling interest in it
** and consolidation method
*** full/proportional/equity
*** or not consolidated for reasons in article 1.2.2.b) "size or materiality grounds"/, or "is held for sale"

Entity is part of the MNE Group if :

* UPE has Controlling interest in the entity
* and consolidation method
** full/proportional/equity
** or not consolidated for reasons in article 1.2.2.b) "size or materiality grounds"/, or "is held for sale"

===== Case 2 : Using UPE and a group boolean indicator =====

=== Step 1.6. - Coherence check of consolidation methods ===

=== Step 1.6. - Excluded entity identification ===

=== Step 1.7. - Joint-Venture identification ===

=== Step 1.8. - MOCE and MOMNE identification ===

=== Step 1.9. - Specific CE treatments ===
Investment entity identification



==== Purpose ====
The purpose of the .

==== General Logic ====
This Step 1.2. will consist in .

==== Data Input ====
The Data input for Step 1.2. consists in :

* The list of 

The detailed matrix is available in the relevant section of the [[Pillar 2 Data Structure]].

==== Data Output ====
The Data output for Step 1.2. consists in :

* The list of 

The detailed matrix is available in the relevant section of the [[Pillar 2 Data Structure]].

==== Detailed computations ====
The list of Micro-Step is a follows :

* Micro-Step 1.2.1.

===== Micro-Step 1.2.1. Unknown subsidiaries =====
This step .

===== Micro-Step 1.2.2. Unknown parents =====
This .

===== Micro-Step 1.2.3. Entity absent from the shareholding structure =====
This .