Excel Modeling in Corporate Finance, Global Edition

Preface <br>Fifth Edition Changes <br>Ready-To-Build Spreadsheets <br>What Is Unique About This Book <br>Conventions Used In This Book <br>Craig's Challenge <br>Excel® Modeling Books <br>Suggestions for Faculty Members <br>Acknowledgements <br>About The Author <br>PART 1 TIME VALUE OF MONEY <br>Chapter 1 Single Cash Flow <br>1.1 Present Value <br>1.2 Future Value <br>Problems <br>Chapter 2 Annuity <br>2.1 Present Value <br>2.2 Future Value <br>2.3 System of Four Annuity Variables <br>Problems <br>Chapter 3 NPV Using Constant Discounting <br>3.1 Nominal Rate <br>3.2 Real Rate <br>Problems <br>Chapter 4 NPV Using General Discounting <br>4.1 Nominal Rate <br>4.2 Real Rate <br>Problems <br>Chapter 5 Loan Amortization <br>5.1 Basics <br>5.2 Sensitivity Analysis <br>Problems <br>Chapter 6 Lease Vs. Buy <br>6.1 Car <br>6.2 Corporate <br>Problems <br>PART 2 VALUATION <br>Chapter 7 Bond Valuation <br>7.1 Annual Payments <br>7.2 EAR, APR, and Foreign Currencies <br>7.3 Duration and Convexity <br>7.4 Price Sensitivity <br>7.5 System of Five Bond Variables <br>Problems <br>Chapter 8 Estimating the Cost of Capital <br>8.1 Static CAPM Using Fama-MacBeth Method <br>8.2 APT or Intertemporal CAPM Using Fama-McBeth Method <br>Problems <br>Chapter 9 Stock Valuation <br>9.1 Dividend Discount Model <br>Problems <br>Chapter 10 Firm and Project Valuation <br>10.1 Cash Flows for Five Equivalent Methods <br>10.2 Adjusted Present Value <br>10.3 Free Cash Flow To Equity <br>10.4 Free Cash Flow to the Firm <br>10.5 Dividend Discount Model <br>10.6 Residual Income <br>10.7 Five Equivalent Methods <br>Problems <br>Appendix: Reconciling the Residual Income Method with Other Approaches to Valuing Firms or Projects <br>Chapter 11 The Yield Curve <br>11.1 Obtaining It From Treasury Bills and Strips <br>11.2 Using It To Price A Coupon Bond <br>11.3 Using It To Determine Forward Rates <br>Problems <br>Chapter 12 US Yield Curve Dynamics <br>12.1 Dynamic Chart <br>Problems <br>PART 3 CAPITAL STRUCTURE <br>Chapter 13 Capital Structure <br>13.1 Modigliani-Miller With No Taxes. <br>13.2 Modigliani-Miller With Corporate Taxes <br>13.3 Trade-off Model: Tax Shield vs. Distress Cost <br>Problems <br>PART 4 CAPITAL BUDGETING <br>Chapter 14 Project NPV <br>14.1 Basics <br>14.2 Forecasting Cash Flows <br>14.3 Working Capital <br>14.4 Sensitivity Analysis <br>Problems <br>Chapter 15 Cost-Reducing Project <br>15.1 Basics <br>15.2 Sensitivity Analysis <br>Problems <br>Chapter 16 Break-Even Analysis <br>16.1 Based On Accounting Profit <br>16.2 Based On NPV <br>Problems <br>PART 5 FINANCIAL PLANNING <br>Chapter 17 Corporate Financial Planning <br>17.1 Actual <br>17.2 Forecast <br>17.3 Cash Flow <br>17.4 Ratios <br>17.5 Sensitivity <br>17.6 Full-Scale Estimation <br>Problems <br>Chapter 18 Du Pont System Of Ratio Analysis <br>18.1 Basics <br>Problems <br>Chapter 19 Life-Cycle Financial Planning <br>19.1 Taxable Vs. Traditional Vs. Roth Savings <br>19.2 Basic Life-Cycle Planning <br>19.3 Full-Scale Life-Cycle Planning <br>Problems <br>PART 6 INTERNATIONAL CORPORATE FINANCE <br>Chapter 20 International Parity <br>20.1 System of Four Parity Conditions <br>20.2 Estimating Future Exchange Rates <br>Problems <br>PART 7 OPTIONS AND CORPORATE FINANCE <br>Chapter 21 Binomial Option Pricing <br>21.1 Estimating Volatility <br>21.2 Single Period <br>21.3 Multi-Period <br>21.4 Risk Neutral <br>21.5 Average of N and N-1 <br>21.6 Convergence to Normal <br>21.7 American With Discrete Dividends <br>21.8 Full-Scale <br>Problems <br>Chapter 22 Real Options <br>22.1 Option To Abandon <br>22.2 Option to Expand <br>22.3 Option to Contract <br>22.4 Option To Choose <br>22.5 Compound Option <br>Problems <br>Chapter 23 Black-Scholes Option Pricing <br>23.1 Basics <br>23.2 Continuous Dividend <br>23.3 Implied Volatility <br>Problems <br>Chapter 24 Debt And Equity Valuation <br>24.1 Two Me