Practical Financial Modelling: A Guide to Current Practice (CIMA Professional Handbook) - Softcover

Swan, Jonathan

Softcover

ISBN 10: 0750663561 ISBN 13: 9780750663564

Publisher: CIMA Publishing, 2005

Synopsis

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

About this title

About the Author

Following a career in the Army the author has been teaching spreadsheet applications in the City of London since 1991. His work has encompassed a range of consultancy and development assignments working with investment banks and others in the City and throughout Europe. For the past five years he has been working at Operis Group plc, the UK's leading independent financial modelling consultancy, where he is director of the training division of the company. Operis teach the fundamentals of financial modelling to over a thousand professionals each year, from backgrounds that include banking, accountancy, financial analysis, and management. With the rest of the company working on major modelling projects in the PFI/PPP sector and elsewhere, their training is based on the latest practice in the industry.

From the Back Cover

Practical Financial Modelling is for all finance and management professionals whose work involves the development or use of complex spreadsheets and financial models.

This book offers a refreshingly simple approach to building and using financial models. Most models in use today are as unique as the individuals who create them, and becuase of this they can be difficult to understanf or use with confidence. This book offers a critical insight into current practice and presents a clear and robust modelling methodology with the specific aim of reducing unnecessary complexity in favour of a simpler and more reliable approach, which will be of interest to both experienced and novice modellers. This methodology has been used for some of the most modelling intensive transactions in the world, but is also equally applicably to reader creating simple cash flow forecasts.

Practical Financial Modelling bridges the gap between the Excel manual and the finance textbook. The principle is that once prople have the ability to structure a model, they have a better starting point from which to address the financial calculations. Quality control is built in from the outset. The key themes of the book are model structure, audit, formulae & functions, and model use, using basic Excel functionality throughout.

The author draws on years of teaching and consultancy to identify the elements of good practice and to highlight those areas and techniques which are prone to error and inconsistency. He explores the different ways in which problems can be solved by using practical worked examples. The reader can adapt the ideas and techniques for their own purposes.

Edition details

• Publisher: CIMA Publishing
• Publication date: 2005
• Language: English
• ISBN 10: 0750663561
• ISBN 13: 9780750663564
• Binding: Paperback
• Number of pages: 160