Finance Cockpit Dashboard

General Description

Finance Cockpit Dashboard is a decisional tool designed to facilitate financial analysis and business piloting. It allows Management/Finance/Controlling team to follow the Financial situation of the Group/GBUs.

It consists in indicators on Balance Sheets, Profit & Loss, Cash and CFROI of the group.

The dashboard provides each month end result of the group's, GBUs' or Legal Entities' overall performance. These included comparison of Actual versus Budget, Historical, BFR in all indicators of each page (refer indicator details).

Target Users

Comex
Controlling
Finance

Authorization & Rights

All the accesses must be validated by:

Corporate Finance - point 1 and 3

GBU Finance Director + copy to Corporate Finance - point 2

1 .Lead FD Role (specific role)

2 .1 GBU / Legal Entities (of the GBU)

3 .Multi GBUs / Legal Entities

Access form

Tabs	175 KPis
Home	Overview
Profit & Loss	Controlling Statutory IFRS Bridges Analysis Net Sales Contribution Product Market Underlying EIBITDA Fixed Costs
Balance Sheet	Industrial Working Capital
Cash	Simplified Cash Flow CAPEX Working Capital Variation Free Cash Flow
CFROI
My Report	free table

General Dimensions

Group of GBUs
GBU
Operating Segment
Group of Activities
Sub Activities
Zone (BFC zone)
Legal Entity
Phases : Actual, Restated, Historical, Budget, BFC
Unity : K€ or M€

YTD/QTD:

YTD: Select the past months of the year

QTD: Select the past months in the current quarter

Current Selection: Displays the selection on unity, Operating Segment, Group of GBU, GBU, Group of Activity, Sub Activity, Zone, Legal Entity.

Phases Details

Actual	Current Year's results
Restated	Previous Year's (Y-1) results based on Current Year's structure and rate
Historical	Previous Year's (Y-1) Official results published
Budget	Official forecast for Current Year defined in October Previous Year (Y-1)
BFR	4 re-forecast for Current Year : BFR03/BFR06/BFR09/BFR12 = (Official forecast for Current Year defined in October Previous Year - Total Actual Q1+Q2+Q3)

BFC Flows
F99	CLOSING BALANCE
RS99	Closing RSB
RS80	Foreign exchange Gain/Loss
F20	INCREASE
F23	CAPITALIZED INTERESTS
F53	INTERNALLY GENERATED FIXED ASSETS
F15	VARIATION
RS100	RSB - Dec Tx Current Month
F06	DIVIDENDS PAID
RS50	RECLASSIFICATION
C04	NET BOOK VALUE (NBV)
Annualized [01] = 12 x [01]; [02] = 6 x ([01] + [02]); [03] = 4 x ([M-2] + [M-1] + [M])

Period of Analysis
Year - 1 Year Month Quarter Quarter To Date Year To Date

Currencies
EUR

My Account
Depending on your dashboard authorization(s), you can switch from GBU view to Legal Entity view (for Lead FD) by following below steps:

Page tree

Corporate Financial Function

Marie-Line Ardito

Finance Cockpit Dashboard is a decisional tool designed to facilitate financial analysis and business piloting. It allows Management/Finance/Controlling team to follow the Financial situation of the Group/GBUs.

It consists in indicators on Balance Sheets, Profit & Loss, Cash and CFROI of the group.

The dashboard provides each month end result of the group's, GBUs' or Legal Entities' overall performance. These included comparison of Actual versus Budget, Historical, BFR in all indicators of each page (refer indicator details).

Comex

Controlling

Finance

All the accesses must be validated by:

Corporate Finance - point 1 and 3

GBU Finance Director + copy to Corporate Finance - point 2

1 .Lead FD Role (specific role)

2 .1 GBU / Legal Entities (of the GBU)

3 .Multi GBUs / Legal Entities

175 KPis

Overview

Bridges Analysis

free table

Group of GBUs

GBU

Operating Segment

Group of Activities

Sub Activities

Zone (BFC zone)

Legal Entity

Phases : Actual, Restated, Historical, Budget, BFC

Unity : K€ or M€

YTD/QTD:

YTD: Select the past months of the year

QTD: Select the past months in the current quarter

Current Selection: Displays the selection on unity, Operating Segment, Group of GBU, GBU, Group of Activity, Sub Activity, Zone, Legal Entity.

Current Year's results

Previous Year's (Y-1) results based on Current Year's structure and rate

Previous Year's (Y-1) Official results published

Official forecast for Current Year defined in October Previous Year (Y-1)

4 re-forecast for Current Year : BFR03/BFR06/BFR09/BFR12 = (Official forecast for Current Year defined in October Previous Year - Total Actual Q1+Q2+Q3)

F99

CLOSING BALANCE

RS99

Closing RSB

RS80

Foreign exchange Gain/Loss

F20

INCREASE

F23

CAPITALIZED INTERESTS

F53

INTERNALLY GENERATED FIXED ASSETS

F15

VARIATION

RS100

RSB - Dec Tx Current Month

F06

DIVIDENDS PAID

RS50

RECLASSIFICATION

C04

NET BOOK VALUE (NBV)

Annualized

[01] = 12 x [01];

[02] = 6 x ([01] + [02]);

[03] = 4 x ([M-2] + [M-1] + [M])

Year - 1

Year

Month

Quarter

Quarter To Date

Year To Date

EUR

Depending on your dashboard authorization(s), you can switch from GBU view to Legal Entity view (for Lead FD) by following below steps: