Co$ta - Anaplan Bridge Calculation

>> Back to the Co$ta project home page

Bridge from Origin to Destination for EBITDA calculation steps


You can check here the bridge process.

Calculation in resume:

  • Starting from Anaplan Scope
  • Removing the items that are not included in EBITDA, such as Capex, B/S elements, Taxes, etc...
  • Adding the billing and internal allocations
  • Adding the  inventory consumption, such as spare parts (going to P&L on Destination)


Remark: Costs at Origin of Anaplan scope do not consider Origin flow: " FI: Packaging & Spare parts reception "

Remember that the bridge is done by Anaplan scope, which is different scope of COSTA Destination total figures. You can check detailed information of Anaplan scope here.

In resume:


Bridge Items:

CAPITAL LEASE

This represents the costs settled to IFRS16 (Destination type "IFRS16" on COSTA). As per IFRS16 Lease costs are not included in EBITDA.

Don't forget that bridge figures are of Anaplan scope:

In the example above the amount considered for Anaplan bridge is 33.784K as 932K are already out of Anaplan scope, so no need for adjustment through the bridge.


GOOD CONSUMED FROM INVENTORY

Destination view ignores Origin Flow FI (linked to purchasing of goods) and replaces it by Inventory consumption, using the flow from where it is consumed.

The way to identify this costs in BW, is filtering the cost elements that explain this flow (consumption of spare parts and packaging). See full detail here

Don't forget that bridge figures are of Anaplan scope:

In the example above the amount considered for Anaplan bridge is 3.968K as 319K are already out of Anaplan scope, so no need for adjustment through the bridge.


CAPITALIZATION

Capitalized costs in Anaplan scope like maintenance, development costs for R&I, IT projects, Regulatory and Capitalized commercial costs, need to be excluded from EBITDA bridge calculation. This costs are capitalized via WBS projects and represented in COSTA on destination type "CAPEX". 

Don't forget that bridge figures are of Anaplan scope:

In the example above the amount considered for Anaplan bridge is 15.423K as 12K are already out of Anaplan scope, so no need for adjustment through the bridge.


STOCK VC

Inventory consumption and benefits / costs related to the same (Raw materials, Hedge, etc...) allocated to production variable costs.  

Don't forget that bridge figures are of Anaplan scope:

In the example above the amount considered for Anaplan bridge is 1.235K as 172K are already out of Anaplan scope, so no need for adjustment through the bridge.


BALANCE SHEET

This costs are primary posted in P&L cost elements and after settled to Balance sheet accounts. They are represented in COSTA on destination type "GLACC".

Don't forget that bridge figures are of Anaplan scope:

In the example above the amount considered for Anaplan bridge is 933K as 171K are already out of Anaplan scope, so no need for adjustment through the bridge.


ERROR

Specific cases where the difference between Origin and Destination is >150% or <0%. This cases are excluded from the Matrix calculations and its applied the rule Destination = Origin, this means we don't know the real destination type and for that reason they are not considered for EBITDA calculation. They are represented in COSTA on destination type "ERROR".

Don't forget that bridge figures are of Anaplan scope:

In the example above the amount considered for Anaplan bridge is 2.550K as 223 are already out of Anaplan scope, so no need for adjustment through the bridge.


NON ERP

This value is uploaded manually for the Origin view of Non ERP entities. Because there is no assignment to destination type (PL, Capex, etc...) this amount is excluded from EBITDA. 


BILLING

Charge Out - The cost is reflected in destination type Billing. If it is a Interco billing the info of partner responsible CC and GBU

Charge In - The cost perspective of the Billing receiver GBU


INTERNAL ALLOCATION

Charge Out - The cost is reflected in destination type PL. The cost moves from a GBU at Origin to another GBU in Destination

Charge In - The cost perspective of the Internal Allocation at the receiver GBU

Don't forget that bridge figures are of Anaplan scope:

In the example above the amount considered for Anaplan bridge is 97.849K as -7.125K are already out of Anaplan scope, so no need for adjustment through the bridge.


POST UNDERLYING EBITDA LINES

Costs with Destination Type "PL"  that do not make part of EBITDA calculation, namely:

  • Interests
  • Taxes
  • Depreciation
  • Amortization