Financial Modeling An Introductory Guide to Excel and VBA Applications in Finance

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. 

Joachim Hacker is Professor of Corporate Finance at Munich University, Germany. He is Director and co-owner of the German Institute of Corporate Finance (GICF) and the European Institute of Financial Engineering and Derivatives (EIFD). Prior to his academic career, Joachim Hacker was a Vice President at Rothschild in the Mergers & Acquisitions department. He holds a PhD in economics and one in law from the University of Tubingen, Germany.

Dietmar Ernst is Professor of International Finance at Nurtingen University, Germany, where he teaches investment banking, corporate finance, valuation and M&A.  He is also a Director and co-owner of the German Institute of Corporate Finance (GICF) and the European Institute of Financial Engineering and Derivatives (EIFD). His career spans academia and finance and where he was previously an Investment Manager at Landesbank Baden-Württemberg (LBBW). He holds a PhD in economics from University of Tubingen, Germany, and one in Natural Science from the University of Stuttgart, Germany.