In this course, you will build robust financial forecasts and models, learn tips and tools, analyze the results, and learn how to communicate key data to decision makers in your organization. Build the model. . .generate the forecast. . .drive the business. Create more powerful and accurate forecasting models that steer you to fast-track, business-improving decision making.
Who Should Attend
Analysts and executive-level managers who work with financial models and need a refresher course on modeling methods—as well as experienced financial professionals who have not built models on a regular basis.
Note:
- Please bring a PC laptop equipped with Excel 2019 or 365.
- Those with minimal finance experience should attend AMA’s Fundamentals of Finance and Accounting.
- Working with advanced Excel modeling techniques such as simulation add-ins
- Creating your own model from real-world examples
- Analyzing and applying diagnostics to validate your forecast
- Understanding how Monte Carlo simulations handle uncertainty
Outline:
Learning Objectives
- Improve Model Design Efficiency
- Expand Your Tool Kit for Building Effective Models
- Learn, Practice, and Apply Sensitivity Tools to Your Models
LESSON ONE
Finance Theory as used in Modeling
- Articulate the Concepts of Modern Finance
- Identify Key Tips for Preparing Financial Models
- Determine the Appropriate Rates of Return for Financial Models
Creating Financial Models and Using Advanced Tools in Microsoft Excel
- Describe Best Practices for Preparing Financial Models in Microsoft Excel
- Use Microsoft Excel Functions That Will Aid in Preparing Models
LESSON TWO
Creating Financial Models and Using Advanced Tools in Microsoft Excel(cont’d)
- Describe Best Practices for preparing Financial Models in Microsoft Excel
- Use Microsoft Excel Functions That Will Aid in Preparing Models
LESSON THREE
Design Effective Models Using Proven Tips and Techniques
- Identify the Key Points Necessary to Problem-Solve Using Models
- Explain the Powerful Sensitivity Analysis Tools Available in Microsoft Excel
- Create a New Model Solving a Complex Business Problem
LESSON FOUR
Presenting Your Findings and Modeling Risk and Uncertainty
- Prepare an Effective Presentation of a Financial Analysis for Nonfinancial Decision Makers
- Explain Several Monte Carlo Simulation Add-Ins
- Identify Uncertainty as It Exists in the Business World
- Develop Simple Techniques to Handle Uncertainty
- Use Monte Carol Simulations to Handle Uncertainty
- Use Option Pricing Models to Handle Uncertainty
