简介
An updated look at the theory and practice of financial analysis and modeling Financial Analysis and Modeling Using Excel and VBA, Second Edition presents a comprehensive approach to analyzing financial problems and developing simple to sophisticated financial models in all major areas of finance using Excel 2007 and VBA (as well as earlier versions of both). This expanded and fully updated guide reviews all the necessary financial theory and concepts, and walks you through a wide range of real-world financial problems and models that you can learn from, use for practice, and easily adapt for work and classroom use. A companion CD-ROM includes several useful modeling tools and fully working versions of all the models discussed in the book. Teaches financial analysis and modeling and illustrates advanced features of Excel and VBA, using a learn-by-doing approach Contains detailed coverage of the powerful features of Excel 2007 essential for financial analysis and modeling, such as the Ribbon interface, PivotTables, data analysis, and statistical analysis Other titles by Sengupta: Financial Modeling Using C++ and The Only Proven Road to Investment Success Designed for self-study, classroom use, and reference This comprehensive guide is an essential read for anyone who has to perform financial analysis or understand and implement financial models.
目录
About This Book
Chapter 1 Introduction to Financial Analysis and Modeling
Part I 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 Data
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 II 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 III 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 IV: 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
Chapter 1 Introduction to Financial Analysis and Modeling
Part I 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 Data
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 II 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 III 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 IV: 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
- 名称
- 类型
- 大小
光盘服务联系方式: 020-38250260 客服QQ：4006604884
云图客服：
用户发送的提问，这种方式就需要有位在线客服来回答用户的问题，这种 就属于对话式的,问题是这种提问是否需要用户登录才能提问
Video Player
×
Audio Player
×
pdf Player
×
亲爱的云图用户，
光盘内的文件都可以直接点击浏览哦
无需下载，在线查阅资料！
