Financial modeling: an introductory guide to Excel and VBA applications in finance
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
London
Palgrave Macmillan
[2017]
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | Literaturangaben |
| Beschreibung: | lxiii, 956 Seiten Diagramme |
| ISBN: | 9781137426574 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV044697128 | ||
| 003 | DE-604 | ||
| 005 | 20190121 | ||
| 007 | t | ||
| 008 | 180102s2017 |||| |||| 00||| eng d | ||
| 020 | |a 9781137426574 |c Print |9 978-1-137-42657-4 | ||
| 035 | |a (OCoLC)1024104013 | ||
| 035 | |a (DE-599)BVBBV044697128 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-M347 |a DE-355 |a DE-11 |a DE-521 | ||
| 084 | |a QP 700 |0 (DE-625)141926: |2 rvk | ||
| 084 | |a QP 730 |0 (DE-625)141930: |2 rvk | ||
| 245 | 1 | 0 | |a Financial modeling |b an introductory guide to Excel and VBA applications in finance |
| 264 | 1 | |a London |b Palgrave Macmillan |c [2017] | |
| 300 | |a lxiii, 956 Seiten |b Diagramme | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 500 | |a Literaturangaben | ||
| 650 | 0 | 7 | |a VisualBASIC für Applikationen |0 (DE-588)4341325-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Mathematische Modellierung |0 (DE-588)7651795-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Excel 2016 |0 (DE-588)1078432899 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Finanzmanagement |0 (DE-588)4139075-1 |2 gnd |9 rswk-swf |
| 655 | 7 | |0 (DE-588)4143413-4 |a Aufsatzsammlung |2 gnd-content | |
| 689 | 0 | 0 | |a Finanzmanagement |0 (DE-588)4139075-1 |D s |
| 689 | 0 | 1 | |a Mathematische Modellierung |0 (DE-588)7651795-0 |D s |
| 689 | 0 | 2 | |a Excel 2016 |0 (DE-588)1078432899 |D s |
| 689 | 0 | 3 | |a VisualBASIC für Applikationen |0 (DE-588)4341325-0 |D s |
| 689 | 0 | |5 DE-604 | |
| 700 | 1 | |a Häcker, Joachim |d 1968- |0 (DE-588)120447568 |4 edt |4 aut | |
| 700 | 1 | |a Ernst, Dietmar |d 1968- |0 (DE-588)131883011 |4 edt |4 aut | |
| 776 | 0 | 8 | |i Erscheint auch als |n Online-Ausgabe |z 978-1-137-42658-1 |
| 856 | 4 | 2 | |m Digitalisierung UB Regensburg - ADAM Catalogue Enrichment |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=030093942&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-030093942 | ||
Datensatz im Suchindex
| _version_ | 1804178163956187136 |
|---|---|
| adam_text | Contents
1 Introduction.................................................. 1
1 How Can Managers Assure that the Decision Papers
which They Receive Are Not Already Flawed and Faulty
Decisions Are Reached as a Consequence?................. 1
2 How Can Applied Tasks Be Modeled Clearly and in a
Structured Manner?............................................. 1
3 How Can Macros Be Used in the Modeling Process?.............. 2
4 How Can Financial Modeling Be Used in Applied Work
in Finance?.................................................. 2
5 How to Create Financial Models for Investment and Financing? 3
6 How to Create Financial Models for Corporate Finance? . . . . 3
7 How to Create Financial Models for Portfolio Management? . . 4
8 How to Create Financial Models in the Field of Derivatives? . . 4
9 Who Needs a Deep Understanding of Financial Modeling? ... 5
10 How Can I Demonstrate My Financial Modeling Skills?............ 5
2 Financial Modeling Standards.......................................... 7
1 Executive Summary............................................ 7
2 Introduction, Structure, Learning Outcomes and Case Study . s
3 Foundations of Financial Modeling........................... 10
3.1 What Are Models and What Is Financial Modeling? ... io
3.2 Analyzing the Model Requirements and Defining
a Task List.............................................. 12
3.3 Structuring Financial Models in Modules.................. 14
» »
VII
viii
Contents
4 Current State of Financial Modeling in Theory and
Applied Work.................... ................. 16
4.1 Literature on Financial Modeling................ 16
4.2 Different Approaches - Identical Aims ........... 18
5 Financial Modeling Standards ........................ 23
5.1 Top-10 Financial Modeling Standards ............ 23
5.2 150 Financial Modeling Standards......... 25
6 Implementing the Top-10 Financial Modeling Standards
with Reference to an Example ......................... 36
6.1 Define the Modeling Purpose .................... 37
6.2 Separate the Problem into independent
Subsections (Modules) ......................... 38
6.3 Provide a Graph of the Flow of Data and the
Model Structure ......................... 40
6.4 Separate Inputs from Outputs.................... 43
6.5 Choose a Unified Layout for the Worksheets . ... 44
6.6 Use Unified Formatting . ....................... 46
6.7 Avoid Complex Formulas and Use Only One Type
of Formula ................... .............. 48
6.8 Avoid Circular References ................... 50
6.9 Work with Control Functions........ 50
6.10 Present the Results Professionally ..... ....... 51
7 Summary.............................................. 53
Notes . . ........................................... 55
Further Reading.................................... 56
3 Model Review..................................... 59
1 Executive Summary.................................... 59
2 Introduction, Structure and Learning Outcomes and
Case Study........................................... 60
3 Fundamentals of Model Review............ ............. 61
3.1 The Term “Model Review”......................... 61
3.2 Steps in the Model Review Process . . .......... 63
4 Errors in Financial Models 65
4.1 Qualitative Errors................. ............ 66
4.2 Quantitative Errors............... ......... 66
5 Error Detection - Recognizing and Finding Errors . ... 67
5.1 Logic Inspection................... ............ 67
5.2 Tests........................... 68
Contents ix
5.3 Analysis Tools..................................... 70
6 Examples of Applications of Analysis Tools ............. 71
6.1 Brief Market Overview of Analysis Tools............ 72
6.2 Model Review with Microsoft Excel.................. 75
6.3 Model Review with Operis Analysis Kit (OAK)........ 92
7 Control Calculations........................................... 100
7.1 Control Calculations that Show the Concrete
Numerical Deviation............................... 101
7.2 Binary Control Calculations....................... 102
8 Measures to Assess the Plausibility of the Results............. 105
8.1 Sensitivity Analysis.............................. 105
8.2 Scenario Analysis................................. 106
9 Documentation.................................................. 106
10 Summary........................................................ 107
Notes.......................................................... 110
Further Reading................................................ Ill
4 Workshop Excel Part I.......................................... 113
1 Executive Summary.............................................. 113
2 Introduction, Structure, Learning Outcomes and Case Study . 113
3 Why Study Excel?............................................... 115
4 Developing a Financial Model................................... 117
4.1 Defining the Task List................................... 117
4.2 Identifying the Key Tasks ............................... 119
4.3 Visualizing Abstract Relations with Bubble Charts .... 120
5 Visual Display of a Financial Model............................ 121
5.1 Structuring a Financial Model............................ 121
5.2 Documenting a Financial Model............................ 123
5.3 Structuring Large Financial Models Ergonomically .... 123
5.4 Borders and Lines: Providing Structure to the Data ... 130
5.5 Using Colors to Highlight Important Elements...... 132
6 Side Note: Using Key Combinations and the Ribbon to
Work in Excel.................................................. 134
6.1 Key Combinations and Sequences in Excel.................. 134
6.2 Different Types of Key Combinations in Excel........ 135
7 Summary........................................................ 139
Further Reading................................................ 140
Contents
5 Workshop Excel Part n....................... 143
1 Executive Summary............................. . . . 143
2 Introduction, Structure, Learning Outcomes and Case Study . 143
3 Creating a Prototype in Excel ..................... 145
3.1 The Formula Sheet - The Translator . ............ 145
3.2 Use of Formulas........ . ................... I4g
3.3 Activating Add-ins.......... 151
3 .4 Making Use of Additional Functions . .....՛.. 154
3.5 Using Names to Improve Clarity of the Formulas. 155
3.6 Comments . . ................................... 157
4 Sending Signals to the Management . . ............. 161
4.1 Signaling with Colors: Conditional Formatting to
Create Information ....................... 161
4.2 Text as Signal: Providing Informative Messages ...... 163
5 Data Collection ...................................... 164
5.1 Secure Data Gathering ....................... . 165
5.2 Importing Internal Data ............................. 170
5.3 Importing External Data: Working with Security
Prices from the Internet in Excel.......... . .... 175
6 Analysis Stage: Sensitivity and Scenarios .............. 180
6.1 Sensitivity Analysis Using Data Tables .............. 180
6.2 Scenarios with the Scenario Manager.................. 183
6.3 Goal Seek ........................................ 189
6.4 Solver - Goal Seek for Challenging Tasks . ......... 190
7 Testing the Performance of a Financial Model . . . ... 194
7.1 Formula Auditing: Checking the Flow of Data and
Formulas........ .............................. 195
7.2 Support from Error Checking ......................... 196
7.3 Formula Evaluation: Formula Assessment Step by Step . 197
8 Summary ................................................ 199
Notes................................................... 200
Further Reading. ................. . . ... . . . ... . . . 200
6 Workshop Excel Part in.......................... . . . . . 203
1 Executive Summary.......................... . ..... 203
2 Introduction, Structure, Learning Outcomes and Case Study . 203
3 Presenting Insights and Recommendations . . ........... 205
3.1 Recommendations for the Presentation of Charts .... 206
3.2 Creating Simple Charts in Excel ........... . . . . 210
Contents XI
33 Dynamic Charts .......................................... 211
3.4 Selecting a Suitable Chart............................. 21$
4 Summary...................................................... 234
Further Reading.............................................. 234
7 VBA Workshop.................................................. 237
1 Executive Summary............................................ 237
2 Introduction, Structure and Learning Outcomes................ 238
3 Why Study Programming with VBA? . ........................... 239
4 Generating Excel Software Solutions ......................... 241
4.1 Preparing Excel for Macros............................. 242
4.2 Possibility 1: Creating Applications with the
Macro Recorder.......................................... 246
43 Possibility 2: Programming with VBA.................... 250
5 Variables and the Most Important Data Types.................. 281
5.1 Declaring a Variable................................... 281
5.2 Conventions for Variable Names......................... 285
6 Process Flow Models and Charts............................... 287
6.1 Process Flow Models.................................... 287
6.2 Flowchart.............................................. 287
6.3 Hierarchy Chart ....................................... 288
7 The Most Important Language Elements of VBA.................. 289
7.1 Programming with Branches.............................. 289
7.2 Loops.................................................. 300
73 Programming Cells and Ranges............................. 306
8 Comfortable Input and Output Using Dialogue Fields........... 314
8.1 Reading Data with the InputBox......................... 314
8.2 Data Output with the MsgBox............................ 316
9 Programming Your Own Dialogues .............................. 318
9.1 Steps Needed to Create Your Own Dialogue .............. 319
9.2 Control Elements..................................... 320
10 Creating Charts with VBA..................................... 326
10.1 Information needed and Types of Diagrams............... 326
10.2 Useful Programs for Diagrams........................... 328
11 Tool Kit: Practical Excel Tools for Modeling................. 333
11.1 Programming Headers and Footers........................ 333
11.2 Transferring Comments to a List........................ 335
11.3 Creating a Table of Contents........................... 337
11.4 Protecting Cells with Formulas......................... 338
xii Contents
12 Summary................................................. 340
Further Reading .. .................................... 341
8 Investment Appraisal ......................................... 343
1 Executive Summary ...................................... 343
2 Learning Outcomes, Definitions, Model Structure and
Case Study ............................. ............ 344
3 The Term Investment and Methods of Investment Appraisal. . 346
4 Static Investment Appraisal Methods..................... 348
4.1 Cost Comparison Method............... 350
4.2 Profit Comparison Method. ............................. 354
4.3 Average Rate of Return ......................... . 357
4.4 Static Payback Period Method . .................. 359
4.3 Comparison and Assessment of the Static
Investment Appraisal Methods . ........... 361
5 Dynamic Investment Appraisal Methods ................... 362
5.1 Net Present Value Method.......................... 363
5.2 Internal Rate of Return Method.................... 371
5-3 Annuity Method ...................... 374
5.4 Comparison and Assessment of the Methods of
Dynamic Investment Appraisal ........................... 378
6 Summary ................................................... 382
Literature and Suggestions....... . . ............ 384
9 Financing..................................................... . 385
1 Executive Summary ........................................... 385
2 Learning Outcomes, Definitions, Model Structure and
Case Study................... . ............... ........ 387
3 Fundamental Rules of Financing............... 392
3-1 The Golden Rule for Balance Sheets................. 392
3.2 The Relationship between Equity and Debt and
the Leverage Effect ................................... 395
4 Analysis of Key Figures........... ..................... 400
4.1 Key Return Figures ............................... 401
4.2 Key Figures about Financial Structure....... 402
4.3 Key Figures on the Asset Structure ..................... 404
4.4 Key Figures for the Capital Structure .................. 408
4.5 Key Figures for the Structure of Earnings ·..՛.՛........ 409
4.6 Cash Flow Key Figures................................. 411
Contents xiii
5 The Ordinary Capital Increase................................. 413
5Л Assumptions Concerning the Ordinary Capital Increase 414
5.2 Calculating the Values on the Balance Sheet............. 416
5.3 Calculating the Value of the Subscription Rights.. 420
6 The Long-Term Loan............................................ 422
6.1 Assumptions Concerning the Long-Term Loan............... 423
6.2 The Annuity Loan........................................ 424
6.3 The Amortizable Loan ............................. 429
6.4 The Bullet Loan......................................... 432
6.5 Comparison of the Various Types of Repayment...... 434
7 Bonds......................................................... 437
7.1 Assumptions for the Bond................................ 437
7.2 Analyzing the Bond from the Issuer Perspective.... 442
7.3 Analyzing the Bond from the Investor Perspective .... 449
7.4 Present Value Method for Known Spot Rates............... 453
7.5 Analysis of the Present Value Method.................... 458
7.6 Risk Analysis .......................................... 459
8 Short-Term Financing Using the Example of the Supplier Credit 475
8.1 Interest on the Supplier Credit......................... 476
8.2 Granting a Supplier Credit........................ 478
8.3 Delaying Payment on a Supplier Credit................... 480
9 The Cash Flow................................................. 484
9.1 Basics.................................................. 485
9.2 Calculating the Gross Cash Flow from Operating
Business Activities..................................... 486
9.3 Calculating the Operating Free Cash Flow................ 488
9.4 Calculating the Net Cash Flow........................... 488
9.5 Control Calculations.................................... 489
10 Financing via Shortening of the Capital Commitment Period . 491
10.1 Premises when Shortening the Capital
Commitment Period....................................... 491
10.2 Reducing Receivables.................................... 492
10.3 Inventory Reductions................................... 494
11 Summary....................................................... 497
Notes......................................................... 499
Literature and Suggestions for Further Reading................ 500
10 Corporate Finance Part I...................................... 501
1 Executive Summary............................................. 501
XIV
Contents
2 Introduction, Structure, Learning Outcomes and Case Study .
3 Overview of the Methods of Company Valuation ... . . . . . .
4 Company Valuation Using Discounted Cash Flow Models . . .
4.1 Basics of Corporate Planning ...................
4.2 WACC Approach ................................
4.3 Period-Specific WACC Approach............
4.4 APV Approach .................................... .
4.5 Equity Approach . . ...............................
4.6 Sensitivity Analysis . .. . .........
4.7 Scenario Analysis........
4.8 Company Valuation for Professionals ............
5 Summary...................................
Notes..............................................
Literature and Suggestions .............
504
511
513
514
546
578
582
590
597
600
605
618
620
621
11 Corporate Finance Part II .............................
1 Executive Summary .....................................
2 Introduction, Structure, Learning Outcomes and Case Study .
3 Company valuation Using Market Capitalization and
Book Value.................................... ...
31 Overview of Market Capitalization......................
3.2 Overview of Book Value......................... . . .
3.3 Valuation Process with Market Capitalization and
Book Value ........................................
4 Trading Multiples..................................
4.1 Overview of Trading Multiples.......................
4.2 Valuation Process with Trading Multiples............
5 Transaction Multiples.....................................
5.1 Overview of Transaction Multiples . . . ............
5.2 Comparison of Trading Multiples and Transaction
Multiples..........................................
5.3 Valuation Process with Transaction Multiples........
5.4 The Football Field Graph ...........
6 Summary ...................................................
Notes.................................................. . . .
Literature and Suggestions .....................
12 Portfolio Management Part I ........... .....................
1 Executive Summary...............
2 Introduction, Structure, Learning Outcomes and Case Study .
623
623
626
629
629
630
631
634
634
634
650
650
650
652
665
674
676
677
679
679
680
Contents
XV
3 Portfolio Management.......................................... 682
4 Return........................................................ 683
4.1 Discrete Return......................................... 684
4.2 Continuous Return....................................... 697
4.3 Comparison between Continuous and Discrete Return . 699
4.4 Returns for Different Time Periods ..................... 701
4.5 Calculation of Prices based on the Different
Types of Returns........................................ 705
5 Risk.......................................................... 706
5.1 The Term Risk........................................... 706
5.2 How to Estimate Risk.................................... 707
5.3 Categories of Risk...................................... 715
5.4 Volatility.............................................. 717
5.5 Variance................................................ 727
5.6 Standard Deviation ..................................... 728
5.7 Risk Measures for Different Time Periods................ 730
5.8 Moving Volatility....................................... 731
5.9 Covariance.............................................. 733
5.10 Coefficient of Correlation.............................. 736
5.11 Semi-variance........................................... 739
5.12 Value at Risk........................................... 742
5.13 Beta Factor............................................. 745
6 Summary....................................................... 750
Notes......................................................... 753
Literature and Suggestions for Further Reading................ 753
13 Portfolio Management.......................................... 755
1 Executive Summary........................................... 755
2 Introduction, Structure, Learning Outcomes and Case Study . 756
3 Overview of Active and Passive Portfolio Management........... 758
3.1 Introduction to the Topic............................... 758
3.2 Solving Optimization Problems with the Excel Solver. . 760
3.3 Matrix Operations in Excel.............................. 764
4 Active Portfolio Management................................... 769
4.1 Absolute Optimization................................... 770
4.2 Relative Optimization................................. 794
5 Passive Portfolio Management.................................. 811
5.1 Quadratic Optimization ................................. 815
5.2 Constrained Regression.................................. 825
xvi
Contents
5.3 Linear Optimization . . . ......... . . . ........ 828
5.4 Summary of the Results for Passive Portfolio Management 836
6 Summary ............................................... 836
Notes . ................................................ 838
Literature and Suggestions for Further Reading........... 838
14 Derivatives......... ................................................ 841
1 Executive Summary ...................................... 841
2 Introduction, Structure, Learning Outcomes and Case study . 843
3 Options Basics ............................................... 848
3.1 Terminology and Types of Options................... 848
3.2 Differentiating Features of Options................ 850
3.3 What are the Value Drivers in Option Pricing?..... 855
4 Option Pricing ............................................... 864
4 .1 Basics of Option Pricing ....................... 864
4.2 Models for Determining the Option Price........... 868
5 What Is Involved in the Four Basic Option Strategies?.... 907
5.1 Long Call . ...... ... ........................... 908
5.2 Short Call ....................................... 910
5.3 Long Put............ . ............. ............. 913
5.4 Short Put............................................ 91$
6 Fundamentals of Futures . ............. . . . ............ 917
6.1 Wliat Are Futures? ............................... 917
6.2 Which Futures Contracts Are Essential in Applied Work? 919
7 Pricing of Futures Contracts............................ 923
7.1 Index Futures . . ................................. 924
7.2 Interest Rate Futures . . .......................... 926
7.3 Currency Futures ................................. 928
7.4 Commodity Futures .................................. 929
7.5 Futures on Single Stocks . . . . ................. . 932
8 What is involved in the Basic Futures Strategies? ...... 932
8.1 Long Futures........................................... 933
8.2 Short Futures ......................................... 934
8.3 Spreads................................................. 935
9 Conclusions and Outlook.............. 936
10 Summary................... 9 37
Notes...................................... 942
Literature and Suggestions................................. 943
Index............................................................. 945
|
| any_adam_object | 1 |
| author | Häcker, Joachim 1968- Ernst, Dietmar 1968- |
| author2 | Häcker, Joachim 1968- Ernst, Dietmar 1968- |
| author2_role | edt edt |
| author2_variant | j h jh d e de |
| author_GND | (DE-588)120447568 (DE-588)131883011 |
| author_facet | Häcker, Joachim 1968- Ernst, Dietmar 1968- Häcker, Joachim 1968- Ernst, Dietmar 1968- |
| author_role | aut aut |
| author_sort | Häcker, Joachim 1968- |
| author_variant | j h jh d e de |
| building | Verbundindex |
| bvnumber | BV044697128 |
| classification_rvk | QP 700 QP 730 |
| ctrlnum | (OCoLC)1024104013 (DE-599)BVBBV044697128 |
| discipline | Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01959nam a2200445 c 4500</leader><controlfield tag="001">BV044697128</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20190121 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">180102s2017 |||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781137426574</subfield><subfield code="c">Print</subfield><subfield code="9">978-1-137-42657-4</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1024104013</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV044697128</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-M347</subfield><subfield code="a">DE-355</subfield><subfield code="a">DE-11</subfield><subfield code="a">DE-521</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QP 700</subfield><subfield code="0">(DE-625)141926:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QP 730</subfield><subfield code="0">(DE-625)141930:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Financial modeling</subfield><subfield code="b">an introductory guide to Excel and VBA applications in finance</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">London</subfield><subfield code="b">Palgrave Macmillan</subfield><subfield code="c">[2017]</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">lxiii, 956 Seiten</subfield><subfield code="b">Diagramme</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Literaturangaben</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">VisualBASIC für Applikationen</subfield><subfield code="0">(DE-588)4341325-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Mathematische Modellierung</subfield><subfield code="0">(DE-588)7651795-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Excel 2016</subfield><subfield code="0">(DE-588)1078432899</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Finanzmanagement</subfield><subfield code="0">(DE-588)4139075-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="0">(DE-588)4143413-4</subfield><subfield code="a">Aufsatzsammlung</subfield><subfield code="2">gnd-content</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Finanzmanagement</subfield><subfield code="0">(DE-588)4139075-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Mathematische Modellierung</subfield><subfield code="0">(DE-588)7651795-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">Excel 2016</subfield><subfield code="0">(DE-588)1078432899</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="3"><subfield code="a">VisualBASIC für Applikationen</subfield><subfield code="0">(DE-588)4341325-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Häcker, Joachim</subfield><subfield code="d">1968-</subfield><subfield code="0">(DE-588)120447568</subfield><subfield code="4">edt</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Ernst, Dietmar</subfield><subfield code="d">1968-</subfield><subfield code="0">(DE-588)131883011</subfield><subfield code="4">edt</subfield><subfield code="4">aut</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Online-Ausgabe</subfield><subfield code="z">978-1-137-42658-1</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Regensburg - ADAM Catalogue Enrichment</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=030093942&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-030093942</subfield></datafield></record></collection> |
| genre | (DE-588)4143413-4 Aufsatzsammlung gnd-content |
| genre_facet | Aufsatzsammlung |
| id | DE-604.BV044697128 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T07:59:37Z |
| institution | BVB |
| isbn | 9781137426574 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-030093942 |
| oclc_num | 1024104013 |
| open_access_boolean | |
| owner | DE-M347 DE-355 DE-BY-UBR DE-11 DE-521 |
| owner_facet | DE-M347 DE-355 DE-BY-UBR DE-11 DE-521 |
| physical | lxiii, 956 Seiten Diagramme |
| publishDate | 2017 |
| publishDateSearch | 2017 |
| publishDateSort | 2017 |
| publisher | Palgrave Macmillan |
| record_format | marc |
| spelling | Financial modeling an introductory guide to Excel and VBA applications in finance London Palgrave Macmillan [2017] lxiii, 956 Seiten Diagramme txt rdacontent n rdamedia nc rdacarrier Literaturangaben VisualBASIC für Applikationen (DE-588)4341325-0 gnd rswk-swf Mathematische Modellierung (DE-588)7651795-0 gnd rswk-swf Excel 2016 (DE-588)1078432899 gnd rswk-swf Finanzmanagement (DE-588)4139075-1 gnd rswk-swf (DE-588)4143413-4 Aufsatzsammlung gnd-content Finanzmanagement (DE-588)4139075-1 s Mathematische Modellierung (DE-588)7651795-0 s Excel 2016 (DE-588)1078432899 s VisualBASIC für Applikationen (DE-588)4341325-0 s DE-604 Häcker, Joachim 1968- (DE-588)120447568 edt aut Ernst, Dietmar 1968- (DE-588)131883011 edt aut Erscheint auch als Online-Ausgabe 978-1-137-42658-1 Digitalisierung UB Regensburg - ADAM Catalogue Enrichment application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=030093942&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Häcker, Joachim 1968- Ernst, Dietmar 1968- Financial modeling an introductory guide to Excel and VBA applications in finance VisualBASIC für Applikationen (DE-588)4341325-0 gnd Mathematische Modellierung (DE-588)7651795-0 gnd Excel 2016 (DE-588)1078432899 gnd Finanzmanagement (DE-588)4139075-1 gnd |
| subject_GND | (DE-588)4341325-0 (DE-588)7651795-0 (DE-588)1078432899 (DE-588)4139075-1 (DE-588)4143413-4 |
| title | Financial modeling an introductory guide to Excel and VBA applications in finance |
| title_auth | Financial modeling an introductory guide to Excel and VBA applications in finance |
| title_exact_search | Financial modeling an introductory guide to Excel and VBA applications in finance |
| title_full | Financial modeling an introductory guide to Excel and VBA applications in finance |
| title_fullStr | Financial modeling an introductory guide to Excel and VBA applications in finance |
| title_full_unstemmed | Financial modeling an introductory guide to Excel and VBA applications in finance |
| title_short | Financial modeling |
| title_sort | financial modeling an introductory guide to excel and vba applications in finance |
| title_sub | an introductory guide to Excel and VBA applications in finance |
| topic | VisualBASIC für Applikationen (DE-588)4341325-0 gnd Mathematische Modellierung (DE-588)7651795-0 gnd Excel 2016 (DE-588)1078432899 gnd Finanzmanagement (DE-588)4139075-1 gnd |
| topic_facet | VisualBASIC für Applikationen Mathematische Modellierung Excel 2016 Finanzmanagement Aufsatzsammlung |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=030093942&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT hackerjoachim financialmodelinganintroductoryguidetoexcelandvbaapplicationsinfinance AT ernstdietmar financialmodelinganintroductoryguidetoexcelandvbaapplicationsinfinance |