What do you think?
Rate this book
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-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
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.
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
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.
- GenresFinance
544 pages, Kindle Edition
Published March 19, 2018
15 people are currently reading
37 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 2 of 2 reviews
August 13, 2024
Michael Rees' Principles of Financial Modelling: Model Design and Best Practices Using Excel and VBA is an essential guide for those delving into financial modelling. This book offers a thorough exploration of model design and the effective use of Excel and VBA, making it invaluable for students and professionals in finance. Rees covers fundamental principles, from constructing robust models to ensuring accuracy and efficiency, all while providing practical examples and best practices.
Suitable for Studying:
Rees' book is highly recommended for finance students and practitioners. It demystifies complex concepts, breaking them down into actionable steps. The emphasis on practical skills, combined with a clear explanation of theoretical underpinnings, equips readers with the tools needed to create reliable financial models.
Inspiration for Fantasy Novel Writing:
Beyond its academic value, this book can spark creativity for fantasy novelists. The structured approach to problem-solving and logical thinking outlined in Rees’ work can inspire the design of intricate, rule-based systems in fantasy worlds. For example, understanding model design principles can help in crafting detailed economic systems or magic rules within a fictional universe, adding depth and realism to the narrative.
In summary, Principles of Financial Modelling is not only a practical resource for financial professionals but also a source of creative inspiration for world-building in fantasy fiction.
Suitable for Studying:
Rees' book is highly recommended for finance students and practitioners. It demystifies complex concepts, breaking them down into actionable steps. The emphasis on practical skills, combined with a clear explanation of theoretical underpinnings, equips readers with the tools needed to create reliable financial models.
Inspiration for Fantasy Novel Writing:
Beyond its academic value, this book can spark creativity for fantasy novelists. The structured approach to problem-solving and logical thinking outlined in Rees’ work can inspire the design of intricate, rule-based systems in fantasy worlds. For example, understanding model design principles can help in crafting detailed economic systems or magic rules within a fictional universe, adding depth and realism to the narrative.
In summary, Principles of Financial Modelling is not only a practical resource for financial professionals but also a source of creative inspiration for world-building in fantasy fiction.
August 3, 2020
The book is divided in three main parts: the first one is related to the best practices of financial modeling concerning planning and design; the second is related to Excel functions commonly used in financial analysis; the last one is introduction to coding in VBA.
The book is really detailed and could have more potential, however the website that accompanied the book is broken, so it is really complicated to follow the exercises in Excel.
I would leverage more the book if there was a drive in which you can download the Excel files used in each chapter and do it at the same time you're reading.
Also I would like to see more empirical exercises, like actually build a financial model.
The book is really detailed and could have more potential, however the website that accompanied the book is broken, so it is really complicated to follow the exercises in Excel.
I would leverage more the book if there was a drive in which you can download the Excel files used in each chapter and do it at the same time you're reading.
Also I would like to see more empirical exercises, like actually build a financial model.
Displaying 1 - 2 of 2 reviews