Michael Rees – Financial Modelling in Practice. A Concise Guide for Intermediate & Advanced Level

Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level is a practical, comprehensive and in–depth guide to financial modelling designed to cover the modelling issues that are relevant to facilitate the construction of robust and readily understandable models.

Based on the authors extensive experience of building models in business and finance, and of training others how to do so this book starts with a review of Excel functions that are generally most relevant for building intermediate and advanced level models (such as Lookup functions, database and statistical functions and so on).  It then discusses the principles involved in designing, structuring and building relevant, accurate and readily understandable models (including the use of sensitivity analysis techniques) before covering key application areas, such as the modelling of financial statements, of cash flow valuation, risk analysis, options and real options. Finally, the topic of financial modelling using VBA is treated. Practical examples are used throughout and model examples are included in the attached CD–ROM.

Aimed at intermediate and advanced level modellers in Excel who wish to extend and consolidate their knowledge, this book is focused, practical, and application–driven, facilitating knowledge to build or audit a much wider range of financial models.

Michael’s 20 years’ of business and finance experience includes roles such as Principal (Partner) at the strategy consultants Mercer Management Consulting (now Oliver Wyman) and Vice-President of Equity Research at J.P. Morgan. He has worked independently for 8 years, for 6 of which he was retained by Palisade Corporation to act as their Director of Training and Consulting (Palisade is the world’s leading provider of quantitative modelling add-ins to Excel).

His academic credentials include a Doctorate in Mathematical Modelling and Numerical Algorithms, and a B.A. with First Class Honours in Mathematics, both from Oxford University. He has an MBA with Distinction from INSEAD in France, as well as holding the Wilmott Certificate of Quantitative Finance, where he graduated top of the course for class work and also received the Wilmott Award for the highest final exam mark.