CFA Chicago Education Advisory Group and Wall St. Training are pleased to offer a suite of technical programs designed to provide members with interactive, practical approaches to analyzing companies.

Members and guests are invited to attend some or all of the sessions listed below. All sessions will be held at the Standard Club (320 S. Plymouth Ct.). Scroll to end of announcement for session details. Register for 2 courses and save $50 off your total payment! Register for 3 courses and save $75 off your total payment!

Monday, April 28 - 9am-12:30pm
Corporate Valuation - Relative Valuation
Level: Intermediate
Fee: $250 member/$300 non-member; $50 student-member (limited space)

Monday, April 28 - 2pm-5:30pm
Intermediate Financial Modeling Using Excel
Level: Intermediate
Fee: $250 member/$300 non-member; $50 student-member (limited space)

Tuesday, April 29 - 9am-5pm
Advanced Financial Modeling Using Excel
Level: Advanced
Fee: $495 member/$595 non-member; $95 student-member (limited space)

Wednesday, April 30 - 9am-5pm
Advanced Excel for Data Analysis
Level: Advanced
Fee: $495 member/$595 non-member; $95 student-member (limited space)

All of these courses are hands-on technical workshops. You should have Intermediate proficiency using Excel and familiarity with its functions and features for the Corporate Valuation and Intermediate Financial Modeling courses. You should have Advanced proficiency using Excel and familiarity with its functions and features for the Advanced Finanical Modeling and Advanced Excel for Data Analysis courses. In addition, you should have a solid grasp of basic accounting fundamentals for all courses.

Lack of the stated skills will impede your ability to effectively acquire and implement the techniques and shortcuts that are presented in this program.

Note: Bring your PC laptop with CD-ROM drive with Microsoft Excel installed. (Excel 2007, Vista, and Macs may not be as effective.)

This program qualifies for credit under the guidelines for the CFA Institute Continuing Education Program. Please click here if you would like more information.

Location:
The Standard Club
320 S. Plymouth Ct.

Date:
Monday, April 28
Tuesday, April 29
Wednesday, April 30

Time:
Registration opens 30 minutes prior to session; See specific times above.

Attire:
Business Casual

This is a "Passport Program." Members of any local CFA society may attend at the CFA Chicago member rate. If you are only a member of CFA Institute, you do not qualify for the society member rate.

For Reservations
Register online below, or by phone: 312-251-1301

We require a credit card guarantee for ALL reservations.
(Visa, MasterCard, American Express, Discover and Diners Club are accepted)

Cancellations accepted until 5:00 pm, April 24. There is a $5 surcharge for walk-ins.

COURSE DESCRIPTIONS:

Corporate Valuation - Relative Valuation
Monday, April 28
9am-12:30pm

Learn how to value companies from a relative valuation perspective. This course takes a practical, tangible, and non-theoretical approach to examining how corporations are valued based on market multiples (trading comps). Coverage goes beyond the academic theory of financial ratios to the practical application of fundamental analysis, offering real-world methods of evaluating a company's relative value. Incorporate the concepts learned by immediately working on Excel-based, hands-on exercises. Perform valuation modeling techniques including: trading statistics, quick & dirty trading comps, reference range analysis, football field construction and WACC calculation. Input historical results and analyst projections for comparable companies, calculate current standalone market valuation multiples and calculate implied valuation of target company.

Level: Intermediate

Intermediate Financial Modeling Using Excel
Monday, April 28
2pm-5:30pm

Learn how to model and build a five-year financial statement projection and valuation model from scratch. You will be provided with a 10K (Annual Report), a list of advanced Excel shortcuts and customized macros. With a focus on incorporating and fusing your accounting knowledge into the mechanics of Excel, you will input publicly available information and learn various shortcuts to construct a five-year income statement projection model from revenue down to earnings per share. Combined with your knowledge of the basics of corporate finance and valuation, translate the model into a discounted cash flow analysis. Leave the classroom with an easily scalable and customizable model that can be immediately applied to other companies.

To obtain the desired financial background, the "Corporate Valuation Methodologies" class is highly recommended as a precursor.

Advanced Financial Modeling Using Excel - Core Model
Tuesday, April 29
9am-5pm
(Lunch will be provided)

This course takes a practical, hands-on approach to the quantitative and technical aspects of advanced financial modeling using Excel. You will build a fully integrated financial statement projection model with income statement projections, a self-balancing balance sheet, an automated cash flow statement, and the balancing cash flow sweep/debt schedule. While knowledge of advanced accounting concepts is not required for this course, you should possess knowledge of basic account ratios and a basic understanding of how the major financial statements are interrelated. You will leave the classroom with a fully constructed model that can be customized and applied to other companies. You will be able to layer other analyses onto this core projection model, including credit and leverage statistics, valuation analyses, or mergers and acquisitions modeling.

The "Corporate Valuation Methodologies" and "Intermediate Financial Modeling using Excel" classes are recommended, but not required.

Advanced Excel for Data Analysis
Wednesday, April 30
9am-5pm

This course focuses on how to effectively and efficiently utilize Microsoft Excel for data analysis. A financial analyst will not only use Excel to build financial models, but also to crunch a large data dump. Learn how to minimize as much manual labor as possible, thereby saving time and performing more detailed analysis quickly. Apply commonly-used formulas in new and different ways; uncover often over-looked Excel formulas; streamline number crunching and analysis via functions and tools including pivot tables, sumif, sum+if, transpose, working with arrays, vlook-up, subtotals, and regression analysis; enhance your spreadsheets with drop-down boxes, data validation techniques, automation of alternate row shading; take Excel to the next level with an introduction to building and automating simple macros and more!

To obtain the desired financial background, the "Corporate Valuation Methodologies" class is highly recommended as a precursor.