|
|
Usually ships within 1 to 3 working days
|
- Product code: 18092
- ISBN: 0471267686,
ISBN13: 9780471267683,
464 pages, CD-Rom + pb
Published by John Wiley & Sons, 2004
Rate this book...
Rating: 0.0/5 (0 votes cast)
|
|
|
|
|
Description of Financial Modeling Using Excel and VBA |
Comprehensive instruction on developing real-world financial models
This book, designed for self-study, classroom use, and reference, presents a com-prehensive approach to developing simple to sophisticated financial models in all major areas of finance. The approach is based on the author’s 20 years of experience of developing such models in the business world and teaching a popular MBA class in financial modeling.
The book assumes only basic knowledge of Excel and teaches all advanced features of Excel and VBA from scratch using a unique simple method. A companion CD includes all working versions of all the models presented in the book and additional useful reference material.
|
Contents of Financial Modeling Using Excel and VBA |
About This Book
1. Introduction to Financial Modeling
PART ONE: Excel for Financial Modeling
2. Excel Basics
3. Advanced Excel Features
4. Excel’s Built-In Functions and Analysis Tools
PART TWO: Financial Modeling Using Excel
5. How to Build Good Excel Models
6. Financial Statements Forecasting
7. Time Value of Money
8. Financial Planning and Investments
9. Analyzing Market History
10. Bond Pricing and Duration
11. Simulating Stock Prices
12. Options and Option Portfolios
13. Binomial Option Pricing
PART THREE: VBA for Financial Modeling
14. Introduction to VBA
15. VBA Essentials
16. Sub and Function Procedures
17. Debugging VBA Models
PART FOUR: Financial Modeling Using VBA
18. How to Build Good VBA Models
19. Time Value of Money
20. Financial Planning and Investments
21. Analyzing Market History
22. Simulating Stock Prices
23. Options and Option Portfolios
24. Binomial Option Pricing
Appendix A: Keyboard Shortcuts for Excel
Appendix B: VBA Quick Reference
Appendix C: Excel and VBA Built-In Functions
Index
About the CD-ROM
|
About Chandan Sengupta |
Chandan Sengupta (White Plains, NY) teaches finance in the MBA program at Fordham University’s Graduate School of Business. Formerly, he was vice president of the Chase Manhattan Bank for eight years and senior financial advisor for Mobil Corporation for 10 years. He is also the author of The Only Proven Road to Investment Success (0-471-44307-7).
|
Buyers of Financial Modeling Using Excel and VBA also bought
Bulk buying
| If you need bulk copies of Financial Modeling Using Excel and VBA, or are interested in opening a corporate account, please contact us. |
|
Shopping basket