Financial Analysis and Modeling Using Excel and VBA With C D /
Chandan Sengupta.
- 2nd ed.
- New Delhi : Wiley India , 2010.
- xxi, 793 p. : Diagramme + 1 CD-ROM
About This Book. Chapter 1 Introduction to Financial Analysis and Modeling. Part One: Excel for Financial Analysis and Modeling. Chapter 2 Excel 2007 and Previous Excel Versions. Chapter 3 Excel Basics. Chapter 4 Advanced Excel Features. Chapter 5 Making Decisions and Looking Up Values. Chapter 6 Analyzing Databases. Chapter 7 Answering What-If Questions. Chapter 8 Finding Iterative Solutions. Chapter 9 Doing Statistical Analysis. Chapter 10 Using Excel's Financial Functions. Chapter 11 Other Useful Excel Functions. Part Two: Financial Modeling Using Excel. Chapter 12 Building Good Excel Models and Debugging Them. Chapter 13 Financial Statements Forecasting. Chapter 14 Time Value of Money. Chapter 15 Financial Planning and Investments. Chapter 16 Analyzing Market History. Chapter 17 Bond Pricing and Duration. Chapter 18 Simulating Stock Prices. Chapter 19 Options and Option Portfolios. Chapter 20 Binomial Option Pricing. Part Three: VBA for Financial Modeling. Chapter 21 Introduction to VBA. Chapter 22 VBA Essentials. Chapter 23 Sub and Function Procedures. Chapter 24 Debugging VBA Codes. Pat Four: Financial Modeling Using VBA. Chapter 25 How to Build Good VBA Models. Chapter 26 Time Value of Money. Chapter 27 Financial Planning and Investments. Chapter 28 Analyzing Market History. Chapter 29 Simulating Stock Prices. Chapter 30 Options and Option Portfolios. Chapter 31 Binomial Option Pricing. Appendix A Keyboard Shortcuts for Excel. Appendix B VBA Quick Reference. Appendix C Excel and VBA Built-In Functions. About the CD-ROM. Index.