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...
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Hoboken :
Wiley,
[2018]
|
Colección: | Wiley finance series.
|
Temas: | |
Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 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.