Announcing the FIFTH EDITIONS of

             EXCEL MODELING IN INVESTMENTS
       EXCEL MODELING IN CORPORATE FINANCE

                             By Craig W. Holden, Indiana University
                                      Published by Pearson

Each book teaches how to build financial models in Excel
Downloadable ready-to-build spreadsheets provide the student with:
     
Step-by-step instructions to build the finance model
     
All instructions are explained twice: first in words and second as an Excel formula
     
Input values, labels, and graphs are given -- students enter the formulas to build the spreadsheet
     
Many examples use real-world data
     
Spin buttons, option buttons, and graphs facilitate visual, interactive learning
The books can be combined with any investments or corporate finance textbook by any publisher
They are c
ompatible with Excel 2003 Ė Excel 2013


See larger photo

EXCEL MODELING IN INVESTMENTS
Contents,  Preface,  Desk Copy,  Purchase on Amazon.
New investments content:
    
Market microstructure including:
      o   Compute the National Best Bid and Offer (NBBO)
      o   Determine how a set of market orders and limit orders will execute in a limit order book market vs. a call market
      o   Compute five alternative transaction cost measures
      o   Decompose transaction costs into four components, and
      o   Estimate the Probability of Informed Trade (PIN)
     Portfolio performance evaluation including Jensenís Alpha, the Sharpe Ratio, the Treynor Ratio, the M2 measure, the T2 measure, and the Information measure
     Taxable vs. traditional vs. Roth savings plans


See larger photo

EXCEL MODELING IN CORPORATE FINANCE
Contents,  Preface, Desk Copy,  Purchase on Amazon.
New corporate finance content:
    
Real options, including project valuation with:
      o   abandonment options
      o   expansion options
      o   contraction options
      o   chooser options
      o   compound options
     Lease vs. buy decisions, including car and corporate applications
    
Taxable vs. traditional vs. Roth savings plans

New content for the fifth editions:
    
Market microstructure including:
      o   Compute the National Best Bid and Offer (NBBO)
      o   Determine how a set of market orders and limit orders will execute in a limit order book market vs. a call market
      o   Compute five alternative transaction cost measures
      o   Decompose transaction costs into four components
      o   Estimate the Probability of Informed Trade (PIN)
     Portfolio performance evaluation including Jensenís Alpha, the Sharpe Ratio, the Treynor Ratio, the M2 measure, the T2 measure, and the Information measure
     Taxable vs. traditional vs. Roth savings plans
    
Real options, including project valuation with:
      o   abandonment options
      o   expansion options
      o   contraction options
      o   chooser options
      o   compound options
     Lease vs. buy decisions, including car and corporate applications
 

My goal in writing the Excel Modeling books is simply to change finance education from limited treatment of the most basic Excel models to comprehensive treatment of both simple and sophisticated Excel models.