Excel Modeling and Estimation in Corporate Finance

Chapter 1 — Single Cash Flow
Chapter 2 — Annuity
Chapter 3 — NPV Using Constant Discounting
Chapter 4 — NPV Using General Discounting
Chapter 5 — Loan Amortization
Chapter 6 — Bond Valuation
Chapter 7 — Estimating Cost of Capital
Chapter 8 — Stock Valuation
Chapter 9 — Firm and Project Valuation
Chapter 10 — The Yield Curve
Chapter 11 — US Yield Curve Dynamics
Chapter 12 — Project NPV
Chapter 13 — Cost-Reducing Project
Chapter 14 — Break-Even Analysis
Chapter 15 — Corporate Financial Planning
Chapter 16 — Du Pont System of Ratio Analysis
Chapter 17 — Life-Cycle Financial Planning
Chapter 18 — Binomial Option Pricing
Chapter 19 — Real Options
Chapter 20 — Black Scholes Option Pricing
Chapter 21 — Debt and Equity Valuation
Chapter 22 — International Parity
Chapter 23 — Useful Excel Tricks