Excel Modeling in Corporate Finance, Global Edition, 5th edition
Published by Pearson (February 2, 2015) © 2015
- Craig W. Holden Indiana University
Price Reduced From: $79.95 AUD
Price Reduced From: $122.95 AUD
This product is expected to ship within 5-7 business days for Australian customers.
Title overview
Present a user-friendly learning environment: Plain Vanilla Excel. Other books on the market teach students how to program using Visual Basic for Applications (VBA) or macros. By contrast, this text does nearly everything in plain vanilla Excel. This approach offers students a very intuitive, user-friendly environment that is accessible to all.
Focus on the implementation : Ready-to-Build Spreadsheets. The accompanying CD for this text provides ready-to-build spreadsheets for every chapter with step-by-step instructions. Since the CD provides instructions within each spreadsheet, students do not have to refer back to the text for each step. This approach allows students to concentrate on how to implement financial formulas and estimation.
Build students’ skills : From Simple Examples to Practical, Real-World Applications. The general approach of this text is to have students start with a simple example and then move on to completing full-scale, practical applications using real data.
Provide effective guidance : Essential Learning Conventions. In order to aid students as they move through the material, this text offers the following learning conventions:
- Time goes across the columns and variables go down rows. When something happens over time, each column represents a period of time. For example, in life cycle financial planning, date 0 is in column B, date 1 is in column C, date 2 is in column D, etc. Each row represents a different variable, which is usually labeled in column A.
- Color coding. A standard color scheme is used to clarify the structure of excel models.
- The Time Line Technique. The most natural technique for discounting cash flows in an excel model is the timeline technique where each column corresponds to a period of time.
- Symbolic notation is self-contained. Every spreadsheet that contains symbolic notation in the instruction boxes is self-contained.
The Fifth Edition adds great new corporate finance content:
- NEW. Real options, including the valuation of abandonment options, expansion options, contraction options, options to defer, and options to extend.
- NEW. Lease vs. buy decisions, including corporate, house, and car applications.
- UPDATED. All of the real world data , including financial statements, bond prices, the yield curve, asset returns, exchange rates, and options prices, have been updated to the present.