Rees Financial Modelling in Practice

A Concise Guide for Intermediate and Advanced Level
1. Auflage 2010
ISBN: 978-0-470-74055-2
Verlag: John Wiley & Sons
Format: PDF
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 296 Seiten, E-Book

Reihe: Wiley Finance Series

Financial Modelling in Practice: A Concise Guide forIntermediate and Advanced Level is a practical, comprehensiveand in-depth guide to financial modelling designed to cover themodelling issues that are relevant to facilitate the constructionof robust and readily understandable models.
Based on the authors extensive experience of building models inbusiness and finance, and of training others how to do so this bookstarts with a review of Excel functions that are generally mostrelevant for building intermediate and advanced level models (suchas Lookup functions, database and statistical functions and soon). It then discusses the principles involved in designing,structuring and building relevant, accurate and readilyunderstandable models (including the use of sensitivity analysistechniques) before covering key application areas, such as themodelling of financial statements, of cash flow valuation, riskanalysis, options and real options. Finally, the topic of financialmodelling using VBA is treated. Practical examples are usedthroughout and model examples are included in the attachedCD-ROM.
Aimed at intermediate and advanced level modellers in Excel whowish to extend and consolidate their knowledge, this book isfocused, practical, and application-driven, facilitating knowledgeto build or audit a much wider range of financial models.
Note: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.

Autoren/Hrsg.

Rees, Michael

Inhaltsverzeichnis

Background, Objectives and Approach.
About the Author.
Acknowledgements.
1 Building Blocks: Selected Excel Functions and Tools.
2 Principles of Modelling.
3 Financial Statement, Cash Flow and Valuation Modelling.
4 Risk Modelling.
5 Introduction to Options and Real Options Modelling.
6 VBA for Financial Modelling.
Further Reading.
Index.

Über Autor(innen)

Michael Rees gained a BA with First Class Honours and aDoctorate in Mathematics from Oxford University in 1985 and 1988respectively. In 1992 he gained an MBA with Distinction fromINSEAD, and in 2003 graduated in first position on the Certificatein Quantitative Finance program, also winning the Wilmottaward.
Since 2002 Michael has worked independently as a consultant andtrainer in financial modelling. Prior to this he worked as astrategy consultant with Braxton Associates and Mercer ManagementConsulting, and also as an analyst at J.P. Morgan.
Michael lives in Richmond, UK. He was born in Canada, has lived inseveral countries, and is fluent in French and German.