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

✍ Scribed by Joachim Häcker,Dietmar Ernst (auth.)

• Publisher: Palgrave Macmillan UK
• Year: 2017
• Tongue: English
• Leaves: 1012
• Series: Global Financial Markets
• Edition: 1
• Category: Library

✦ Synopsis

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 of finance 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.

✦ Table of Contents

Front Matter ....Pages i-lxiii
Introduction (Joachim Häcker, Dietmar Ernst)....Pages 1-5
Financial Modeling Standards (Joachim Häcker, Dietmar Ernst)....Pages 7-58
Model Review (Joachim Häcker, Dietmar Ernst)....Pages 59-112
Workshop Excel Part I (Joachim Häcker, Dietmar Ernst)....Pages 113-141
Workshop Excel Part II (Joachim Häcker, Dietmar Ernst)....Pages 143-201
Workshop Excel Part III (Joachim Häcker, Dietmar Ernst)....Pages 203-235
VBA Workshop (Joachim Häcker, Dietmar Ernst)....Pages 237-342
Investment Appraisal (Joachim Häcker, Dietmar Ernst)....Pages 343-384
Financing (Joachim Häcker, Dietmar Ernst)....Pages 385-500
Corporate Finance Part I (Joachim Häcker, Dietmar Ernst)....Pages 501-622
Corporate Finance Part II (Joachim Häcker, Dietmar Ernst)....Pages 623-678
Portfolio Management Part I (Joachim Häcker, Dietmar Ernst)....Pages 679-754
Portfolio Management (Joachim Häcker, Dietmar Ernst)....Pages 755-839
Derivatives (Joachim Häcker, Dietmar Ernst)....Pages 841-943
Back Matter ....Pages 945-956

✦ Subjects

Corporate Finance