Research Catalog

Financial analysis and modeling using Excel and VBA / Chandan Sengupta.

Title
Financial analysis and modeling using Excel and VBA / Chandan Sengupta.
Author
Sengupta, Chandan.
Publication
Hoboken, N.J. : Wiley, c2010.

Items in the Library & Off-site

Filter by

1 Item

StatusFormatAccessCall NumberItem Location
TextRequest in advance HG106 .S46 2010 book & CD-ROMOff-site

Details

Additional Authors
Sengupta, Chandan.
Description
xxi, 793 p. : ill.; 24 cm. +
Series Statement
  • Wiley finance
  • Wiley trading
Uniform Title
  • Wiley finance series.
  • Wiley trading.
Subjects
Note
  • Includes index.
  • Rev. ed. of: Financial modeling. c2004.
Contents
Ch. 1. Introduction to Financial Analysis and Modeling -- Pt. I. Excel for Financial Analysis and Modeling -- Ch. 2. Excel 2007 and Previous Excel Versions -- Ch. 3. Excel Basics -- Ch. 4. Advanced Excel Features -- Ch. 5. Making Decisions and Looking Up Values -- Ch. 6. Analyzing Data -- Ch. 7. Answering What-If Questions -- Ch. 8. Finding Iterative Solutions -- Ch. 9. Doing Statistical Analysis -- Ch. 10. Using Excel's Financial Functions -- Ch. 11. Other Useful Excel Functions -- Pt. II. Financial Modeling Using Excel -- Ch. 12. Building Good Excel Models and Debugging Them -- Ch. 13. Financial Statements Forecasting -- Ch. 14. Time Value of Money -- Ch. 15. Financial Planning and Investments -- Ch. 16. Analyzing Market History -- Ch. 17. Bond Pricing and Duration -- Ch. 18. Simulating Stock Prices -- Ch. 19. Options and Option Portfolios -- Ch. 20. Binomial Option Pricing -- Pt. III. VBA for Financial Modeling -- Ch. 21. Introduction to VBA -- Ch. 22. VBA Essentials -- Ch. 23. Sub and Function Procedures -- Ch. 24. Debugging VBA Codes -- Pt. IV. Financial Modeling Using VBA -- Ch. 25. How to Build Good VBA Models -- Ch. 26. Time Value of Money -- Ch. 27. Financial Planning and Investments -- Ch. 28. Analyzing Market History -- Ch. 29. Simulating Stock Prices -- Ch. 30. Options and Option Portfolios -- Ch. 31. Binomial Option Pricing -- Appendix A. Keyboard shortcuts for Excel -- Appendix B. VBA Quick Reference -- Appendix C. Excel and VBA Built-In Functions.
ISBN
  • 9780470275603 (paper/CD-ROM)
  • 047027560X (paper/CD-ROM)
LCCN
2009035135
Owning Institutions
Columbia University Libraries