Practical Financial Modelling - 2nd Edition - ISBN: 9780750686471, 9780080570112

Practical Financial Modelling

2nd Edition

A Guide to Current Practice

Authors: Jonathan Swan Jonathan Swan
eBook ISBN: 9780080570112
Paperback ISBN: 9780750686471
Imprint: CIMA Publishing
Published Date: 22nd April 2008
Page Count: 304
Tax/VAT will be calculated at check-out Price includes VAT (GST)
30% off
30% off
30% off
30% off
30% off
20% off
20% off
30% off
30% off
30% off
30% off
30% off
20% off
20% off
30% off
30% off
30% off
30% off
30% off
20% off
20% off
30% off
30% off
30% off
30% off
30% off
20% off
20% off
42.95
30.07
30.07
30.07
30.07
30.07
34.36
34.36
54.95
38.47
38.47
38.47
38.47
38.47
43.96
43.96
56.95
39.87
39.87
39.87
39.87
39.87
45.56
45.56
33.99
23.79
23.79
23.79
23.79
23.79
27.19
27.19
Unavailable
Price includes VAT (GST)
DRM-Free

Easy - Download and start reading immediately. There’s no activation process to access eBooks; all eBooks are fully searchable, and enabled for copying, pasting, and printing.

Flexible - Read on multiple operating systems and devices. Easily read eBooks on smart phones, computers, or any eBook readers, including Kindle.

Open - Buy once, receive and download all available eBook formats, including PDF, EPUB, and Mobi (for Kindle).

Institutional Access

Secure Checkout

Personal information is secured with SSL technology.

Free Shipping

Free global shipping
No minimum order.

Description

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.

Key Features

• 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

Readership

Management Accountants

Table of Contents

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.

Details

No. of pages:
304
Language:
English
Copyright:
© CIMA Publishing 2008
Published:
Imprint:
CIMA Publishing
eBook ISBN:
9780080570112
Paperback ISBN:
9780750686471

About the Author

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

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

Reviews

Five Star Reviews from Amazon.co.uk (all five stars): "I attended one of Jonathan's courses recently and commented at the time that it was rather like the spreadsheet equivalent of going from an ordinary car to driving an F1 car! I have now read through his book and I can only say that this is a superb publication. It sets out how to do advanced spreadsheet modelling far better than anything else I have come across." "This guide consists of 163 pages of text along with a CD containing Excel-based demonstration material...It offers detailed advice on preparing financial models using Excel spreadsheets, which is likely to be of use to both practitioners and students of practical financial modelling....Although there are many guides to Excel on the market, this one is distinguished by its emphasis on how to use the program for management accounting. Even the most experienced modeller will learn something from this resource."