*** Proof of Product ***
Exploring the Essential Features of “Jonathan Swan – Practical Financial Modelling (2nd Ed.)”
Practical Financial Modelling: A Guide to Current Practice 2nd Edition
by Jonathan Swan (Author)
There is a newer edition of this item:
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.
- 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
Editorial Reviews
Review
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.”
Review
How to get the best out of Excel when preparing financial budgets and financial planning/modelling for your firm
From the Back Cover
Get the best out of Excel when planning, modelling or preparing financial budgets.
This second edition of ‘Practical Financial Modelling’ is a 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 advice and useful tips.
Now includes:
* 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.
Jonathan Swan, Training Director at Operis TRG, London, draws on years of teaching and consultancy experience to identify good practice and to highlight 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 he explores the most effective ways in which problems can be solved. Key themes include: model structure, audit, formulae and functions, and model use.
About the Author
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.
Product details
Publisher : CIMA Publishing; 2nd edition
Language : English
Paperback : 304 pages
Customer reviews
Jared Carollo
Five Stars
Teaches the main tenants of good model design along with some helpful tips.
W Boudville
about using Excel
The financial modelling described here is somewhat misleading. It is really about elementary modelling that can be done within Excel. Swan takes the reader beyond introductory books on Excel, by showing some more elaborate computations possible using the built-in functions to relate cells. So long as you keep this in mind, then the book can be useful. The Excel textbooks tend to assume no prior knowledge of it, and they then typically give an exhaustive coverage of all the features. But in doing do, they rarely go beyond simple examples. Swan assumes you’re fairly well versed in Excel, and so doesn’t waste your time on a lot of introductory material.
But this book is not the place to find instructions in indulging in financial derivatives of any complexity.
Please see the full list of alternative group-buy courses available here: https://lunacourse.com/shop/
Fred Haug - Virtual Wholesaling Simplified