Financial Analysis and Modeling Using Excel and VBA / Edition 2

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $61.79
Usually ships in 1-2 business days
(Save 58%)
Other sellers (Paperback)
  • All (13) from $61.79   
  • New (9) from $80.63   
  • Used (4) from $61.80   


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

Read More Show Less

Product Details

  • ISBN-13: 9780470275603
  • Publisher: Wiley
  • Publication date: 11/9/2009
  • Series: Wiley Finance Series, #456
  • Edition number: 2
  • Pages: 784
  • Sales rank: 916,879
  • Product dimensions: 7.50 (w) x 9.20 (h) x 1.80 (d)

Meet the Author

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.
Read More Show Less

Table of Contents

About This Book.

Chapter 1 Introduction to Financial Analysis and Modeling.

Part One: 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 Databases.

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 Two: 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 Three: 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 Four: 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.


Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)