Calcul Sheet Good Version.xlsx - Income Statement Sales Cost of Sales Gross Margin R&D costs Administrative and marketing costs EBITDA

Calcul Sheet Good Version.xlsx - Income Statement Sales...

This preview shows page 1 - 7 out of 33 pages.

Income Stateme 2014 2015 2016 Sales 72874 75006 77565 Cost of Sales -55595 -57405 -61151 Gross Margin 17279 17601 16414 R&D costs 0 0 0 Administrative and marketing costs -212 -885 8 EBITDA 17067 16716 16422 Depreciation&Amortization -9083 -12436 -8908 EBIT 7984 4280 7514 Other income (costs) 0 0 0 Financial income (costs) -2551 -2588 -3333 Non-recurring Items 0 0 0 Profit before Taxes 5433 1692 4181 Income Tax -1660 -291 -1170 Net Income 3773 1401 3011
Image of page 1
ent 2017 2018 Taken into acount 76119 68976 -62377 -53711 13742 15265 "Sales"+"Cost of sales" 0 0 1363 -105 -"Autre produits et charges d'exploitation" 15105 15160 -9468 -9878 5637 5282 0 0 -2236 -4809 0 0 3401 473 "Résultat avant imôt des sociétés intégrées" -112 718 -"Impôts sur les résultats"+"quote-part de résultat net..." 3289 1191 "Résulat net consolidé" "Chiffre d'affaires" + "Autres produits et charges opérationnelles" combustibles externes"-"Charges de personnel"-"Impôts et taxes" amortissement"-"Dotations nettes aux provisions"-"(Pertes de valeur)/reprise" l'actualisation"-"Autres produits et charges financier" OR "Résultat finacier"
Image of page 2
Cash Flow Statem 2014 2015 2016 Net Income 3773 1402 3011 Depreciation&Amortization 9083 12436 8908 Cash Flow 12856 13838 11919 Change in Net Working Capital -2231 16396 0 Cash Flow from Operating Activities 10625 12730 11125 Cash Flow from Investing Activities -12393 -18839 -16557 Free Cash Flow -1768 -6109 -5432 Proceeds from share issues 3422 7270 3226 dividends paid -2199 -1696 912 Increase (decrease) in Net Debt -545 -535 -1294
Image of page 3
ment 2017 2018 Taken into acount 3289 1191 9468 9878 12757 11069 -794 2295 11663 13364 -11713 -17165 -50 -3801 -3476 2679 4188 851 662 -271 "Net income" from income statement "Depreciation&..." from income statement in positive" "Flux de trésorerie nets générés par l'exploitation" "Flux de trésorerie nets liés aux opérations d'exploitation" opérations d'investissement" "Autres flux de trésorerie liés aux opérations de finacement" "Flux de trésorerie avec les actionnaires" et des équivalents de trésorerie"
Image of page 4
Balance Sh 2014 2015 Cash 4701 4182 Short-Term Investments 20752 27019 Accounts Receivable 8793 8807 Stocks and Inventories 14747 14714 Other Current Assets 23776 23474 Total Current Assets 72769 78196 Fixed Assets Intangible fixed assets 18578 19125 Tangible fixed assets 127500 130314 Financial fixed assets 49142 51306 Total Fixed Assets 195220 200745 Total assets 267989 278941 Current liabilities Accounts payable 14864 13284 Other Current Liabilities 43028 46955 Total Current Liabilities 57892 60239 Non-current liabilities Long-term debts 169487 178462 Total non-current liabilities 169487 178462 Total Liabilities 227379 238701 Shareholder's equity Capital 35191 34749 Retained earnings 5419 5491 Total Shareholder's equity 40610 40240 Total Liabilities + SE 267989 278941 Current Assets
Image of page 5
heet ="Bilan consolidé" 2016 2017 2018 Taken into acount 2893 3692 3290 29986 24953 31143 "actifs financiers courants" 10652 9561 7346 "Autres débiteurs courants" 14101 14138 14227 "Stock" 28699 24084 16779 86331 76428 72785 "Actif courant" 16373 18932 20113 "Goodwill"+"Autres actifs incorporels 131253 137968 142106 "Sum of all "Immobilisations..." 47683 47424 48165 195309 204324 210384 281640 280752 283169 24414 24960 "fournisseur et compte rattaché" 39076 "sum of all rest of "passif courant" 63490 55767 52815 "Passif Courant" 176788 176287 177708
Image of page 6
Image of page 7

You've reached the end of your free preview.

Want to read all 33 pages?

  • Fall '19

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors