Financial Modeling Using Excel and VBA (Wiley Finance) (Paperback)

by Chandan Sengupta (Author)

Editorial Reviews

Product Description
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.

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

From the Back Cover
Praise for Financial Modeling Using Excel and VBA

"Excel and VBA have vast capabilities, yet until this book, users were on their own to figure out just how to use these tools for both single and complex financial problems. Financial Modeling fills the gaps with practical guidance to modeling a wide range of finance problems."
--Tim Koller, Partner, McKinsey & Company, Inc.

Financial modeling is an essential skill for all financial professionals and students--and Excel and its built-in programming language, Visual Basic for Applications (VBA), are the preferred tools for the job. Financial Modeling Using Excel and VBA, designed for self-study, classroom use, and reference, presents a comprehensive approach to developing both simple and sophisticated financial models in all major areas of finance using both Excel and VBA.

The book assumes only basic knowledge of finance and Excel, and no previous knowledge of VBA. From that base, it teaches financial modeling, VBA, and advanced features of Excel using a unique, simple approach that is based on the author’s twenty years of experience in financial modeling in the business world and the classroom. The book reviews all the necessary financial theory and concepts, and walks you through a wide range of real-world financial models--over seventy-five of them--that you can imitate and use for practice as well. A companion CD-ROM includes several useful modeling tools and full working versions of all the models discussed in the book, so you can be more productive.

Financial modeling is finance in action. It is both challenging and rewarding. Financial Modeling Using Excel and VBA shows you how you can both enjoy the challenge and reap the rewards.

See all Editorial Reviews

Product Details

• Paperback: 672 pages
• Publisher: Wiley (February 26, 2004)
• Language: English
• ISBN-10: 0471267686
• ISBN-13: 978-0471267683
• Product Dimensions: 9 x 7.5 x 1.4 inches
• Shipping Weight: 2.6 pounds (View shipping rates and policies)
• Average Customer Review: 2.9 out of 5 stars See all reviews (8 customer reviews)
• Amazon.com Sales Rank: #104,576 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #27 in

  Books > Computers & Internet > Microsoft > Development > VBA

Customer Reviews

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

4.0 out of 5 stars Good section on Fin Stmt modeling , June 23, 2008

By	DJ - See all my reviews

The section on financial stmmt modeling and projections (pro forma) is one of the best out there. It is only a slice of what the book offers but if you are an equity analyst and asked to build models, I would buy this book based on the section it has on forecasting. It is not the end all be all, but a solid effort to supplement your other modeling books.........

25 of 37 people found the following review helpful:

2.0 out of 5 stars No access to Excel files for eBook version, February 1, 2006

By	M. McClure "Big 4 CPA" (Bethesda, MD) - See all my reviews (REAL NAME)

I spent a lot of money on this eBook only to find out that I would not receive the Excel files that go along with it. I am stuck either going through this book without the files that it uses throughout or shelling out even more money to buy a hardcopy version just for the attached CD.

22 of 36 people found the following review helpful:

1.0 out of 5 stars Not for professional, January 29, 2006

By	Cheng Chi Ho (Hong Kong) - See all my reviews (REAL NAME)

Just for basic models. Not enough description on complex financial models.