
Practical Financial Modelling
A Guide to Current Practice
- 1st Edition - December 15, 2004
- Imprint: CIMA Publishing
- Author: Jonathan Swan
- Language: English
- eBook ISBN:9 7 8 - 0 - 0 8 - 0 4 5 5 7 2 - 3
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,… Read more

Purchase options

Institutional subscription on ScienceDirect
Request a sales quoteThis 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.
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
* How-to approach, with numerous worked examples
* Explains the techniques and functions of Excel most use in financial modelling and budgeting
Financial professionals whose work 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.
Context: Introduction; Definitions; Descriptions; Common approaches; Structure; Inputs; Workings; Outputs; Variations; Support; Documentation; Navigation; Content: Formulae; Range names; Corkscrews; Masks and switches; Recalculation; Circularities; Functions; Logical; Lookup; Financial; Other; Custom; Quality control: Audit; Audit sheet; Structural checks; Arithmetical checks; Financial checks; Model Use; Grouping; Data validation and Dropdown lists; Conditional and custom formats; Sensitivity analysis; Reporting - Reports, Charting, Printing; Automation; Macros; Appendix; Keyboard shortcuts; References; Further information; index.
- Edition: 1
- Published: December 15, 2004
- Imprint: CIMA Publishing
- No. of pages: 160
- Language: English
- eBook ISBN: 9780080455723
JS
Jonathan Swan
Jonathan Swan's work has encompassed a range of consultancy and development assignments with investment banks and others in the City and throughout Europe. He is currently Director of Training at Operis Group plc, the UK's leading independent financial modelling consultancy.
Affiliations and expertise
Operis TRG Limited, London, UK