My worksheets basically allow me to put it any combination of follwing variables (P205 price, MTPA output, CAPEX, tax rate, discount rate and any royalties)
It does not factor in finance costs ie interest cost of debt.
It then puts out
REVENUE
OPEX
EBITDA
D&A
EBIT
NPAT
Free Cashflow
NPV
So I can factor in combination of variables to see sensitivity of cashflows and NPV. It doesn't do the sensitivity chart that you sometimes see as Im not that advanced with excel.
My worksheets basically allow me to put it any combination of...
-
- There are more pages in this discussion • 30 more messages in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)
