Financial Modeling and DCF Modeling
Intermediate Proficiency Using Excel Required

Learn how to model and build a five-year Income Statement projection model from scratch for valuation purposes or for analyzing mergers and acquisitions. You will be provided with a 10K (Annual Report) and 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, you will translate the model into a discounted cash flow analysis. In addition, you will build and analyze current market valuation and multiples analysis at various prices including proper way to treat and account for dilutive options. Leave the classroom with an easily scalable and customizable model that can be immediately applied to other companies.

Prerequisite: Intermediate proficiency using Excel and a sold grasp of basic accounting, finance and valuation fundamentals are required. This Financial Modeling class is a technical workshop. NOTE: Lack of Excel skills will impede your ability to effectively acquire and implement the techniques and shortcuts that are presented in this program.

Bring your PC laptop with Microsoft Excel installed and a working USB slot drive (files will be copied using USB thumb drive). Please note that Macs with Excel 2008 may not be as effective, so we recommend bringing a PC or Mac with Windows/Excel installed.

Eligible for 7 credit hours

This seminar 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:
Wednesday, December 10, 2008

Time:
8:30 - 9:00 am: Registration
9:00 am - 5:00 pm: Seminar

Lunch will be provided

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

Attire:
Business Casual

Fees:
Member Rate: $495 (cash, check or credit card)
Student-Member Rate: $125 (cash, check or credit card); Limited seats available Note: This rate is only available to students who have been approved as a Student-Member of CFA Chicago.
Non-Member Rate: $595 (cash, check or credit card)

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

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

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

SAVE THE DATE: MONDAY, APRIL 27, 2009
"CORPORATE VALUATION METHODOLOGIES"
This course takes a practical, tangible and non-theoretical approach to examining how corporations are valued and the major analytical tools that are used.

Registration will open in March, 2009.