I have an amount of $170 (D76). The starting date is 7/15/05 (D66). Payment date of interest is 12/15/2012 (D3). Interest rate change on a quarterly basis. These rate amount are located in D32 - D55 and H32-H55. Interest should be compounded daily. I have attached the file for your review.
I need to write a formula that will calculate the related interest on the amounts in D71-D76. Is there a look-up feature that can do this? Or, should I just work out a formula for each quarter period?1291-Working.xlsx
Thank you for the help.