Always Learning

Excel Modeling and Estimation in Corporate Finance, 3/E
Craig W. Holden

ISBN-10: 0136025617
ISBN-13:  9780136025610

Publisher:  Prentice Hall
Copyright:  2009
Format:  Paper; 216 pp
Published:  03/04/2008

Customers outside the U.S., click here.


Print this content

In this section:


Description

For undergraduate and graduate courses in corporate finance or financial management.

 

This book focuses on active learning by teaching students how to build and estimate financial models using Excel so they understand the steps involved, rather than being handed completed spreadsheets.


Features

For undergraduate and graduate courses in corporate finance or financial management.

 

This book focuses on active learning by teaching students how to build and estimate financial models using Excel so they understand the steps involved, rather than being handed completed spreadsheets.

 

Ready-To-Build Spreadsheets

 

The accompanying CD provides ready-to-build spreadsheets for every chapter that dictates step-by-step instructions to the student.  Since the CD provides instructions within each spreadsheet, so students do not have to refer back to the book for each step.  This approach allows students to concentration on implementing financial formulas and estimation.

 

Excel Modeling and Estimation — The New Content

 

Several significant updates have been made to this edition, including:

 

  • Estimating firm valuation in a two-stage framework
  • Estimating the cost of capital using the static CAPM based on the Fama-MacBeth method
  • Estimating the cost of capital using the APT or Intertemporal CAPM based on the Fama-French three factor model
  • Four international parity conditions
  • A new chapter on Excel tricks
  • Flexible content to use as a supplement with any textbook for a corporate finance course
  • Opportunities to build from simple Excel examples to practical, real-world applications using Excel.


New To This Edition

For undergraduate and graduate courses in corporate finance or financial management.

 

This book focuses on active learning by teaching students how to build and estimate financial models using Excel so they understand the steps involved, rather than being handed completed spreadsheets.

 

Ready-To-Build Spreadsheets

 

The accompanying CD provides ready-to-build spreadsheets for every chapter that dictates step-by-step instructions to the student.  Since the CD provides instructions within each spreadsheet, so students do not have to refer back to the book for each step.  This approach allows students to concentration on implementing financial formulas and estimation.

 

Excel Modeling and Estimation — The New Content

 

Several significant updates have been made to this edition, including:

 

  • Estimating firm valuation in a two-stage framework
  • Estimating the cost of capital using the static CAPM based on the Fama-MacBeth method
  • Estimating the cost of capital using the APT or Intertemporal CAPM based on the Fama-French three factor model
  • Four international parity conditions
  • A new chapter on Excel tricks
  • Flexible content to use as a supplement with any textbook for a corporate finance course
  • Opportunities to build from simple Excel examples to practical, real-world applications using Excel.


Table of Contents

Contents

 

Chapter 1 — Single Cash Flow

 

Chapter 2 — Annuity

 

Chapter 3 — NPV Using Constant Discounting

 

Chapter 4 — NPV Using General Discounting

 

Chapter 5 — Loan Amortization

 

Chapter 6 — Bond Valuation

 

Chapter 7 — Estimating Cost of Capital

 

Chapter 8 — Stock Valuation

 

Chapter 9 — Firm and Project Valuation

 

Chapter 10 — The Yield Curve

 

Chapter 11 — US Yield Curve Dynamics

 

Chapter 12 — Project NPV

 

Chapter 13 — Cost-Reducing Project

 

Chapter 14 — Break-Even Analysis

 

Chapter 15 — Corporate Financial Planning

 

Chapter 16 — Du Pont System of Ratio Analysis

 

Chapter 17 — Life-Cycle Financial Planning

 

Chapter 18 — Binomial Option Pricing

 

Chapter 19 — Real Options

 

Chapter 20 — Black Scholes Option Pricing

 

Chapter 21 — Debt and Equity Valuation

 

Chapter 22 — International Parity

 

Chapter 23 — Useful Excel Tricks


Short Retail Descripti


Previous Edition(s)

  • Excel Modeling in Corporate Finance Book and CD-ROM, 2/E
    Holden
    ©2005  |  Prentice Hall  |  Kit/Package/ShrinkWrap  |  Out of Print
    ISBN-10: 013132165X  |  ISBN-13: 9780131321656
    Brief Description  |  More Info


Next Edition(s)

  • Excel Modeling in Corporate Finance, 4/E
    Holden
    ©2012  |  Prentice Hall  |  Paper; 240 pp  |  Instock
    ISBN-10: 0132497840  |  ISBN-13: 9780132497848
    Brief Description  |  More Info



Back to top

Print this content

In this section:

Faculty Excel Files, 3/E
Holden
©2009  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 0136025625  |  ISBN-13: 9780136025627

Show Downloadable Files
 | More Info

Back to top


Student resources

Student CD for Excel Modeling and Estimation in Corporate Finance, 3/E
Holden
©2009  |  Prentice Hall  |  CD-ROM Only  |  Estimated Availability : 03/01/2008
ISBN-10: 0136025633  |  ISBN-13: 9780136025634
More Info


For the Finance Discipline

FinCoach 2.0: CD-ROM Edition
Handa
©2002  |  Prentice Hall  |  CD-ROM Only  |  Instock
ISBN-10: 0130606189  |  ISBN-13: 9780130606181
More Info

Research Navigator: Resources for College Research
Pearson
©2006  |  Prentice Hall  |  Paper  |  Instock
ISBN-10: 0321186079  |  ISBN-13: 9780321186072
More Info


Back to top

Log in to the Instructor Resource Center

Login name: 

  Password: 

Forgot login/password?  |  Need to redeem an access code?

        

Instructor Resource Center File Download

This work is protected by local and international copyright laws and is provided solely for the use of instructors in teaching their courses and assessing student learning. Dissemination or sale of any part of this work (including on the World Wide Web) will destroy the integrity of the work and is not permitted. The work and materials from this site should never be made available to students except by instructors using the accompanying text in their classes. All recipients of this work are expected to abide by these restrictions and to honor the intended pedagogical purposes and the needs of other instructors who rely on these materials.

Cancel     I accept, proceed with download

Print this content

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students contact your Pearson Higher Education representative.

Back to top