Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level is a sensible, complete and in–depth information to monetary modelling designed to cowl the modelling points which might be related to facilitate the development of strong and readily comprehensible fashions.
Based on the authors in depth expertise of constructing fashions in enterprise and finance, and of coaching others how to take action this e book begins with a assessment of Excel capabilities which might be typically most related for constructing intermediate and superior stage fashions (comparable to Lookup capabilities, database and statistical capabilities and so forth). It then discusses the rules concerned in designing, structuring and constructing related, correct and readily comprehensible fashions (together with the usage of sensitivity evaluation strategies) earlier than protecting key utility areas, such because the modelling of monetary statements, of money stream valuation, threat evaluation, choices and actual choices. Finally, the subject of monetary modelling utilizing VBA is handled. Practical examples are used all through and mannequin examples are included in the hooked up CD–ROM.
Aimed at intermediate and superior stage modellers in Excel who want to lengthen and consolidate their data, this e book is concentrated, sensible, and utility–pushed, facilitating data to construct or audit a a lot wider vary of monetary fashions.
Michael’s 20 years’ of enterprise and finance expertise consists of roles comparable to Principal (Partner) on the technique consultants Mercer Management Consulting (now Oliver Wyman) and Vice-President of Equity Research at J.P. Morgan. He has labored independently for eight years, for 6 of which he was retained by Palisade Corporation to behave as their Director of Training and Consulting (Palisade is the world’s main supplier of quantitative modelling add-ins to Excel).
His educational credentials embody a Doctorate in Mathematical Modelling and Numerical Algorithms, and a B.A. with First Class Honours in Mathematics, each from Oxford University. He has an MBA with Distinction from INSEAD in France, in addition to holding the Wilmott Certificate of Quantitative Finance, the place he graduated prime of the course for class work and in addition obtained the Wilmott Award for the very best last examination mark.
More data could be discovered at www.michaelrees.co.uk