Financial Modeling—Core Model
Increase your efficiency in Excel and learn best practices of model
building. Build a fully integrated financial statement projection model
with income statement projections, self-balancing balance sheet,
automated cash flow statement, and the balancing debt sweep schedule.
Expand your knowledge on how to auto balance the model without plugs,
integrate the model via interest and control for circular references.
Leave with a fully constructed model that can be customized and applied
to other companies.
Prerequisites: Proficiency using Excel, knowledge of
basic accounting ratios, and an understanding of how the major financial
statements are interrelated.
Note: Bring your PC laptop with Microsoft Excel
installed and a CD-ROM drive. Mac applications may not be as
effective.
Also Recommended: Basic Financial Modeling
Using Excel on February 24, Financial Modeling—Enhancements on
April 22 and Advanced Excel for Data Analysis in Summer 2010.
|
DATE:
Wednesday, April 14, 2010
TIME:
9:00 a.m.–5:00 p.m.
LOCATION:
NYSSA
1540 Broadway, 10th Floor, NYC
(entrance on 45th Street–Times Square)
Photo ID required for access to the building.
|
INSTRUCTOR:
Hamilton Lin, CFA ( Instructor Bio)
TUITION:
Member $520 | Nonmember $620
Student, Retired and Unemployed members receive half off member
price
LEVEL: Intermediate
CREDITS:
CE/CPE = 7
|
|