Financial Modeling and Forecasting Workshop

Financial Modeling and Forecasting Workshop Improve decision making with advanced modeling techniques! Build more powerful and more accurate forecasting models to better analyze financial data, predict revenues and costs, assess risks—and be better equipped to justify critical business decisions made during uncertain economic times. How You Will Benefit Create effective financial models that meet your business needs Quantify the uncertainty inherent in forecasting models with various risk analysis techniques Make better, more profitable business decisions using advanced financial modeling methods Evaluate patterns in your historical data Identify and utilize key business drivers and integrate them into your forecast Effectively communicate the results of  your models to team members and senior management What You Will Cover 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 Who Should Attend Analysts and executive-level managers who work with financial models, 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 laptop equipped with Excel. Those with minimal finance experience should attend FOCUS’s  Fundamentals of Finance and Accounting for Nonfinancial Managers or Intermediate Finance and Accounting for Nonfinancial Managers. Extended Training Description Learning Objectives Use Mainstream Financial Concepts and Terminology Describe Fundamental Statistical Methods Develop Existing Financial Models in Excel® View More Advanced Excel® Modeling Techniques Such as Monte Carlo Add-Ins Create Your Own Model and Provide Diagnostics Analyze Your Model and Provide Diagnostics Identify Uncertainty in the Model and Design Methods to Address It Present Your Models to a Brand Management Audience Finance Theory As Used in Modeling Apply the Concepts of Modern Finance Use Various Interest and Risk Measures in Your Models Develop Models That Are Consistent with the Principles of Finance Creating Financial Models in Microsoft Excel® Develop a Set of Guidelines for Preparing Financial Models in Microsoft Excel® Identify Key Tips for Preparing These Models Apply the Pyramid Structure to Your Models Use Various Microsoft Excel® Functions That Will Aid in Developing Models Prepare a Basic Model Using These Techniques The Art of Building Models Identify the Key Points Necessary to Build a Model Describe the Art in Creating an Effective Model Create a New Model Solving a Complex Business Problem Model Statistics and Forecasting Calculate Mean and Standard Deviation of a Dataset Present Data for Manipulation Analyze the Data Using Simple Techniques Forecast Financial Data Using Regression Analysis Modeling Risk and Uncertainty Identify Uncertainty as It Exists in the Business World Develop Simple Techniques to Handle Uncertainty Use Monte Carlo Simulations to Handle Uncertainty Use Option Pricing Models to Handle Uncertainty Course Summary Summarize Points Learned in This Course   FOCUS TRACO INDONESIA Management & Technical Training Course Seminar Provider Download 2009 FOCUS Training Catalog

Instructor Dra. Melani K. Harriman, Ak, MBA, CFA Schedule July 21-23, 2009 3 days Venue Ciputra Hotel Semarang Tuition Fee  Rp. 4.800.000,-   per participant, excluding accommodation & tax. Registration Send by email -or- fax to: PT. FOCUS TRACO INDONESIA Wisma Pakuan, Jl. Pakuan 12 BOGOR – 16143 (021) 7009-9943   (0251) 2169-150 (0251) 7534-984 training@focustraco.com