# Financial Analysis and Modeling Using Excel and VBA, Second Edition

• 14h 25m
• Chandan Sengupta
• John Wiley & Sons (US)
• 2010

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.

• 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
• 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.

Chandan Sengupta teaches finance in the MBA program at the Fordham University Graduate School of Business, specializing in financial modeling, business valuation, corporate finance, and investment management. Formerly, he was vice president at the Chase Manhattan Bank for eight years and senior financial advisor for Mobil Corporation for ten years. He is also the author of the first edition of this book as well as Financial Modeling Using C++ and The Only Proven Road to Investment Success, all of which are published by Wiley.

## In this Book

• Introduction to Financial Analysis and Modeling
• Excel 2007 and the Previous Versions
• Excel Basics
• Advanced Excel Features
• Making Decisions and Looking up Values
• Analyzing Databases
• Answering What-If Questions
• Finding Iterative Solutions
• Doing Statistical Analysis
• Using the Financial Functions
• Other Useful Excel Functions
• Building Good Excel Models and Debugging Them
• Financial Statements Forecasting
• Time Value of Money
• Financial Planning and Investments
• Analyzing Market History
• Bond Pricing and Duration
• Simulating Stock Prices
• Options and Option Portfolios
• Binomial Option Pricing
• Introduction to VBA
• VBA Essentials
• Sub and Function Procedures
• Debugging VBA Codes
• How to Build Good VBA Models
• Time Value of Money
• Financial Planning and Investments
• Analyzing Market History
• Simulating Stock Prices
• Options and Option Portfolios
• Binomial Option Pricing
• About the CD-ROM