013: Coles Group (ASX: COL) discounted cash flow

NOTE: This project is purely to apply concepts that I have learned from courses and certifications completed and not a formal, independent analyst opinion of any kind. Find the model here. Any feedback is welcome. Overview Extending the Coles three statement model into a discounted cash flow. Main goal was to implement some iterations on … Read more

011: Capricorn Metals (ASX: CMM) / AIC Mines (ASX: A1M) mergers and acquisitions accretion and dilution model

NOTE: This project is purely to apply concepts that I have learned from courses and certifications completed and not a formal, independent analyst opinion of any kind. Find the model here. Any feedback is welcome. Overview Another rep on the board for accretion and dilution models. This one happens to be accretive. I wanted to … Read more

010: BHP (ASX: BHP) / South32 (ASX: S32) mergers and acquisitions accretion and dilution model

NOTE: This project is purely to apply concepts that I have learned from courses and certifications completed and not a formal, independent analyst opinion of any kind. Find the model here. Any feedback is welcome. Overview Stepping away from three statement models and trying my hand at an accretion and dilution model. To try and … Read more

009: Capricorn Metals (ASX: CMM) discounted cash flow

NOTE: This project is purely to apply concepts that I have learned from courses and certifications completed and not a formal, independent analyst opinion of any kind. Find the model here. Any feedback is welcome. Overview Another DCF repetition turning the CMM three statement model into a DCF as well. Not necessarily any iterations, just … Read more

008: AIC Mines (ASX: A1M) discounted cash flow

NOTE: This project is purely to apply concepts that I have learned from courses and certifications completed and not a formal, independent analyst opinion of any kind. Find the model here. Any feedback is welcome. Overview Taking the recent redo of the AIC Mines three statement model, I’ve tacked on a discounted cash flow analysis … Read more

007: Capricorn Metals (ASX: CMM) three statement model [V2]

NOTE: This project is purely to apply concepts that I have learned from courses and certifications completed and not a formal, independent analyst opinion of any kind. Find the model here. Any feedback is welcome. Overview This was simply to revisit one of the earlier attempts at creating a three statement model from scratch where … Read more

006: AIC Mines (ASX: A1M) three statement model [V2]

NOTE: This project is purely to apply concepts that I have learned from courses and certifications completed and not a formal, independent analyst opinion of any kind. Find the model here. Any feedback is welcome. Overview Revisit of prior three statement model built on historical financial statements for this entity. Cash is reconciled. Another rep. … Read more

005: Sandfire Resources (ASX: SFR) discounted cash flow and comparables analysis

NOTE: This project is purely to apply concepts that I have learned from courses and certifications completed and not a formal, independent analyst opinion of any kind. Find the model here. Any feedback is welcome. Overview This is simply an addendum to the prior project, the three statement model for Sandfire Resources. Please note this … Read more

004: Sandfire Resources (ASX: SFR) three statement model

NOTE: This project is purely to apply concepts that I have learned from courses and certifications completed and not a formal, independent analyst opinion of any kind. Find the model here. Any feedback is welcome. Overview Another repetition on the board for preparing three statement models. Please note this does not utilise a life of … Read more

003: Capricorn Metals (ASX: CMM) three statement model [V1]

NOTE: This project is purely to apply concepts that I have learned from courses and certifications completed and not a formal, independent analyst opinion of any kind. Find the model here. Any feedback is welcome. Noted cash flow doesn’t balance, refer below. Revisited in V2.Noted cash flow doesn’t balance, refer below. Revisited in V2. Overview … Read more