Loading…

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

The comprehensive, broadly-applicable, real-world guide to financial modelling Principles of Financial Modelling - Model Design and Best Practices Using Excel and VBAcovers the full spectrum of financial modelling tools and techniques in order to provide practical skills that are grounded in real-wo...

Full description

Bibliographic Details
Call Number:Libro Electrónico
Main Author: Rees, Michael, 1964- (Author)
Format: Electronic eBook
Language:Inglés
Published: Hoboken : Wiley, [2018]
Series:Wiley finance series.
Subjects:
Online Access:Texto completo (Requiere registro previo con correo institucional)
Table of 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.