{"product_id":"principles-of-financial-modelling-model-design-and-best-practices-using-excel-and-vba-hardcover","title":"Principles of Financial Modelling: Model Design and Best Practices Using Excel and VBA - Hardcover","description":"\u003cp\u003eby \u003cb\u003eMichael Rees\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003cb\u003eThe comprehensive, broadly-applicable, real-world guide to financial modelling\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003ci\u003ePrinciples of Financial Modelling \u003c\/i\u003e- \u003ci\u003eModel Design and Best Practices Using Excel and VBA\u003c\/i\u003ecovers 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: \u003c\/p\u003e \u003cul\u003e \u003cli\u003eModel 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\u003c\/li\u003e \u003cli\u003eSensitivity and scenario analysis, simulation, and optimisation\u003c\/li\u003e \u003cli\u003eData manipulation and analysis\u003c\/li\u003e \u003cli\u003eThe 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\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eThe 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.\u003c\/p\u003e \u003cp\u003eFor practical instruction, robust technique and clear presentation, \u003ci\u003ePrinciples of Financial Modelling\u003c\/i\u003e 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.\u003c\/p\u003e\u003ch3\u003eFront Jacket\u003c\/h3\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003ci\u003ePrinciples of Financial Modelling\u003c\/i\u003e covers the full spectrum of financial modelling tools and techniques, which are drawn from the author's years of experience in dealing with a wide variety of real-world applications, both from consulting projects and from conducting training courses. The book demonstrates how to plan, design and build financial models that are flexible, robust, and transparent, and which are applicable to many decision-support contexts, including forecasting, business planning, project evaluation and selection, portfolio optimisation, and resource allocation. \u003c\/p\u003e \u003cp\u003eThe book includes extensive coverage of: \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eModel 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\u003c\/li\u003e \u003cli\u003eSensitivity and scenario analysis, simulation, and optimisation\u003c\/li\u003e \u003cli\u003eData manipulation and analysis\u003c\/li\u003e\n\u003c\/ul\u003e \u003cp\u003e\u003ci\u003ePrinciples of Financial Modelling\u003c\/i\u003e also provides practical examples of the use of most Excel functions, and an in-depth treatment of VBA and its key areas of application within financial modelling, including the automation of many tasks to improve efficiency in areas such as data analysis and manipulation, simulation, and user-defined functions.\u003c\/p\u003e\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003cb\u003eMICHAEL REES, D.PHIL., MBA, \u003c\/b\u003e operates globally to help senior executives to solve their most complex problems in the areas of decision support, business strategy, value-creation, risk assessment, and optimisation. He combines practical experience from top firms with an exceptional analytic record, and is among the world's leading authors and instructors in the field of financial and risk modelling. His special interest is in cases where issues in strategy, business economics, and valuation are best addressed using practical advanced quantitative approaches.\u003c\/p\u003e \u003cp\u003eHe has a Doctorate in Mathematical Modelling and Numerical Algorithms, and a B.A. with First Class Honours in Mathematics, both from Oxford University in the UK. He has an MBA with distinction from INSEAD in France. He also studied for the Certificate of Quantitative Finance, graduating top of the class for course work, and receiving the Wilmott Award for the highest final exam mark. \u003c\/p\u003e\u003cp\u003eHe has approximately 30 years' business and finance experience, in many sectors, including oil, gas, energy and resources, private equity, health care, biotechnology, chemicals, construction, engineering, and insurance.\u003c\/p\u003e\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 544\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 1.4 x 9.8 x 6.9 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e July 18, 2018\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":42721388232767,"sku":"9781118904015","price":181.44,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0105\/8226\/1823\/files\/e10497577012f6fa68907d242d8c59d1.webp?v=1765092189","url":"https:\/\/dhlswag.com\/products\/principles-of-financial-modelling-model-design-and-best-practices-using-excel-and-vba-hardcover","provider":"BBB","version":"1.0","type":"link"}