| 000 -LEADER |
|---|
| fixed length control field |
13389cam a22004097a 4500 |
| 001 - CONTROL NUMBER |
|---|
| control field |
19733894 |
| 003 - CONTROL NUMBER IDENTIFIER |
|---|
| control field |
OSt |
| 005 - DATE AND TIME OF LATEST TRANSACTION |
|---|
| control field |
20230308170637.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
|---|
| fixed length control field |
170620s2017 enka 001 0 eng d |
| 010 ## - LIBRARY OF CONGRESS CONTROL NUMBER |
|---|
| LC control number |
2017946169 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
9781137426574 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
1137426578 |
| 035 ## - SYSTEM CONTROL NUMBER |
|---|
| System control number |
(OCoLC)on1027711321 |
| 040 ## - CATALOGING SOURCE |
|---|
| Original cataloging agency |
SINAP |
| Language of cataloging |
eng |
| Transcribing agency |
SINAP |
| Modifying agency |
OCLCO |
| -- |
SINLB |
| -- |
OCLCF |
| -- |
OCLCQ |
| -- |
OCLCO |
| -- |
DLC |
| 042 ## - AUTHENTICATION CODE |
|---|
| Authentication code |
lccopycat |
| 050 00 - LIBRARY OF CONGRESS CALL NUMBER |
|---|
| Classification number |
HF5548.4.M523 |
| Item number |
H33 2017 |
| 082 ## - DEWEY DECIMAL CLASSIFICATION NUMBER |
|---|
| Classification number |
658.15 HAC |
| 100 1# - MAIN ENTRY--PERSONAL NAME |
|---|
| Personal name |
Häcker, Joachim A., |
| Dates associated with a name |
1968- |
| 245 10 - TITLE STATEMENT |
|---|
| Title |
Financial modeling : |
| Remainder of title |
An introductory guide to Excel and VBA applications in finance / |
| Statement of responsibility, etc. |
Joachim Häcker, Dietmar Ernst. |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. |
|---|
| Place of publication, distribution, etc. |
London : |
| Name of publisher, distributor, etc. |
Palgrave Macmillan, |
| Date of publication, distribution, etc. |
[2017] |
| 300 ## - PHYSICAL DESCRIPTION |
|---|
| Extent |
lxiii, 956 pages : |
| Other physical details |
illustrations ; |
| Dimensions |
25 cm. |
| 336 ## - CONTENT TYPE |
|---|
| Content type term |
text |
| Content type code |
txt |
| Source |
rdacontent |
| 337 ## - MEDIA TYPE |
|---|
| Media type term |
unmediated |
| Media type code |
n |
| Source |
rdamedia |
| 338 ## - CARRIER TYPE |
|---|
| Carrier type term |
volume |
| Carrier type code |
nc |
| Source |
rdacarrier |
| 490 0# - SERIES STATEMENT |
|---|
| Series statement |
Global financial markets |
| 505 ## - FORMATTED CONTENTS NOTE |
|---|
| Formatted contents note |
1 Introduction<br/>1 How Can Managers Assure that the Decision Papers which They Receive Are Not Already Flawed and Fau<br/>2 How Can Applied Tasks Be Modeled Clearly and in a Structured Manner?<br/>3 How Can Macros Be Used in the Modeling Process?<br/>4 How Can Financial Modeling Be Used in Applied Work in Finance?<br/>5 How to Create Financial Models for Investment and Financing?<br/>6 How to Create Financial Models for Corporate Finance?<br/>7 How to Create Financial Models for Portfolio Management?<br/>8 How to Create Financial Models in the Field of Derivatives?<br/>9 Who Needs a Deep Understanding of Financial Modeling?<br/>10 How Can I Demonstrate My Financial Modeling Skills?<br/>2 Financial Modeling Standards<br/>1 Executive Summary<br/>2 Introduction, Structure, Learning Outcomes and Case Study<br/>3 Foundations of Financial Modeling<br/>3.1 What Are Models and What Is Financial Modeling?<br/>3.2 Analyzing the Model Requirements and Defining a Task List<br/>3.3 Structuring Financial Models in Modules<br/>4 Current State of Financial Modeling in Theory and Applied Work<br/>4.1 Literature on Financial Modeling<br/>4.2 Different Approaches – Identical Aims<br/>5 Financial Modeling Standards<br/>5.1 Top-10 Financial Modeling Standards<br/>5.2 150 Financial Modeling Standards<br/>6 Implementing the Top-10 Financial Modeling Standards with Reference to an Example<br/>6.1 Define the Modeling Purpose<br/>6.2 Separate the Problem into independent Subsections (Modules)<br/>6.3 Provide a Graph of the Flow of Data and the Model Structure<br/>6.4 Separate Inputs from Outputs<br/>6.5 Choose a Unified Layout for the Worksheets<br/>6.6 Use Unified Formatting<br/>6.7 Avoid Complex Formulas and Use Only One Type of Formula<br/>6.8 Avoid Circular References<br/>6.9 Work with Control Functions<br/>6.10 Present the Results Professionally<br/>7 Summary<br/>Notes<br/>Further Reading<br/>3 Model Review<br/>1 Executive Summary<br/>2 Introduction, Structure and Learning Outcomes and Case Study<br/>3 Fundamentals of Model Review<br/>3.1 The Term ``Model Review''<br/>3.2 Steps in the Model Review Process<br/>4 Errors in Financial Models<br/>4.1 Qualitative Errors<br/>4.2 Quantitative Errors<br/>5 Error Detection – Recognizing and Finding Errors<br/>5.1 Logic Inspection<br/>5.2 Tests<br/>5.3 Analysis Tools<br/>6 Examples of Applications of Analysis Tools<br/>6.1 Brief Market Overview of Analysis Tools<br/>6.2 Model Review with Microsoft Excel<br/>6.3 Model Review with Operis Analysis Kit (OAK)<br/>7 Control Calculations<br/>7.1 Control Calculations that Show the Concrete Numerical Deviation<br/>7.2 Binary Control Calculations<br/>8 Measures to Assess the Plausibility of the Results<br/>8.1 Sensitivity Analysis<br/>8.2 Scenario Analysis<br/>9 Documentation<br/>10 Summary<br/>Notes<br/>Further Reading<br/>4 Workshop Excel Part I<br/>1 Executive Summary<br/>2 Introduction, Structure, Learning Outcomes and Case Study<br/>3 Why Study Excel?<br/>4 Developing a Financial Model<br/>4.1 Defining the Task List<br/>4.2 Identifying the Key Tasks<br/>4.3 Visualizing Abstract Relations with Bubble Charts<br/>5 Visual Display of a Financial Model<br/>5.1 Structuring a Financial Model<br/>5.2 Documenting a Financial Model<br/>5.3 Structuring Large Financial Models Ergonomically<br/>5.4 Borders and Lines: Providing Structure to the Data<br/>5.5 Using Colors to Highlight Important Elements<br/>6 Side Note: Using Key Combinations and the Ribbon to Work in Excel<br/>6.1 Key Combinations and Sequences in Excel<br/>6.2 Different Types of Key Combinations in Excel<br/>7 Summary<br/>Further Reading<br/>5 Workshop Excel Part II<br/>1 Executive Summary<br/>2 Introduction, Structure, Learning Outcomes and Case Study<br/>3 Creating a Prototype in Excel<br/>3.1 The Formula Sheet – The Translator<br/>3.2 Use of Formulas<br/>3.3 Activating Add-ins<br/>3.4 Making Use of Additional Functions<br/>3.5 Using Names to Improve Clarity of the Formulas<br/>3.6 Comments<br/>4 Sending Signals to the Management<br/>4.1 Signaling with Colors: Conditional Formatting to Create Information<br/>4.2 Text as Signal: Providing Informative Messages<br/>5 Data Collection<br/>5.1 Secure Data Gathering<br/>5.2 Importing Internal Data<br/>5.3 Importing External Data: Working with Security Prices from the Internet in Excel<br/>6 Analysis Stage: Sensitivity and Scenarios<br/>6.1 Sensitivity Analysis Using Data Tables<br/>6.2 Scenarios with the Scenario Manager<br/>6.3 Goal Seek<br/>6.4 Solver – Goal Seek for Challenging Tasks<br/>7 Testing the Performance of a Financial Model<br/>7.1 Formula Auditing: Checking the Flow of Data and Formulas<br/>7.2 Support from Error Checking<br/>7.3 Formula Evaluation: Formula Assessment Step by Step<br/>8 Summary<br/>Notes<br/>Further Reading<br/>6 Workshop Excel Part III<br/>1 Executive Summary<br/>2 Introduction, Structure, Learning Outcomes and Case Study<br/>3 Presenting Insights and Recommendations<br/>3.1 Recommendations for the Presentation of Charts<br/>3.2 Creating Simple Charts in Excel<br/>3.3 Dynamic Charts<br/>3.4 Selecting a Suitable Chart<br/>4 Summary<br/>Further Reading<br/>7 VBA Workshop<br/>1 Executive Summary<br/>2 Introduction, Structure and Learning Outcomes<br/>3 Why Study Programming with VBA?<br/>4 Generating Excel Software Solutions<br/>4.1 Preparing Excel for Macros<br/>4.2 Possibility 1: Creating Applications with the Macro Recorder<br/>4.3 Possibility 2: Programming with VBA<br/>5 Variables and the Most Important Data Types<br/>5.1 Declaring a Variable<br/>5.2 Conventions for Variable Names<br/>6 Process Flow Models and Charts<br/>6.1 Process Flow Models<br/>6.2 Flowchart<br/>6.3 Hierarchy Chart<br/>7 The Most Important Language Elements of VBA<br/>7.1 Programming with Branches<br/>7.2 Loops<br/>7.3 Programming Cells and Ranges<br/>8 Comfortable Input and Output Using Dialogue Fields<br/>8.1 Reading Data with the InputBox<br/>8.2 Data Output with the MsgBox<br/>9 Programming Your Own Dialogues<br/>9.1 Steps Needed to Create Your Own Dialogue<br/>9.2 Control Elements<br/>10 Creating Charts with VBA<br/>10.1 Information needed and Types of Diagrams<br/>10.2 Useful Programs for Diagrams<br/>11 Tool Kit: Practical Excel Tools for Modeling<br/>11.1 Programming Headers and Footers<br/>11.2 Transferring Comments to a List<br/>11.3 Creating a Table of Contents<br/>11.4 Protecting Cells with Formulas<br/>12 Summary<br/>Further Reading<br/>8 Investment Appraisal<br/>1 Executive Summary<br/>2 Learning Outcomes, Definitions, Model Structure and Case Study<br/>3 The Term Investment and Methods of Investment Appraisal<br/>4 Static Investment Appraisal Methods<br/>4.1 Cost Comparison Method<br/>4.2 Profit Comparison Method<br/>4.3 Average Rate of Return<br/>4.4 Static Payback Period Method<br/>4.5 Comparison and Assessment of the Static Investment Appraisal Methods<br/>5 Dynamic Investment Appraisal Methods<br/>5.1 Net Present Value Method<br/>5.2 Internal Rate of Return Method<br/>5.3 Annuity Method<br/>5.4 Comparison and Assessment of the Methods of Dynamic Investment Appraisal<br/>6 Summary<br/>Literature and Suggestions<br/>9 Financing<br/>1 Executive Summary<br/>2 Learning Outcomes, Definitions, Model Structure and Case Study<br/>3 Fundamental Rules of Financing<br/>3.1 The Golden Rule for Balance Sheets<br/>3.2 The Relationship between Equity and Debt and the Leverage Effect<br/>4 Analysis of Key Figures<br/>4.1 Key Return Figures<br/>4.2 Key Figures about Financial Structure<br/>4.3 Key Figures on the Asset Structure<br/>4.4 Key Figures for the Capital Structure<br/>4.5 Key Figures for the Structure of Earnings<br/>4.6 Cash Flow Key Figures<br/>5 The Ordinary Capital Increase<br/>5.1 Assumptions Concerning the Ordinary Capital Increase<br/>5.2 Calculating the Values on the Balance Sheet<br/>5.3 Calculating the Value of the Subscription Rights<br/>6 The Long-Term Loan<br/>6.1 Assumptions Concerning the Long-Term Loan<br/>6.2 The Annuity Loan<br/>6.3 The Amortizable Loan<br/>6.4 The Bullet Loan<br/>6.5 Comparison of the Various Types of Repayment<br/>7 Bonds<br/>7.1 Assumptions for the Bond<br/>7.2 Analyzing the Bond from the Issuer Perspective<br/>7.3 Analyzing the Bond from the Investor Perspective<br/>7.4 Present Value Method for Known Spot Rates<br/>7.5 Analysis of the Present Value Method<br/>7.6 Risk Analysis<br/>8 Short-Term Financing Using the Example of the Supplier Credit<br/>8.1 Interest on the Supplier Credit<br/>8.2 Granting a Supplier Credit<br/>8.3 Delaying Payment on a Supplier Credit<br/>9 The Cash Flow<br/>9.1 Basics<br/>9.2 Calculating the Gross Cash Flow from Operating Business Activities<br/>9.3 Calculating the Operating Free Cash Flow<br/>9.4 Calculating the Net Cash Flow<br/>9.5 Control Calculations<br/>10 Financing via Shortening of the Capital Commitment Period<br/>10.1 Premises when Shortening the Capital Commitment Period<br/>10.2 Reducing Receivables<br/>10.3 Inventory Reductions<br/>11 Summary<br/>Notes<br/>Literature and Suggestions for Further Reading<br/>10 Corporate Finance Part I<br/>1 Executive Summary<br/>2 Introduction, Structure, Learning Outcomes and Case Study<br/>3 Overview of the Methods of Company Valuation<br/>4 Company Valuation Using Discounted Cash Flow Models<br/>4.1 Basics of Corporate Planning<br/>4.2 WACC Approach<br/>4.3 Period-Specific WACC Approach<br/>4.4 APV Approach<br/>4.5 Equity Approach<br/>4.6 Sensitivity Analysis<br/>4.7 Scenario Analysis<br/>4.8 Company Valuation for Professionals<br/>5 Summary<br/>Notes<br/>Literature and Suggestions<br/>11 Corporate Finance Part II<br/>1 Executive Summary<br/>2 Introduction, Structure, Learning Outcomes and Case Study<br/>3 Company valuation Using Market Capitalization and Book Value<br/>3.1 Overview of Market Capitalization<br/>3.2 Overview of Book Value<br/>3.3 Valuation Process with Market Capitalization and Book Value<br/>4 Trading Multiples<br/>4.1 Overview of Trading Multiples<br/>4.2 Valuation Process with Trading Multiples<br/>5 Transaction Multiples<br/>5.1 Overview of Transaction Multiples<br/>5.2 Comparison of Trading Multiples and Transaction Multiples<br/>5.3 Valuation Process with Transaction Multiples<br/>5.4 The Football Field Graph<br/>6 Summary<br/>Notes<br/>Literature and Suggestions<br/>12 Portfolio Management Part I<br/>1 Executive Summary<br/>2 Introduction, Structure, Learning Outcomes and Case Study<br/>3 Portfolio Management<br/>4 Return<br/>4.1 Discrete Return<br/>4.2 Continuous Return<br/>4.3 Comparison between Continuous and Discrete Return<br/>4.4 Returns for Different Time Periods<br/>4.5 Calculation of Prices based on the Different Types of Returns<br/>5 Risk<br/>5.1 The Term Risk<br/>5.2 How to Estimate Risk<br/>5.3 Categories of Risk<br/>5.4 Volatility<br/>5.5 Variance<br/>5.6 Standard Deviation<br/>5.7 Risk Measures for Different Time Periods<br/>5.8 Moving Volatility<br/>5.9 Covariance<br/>5.10 Coefficient of Correlation<br/>5.11 Semi-variance<br/>5.12 Value at Risk<br/>5.13 Beta Factor<br/>6 Summary<br/>Notes<br/>Literature and Suggestions for Further Reading<br/>13 Portfolio Management<br/>1 Executive Summary<br/>2 Introduction, Structure, Learning Outcomes and Case Study<br/>3 Overview of Active and Passive Portfolio Management<br/>3.1 Introduction to the Topic<br/>3.2 Solving Optimization Problems with the Excel Solver<br/>3.3 Matrix Operations in Excel<br/>4 Active Portfolio Management<br/>4.1 Absolute Optimization<br/>4.2 Relative Optimization<br/>5 Passive Portfolio Management<br/>5.1 Quadratic Optimization<br/>5.2 Constrained Regression<br/>5.3 Linear Optimization<br/>5.4 Summary of the Results for Passive Portfolio Management<br/>6 Summary<br/>Notes<br/>Literature and Suggestions for Further Reading<br/>14 Derivatives<br/>1 Executive Summary<br/>2 Introduction, Structure, Learning Outcomes and Case study<br/>3 Options Basics<br/>3.1 Terminology and Types of Options<br/>3.2 Differentiating Features of Options<br/>3.3 What are the Value Drivers in Option Pricing?<br/>4 Option Pricing<br/>4.1 Basics of Option Pricing<br/>4.2 Models for Determining the Option Price<br/>5 What Is Involved in the Four Basic Option Strategies?<br/>5.1 Long Call<br/>5.2 Short Call<br/>5.3 Long Put<br/>5.4 Short Put<br/>6 Fundamentals of Futures<br/>6.1 What Are Futures?<br/>6.2 Which Futures Contracts Are Essential in Applied Work?<br/>7 Pricing of Futures Contracts<br/>7.1 Index Futures<br/>7.2 Interest Rate Futures<br/>7.3 Currency Futures<br/>7.4 Commodity Futures<br/>7.5 Futures on Single Stocks<br/>8 What is involved in the Basic Futures Strategies?<br/>8.1 Long Futures<br/>8.2 Short Futures<br/>8.3 Spreads<br/>9 Conclusions and Outlook<br/>10 Summary<br/>Notes<br/>Literature and Suggestions<br/>Index<br/>Read Less<br/> |
| 630 07 - SUBJECT ADDED ENTRY--UNIFORM TITLE |
|---|
| Uniform title |
Microsoft Excel (Computer file) |
| Source of heading or term |
fast |
| Authority record control number or standard number |
(OCoLC)fst01366659 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Electronic spreadsheets |
| General subdivision |
Computer programs. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Visual Basic for Applications (Computer program language) |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Finance |
| General subdivision |
Mathematical models. |
| Source of heading or term |
fast |
| Authority record control number or standard number |
(OCoLC)fst00924398 |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Visual Basic for Applications (Computer program language) |
| Source of heading or term |
fast |
| Authority record control number or standard number |
(OCoLC)fst01910316 |
| 700 1# - ADDED ENTRY--PERSONAL NAME |
|---|
| Personal name |
Ernst, Dietmar K., |
| Dates associated with a name |
1968- |
| 830 #0 - SERIES ADDED ENTRY--UNIFORM TITLE |
|---|
| Uniform title |
Global financial markets (Houndmills, Basingstoke, England) |
| 906 ## - LOCAL DATA ELEMENT F, LDF (RLIN) |
|---|
| a |
7 |
| b |
cbc |
| c |
copycat |
| d |
2 |
| e |
ncip |
| f |
20 |
| g |
y-gencatlg |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) |
|---|
| Source of classification or shelving scheme |
|
| Koha item type |
BOOK |
