Online Credit Derivatives eLearning

Financial math Module 3 - Key statistical skills - MDA Training - In this module, we explore key statistical measures. The module begins by explaining how to calculate measures of central tendency including the arithmetic mean and expected values. The module then goes on to outline how simple and weighted moving averages are calculated. The module also explains how to calculate different types of statistical dispersion such as range,  more...

Financial math Module 4 - Covariance Correlation and Regression In this module, we examine the mathematical relationship between two variables. The module begins by explaining how covariance and correlation are defined and calculated. The module then moves on to explain how regression analysis is used to estimate the value of one variable based on another. The module also explains the regression equation, outlines how to interpret the coefficient of  more...

Financial analysis Module 1 - Analyzing the income statement - MDA Training - In this module, we work through the various components of the income statement and explain how best to analyze it. Using real-life case studies, you will learn how to perform robust vertical and horizontal income statement analysis using various performance ratios. You will also learn how to approach benchmarking income statement performance against an appropriate peer  more...

Financial analysis Module 4 - Pyramid of ratios - MDA Training - In this session, you will combine everything learned in previous modules to unlock the drivers of financial performance. This module guides you through the pyramid of ratios, demonstrating how you can use the pyramid to uncover the profitability, efficiency, and leverage drivers for any organization. By the end of this course, you will understand how to effectively use the  more...

Financial analysis Module 3 - Funding the business - MDA Training - In this third module, you will analyze the cash flow statement to better understand the inflows and outflows of cash throughout the year. Using different financial ratios taken from the balance sheet, we will help you assess the solvency and leverage of a business. In the end, we will examine different funding options for an organization looking to both operate efficiently and  more...

Financial analysis Module 2 - Analyzing the balance sheet - MDA Training - In this second segment, you will analyze the balance sheet to determine the operational efficiency of a company. Key ratios taken from the balance sheet and its implications on a company's cash flow are thoroughly explained in this segment. Illustrated using a technology and a retail company, we will show you how to conduct a comprehensive analysis using efficiency ratios  more...

Auditing a financial model in Excel - MDA Training - Learn how to easily and quickly uncover errors on complex financial models with tools already available in both Excel 2003 and 2007. Desktop widgets are available as part of the course to provide you with additional video assistance. Objectives: 1 - Learn how to quickly and easily find errors and audit a spreadsheet 2 - Understand how the auditing toolbar can help  more...

Catering for Uncertainty in Financial Models for Excel - MDA Training - Learn how to effectively use Excel tools to mitigate uncertainty. This course will teach you how to use scenarios and sensitivity analysis in your model to better understand how single and multiple material variables can impact your output. Desktop widgets are available as part of the course to provide you with additional video assistance. Objectives: 1) Learn how to  more...

Building Better Formulas in Excel - MDA Training - Learn how to build better formulas in Excel 2007 / 2003. This course will guide you in using industry standard methods and techniques to help you increase the accuracy of your financial model and speed up your model building process. Desktop widgets are available as part of the course to provide you with additional video assistance. Objectives: 1) Build flexibility  more...