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
Status | Format | Access | Call Number | Item Location |
---|---|---|---|---|
Text | Request in advance | HG106 .S46 2010 book & CD-ROM | Off-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