Normal view MARC view ISBD view

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
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.
Summary: 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.
Item type Home library Call number URL Status Notes Date due Item reserves
EBook EBook International
EBL Ebook (Browse shelf) Link to resource eBook Available as an ebook here
Total holds: 0

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.

© 2017 Chartered Accountants Australia and New Zealand ABN 50 084 642 571 (CA ANZ).
Formed in Australia. Members of CA ANZ are not liable for the debts and liabilities of CA ANZ

Powered by Koha

Powered by Koha