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

by Allman, Keith A.; Laurito, Josh; Loh, Michael

• ISBN13: 9780470931226
• ISBN10: 0470931221
• Edition: 1st
• Format: Paperback
• Copyright: 2011-10-11
• Publisher: Wiley

Summary

Presents modern CMOS logic circuits, fabrication, and layout in a cohesive manner that links the material together with the system-level considerations. Chapter on Verilog HDL allows for rapid start-up. Illustrates the top-down design procedure used in modern VLSI chip design with an emphasis on variations in the HDL, logic, circuits and layout.

Author Biography

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

Table of Contents

Preface	p. vii
Acknowledgments	p. xi
About the Authors	p. xiii
Introduction	p. 1
Random Numbers, Distributions, and Basic Simulation Setup	p. 13
Correlation	p. 47
Option Pricing	p. 65
Corporate Default Simulation	p. 95
Simulating Pools of Assets	p. 127
Dealing with Data Deficiencies and Other Issues	p. 153
Advanced Topics and Further Reading	p. 169
Partial Differential Equations	p. 175
Newton-Raphson Method	p. 183
References	p. 187
Index	p. 189
Table of Contents provided by Ingram. All Rights Reserved.