Anne-Claire

- Development / modification / verification of Business Plans (investments, sales, acquisitions),
- Financial analyses and verification of the BP's hypotheses (data collection),
- Presentation for internal / external use,
- Preparation of investment notes,
- Sectoral research,
- Portfolio review, meeting preparation, database maintenance, etc.

Work in coordination with several teams within EDF (Group Finance Department (Investments, M&A, Controlling), Legal Department, Tax Department, and other Group entities).

Encres DUBUIT is a French manufacturer of industrial inks for screen printing, pad printing and digital printing.

- Elaboration of the Economic and Social Data Base of the company (mandatory under French law) : extracting social data from the payroll software, processing these data on Excel to construct the required social indicators, recording all manipulations and formulas used, elaboration of the complete Excel and Word frames for the future updates of the Data Base

- Improvement of an Excel document consolidating the gross revenues of Encres DUBUIT group’s subsidiaries: Processing data from subsidiaries’ Excel files, enhancement of the formulas importing data from subsidiaries’ Excel files in the consolidation table

- Computation and research of effective interest rates to account for leasing contracts under IFRS16: computation of effective interest rates based on leasing contracts’ information ; research of relevant standard rates reflecting country risk, industry risk, size of subsidiary, object of the rent ; computation of the sum of actualised lease payments per subsidiary

- Softwares used : Nibélis (payroll software), Excel (basic and pivot tables ; conditional formatting ; formulas IF, VLOOKUP, INDEX+MATCH), Word (automatic table of content, linking content with Excel files, analysis of numerical indicators)

- Participation to missions in various industries : garages, automotive spare parts, cleaning services, pharmacy,… (in average, change of client and location every week)

- Elaboration of a valuation tool based on Excel, based on actualised cash flows

- Elaboration of an analysis of a client’s revenues and gross margin in comparison with the industry averages. Data bases used : Xerfi’s annual industry analysis, Diane data base

- Control of the trustworthiness of accounts classes presented in clients’ general accounting balances (Cash at bank, Loans, Suppliers, Clients, Stocks, PP&E, Equity)

- Softwares used : eAudIT, IDEA, Excel

- Improving the Days of Sales Outstanding ratio of the company : Analysing clients' accounts receivable ; determining which invoices to remind to clients ; reaching out to clients in the most adequate way ; keeping track of actions already taken ; planning next actions

- Taking Credit Management to the next level : Participation to Excel analyses identifying the weaknesses and strengths of the company's different scopes regarding the collection of receivables ; redaction of processes and methods to favor an increasing mastery of the softwares and analyses over the company's long run

- Calculation of the provisions for doubtful accounts, based on the knowledge about clients' solvability and willingness to pay

- Softwares used : CEGID, CashOnTime, Excel