Advanced Financial Modeling - Core Model (Ended)
Advanced Financial Modeling - Core Model
(Intermediate Proficiency Using Excel & Solid Grasp of Basic Accounting Fundamentals Required)
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 debt sweep schedule. Properly manage the use of circular references and avoid plugs to balance your model and mastering best practices of model building. While knowledge of advanced accounting concepts is not required for this course, you should possess knowledge of basic accounting ratios and a basic understanding of how the major financial statements are interrelated. You will leave the classroom with a fully constructed and cleanly built, self-contained 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.
Prerequisite: Intermediate proficiency using Excel and a solid grasp of basic accounting fundamentals are required. Lack of basic Excel 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 a CD-ROM drive and Microsoft Excel installed. (Macs with Office 2008 will not be as effective).
Eligible for 7 credit hours
This program qualifies for credit under the guidelines for the CFA Institute Continuing Education Program. Please click here if you would like more information.
The Standard Club
320 S. Plymouth Ct.
Tuesday, December 1, 2009
8:30 - 9:00am - Registration
9:00am - 5:00pm - Seminar
Lunch will be provided.
Materials: Bring your PC laptop with a CD-ROM drive and Microsoft Excel installed. (Macs with Office 2008 will not be as effective) Note: Laptops will not be provided.
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 for 2009-2010.
Non-Member Rate: $595 (cash, check or credit card)
Credit card is required to guarantee 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.
Register online below, or by phone: 312-251-1301
Cancellations accepted until 5:00 pm, November 30. There is a $5 surcharge for walk-ins.
Content shared during CFA Society Chicago programs is not, and nothing in it should be construed as, an offer, invitation or recommendation of any specific financial services company or professional, or an offer, invitation or recommendation to sell, or a solicitation of an offer to buy, any securities in any jurisdiction. By registering for and attending this event, you acknowledge that any photographs that may be taken are the property of CFA Society Chicago and give your consent to their use in CFA Society Chicago's online and print business communications and marketing.