|
What You'll Learn...
|
- Excel™ Application Tools: Financial and Statistical
- Excel™ Decision Making Tools: Data Tables; Goal Seek;
- Solver; Scenario Manager; Pivot Tables; Data Filter; Chart Wizard; More!
- Capital Expenditure Analysis: Scenarios and Case Studies
- Lease Analysis: Operating, Financial, Synthetic and Leveraged
- EVA Calculations: Operating vs. Financing Method
- Three Methods of Business Valuation: EVA; DCF and ROI/Book Value
- Statistical Analysis: Probability, Uncertainty and Financial Decision Making
- Moving Averages, Non-linear Growth and Multivariate Regression Analysis
- Technical Analysis and Charts
- Introduction to XBRL: Financial Analysis in a Digital World
- Online Analysis and Screening: Using Excel™ for External Data Query
|
|
Seminar Focuses on:
|
|
PV/FV Excel™ Applications
|
- Compound Growth Rates (Case Studies)
- Fixed and Variable Annuities
- DCF;NPV;IRR;XNPV;XIRR;MIRR
- Hurdle Rates, Risk, and Cost of Capital
- Computer Applications and Graphics
|
|
Financial Forecasting and Modeling Overview
|
- Basic Concepts
- Linear Regression Using Excel™
- Forecasting Revenues
- Forecasting Fixed and Variable Costs; Flexible Budgeting
- Sensitivity "What If" Analysis Using Excel™ Data Tables
- Retirement Planning Sensitivity Analysis
- Break-Even Analysis and Flexible Budgeting
- Cost-Volume-Profit (CVP) Sensitivity Analysis
- Plan Profits Using Operating Leverage
|
|
Excel™ Tools and Special Features
|
- 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
|
|
Evaluating Cap Ex Proposals
|
- 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
|
- Overview and Definition
- Calculating the Weighted After-Tax Cost of Capital (WACC)
- The Capital Asset Pricing Model (CAPM)
- ROIC and the EVA Formula
|
|
EVA Detailed Calculations
|
- 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)
- DuPont Model vs. EVA
|
|
The Basics of Business Valuation
|
- Compound Growth, the P/E Multiple and P.E.G.
- DCF, Free Cash Flow, Discount Rate, Capitalized Earnings and Terminal Value
|
|
The Specifics of Business Valuation - Three Methods (Case Studies)
|
- EVA - Economic Value Added
- DCF - Using Free Cash Flow
- Book Value - Using ROE
- Modeling Sustainable Growth Rate
|
|
Financial Analysis Under Uncertain Conditions
|
- 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)
|
|
Understanding Basic Technical Analysis: An Introduction
|
- Moving Averages, Least Squared (LSQ) Trend Lines and Trading Channels
- Support and Resistance Levels
- Convergence/Divergence (MACD) and Stochastics
- Online Technical Analysis Tools (Overview)
|
|
Evaluating Financial Performance: Rapid Review of Metrics
|
- Horizontal and Vertical Analysis
- 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
|
- 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
- Taxonomies
- Regulated Industries
- EDGAR: Reporting and Analysis
- Banking/FDIC; IRS and Others
- Private Companies and XBRL Enabled Firms
- Applications and Tools
- Web Enabled Financial Reporting
|
|
Online Analysis
|
- Horizontal and Vertical Analysis
- Retrieving Financials and Ratios: EDGAR (and XBRL)
- Screening for Momentum, Undervalued Stocks and Competitors
- Screening Mutual Funds
|
|
CPE Credits
|
|
This seminar is recommended for 16 hours of A&A 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 website at www.nasba.org.
|
|
Who Should Attend?
|
|
This course is designed for seasoned 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 analysts, security analysts, budget analysts, internal auditors, financial planners and investment advisors.
|
|
Seminar Prerequisites
|
|
This seminar requires that you have a basic unterstanding of financial statements and ratio analysis. Course Level: Intermediate.
|
|
Instructors
|
|
|
|
In-house Presentations ...
|
|
When you bring Advanced Financial Analysis 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 the DuPont formula to stress
profitability.
Some of our past in-house clients include: Hewlett-Packard; Stanley Tools; Harley-Davidson; Fortune Magazine and General Mills.
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.
|
