Building a Financial Model, DCF Valuation Analysis and Excel
Building a Financial Model:
This hands-on course focuses on the skills required to design and create an interactive financial model of a company that adheres to the highest industry standards. The course material includes model
design, logic, construction, financial concepts and accounting treatment. During the seminar, participants will build a model that includes a forecast of a company’s income statement,
cash flow statement and balance sheet.
Prerequisites: Participants should have a solid grasp of basic accounting fundamentals and proficiency with Excel prior to taking this course.
This hands-on course is focused on the practical implementation of a Discounted Cash Flow (“DCF”) valuation analysis. The skills required to build a DCF analysis will be discussed and incorporated into a financial model. Participants will learn to recognize and
avoid the most common errors that finance professionals make when creating a DCF analysis. This course will also include a number of Excel tips and skills to help a user check and audit a financial model.
Data Manipulation with Excel:
This hands-on course is an intensive program that will transform
participants into Excel “Power Users”. The course is focused on the pertinent Excel tools that are required in a business environment to efficiently analyze and manipulate data and to create compelling financial analyses. The course covers intermediate and advanced level Excel topics. As such, participants should have a good
working knowledge of Excel prior to taking this course.
Assignments, handouts and examples
will be used throughout the day.
Member Price: $1500
Non-member Price: $2250
Candidate Price: $2250
You may also like the following events from CFA Society Calgary: