Principles of Financial Modelling

Model Design and Best Practices Using Excel and VBA

Business & Finance, Finance & Investing, Finance
Cover of the book Principles of Financial Modelling by Michael Rees, Wiley
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Michael Rees ISBN: 9781118904008
Publisher: Wiley Publication: March 19, 2018
Imprint: Wiley Language: English
Author: Michael Rees
ISBN: 9781118904008
Publisher: Wiley
Publication: March 19, 2018
Imprint: Wiley
Language: English

The comprehensive, broadly-applicable, real-world guide to financial modelling

Principles of Financial ModellingModel 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.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

The comprehensive, broadly-applicable, real-world guide to financial modelling

Principles of Financial ModellingModel 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:

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.

More books from Wiley

Cover of the book The Wiley Blackwell Companion to Tourism by Michael Rees
Cover of the book Uhlig's Corrosion Handbook by Michael Rees
Cover of the book An Aid to the MRCP PACES, Volume 1 by Michael Rees
Cover of the book macOS Sierra For Dummies by Michael Rees
Cover of the book Change Your Thinking, Change Your Life by Michael Rees
Cover of the book Fuels, Chemicals and Materials from the Oceans and Aquatic Sources by Michael Rees
Cover of the book The Wiley Handbook of Evolutionary Neuroscience by Michael Rees
Cover of the book The Law of Tax-Exempt Healthcare Organizations 2016 Supplement by Michael Rees
Cover of the book Optical 3D-Spectroscopy for Astronomy by Michael Rees
Cover of the book Introduction to Audiovisual Archives by Michael Rees
Cover of the book The Profitable Consultant by Michael Rees
Cover of the book Africa Emerges by Michael Rees
Cover of the book Kripke by Michael Rees
Cover of the book Beginning T-SQL with Microsoft SQL Server 2005 and 2008 by Michael Rees
Cover of the book Hamas by Michael Rees
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy