发帖
雷达卡
Author(s): MICHAEL REES
Description:
This reference textbook 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 transpar-ency, 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.
Financial Modeling in Practice _ a Guide Using Excel and VBA .pdf
(25.8 MB, 需要: RMB 19 元)
京公网安备 11010802022788号
