Includes index.

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.

SACFinal081324