Chapter 1: The Role of Financial Modelers today
Sub1: Examples of Real day modelling roles
Sub2: Where financial modelers have been used
Sub3: The modelling roles for the future (New)
Chapter 2: Types of Financial Models (New)
Sub1: Quantitive models
Sub2: Stochastic models
Sub3: Time-based models
Sub4: Scenario models
Sub5: Valuation models
Sub6: Other Models
Chapter 3: Review of Best Practices for Modeling
Sub1: Accepted rules
Sub2: Avoid these Sub:3 Reason behind Best practices (New)
Chapter 4: The Modeling Lifecyle explained (New)
Sub1: The Seven Modeling components explained.
Chapter 5: Planning and designing models
Sub1: Methods of Planning
Sub2: Completing the Plan
Sub3: How to know which model type
Sub4: Methods of designing all models
Sub5: Completing the design
Chapter 6: Its all about the model outputs (New)
Sub1: Explore the types of outputs
Sub2: Creating Dashboards with Excel
Chapter 7: Model Build
Sub1: Building the Outputs
Sub2: Developing the Inputs and Scenarios
Sub3: Connecting the Outputs with the Inputs
Sub4: Building Error Checks
Sub5: User interaction with the model
Chapter 8: Financial Modeling and
About the Author: Jack Avon is the principal consultant at Isys Systems, an international provider of financial modeling and analysis services. He specializes in integrating in-house ERP systems and bespoke financial models, automated dashboards, and automated reporting packages using Microsoft Access, Excel, VBA, SQL Server, and SQL. He trains corporate personnel and develops training manuals in financial data analysis and financial reporting. Clients include British Telecom, Huawei, HSBC, Crossrail, Fujitsu, and the UK Electoral Commission. Avon is the author of The Handbook of Financial Modeling (Apress, 2013) and The Basics of Financial Modeling (Apress, 2015). He holds his MBA in information technology and BS from Bournemouth University and his MS from the University of London.
