Versions Compared

Old Version 3

changes.mady.by.user Li Lian Cheong

Saved on

compared with

New Version Current

changes.mady.by.user Marie-Line Ardito

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

Info
iconfalse
titleProcess Owner
François Carette
 Performance & Capex Reporting Manager - GEC
Corporate Financial Function
Info
iconfalse
titleD&PS Expert
Marie-Line Ardito

General Description

Capex Dashboard consists indicators on Budget, Capex, Capital Spend, Downpayment and Commitments
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
Capex
dashboard provides
"actual" status and cost of projects allowing GBUs' controllers and project managers to keep track on all projects of its movement as and when needed. The dashboard also provides a "Cash Due" information where it shows the upcoming amount that needed to be pay to suppliers in coming months.
TabsHomeProfit & LossBalance SheetCashCFROIMy Page

17

KPis

  • Overview
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).
Info
iconfalse
titleTarget Users
  • Comex
  • Controlling
  • Finance
Info
iconfalse
titleAuthorization & 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
Profit & Loss
EIBITDA
Balance Sheet
Industrial Working Capital
Cash
CFROI 
My Report
General Dimensions
  • Group of GBUs
  • GBU
  • Operating Segment
  • Group of Activities
  • Sub Activities
  • Zone (BFC zone)
  • Legal Entity

  • Operating Segment
  • Group of GBU
  • GBU
  • Group of Activity
  • Sub Activity
  • QTD/YTD:
    • QTD - Select the past months in current quarter
    • YTD - Select the past months of current year
  • Unity: K€ or M€
  • Phrase: Historical, Budget, BFC
    • Phases : Actual, Restated, Historical, Budget or Budget Y+1, 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.
     
    Note
    iconfalse
    title
    Notes In Dashboard Tab AnchorCapexCapexCapex (YTD)
    It’s the amount paid during the current year. Amount is without tax.
    AnchorCapspendCapspendCapspend (YTD)
    It’s the actual costs for the current year. Amount is without tax.
    AnchorCommitmentsCommitmentsCommitments (YTD)
    It’s the current amount of the purchase requests and orders not yet received. Amount is without tax.
    AnchorTotal Projects without BudgetTotal Projects without BudgetTotal Projects without Budget

    Image Removed

    This indicated the number of projects with movement during the selected period which are without Budget and percentage of these projects against total number of projects with movement during the selected period. By double clicking on this box in the dashboard, you will be able to see the list of projects that are without budget.
    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
    F99AJ
    Adjusted
    FA99EX
    Exceptional
    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])
    Sources 
    BFC
    All except below listed managed by Corporate Finance
    Manual Files
    • BFR  – quarterly basis
    • WACC Corporate – updated by the Corporate Finance
    • WACC GBUs – updated by the Corporate Finance
    • Tax Rate – updated by the Corporate Finance
    • Maintenance rate – updated by the Corporate Finance
    • Free cash flow – updated by the Corporate Finance. Actual by month, Historical by quarter, budget of the Year and BFR by month :
      • Delta working capital others
      • Tax cash out
      • Provisions cash out
      • Others & Disc. opFree cash flow
    Period of Analysis
    • Year - 1
    • Year
    • Month
    • Quarter
    • Quarter To Date
    • Year To Date
    Currencies
    • EUR
    My Account
    Image AddedDepending on your dashboard authorization(s), you can switch from GBU view to Legal Entity view (for Lead FD) by following below steps:

    Image Added

    Dashboard refresh frequency
    From the 4th to the 25th of each month :

    Image Added

    AnchorTotal projects BudgetTotal projects BudgetTotal projects > Budget

    Image Removed

    This indicates the total number of projects with movement during the selected period exceed Budget and percentages of these projects against total number of projects with movement during the selected period. By double clicking on this box in the dashboard, you will be able to see the list of projects that are over budget.
    AnchorTotal projects LateTotal projects LateTotal projects "Late"

    Image Removed

    This indicates the number of projects with movement during the period that exceed the initial planned completion date and the percentage of these projects against total number of projects. By double clicking on this box in the dashboard, you will be able to see the list of projects that are late.
    AnchorTotal projects InactiveTotal projects InactiveTotal projects "Inactive"

    Image Removed

    This indicates the number of projects that are inactive for more than 6 months and percentage of these projects against total number of projects. By double clicking on this box in the dashboard, you will be able to see the list of projects that are inactive.
    Period of Analysis
    • Year - 1
    • Year
    • Quarter
    • Month
    Currencies
    • EUR, USD, BRL, SGD, PLN, CNY, KRW, INR
    • Conversion rate : End of month
      For Budget, rate of the project creation date. If this date is empty, last know rate (M-1 Y)
      For Capital Spend and Capex, historical rate (eg. CAPEX of January 2015 ===> conversion rate end of January 2015)  
    Info
    iconfalse
    titleTarget Users
    • Finance
    • Controlling
    Info
    iconfalse
    titleAuthorization & Rights
    All the accesses must be validated by:
    Corporate Finance
    Authorisations' rights:
    • Lead FD Role (Requester's selection on Legal Entities regardless of GBUs)
    • Selected GBU (Requester's designated GBU regardless of Legal Entities)
    • Both (Requester's selections on access to specific Legal Entities and GBUs)
    Access form