Practical Financial Modelling: The Development And Audit Of Cash Flow Models by Jonathan SwanPractical Financial Modelling: The Development And Audit Of Cash Flow Models by Jonathan Swan

Practical Financial Modelling: The Development And Audit Of Cash Flow Models

byJonathan SwanEditorJonathan Swan

Paperback | August 21, 2015

Pricing and Purchase Info


Earn 450 plum® points

Prices and offers may vary in store

Out of stock online

Not available in stores


Practical Financial Modelling, 3eis a book on model development and model assurance. It enhances the modelling process by emphasizing controls and checks for accuracy and reliability. New content on validation and verification, model use and sensitivity analysis is presented alongside a modelling methodology that underpins the various proprietary standards used in financial modelling today. It provides more details than other books and yet is general enough for applying its methodology to many applications. This book isn't just about the details of building cash flow models, it's about building better cash flow models.

  • This new edition increases the number of worked examples and introduces new material on the audit sheet and audit workbook methodologies, and the delta sheet approach to sensitivity analysis.
  • It provides the developer with a toolkit of modelling techniques and a framework of error controls to reduce the risk of spreadsheet error.
  • The methodology and structure conforms with the modelling principles defined by the Institute of Chartered Accountants of England and Wales; and the model assurance processes ensure compliance with the UK public sector Macpherson Report and regulatory requirements such as Sarbanes-Oxley.
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.
Title:Practical Financial Modelling: The Development And Audit Of Cash Flow ModelsFormat:PaperbackDimensions:336 pages, 8.75 × 6.35 × 0.68 inPublished:August 21, 2015Publisher:Butterworth (trade)Language:English

The following ISBNs are associated with this title:

ISBN - 10:0081005873

ISBN - 13:9780081005873

Look for similar items by category:


Table of Contents

1. Model Structure
2. Quality Control
3. Mainly Formulas
4. Mainly Functions
5. Model Use
6. Sensitivity Analysis and Scenarios
7. Model Audit and Review
8. Automation

Editorial Reviews

"The 3rd edition of Practical Financial Modelling by Jonathan Swan is a must-read for any organization engaged in corporate modelling in the Excel environment. This well-forged edition offers practitioners important insights and methods to develop models that are useful to the key decision-makers, free of errors, and maintainable for the future by implementing industry standards in model development. Few books in financial modelling even touch on the importance of technique. This book offers a compelling guide to ensure model competence."  --John C. Banko, University of Florida "Jonathan Swan has provided an excellent financial modelling resource, written in a practical way that will appeal to practitioners and academics alike. The book very effectively addresses the essential topic of quality assurance and is bursting with invaluable advice on avoiding errors and improving controls."  --Rob Powell, Edith Cowan University "Practical Financial Modelling provides a great coverage of topics for a book on process modelling. It successfully guides the reader in an innovative practical approach through model use, validation and sensitive analysis. This is a very valuable material to any practitioner, student, or researcher in the modelling process framework."  --Leandro Maciel, University of Campinas