EXCEL MODELING AND ESTIMATION IN THE FUNDAMENTALS OF CORPORATE FINANCE,

THIRD  EDITION - Contents    Preface,  Desk Copy,  Purchase on Amazon.

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   8
Chapter 3  NPV Using Constant Discounting   9
                              3.1  Nominal Rate   9
                             3.2  Real Rate   10
                             Problems   11
Chapter 4  NPV Using General Discounting   12
                              4.1  Nominal Rate   12
                             4.2  Real Rate   14
                             Problems    16
Chapter 5  Loan Amortization   17
                              5.1  Basics   17
                             5.2  Sensitivity Analysis   18
                             Problems   20

PART 2  VALUATION   21

Chapter 6  Bond Valuation   21
                              6.1  Annual Payments   21
                             6.2  APR and EAR   22
                             6.3  By Yield To Maturity   23
                             6.4  Dynamic Chart   24
                             6.5  System Of Five Bond Variables   25
                             Problems   26
 Chapter 7  Estimating the Cost of Capital   28
                              7.1  Static CAPM Using Fama-MacBeth Method   28
                             7.2  APT or Intertemporal CAPM Using Fama-MacBeth Method   33
                             Problems   40
 Chapter 8  Stock Valuation   42
                               8.1  Dividend Discount Model   42
                              Problems   43
 Chapter 9  Firm and Project Valuation   44
                               9.1  Cash Flows for Five Equivalent Methods   44
                              9.2  Adjusted Present Value   47
                              9.3  Free Cash Flow to Equity   48
                              9.4  Free Cash Flow to the Firm   50
                              9.5  Dividend Discount Model   52
                              9.6  Residual Income   53
                              9.7  Five Equivalent Methods   54
                              Problems   63
                              Appendix: Where did those Two-Stage Formulas for the Cost of Equity
                              Capital and the Cost of Firm Capital come from?   64
Chapter 10 U.S. Yield Curve Dynamics   70
                               10.1  Dynamic Chart   70
                              Problems   76

PART 3  CAPITAL BUDGETING   78

Chapter 11 Project NPV   78  
                              11.1  Basics   78
                              11.2  Forecasting Cash Flows   81  
                              11.3  Working Capital   82
                              11.4  Sensitivity Analysis   84
                              Problems   87
 Chapter 12 Break-Even Analysis   88
                               12.1  Based On Accounting Profit   88
                              12.2  Based On NPV   91
                              Problems   95
 

PART 4 FINANCIAL PLANNING   96

Chapter 13 Corporate Financial Planning   96
                         13.1  Actual   96
                              13.2  Forecast   99
                              13.3  Cash Flow   103
                              13.4  Ratios   105
                              13.5  Sensitivity   107
                              13.6  Full-Scale Estimation   108
                              Problems   114
 Chapter 14 Life-Cycle Financial Planning   117
                              14.1  Basics   117
                              14.2  Full-Scale Estimation  119             
                              Problems   127

PART 5  OPTIONS AND CORPORATE FINANCE   128

Chapter 15 Binomial Option Pricing   128
                               15.1  Estimating Volatility   128
                              15.2  Single Period   129
                              15.3  Multi-Period   132
                              15.4  Risk Neutral   137
                              15.5  American With Discrete Dividends   140
                              15.6  Full-Scale    144
                              Problems   152
 Chapter 16 Real Options   154
                               16.1  NPV Correctly vs. NPV Ignoring Option   154
                              Problems   157
 Chapter 17 Black Scholes Option Pricing   158
                               17.1  Basics   158
                              17.2  Continuous Dividend   159
                               17.3  Dynamic Chart   160
                              17.4  Implied Volatility   163
                              Problems   165

PART 6  EXCEL SKILLS     167

 Chapter 18 Useful Excel Tricks     167
                               18.1  Quickly Delete The Instruction Boxes and Arrows     167
                               18.2  Freeze Panes     167
                               18.3  Spin Buttons and the Developer Tab     168
                               18.4  Option Buttons and Group Boxes     169
                               18.5  Scroll Bar     171
                               18.6  Install Solver or the Analysis ToolPak     172
                               18.7  Format Painter     172
                               18.8  Conditional Formatting     173
                               18.9  Fill Handle     174
                               18.10  2-D Scatter Chart     174
                               18.11  3-D Scatter Chart     176

CONTENTS ON CD

      TXT   Readme.txt
      PDF  Excel Mod Est Fun CorpFin 3.pdf
        Ch 01 Single Cash Flow.xlsx
        Ch 02 Annuity.xlsx
        Ch 03 NPV Constant Discnt.xlsx
        Ch 04 NPV General Discnt.xlsx
        Ch 05 Loan Amortization.xlsx
        Ch 06 Bond Valuation.xlsx
        Ch 07 Cost of Capital.xlsx
        Ch 08 Stock Valuation.xlsx
        Ch 09 Firm and Project Val.xlsx
        Ch 10 US Yield Curve Dynam.xlsx
        Ch 11 Project NPV.xlsx
        Ch 12 Break Even Analysis.xlsx
        Ch 13 Corp Financial Plan.xlsx
        Ch 14 Life-Cycle Fin Plan.xlsx
        Ch 15 Binomial Option Pric.xlsx
        Ch 16 Real Options.xlsx
        Ch 17 Black Scholes Opt Pr.xlsx
      Folder%20Icon  Files in Excel 97-2003 Format