Write your awesome label here.

Exotic Options Foundations

Microsoft Excel is a powerful tool. There are countless ways of using Excel to analyze, manipulate, and present financial data in a clear and concise format. For any aspiring investment banker, proficiency in Excel is a critical part of the job description.

21 Modules

Overview

Certificate

Buy Now

Microsoft Excel is a powerful tool. There are countless ways of using Excel to analyze, manipulate, and present financial data in a clear and concise format. For any aspiring investment banker, proficiency in Excel is a critical part of the job description.

Excel’s advanced features and functionality are used by banks and other financial institutions to solve a wide variety of financial problems, including discounted cash flow (DCF) evaluation, financial statement ratio analysis, stock valuation, bond pricing, option valuation, portfolio management, correlation and regression analysis, sensitivity analysis, and scenario analysis. But the focus in this course is not on any of the topics listed above. You need to be able to “walk before you run,” so this course focuses more on teaching you to use Excel both efficiently and effectively.

It's hard – though some may try – to avoid spreadsheets in the world of banking and finance. They are an indispensable tool in financial modeling and analysis. Good, fundamental Excel training will help you build a solid foundation for mastering the use of spreadsheets, assisting you to use them confidently throughout your career.

Once you’ve mastered the basics, you can start to harness the power of Excel in your day-to-day job and use it to perform tasks such as those listed earlier.

Exotic Options Basics.
Path Dependent Options.
Forward Start Options.
Exotic Options Considerations.
Barrier Options – Basics, Strategies, Pricing, and Risks.
Average Rate Options.
Basket Options.
Spread Options.
Exotic Option Payoffs.
Asian Option Payoffs.
Basket Option Calculations.
Structured Product Calculations.

This course is designed for derivatives professionals such as Derivatives traders, both sell-side and prop, Risk managers, Auditors, and product controllers, Junior quant analysts.