Share via

ICE for equity template

  • Article

When you complete the ICE for Equity template with appropriate account information, this rule eliminates equity that a holding company has in its consolidated subsidiaries.

This rule selects members that have account types Equity and BS-Net Income. Because these account types do not allow for intercompany (IC) transactions, no IC partners are selected for rule application. For more information about Account types, see the topic About the Account dimension.

Note

When a rule eliminates a transaction value, the consolidation process removes a transaction from the aggregated total and makes a corresponding adjustment to the Elimination member of the Business Process dimension. For more information, see the topic About the Business Process dimension.

For examples that show more about how to customize this template, see the topic Examples: Customized consolidation rule templates.

For information about how Planning Business Modeler determines values for percent consolidation (PCON), see About measure groups for shares calculation and consolidation.

Prerequisites

The following list shows the tasks that are prerequisite for a rule that you create with this template:

Placeholder substitution requirements

To use the ICE for Equity template to make a business rule, you must substitute actual account values for the placeholders in the template. For information about how to substitute values, see the topic Filling a placeholder in a rule template.

The following table describes the placeholder substitutions that you must make for IC transactions of this kind. In addition, the table describes the adjustments that this rule performs when these values are supplied.

If Flow member for cell has Flow type Placeholder substitutions required Rule action

Prior year adjustment (PY Adj)

  • Equity Clearing account

  • Minority Equity account

  • Eliminates the equity transaction by multiplying the value by percent consolidation (PCON) for the prior year

  • Multiplies the transaction value by percent ownership for prior year (POWN_1), and posts the result in the Equity Clearing account

  • Multiplies the transaction value by minority interest for the prior year (PMIN_1), and posts the result in the Minority Equity account

Other than PY Adj or FXO

  • Equity Clearing account

  • Minority Equity account

  • Eliminates the equity transaction by multiplying the value by percent consolidation (PCON)

  • Multiplies the transaction value by percent ownership (POWN), and posts the result in the Equity Clearing account

  • Multiplies the transaction value by minority interest (PMIN), and posts the result in the Minority Equity account

See Also

Concepts

Consolidation rules
ICE for investments template
ICE for profit and loss template
ICE for balance sheet template