• Book Name: Principles of Financial Modelling Model Design and Best Practices Using Excel and VBA by Michael Rees
• Author: Michael Rees
• Pages: 515
• Size: 26

Principles of Financial Modelling PDF Download

This text aims to address key topics in the design and building of financial models, so that such models are appropriate to decision support, are transparent and flexible. It aims to address the issues that are generally applicable in many applications, highlighting several core themes:

◾ Building models that meet their decision-support role.

◾ Designing models so that sensitivity analysis can be conducted as relevant, and which meet core requirements for flexibility.

◾ Minimising the complexity, subject to the model meeting the core requirements.

◾ Structuring models to have an effective layout and flow, with audit (dependency) paths as short as possible.

◾ Focusing on the creation of transparency.

◾ Using Excel functions and functionality (and perhaps VBA/macros) in the most effective and appropriate way (requiring one to have a good knowledge of the possibilities and options available).

◾ Employing problem-solving skills in an integrated way.

The work is structured into six Parts:

◾ Part I presents a framework to describe modelling processes, discusses the role of models in decision support and summarises some key themes and best practices.

◾ Part II discusses model design, focusing on sensitivity and flexibility requirements, and the optimisation of data structures and layout.

◾ Part III covers the process of building models, focusing on maximising transparency, using the appropriate Excel functions, and creating models which are errorfree and easy to audit.

◾ Part IV covers sensitivity and scenario analysis, simulation and optimisation.

◾ Part V provides practical examples of the use of Excel functions and functionality in financial modelling.

◾ Part VI covers an introduction to VBA and its key areas of application within financial modelling. Note that Part V and Part VI are relevant on a stand-alone basis and could be read before the other Parts. This allows the earlier Parts of the text to focus on the general issues relating to model design, build and use, even as, on occasion, they refer to the later Parts.

Principles of Financial Modelling PDF Download

This text builds on some key principles that were also a core aspect of the author’s earlier work Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level (John Wiley & Sons, 2008), especially that of using sensitivity thought processes as a model design tool. However, the discussion here is more extensive and detailed, reflecting the author’s enhanced view of these topics that has been gained through the decade since the publication of the earlier work. Indeed, this text is approximately three times the length of that of the corresponding elements of the earlier work (i.e. of Chapters 1, 2 and 6 in that work).

Note that, unlike the earlier work, this text does not aim to treat specific applications in depth (such as financial statements, valuation, options and real options). Further, the topic of risk, uncertainty and simulation modelling is covered only briefly, since the author’s Business Risk Modelling in Practice: Using Excel, VBA and @RISK (John Wiley & Sons, 2015) provides a detailed treatment of this topic. The website associated with this text contains approximately 235 Excel files (screen-clips of most of which are shown in the text). These are an integral part of this work, and it will generally be necessary to refer to these files in order to gain the maximum benefit from reading this text.

Principles of financial modelling pdf download.