Month: February 2015

The use of Excel’s PRICE function can eliminate much of the math required to understand how modified duration and convexity can be used to predict the price change in option-free bonds. The spreadsheet for this post is called “Option Free” and like all of my...

In my very first post back in August of last year titled “No XNFV Excel Function?” I showed formulas for calculating present value and future values when cash flows with dates are given. These formula were calculated based upon actual days between dates and a 365 day base year. I...

If you have looked at very many of my posts and spreadsheets, it is obvious that a good deal of them involve loan amortization schedules. So does this one. The first sheet in the workbook “consolidate” is called “Amortization Loan”. That is because it contains...

Math majors can skip this one. I found it looking through my files and thought it might be useful to some credit union financial managers. The math problem is: How much of a change in capital would it take to move the net worth ratio from the...

Both Child Support #1 and #2 have been simplified in order to correct a problem which includes the prepayment of support. This results in the payer earning the stated interest rate on the positive balance prepaid, which is typically much higher than market rates, and...