Financial Analysis And Modeling Using Excel And VBA (With - CD) 2nd Edition (English, Paperback, Chandan Sengupta

Financial Analysis And Modeling Using Excel And VBA (With - CD) provides an in-depth coverage of using Excel with VBA for financial analysis.

Summary Of the Book

Using sophisticated applications like Excel simplifies tasks like performing complex financial analysis. But, these methods require a deeper knowledge of the program, a more advanced understanding of techniques than the average user would have. Microsoft Excel is a full featured spreadsheet that can handle anything from just tabulating data to performing complex calculations, analysis, and creating graphs.
Excel can also be extended and customized using VBA, an implementation of the Visual Basic programming language within the environments of an application. Visual Basic for Applications provides a powerful tool for modifying or enhancing the functionalities of applications like Excel, Word, Access etc.

Financial Analysis And Modeling Using Excel And VBA (With - CD) explains how to use Excel and VBA together for carrying out complex financial analysis. The material in the book is divided into four parts. It begins with providing an overview of Excel for Financial Analysis and Modeling. This section provides an introduction to the principles and techniques of financial modeling and analysis. It also discusses Excel basics and Excel 2007. This part also goes into advanced features of Excel, doing statistical analysis, dealing with what-if questions, making decisions, looking up variables, using Excel’s many built in functions, and analyzing databases.

The second part addresses actual Financial Modeling Using Excel. It explains how to build good financial models in Excel, analysing market history, simulating stock prices, and financial statements forecasting. It also discusses time value of money, options and options portfolios and other related concepts. The third part looks at using VBA for Financial Modeling. It discuss VBA basics, and explains Sub and Function procedures. It also shows how to debug VBA code. Part four focuses on implementing Financial Modeling Using VBA. It shows how to use VBA to create the models and analytical methods discussed in chapter three, where these were implemented using Excel’s built-in features.

Financial Analysis And Modeling Using Excel And VBA (With - CD) provides an updated coverage to using Excel 2007 functionalities and features. It also provides an overview of financial analysis techniques and modeling methods. It uses many real world examples to provide a deeper understanding of the concepts covered. The CD that comes with the book contains the full working versions for the models discussed in the book. It also contains many more useful modeling tools.

About Chandan Sengupta

Chandan Sengupta teaches finance in MBA programs. He has also written two other books called Financial Modeling Using C++ and The Only Proven Road to Investment Success: Everyone's Simple Guide to a Safe Trip. Chandan Sengupta worked in the corporate sector before taking up teaching. He has worked for Mobil Corporation and the Chase Manhattan Bank in senior executive and advisory positions. He is now in a faculty member of the Fordham University Graduate School of Business.