Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level
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.
From the Inside Flap
“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
2008年出的一本书，看到咱们论坛上没有就发了，虽然是首发但因为不是新书，所以免费！粗略扫了一下，内容并不难，对金融建模感兴趣的同学也可以结合我另一个帖子里发的书一起看一下http://www.pinggu.org/bbs/thread-1009292-1-1.html
网络较差，怕上传过程出错，所以上传好了我会在二楼告之大家。
扫码加好友，拉您进群
全部版块
我的主页
收藏
