Skip to main content
  • Book
  • © 2017

Financial Modeling

An Introductory Guide to Excel and VBA Applications in Finance

Palgrave Macmillan
  • Will be used for the Certified Financial Modeler accreditation, a joint training program of the German Institute of Corporate Finance and the German Stock Exchange
  • Helps plug a gap across numerous disciplines where there is a dearth in the understanding of financial applications of Excel and VBA amongst finance practitioners
  • Supported by an e-learning platform featuring 1400 exercises covering all areas of the book

Part of the book series: Global Financial Markets (GFM)

Buy it now

Buying options

eBook USD 84.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book USD 109.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (14 chapters)

  1. Front Matter

    Pages i-lxiii
  2. Introduction

    • Joachim Häcker, Dietmar Ernst
    Pages 1-5
  3. Financial Modeling Standards

    • Joachim Häcker, Dietmar Ernst
    Pages 7-58
  4. Model Review

    • Joachim Häcker, Dietmar Ernst
    Pages 59-112
  5. Workshop Excel Part I

    • Joachim Häcker, Dietmar Ernst
    Pages 113-141
  6. Workshop Excel Part II

    • Joachim Häcker, Dietmar Ernst
    Pages 143-201
  7. Workshop Excel Part III

    • Joachim Häcker, Dietmar Ernst
    Pages 203-235
  8. VBA Workshop

    • Joachim Häcker, Dietmar Ernst
    Pages 237-342
  9. Investment Appraisal

    • Joachim Häcker, Dietmar Ernst
    Pages 343-384
  10. Financing

    • Joachim Häcker, Dietmar Ernst
    Pages 385-500
  11. Corporate Finance Part I

    • Joachim Häcker, Dietmar Ernst
    Pages 501-622
  12. Corporate Finance Part II

    • Joachim Häcker, Dietmar Ernst
    Pages 623-678
  13. Portfolio Management Part I

    • Joachim Häcker, Dietmar Ernst
    Pages 679-754
  14. Portfolio Management

    • Joachim Häcker, Dietmar Ernst
    Pages 755-839
  15. Derivatives

    • Joachim Häcker, Dietmar Ernst
    Pages 841-943
  16. Back Matter

    Pages 945-956

About this book

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.

Authors and Affiliations

  • German Institute of Corporate Finance, Nürtingen, Germany

    Joachim Häcker, Dietmar Ernst

About the authors

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.

Bibliographic Information

Buy it now

Buying options

eBook USD 84.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book USD 109.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access