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 the workpaper to include both perpetual growth and implied multiple, multiple and implied terminal growth rate.
The three statement model uses growth rates inherent within the past three financial statements (30 June 2023 – 30 June 2025), i.e., historical growth rates. Assumed WACC of 8%: made up, no basis. Assumed EBITDA multiple of 10: made up, no basis.
