REGISTRATION AND PAYMENT

Excel Fundamentals, Advanced Excel for Data Analysis & Charting Techniques (Mon-Wed, Jun 21 – Jun 23, 2010)

3 days $ 3,375.00

Learning Objectives

- Introduction to data manipulation & realizing the power & capabilities of Excel
- Learn relevant formulas and functions and how to maximize Excel’s abilities
- Learn how to minimize as much manual labor as possible in data analysis
- Learn to use the most overlooked Excel formulas that will simplify your life
- Learn powerful functions built in Excel that streamline your analysis
- Translate Excel analysis into meaningful charts & graphs to visually present data
- Master the skills necessary to create robust dynamic charts easily and effortlessly
- Learn different techniques and best practices of integrating charts into PowerPoint
- Advance to complex charting functions to create multi-layered graphs that combine & display multiple data sets simultaneously


Dates: Monday, 4/26/10 to Wednesday, 4/28/10
Time: Approximately 9AM – 5PM
1330 Avenue of the Americas
New York City, NY 10019

Accounting & Financial Integration

6 month(s) $ 0.00

Course Goals & Overview:
This is not an Accounting class, but rather, is a perfect course for those needing a refresher or those desiring a financial statements crash course as it relates to financial analysis. Learn the most important and relevant areas of financial statements for financial modeling.

This program covers the basics of financial accounting including the major financial statements (Income Statement, Balance Sheet and Cash Flow) and the most important components of each as it relates to financial analysis. Concentration is placed on the integration of the financial statements and provides a full integrated grasp of accounting from a finance perspective.

Course Sections:
Financial Statement Analysis
- Income Statement, Balance Sheet, Cash Flow Statement defined and importance of
- Comprehensive Financial Statement review
- Components of each major financial statement
- IS: Revenue and expense items, EBITDA defined and discussed
- BS: Assets, Liabilities, and Shareholders' Equity
- CF: Cash Flow from Operations, Investing Activities and Financing
- Understand how financial statements are inter-related to each other
- Relationship between the Income Statement and Cash Flow Statement
- Explanation of Accrued Expenses, Receivables and Payables and how they tie together

Key Ratios
- Overview and explanation of major financial ratios, including: liquidity, asset management, debt management, profitability, and market value ratios

Hands-on Exercise
- Interactive group project break-out to analyze, compare and contrast financial statements of various companies; discussion and recommendation of which companies are more attractive

Video Length / Estimated Total Course Time:
2.5 hours / 4 hours

How to Analyze a 10K

6 month(s) $ 0.00

Course Goals & Overview:
"How to Analyze a 10K" builds upon basic accounting and financial statements concepts to focus on the major components of a 10K SEC filing, including the Management Discussion & Analysis, Financial Condition and Results and how to analyze the myriad of footnotes.

It’s simply not enough to merely analyze the financial statements, but especially critical to plow through and understand the footnotes and the management discussion & analysis, where the most of the qualitative information is contained. The challenge is that there are a myriad of footnotes and figuring out which are the important and relevant ones is no small feat. This course provides the overview and analysis for most major common footnotes and gives you a starting point to plow in deeper when we build our financial models. The irony is that in the process of crunching numbers and building numbers, reading comprehension, particularly on the 10K is probably even more important in terms of getting the right inputs.

Course Sections:
Overview & Analysis
- What is a 10K and how is it different from an Annual Report?
- Major components of a 10K filing
- Detailed discussion on the MD&A section (Management Discussion & Analysis)
- Detailed discussion of all major footnotes and how to analyze and interpret major categories of footnotes: general footnotes, Balance Sheet footnotes, contingencies footnotes, Income Statement footnotes, Capital Structure footnotes, many other footnotes
- Brief discussion of Proxy statement and its utility
- Brief discussion and introduction to differences between US and International GAAP

Hands-on Exercise
- Interactive group project break-out to analyze, compare and contrast 10K's of various companies
- Concentration on: revenue terminology differences, balance sheet analysis, cash flow analysis, analysis and comparison of footnote, MD&A / segment breakdown and discussion

Video Length / Estimated Total Course Time:
2 hours / 3 hours

Finance 101 - Introduction to Finance

6 month(s) $ 0.00

Course Goals & Overview:
Learn the basic finance concepts that are the backbone of any financial analysis. An understanding of these basic core tools is absolutely critical to mastering any Wall Street analysis. Topics covered include risk / return trade-offs, time value of money, cost of capital, Gordon growth model and basic valuation theories.

Moving beyond the accounting and 10K analysis, this course provides an introduction to the major concepts in finance that many people take for granted. Understanding financial modeling, valuation, and the capital markets in general would be difficult without a full grasp of these fundamental concepts.

Course Sections:
- Risk / Return: Calculating returns and measuring risk, benefits of diversification (systematic and unsystematic risk, total risk, market risk and firm-specific risk), security market line, capital asset pricing model, beta
- Time Value of Money: present and future values, net present value, internal rate of return, compounding, discounting, uneven cash flow streams, simple vs. effective rates, periodic rates, CAGR (Compound Annual Growth Rates)
- Basic Valuation Theories: value of any asset, dividend discount model (theory only!), Gordon growth model, growing perpetuity
- Cost of Capital: sources of capital, component costs, weighted average cost of capital

Video Length / Estimated Total Course Time:
1.5 hours / 2 hours

Company Profiles

6 month(s) $ 0.00

Course Goals & Overview:
Company profiles are the most basic overview and descriptions of a company being analyzed. Profiles supply the most basic and fundamental, yet probably the most important aspects of a company. Gain an introduction and explanation of the major components of a profile for a publicly traded company.

Course Sections:
- Summary business description and financial summary and trading analysis
- Stock price charts: price / volume graphs, indexed stock price history, moving averages, shares traded at various prices, forward PE history, historical EBITDA multiple valuation trends, beta and volatility, management and Board of Directors biographies, ownership analysis

Video Length / Estimated Total Course Time:
1 hour / 1 hour

Company Overview

6 month(s) $ 0.00

Course Goals & Overview:
Build very quick financial summary and trading statistics exhibit using historical results, analyst estimates & basic assumptions in Excel. This course will allow you to understand basic structure of building an analysis in Excel and navigating through and becoming efficient in Excel.

Course Sections:
Financial Summary
- Build a very simple financial overview exhibit by inputting historical results, analyst estimates and basic projections.

Trading Statistics
- Build trading statistics exhibit displaying standard market valuation multiples.

Video Length / Estimated Total Course Time:
1.5 hours / 2 hours

Overview of Financial Markets

6 month(s) $ 0.00

Course Goals & Overview:
Introduction to the major jargon and finance terminology in finance. What exactly is the sell-side and the buy-side and do they affect the capital markets and why do they have a symbiotic relationship? What exactly is investment banking, sales & trading and research? How is it that asset management is the flip opposite and yet very similar at the same time? Put those questions to rest with this Overview of Financial Markets overview.

Course Sections:
- Overview of the Sell-Side Process: Investment banking (products / services, deal process, role of professional, industry trends, buzzwords, bulge bracket vs. boutique middle market), equity research, commercial banking, sales & trading (prime brokerage, proprietary trading)
- Overview of the Buy-Side Process: Asset management (products / services, role of professional, industry trends, buzzwords, private client services, private wealth management, portfolio management ), alternatives (hedge funds, private equity, fund of funds)

Video Length / Estimated Total Course Time:
1 hour / 1 hour

Supplementary Video Exhibits

6 month(s) $ 0.00

Treasury Options: - Explanation of how to account for diluted shares outstanding using the treasury method of adjustment

Depreciation in Future: - Full tutorial on the concepts of depreciation vs. capital expenditures in the long run
- Full explanation on the concepts working capital and importance of

Share Repurchase: - Step-by-step walk-through of whether or not share repurchases add value

Circular Reference: - Explanation of how and why circular references are created in a financial model - Our various financial modeling courses explain how to avoid circular references

Excel Iterations: - Detailed explanation of how Excel's iterations function works when you cannot avoid circular reference

Gray Background: - Tutorial of how to change your background to gray when using white cells and white shading

WST Excel Add-in Instructions: - How to properly install Wall St. Training's Excel add-in macros & toolbars

Increase / Decrease Decimal Instructions: - How to automate increase and decrease decimals without the mouse and really customize Excel to the next level

Video Length / Estimated Total Course Time:
1 hour / 1.5 hours

Youtube Clips

6 month(s) $ 0.00

A sampling of selected extracts – self-contained video clips - from our courses and packages. For full access to our courses, click on Order More Courses. Enjoy!