| Name |
| Must be 3 consecutive years |
| 2019 | 2018 | 2017 |
| EARNINGS BEFORE TAX & INTEREST |
| INCOME BEFORE TAX |
| INCOME TAX EXPENSE |
| APPROXIMATE TAX RATE | B6/B5 | B6/B5 | B6/B5 |
| NOPAT |
| OCA |
| OCL |
| NOWC |
| NFA (PROPERTY, PLANTS & EQUIPMENT) |
| TOC |
| FCF |
| ENTER BALANCE SHEET ACCOUNT NAMES BELOW |
| and the corresponding amounts to the right. If an account has |
| zero balance in all three years omit it. Do not copy and paste. |
| doing so can cause some problems. Do not use a dash ( - ) to |
| represent a zero. Use a zero, 0. Otherwise, you will cause yourself |
| some problems. |
| You can go to yahoo finance to get accounting data. Do not use a |
| financial institutions such as banks, insurance companies etc. Use |
| manufacturing and/or retail firms. |
othman1995
FIN443FCFPROJECT2019-1.xlsx
