文档介绍：Financial Modeling
Financial Modeling, Second Edition
Simon Benninga
Copyright © 2000 Massachusetts Institute of Technology
Financial Modeling
Simon Benninga
with a section on Visual Basic for Applications by Benjamin Czaczkes
SECOND EDITION
The MIT Press
Cambridge,MassachusettsLondon,England
© 2000 Massachusetts Institute of Technology
All rights reserved. No part of this book may be reproduced in any form by an electronic or mechanical means
(including photocopying, recording, or information storage and retrieval) without permission in writing from the
publisher.
Library of Congress Cataloging-in-Publication Data
Benninga, Simon,
Financial modeling / Simon Benninga; with a section on
Visual Basic for Applications by Benjamin Czaczkes.—2nd ed.
p. cm.
Includes bibliographical references and index.
ISBN 0-262-02482-9
1. Finance—Mathematical models. 2. Excel—Finance applications.
3. Microsoft Visual Basic for applications. I. Czaczkes, Benjamin.
II. Title.
HG173 .B46 2000
'5118—dc21 00-035473
Dedication
To our parents: Helen and Noach Benninga, Esther and Alfred Czaczkes
Books24x7, Inc. © 2001-2002 – Feedback
Preface
Financial Modeling, Second Edition
Simon Benninga
Copyright © 2000 Massachusetts Institute of Technology
Preface
The purpose of this book remains to provide a "cookbook" for mon financial models in Excel. This
edition has been expanded by six additional chapters, covering financial calculations, cost of capital, value at risk
(VaR), real options, early exercise boundaries, and term-structure modeling. There is also an additional technical
chapter containing a potpourri of Excel hints.
I am indebted to a number of people (in addition to those mentioned in the previous preface) for help and
suggestions: Yoni Aziz, Michael o Bertolino, Michael J. Clarke, Beni Daniel, Hector Tassinari Eldridge,
RazGilad, Doron Greenberg, Rick Labs, Allen Lee, Paul Legerer, Steve Rubin, Roger S