Financial Modeling Using Excel and VBA

By Chandan Sengupta
Publisher:   Wiley

CHAPTER 1: Introduction to Financial Modeling.

Part One: Excel for Financial Modeling.
CHAPTER 2: Excel Basics.
CHAPTER 3: Advanced Excel Features.
CHAPTER 4: Excel's Built-In Functions and Analysis Tools.

Part Two: Financial Modeling Using Excel.
CHAPTER 5: How to Build Good Excel Models.
CHAPTER 6: Financial Statements Forecasting.
CHAPTER 7: Time Value of Money.
CHAPTER 8: Financial Planning and Investments.
CHAPTER 9: Analyzing Market History.
CHAPTER 10: Bond Pricing and Duration.
CHAPTER 11: Simulating Stock Prices.
CHAPTER 12: Options and Option Portfolios.
CHAPTER 13: Binomial Option Pricing.

Part Three: VBA for Financial Modeling.
CHAPTER 14: Introduction to VBA.
CHAPTER 15: VBA Essentials.
CHAPTER 16: Sub and Function Procedures.
CHAPTER 17: Debugging VBA Models.

Part Four: Financial Modeling Using VBA.
CHAPTER 18: How to Build Good VBA Models.
CHAPTER 19: Time Value of Money.
CHAPTER 20: Financial Planning and Investments.
CHAPTER 21: Analyzing Market History.
CHAPTER 22: Simulating Stock Prices.
CHAPTER 23: Options and Option Portfolios.
CHAPTER 24: Binomial Option Pricing.
Appendix A: Keyboard Shortcuts for Excel.
Appendix B: VBA Quick Reference.
Appendix C: Excel and VBA Built-In Functions.

[此贴子已经被作者于2008-11-18 13:57:20编辑过]