Calculation guide
Use subsidiary profit after consolidation adjustments attributable to it, including upstream eliminations. Enter parent-only profit separately.
Inputs
Subsidiary reported profit
Example entry 50000 (in the selected currency).
Signed subsidiary consolidation adjustment
Example entry -5000 (in the selected currency).
Parent-only profit after adjustments
Example entry 100000 (in the selected currency).
Noncontrolling ownership
Example entry 20 %. Allowed range 0 to 100.
Worked example
| Input | Value |
|---|---|
| Subsidiary reported profit | 50,000 |
| Signed subsidiary consolidation adjustment | -5,000 |
| Parent-only profit after adjustments | 100,000 |
| Noncontrolling ownership | 20% |
| Result | Value |
|---|---|
| Profit · Non-controlling interests | 9,000 |
| Profit · Parent owners | 136,000 |
| Profit · Consolidated | 145,000 |
Calculation steps
Profit attributable to NCI = (((Subsidiary reported profit + Signed subsidiary consolidation adjustment) × Noncontrolling ownership) ÷ 100)
(((50,000 + -5,000) × 20) ÷ 100) = 9,000
Profit attributable to parent owners = (Parent-only profit after adjustments + ((Subsidiary reported profit + Signed subsidiary consolidation adjustment) × (1 − (Noncontrolling ownership ÷ 100))))
(100,000 + ((50,000 + -5,000) × (1 − (20 ÷ 100)))) = 136,000
Consolidated profit = ((Parent-only profit after adjustments + Subsidiary reported profit) + Signed subsidiary consolidation adjustment)
((100,000 + 50,000) + -5,000) = 145,000
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Subsidiary reported profit | 50,000 | 55,000 | Profit · Non-controlling interests | 9,000 | 10,000 |
| Signed subsidiary consolidation adjustment | -5,000 | -4,500 | Profit · Non-controlling interests | 9,000 | 9,100 |
| Parent-only profit after adjustments | 100,000 | 110,000 | Profit · Parent owners | 136,000 | 146,000 |
| Noncontrolling ownership | 20% | 22% | Profit · Non-controlling interests | 9,000 | 9,900 |
