Case Study: VBA Implementation of a Bond Ladder

This is a short post showcasing some of the VBA procedures, classes, and coding techniques in last month’s bond ladder financial model. The model relies heavily on VBA, using it to manage displays, calculations, and data storage.

Financial Model: Bond Ladder

This post introduces a new financial model — an Excel/VBA implementation of a bond ladder portfolio and summary. Its general purpose is to calculate an average weighted yield for a ladder of bonds.

Financial Model: Coffee Brewing Methods

In recognition of National Coffee Day, I’ve put together a simple financial model to compare the cost of coffee brewing methods. While most holiday backers seem to be trying to get you to spend more on coffee, I’m here to help you spend less! By inputting basic details on your …