OVERVIEW

Gain comfort with the core, fundamental mathematical techniques used throughout the financial industry, with an emphasis on the time value of money.

LEARNING OBJECTIVES

• Solve Future Value, Present Value and Yield calculations
• Value Annuities, Perpetuities and Growing Perpetuities
• Apply time value of money techniques to a Discounted Cash Flow (DCF) valuation and bond pricing
• Calculate Annual Equivalent Rates of interest
• Understand and calculate mean, median, variance and standard deviation for a data set.

TOPICS COVERED

Complete topics step by step or jump to any of the below at any time.

OVERVIEW

By utilizing both basic and advanced Excel tools, this course is designed to dramatically improve a participant’s ability to use Excel efficiently. Whether you’re an investment banker, consultant, accountant, or specialist in healthcare, technology or industrials, this class offers the broadest, most valuable Excel skill set of any of course we offer.

LEARNING OBJECTIVES

• The financial services industry (investment banking, consulting, research, asset management, brokerage, sales & trading, insurance, private equity, venture capital, entrepreneurship and start-ups)
• Corporate/strategic development or finance group of a corporation
• Marketing, brand management or operations for a corporation or any position responsible for a product or divisional budget, projections and profit/loss statement
• Enhancing their learning in finance and financial statement analysis classes
• Non-finance roles, but interested in gaining a solid foundation in applied corporate finance
• Optimized for PC based Excel

TOPICS COVERED

Complete topics step by step or jump to any of the below at any time.

OVERVIEW

During this module, you will learn about the key bond market players and products, how to price bonds, how to calculate yields, how to measure bond price risk using modified duration and convexity, how to interpret yield curve moves, the calculations behind bond carry and roll and how to interpret the profit and loss on bond trades.

LEARNING OBJECTIVES

• Identify the key players and products in the bond markets
• Price bonds
• Calculate yields
• Calculate modified duration
• Calculate PV01
• Calculate DV01
• Identify yield curve moves
• Calculate bond carry and roll
• Calculate the profit and loss for bond trades

TOPICS COVERED

Complete topics step by step or jump to any of the below at any time.

OVERVIEW

During this module, you will learn about the key equity market players and products, the IPO and rights issues processes, how the market values equities, how the market evaluates equity returns, key equity indices and the calculations for price-weighted and market-weighted indices, and the main order types in the equity markets.

LEARNING OBJECTIVES

• Identify the key players and products in the equity markets
• Explain the key steps in an IPO process for various types of IPO
• Carry out rights issue calculations
• Evaluate key equity valuation methods and interpret their output
• Explain how equity returns are calculated 
• Calculate price-weighted and market-weighted equity indices 
• Explain key market order types and the workings of central limit order books 

TOPICS COVERED

Complete topics step by step or jump to any of the below at any time.

OVERVIEW

During this module, you will learn how profits and losses are made in the futures markets, how futures margins work, how to create option payoff profiles from calls and puts, the creation of synthetic forwards using put-call parity, the ways in which options can be used for hedging, how options are affected by various sensitivities and how they can be managed, the key trading strategies and creating synthetic dividends and stock/loan borrow.

LEARNING OBJECTIVES

• Calculate futures profits and losses 
• Calculate futures margins 
• Be aware of the importance of clearing houses to the futures markets 
• Understand the meaning of calls and puts both long and short and be able to draw payoff profiles 
• Understand time value and intrinsic value 
• Be able to create synthetic forwards using put-call parity 
• Be able to create options hedges for long and short underlying positions and draw their payoff profiles 
• Be able to explain the main option ‘Greeks’ and how they can be hedged
• Be able to explain and draw payoff profiles for the main trading strategies 
• Be able to create synthetic dividends using options 
• Be able to create synthetic stock loan/borrow using options

TOPICS COVERED

Complete topics step by step or jump to any of the below at any time.

OVERVIEW

Learn about the foreign exchange market players and products, how to quote spot FX rates, the difference between the 'big figure' and pips, how to calculate spot foreign exchange trade profits and losses, how to calculate spot cross rates, the mechanics of forward foreign exchange outrights including forward points and calculations, hedging using forward outrights, the structure of foreign exchange swaps and their uses, the rationale behind non-deliverable forwards and how to calculate NDF P&L.

LEARNING OBJECTIVES

• Explain spot bid-offer quotes 
• Calculate spot cross rates 
• Calculate spot currency amounts 
• Calculate spot trade P&L   
• Interpret and calculate forward points 
• Explain hedging with forward outrights 
• Explain the structure of foreign exchange swaps and show examples of how FX swaps are used
• Explain NDFs and how to calculate NDF P&L 

TOPICS COVERED

Complete topics step by step or jump to any of the below at any time.

OVERVIEW

During this module, you will learn about the importance of risk and return to constructing an efficient portfolio using modern portfolio theory methodology; the role that correlation plays in portfolio diversification and portfolio optimization; how to measure portfolio performance; the significance of the Capital Asset Pricing Model to portfolio optimization and portfolio performance measurement; limitations and criticisms of modern portfolio theory.

LEARNING OBJECTIVES

• Calculate portfolio returns
• Calculate portfolio risk in the form of standard deviation of returns
• Calculate correlation of returns for a portfolio
• Be able to create optimal portfolios for a two-asset portfolio
• Be able to explain the efficient frontier for portfolios
• Calculate Sharpe ratios
• Calculate active return
• Calculate tracking error
• Calculate information ratios
• Calculate Treynor ratios
• Calculate beta of a portfolio
• Calculate the alpha of a portfolio

TOPICS COVERED

Complete topics step by step or jump to any of the below at any time.