|
Build a fully integrated financial statement projection model with
income statement projections, self-balancing balance sheet, automated
cash flow statement, and balancing cash flow sweep/debt schedule. Learn
how to auto balance the model without plugs, integrate the model via
interest, and control for circular references as well as best practices.
Leave the classroom with a fully constructed model that can be
customized and applied to other companies.
Note: Bring your PC laptop with Microsoft Excel installed and a
CD-ROM drive. (Excel 2007, Vista, and Macs may not be as effective.)
Prerequisites: While knowledge of advanced accounting
concepts is not required for this course, you should possess knowledge
of basic accounting ratios and a fundamental understanding of how the
major financial statements are interrelated. Intermediate
proficiency using Excel and a solid grasp of basic accounting
fundamentals are required. NYSSA’s “Basic
Financial Modeling Using Excel” and “Corporate
Valuation Methodologies” classes are recommended,
but not required.
Note: To maximize the educational value of this
program, it is strongly recommended that you have a basic understanding
of Excel and are familiar with its functions and features. Lack of basic
Excel skills will impede your ability to effectively acquire and
implement the techniques and shortcuts that are presented in this
program. If you have any questions, or for further information, please contact the Education Department
at education@nyssa.org.
Level: Advanced
|
