Financial Simulation Modeling in Excel
Guardado en:
| Autor principal: | |
|---|---|
| Otros Autores: | , |
| Publicado: |
John Wiley & Sons, Incorporated
|
| Materias: | |
| Acceso en línea: | Full Text - Ebook |
| Etiquetas: |
Sin Etiquetas, Sea el primero en etiquetar este registro!
|
MARC
| LEADER | 00000nab a2200000uu 4500 | ||
|---|---|---|---|
| 001 | 2131189419 | ||
| 003 | UK-CbPIL | ||
| 020 | |a 9781118137222 | ||
| 035 | |a 2131189419 | ||
| 045 | 0 | |b d20111011 | |
| 100 | 1 | |a Allman, Keith A | |
| 245 | 1 | |a Financial Simulation Modeling in Excel | |
| 260 | |a US |b John Wiley & Sons, Incorporated |c Oct 11, 2011 | ||
| 513 | |a Book | ||
| 520 | 3 | |a As simulation techniques become more prominent within the financial community, a thorough understanding of the theory behind, and implementation of, those techniques is critical for those involved in portfolio management, risk management, pricing, and other essential financial activities. Created by the expert author team of Keith Allman, Josh Laurito, and Michael Loh, Financial Simulation Modeling in Excel contains valuable theoretical insights as well as practical exercises that will help you transform financial concepts into dynamic, usable models. And because simulation has its place in many different parts of finance, this well-rounded resource takes you step by step through the process of creating multiple, smaller models--using Microsoft® Excel® and VBA--as opposed to a single unified model. Each section begins with a discussion of theory--with enough background and mathematical formulas provided to reinforce the concept covered--and then moves on to a Model Builder exercise where the theory is transferred to an application in Microsoft® Excel®. Along the way, this accessible guide: Works through random number generation, explains Brownian motion, and explores correlation between variables with specific examples Takes you through simulating interest rate paths to price bonds Creates a corporate default simulation based on structural and reduced form models Provides a thorough look at simulating pools of assets Addresses data deficiencies and how to manage data as it relates to a simulation Complete with a companion website that contains information including Model Builder files, this book is an essential guide--for both seasoned professionals and those new to the world of financial simulation modeling--to understanding the intricacies of this discipline and excelling at it. As simulation techniques become more prominent within the financial community, a thorough understanding of the theory behind, and implementation of, those techniques is critical for those involved in portfolio management, risk management, pricing, and other essential financial activities. Created by the expert author team of Keith Allman, Josh Laurito, and Michael Loh, Financial Simulation Modeling in Excel contains valuable theoretical insights as well as practical exercises that will help you transform financial concepts into dynamic, usable models. And because simulation has its place in many different parts of finance, this well-rounded resource takes you step by step through the process of creating multiple, smaller models--using Microsoft® Excel® and VBA--as opposed to a single unified model. Each section begins with a discussion of theory--with enough background and mathematical formulas provided to reinforce the concept covered--and then moves on to a Model Builder exercise where the theory is transferred to an application in Microsoft® Excel®. Along the way, this accessible guide: Works through random number generation, explains Brownian motion, and explores correlation between variables with specific examples Takes you through simulating interest rate paths to price bonds Creates a corporate default simulation based on structural and reduced form models Provides a thorough look at simulating pools of assets Addresses data deficiencies and how to manage data as it relates to a simulation Complete with a companion website that contains information including Model Builder files, this book is an essential guide--for both seasoned professionals and those new to the world of financial simulation modeling--to understanding the intricacies of this discipline and excelling at it. Keith A. Allman is an investment manager at Bamboo Finance, a private equity fund that invests in for-profit, commercially viable companies that provide a good or service that beneficially impacts the lives of low-income individuals. Previously, he was the director of analytics and modeling at Pearl Street Capital Group. Allman also founded Enstruct, which services clients worldwide in capital markets and equity valuation, distressed valuation, and quantitative-based training. He is the author of the Wiley titles Corporate Valuation Modeling, Modeling Structured Finance Cash Flows with Microsoft® Excel®, and Reverse Engineering Deals on Wall Street with Microsoft® Excel®. Allman holds bachelor degrees from UCLA and a master's degree from Columbia University. Josh Laurito, CFA, is a co-founder and Principal of Lumesis, a leading provider of credit analysis software and solutions to the municipal finance market. In addition, he directs corporate modeling for Hexagon Securities, a boutique merchant bank that advises and invests in banks and specialty finance companies. MichaelL Loh currently works for Tech-X Corporation where he is actively engaged in complex data management and high-performance computing using accelerated hardware. Prior to Tech-X, Loh developed and implemented financial models at RangeMark Financial Services | |
| 653 | |a Finance companies | ||
| 653 | |a Simulation | ||
| 653 | |a Computers | ||
| 653 | |a Valuation | ||
| 653 | |a Spreadsheets | ||
| 653 | |a Brownian motion | ||
| 653 | |a Economic conditions | ||
| 653 | |a Finance | ||
| 653 | |a Finance -- Mathematical models -- Computer programs | ||
| 653 | |a Microsoft Excel (Computer file) ; Finance -- Mathematical models -- Computer programs. | ||
| 653 | |a Business conditions | ||
| 653 | |a Professionals | ||
| 653 | |a Interest rates | ||
| 653 | |a Risk management | ||
| 653 | |a Merchant banks | ||
| 653 | |a Microsoft Excel (Computer file) | ||
| 653 | |a Office software | ||
| 653 | |a Portfolio management | ||
| 700 | 1 | |a Laurito, Josh | |
| 700 | 1 | |a Loh, Michael | |
| 773 | 0 | |t Financial Simulation Modeling in Excel |g (Oct 11, 2011) | |
| 786 | 0 | |d ProQuest |t Ebook Central | |
| 856 | 4 | 0 | |3 Full Text - Ebook |u https://www.proquest.com/docview/2131189419//embedded/L8HZQI7Z43R0LA5T?source=fedsrch |