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.

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.