Principles of financial modelling : model design and best practices using Excel and VBA / by Michael Rees
By: Rees, Michael.Publisher: Chichester, U.K. : Wiley, 2018Edition: 2nd ed.Description: 616 p. : ill.ISBN: 9781118904015.Other title: Financial modelling in practice : a concise guide using Excel and VBA for intermediate and advanced level.Subject(s): Financial modelling | Excel | VBAOnline resources: Download as an eBook
|Item type||Home library||Call number||URL||Status||Notes||Date due||Item reserves|
|EBook||International||EBL Ebook (Browse shelf)||Link to resource||eBook||Available as an ebook here|
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.
Provides a practical, real-world, guide to financial modelling tools and techniques. Discusses how to design, structure and build accurate and understandable models. Covers topics such as financial statements, cash flow valuation, risk analysis, and options. Includes model examples.