Financial Modelling in Practice (eBook)

A Concise Guide for Intermediate and Advanced Level

Michael Rees (Autor)

eBook Download: PDF

2010 | 1. Auflage
296 Seiten
John Wiley & Sons (Verlag)
978-0-470-74055-2 (ISBN)

Infos

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.

Autor

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.

Inhalt

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.

Produkt-Details

• Erscheint lt. Verlag: 19.3.2010
• Reihe/Serie: Wiley Finance Series
• Sprache: englisch
• Themenwelt: Recht / Steuern ► Wirtschaftsrecht
• Themenwelt: Wirtschaft ► Betriebswirtschaft / Management ► Finanzierung
• Schlagworte: Finance & Investments • Financial Engineering • Finanztechnik • Finanz- u. Anlagewesen
• ISBN-10: 0-470-74055-8 / 0470740558
• ISBN-13: 978-0-470-74055-2 / 9780470740552