Principles of financial modelling
Subtitle: model design and best practices using Excel and VBA
By: Michael Rees
Series: Wiley Finance Series; Wiley finance series
Published: 2018
Language: eng
Number of pages: 512
ISBN-13: 9781118904015
Copyright date: 2018
Subjects: Finance; Mathematical models; Microsoft Excel (Computer file); Visual Basic for Applications (Computer program language); Corporations; Microsoft Office
Notes: Includes index.
Table of contents: title: Introduction to modelling, core themes and best practices; title: Models of models; title: Using models in decision support; title: Core competencies and best practices : meta-themes; title: Model design and planning; title: Defining sensitivity and flexibility requirements; title: Database versus formulae-driven approaches; title: Designing the workbook structure; title: Model building, testing and auditing; title: Creating transparency: formula structure, flow and format; title: Building robust and transparent formulae; title: Choosing Excel functions for transparency, flexibility and efficiency; title: Dealing with circularity; title: Model review, auditing and validation; title: Sensitivity and scenario analysis, simulation and optimisation; title: Sensitivity and scenario analysis : core techniques; title: Using Goalseek and Solver; title: Using VBA macros to conduct sensitivity and scenario analyses; title: Introduction to simulation and optimisation; title: The modelling of risk and uncertainty, and using simulation; title: Excel functions and functionality; title: Core arithmetic and logical functions; title: Array functions and formulae; title: Mathematical functions; title: Financial functions; title: Statistical functions; title: Information functions; title: Date and time functions; title: Text functions and functionality; title: Lookup and reference functions; title: Filters, database functions and pivottables; title: Selected short-cuts and other features; title: Foundations of VBA and macros; title: Getting started; title: Working with objects and ranges; title: Controlling execution; title: Writing robust code; title: Manipulation and analysis of data sets with VBA; title: User-defined functions.