Financial Modeling
FINANCIAL MODELING
The materials in this book are intended for instructional and educational purposes, to illustrate situations similar to those encountered in the real world. The reader will understand that MIT Press and its authors do not guarantee the accuracy or completeness of any information published in this book. Neither MIT Press nor its authors is responsible for the consequences of the implementation of models or information presented in this book.
FINANCIAL MODELING
Simon Benninga
with a section on Visual Basic for Applications by Benjamin Czaczkes
THIRD EDITION
The MIT Press Cambridge, Massachusetts London, England
© 2008 Massachusetts Institute of Technology All rights reserved. No part of this book may be reproduced in any form by any electronic or mechanical means (including photocopying, recording, or information storage and retrieval) without permission in writing from the publisher. This book was set in Times Roman by SNP Best-set Typesetter Ltd., Hong Kong, and was printed and bound in the United States of America. Library of Congress Cataloging-in-Publication Data Benninga, Simon. Financial modeling / Simon Benninga.—3rd ed. p. cm. Includes bibliographical references and index. ISBN 978-0-262-02628-4 1. Finance—Mathematical models. I. Title. HG173.B46 2008 332.01′5118—dc22 2007038629 10 9 8 7 6
To our parents: Helen and Noach Benninga; Esther and Alfred Czaczkes
Contents
Preface Preface to the Second Edition Preface to the First Edition I 1 Corporate Finance Models Basic Financial Calculations 1.1 Overview 1.2 Present Value and Net Present Value 1.3 Internal Rate of Return and Loan Tables 1.4 Multiple Internal Rates of Return 1.5 Flat Payment Schedules 1.6 Future Values and Applications 1.7 A Pension Problem—Complicating the Future-Value Problem 1.8 Continuous Compounding 1.9 Discounting Using Dated Cash Flows Exercises Calculating the Cost of Capital 2.1 Overview 2.2 The Gordon Dividend Model 2.3 Adjusting
The materials in this book are intended for instructional and educational purposes, to illustrate situations similar to those encountered in the real world. The reader will understand that MIT Press and its authors do not guarantee the accuracy or completeness of any information published in this book. Neither MIT Press nor its authors is responsible for the consequences of the implementation of models or information presented in this book.
FINANCIAL MODELING
Simon Benninga
with a section on Visual Basic for Applications by Benjamin Czaczkes
THIRD EDITION
The MIT Press Cambridge, Massachusetts London, England
© 2008 Massachusetts Institute of Technology All rights reserved. No part of this book may be reproduced in any form by any electronic or mechanical means (including photocopying, recording, or information storage and retrieval) without permission in writing from the publisher. This book was set in Times Roman by SNP Best-set Typesetter Ltd., Hong Kong, and was printed and bound in the United States of America. Library of Congress Cataloging-in-Publication Data Benninga, Simon. Financial modeling / Simon Benninga.—3rd ed. p. cm. Includes bibliographical references and index. ISBN 978-0-262-02628-4 1. Finance—Mathematical models. I. Title. HG173.B46 2008 332.01′5118—dc22 2007038629 10 9 8 7 6
To our parents: Helen and Noach Benninga; Esther and Alfred Czaczkes
Contents
Preface Preface to the Second Edition Preface to the First Edition I 1 Corporate Finance Models Basic Financial Calculations 1.1 Overview 1.2 Present Value and Net Present Value 1.3 Internal Rate of Return and Loan Tables 1.4 Multiple Internal Rates of Return 1.5 Flat Payment Schedules 1.6 Future Values and Applications 1.7 A Pension Problem—Complicating the Future-Value Problem 1.8 Continuous Compounding 1.9 Discounting Using Dated Cash Flows Exercises Calculating the Cost of Capital 2.1 Overview 2.2 The Gordon Dividend Model 2.3 Adjusting