Spreadsheet Modeling in Corporate Finance [With CDROM]

by Craig W. Holden

Book Overview

This supplementary text/CD-ROM, written to be used with any primary text, shows how to build financial models in Excel, with material progressing from simple examples to complex real-world applications and spanning most quantitative models in corporate finance. Emphasis is on examples, problems, and hands-on learning. Chapters are in sections on th

• Format: Paperback
• Language: English
• ISBN: 0130675237
• ISBN13: 9780130675231
• Release Date: December 2001
• Publisher: Prentice Hall
• Length: 160 Pages
• Weight: 0.98 lbs.
• Dimensions: 0.4" x 8.3" x 10.8"

Customer Reviews

Good book

Hi, I just finished the book. It is worth every dollar spent on it. If you are buying, get the second edition because the first is packed with typos. This book serves two purposes: 1. It teaches you how to use Excel 2. It is a great practical review of corporate finance and it does a great job in both aspects

The Second Edition is Better

Hi, I am Craig W. Holden, author of "Spreadsheet Modeling in Corporate Finance" (the first edition). I just want to let you know that the second edition of this book is now available. It has been retitled as "Excel Modeling in Corporate Finance Book and CD-ROM (2nd Edition)." It includes everything that was in the first edition plus some new content. All of the examples and data have been updated to the present and all known typos have been corrected. The second edition strictly dominates the first edition and I strongly recommend it. Click on my name at the top of the page to locate it. Thanks for your consideration.

Recommended by my Qualitative Methods teacher at NYU

Basic use of Excel for accounting methods. 5 stars only because I had to select something.

Excellent learning tool

Although intended as a supplement for textbooks used in college level business courses, this book is also valuable to working professionals who deal with financial modeling. Because I am a consultant and project manager I'm going to slant this review towards how my peers will benefit from the book. It's value outside of my narrow scope should be apparent.First, unlike other books that teach spreadsheet modeling, the spreadsheets that come on the CD ROM are not finished products. Instead the author has chosen spreadsheets that use dynamic charts to illustrate concepts in an interactive manner (drag a control to change the parameters and the chart changes - this is a powerful teaching tool in or out of the classroom).Second, the book needs to be read in sequence because spreadsheets you build in one chapter are the basis for refinements and added complexity in later chapters. This leads to highly complex spreadsheets, such as the model in chapter 16 (Life-Cycle Financial Planning), which incorporates tax parameters (federal and state levels), benefits analysis and other factors. In all there are 53 spreadsheets presented in this book, and you build them. The author calls this "active learning" (as opposed to passive learning where you are provided templates), and it is effective because you are the one who builds the models and tools while following the book. Note that this book does NOT purport to teach Excel programming, but how to build models using Excel's basic features and functions. As a consultant and project manager the parts of this book that were immediately useful to me were: Parts I (Time Value of Money), III (Capital Budgeting) and IV (Financial Planning). In particular, project management requires a thorough understanding of time value of money and capital budgeting, and the chapters in these sections should be read by anyone who is assigned as a project manager. Financial planning, especially from the perspective of IT asset management, is another knowledge area in which IT consultants should be well versed.The other parts of the book (II Valuation and V Options and Corporate Finance) will be more useful to finance professionals and general business managers. There is a collection of supporting material on the author's web site that augment this book, including spreadsheets that can be downloaded. Another plus for the working professional is the book is fast-paced and, dare I say, engrossing.