Financial Forecasting & Modelling

Danielle Stein Fairhurst

Self paced
Finance
3 days

NaN:NaN:NaN

NaN:aN / NaN:aN

Free

Enroll Now

Download Brouchure

Share on

Key takeaways

Grasp the basics of excel functions and formatting, from simple formulas to best practices that are common in the industry
Understand how to build a financial statement model that’s modular, scalable and user-friendly
Learn how to reach the value of a company or a stock and decide whether under, fairly or over-priced through a combination of valuation methods, including Discounted Cashflow model, Leveraged Buyout model, Management Buyout Model and Multiples valuation method

Course overview

This course is designed to establish the necessary excel foundation regarding the various tools available at the participant disposal and teach how to use them to create financial models. Participants will be able to read and construct financial models through the various best practices discussedin the course. Furthermore, the course utilizes this excel knowledge to explain debt repayments, scenario analysis and various valuation methods such as a Discounted Cashflow Model and a Leveraged Buyout Model, alongside the necessary information needed to conduct them such as Beta, CAPM and WACC. Practical examples and case studies will be utilized and shared throughout the course, with participants encouraged to solve alongside the instructor to enhance the learning experience.

Syllabus

This Course Includes

Educational Content
Lifetime Access
Quizzes and Assignments
Downloadable Resources
Certificate of Completion
Taught by an Industry Expert

Instructors

Danielle Stein Fairhurst

Financial Modeller & Author

Danielle Stein Fairhurst is regularly engaged as a speaker, course facilitator, financial modelling consultant and analyst. She founded the Financial Modellers' Meetup groups (which currently meet virtually) and she is the author of "Using Excel for Business and Financial Modelling" Third Edition and "Financial Modeling in Excel For Dummies". With many years of experience, a talent for financial modelling and professional approach, she helps her clients create meaningful financial models in the form of business cases, pricing models and management reports. She runs regular training seminars around Australia and globally, and her custom-built training courses have been described by attendees as well-presented, neatly structured, informative, practical, and extremely relevant to their everyday needs. She is available for presentations, workshops, training courses, lectures and seminars. Topics include Financial Modelling using Excel, Budgeting & Forecasting and Data Analysis & Reporting.She holds a Master of Business Administration (MBA) from Macquarie Graduate School of Management, and has taught management accounting subjects at Sydney University. She is on the judging panel for the 2020 Financial Modelling Innovation Awards, the Advisory Board of the Financial Modeling Institute (FMI) and was on the Diversity Council for the ModelOff Financial Modeling World Championships.

View Profile