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: 4455

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.

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: 3331

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.

Risk Analysis

A Quantitative Guide

Author: David Vose

Publisher: John Wiley & Sons

ISBN: 0470512849

Category: Business & Economics

Page: 752

View: 8389

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.

Financial Modelling in Practice

A Concise Guide for Intermediate and Advanced Level

Author: Michael Rees

Publisher: Wiley

ISBN: 9780470997444

Category: Business & Economics

Page: 292

View: 4920

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.

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: 8205

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: 7756

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.

Excel-VBA für Dummies

Author: John Walkenbach

Publisher: John Wiley & Sons

ISBN: 3527709282

Category:

Page: 411

View: 1986

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, 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.

Finanzmarktstatistik

Author: Friedrich Schmid,Mark Matthias Trede

Publisher: Springer-Verlag

ISBN: 3540297952

Category: Business & Economics

Page: 267

View: 6987

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: 3767

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.

Excel 2002 für Dummies

Author: Greg Harvey

Publisher: Wiley-VCH

ISBN: 9783527700523

Category: Computers

Page: 352

View: 9531

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

Capital Asset Investment

Strategy, Tactics and Tools

Author: Anthony F. Herbst

Publisher: John Wiley & Sons

ISBN: 0470856408

Category: Business & Economics

Page: 334

View: 3303

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

Publisher: N.A

ISBN: 9783791028385

Category:

Page: 506

View: 4583

Nachvollziehbare Modelle zur Beurteilung komplexer Finanzprodukte. Die Autoren bieten Studenten einen anwendungsorientierten Leitfaden zu den zentralen Themenkomplexen Corporate Finance, Derivate und Portfoliomanagement. Zwei Workshops zu Microsoft Excel® und der Programmiersprache VBA® komplettieren das finanzwirtschaftliche Know-how. Der Kurscharakter des Buches und die praxisnahen Beispiele, die zusätzlich als Download-Angebot zur Verfügung stehen, ermöglichen ein schnelles und interaktives Lernen. Als Nachschlagewerk leistet der Band auch Praktikern wertvolle Dienste.

Statistik mit Excel für Dummies

Author: Joseph Schmuller

Publisher: John Wiley & Sons

ISBN: 3527811702

Category: Computers

Page: 535

View: 2301

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.

Practical Portfolio Performance Measurement and Attribution

Author: Carl R. Bacon

Publisher: John Wiley & Sons

ISBN: 0470856807

Category: Business & Economics

Page: 240

View: 5403

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 2007 VBA-Programmierung für Dummies

Author: John Walkenbach

Publisher: Wiley-VCH

ISBN: 9783527704118

Category: Computers

Page: 385

View: 6570

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.

Ökonometrie für Dummies

Author: Roberto Pedace

Publisher: John Wiley & Sons

ISBN: 3527801529

Category: Business & Economics

Page: 388

View: 7371

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.