Excel VBA to compute a period interest based on several variable rates

I need my worksheet to compute interest pmts due. I have several different principal amts and, in most cases, each period within my Start Date and End Date has several interest rates. I have two workseets in my file. The first had a list of all the principal amounts and the second had a list of the interest rates and the effective start dates of the int rates. I need to write a macro because I use this quite often and sometimes I have many different principal amounts. Please help! THanks.

Leave a Reply

Your email address will not be published. Required fields are marked *