金融建模 以Excel為工具（英文版）

I Basics of Excel Functionality
Chapter 1: Array Functions; Goal Seek; Data Tables
Chapter 2: Boolean Functions; Excel’s PV Function
Chapter 3: Regressions in Excel; Matrix Functions
Chapter 4: Excel’s Amortization Functions; VLOOKUP
Chapter 5: Scatter Plot; Polynomial Regressions
Chapter 6: Excel’s Solver; Excel’s IRR Function
II Absolute Valuation and Portfolio Management
Chapter 7: Pro-forma Accounting Statements; Firm Value
Chapter 8: Value at Risk; Portfolio Theory Introduction
Chapter 9: Portfolio Theory; Market Model; Events
III Options
Chapter 10: Option Payoffs and Premia
Chapter 11: Black-Scholes-Merton Model Applications
Chapter 12: Replicating Portfolios Involving Options
Chapter 13: Revisiting Option Replicating Portfolios
Chapter 14: Binomial Pricing Model; Monte Carlo
Chapter 15: Path Dependent Options; Real Options
IV Bonds
Chapter 16: Price-yield Curve & Approximations; Spot Rates;
Pricing Between Coupon Dates
Chapter 17: Bond Immunization Portfolio
Appendices
Appendix Chapter A: Review of Financial Basics
Appendix Chapter B: Financial Accounting Statements
Appendix Chapter C: Earnings Multiplier Model
Appendix Chapter D: Rate and Yield Metrics
References and Selected Readings
Index