| Must be 3 consecutive years |
| 2018 | 2017 | 2016 |
| EARNINGS BEFORE TAX & INTEREST | 556150 | 9819 | -340866 |
| INCOME BEFORE TAX | 423544 | -95418 | -440834 |
| INCOME TAX EXPENSE | -782052 | 12645 | 16039 |
| APPROXIMATE TAX RATE | -1.85 | -0.13 | -0.04 |
| NOPAT | 1583052.0923446 | 11120.2351443124 | -353267.833284184 |
| OCA | 2796079 | 2557195 | 1866215 |
| OCL | 1516311 | 583278 | 584021 |
| NOWC | 1279768 | 1973917 | 1282194 |
| NFA (PROPERTY, PLANTS & EQUIPMENT) | 885078 | 773715 | 783901 |
| TOC | 2164846 | 2747632 | 2066095 |
| FCF | 2165838.0923446 | -670416.764855688 |
| Assets |
| Current Assets |
| Cash |
| Cash and Cash Equivalent | 1894444 | 1638413 | 988598 |
| Short Term Investments | 4314957 | 2764689 | 2785981 |
| Total Cash | 6209401 | 4403102 | 3774579 |
| Net Receivables | 788700 | 664268 | 650650 |
| Total Current Assets | 7111036 | 5321884 | 4652196 |
| Non-current Assets |
| Property, plant and equipment |
| Gross property, plant and equipment | 885078 | 773715 | 783901 |
| Accumulated Depreciation | -1280174 | -1154373 | -857927 |
| Net property, plant and equipment | 885078 | 773715 | 783901 |
| Goodwill | 1227269 | 1188935 | 1185315 |
| Intangible Assets | 45025 | 49654 | 95334 |
| Other long-term assets | 85705 | 78289 | 153619 |
| Total non-current assets | 3051536 | 2090593 | 2218169 |
| Total Assets | 10162572 | 7412477 | 6870365 |
| Liabilities and stockholders' equity |
| Liabilities |
| Current Liabilities |
| Accrued liabilities | 405751 | 327333 | 380937 |
| Deferred revenues | 38949 | 27824 | 33659 |
| Total Current Liabilities | 1516311 | 583278 | 584021 |
| Non- current Liabilities |
| Long Term Debt | 1730922 | 1627460 | 1538967 |
| Deferred taxes liabilities | 17849 | 13240 | 7556 |
| Other long-term liabilities | 67502 | 59973 | 68049 |
| Total non-current liabilities | 1840667 | 1781981 | 1681409 |
| Total Liabilities | 3356978 | 2365259 | 2265430 |
| Stockholder's Equity |
| Common Stock | 4 | 4 | 4 |
| Retained Earnings | -1454073 | -2671729 | -2550350 |
| Accumulated other comprehensive income | -65311 | -31579 | -69253 |
| Total stockholders' equity | 6805594 | 5047218 | 4604935 |
| Total liabilities and stockholders' equity | 10162572 | 7412477 | 6870365 |
othman1995
Freecashflowexample.xlsx
