Online Financial Modelling eLearning

Financial math Module 1 - Discounted cash flows In this first module, we explore the concept of the a time value of moneya . The module focuses on how to calculate present values and future values using compounding and discounting techniques. The module then goes on to outline how the present values of annuities, perpetuities, and growing perpetuities can be calculated. Each concept is reinforced with practical and applied exercises and case  more...

Financial math Module 2 - Bond pricing and yields - MDA Training - In this module, we explore bond pricing and yields. The module begins by explaining how to calculate the price of a bond using DCF. The module then goes on to outline how various yields (such as the current yield and the yield to maturity) are calculated. The module also explains the relationship between bond prices and yields as well as how to identify whether a bond is  more...

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...

Building a financial model Part 4 - MDA Training - In this final segment, we will illustrate how important it is to incorporate error checks in your financial models by showing you how to use different tools provided in Excel. You will also learn how to derive a forecast cash flow statement based on a forecast income statement and balance sheet. And finally, we will show you how to derive a free cash flow statement that can be  more...

Building a financial model Part 3 - MDA Training - In this third segment, we will show you how to forecast debt financial and related interest costs, as well as equity financing and dividends. You will also learn how to use iterative and analytic approaches to manage circular references. Desktop widgets are available as part of the course to provide you with additional video assistance.  more...

Building a financial model Part 2 - MDA Training - In this segment of the four part series, you will learn how to use different approaches to forecast plant, equipment and property and other operating assets. In addition to that, we will demonstrate how to forecast various components of working capital, including accounts receivable, inventories, and accounts payable. Key ratios are introduced to help you build the financial  more...

Building a financial model Part 1 - MDA Training - In the beginning of this four part series, you will learn the key components required to create robust financial models. Moving forward, you will improve your financial modeling skills by learning how to plan your structure, use data validation and formatting, and test for errors. This course will also explain the importance of planning your model structure and show you how to  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...

Excel Modeling Tips and Tricks - MDA Training - Learn how to navigate around your Excel worksheet and workbook more quickly. This course will demonstrate how navigating shortcuts and simple formatting can significantly improve your ability in accessing and editing your Excel worksheet. Desktop widgets are available as part of the course to provide you with additional video assistance. Title: Navigating around your  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...