Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
In this financial modeling course, you will learn how to perform scenario and sensitivity analysis with a focus on practical applications. You will gain a big picture outlook on a range of outcomes within a specific set of variables. Excel functions ensure you can make quick changes with a live transaction, adjusting the model as required.
This course includes a quiz that you can attempt multiple times. To ensure that your understanding of the material is accurately assessed, the correct answers will not be shown after each attempt.
Unlock learning anytime, anywhere with the Blackboard Learn app
Seamlessly access your on demand courses, assignments, and get PD hours on the go. Learn how to download now and elevate your education experience with the convenience of mobile learning.
Key Takeaways
By the end of this course, you will be able to:
- Identify the differences between scenario and sensitivity analysis.
- Build a sensitivity analysis system into your financial model.
- Create a dynamic scenario manager in Excel.
- Distinguish between direct and indirect methods of integration.
- Organize results that automatically sort data.
- Output ranking sensitivities from highest to lowest.
- Present results in a tornado chart.
Who Will Benefit
Prerequiste(s)
You are expected to have either completed Building a Financial Model in Excel and Business Valuation Modeling, or possess the equivalent knowledge prior to enrolling in this course
How to Access the Course
To access your course, visit the CPA Ontario Blackboard site and sign in using the same username and password used for the Registration Portal.
Important: Course access begins on the date of purchase and remains available for the Access Time specified for the course under Dates and Location. Please review the access time before purchasing. Note that it may take up to 15 minutes after registration for the course to appear in Blackboard.
Registration, cancellation, withdrawal, and other CPA Ontario PD policies can be found here.
Speaker(s)
Tim Vipond is an entrepreneur, financial analyst and former investment banker. He has worked across a wide range of corporate finance, financial modelling and forecasting roles at CIBC World Markets and Goldcorp Inc. Tim is the CEO of the Corporate Finance Institute®.
Lisa Dorian has designed and delivered courses for the financial services and corporate sectors in strategy and analysis to numerous organizations, including Bank of Montreal, Deutsche Bank, and ATB Financial. Lisa is a CPA and Managing Director of MDA Training Inc.
Scott Powell has over 15 years of experience designing and delivering Wall Street training programs for many of the world’s large investment banks. His clients include Allied Irish Bank, Bank of America and Merrill Lynch. Scott specializes in financial modeling, business valuations, and asset management.