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 CD-ROM 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.
Praise for the first edition of Financial Analysis and 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.
Although many people think that financial analysis and financial modeling are different activities, they are actually the two sides of a coin. The skills associated with these disciplines are essential for today′s financial professional as well as students in this field and Excel and its built–in programming language Visual Basic for Applications (VBA) remain the premier tools for the job.
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 to find solutions.
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.
Written in a straightforward and accessible style, the Second Edition of Financial Analysis and Modeling Using Excel and VBA:
- Includes 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
- Teaches financial analysis and modeling, and illustrates advanced features of Excel and VBA, using a learn–by–doing approach
- Contains comprehensive new chapters on writing formulas that can make decisions, answering what–if questions,finding iterative solutions to problems, and much more
Equally useful to both those who are interested in financial analysis and those who are interested in financial modeling, this reliable resource will help you make the most of Excel and VBA as you navigate the complex terrain of today′s modern financial world.
