Financial Analysis and Modeling Using Excel and VBA

Author: Chandan Sengupta
Publisher: John Wiley & Sons
ISBN: 047027560X
Category : Business & Economics
Languages : en
Pages : 822

Book Description
An updated look at the theory and practice of financial analysis and modeling Financial Analysis and Modeling Using Excel and VBA, Second Edition presents a comprehensive approach to analyzing financial problems and developing simple to sophisticated financial models in all major areas of finance using Excel 2007 and VBA (as well as earlier versions of both). This expanded and fully updated guide reviews all the necessary financial theory and concepts, and walks you through a wide range of real-world financial problems and models that you can learn from, use for practice, and easily adapt for work and classroom use. A companion website includes several useful modeling tools and fully working versions of all the models discussed in the book. Teaches financial analysis and modeling and illustrates advanced features of Excel and VBA, using a learn-by-doing approach Contains detailed coverage of the powerful features of Excel 2007 essential for financial analysis and modeling, such as the Ribbon interface, PivotTables, data analysis, and statistical analysis Other titles by Sengupta: Financial Modeling Using C++ and The Only Proven Road to Investment Success Designed for self-study, classroom use, and reference This comprehensive guide is an essential read for anyone who has to perform financial analysis or understand and implement financial models.

Advanced Modelling in Finance using Excel and VBA

Author: Mary Jackson
Publisher: John Wiley & Sons
ISBN: 0470061669
Category : Business & Economics
Languages : en
Pages : 278

Book Description
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
Languages : en
Pages : 680

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

Financial Modeling

Author: Simon Benninga
Publisher: MIT Press
ISBN: 9780262024822
Category : Business & Economics
Languages : en
Pages : 648

Book Description
Too often, finance courses stop short of making a connection between textbook finance and the problems of real-world business. "Financial Modeling" bridges this gap between theory and practice by providing a nuts-and-bolts guide to solving common financial problems with spreadsheets. The CD-ROM contains Excel* worksheets and solutions to end-of-chapter exercises. 634 illustrations.

Option Pricing Models and Volatility Using Excel-VBA

Author: Fabrice D. Rouah
Publisher: John Wiley & Sons
ISBN: 1118429206
Category : Business & Economics
Languages : en
Pages : 456

Book Description
This comprehensive guide offers traders, quants, and students the tools and techniques for using advanced models for pricing options. The accompanying website includes data files, such as options prices, stock prices, or index prices, as well as all of the codes needed to use the option and volatility models described in the book. Praise for Option Pricing Models & Volatility Using Excel-VBA "Excel is already a great pedagogical tool for teaching option valuation and risk management. But the VBA routines in this book elevate Excel to an industrial-strength financial engineering toolbox. I have no doubt that it will become hugely successful as a reference for option traders and risk managers." —Peter Christoffersen, Associate Professor of Finance, Desautels Faculty of Management, McGill University "This book is filled with methodology and techniques on how to implement option pricing and volatility models in VBA. The book takes an in-depth look into how to implement the Heston and Heston and Nandi models and includes an entire chapter on parameter estimation, but this is just the tip of the iceberg. Everyone interested in derivatives should have this book in their personal library." —Espen Gaarder Haug, option trader, philosopher, and author of Derivatives Models on Models "I am impressed. This is an important book because it is the first book to cover the modern generation of option models, including stochastic volatility and GARCH." —Steven L. Heston, Assistant Professor of Finance, R.H. Smith School of Business, University of Maryland

Hedge Fund Modelling and Analysis Using Excel and VBA

Author: Paul Darbyshire
Publisher: John Wiley & Sons
ISBN: 111994564X
Category : Business & Economics
Languages : en
Pages : 294

Book Description
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.

Modeling Structured Finance Cash Flows with Microsoft Excel

Author: Keith A. Allman
Publisher: John Wiley & Sons
ISBN: 1118044665
Category : Business & Economics
Languages : en
Pages : 230

Book Description
A practical guide to building fully operational financial cash flow models for structured finance transactions Structured finance and securitization deals are becoming more commonplace on Wall Street. Up until now, however, market participants have had to create their own models to analyze these deals, and new entrants have had to learn as they go. Modeling Structured Finance Cash Flows with Microsoft Excel provides readers with the information they need to build a cash flow model for structured finance and securitization deals. Financial professional Keith Allman explains individual functions and formulas, while also explaining the theory behind the spreadsheets. Each chapter begins with a discussion of theory, followed by a section called "Model Builder," in which Allman translates the theory into functions and formulas. In addition, the companion website features all of the modeling exercises, as well as a final version of the model that is created in the text. Note: Companion website and other supplementary materials are not included as part of eBook file.

Financial Applications using Excel Add-in Development in C / C++

Author: Steve Dalton
Publisher: John Wiley & Sons
ISBN: 0470027975
Category : Business & Economics
Languages : en
Pages : 586

Book Description
Financial Applications using Excel Add-in Development in C/C++ is a must-buy book for any serious Excel developer.Excel is the industry standard for financial modelling, providing a number of ways for users to extend the functionality of their own add-ins, including VBA and C/C++. This is the only complete how-to guide and reference book for the creation of high performance add-ins for Excel in C and C++ for users in the finance industry. Steve Dalton explains how to apply Excel add-ins to financial applications with many examples given throughout the book. It also covers the relative strengths and weaknesses of developing add-ins for Excel in VBA versus C/C++, and provides comprehensive code, workbooks and example projects on the accompanying CD-ROM. The impact of Excel 2007’s multi-threaded workbook calculations and large grids on add-in development are fully explored. Financial Applications using Excel Add-in Development in C/C++ features: Extensive example codes in VBA, C and C++, explaining all the ways in which a developer can achieve their objectives. Example projects that demonstrate, from start to finish, the potential of Excel when powerful add-ins can be easily developed. Develops the readers understanding of the relative strengths and weaknesses of developing add-ins for Excel in VBA versus C/C++. A CD-ROM with several thousand lines of example code, numerous workbooks, and a number of complete example projects.

Corporate Valuation Modeling

Author: Keith A. Allman
Publisher: John Wiley & Sons
ISBN: 0470579374
Category : Business & Economics
Languages : en
Pages : 389

Book Description
A critical guide to corporate valuation modeling Valuation is at the heart of everything that Wall Street does. Every day, millions of transactions to purchase or sell companies take place based on prices created by the activities of all market participants. In this book, author Keith Allman provides you with a core model to value companies. Corporate Valuation Modeling takes you step-by-step through the process of creating a powerful corporate valuation model. Each chapter skillfully discusses the theory of the concept, followed by Model Builder instructions that inform you of every step necessary to create the template model. Many chapters also include a validation section that shows techniques and implementations that you can employ to make sure the model is working properly. Walks you through the full process of constructing a fully dynamic corporate valuation model A Tool Box section at the end of each chapter assists readers who may be less skilled in Excel techniques and functions Complete with a companion CD-ROM that contains constructed models, this book is an essential guide to understanding the intricacies of corporate valuation modeling. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Operational Risk with Excel and VBA

Author: Nigel Da Costa Lewis
Publisher: John Wiley & Sons
ISBN: 9780471478874
Category : Business & Economics
Languages : en
Pages : 296

Book Description
A valuable reference for understanding operational risk Operational Risk with Excel and VBA is a practical guide that only discusses statistical methods that have been shown to work in an operational risk management context. It brings together a wide variety of statistical methods and models that have proven their worth, and contains a concise treatment of the topic. This book provides readers with clear explanations, relevant information, and comprehensive examples of statistical methods for operational risk management in the real world. Nigel Da Costa Lewis (Stamford, CT) is president and CEO of StatMetrics, a quantitative research boutique. He received his PhD from Cambridge University.