|
What you'll learn...
|
The most successful financial professionals possess a winning combination of
Excel™, software and financial application training...
Now you can too!
Excel™ Training:
- Application Tools: Financial and Statistical
- Modeling Tools: Data Tables; Goal Seek; Solver; Scenario Manager, More!
- Data Analysis Tools: Pivot Table; Lookup Table; Chart Wizard; AutoFilter
- Macros and User Defined Functions; Custom Toolbars; Spinners, More!
Budgeting and Financial Analysis Training:
- Capital Expenditure Analysis: Scenarios and Case Studies
- Lease Analysis: Operating; Capital; Synthetic and Leveraged
- Cost of Capital and EVA Calculations: Operating v. Financing Method
- Three Methods of Business Valuation: EVA; DCF and ROI/Book Value
- FASB 95 Metrics; Automated Z-Score Analysis; More!
Technology Tools:
- Introduction to XBRL: Financial Analysis in a Digital World
- Monte Carlo Simulations Using the Excel™ Add-In “Crystal Ball”
|
|
Seminar Agenda
|
|
Excel™ Financial Modeling Overview (120 min.)
|
- Basic Concepts
- Linear Regression Using Excel™
- Forecasting Revenues
- Forecasting Fixed and Variable Costs; Flexible Budgeting
- Using Graphics to Illustrate Models (Chart Wizard)
- Sensitivity “What If” Analysis Using Excel™ Data Tables
- Cost-Volume-Profit (CVP) Sensitivity Analysis
- Plan Profits Using Operating Leverage
|
|
Excel™ Tools and Special Features (150 min.)
|
- Excel™ Goal Seek vs. Excel™ Data Tables: CVP Case Study
- Excel™ Solver: CVP Case Study
- Using the Scenario Manager for Multiple Solutions
- Creating/Editing Scenarios (Input and Result Values)
- Using Multiple Scenario Sets
- The PivotTable Wizard (Toolbar) and PivotTable Menu Illustrated — Slice ‘n’ Dice Your Data
- Downloading Data and Summarizing with the PivotTable
- Using the PivotTable Field Button to Customize Calculations
- Using the Chart Wizard with the PivotTable Wizard
- Creating a Calculated Field in a PivotTable
- Organizing, Summarizing and Analyzing Data with the AutoFilter (Query)
- Vlookup Tables; Hlookup Tables
- Conditional Functions to Find Strings or Values
- Case study: Inventory and Tax Tables
- Query vs. Lookup Function
- Auditing the Spreadsheet; Audit Toolbar
|
|
Macro Overview and Custom Toolbars (120 min.)
|
- Macro Record and Playback
- Relative v. Absolute
- VBA and Using the Visual Basic Editor and Toolbar
- Creating User Defined Functions
- Dialog Boxes; Check Boxes and User Forms
- Creating Custom Toolbars and Display Boxes
- Create, Display and Hide Toolbars
- Create Built-in Buttons and Menus
- Run a Macro from a Custom Toolbar
- Create Custom Forms Toolbars
- Incorporating Spinners and Macros for Financial Analysis: Case Study
|
|
PV/FV Excel™ Applications/Template (60 min.)
|
- Compound Growth Rates (Case Studies)
- Fixed and Variable Annuities
- Automated Financial Functions: DCF;NPV;IRR;XNPV;XIRR;MIRR
- Retirement Planning Sensitivity Analysis
|
|
Evaluating Cap Ex Proposals (60 min.)
|
- Payback; ROI; NPV and IRR
- Lease vs. Purchase and Capitalized Leases — FASB 13 on a Spreadsheet
- Synthetic and Leveraged Leases
- Capital Budgeting using Excel™ Goal Seek
- Using Excel™ Solver to Optimize Cap Ex Decisions: Case Studies
|
|
Economic Value Added (EVA) Model (90 min.)
|
- Overview and Definition
- Calculating the Weighted After-Tax Cost of Capital (WACC)
- The Capital Asset Pricing Model (CAPM)
- ROIC and the EVA formula
- EVA Calculations - Two Methods:
- Operating Method
- Financing Method
- Case Study: Calculate EVA for Your Firm (Bring Financial Report)
- How to use Value Line to Rapidly Approximate EVA for Public Firms
- How to Use EVA to Evaluate Capital Expenditure Projects (Case Study)
|
|
Business Valuation — Three Methods and Case Studies (90 min.)
|
- Free Cash Flow, Discount Rate, Capitalized Earnings and Terminal Value
- EVA - Economic Value Added
- DCF - Using Free Cash Flow
- Book Value - Using ROE
- Modeling Sustainable Growth Rate
- Discounted Cash Flow from Operations v. Stock Price
|
|
Financial Analysis Under Uncertain Conditions (75 min.)
|
- Advanced Applications of the Excel™ Statistical Tool Pack
- Moving Average Forecasts
- Differentiating Between Linear (Trend) and Non-Linear (Growth) Forecasts
- Smoothing for Linear Regression; Adjusting Confidence Intervals
- Multivariate Regression Analysis
- Probability Tools
- Using Probability Analysis for Cap Ex Decisions (Case Study)
- Monte Carlo Simulation
- Using @RAND
- Using the Excel™ Add-In “Crystal Ball”
|
|
Evaluating Financial Performance: Rapid Review of Metrics (20 min.)
|
- Basic Metrics: Liquidity; Activity; Leverage; Profitability and Z-scores
- Cash Flow Ratios (FASB 95)
- Template for Automatic Calculations
|
|
Introduction to XBRL: Financial Analysis in a Digital World (45 min.)
|
- History: NASDAQ and PricewaterhouseCoopers
- Purpose and Overview
- XML and Formatted Input
- Tagging and Taxonomy
- XBRL Tagging: The Digital General Ledger
- Continuous Audit Assurance
- Microsoft Excel™ and XBRL Tagged Data
- Universal Converters and Transparent Conversion
- In-Class Demo
- Understanding Taxonomies
- Regulated Industries
- Private Companies and XBRL Enabled Firms
- Applications and Tools
- Web-Enabled Financial Reporting
|
|
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 course is designed for financial professionals who want a state-of-the-art update and a crystal-clear explanation of advanced financial tools and techniques.
This seminar is perfect for CFOs, CPAs, treasurers, controllers, financial and security analysts, budget analysts, internal auditors, financial planners and investment advisors.
|
|
Seminar Prerequisites
|
|
This program requires that you have a basic understanding of financial statements and corporate finance. Course Level: Intermediate
|
|
Instructor
|
|
|
|
In-house Presentations ...
|
|
When you bring Budgeting and Financial Analysis using Excel™ in-house, the course encompasses a complete financial analysis of a public company you select including: ratio analysis; a thorough review of the company’s statement of cash flow (FASB 95), including cash flow ratios, and review of the Z-score to predict bankruptcy. We also review five-year trends (trend analysis), and graph the results.
As a group, we’ll also calculate the company’s annual Economic Value Added (added shareholder value) and compare the cash flow from operations (CFO) to the stock valuation.
Some of our past in-house clients include Hewlett-Packard, Stanley Tools, Harley-Davidson, Fortune Magazine and Deloitte-Touche, General Mills and Motorola.
For more information or to schedule a custom in-house program, e-mail NCCE at contact@nccetraining.com or telephone 800-635-9615.
Back to top
|
© Copyright 2006 Performance Seminars, Inc.
|
