Financial Modeling

Cover 1) Overview of Financial Modeling 2) Modeling Best Practices 3) Before We Begin... 4) Constructing the Model Core Statements Working Capital Schedule Depreciation Schedule Amortization Schedule Other Long-Term Items' Schedule Completion of Income Statement Logic Shareholders' Equity Schedule Shares Outstanding Schedule Preparing for Debt and Interest Debt and Interest Schedule 5) Trouble Shooting Your Model Dealing with Circular Models Balancing Your Model Deal Ready Model 6) The Finished Product 7) Advanced Excel Functionality Data Tables Overview of Print Macros Utilizing TEXT Functions 8) Creating Scenarios 9) Other Tips and Tricks 10) Step-by-Step Construction Core Statements Working Capital Schedule Depreciation Schedule Amortization Schedule Other Long-Term Items' Schedule Completion of Income Statement Logic Shareholders' Equity Schedule Shares Outstanding Schedule Preparing for Debt and Interest Debt and Interest Schedule 11) TTS Turbo Macros Overview 12) Additional Resources TTS Templates and Webinars