Financial Modelling in Practice

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.