|
Your Roadmap to Successful Financial Modeling
|
|
An intense, interactive two-day workshop illustrating the professional way to construct and use financial models on spreadsheets
A combination of modeling methodology
and advanced Excel™
financial tools focusing on:
- Proper Financial Model Construction Techniques
- Present- and Future-Value Modeling
- Capital Budgeting: Detailed Analysis and Modeling
- Leasing Models: Capital, Operating; Buy vs. Lease
- Regression Analysis to Identify Key Revenue and Expense Drivers
- Valuing Stock Options: Black-Scholes and Binomial Models
- Weighted Cost of Capital and EVA Modeling and Analysis
- Valuation Modeling and Analysis; Arbitrage Pricing Model
- Advanced Excel™ Tips and Techniques for Instant Modeling
A state-of-the-art workshop
designed for
accounting and financial professionals including:
- CFOs, Treasurers, Controllers and accounting staff
- Financial Directors, Managers, Analysts and their staff
- Mergers & Acquisitions Specialists; Valuation Analysts
- Financial and Corporate Planners; Strategic Planning Managers
- Budget Directors, Managers and Analysts
- Operations Analysts and Business Development Directors
|
|
Seminar Agenda
|
|
Financial Modeling Principals
|
- Using Financial Models to Solve Business Problems
- Designing Financial Models: Ten Keys to Success
- Other Modeling Considerations
- Modeling Financial Problems in Excel: Five Options
- Online Financial Calculators
|
|
Financial Functions and Time Value of Money Considerations
|
- Overview
- Present Value and Future Value
- Automatic Functions:
- FV Schedule Function
- Rate Function
- Effect Function; Continuous Compounding
- Nominal Function
- Payment Function
- IPMT Function
- CUMIPMT Function
- PPMT Function
- NPER Function
|
|
Modeling Tools
|
- Overview
- Excel: Recording and Using Macros
- Creating a Custom Toolbar; Adding Macros to a Toolbar
- Graphs and Charts for Modeling
- Protecting the Worksheet
- Creating Random Numbers
|
|
Sensitivity Analysis
|
- Overview: How to Use Data Tools
- Goal Seek: 18 Financial Applications
- Data Tables: One Input; Two Input
- Scenario Manager
- Using the Forms Toolbar: (1) Combo Box; (2) Option Button and Group Box; (3) Spinners; and (4) Scroll Bars
|
|
Optimization with Excel’s Solver
|
- Overview: How to Use Solver
- Specific Examples: (1) Optimal Level of Production to Maximize Profits; (2) Optimal Product Mix; (3) Breakeven; and (4) Optimal Portfolio Analysis
|
|
Simulation Analysis
|
- Overview
- Simulating the Profit Scenario
- Monte Carlo Simulation
- Probability Distributions
- Using “Crystal Ball”
|
|
Financial Forecasting
|
- Statistical Forecasting Overview
- Regression Analysis
- Charting vs. Regression Analysis Function
- Using the Regression Equation and Excel’s Forecast Function
- Statistics and Forecasting Software Overview
- Pro Forma Financial Statement Modeling: Overview
- Forecasting the Cash Flow Statement
|
|
Financial Modeling for Cost of Capital & Capital Structure Considerations
|
- Estimating the Cost of Capital
- Choosing the Method of Project Financings: 3 Options
- Establishing the Firm’s Optimal Capital Structure
- Estimating the Firm’s Discount Rate
- The Basic Risk Premium Model
- Estimating Investment Risk: The Three Major Models
- Implementing the CAPM: Key Terms & Concepts
- Equity Risk Premium (ERP)
- CAPM: Advantages and Disadvantages
- CAPM: Six Major Assumptions
- Adjusting the CAPM for Private Firms and Specific Risk Factors
- Relevered Beta: Adjusting Beta for Leverage
- Using the Build-Up Model: 30 Items to Consider
- Calculating the Weighted After-Tax Cost of Capital (WACC)
- Measuring Return with Economic Value Added (EVA)
|
|
Modeling the Project Investment Decision
|
- Real World Example
- The Capital Budgeting Process: Five Steps
- Estimating Cash Flows
- Determining the Project’s Hurdle Rate
- Evaluating Capital Expenditures
- Payback Period
- Accounting Rate Return
- Discounted Cash Flow Methods (Using Excel)
- Internal Rate of Return (IRR) and Modified IRR (Using Excel)
- Discounted Payback Method
- Evaluating Projects with Different Lives
|
|
Lease Analysis Models
|
- Overview
- Case Study: Lease vs. Purchase
- Accounting Considerations in Asset Leasings: Overview
- Requirements for a Capital Lease: GAAP and FASB 13
- Capital Lease Analysis Models: Case Study – FASB 13 on a Spreadsheet
|
|
Valuation Models
|
- Overview
- Discounted Cash Flow Valuation Model
- Market Comparable Approach
- Overview of M&A Issues
- Case Studies
|
|
Stock Option Pricing Models
|
- Background: Amendments to FASB 123 and 95; Expensing Stock Options
- Valuing Stock Options
- Puts and Calls
- Variables Related to the Underlying Asset
- American v. European Options
- Pricing Stock Options: Two Models
- Black-Scholes Option Pricing Model
- Key Assumptions and Five Key Determinants of an Option’s Price
- Formula to Calculate the Call Option Price
- Example, Spreadsheet Model and Free Online Option Pricing Calculator
- Binomial Option Pricing Model
- Calculating the Risk-free Hedge
- Valuing the Call Option
- Extending the Binomial Model Using Volatility Assumptions
|
|
CPE Credits
|
|
This seminar is recommended for 16 hours of Specialized Knowledge & Applications CPE credit.
The National Center for Continuing Education is registered with the National Association of State Boards of Accountancy (NASBA), as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be addressed to the National Registry of CPE Sponsors, 150 Fourth Avenue North, Suite 700, Nashville, TN, 37219-2417. Visit the NASBA web site at www.nasba.org.
|
|
Who Should Attend?
|
|
This seminar is ideal for accounting, business and financial professionals who want to master both professional modeling techniques and state-of-the-art computer tools specifically designed to make financial modeling quick and easy. Included in the group are:
- CFOs, Treasurers, Controllers and accounting staff
- Financial Directors, Managers, Analysts and their staff
- Valuation Professionals
- Mergers & Acquisitions Specialists
- Financial and Corporate Planners; Strategic
- Planning Managers
- Budget Directors, Managers and Analysts
- Business Development Directors
This seminar is ideal for financial professionals who need to clearly understand the new stock option expensing requirements and compare the Black-Scholes Option Pricing Model to the Binomial Option Pricing Model.
|
|
Seminar Prerequisites
|
|
Course Level: Intermediate. Prerequisites: Basic knowledge of financial analysis and Excel.
|
|
Instructors
|
|
|
|
In-house Presentations ...
|
|
If you have a group of 14 or more employees who need to learn the proper, professional way to design financial models, NCCE’s customized training is the cost-effective solution for your organization. Bring Modern Financial Modeling in-house and ensure that your staff possess all of the technical modeling skills necessary to give your company an edge in today’s competitive market.
Some of the organizations who have taken advantage of NCCE’s custom training include Stanley Tools; Harley Davidson; General Mills; US Small Business Administration; Aetna; Western Union and law firms such as Jones, Day, Reavis & Pogue; Weil, Gotshal & Manges; and King and Spalding.
For more information or to schedule a custom in-house program, email NCCE at contact@nccetraining.com or telephone 800-635-9615.
Back to top
|
© Copyright 2006 Performance Seminars, Inc.
|
