Finance & Accounting Resources

Bond Duration Spreadsheet: use the spreadsheet below to calculate a bond's duration (it's weighted average effective timing of cash flow), the modified duration (for every % change in interest rates, the expected % change in price (in the opposite direction).