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

Intro -- Global Financial Markets -- Preface -- Contents -- About the Authors -- List of Figures -- List of abbreviations and symbols -- List of Synonyms -- 1 Introduction -- 1 How Can Managers Assure that the Decision Papers which They Receive Are Not Already Flawed and Faulty Decisions Are Reached as a Consequence? -- 2 How Can Applied Tasks Be Modeled Clearly and in a Structured Manner? -- 3 How Can Macros Be Used in the Modeling Process? -- 4 How Can Financial Modeling Be Used in Applied Work in Finance? -- 5 How to Create Financial Models for Investment and Financing? -- 6 How to Create Financial Models for Corporate Finance? -- 7 How to Create Financial Models for Portfolio Management? -- 8 How to Create Financial Models in the Field of Derivatives? -- 9 Who Needs a Deep Understanding of Financial Modeling? -- 10 How Can I Demonstrate My Financial Modeling Skills? -- 2 Financial Modeling Standards -- 1 Executive Summary -- 2 Introduction, Structure, Learning Outcomes and Case Study -- 3 Foundations of Financial Modeling -- 3.1 What Are Models and What Is Financial Modeling? -- 3.2 Analyzing the Model Requirements and Defining a Task List -- 3.3 Structuring Financial Models in Modules -- 4 Current State of Financial Modeling in Theory and Applied Work -- 4.1 Literature on Financial Modeling -- 4.2 Different Approaches - Identical Aims -- 5 Financial Modeling Standards -- 5.1 Top-10 Financial Modeling Standards -- 5.2 150 Financial Modeling Standards -- 6 Implementing the Top-10 Financial Modeling Standards with Reference to an Example -- 6.1 Define the Modeling Purpose -- 6.2 Separate the Problem into independent Subsections (Modules) -- 6.3 Provide a Graph of the Flow of Data and the Model Structure -- 6.4 Separate Inputs from Outputs -- 6.5 Choose a Unified Layout for the Worksheets -- 6.6 Use Unified Formatting.