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 mine model, I’m either using growth rates and ratios based on historical financials or making up certain assumptions to have numbers to play with.
Takeaways
- In balancing at the end with the cash flow reconciliation, I realised that though I had been able to balance my prior models I actually did it wrong. I have done it properly in this model.
- I realised I am probably overcomplicating things. Given the nature of the exercise as long as drivers and directional movement in financial statement line items are reasonable, the outcome will also be (to a certain extent). Obviously subject to circumstances and purpose of the model. I am challenging myself and trying to get as many reps in as I can.