Online Building Usa eLearning

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

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