Financial Modelling in Practice: A Concise Guide for
Intermediate and Advanced Level is a practical, comprehensive
and in-depth guide to financial modelling designed to cover the
modelling issues that are relevant to facilitate the construction
of robust and readily understandable models.
Based on the authors extensive experience of building models in
business and finance, and of training others how to do so this book
starts with a review of Excel functions that are generally most
relevant for building intermediate and advanced level models (such
as Lookup functions, database and statistical functions and so
on). It then discusses the principles involved in designing,
structuring and building relevant, accurate and readily
understandable models (including the use of sensitivity analysis
techniques) before covering key application areas, such as the
modelling of financial statements, of cash flow valuation, risk
analysis, options and real options. Finally, the topic of financial
modelling using VBA is treated. Practical examples are used
throughout and model examples are included in the attached
CD-ROM.
Aimed at intermediate and advanced level modellers in Excel who
wish to extend and consolidate their knowledge, this book is
focused, practical, and application-driven, facilitating knowledge
to build or audit a much wider range of financial models.
Note: CD-ROM/DVD and other supplementary materials are
not included as part of eBook file.
Autorentext
Michael Rees gained a BA with First Class Honours and a Doctorate in Mathematics from Oxford University in 1985 and 1988 respectively. In 1992 he gained an MBA with Distinction from INSEAD, and in 2003 graduated in first position on the Certificate in Quantitative Finance program, also winning the Wilmott award.
Since 2002 Michael has worked independently as a consultant and trainer in financial modelling. Prior to this he worked as a strategy consultant with Braxton Associates and Mercer Management Consulting, and also as an analyst at J.P. Morgan.
Michael lives in Richmond, UK. He was born in Canada, has lived in several countries, and is fluent in French and German.
Klappentext
Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level is a practical, comprehensive and in-depth guide to financial modelling designed to cover the modelling issues that are relevant to facilitate the construction of robust and readily understandable models.
Based on the authors extensive experience of building models in business and finance, and of training others how to do so this book starts with a review of Excel functions that are generally most relevant for building intermediate and advanced level models (such as Lookup functions, database and statistical functions and so on). It then discusses the principles involved in designing, structuring and building relevant, accurate and readily understandable models (including the use of sensitivity analysis techniques) before covering key application areas, such as the modelling of financial statements, of cash flow valuation, risk analysis, options and real options. Finally, the topic of financial modelling using VBA is treated. Practical examples are used throughout and model examples are included in the attached CD-ROM.
Aimed at intermediate and advanced level modellers in Excel who wish to extend and consolidate their knowledge, this book is focused, practical, and application-driven, facilitating knowledge to build or audit a much wider range of financial models.
"An excellent book which presents advanced financial modelling tools and simulations, and applies them to modern aspects of financial management. As a renowned expert in modelling, Michael Rees develops efficient techniques for simulation and sensitivity analysis within an Excel and Excel add-on framework using many useful and transparent applications in the context of company valuation, derivative business and risk management, enabling the reader to develop good models themselves. A unique book which is highly instructive and motivating."
Professor Dr Dieter Gramlich, University of Cooperative Education, Heidenheim, Germany
"Mike Rees's book fills an important gap in the literature on how to model financial data. It not only provides a whole host of useful suggestions on how to design, structure, build and analyse models; including tips on how use some of the more advanced functionality in Excel, but also in a clear and concise way explains how to include uncertainty in to these models. During the last few years many business's environment have changed, creating the need to explicitly include uncertainty into their decision making rather than hide behind simple (and often flawed) assumptions of what the future may hold. Mike clearly understands the importance of this area and includes several sections which provide an excellent introduction to anyone starting to apply these types of techniques in their financial models for the first time. It is the combination of best practice modelling techniques, plenty of examples and the basics of some of the more advanced approaches that make this book a useful addition to anyone building financial models."
Andrea Dickens, Decision Analysis Group Leader, Finance Excellence Unilever
Inhalt
Background, Objectives and Approach xv
About the Author xix
Acknowledgements xxi
1 Building Blocks: Selected Excel Functions and Tools 1
Core Functions for Financial Modelling 1
Arithmetic Operations 1
Logical Operations 3
Financial Calculations 6
Database Functions, Features and Pivot Tables 12
Statistical Functions 16
Lookup and Reference Functions 20
Text Functions 29
Information Functions 33
Array Functions, Formulae and Matrix Calculations 35
GoalSeek and Solver 40
The Analysis ToolPak and Other Add-ins 43
The Analysis ToolPak 44
Selected Excel Short-cuts 47
2 Principles of Modelling 49
What is a Good Model? 49
Model Design 50
Selection of Model Variables and their Dependencies 50
Hyper Sensitivity to a Variable 55
Level of Detail or Aggregation 55
Model Structure and Planning 60
Logical Flow 60
Compactness 62
Named Ranges 64
Circular References 69
Model Building 74
Formatting and Comments 74
Creating Robust Formulae 78
Results Presentation and Other Uses of Sensitivity Analysis 85
General Remarks on Presentation 86
Using Data Tables to Conduct Sensitivity Analysis 86
Hiding and Protecting Models 92
Model Auditing 94
3 Financial Statement, Cash Flow and Valuation Modelling 99
Financial Statement Modelling: Core Points and Example 99
General Comments 100
Income Statement Forecasting 102
Balance Sheet Forecasting 107
Cash Flow Statement Forecasting 110
Error Checks and Feasibility Checks 111
General Error Checking Tools 111
Feasibility Checking and Ratio Analysis 113
Adding Generality 116
Cash Flow Valuation 120
Calculation of Free Cash Flow 121
Discounting Free Cash Flow 121
Terminal Value Calculations 124
Further Adjustments 128
Sensitivity Analysis 129
4 Risk Modelling 133
Benefits and Challenges of Risk Modelling 133
The Risk Modelling Process 135
An Introduction to Simulation Techniques 136
The Language of Probability Distributions 137
Quick Guide to using @RISK 142
Types of Dependency Relationships in Risk Models 144
The Selection and Use of Distributions 147…