Excel Visual Basic for Applications (VBA) can be used to automate operations in Excel and is one of the most frequently used software programs for manipulating data and building models in banks and insurance companies. An Introduction to Excel VBA Programming: with Applications in Finance and Insurance introduces readers to the basic fundamentals of VBA Programming while demonstrating applications of VBA to solve real-world problems in finance and insurance. Assuming no prior programming experience and with reproducible examples using code and data, this text is suitable for advanced undergraduate students, graduate students, actuaries, and financial analysts who wish to learn VBA.

Features

Presents the theory behind the algorithms in detail
Includes more than 100 exercises with selected solutions
Provides VBA code in Excel files and data to reproduce the results in the book
Offers a solutions manual for qualified instructors
Contents
Part I VBA Preliminaries
Chapter 1 Introduction To VBA
Chapter 2 Excel Objects
Chapter 3 Variables, Data Types, And Scopes
Chapter 4 Operators And Control Structures
Chapter 5 Functions, Events, And File Io
Chapter 6 Error Handling And Debugging

Part II Applications
Chapter 7 Generating Payment Schedules
Chapter 8 Bootstrapping Yield Curves
Chapter 9 Generating Risk-Neutral Scenarios
Chapter 10 Valuing A Gmdb
Chapter 11 Connecting To Databases
Chapter 12 Object-Oriented Programming
Chapter A Solutions To Selected Exercises