You have no items in your shopping cart.

Principles of Financial Modelling: Model Design and Best Practices Using Excel and VBA

Principles of Financial Modelling: Model Design and Best Practices Using Excel and VBA

  • Author:
  • Publisher: John Wiley & Sons
  • ISBN: 9781118904015
  • Published In: March 2018
  • Format: Hardback , 544 pages
  • Jurisdiction: International ? Disclaimer:
    Countri(es) stated herein are used as reference only

List Price: HKD 1,000.00

HKD 890.00 Save HKD 110.00 (11%)

Delivery Time: around 1-2 weeks
Extra 2-10 working days working days if shipping address outside Hong Kong
Free delivery HK & China?
Hong Kong: free delivery (order over HKD 500)
China: free delivery (order over RMB 500)
OR
  • Description 
  • Contents 
  • Details

    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-world applications. Based on rigorously-tested materials created for consulting projects and for training courses, this book demonstrates how to plan, design and build financial models that are flexible, robust, transparent, and highly applicable to a wide range of planning, forecasting and decision-support contexts. This book integrates theory and practice to provide a high-value resource for anyone wanting to gain a practical understanding of this complex and nuanced topic. Highlights of its content include extensive coverage of:

    • Model design and best practices, including the optimisation of data structures and layout, maximising transparency, balancing complexity with flexibility, dealing with circularity, model audit and error-checking
    • Sensitivity and scenario analysis, simulation, and optimisation
    • Data manipulation and analysis
    • The use and choice of Excel functions and functionality, including advanced functions and those from all categories, as well as of VBA and its key areas of application within financial modelling

    The companion website provides approximately 235 Excel files (screen-clips of most of which are shown in the text), which demonstrate key principles in modelling, as well as providing many examples of the use of Excel functions and VBA macros. These facilitate learning and have a strong emphasis on practical solutions and direct real-world application.

    For practical instruction, robust technique and clear presentation, Principles of Financial Modelling is the premier guide to real-world financial modelling from the ground up. It provides clear instruction applicable across sectors, settings and countries, and is presented in a well-structured and highly-developed format that is accessible to people with different backgrounds.

  • Preface xxv

    About the Author xxvii

    About the Website xxix

    PART ONE Introduction to Modelling, Core Themes and Best Practices 1

    CHAPTER 1 Models of Models 3

    CHAPTER 2 Using Models in Decision Support 7

    CHAPTER 3 Core Competencies and Best Practices: Meta-themes 15

    PART TWO Model Design and Planning 23

    CHAPTER 4 Defining Sensitivity and Flexibility Requirements 25

    CHAPTER 5 Database Versus Formulae-driven Approaches 37

    CHAPTER 6 Designing the Workbook Structure 47

    PART THREE Model Building, Testing and Auditing 57

    CHAPTER 7 Creating Transparency: Formula Structure, Flow and Format 59

    CHAPTER 8 Building Robust and Transparent Formulae 79

    CHAPTER 9 Choosing Excel Functions for Transparency, Flexibility and Efficiency 105

    CHAPTER 10 Dealing with Circularity 117

    CHAPTER 11 Model Review, Auditing and Validation 143

    PART FOUR Sensitivity and Scenario Analysis, Simulation and Optimisation 153

    CHAPTER 12 Sensitivity and Scenario Analysis: Core Techniques 155

    CHAPTER 13 Using GoalSeek and Solver 163

    CHAPTER 14 Using VBA Macros to Conduct Sensitivity and Scenario Analyses 171

    CHAPTER 15 Introduction to Simulation and Optimisation 177

    CHAPTER 16 The Modelling of Risk and Uncertainty, and Using Simulation 187

    PART FIVE Excel Functions and Functionality 199

    CHAPTER 17 Core Arithmetic and Logical Functions 201

    CHAPTER 18 Array Functions and Formulae 217

    CHAPTER 19 Mathematical Functions 229

    CHAPTER 20 Financial Functions 243

    CHAPTER 21 Statistical Functions 257

    CHAPTER 22 Information Functions 299

    CHAPTER 23 Date and Time Functions 307

    CHAPTER 24 Text Functions and Functionality 313

    CHAPTER 25 Lookup and Reference Functions 325

    CHAPTER 26 Filters, Database Functions and PivotTables 355

    CHAPTER 27 Selected Short-cuts and Other Features 387

    PART SIX Foundations of VBA and Macros 395

    CHAPTER 28 Getting Started 397

    CHAPTER 29 Working with Objects and Ranges 413

    CHAPTER 30 Controlling Execution 425

    CHAPTER 31 Writing Robust Code 441

    CHAPTER 32 Manipulation and Analysis of Data Sets with VBA 455

    CHAPTER 33 User-defined Functions 473

    Index 493

You may also be interested in these books:

The Chief HR Officer
The Chief HR Officer

List Price: HKD 600.00

HKD 534.00 Save HKD 66.00 (11%)

Brand for Talent
Brand for Talent

List Price: HKD 300.00

HKD 267.00 Save HKD 33.00 (11%)

Optimize Your Greatest Asset -- Your People
Optimize Your Greatest Asset -- Your People

List Price: HKD 600.00

HKD 534.00 Save HKD 66.00 (11%)

THREE: The Human Resources Emerging Executive
THREE: The Human Resources Emerging Executive

List Price: HKD 350.00

HKD 311.50 Save HKD 38.50 (11%)

Advancing Human Resource Project Management
Advancing Human Resource Project Management

List Price: HKD 800.00

HKD 712.00 Save HKD 88.00 (11%)

Misplaced Talent: A Guide to Better People Decisions
Misplaced Talent: A Guide to Better People Decisions

List Price: HKD 300.00

HKD 267.00 Save HKD 33.00 (11%)

Developing Human Capital
Developing Human Capital

List Price: HKD 600.00

HKD 534.00 Save HKD 66.00 (11%)

Predictive Analytics for Human Resources
Predictive Analytics for Human Resources

List Price: HKD 500.00

HKD 445.00 Save HKD 55.00 (11%)

Resourcing and Talent Management, 6th Edition
Resourcing and Talent Management, 6th Edition
HKD 540.00
Managing People and Organisations
Managing People and Organisations
HKD 540.00
Common Sense Talent Management
Common Sense Talent Management

List Price: HKD 550.00

HKD 489.50 Save HKD 60.50 (11%)

Employee Engagement
Employee Engagement

List Price: HKD 388.00

HKD 345.32 Save HKD 42.68 (11%)

Reward Management
Reward Management

List Price: HKD 300.00

HKD 267.00 Save HKD 33.00 (11%)

Performance Management
Performance Management

List Price: HKD 300.00

HKD 150.00 Save HKD 150.00 (50%)

Armstrong's Handbook of Human Resource Management Practice, 13th Edition
Armstrong's Handbook of Human Resource Management Practice, 13th Edition

List Price: HKD 480.00

HKD 427.20 Save HKD 52.80 (11%)

HR Bible
HR Bible

List Price: HKD 295.00

HKD 206.50 Save HKD 88.50 (30%)

Simply HR
Simply HR

List Price: HKD 320.00

HKD 160.00 Save HKD 160.00 (50%)

Employment Law in China, 4th Edition
Employment Law in China, 4th Edition

List Price: HKD 800.00

HKD 400.00 Save HKD 400.00 (50%)

Hiring Greatness: How to Recruit Your Dream Team and Crush the Competition
Hiring Greatness: How to Recruit Your Dream Team and Crush the Competition

List Price: HKD 270.00

HKD 240.30 Save HKD 29.70 (11%)