presents American Management Association Seminars
AMA'S COURSE ON FINANCIAL MODELING
Seminar No: 01276 -XNBB
CEU Credits: 1.8
Length: 3 days
Master the key steps for designing, building and utilizing your models for maximum results!
Here’s your opportunity to sharpen your analytical abilities for more profitable decision making. This comprehensive seminar walks you through the modeling process from start to finish. It provides, along the way, practical examples and applications of modeling for the financial executive, including capital budgeting, portfolio analysis, ROI and more. From formulating the model to exploring alternative scenarios, this course covers it all.
Attendees:
Financial executives, business professionals and operations managers who are involved in the decision-making process.
How You Will Benefit:
- Understand the significance of proper formulation and interpretation of models
- Translate specific quantitative problems into neatly structured mathematical models
- Get the most from your software investment
- Create more powerful models in less time
- Draw more accurate conclusions from these model results
What You Will Cover:
- Building an infrastructure for successful financial modeling
- Classifying financial model types by function and time horizon
- Formulating financial forecasting models
- Using optimization and simulation techniques in financial models
- Employing sensitivity analysis in financial modeling
- Risk analysis in financial modeling
- Validating financial models
- Implementation issues
Extended/Detailed Seminar Outline
Learning Objectives
- Understand the Significance of Proper Formulation and Interpretation of Models
- Translate Specific Quantitative Problems into Neatly Structured Mathematical Models
- Get the Most from Your Software Investment
- Learn the Secret to Creating More Powerful Models in Less Time
- Draw More Accurate Conclusions from the Results of Your Models
Introduction-Why Build Models
- Understand the Meaning of the Team Financial Modeling
- Give a Rationale for Building and Using Financial Models
- Understand Who Uses the Results of Financial Models
- Appreciate the Historical Evolution of Financial Modeling in Organizations
DSS Applications of Financial Modeling
- Appreciate the Key Decision Variables and Practical Use of Financial Modeling in the Following Applications - Capital Investment Decisions - Budgeting - Leasing - Cash Management - Tax Strategies - Capital Structure - Mergers and Acquisitions - Ratio Analysis - Human Resource Management - Break-Even Analysis - Pro Forma P&L - Asset Redeployment Strategies - Consolidations
Classifications of Financial Models
- Understand How Financial Models Could Be Classified by Time Horizon and How That Factor Influences Model Design Choices
- Understand How Financial Models Could Be Classified by the Orientation of the Model Builder and How That Factor Influences the Effectiveness of the Resulting Model
Steps in Building Financial Models
- Follow the Key Steps in the Design and Development of a Financial Model
- Aggregate the Steps into Phases and Relate the Various Responsibilities of All Parties to the Entire Process
- Deal with the Central Issues of an Active vs. Passive Posture on the Part of the Decision Maker to the Modeling Process
Formulating Financial Forecasting Models
- Understand the Two Generic Approaches Used to Build Financial Forecasting Models
- Balance the Use of Science and Art in the Construction of Forecasting Models
- Recognize the Basic Patterns Inherent in Your Data
- Measure the Degree of the Basic Patterns in Your Data Using Exploratory Data Analysis Tools
- Apply the Key Factors in Determining the Proper Time Horizon to Choose for Your Model
- Apply the Criteria Used to Determine Forecast Accuracy
- Understand and Apply Selected Forecasting Techniques
- Understand the Key Considerations in Forecasting Software Selection
Optimization Techniques in Financial Modeling
- Understand the Basic Structure of All Optimization Models
- Understand the Different Forms of Optimization Models
- Formulate a Financial Optimization Model
- Apply Optimization Models to a Spreadsheet Environment
- Perform Sensitivity Analysis of an Optimization Model
- Interpret the Solution of an Optimization Model to a Nontechnical Manager
- Build a Portfolio Model Using the Technique and Apply Sensitivity Analysis
- Understand the Decision Criteria to Be Used in Selecting Available Optimization Software
Simulation Techniques in Financial Modeling
- Understand the Steps in Using the Simulation Modeling Approach to Building Financial Models
- Appreciate the Differences between Deterministic and Probabilistic Simulation Models
- Understand the Implications of Model Sizing as It Applies to Building Financial Models
- Build and Exercise a Financial Model Analyzing a New Product Planning Decision
- Participate in a Team Exercise in Building a Financial Model
Sensitivity Analysis in Financial Modeling
- Appreciate the Meaning and Importance of Sensitivity Analysis
- Apply the Difference between Changes to Data and Changes to Model Logic
- Capitalize on the Differences in the Way Different Managers Approach Making Financial Decisions
- Apply Some of the Most Frequently Used Techniques of Sensitivity Analysis
- Modify the Case Study Presented Earlier by Using Sensitivity Analysis Techniques
Risk Analysis in Financial Modeling
- Appreciate the Risk Continuum and How It Can Be Used to Select the Appropriate Type of Financial Model
- Discuss with Your Managers the Benefits and Costs of Building Financial Models Using Risk Analysis Techniques
- Explain the Results of a Risk Analysis Modeling Exercise from Both a Technical and Nontechnical Viewpoint
- Extend the Case Study to Include Risk Analysis Capabilities
- See How Risk Analysis Is Used on Both a Mainframe and Spreadsheet Platforms (1-2-3 and Excel)
Extensions to the Case Study
- Understand, Appreciate, and Apply Changes to the Underlying Assumptions of the Case Study Model Regarding Asymmetric Properties of the Probability Distributions
Validating Financial Models
- Create a Framework for Ensuring the Development of Valid Financial Models
- Decompose Financial Model Validity into Selected Components in Order to Facilitate Better Model Development
- Consider How You Can Build More Valid Models
- Apply Spreadsheet Auditor Software Capability to Your Existing Model
- Explore How Colleagues in Other Organizations Validate Their Financial Models
Stylistics of Financial Models
- Evaluate the Benefits and Costs of Building Financial Models on a Micro or Mainframe Platform
- Explore the Issues of Modeling in a Menu Mode or in a Command Mode
- Evaluate the Feasibility of Organizing Your Financial Models to Take Advantage of Data Separation in Model Design
- Consider the Ramifications of Migration Paths in Language Selection
- Explore the Implications of Using the "Suite" Approach in Solving the Financial Modeler’s Functionality Needs Regarding Applications' Integration
Information Exchange
- Explore Any Financial Modeling Issues That Have Not Been Discussed in the Seminar up to This Point
Start and End times: first day - 8:30am-5pm, all other days 9am-5pm unless otherwise specified. Your registration confirmation notice will confirm the hotel/conference center for the seminar for which you registered. The information included on this page is all the information available on this seminar. Please use form below to register only. To request information that is not included above please send an email to
. Remember to specify the complete seminar number about which you are requesting information.
For information about bringing a course to your site please call 1-919-847-0331 or email the registry at
.
|
If this course or the dates/locations below do not have what you are looking for, then click here and we will find it for you right away. It will save you a lot of time and energy finding it yourself.
|
** Online Registration & Fee Information ** Please use form below to register only. To request information that is not included above please send an email to
. Remember to specify the complete seminar number about which you are requesting information.
Select date/location & complete form below. Then, click on 'Send'
Additional Information:
After submitting your online registration you will receive registration confirmation and invoice within 7-10 business days. You may pay by credit card or check. Confirmation information will also include location and other pertinent course information.
Always state priority code XNBB to your customer service representative when registering directly by phone.
Note: Prices are subject to change without notice. To confirm the price of your session, select the session above and click “Send”. Discounts apply for groups of two or more people. Call for details. Federal government employees are eligible for special GSA pricing for many seminars.
AMA's main conference centers
Seminars scheduled for the cities below are held at the locations listed below. For location information for other cities in which AMA seminars are held please call or email for information.
New York
AMA executive Conference Center
1601 Broadway New York, NY 10019
American Management Association (Located in the same building as the Crowne Plaza Hotel) 1601 Broadway On Broadway and 48th Street near Times Square. Entrance is on 48th Street.
Chicago
AMA executive Conference Center (adjacent to the Marroitt O'Hare)
8655 west higgins rd
Chicago, IL 60631
San Francisco
AMA executive Conference Center is located in San Francisco Marriott Hotel
55 Fourth Street 2nd Level
San Francisco, CA 94103
Atlanta
AMA Executive Conference Center
Address: 1170 Peachtree Street Ne Cnr Peachtree & 14th (3rd Flr)
City, State, Zip: Atlanta, GA 30309
Washington, DC
Arlington, Virginia
2345 Crystal Drive, Suite 200
Arlington, VA 22202
If you are not paying via credit card, you will receive an invoice with payment instructions.
Cancellation Policy:
If you cannot attend a seminar you can contact AMA in advance to transfer to a future session, or you can send someone to take your place. If you need to cancel your attendance, AMA will give you a complete refund if you cancel more than three weeks before your seminar begins. To cancel, simply email us at
. If you cancel with less than three weeks’ advance notice, you will be liable for the entire seminar fee. Once your payment has been received, you may request a courtesy transfer to use at any future AMA seminar of equal or lesser length. The courtesy transfer must be used within one year of the date of your originally scheduled seminar. In fairness to all attendees, if you do not attend a seminar session for which you are confirmed and do not contact AMA to cancel in advance, you will be charged the entire seminar fee.
AMA grants courtesy transfers to people who cannot attend their scheduled sessions. You can use a courtesy transfer for any seminar of equal or lesser length than the original seminar. You must use your courtesy transfer within one year of the date of your originally scheduled seminar.
AMA guarantees the quality of our seminars. If, for any reason, you are not satisfied with a seminar for which you have paid, AMA will give you credit toward another seminar of comparable price or will refund your fee.
You can also register by emailing your registration information to us at
or calling us at 919-847-0331.