書籍詳細

書籍詳細




洋書

金融モデリングの原理

Principles of Financial Modelling : Model Design and Best Practices Using Excel and VBA

(Wiley Finance)

Rees, Michael

Wiley 2018/05
520 p. 24 cm   
装丁: Hrd    装丁について
テキストの言語: ENG    出版国: US
ISBN: 9781118904015
KCN: 1024222083
紀伊國屋書店 選定タイトル
標準価格:¥14,740(本体 ¥13,400)   
Web販売価格あり    Web販売価格について

為替レートの変動や出版社の都合によって、価格が変動する場合がございます。

この商品は提携先の海外出版社在庫からの取り寄せとなります。品切れの場合、恐れ入りますがご了承下さい。

納期について
DDC: 332
KDC: E210 金融理論
ご購入を希望される方は、
下のリンクをクリックしてください。

Annotation

Based on rigorously-tested materials created for consulting projects and for training courses, this book demonstrates how to plan, design and build financial models that are flexible, robust, transparent, and highly applicable to a wide range of planning, forecasting and decision-support contexts.

Full Description

The comprehensive, broadly-applicable, real-world guide to financial modelling Financial Modelling in Practice, Second Edition covers the full spectrum of financial modelling tools and techniques to provide practical skills grounded in real-world scenarios.
Detailed information

Table of Contents

Preface xxv About the Author xxvii About the Website xxix PART ONE Introduction to Modelling, Core Themes and Best Practices 1 CHAPTER 1 Models of Models 3 CHAPTER 2 Using Models in Decision Support 7 CHAPTER 3 Core Competencies and Best Practices: Meta-themes 15 PART TWO Model Design and Planning 23 CHAPTER 4 Defining Sensitivity and Flexibility Requirements 25 CHAPTER 5 Database Versus Formulae-driven Approaches 37 CHAPTER 6 Designing the Workbook Structure 47 PART THREE Model Building, Testing and Auditing 57 CHAPTER 7 Creating Transparency: Formula Structure, Flow and Format 59 CHAPTER 8 Building Robust and Transparent Formulae 79 CHAPTER 9 Choosing Excel Functions for Transparency, Flexibility and Efficiency 105 CHAPTER 10 Dealing with Circularity 117 CHAPTER 11 Model Review, Auditing and Validation 143 PART FOUR Sensitivity and Scenario Analysis, Simulation and Optimisation 153 CHAPTER 12 Sensitivity and Scenario Analysis: Core Techniques 155 CHAPTER 13 Using GoalSeek and Solver 163 CHAPTER 14 Using VBA Macros to Conduct Sensitivity and Scenario Analyses 171 CHAPTER 15 Introduction to Simulation and Optimisation 177 CHAPTER 16 The Modelling of Risk and Uncertainty, and Using Simulation 187 PART FIVE Excel Functions and Functionality 199 CHAPTER 17 Core Arithmetic and Logical Functions 201 CHAPTER 18 Array Functions and Formulae 217 CHAPTER 19 Mathematical Functions 229 CHAPTER 20 Financial Functions 243 CHAPTER 21 Statistical Functions 257 CHAPTER 22 Information Functions 299 CHAPTER 23 Date and Time Functions 307 CHAPTER 24 Text Functions and Functionality 313 CHAPTER 25 Lookup and Reference Functions 325 CHAPTER 26 Filters, Database Functions and PivotTables 355 CHAPTER 27 Selected Short-cuts and Other Features 387 PART SIX Foundations of VBA and Macros 395 CHAPTER 28 Getting Started 397 CHAPTER 29 Working with Objects and Ranges 413 CHAPTER 30 Controlling Execution 425 CHAPTER 31 Writing Robust Code 441 CHAPTER 32 Manipulation and Analysis of Data Sets with VBA 455 CHAPTER 33 User-defined Functions 473 Index 493

Subject:Microsoft Office.