# VBA for the Macaulay Duration

The Macaulay Duration is a fundamental characteristic of a bond, and is the weighted average of the time until each payment is received.

The Macaulay Duration is a fundamental characteristic of a bond, and is the weighted average of the time until each payment is received.

Calculate the redemption yield of a bond via the bisection method and VBA.

Want to know where the bond pricing equation comes from?

These equations will help you manage your credit card debt. The math isn’t scary!

Learn how to convert between interest rates with different compounding frequencies.

Yahoo Finance gives beta values for stocks. But how are these values calculated? Find out how with a detailed step-by-step explanation.

This Excel spreadsheet downloads historical dividend data and calculates annual dividend growth rates for a set of user-specified stock tickers.

This is a simple but remarkably insightful method of valuing stocks.

Want to know how much that new car will cost? Just crack open Excel and load this spreadsheet.

Sometimes I just want stock market data in Excel, and I don’t want to spin my wheels hacking about with VBA.