Practical Financial Modelling - Jonathan Swan

Practical Financial Modelling

A Guide to Current Practice

(Autor)

Buch | Softcover
304 Seiten
2008 | 2nd edition
CIMA Publishing (Verlag)
978-0-7506-8647-1 (ISBN)
49,85 inkl. MwSt
zur Neuauflage
  • Titel erscheint in neuer Auflage
  • Artikel merken
Zu diesem Artikel existiert eine Nachauflage
Suitable for finance and management professionals whose work involves the production and development of complex spreadsheets and financial models, this book bridges the gap between the Excel manual and financial literature with practical advise and useful tips.
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.

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.

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.

Erscheint lt. Verlag 22.4.2008
Verlagsort Oxford
Sprache englisch
Maße 165 x 234 mm
Gewicht 590 g
Themenwelt Wirtschaft Allgemeines / Lexika
Wirtschaft Betriebswirtschaft / Management Rechnungswesen / Bilanzen
ISBN-10 0-7506-8647-2 / 0750686472
ISBN-13 978-0-7506-8647-1 / 9780750686471
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich