EXCEL MODELING IN CORPORATE FINANCE, FIFTH EDITION
Contents
   Preface,  Desk Copy,  Purchase on Amazon Free US Yield Curve Dynamics.

PART 1  TIME VALUE OF MONEY..1

Chapter 1  Single Cash Flow..............................................1
                         
   1.1  Present Value........................................................................................1
                             1.2  Future Value..........................................................................................2
                             Problems........................................................................................................3

Chapter 2  Annuity............................................................4
                             2.1  Present Value........................................................................................4
                             2.2  Future Value..........................................................................................5
                             2.3  System of Four Annuity Variables....................................................6
                             Problems........................................................................................................7

Chapter 3  NPV Using Constant Discounting.....................8
                             3.1  Nominal Rate.........................................................................................8
                             3.2  Real Rate................................................................................................9
                             Problems......................................................................................................10

Chapter 4  
NPV Using General Discounting.....................11
                             4.1  Nominal Rate.......................................................................................11
                             4.2  Real Rate..............................................................................................13
                             Problems......................................................................................................15

Chapter 5  Loan Amortization.........................................16
                             5.1  Basics...................................................................................................16
                             5.2  Sensitivity Analysis...........................................................................17
                             Problems......................................................................................................19
Chapter 6  Lease Vs. Buy.................................................20
                             6.1  Car.........................................................................................................20
                             6.2  Corporate.............................................................................................20
                             Problems......................................................................................................22

PART 2  VALUATION................................23

Chapter 7  Bond Valuation..............................................23
                           
 7.1  Annual Payments...............................................................................23
                             7.2  EAR, APR, and Foreign Currencies..............................................24

                             7.3  Duration and Convexity....................................................................29
 
                            7.4  Price Sensitivity................................................................................31
                             7.5  System of Five Bond Variables.......................................................33
                             Problems.....................................................................................................34
Chapter 8  Estimating the Cost of Capital.......................37
                             8.1  Static CAPM Using Fama-MacBeth Method................................37
                             8.2  APT or Intertemporal CAPM Using Fama-MacBeth Method...41
                             Problems.....................................................................................................46
Chapter 9  Stock Valuation.............................................47
                              9.1  Dividend Discount Model.................................................................47
                              Problems....................................................................................................48
Chapter 10  Firm and Project Valuation..........................49
                            
 10.1  Cash Flows for Five Equivalent Methods.....................................49
                              10.2  Adjusted Present Value.................................................................52
                              10.3  Free Cash Flow to Equity...............................................................53
                              10.4  Free Cash Flow to the Firm...........................................................54
                              10.5  Dividend Discount Model...............................................................55
                              10.6  Residual Income..............................................................................56
                              10.7  Five Equivalent Methods.................................................................57
                              Problems....................................................................................................66
                              Appendix: Reconciling the Residual Income Method with Other
                              Approaches to Valuing Firms or Projects..........................................67

Chapter 11 The Yield Curve............................................73
                            
 11.1  Obtaining It From Treasury Bills and Strips..........................73
                              11.2  Using It To Price A Coupon Bond...............................................74
                              11.3  Using It To Determine Forward Rates.......................................75
                              Problems...................................................................................................76

Chapter 12 U.S. Yield Curve Dynamics...........................77

                              12.1  Dynamic Chart..............................................................................77
                              Problems..................................................................................................82

PART 3  CAPITAL STRUCTURE....84

Chapter 13 Capital Structure...........................................84
 
                              13.1  Modigliani-Miller With No Taxes..............................................84
                              13.2 
Modigliani-Miller With Corporate Taxes.................................86  
                              13.3  Trade-off Model: Tax Shield vs. Distress Cost.........................88
                              Problems....................................................................................................90

PART 4  CAPITAL BUDGETING....91

Chapter 14 Project NPV.................................................91
 
                              14.1  Basics.............................................................................................91
                              14.2  Forecasting Cash Flows..............................................................94  
                              14.3  Working Capital..........................................................................95
                              14.4  Sensitivity Analysis.....................................................................97
                              Problems................................................................................................100

Chapter 15 Cost-Reducing Project................................101  
                              15.1  Basics...........................................................................................101
                              15.2  Sensitivity Analysis...................................................................104  
                              Problems................................................................................................105
Chapter 16 Break-Even Analysis...................................106
                            
 16.1  Based On Accounting Profit....................................................106
                              16.2  Based On NPV............................................................................109
                              Problems................................................................................................113

PART 5 FINANCIAL PLANNING.114

Chapter 17 Corporate Financial Planning.....................114
         
                17.1  Actual...........................................................................................114
                              17.2  Forecast........................................................................................117
                              17.3  Cash Flow.....................................................................................121
                              17.4  Ratios............................................................................................123
                              17.5  Sensitivity....................................................................................125
                              17.6  Full-Scale Estimation................................................................126
                              Problems................................................................................................132
Chapter 18 Du Pont System of Ratio Analysis..............135
                            
 18.1  Basics...........................................................................................134  
                              Problems................................................................................................136
Chapter 19 Life-Cycle Financial Planning.....................137
         
                    19.1  Taxable Vs. Traditional Vs. Roth Savings.............................137
                              19.2  Basic Life-Cycle Planning.......................................................139
                              19.3  Full-Scale Life-Cycle Planning...............................................141             
                            
 Problems................................................................................................148

PART 6  INTERNATIONAL
           CORPORATE FINANCE....
149

Chapter 20 International Parity...................................149
                              20.1  System of Four Parity Conditions.........................................149
                              20.2  Estimating Future Exchange Rates.......................................151
                              Problems..............................................................................................
152

PART 7  OPTIONS AND
           CORPORATE FINANCE...
153

Chapter 21 Binomial Option Pricing...........................153
                              21.1  Estimating Volatility...............................................................153

                              21.2  Single Period............................................................................154
                              21.3  Multi-Period..............................................................................157
                              21.4  Risk Neutral.............................................................................161
                              21.5  Average of N and N-1...............................................................164
                              21.6  Convergence to Normal...........................................................166
                              21.7  American With Discrete Dividends......................................168
                              21.8  Full-Scale...................................................................................172
                              Problems..............................................................................................177
Chapter 22 Real Options.............................................179
                              22.1  Option To Abandon..................................................................179
                              22.2  Option To Expand.....................................................................180
                              22.3  Option To Contract..................................................................181
                              22.4  Option To Choose.....................................................................182
                              22.5  Compound Option.....................................................................184
                              Problems..............................................................................................187

Chapter 23 Black Scholes Option Pricing....................189
                              23.1  Basics.........................................................................................189
 
                             23.2  Continuous Dividend................................................................190
                              23.3  Implied Volatility......................................................................194
                              Problems..............................................................................................196
Chapter 24 Debt and Equity Valuation........................198
                              24.1  Two Methods..............................................................................198
                              24.2  Impact of Risk...........................................................................200
                              Problems..............................................................................................201

PART 6  EXCEL SKILLS...................202

Chapter 25 Useful Excel Tricks...................................202
                           
  25.1  Quickly Delete The Instruction Boxes and Arrows........202
                              25.2  Freeze Panes...........................................................................202
                              25.3  Spin Buttons and the Developer Tab...................................203
                              25.4  Option Buttons and Group Boxes........................................204
                              25.5  Scroll Bar................................................................................206
                              25.6  Install Solver or the Analysis ToolPak..............................207
                              25.7  Format Painter........................................................................207
                              25.8  Conditional Formatting.........................................................208
                              25.9  Fill Handle...............................................................................209
                              25.10  2-D Scatter Chart................................................................209
                              25.11  3-D Scatter Chart................................................................211

DOWNLOADABLE CONTENTS

      PDF  Excel Modeling in Corporate Finance Fifth Edition.pdf
        Ready-To-Build spreadsheets available in both XLSX
          and XLS file formats:

              Ch 01 Single Cash Flow - Ready-To-Build.xlsx
              Ch 02 Annuity - Ready-To-Build..xlsx
              Ch 03 NPV Using Constant Discounting - Ready-To-Build..xlsx
              Ch 04 NPV Using General Discounting - Ready-To-Build..xlsx
              Ch 05 Loan Amortization - Ready-To-Build..xlsx
              Ch 06 Leasee Vs Buy - Ready-To-Build..xlsx
              Ch 07 Bond Valuation - Ready-To-Build..xlsx
              Ch 08 Estimating the Cost of Capital.xlsx
              Ch 09 Stock Valuation - Ready-To-Build..xlsx
              Ch 10 Firm and Project Valuation - Ready-To-Build..xlsx
              Ch 11 The Yield Curve - Ready-To-Build..xlsx
              Ch 12 US Yield Curve Dynamics - Ready-To-Build..xlsx
              Ch 13 Capital Structure - Ready-To-Build..xlsx
              Ch 14 Project NPV - Ready-To-Build..xlsx
              Ch 15 Cost-Reducing Project - Ready-To-Build..xlsx
              Ch 16 Break Even Analysis - Ready-To-Build..xlsx
              Ch 17 Corporate Financial Planning - Ready-To-Build..xlsx
              Ch 18 DuPont System of Ratio Analysis - Ready-To-Build..xlsx
              Ch 19 Life-Cycle Financial Planning - Ready-To-Build..xlsx
              Ch 20 International Parity - Ready-To-Build..xlsx
              Ch 21 Binomial Option Pricing - Ready-To-Build..xlsx
              Ch 22 Real Options - Ready-To-Build..xlsx
              Ch 23 Black-Scholes Option Pricing - Ready-To-Build..xlsx
              Ch 23 Debt and Equity Valuation - Ready-To-Build..xlsx