Practical Financial Modelling -  Jonathan Swan

Practical Financial Modelling (eBook)

A Guide to Current Practice
eBook Download: PDF
2004 | 1. Auflage
160 Seiten
Elsevier Science (Verlag)
978-0-08-045572-3 (ISBN)
Systemvoraussetzungen
38,51 inkl. MwSt
  • Download sofort lieferbar
  • Zahlungsarten anzeigen
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

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

PDFPDF (Adobe DRM)

Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM

Dateiformat: PDF (Portable Document Format)
Mit einem festen Seiten­layout eignet sich die PDF besonders für Fach­bücher mit Spalten, Tabellen und Abbild­ungen. Eine PDF kann auf fast allen Geräten ange­zeigt werden, ist aber für kleine Displays (Smart­phone, eReader) nur einge­schränkt geeignet.

Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine Adobe-ID und die Software Adobe Digital Editions (kostenlos). Von der Benutzung der OverDrive Media Console raten wir Ihnen ab. Erfahrungsgemäß treten hier gehäuft Probleme mit dem Adobe DRM auf.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine Adobe-ID sowie eine kostenlose App.
Geräteliste und zusätzliche Hinweise

Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.

Mehr entdecken
aus dem Bereich
Ideen und Erfolgskonzepte für die Praxis

von Marcel Seidel; Svend Reuse

eBook Download (2023)
Springer Fachmedien Wiesbaden (Verlag)
46,99
Keith Cheeseman Reveals the True Story of Britain's Biggest Ever …

von Keith Cheeseman; Clifford Thurlow

eBook Download (2024)
Icon Books Ltd (Verlag)
24,00