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.

Rev. ed. of: Financial modeling. c2004.

Introduction to financial analysis and modeling -- Excel 2007 and previous Excel versions -- Excel basics -- Advanced excel features -- Making decisions and looking up values -- Analyzing data -- Answering what-if questions -- Finding iterative solutions -- Doing statistical analysis -- Using Excel's financial functions -- Other useful Excel functions.