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.

10 Tips for Great Spreadsheet Aesthetics and Design

The aesthetic design of a spreadsheet, when done right, can add significant benefits in terms of usability and functionality.

Navigation in Excel with VBA

Using VBA to control navigation elements of a spreadsheet provides a greater level of flexibility. Through proper coding, users will be provided with responsive navigation and proper feedback.