Principles of financial modelling : model design and best practices using Excel and VBA / Michael Rees.

Author
Rees, Michael, 1964- [Browse]
Format
Book
Language
English
Published/​Created
  • Chichester, West Sussex, United Kingdom : John Wiley & Sons, Ltd, 2018.
  • ©2018
Description
xxix, 512 pages : illustrations ; 25 cm.

Details

Subject(s)
Series
Wiley finance series. [More in this series]
Notes
Includes index.
Contents
Introduction to modelling, core themes and best practices -- Models of models -- Using models in decision support -- Core competencies and best practices : meta-themes -- Model design and planning -- Defining sensitivity and flexibility requirements -- Database versus formulae-driven approaches -- Designing the workbook structure -- Model building, testing and auditing -- Creating transparency: formula structure, flow and format -- Building robust and transparent formulae -- Choosing Excel functions for transparency, flexibility and efficiency -- Dealing with circularity -- Model review, auditing and validation -- Sensitivity and scenario analysis, simulation and optimisation -- Sensitivity and scenario analysis : core techniques -- Using Goalseek and Solver -- Using VBA macros to conduct sensitivity and scenario analyses -- Introduction to simulation and optimisation -- The modelling of risk and uncertainty, and using simulation -- Excel functions and functionality -- Core arithmetic and logical functions -- Array functions and formulae -- Mathematical functions -- Financial functions -- Statistical functions -- Information functions -- Date and time functions -- Text functions and functionality -- Lookup and reference functions -- Filters, database functions and pivottables -- Selected short-cuts and other features -- Foundations of VBA and macros -- Getting started -- Working with objects and ranges -- Controlling execution -- Writing robust code -- Manipulation and analysis of data sets with VBA -- User-defined functions.
ISBN
  • 9781118904015 ((hardcover))
  • 111890401X ((hardcover))
LCCN
2017057631
OCLC
1028606768
Other views
Staff view

Supplementary Information