Book description
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.
Note: CD-ROM/DVD and other supplementary materials are not
included as part of eBook file.
Michael Rees gained a BA with First Class Honours
and a Doctorate in Mathematics from Oxford University in 1985 and 1988
respectively. In 1992 he gained an MBA with Distinction from INSEAD,
and in 2003 graduated in first position on the Certificate in
Quantitative Finance program, also winning the Wilmott
award.
Since 2002 Michael has worked independently as a
consultant and trainer in financial modelling. Prior to this he worked
as a strategy consultant with Braxton Associates and Mercer Management
Consulting, and also as an analyst at J. P. Morgan.
Michael lives
in Richmond, UK. He was born in Canada, has lived in several
countries, and is fluent in French and German.
