E-Book Overview
Financial Modeling for Managers is a do-it-yourself guide to the instruments, equations and analysis of financial markets. Designed for both dealing room and classroom, it is a highly accessible reference for practitioners and students of finance. Numerous examples are provided on pricing, hedging, yield curve analysis, portfolio selection and other topics, together with detailed "how-to" models in Excel. It is currently used as an industry reference and as a university companion text for undergraduate and graduate courses in Financial Markets and Instruments, Financial Institutions Management, Portfolio Design & Investments, Treasury Management & Derivatives. This is a book to use, rather than park on the shelf!"
E-Book Content
with Excel® applications
second edition
Dawn E. Lorimer Charles R. Rayhorn
Copyright 2002 by Authors Academic Press Financial Modeling for Managers with Excel Applications All rights reserved. Previous edition copyright 1999 by Dunmore Press Limited. Printed in the United States of America. Except as permitted under the United States Copyright Act of 1976, no part of this publication may be reproduced or distributed in any form or by any means, or stored in a data base or retrieval system, without the prior written permission of the publisher. ISBN 0-9703333-1-5 Acquisition Editors: Trond Randoy, Jon Down, Don Herrmann Senior Production Manager: Cynthia Leonard Layout Support: Rebecca Herschell Marketing Manager: Nada Down Copyeditor: Michelle Abbott Cover Design: Tom Fenske and Cynthia Leonard Cover Photo: London Dealing Room. Courtesy National Australia Bank, London. Printer: EP Imaging Concepts Acknowledgments Robert Miller—Northern Michigan University, Michael G. Erickson—Albertson College, and Jacquelynne McLellan—Frostburg State University all contributed greatly to the production of this book through their thoughtfu