Practical Financial Modelling (eBook)

A Guide to Current Practice

Jonathan Swan (Autor)

eBook Download: PDF

2004 | 1. Auflage
160 Seiten
Elsevier Science (Verlag)
978-0-08-045572-3 (ISBN)

Infos

This book is for all financial professionals whose work, to a greater or lesser degree, involves complex spreadsheets and financial models. This includes investment bankers, commercial banks, accountancy firms, property firms, public sector including local government and healthcare, PFI/PPP enterprises, financial managers and financially literate general managers. Junior/middle management, where the focus would be on cash flow forecasting and budgeting tasks, will also find this book of value.

For the vast majority of people involved in this subject, financial modelling is an activity, a task requiring skills. Once people have the ability to structure the model, they have a better starting point from which to address the financial problems. This new book proposal intends to offer that starting point.

Theory is limited to the absolute essentials that aid understanding, thus the focus with this new book is very practical - this is how-to-do-it, showing best practice, and is illustrated with many practical worked examples.

* Practical financial modelling- all the essentials in one book
* How-to approach, with numerous worked examples
* Explains the techniques and functions of Excel most use in financial modelling and budgeting

---

This book is for all financial professionals whose work, to a greater or lesser degree, involves complex spreadsheets and financial models. This includes investment bankers, commercial banks, accountancy firms, property firms, public sector including local government and healthcare, PFI/PPP enterprises, financial managers and financially literate general managers. Junior/middle management, where the focus would be on cash flow forecasting and budgeting tasks, will also find this book of value.For the vast majority of people involved in this subject, financial modelling is an activity, a task requiring skills. Once people have the ability to structure the model, they have a better starting point from which to address the financial problems. This new book proposal intends to offer that starting point.Theory is limited to the absolute essentials that aid understanding; thus the focus with this new book is very practical - this is "e;how-to-do-it"e;, showing best practice, and is illustrated with many practical worked examples.* Practical financial modelling- all the essentials in one book* How-to approach, with numerous worked examples* Explains the techniques and functions of Excel most use in financial modelling and budgeting

Inhalt

Cover 1
Contents 7
Preface 9
About the Author 10
Context 11
1 Model structure 19
Introduction 19
Two approaches 19
Purpose 21
Structure 21
Workbook structure 21
Inputs 22
Workings 23
Outputs 25
Variations 27
Documentation 28
Reporting 31
Reports 34
Model development 35
Navigation 38
2 Quality control 44
Introduction 44
Taxonomies of error 44
Audit tools 46
Error values 48
Audit sheet 50
Structural checks 52
Arithmetical checks 60
Financial checks 61
Model map 64
3 Mainly formulae 66
Introduction 66
Range names 67
Additional name functionality 78
BODMAS 89
Timing 89
Changing time periods 94
Circularities and iteration 97
Array formulae 106
Coercion 107
4 Mainly functions 108
Introduction 108
Logical 108
Lookup 117
Financial 127
Dates 129
Other useful functions 131
5 Model use 135
Introduction 135
Grouping and outlining 135
Data inputs 137
Conditional formatting 141
Custom formatting 144
Protection 149
6 Sensitivity analysis and scenarios 153
Introduction 153
Goal Seek 153
Data tables 154
Scenarios 156
Solver 165
Risk 165
Monte Carlo simulation 166
7 Automation 169
Introduction 169
Recorded macros 170
Iteration macro 171
Assigning macros 173
Written macros 175
Branching macros 176
Quarterly/annual macro 178
Error handling 178
User-defined functions 179
Appendix: Keyboard shortcuts 183
Index 188

Produkt-Details

• Erscheint lt. Verlag: 15.12.2004
• Sprache: englisch
• Themenwelt: Sachbuch/Ratgeber
• Themenwelt: Recht / Steuern ► Wirtschaftsrecht
• Themenwelt: Technik ► Architektur
• Themenwelt: Wirtschaft ► Betriebswirtschaft / Management ► Finanzierung
• Themenwelt: Wirtschaft ► Betriebswirtschaft / Management ► Rechnungswesen / Bilanzen
• Themenwelt: Betriebswirtschaft / Management ► Spezielle Betriebswirtschaftslehre ► Bankbetriebslehre
• ISBN-10: 0-08-045572-7 / 0080455727
• ISBN-13: 978-0-08-045572-3 / 9780080455723