Here is the situation:
There is an OLD dbase program that a user has that he uses for compound interest calculations. For Y2K compliance all I did was some minor adjusting of the dbase code and I compiled it using FoxPro, which was great.
The way this program works is it has a table with rates and dates. From this table the program gets the interest rate that was current for that date range and calculates the interest.
The problem is that the way the program works the rates table can only have 12 rates in it…
Is there any program or Excel template or shareware or paid software that can calcualte compond interest with multiple interest rates?
I can’t be the only one looking for something like this. I don’t want to look at that dbase code again
HELP