Financial Modeling

This book provides a comprehensive introduction to modern financial modeling using Excel, VBA, standards of financial modeling and model review. It offers guidance on essential modeling concepts around the four core financial activities in the modern financial industry today: financial management; corporate finance; portfolio management and financial derivatives. Written in a highly practical, market focused manner, it gives step-by-step guidance on modeling practical problems in a structured manner. Quick and interactive learning is assured due to the structure as a training course which includes applied examples that are easy to follow. All applied examples contained in the book can be reproduced step by step with the help of the Excel files. The content of this book serves as the foundation for the training course Certified Financial Modeler.

In an industry that is becoming increasingly complex, financial modeling is a key skill for practitioners across all key sectors offinance and banking, where complicated problems often need to be solved quickly and clearly. This book will equip readers with the basic modeling skills required across the industry today.

Chapter1. Financial Modeling Standards. -Chapter2. Model Review. -Chapter3. Excel Workshop(1). -Chapter4. Excel Workshop (2). -Chapter5. Excel Workshop (3). -Chapter6. VBA Workshop. -Chapter7. Investment Appraisal. -Chapter8. Financing. -Chapter9. Corporate Finance (1). -Chapter10. Corporate Finance (2). - Chapter11. Portfolio Management (1). -Chapter 12. Portfolio Management (2). -Chapter 13. Derivatives.