Häcker J., Ernst D. Financial Modeling: An Introductory Guide to Excel and VBA Applications in Finance

Palgrave Macmillan, 2017. — 1012 p.This book is structured around the instruments of modern Financial Management. Strategic decisions of corporations are increasingly supported by financial models. These are created by an expert, the financial modeler. In the context of financial modeling he creates applications based on financial knowledge in the context of modern standardized software – Excel in particular. This textbook provides comprehensive training in the field of financial modeling for managers, financial experts, young professionals and students. These skills provide excellent career prospects. 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. These files are also available for download at www.certified-financial-modeler.de in addition to the web pages of the publisher provided on the first page. There you find additional files dealing with the topic of financial modeling. Best results will be obtained if you directly apply the theoretical contents and make use of the online-offering as you work your way through the text. This textbook is suitable for teaching at the university and college level as well as for in house-training at corporations. It is also possible to study the material independently. Mastery of the subject matter can be demonstrated via the title “Certified Financial Modeler” which is awarded by the German Institute of Corporate Finance.
This book contains the following topics:
Financial Modeling Standards.
Model Review.
Financial Modeling using Excel.
Financial Modeling using VBA.
Investment Appraisal and Financing.
Corporate Finance.
Portfolio Management.
Derivatives.