• Business & Economics

Financial Modeling Using Excel and VBA


Author: Chandan Sengupta
Publisher: John Wiley & Sons
ISBN: 9780471267683
Category: Business & Economics
Page: 857
View: 5307
"Reviews all the necessary financial theory and concepts, and walks you through a wide range of real-world financial models" - cover.

    • Business & Economics

Financial Analysis and Modeling Using Excel and VBA


Author: Chandan Sengupta
Publisher: John Wiley & Sons
ISBN: 047027560X
Category: Business & Economics
Page: 793
View: 4015
Provides a comprehensive guide for anyone who has to undertake financial analysis, or understand and implement financial models. Discusses a wide range of real-world financial problems and models using Excel 2007 and Visual Basic for Applications (VBA). Provides reference to earlier versions of Excel and VBA, and includes a CD-Rom with modelling tools and working versions of models discussed.

    • Business & Economics

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: 3845
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.

    • Business & Economics

Financial Modeling

An Introductory Guide to Excel and VBA Applications in Finance
Author: Joachim Häcker,Dietmar Ernst
Publisher: Springer
ISBN: 1137426586
Category: Business & Economics
Page: 956
View: 7361
This book provides a comprehensive introduction to modern financial modeling using Excel, VBA, standards of financial modeling and model review. It offers guidance on essential modeling concepts around the four core financial activities in the modern financial industry today: financial management; corporate finance; portfolio management and financial derivatives. Written in a highly practical, market focused manner, it gives step-by-step guidance on modeling practical problems in a structured manner. Quick and interactive learning is assured due to the structure as a training course which includes applied examples that are easy to follow. All applied examples contained in the book can be reproduced step by step with the help of the Excel files. The content of this book serves as the foundation for the training course Certified Financial Modeler. In an industry that is becoming increasingly complex, financial modeling is a key skill for practitioners across all key sectors of finance and banking, where complicated problems often need to be solved quickly and clearly. This book will equip readers with the basic modeling skills required across the industry today.

    • Business & Economics

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: 4790
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.

    • Business & Economics

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: 1096
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.

    • Business & Economics

Financial Modeling


Author: Simon Benninga,Benjamin Czaczkes
Publisher: MIT Press
ISBN: 0262027283
Category: Business & Economics
Page: 1144
View: 9720
A substantially revised edition of a bestselling text combining explanation and implementation using Excel; for classroom use or as a reference for finance practitioners.

    • Business & Economics

Financial Modeling Using C++


Author: Chandan Sengupta
Publisher: Wiley
ISBN: 9780471789086
Category: Business & Economics
Page: 565
View: 4117
A detailed look at developing real-world financial models using C++ This book, designed for self-study, reference, and classroom use, outlines a comprehensive approach to creating both simple and advanced financial models using C++. Author and modeling expert Chandan Sengupta covers programming, the C++ language, and financial modeling from the ground up-assuming no prior knowledge in these areas-and shows through numerous examples how to combine these skills with financial theory and mathematics to develop practical financial models. Since C++ is the computer language used most often to develop large-scale financial models and systems, readers will find this work-which includes a CD-ROM containing the models and codes from the book-an essential asset in their current modeling endeavors. Chandan Sengupta (White Plains, NY) teaches finance in the MBA program at the Fordham University Graduate School of Business. He is also the author of Financial Modeling Using Excel and VBA (0-471-26768-6).

    • Business & Economics

Financial Modeling in Excel For Dummies


Author: Danielle Stein Fairhurst
Publisher: John Wiley & Sons
ISBN: 111935756X
Category: Business & Economics
Page: 336
View: 7333
Make informed business decisions with the beginner's guide to financial modeling using Microsoft Excel Financial Modeling in Excel For Dummies is your comprehensive guide to learning how to create informative, enlightening financial models today. Not a math whiz or an Excel power-user? No problem! All you need is a basic understanding of Excel to start building simple models with practical hands-on exercises and before you know it, you'll be modeling your way to optimized profits for your business in no time. Excel is powerful, user-friendly, and is most likely already installed on your computer—which is why it has so readily become the most popular financial modeling software. This book shows you how to harness Excel's capabilities to determine profitability, develop budgetary projections, model depreciation, project costs, value assets and more. You'll learn the fundamental best practices and know-how of financial modeling, and how to put them to work for your business and your clients. You'll learn the tools and techniques that bring insight out of the numbers, and make better business decisions based on quantitative evidence. You'll discover that financial modeling is an invaluable resource for your business, and you'll wonder why you've waited this long to learn how! Companies around the world use financial modeling for decision making, to steer strategy, and to develop solutions. This book walks you through the process with clear, expert guidance that assumes little prior knowledge. Learn the six crucial rules to follow when building a successful financial model Discover how to review and edit an inherited financial model and align it with your business and financial strategy Solve client problems, identify market projections, and develop business strategies based on scenario analysis Create valuable customized templates models that can become a source of competitive advantage From multinational corporations to the mom-and-pop corner store, there isn't a business around that wouldn't benefit from financial modeling. No need to buy expensive specialized software—the tools you need are right there in Excel. Financial Modeling in Excel For Dummies gets you up to speed quickly so you can start reaping the benefits today!

    • Business & Economics

Financial Modelling and Asset Valuation with Excel


Author: Morten Helbæk,Ragnar Løvaas,Jon Olav Mjølhus
Publisher: Routledge
ISBN: 1134620276
Category: Business & Economics
Page: 448
View: 6286
Finance is Excel! This book takes you straight into the fascinating world of Excel, the powerful tool for number crunching. In a clear cut language it amalgamates financial theory with Excel providing you with the skills you need to build financial models for private or professional use. A comprehensive knowledge of modeling in Excel is becoming increasingly important in a competitive labour market. The chapters in part one start with the most basic Excel topics such as cell addresses, workbooks, basic formulas, etc. These chapters get more advanced through part one, and takes you in the end to topics such as array formulas, data tables, pivot tables, etc. The other parts of the book discusses a variety of subjects such as net present value, internal rate of return, risk, portfolio theory, CAPM, VaR, project valuation, asset valuation, firm valuation, loan, leasing, stocks, bonds, options, simulation, sensitivity analysis, etc.

    • Corporations

Financial Modelling in Practice

A Concise Guide for Intermediate and Advanced Level
Author: Michael Rees
Publisher: N.A
ISBN: 9781118374658
Category: Corporations
Page: 270
View: 1924
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. --From publisher's description.

    • Business & Economics

Business Risk and Simulation Modelling in Practice

Using Excel, VBA and @RISK
Author: Michael Rees
Publisher: John Wiley & Sons
ISBN: 1118904052
Category: Business & Economics
Page: 464
View: 1233
The complete guide to the principles and practice of risk quantification Risk analysis can enhance traditional financial modeling in any decision-related situation, and in some cases, is an indispensable part of the decision process. Business Risk and Simulation Modeling in Practice covers the principles and tools in depth, helping readers gain a greater understanding of effective application in real-world scenarios. This book provides a practical, comprehensive, and in-depth guide to the industry's fundamental principles and tools. Based on the author's many years in training and consultancy, this book provides real-life solutions to risk modeling applications, demonstrated with highly developed practical models that directly apply to real situations. Coverage includes the use of Excel and VBA, as well as in-depth guidance to Palisade's @RISK Excel add-in, which allows a richer range of models to be built more quickly, flexibly, and transparently. The underlying theory and statistical concepts of risk analysis are covered from a rigorous, yet practical perspective, with a non-mathematical focus accessible to a wide variety of readers. The companion website provides additional resources, including one hundred worked examples and preformatted spreadsheets. Understand the fundamental concepts and practices of risk analysis and modeling Master the use of Excel, VBA, and @RISK for dependency and correlation modeling Learn which distribution fits which scenario, and how to use it appropriately Examine example models to better understand the more complex concepts The quantification of risk is an increasingly important aspect of all forms of decision-making, and is a natural extension of general financial modeling. To be effective, professionals need a firm grasp of both the fundamental concepts and the tools of the trade. Business Risk and Simulation Modeling in Practice provides clear, complete guidance, enhanced with expert perspective.

    • Business & Economics

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: 5512
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 & Economics

Using Excel for Business Analysis

A Guide to Financial Modelling Fundamentals
Author: Danielle Stein Fairhurst
Publisher: John Wiley & Sons
ISBN: 1119062462
Category: Business & Economics
Page: 464
View: 1980
While there are many hundreds of tools, features and functions in Excel, this book focusses only on the ones it is critical for the Finance Business user to know. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. It is invaluable for anyone using Excel for Finance, as it helps them to do their jobs faster, more efficiently and with fewer errors. The book is organized into twelve chapters, arranged in order based on different aspects of Excel modelling. This book includes: -step-by-step instructions for how to use each feature that are detailed in a practical example -live models for readers to build it on their own accompanying excel worksheets downloadable via the website

    • Business & Economics

Professional Financial Computing Using Excel and VBA


Author: Donny C. F. Lai,Humphrey K. K. Tung,Michael C. S. Wong
Publisher: John Wiley & Sons
ISBN: 1118179080
Category: Business & Economics
Page: 350
View: 1551
"Professional Financial Computing Using Excel and VBA is an admirable exposition that bridges the theoretical underpinnings of financial engineering and its application which usually appears as a "black-box" software application. The book opens the black-box and reveals the architecture of risk-modeling and financial engineering based on industry-standard stochastic models by utilizing Excel and VBA functionality to create a robust and practical modeling tool-kit. Financial engineering professionals who purchase this book will have a jumpstart advantage for their customized financial engineering and modeling needs." Dr. Cameron Wicentowich Vice President, Treasury Analytics Canadian Imperial Bank of Commerce (CIBC) "Spreadsheet modeling for finance has become a standard course in the curriculum of many Quantitative Finance programs since the Excel-based Visual Basic programming is now widely used in constructing optimal portfolios, pricing structured products and managing risks. Professional Financial Computing Using Excel and VBA is written by a unique team of finance, physics and computer academics and practitioners. It is a good reference for those who are studying for a Masters degree in Financial Engineering and Risk Management. It can also be useful for financial engineers to jump-start a project on designing structured products, modeling interest term structure or credit risks." Dr. Jin Zhang Director of Master of Finance Program and Associate Professor The University of Hong Kong "Excel has been one of the most powerful tools for financial planning and computing over the last few years. Most users utilize a fraction of its capabilities. One of the reasons is the limited availability of books that cover the advanced features of Excel for Finance. Professional Financial Computing Using Excel and VBA goes the extra mile and deals with the Excel tools many professionals call for. This book is a must for professionals or students dealing with financial engineering, financial risk management, computational finance or mathematical finance. I loved the way the authors covered the material using real life, hands-on examples." Dr. Isaac Gottlieb Temple University Author, Next Generation Excel: Modeling in Excel for Analysts and MBAs

    • Business & Economics

Intermediate Structured Finance Modeling

Leveraging Excel, VBA, Access, and Powerpoint
Author: William Preinitz,Matthew Niedermaier
Publisher: John Wiley & Sons
ISBN: 0470928786
Category: Business & Economics
Page: 1032
View: 6211
This book provides a pragmatic, hands-on approach to reaching an intermediate level of sophistication as a financial modeler. Expanding on the first book, A Fast Tract to Structured Finance Modeling, Monitoring, and Valuation, the book will guide you step-by-step through using learned principals in new and more powerful applications. These applications will build on the knowledge of Excel and VBA gained, expand the use of Access for data management tasks, as well as PowerPoint and Outlook for reporting and presentation tasks.

    • Business & Economics

Structured Finance Modeling with Object-Oriented VBA


Author: Evan Tick
Publisher: John Wiley & Sons
ISBN: 1118160665
Category: Business & Economics
Page: 352
View: 1255
A detailed look at how object-oriented VBA should be used to model complex financial structures This guide helps readers overcome the difficult task of modeling complex financial structures and bridges the gap between professional C++/Java programmers writing production models and front-office analysts building Excel spreadsheet models. It reveals how to model financial structures using object-oriented VBA in an Excel environment, allowing desk-based analysts to quickly produce flexible and robust models. Filled with in-depth insight and expert advice, it skillfully illustrates the art of object-oriented programming for the explicit purpose of modeling structured products. Residential mortgage securitization is used as a unifying example throughout the text.

    • Business & Economics

Mastering Financial Modelling in Microsoft Excel 3rd edn

A Practitioner's Guide to Applied Corporate Finance
Author: Alastair Day
Publisher: Pearson UK
ISBN: 0273772341
Category: Business & Economics
Page: 520
View: 6121
Comprehensive tools and methods to help you build, develop and apply financial models using Microsoft Excel, enabling you to get better, more accurate results, faster. The new edition of this bestselling title begins by explaining basic modelling techniques before moving through to more complex models. The book is divided into two parts: the first part outlines model designs and gives templates, key features and techniques. The second part of the book shows how to build corporate financial models in Excel. This new edition includes a reworking of the book in Excel 2010 (but with older material still included), inclusion of Apple Mac, addition of specific 2010 features and end of chapter exercises. If you are buying the ebook, companion files can be downloaded from the digital downloads section of http://www.financial-models.com/.

    • Business & Economics

Building Financial Models with Microsoft Excel

A Guide for Business Professionals
Author: K. Scott Proctor
Publisher: John Wiley and Sons
ISBN: 9780470561454
Category: Business & Economics
Page: 352
View: 8214

    • Business & Economics

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: 7241
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.