Versions Compared

Old Version 8

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.
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
  • Finance
    Comex
  • Controlling
  • Finance
Info
iconfalse
titleAuthorization & Rights
All the accesses must be validated by:
Corporate Finance
Authorisations' rights:
- point 1 and 3
GBU Finance Director + copy to Corporate Finance - point 2
1 .Lead FD Role (
Requester's selection on
specific role)
2 .1 GBU / 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)
    • (of the GBU)
    3 .Multi GBUs / Legal Entities
    Access form
    Tabs

    175 KPis

    Home
    Profit & Loss
    Balance SheetCash

    17

    KPis

    • Overview
    CFROIMy Page
    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.
     
    Capex (YTD)Capspend (YTD)Commitments (YTD)Total Projects without Budget

    Image Removed

    Total projects > Budget

    Image Removed

    Total projects "Late"

    Image Removed

    Total 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.
    Note
    iconfalse
    titleNotes In Dashboard Tab
    Anchor
    CapexCapex
    It’s the amount paid during the current year. Amount is without tax.
    Anchor
    CapspendCapspend
    It’s the actual costs for the current year. Amount is without tax.
    Anchor
    CommitmentsCommitments
    It’s the current amount of the purchase requests and orders not yet received. Amount is without tax.
    Anchor
    Total Projects without BudgetTotal Projects without Budget
    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.
    Anchor
    Total projects BudgetTotal projects Budget
    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.
    Anchor
    Total projects LateTotal projects Late
    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.
    Anchor
    Total projects InactiveTotal projects Inactive
    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
      Month
    • Quarter To Date
    • Year To Date
    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)
    Currencies
    • EUR
      , USD, BRL, SGD, PLN, CNY, KRW, INR
    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