# Financial Simulation Modeling in Excel, + Website: A Step-by-Step Guide

## Keith A. Allman; Josh Laurito; Michael Loh

5 valoración promedio
( 1 valoraciones por Goodreads )

"I've worked with simulation in business for over 20 years, and Allman really nails it with this book. I admit that I own his previous book on structured finance cash flows, but I was surprised by what I found in here. He addresses the fundamental questions of how decision makers react to simulations and his read was very much in accordance with what I've experienced myself. When it came to the nuts and bolts of describing the different types of simulation analysis the book becomes incredibly detailed. There is working code and models for a fantastic array of the most common simulation problems. If you're so inclined, the book very carefully steps through the tricky math needed to really understand the theory behind stochastic modeling in finance. If you're preparing models that include any kind of randomization or stochastic modeling component, this book is a must-read, a tremendous value and time-saver." — David Brode of The Brode Group

A practical guide to understanding and implementing financial simulation modeling

As simulation techniques become more popular among the financial community and a variety of sub-industries, a thorough understanding of theory and implementation is critical for practitioners involved in portfolio management, risk management, pricing, and capital budgeting. Financial Simulation Modeling in Excel contains the information you need to make the most informed decisions possible in your professional endeavors.

Financial Simulation Modeling in Excel contains a practical, hands-on approach to learning complex financial simulation methodologies using Excel and VBA as a medium. Crafted in an easy to understand format, this book is suitable for anyone with a basic understanding of finance and Excel. Filled with in-depth insights and expert advice, each chapter takes you through the theory behind a simulation topic and the implementation of that same topic in Excel/VBA in a step-by-step manner.

• Organized in an easy-to-follow fashion, this guide effectively walks you through the process of creating and implementing risk models in Excel
• A companion website contains all the Excel models risk experts and quantitative analysts need to practice and confirm their results as they progress
• Keith Allman is the author of other successful modeling books, including Corporate Valuation Modeling and Modeling Structured Finance Cash Flows with Microsoft Excel

Created for those with some background in finance and experience in Excel, this reliable resource shows you how to effectively perform sound financial simulation modeling, even if you've yet to do extensive modeling up to this point in your professional or academic career.

"Sinopsis" puede pertenecer a otra edición de este libro.

From the Back Cover:

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

"Sobre este título" puede pertenecer a otra edición de este libro.

Comprar nuevo Ver libro
EUR 52,26

Gastos de envío: EUR 2,95

Destinos, gastos y plazos de envío

## 1.Financial Simulation Modeling in Excel: A Step-by-Step Guide, + Website Format: Paperback

Editorial: John Wiley and Sons
ISBN 10: 0470931221 ISBN 13: 9780470931226
Librería
INDOO
(Avenel, NJ, Estados Unidos de America)
Valoración

Descripción John Wiley and Sons. Estado de conservación: New. Brand New. Nº de ref. de la librería 0470931221

Comprar nuevo
EUR 52,26
Convertir moneda
Gastos de envío: EUR 2,95
Destinos, gastos y plazos de envío

## 2.Financial Simulation Modeling in Excel: A Step-by-step Guide + Website (Mixed media product)

Editorial: John Wiley and Sons Ltd, United Kingdom (2011)
ISBN 10: 0470931221 ISBN 13: 9780470931226
Librería
The Book Depository US
(London, Reino Unido)
Valoración

Comprar nuevo
EUR 78,23
Convertir moneda
Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

## 3.Financial Simulation Modeling in Excel, + Website: A Step-by-Step Guide

Editorial: Wiley (2011)
ISBN 10: 0470931221 ISBN 13: 9780470931226
Librería
Murray Media
(North Miami Beach, FL, Estados Unidos de America)
Valoración

Descripción Wiley, 2011. Paperback. Estado de conservación: New. Never used!. Nº de ref. de la librería P110470931221

Comprar nuevo
EUR 78,13
Convertir moneda
Gastos de envío: EUR 1,68
Destinos, gastos y plazos de envío

## 4.Financial Simulation Modeling in Excel: A Step-by-step Guide + Website (Mixed media product)

Editorial: John Wiley and Sons Ltd, United Kingdom (2011)
ISBN 10: 0470931221 ISBN 13: 9780470931226
Librería
Book Depository hard to find
(London, Reino Unido)
Valoración

Comprar nuevo
EUR 80,15
Convertir moneda
Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

## 5.Financial Simulation Modeling in Excel

Editorial: John Wiley and#38; Sons (2011)
ISBN 10: 0470931221 ISBN 13: 9780470931226
Librería
Books2Anywhere
(Fairford, GLOS, Reino Unido)
Valoración

Descripción John Wiley and#38; Sons, 2011. PAP. Estado de conservación: New. New Book. Shipped from UK in 4 to 14 days. Established seller since 2000. Nº de ref. de la librería FW-9780470931226

Comprar nuevo
EUR 76,58
Convertir moneda
Gastos de envío: EUR 10,00
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

## 6.Financial Simulation Modeling in Excel: A Step-by-step Guide + Website (Mixed media product)

Editorial: John Wiley and Sons Ltd, United Kingdom (2011)
ISBN 10: 0470931221 ISBN 13: 9780470931226
Librería
The Book Depository
(London, Reino Unido)
Valoración

Comprar nuevo
EUR 86,78
Convertir moneda
Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

## 7.Financial Simulation Modeling in Excel, + Website: A Step-by-Step Guide

Editorial: Wiley
ISBN 10: 0470931221 ISBN 13: 9780470931226
Librería
Cloud 9 Books
(Wellington, FL, Estados Unidos de America)
Valoración

Descripción Wiley. PAPERBACK. Estado de conservación: New. 0470931221 New Condition. Nº de ref. de la librería NEW7.1110637

Comprar nuevo
EUR 84,74
Convertir moneda
Gastos de envío: EUR 4,21
Destinos, gastos y plazos de envío

## 8.Financial Simulation Modeling in Excel

Editorial: Wiley 2011-11-11, Hoboken, N.J. (2011)
ISBN 10: 0470931221 ISBN 13: 9780470931226
Librería
Blackwell's
(Oxford, OX, Reino Unido)
Valoración

Descripción Wiley 2011-11-11, Hoboken, N.J., 2011. paperback. Estado de conservación: New. Nº de ref. de la librería 9780470931226

Comprar nuevo
EUR 88,02
Convertir moneda
Gastos de envío: EUR 6,66
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

## 9.Financial Simulation Modeling in Excel: A Step-by-step Guide + Website (Wiley Finance)

Editorial: John Wiley & Sons
ISBN 10: 0470931221 ISBN 13: 9780470931226
Librería
THE SAINT BOOKSTORE
(Southport, Reino Unido)
Valoración

Descripción John Wiley & Sons. Paperback. Estado de conservación: New. New copy - Usually dispatched within 2 working days. Nº de ref. de la librería B9780470931226

Comprar nuevo
EUR 92,37
Convertir moneda
Gastos de envío: EUR 7,70
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

## 10.Financial Simulation Modeling in Excel, + Website: A Step-by-Step Guide (Wiley Finance)

Editorial: Wiley (2011)
ISBN 10: 0470931221 ISBN 13: 9780470931226
Librería
Ergodebooks
(RICHMOND, TX, Estados Unidos de America)
Valoración

Descripción Wiley, 2011. Paperback. Estado de conservación: New. 1. Nº de ref. de la librería DADAX0470931221

Comprar nuevo
EUR 105,77
Convertir moneda
Gastos de envío: EUR 3,37