Advanced Modelling in Finance using Excel and VBA

Author: Mary Jackson,Mike Staunton

Publisher: John Wiley & Sons

ISBN: 0470061669

Category: Business & Economics

Page: 276

View: 7650

DOWNLOAD NOW »

This new and unique book demonstrates that Excel and VBA can play an important role in the explanation and implementation of numerical methods across finance. Advanced Modelling in Finance provides a comprehensive look at equities, options on equities and options on bonds from the early 1950s to the late 1990s. The book adopts a step-by-step approach to understanding the more sophisticated aspects of Excel macros and VBA programming, showing how these programming techniques can be used to model and manipulate financial data, as applied to equities, bonds and options. The book is essential for financial practitioners who need to develop their financial modelling skill sets as there is an increase in the need to analyse and develop ever more complex 'what if' scenarios. Specifically applies Excel and VBA to the financial markets Packaged with a CD containing the software from the examples throughout the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Financial Modeling Using Excel and VBA

Author: Chandan Sengupta

Publisher: John Wiley & Sons

ISBN: 9780471267683

Category: Business & Economics

Page: 857

View: 5012

DOWNLOAD NOW »

"Reviews all the necessary financial theory and concepts, and walks you through a wide range of real-world financial models" - cover.

Principles of Financial Modelling

Model Design and Best Practices Using Excel and VBA

Author: Michael Rees

Publisher: John Wiley & Sons

ISBN: 1118904001

Category: Business & Economics

Page: 544

View: 8056

DOWNLOAD NOW »

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.

Financial Modelling in Practice

A Concise Guide for Intermediate and Advanced Level

Author: Michael Rees

Publisher: John Wiley & Sons

ISBN: 9781119995203

Category: Business & Economics

Page: 288

View: 4130

DOWNLOAD NOW »

Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level is a practical, comprehensive and in-depth guide to financial modelling designed to cover the modelling issues that are relevant to facilitate the construction of robust and readily understandable models. Based on the authors extensive experience of building models in business and finance, and of training others how to do so this book starts with a review of Excel functions that are generally most relevant for building intermediate and advanced level models (such as Lookup functions, database and statistical functions and so on). It then discusses the principles involved in designing, structuring and building relevant, accurate and readily understandable models (including the use of sensitivity analysis techniques) before covering key application areas, such as the modelling of financial statements, of cash flow valuation, risk analysis, options and real options. Finally, the topic of financial modelling using VBA is treated. Practical examples are used throughout and model examples are included in the attached CD-ROM. Aimed at intermediate and advanced level modellers in Excel who wish to extend and consolidate their knowledge, this book is focused, practical, and application-driven, facilitating knowledge to build or audit a much wider range of financial models. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Hedge Fund Modelling and Analysis Using Excel and VBA

Author: Paul Darbyshire,David Hampton

Publisher: John Wiley & Sons

ISBN: 111994564X

Category: Business & Economics

Page: 278

View: 4207

DOWNLOAD NOW »

Co-authored by two respected authorities on hedge funds and asset management, this implementation-oriented guide shows you how to employ a range of the most commonly used analysis tools and techniques both in industry and academia, for understanding, identifying and managing risk as well as for quantifying return factors across several key investment strategies. The book is also suitable for use as a core textbook for specialised graduate level courses in hedge funds and alternative investments. The book provides hands-on coverage of the visual and theoretical methods for measuring and modelling hedge fund performance with an emphasis on risk-adjusted performance metrics and techniques. A range of sophisticated risk analysis models and risk management strategies are also described in detail. Throughout, coverage is supplemented with helpful skill building exercises and worked examples in Excel and VBA. The book's dedicated website, www.darbyshirehampton.com provides Excel spreadsheets and VBA source code which can be freely downloaded and also features links to other relevant and useful resources. A comprehensive course in hedge fund modelling and analysis, this book arms you with the knowledge and tools required to effectively manage your risks and to optimise the return profile of your investment style.

Excel 2007 VBA-Programmierung für Dummies

Author: John Walkenbach

Publisher: Wiley-VCH

ISBN: 9783527704118

Category: Computers

Page: 385

View: 9540

DOWNLOAD NOW »

Um noch mehr aus Excel herauszuholen, empfiehlt sich die VBA-Programmierung, mit der Sie Excel auf Ihre Bedürfnisse zuschneiden können. John Walkenbach zeigt Ihnen in "Excel 2007 VBA-Programmierung für Dummies", wie Sie Excel-Berechnungen mit VBA automatisieren. Er erklärt Ihnen zunächst die notwendigen VBA-Grundlagen und wichtigsten Werkzeuge sowie VBA-Abläufe des VBA-Editors. Außerdem erhalten Sie eine Übersicht über die wichtigsten Bestandteile und Begriffe, die für die VBA-Programmierung in Excel relevant sind, und Sie erfahren, wie Sie Programmierfehler ausfindig machen und beheben.

Risk Analysis

A Quantitative Guide

Author: David Vose

Publisher: John Wiley & Sons

ISBN: 0470512849

Category: Business & Economics

Page: 752

View: 7423

DOWNLOAD NOW »

Risk Analysis concerns itself with the quantification of risk, the modeling of identified risks and how to make decisions from those models. Quantitative risk analysis (QRA) using Monte Carlo simulation offers a powerful and precise method for dealing with the uncertainty and variability of a problem. By providing the building blocks the author guides the reader through the necessary steps to produce an accurate risk analysis model and offers general and specific techniques to cope with most modeling problems. A wide range of solved problems is used to illustrate these techniques and how they can be used together to solve otherwise complex problems.

Business Risk and Simulation Modelling in Practice

Using Excel, VBA and @RISK

Author: Michael Rees

Publisher: John Wiley & Sons

ISBN: 1118904044

Category: Business & Economics

Page: 464

View: 5916

DOWNLOAD NOW »

The complete guide to the principles and practice of risk quantification for business applications. The assessment and quantification of risk provide an indispensable part of robust decision-making; to be effective, many professionals need a firm grasp of both the fundamental concepts and of the tools of the trade. Business Risk and Simulation Modelling in Practice is a comprehensive, in–depth, and practical guide that aims to help business risk managers, modelling analysts and general management to understand, conduct and use quantitative risk assessment and uncertainty modelling in their own situations. Key content areas include: Detailed descriptions of risk assessment processes, their objectives and uses, possible approaches to risk quantification, and their associated decision-benefits and organisational challenges. Principles and techniques in the design of risk models, including the similarities and differences with traditional financial models, and the enhancements that risk modelling can provide. In depth coverage of the principles and concepts in simulation methods, the statistical measurement of risk, the use and selection of probability distributions, the creation of dependency relationships, the alignment of risk modelling activities with general risk assessment processes, and a range of Excel modelling techniques. The implementation of simulation techniques using both Excel/VBA macros and the @RISK Excel add-in. Each platform may be appropriate depending on the context, whereas the core modelling concepts and risk assessment contexts are largely the same in each case. Some additional features and key benefits of using @RISK are also covered. Business Risk and Simulation Modelling in Practice reflects the author′s many years in training and consultancy in these areas. It provides clear and complete guidance, enhanced with an expert perspective. It uses approximately one hundred practical and real-life models to demonstrate all key concepts and techniques; these are accessible on the companion website.

Credit Risk Modeling Using Excel and VBA

Author: Gunter Löeffler,Mr Peter N Posch

Publisher: John Wiley & Sons

ISBN: 0470660929

Category: Business & Economics

Page: 342

View: 3601

DOWNLOAD NOW »

This book provides practitioners and students with an intuitive, hands-on introduction to modern credit risk modelling. Every chapter starts with an explanation of the methodology and then the authors take the reader step by step through the implementation of the methods in Excel and VBA.

Finanzmarktstatistik

Author: Friedrich Schmid,Mark Matthias Trede

Publisher: Springer-Verlag

ISBN: 3540297952

Category: Business & Economics

Page: 267

View: 2923

DOWNLOAD NOW »

Dieses Buch gibt eine Einführung in die wichtigsten Verfahren der statistischen Analyse von Finanzmarktdaten wie beispielsweise Kursen oder Renditen von Aktien oder Aktienindizes. Unter den Themen sind die Deskription und Analyse von uni- und multivariaten Renditeverteilungen, die Analyse der Struktur von Renditezeitreihen sowie statistische Verfahren für das CAPM und die Untersuchung der stochastischen Dominanz. Das Buch richtet sich an Studierende der Wirtschaftswissenschaften im Hauptstudium, aber auch an Praktiker in Banken und Versicherungen. Es ist sehr gut zum Selbststudium geeignet. Kenntnisse der Mathematik und Statistik werden nur soweit vorausgesetzt, wie sie im wirtschaftswissenschaftlichen Grundstudium vermittelt werden.

Autokorrelationen in der historischen Simulation

Analyse der autokorrelationsarmen Abbildung von Zinsänderungsrisiken

Author: Noel Boka

Publisher: Springer-Verlag

ISBN: 3658211083

Category: Business & Economics

Page: 113

View: 6208

DOWNLOAD NOW »

Ausgehend von der Definition und Vorstellung barwertiger Konzepte der Zinsrisikomessung führt Noel Boka durch die Problematik von Autokorrelationen in der historischen Simulation. Nach der Verknüpfung der grundlegenden statistischen Eigenschaften mit der praktischen Anwendung folgt eine umfassende empirische Analyse zu den verschiedenen Ausprägungen und Einflussfaktoren. So kann zusammengefasst werden, dass die Differenzenmethode eine ausreichende Prognosegüte gewährleistet. Für niveauunabhängige Verfahren kann hingegen ein Kausalzusammenhang aus geminderter Prognosegüte und Autokorrelationen festgestellt werden.

Risikomanagement

Banken, Versicherungen und andere Finanzinstitutionen

Author: John Hull

Publisher: Pearson Deutschland GmbH

ISBN: 9783868940435

Category: Financial institutional

Page: 616

View: 6023

DOWNLOAD NOW »

Statistik mit Excel für Dummies

Author: Joseph Schmuller

Publisher: John Wiley & Sons

ISBN: 3527811702

Category: Computers

Page: 535

View: 7328

DOWNLOAD NOW »

Statistiken und Aussagen zu Wahrscheinlichkeiten begegnen uns heute überall: Die Umsatzentwicklung in Unternehmen, Hochrechnungen für Wahlergebnisse, PISA-Ergebnisse fünfzehnjähriger Schüler sind nur drei von zahlreichen Beispielen. Joseph Schmuller zeigt Ihnen in diesem Buch, wie Sie die Zahlen in den Griff bekommen und Daten, Statistiken und Wahrscheinlichkeiten richtig lesen und interpretieren. Dafür brauchen Sie keinen Statistikkurs zu belegen und kein Mathegenie zu sein. Für alles gibt es in Excel die passende Funktion und das passende Werkzeug. So können Sie Theorie und Praxis sofort miteinander verbinden.

Capital Asset Investment

Strategy, Tactics and Tools

Author: Anthony F. Herbst

Publisher: John Wiley & Sons

ISBN: 0470856408

Category: Business & Economics

Page: 334

View: 9693

DOWNLOAD NOW »

Providing a balanced and practical approach to capital management and budgeting, this book covers the full spectrum of capital investments, from the basics through the latest innovations. It is aimed at managers who are involved in capital investment decisions: setting company capital investment policy; performing project analyses; and drafting recommendations. Those in top management will benefit from discussions of strong and weak points of various methods and concepts. Included in the arsenal of capital investment tools in this book are concepts of proven usefulness, such as the MAPI method, no longer available in other works on the topic of capital budgeting, and other topics not covered elsewhere, such as abandonment analysis.

Financial Modeling

Author: Sebastian Prexl,Michael Bloss,Dietmar Ernst,Christoph Haas,Joachim Häcker,Bernhard Röck

Publisher: N.A

ISBN: 9783791035413

Category:

Page: 640

View: 9998

DOWNLOAD NOW »

Practical Portfolio Performance Measurement and Attribution

Author: Carl R. Bacon

Publisher: John Wiley & Sons

ISBN: 0470856807

Category: Business & Economics

Page: 240

View: 9772

DOWNLOAD NOW »

Practical Performance Measurement and Attribution provides a clear introduction to the subject of performance measurement. Focusing more on the practical use and calculation of performance returns rather than the academic background it will help readers gain a clear understanding of the role and implications of performance measurement in today's financial environment. "Carl’s book is a ‘must have’ resource - the complete A to Z of the increasingly complex field of performance measurement." Glenn Solomon, Global Head of Institutional Clients, Investment Reporting & Performance, BNP Paribas Securities Services "Internationally renowned authority Carl Bacon has provided what one would expect – an exceptionally well written and practical resource that every investment performance measurement professional should own." David Spaulding, President, The Spaulding Group "Carl Bacon is one of the most knowledgeable professionals I know on the subject of Performance Measurement. He has been a pioneer, leader, and teacher at the forefront of developments in global investment performance standards, performance attribution technique, and risk measurement. I am very pleased he has written this timely and useful book as a complete reference and explanation update on these important subjects." James Hollis, Managing Director, Cutter Associates "Though the subject matter is complex, Carl strikes the right balance between theory and reality. This book should have a permanent spot on the desk of every performance practitioner. I will refer to it often." Karyn Vincent, CFA, Vincent Performance Services LLC "Whether you are a provider or a user of Performance Analysis, this book is well structured, informative and truly a practical guide in every sense." Gary Hilldrup, Global Head Performance, Risk & Client Reporting, Fortis Investments

Excel 2002 für Dummies

Author: Greg Harvey

Publisher: Wiley-VCH

ISBN: 9783527700523

Category: Computers

Page: 352

View: 7341

DOWNLOAD NOW »

Sie haben keine blasse Ahnung von Tabellenkalkulationen, möchten aber Ihre Zahlen endlich in den Griff bekommen? Oder zählen Sie zu diesen Excel-begeisterten Buchhaltern, die mit Spannung auf die neuen Features der 2002er Version warten, um Ihren Chef mal wieder zu beeindrucken? In diesem Buch führt Sie Greg Harvey Schritt für Schritt in die Welt der Tabellen-kalkulation ein und demonstriert Ihnen das grandiose Organisationstalent von Excel 2002: unterschiedliche Datentypen zusammenstellen, Berechnungen durchführen, anschauliche Diagramme fabrizieren. Sie erfahren: * Wo der Unterschied zwischen Arbeitsmappen und Arbeitsblättern liegt * Wie Sie Ihre eigenen Tabellenblätter erstellen, bearbeiten, formatieren und drucken * Wie Sie aus Excel direkt Tabellen, Arbeitsblätter und Mappen per E-Mail versenden können * Wie Sie Ihre Excel-Tabelle auf der Website Ihres Unternehmens veröffentlichen * Welche neuen Features Excel 2002 zu bieten hat: ClipArts in Ihr Tabellenblatt einfügen, Webseiten in Excel bearbeiten u.v.a.m. * Wie Sie Daten und Texte aus allen Office XP-Programmen in Ihr Excel-Sheet integrieren

Implementing Models of Financial Derivatives

Object Oriented Applications with VBA

Author: Nick Webber

Publisher: John Wiley & Sons

ISBN: 0470661844

Category: Business & Economics

Page: 692

View: 9168

DOWNLOAD NOW »

Implementing Models of Financial Derivatives is a comprehensive treatment of advanced implementation techniques in VBA for models of financial derivatives. Aimed at readers who are already familiar with the basics of VBA it emphasizes a fully object oriented approach to valuation applications, chiefly in the context of Monte Carlo simulation but also more broadly for lattice and PDE methods. Its unique approach to valuation, emphasizing effective implementation from both the numerical and the computational perspectives makes it an invaluable resource. The book comes with a library of almost a hundred Excel spreadsheets containing implementations of all the methods and models it investigates, including a large number of useful utility procedures. Exercises structured around four application streams supplement the exposition in each chapter, taking the reader from basic procedural level programming up to high level object oriented implementations. Written in eight parts, parts 1-4 emphasize application design in VBA, focused around the development of a plain Monte Carlo application. Part 5 assesses the performance of VBA for this application, and the final 3 emphasize the implementation of a fast and accurate Monte Carlo method for option valuation. Key topics include: ?Fully polymorphic factories in VBA; ?Polymorphic input and output using the TextStream and FileSystemObject objects; ?Valuing a book of options; ?Detailed assessment of the performance of VBA data structures; ?Theory, implementation, and comparison of the main Monte Carlo variance reduction methods; ?Assessment of discretization methods and their application to option valuation in models like CIR and Heston; ?Fast valuation of Bermudan options by Monte Carlo. Fundamental theory and implementations of lattice and PDE methods are presented in appendices and developed through the book in the exercise streams. Spanning the two worlds of academic theory and industrial practice, this book is not only suitable as a classroom text in VBA, in simulation methods, and as an introduction to object oriented design, it is also a reference for model implementers and quants working alongside derivatives groups. Its implementations are a valuable resource for students, teachers and developers alike. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Ökonometrie für Dummies

Author: Roberto Pedace

Publisher: John Wiley & Sons

ISBN: 3527801529

Category: Business & Economics

Page: 388

View: 8935

DOWNLOAD NOW »

Theorien verstehen und Techniken anwenden Was haben die Gehälter von Spitzensportlern und der Mindestlohn gemeinsam? Richtig, man kann sie mit Ökonometrie erforschen. Im Buch steht, wie es geht. Und nicht nur dafür, sondern für viele weitere Gebiete lohnt es sich, der zunächst etwas trocken und sperrig anmutenden Materie eine Chance zu geben. Lernen Sie von den Autoren, wie Sie spannende Fragen formulieren, passende Variablen festlegen, treffsichere Modelle entwerfen und Ihre Aussagen auf Herz und Nieren prüfen. Werden Sie sicher im Umgang mit Hypothesentests, Regressionsmodellen, Logit- & Probit-Modellen und allen weiteren gängigen Methoden der Ökonometrie. So begleitet Ökonometrie für Dummies Sie Schritt für Schritt und mit vielen Beispielen samt R Output durch dieses spannende Thema.