This module highlights how you can use Excel to calculate different types of volatility and correlations and what to take into account.

   ● Volatilities
   ● Correlations
   ● Weighting factors
   ● Scaling

Duration: 45 minutes

Bonds play an important role on capital markets as a form of long-term funding and capital investment.
We will show you how you can rapidly determine the key parameters of a bond using Excel.

   ● Bond valuation
   ● Calculating interest accrued
   ● Determining the yield
   ● Interest rate sensitivity (modified duration)

Duration: 45 minutes

Due to their asymmetrical payment structure, options have attractive properties and are often used to hedge major projects during the bidding phase. We will show how simple it can be to price plain vanilla options using Excel.

   ● The Black-Scholes Model
   ● Determining the calculation parameters
   ● Valuation of FX options

Duration: 45 minutes

Good cash management releases liquidity and increases enterprise value. This webinar demonstrates this connection by means of specific examples, highlights the tasks and techniques in international cash management, as well as identifying the levers for optimising account clearing, payment transfer  management and short-term cash flow forecasting.

   ● Definition and task-based areas
   ● Account clearing
   ● Cash pooling
   ● Netting

Duration: 45 minutes

In order to be able to compare lending conditions, it is often necessary to compare different methods of calculating interest. This webinar focuses on the methods used for calculation purposes, which functions Excel provides for accruing and discounting interest, and how to perform the right calculations.

   ● Daily calculations of interest
   ● Single-period calculations
   ● One-off cash flows
   ● Periodic cash flows

Duration: 45 minutes

Termingeschäfte stellen einen der wichtigsten Bestandteile für gängige Sicherungs- strategien dar. Wir zeigen in diesem Modul, wie mittels Excel der faire Preis dieser Geschäfte schnell berechnet werden kann.

   ● No-Arbitrage-Beziehungen
   ● Ermittlung der Berechnungsparameter: Kurse und Zinsen
   ● Berechnung der Terminkurse

Dauer: ca. 35 Minuten

Forward contracts represent one of the most important components of many hedging strategies. In this module, we highlight how you can quickly calculate the fair prices of these transactions using Excel.

   ● No-arbitrage relationship
   ● Determining the calculation parameters: FX and interest rates
   ● Calculation of the forward rate

Duration: 35 minutes

FX rate changes can cause considerable volatility in terms of profitability for corporates and banks. This has been shown to have a negative impact on enterprise value and even threaten the continued existence of companies are times. This webinar addresses the process of market risk management. We identify which positions are exposed to risk and analyse how these risks can affect corporates.

   ● The different types of risk – direct and indirect FX risk
   ● Approaches for your risk strategy
   ● The practice-oriented use of hedging instruments: futures and options

Duration: 45 minutes

Interest rate changes can cause considerable volatility in terms of profitability for corporates and banks. This has been shown to have a negative impact on enterprise value and even threaten the continued  existence of companies are times. This webinar addresses the process of market interest rate risk management. We identify which positions are exposed to risk and analyse how these risks can affect corporates.

   ● Sources and forms of risk
   ● The building blocks of a risk policy
   ● Hedging instruments: forward rate agreements, swaps, caps and floors

Duration: 45 minutes

Asset management relies on strategic decisions of expected returns based on historical data, diversification effects and portfolio efficiency. We will show you how Excel can be used to systematically optimise a financial portfolio, irrespective of whether this relates to assets or liabilities.

   ● Markowitz’s portfolio theory
   ● Defining optimisation parameters
   ● Efficient portfolios by means of target values

Duration: 40 minutes

Besides FX, commodity, market price and other risks, interest rate risk is another key factor influencing a company’s earnings position. This module demonstrates how you can independently price and value interest rate swaps.

   ● Zero rates
   ● Discounting factors
   ● Calculating swap rates
   ● Valuing swaps

Duration: 35 minutes

Risk management first and foremost means identifying risk factors, defining risk positions and measuring potential losses. Analysis and communication are the key tenets of risk management. We highlight how you can calculate ‘at-risk’ parameters using Excel.

   ● Calculating variances
   ● Calculating portfolio volatility
   ● Value-at-risk

Duration: 40 minutes

By means of a case study, this webinar highlights all of the key levers in working capital management and shows you how you can effectively and sustainably free up liquidity.

   ● Building blocks of working capital managements
   ● Levers in payables management
   ● Levers in receivables management

Duration: 45 minutes