“Financial Modelling in Practice” — In Print Now!

Financial Modelling in PracticeThe highlight of my week has been the publication of my book “Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level” by John Wiley&Sons.

I wrote the book partly as a result of my experiences running training courses, which showed me that many modellers have a reasonable knowledge of core Excel functionality, but desire to increase and consolidate their knowledge in a way that is prioritised, practical, and application-driven. In addition, I felt that there were few if any really good texts out there which help modellers to design, to structure and to build models which are relevant, accurate, and readily understandable.  Many texts and training courses in the modelling area put their emphasis either on Excel functionality, or on financial theory, or on mathematical models, but hardly address the modelling process. Finally, most modelling texts either do not adequately treat the topic of risk analysis, or otherwise treat it from a mathematical perspective that is both inaccessible to many modellers and lacking in practical tools.

The book starts with a review of Excel functions that are generally most relevant for building intermediate and advanced level models, including functions relevant to statistical analysis. It then discusses the principles involved in designing, structuring and building relevant, accurate and readily understandable models.  Topics covered include the use of sensitivity analysis, best practice modelling principles and related issues, and model auditing tools. A Chapter is devoted to the modelling of financial statements and of cash flow valuation using discounted cash flow analysis. It then moves on to discuss risk assessment and uncertainty modelling.  Many practical applications and example models are presented in an intuitive and accessible way and the @RISK Monte Carlo software from Palisade Corporation is used to implement most models. The topic of options and real options modelling is then covered, treating these as a natural extension of risk modelling.  Classical option valuation methods are discussed, as well as practical methods of modelling real options, including the implementation of decision trees. Chapter 6 covers VBA for financial modelling applications.  The topics selected for inclusion were established by consideration of the core types of financial models that frequently require the use of VBA and provides beginners in this area with a solid base on which to discover the richer possibilities available to modellers by using VBA.

» Buy now at Amazon.co.uk
» Buy now at Amazon.com

Dr. Michael Rees
Director of Training and Consulting


  1. The book just came out, and there are no plans to publish in Spanish at the moment, but we will announce any new editions on the Palisade website. Thanks for your interest!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s