Financial Modeling Using Excel and VBA (Wiley Finance) - Softcover

Sengupta, Chandan

Softcover

ISBN 10: 0471267686 ISBN 13: 9780471267683

Publisher: John Wiley & Sons, 2004

Synopsis

This book offers comprehensive instructions on developing real-world financial models. Designed for self-study, classroom use, and reference, it presents a comprehensive 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. The 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).

About this title

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.

Edition details

• Publisher: John Wiley & Sons
• Publication date: 2004
• ISBN 10: 0471267686
• ISBN 13: 9780471267683
• Binding: Paperback
• Language: English
• Number of pages: 672