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

Chandan Sengupta (Author)

Book Description

Publication Date: February 26, 2004 | ISBN-10: 0471267686 | ISBN-13: 978-0471267683 | Edition: First Edition

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

Editorial Reviews

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.

About the Author

CHANDAN SENGUPTA teaches at the Fordham University Graduate School of Business Administration, 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 the author of The Only Proven Road to Investment Success, also published by Wiley.

Product Details

• Paperback: 672 pages
• Publisher: Wiley; First Edition edition (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
• Average Customer Review: 3.0 out of 5 stars  See all reviews (8 customer reviews)
• Amazon Best Sellers Rank: #949,018 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

25 of 25 people found the following review helpful:

1.0 out of 5 stars EXTREMELY WEAK TREATMENT FOR FINANCIAL NOVICES!, September 15, 2009

By 

Texas CPA (Houston, TX) - See all my reviews

This review is from: Financial Modeling Using Excel and VBA (Wiley Finance) (Paperback)

I must agree with the other reviewers of Sengupta's very weak effort. This book is overly simplistic and of very little use to any true financial professional.

For an excellent overview of financial modeling in general, look at Ragsdale 5e or The Art of Modeling with Spreadsheets by Powell of the Tuck School. For excellent treatment of robust financial statement analysis and valuation, look at Penman 4e, McKinsey 4e, or Damordaran on Valuation. For utilizing Excel for general Corporate Finance applications, look at Financial Modeling Benninga 3e or Benninga's Principles of Finance with Excel.

For an excellent treatment of how powerfully VBA can be utilized in general financial modeling, look at A Fast Track to Structured Finance by William Preinitz or Evan Tick's similar title. In my opinion, both are an excellent value and provide a tremendous learning experience for the serious student or practionier.

There are many far more useful texts than Sengupta's. Save your money and do not purchase this title unless you are a true novice and very new to financial statements and/or Excel.

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

This review is from: Financial Modeling Using Excel and VBA (Wiley Finance) (Paperback)

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

3.0 out of 5 stars Ok, but a bit simplistic, August 24, 2011

By 

A. Nonym (France) - See all my reviews

This review is from: Financial Analysis and Modeling Using Excel and VBA (Wiley Desktop Editions) (Paperback)

The book is correct for very novice student, but no more. It spends a lot of time explaining very basic facts and ideas (eg. the author justifies at length why learning a programming language, but does not discuss any other language apart from VBA). There are many examples, but they are often mere variations of each others.