国信模型培训2008综述.ppt

Internal Training Use Only;Table of Contents;Table of Contents (cont);Purpose of this Workshop;1. Overview of Financial Modeling ;What is a Financial model?;Different Types of Models;End Goal of a Model;Essence of a Model: Assumptions;Choosing Assumptions;An Effective and Efficient Model is ...;2. Excel Best Practices ;Excel Best Practices Principles;Commonly Used Shortcut Keys;Commonly Used Functions;Use a consistent color scheme (use print “black white): Blue = inputs (historical, assumptions, and drivers) Black = calculations references on same schedule/sheet Green = references from another schedule/sheet Red = Warnings to another user/links to another model DON’T embed inputs in formulas INSTEAD, break out into separate line item;Excel Best Practices (cont);Moving Between Toolbars;Customizing Your Toolbar;Move Selection after Enter;Formatting Matters!;Custom Number Formatting;Custom Number Formatting (cont);Custom Number Formatting (cont);3. Before We Begin ... ;Use a Modular Approach;Use a Modular Approach (cont);Things to Emphasize;Tips Before We Begin;Stress Testing Your Model;4. Core Statements ;Overview of Core Statements;Core Statements;5. Working Capital Schedule ;Overview of Working Capital;Working Capital;Illustrative Flows of Funds;6. Depreciation Schedule ;Overview of Depreciation Schedule;Overview of Depreciation Schedule (cont);Depreciation Schedule ;Projecting Dep. From Existing PPE;Illustrative Flow of Funds;7. Amortization Schedule ;Overview of Amortization Schedule;Overview of Amortization Schedule (cont);Amortization Schedule;Illustrative Flow of Funds;8. Other Long-Term Items’ Schedule ;Overview of Other Long-Term Items;Other Long-Term Items;Illustrative Flow of Funds;9. Completion of Income Statement Logic;Completing Income Statement Logic;10. Shareholders’ Equity Schedule;Overview of Equity Schedule;Equity Schedule;Illustrative Flow of Funds;11. Share Outstanding Schedule;Share Outstanding Schedule;Share Outstanding Schedule;12. Prepa