Announcing the THIRD EDITIONS of the

    EXCEL MODELING AND ESTIMATION BOOKS/CDS

                             By Craig W. Holden, Indiana University
                                Published by Pearson / Prentice Hall

Each book teaches how to build and estimate financial models in Excel
They can be combined with any investments or corporate finance textbook by any publisher

New to the third editions:
 ·  Ready-to-build spreadsheets on the CD provide the student with:
      · the model/estimation setup (input values, labels, and graphs)
      · step-by-step instructions for financial modeling/estimation on the spreadsheet itself
      · all instructions are explained twice: first in English and second as an Excel formula
      · a platform to enter and copy the formulas as instructed to build the spreadsheet
      · examples using real data
      · spin buttons, option buttons, and graphs that facilitate visual, interactive learning
· Compatible with Excel 97 – Excel 2007


See larger photo

 EXCEL MODELING AND ESTIMATION
IN INVESTMENTS
Contents,  Preface,  Desk Copy,  Purchase on Amazon.
New investments content:
      · estimating asset pricing models, including the Fama-French three-factor model
      · estimating portfolio optimization with constraints (e.g., short-sale constraints)
      · trader simulation and dealer simulation using simulation add-in @RISK
      · Cox-Ingersoll-Ross term structure model, Merton corporate bond model,
         American options with discrete dividends, Black-Scholes sensitivities (Greeks),
         11 exotic options


See larger photo

EXCEL MODELING AND ESTIMATION
IN CORPORATE FINANCE
Contents,  Preface, Desk Copy,  Purchase on Amazon.
New corporate finance content:
     · estimating the cost of capital from real data
     · two-stage valuation of firms and of projects using five equivalent methods:
        (1) adjusted present value, (2) free cash flow to equity, (3) free cash flow to the
        firm, (4) dividend discount model, and (5) residual income
     · four international parity conditions


See larger photo

EXCEL MODELING AND ESTIMATION
IN THE FUNDAMENTALS OF INVESTMENTS
 Contents,  Preface,  Desk Copy,  Purchase on Amazon.


See larger photo

EXCEL MODELING AND ESTIMATION
IN THE FUNDAMENTALS OF CORPORATE FINANCE
Contents,  Preface,  Desk Copy,  Purchase on Amazon.

· Other new content:
     · useful Excel tricks

My goal in writing the Excel Modeling and Estimation books/CDs is simply to change finance education from being calculator-based to being Excel-based.