金融建模-英文版

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 AppendicesAppendix Chapter A: Review of Financial BasicsAppendix Chapter B: Financial Accounting Statements Appendix Chapter C: Earnings Multiplier Model Appendix Chapter D: Rate and Yield Metrics References and Selected Readings Index