Some more errors corrected.
- EV = MktCap+Debt - Cash and Cash Equiv, or in the excel it should be
EV=B26+‘Data Sheet’!B59-‘Data Sheet’!B69
another inadvertent error - don’t know how that that ‘Data Sheet’!C83 crept in
so just deleting that ‘Data Sheet’!C83 and copying teh formula across columns would do the job
Everyone using this Excel please make the change.
2.Operating Cash Flow doesn’t need any calculations:). Its a straight lift from the Data Sheet B82 from the Cash Flow section
Delete the others ‘Data Sheet’!D53 & ‘Data Sheet’!D77 please and copy across all the columns will do the job.
Corrected Excel. Also uploaded corrected Excel in original post before
Zenith Fibres.xlsm (85.4 KB)