Running multiple sets of inputs through a single calculation engine. Building, managing and extending a scenario manager with VBA
This course is designed to help you build a robust and dynamic Cashflow Forecast as well as a fully integrated Financial model containing a projected Balance Sheet, Income Statement and Cashflow Statement confronted with Actuals. A well-designed financial projection model can be invaluable for providing estimates of an organization’s future financial condition given certain performance assumptions. It allows business users to improve the reliability, quality and timeliness of their decision making. Financial Modelling techniques can be used in many different areas, such as Capital Budgeting, Business Valuation, Financial Reporting, Analysis, Budgeting and Forecasting.
Traditional financial modelling is normally geared towards building a stand-alone model without merging the projected numbers with detailed Actuals. Furthermore, you might be dealing with a multitude of companies or departments that you want to consolidate. Traditionally, these types of models contain too many unique formulas, which make them hard to grasp and maintain.
Mastering Financial Modelling helps you create a flexible model with a minimum number of unique formulas by using Modern Excel features, such as Tables, Power Query and the Data Model. You will discover how to present custom Financial Reports and combine them with the outcome of different scenarios.
Tony De Jonker, Microsoft MVP is the principal of De Jonker Consultancy & AlwaysExcel, The Netherlands and specializes in Financial Modelling, Analysis, Reporting and Training for clients worldwide. He is the founder and presenter of the Annual Excel events, such as Excel Experience Day, Excel Expert Class and Amsterdam Excel Summit. Tony offers a range of Excel Business related training courses in Dutch, English or German based on more than 33 years of spreadsheet modelling and more than 41 years of Finance & Accounting experience. He has written more than 100 articles on the use of Excel in Business for the Dutch Controller’s Magazine.