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.
"synopsis" may belong to another edition of this title.
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.
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.
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.
"An excellent book which presents advanced financial modelling tools and simulations, and applies them to modern aspects of financial management. As a renowned expert in modelling, Michael Rees develops efficient techniques for simulation and sensitivity analysis within an Excel and Excel add-on framework using many useful and transparent applications in the context of company valuation, derivative business and risk management, enabling the reader to develop good models themselves. A unique book which is highly instructive and motivating."
—Professor Dr Dieter Gramlich, University of Cooperative Education, Heidenheim, Germany
"Mike Rees's book fills an important gap in the literature on how to model financial data. It not only provides a whole host of useful suggestions on how to design, structure, build and analyse models; including tips on how use some of the more advanced functionality in Excel, but also in a clear and concise way explains how to include uncertainty in to these models. During the last few years many business's environment have changed, creating the need to explicitly include uncertainty into their decision making rather than hide behind simple (and often flawed) assumptions of what the future may hold. Mike clearly understands the importance of this area and includes several sections which provide an excellent introduction to anyone starting to apply these types of techniques in their financial models for the first time. It is the combination of best practice modelling techniques, plenty of examples and the basics of some of the more advanced approaches that make this book a useful addition to anyone building financial models."
—Andrea Dickens, Decision Analysis Group Leader, Finance Excellence Unilever
"A well structured reference. If you are unclear how best to approach a modelling task or you are ready to reconsider some of your modelling habits, this is a useful bag of tricks and thoughts which can greatly simplify your task."
―Dominik Geller; Head of Corporate Risk Management; F. Hoffmann –La Roche AG
"Michael Rees has written a financial modelling book that is exceptional in its clarity, balance of theory and practice, and its abundance of invaluable examples. Comprehensive and application-driven in its topical coverage, it is one of the very few books that address the modelling process itself. Michael Rees enables even the desperate readers to design, structure and build models appropriate for their situation and provides them with a sound and practical foundation to bring financial modelling to life."
―Johannes Klose, Principal, Allianz Risk Transfer
"With this outstanding book the reader gets a comprehensive guideline on how to build financial models by showing a path from theoretical approaches to more realistic models. I have never seen such a good explanation of the basic aspects of financial modelling and the presentation of risk modelling including the application of statistical functions. Mike combines visual explanations with mathematical functions and statements where necessary. Supported with a lot of examples this gives the reader a quick understanding of the different topics. The logical development from risk modelling to the analysis of real options is extremely helpful and to my knowledge has never been published in such a form. From my daily practise I would recommend this unique book to every professional or student who is engaged in business modelling and especially interested in risk management."
―D. Martin Erdmann, Director Risk Management, Infineon Technologies AG
"Michael Rees has hit the nail on the head. In Financial Modelling in Practice, he has addressed many common problems business professionals face in accurately representing their real-life situations as Excel spreadsheets. Modelling is crucial for informed decision-making, as is taking uncertainty and risk into account. Michael Rees addresses these needs in a practical, easily understood way that is both robust and accessible."
―Randy Heffernan, Vice President, Palisade Corporation
"About this title" may belong to another edition of this title.
FREE shipping within U.S.A.
Destination, rates & speedsSeller: Orion Tech, Kingwood, TX, U.S.A.
hardcover. Condition: Fair. Seller Inventory # 0470997443-4-31009980
Quantity: 1 available
Seller: Zoom Books Company, Lynden, WA, U.S.A.
Condition: very_good. Book is in very good condition and may include minimal underlining highlighting. The book can also include "From the library of" labels. May not contain miscellaneous items toys, dvds, etc. . We offer 100% money back guarantee and 24 7 customer service. Seller Inventory # ZBV.0470997443.VG
Quantity: 1 available
Seller: Oblivion Books, Seattle, WA, U.S.A.
hardcover. Condition: Very Good. Hardcover. Clean text - NO writing, NO highlighting to text. Very good. Seller Inventory # mon0000220551
Quantity: 1 available
Seller: Anybook.com, Lincoln, United Kingdom
Condition: Good. This is an ex-library book and may have the usual library/used-book markings inside.This book has hardback covers. In good all round condition. Dust jacket in good condition. Please note the Image in this listing is a stock photo and may not match the covers of the actual item,800grams, ISBN:9780470997444. Seller Inventory # 9255240
Quantity: 1 available
Seller: thebookforest.com, San Rafael, CA, U.S.A.
hardcover. Condition: LikeNew. Text block, pages, boards and binding are pristine. Dust wrapper is like new. Disc included. Well packaged and promptly shipped from California. Partnered with Friends of the Library since 2010. Seller Inventory # 1LAT070005VW
Quantity: 1 available
Seller: Solr Books, Lincolnwood, IL, U.S.A.
Condition: new. Seller Inventory # BCV.0470997443.N
Quantity: 1 available
Seller: SGS Trading Inc, Franklin Lakes, NJ, U.S.A.
Hardcover. Condition: Good. Textbook, May Have Highlights, Notes and/or Underlining, BOOK ONLY-NO ACCESS CODE, NO CD, Ships with Tracking. Seller Inventory # SKU0214579
Quantity: 2 available
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Condition: As New. Unread book in perfect condition. Seller Inventory # 5302940
Quantity: Over 20 available
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Condition: New. Seller Inventory # 5302940-n
Quantity: Over 20 available
Seller: PBShop.store US, Wood Dale, IL, U.S.A.
HRD. Condition: New. New Book. Shipped from UK. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # L1-9780470997444
Quantity: Over 20 available