Practical Financial Modelling (eBook)

A Guide to Current Practice

Jonathan Swan (Autor)

eBook Download: EPUB

2009 | 2. Auflage
304 Seiten
Elsevier Science (Verlag)
978-0-08-057011-2 (ISBN)

Infos

This second edition of Practical Financial Modelling is vital tool for all finance and management professionals whose work involves the production and development of complex spreadsheets and financial models. The author bridges the gap between the Excel manual and financial literature with a wealth of practical advise and useful tips.

The book identifies good practice and highlights those areas which are prone to error and inconsistency resulting in a refreshingly simple approach to building and using financial models suitable for novice and experienced modellers. By using practical worked examples the most effective ways in which problems can be solved are explored. Key themes include: model structure, audit formulae and functions and model use.

New to the second edition:

Instructive information on Excel 2007 and its enhanced modelling functions and feature, Risk controls in developing and using financial models, Test-yourself modelling problems and applied examples in every chapter, Substantial information related to reporting and charting techniques and an appendix devoted to parallel comparison of how-to in Excel 2003 and 2007.

. Instructive information on Excel 2007 and its enhanced modelling functions and features
. Risk controls in developing and using financial models
. Test-yourself modelling problems and applied examples in every chapter
. Substantial information relating to reporting and charting techniques
. An appendix devoted to a parallel comparison of how-to in Excel 2003 and Excel 2007

Inhalt

Front Cover 1
Practical Financial Modelling: A Guide to Current Practice 4
Copyright Page 5
Contents 8
Preface to the First Edition 12
Preface to the Second Edition 14
About the Author 16
Introduction 18
Chapter 1. Model Structure 30
Introduction 30
Risk assessment and risk controls 31
The model developer 33
Two approaches 34
Purpose 35
Structure 36
Workbook structure 39
Inputs 40
Workings 41
Outputs 43
Variations 45
Documentation 47
Reporting 50
Reports 55
Model development 56
Navigation 61
Exercises 66
Chapter 2. Quality Control 68
Introduction 68
Taxonomies of error 69
Audit tools 72
Error values 76
Audit sheet 80
Structural checks 82
Arithmetical checks 95
Financial checks 97
Model map 102
Excel 2007 workbook tests 104
Third party model audit tools 105
Exercises 105
Chapter 3. Mainly Formulas 108
Introduction 108
Range names 109
Define names 116
Additional name functionality 127
BODMAS or PEMDAS 141
Timing 141
Changing time periods 148
Circularities and iteration 152
Coercion 164
Array formulas 165
R1C1 168
Exercises 169
Chapter 4. Mainly Functions 172
Introduction 172
Logical 173
Revolving credit and the cash cascade 183
Lookup 186
Financial 198
Dates 201
Other useful functions 203
Exercises 208
Chapter 5. Model Use 210
Introduction 210
Risk controls 211
Grouping and outlining 211
Data inputs 214
Conditional formatting 220
Custom formatting 227
Protection 234
Charting 238
Exercises 240
Chapter 6. Sensitivity Analysis and Scenarios 242
Introduction 242
Best practice 243
Goal Seek 244
Data tables 245
Scenarios 248
Solver 260
Risk 260
Monte Carlo simulation 262
Exercises 263
Chapter 7. Automation 266
Introduction 266
Macro security settings 267
Recorded macros 268
Iteration macro 269
Assigning macros 273
Written macros 276
Branching macros 278
Quarterly/annual macro 280
Error handling 281
User-defined functions 282
Deleting macros 285
Exercises 286
Appendix 1: Keyboard Shortcuts 288
Appendix 2: Good Modelling Practice 292
Appendix 3: Case Study 298
Index 300

Produkt-Details

• Erscheint lt. Verlag: 1.12.2009
• Sprache: englisch
• Themenwelt: Sachbuch/Ratgeber
• Themenwelt: Recht / Steuern ► Wirtschaftsrecht
• Themenwelt: Wirtschaft ► Betriebswirtschaft / Management ► Rechnungswesen / Bilanzen
• ISBN-10: 0-08-057011-9 / 0080570119
• ISBN-13: 978-0-08-057011-2 / 9780080570112