I really wasn't very clear on what I was looking for. I just want to easily
view the amount of interest due based on today's date. I have a number of
loans outstanding and would like to easily see what the payoff is for today.

"Sean Timmons" wrote:

So, you have principal, interest rate, compunding frequency
And want just the annual interest rate.


You'll want:

=ISPMT()
Requires Rate per period, interest period you're searching for, nuber of
periods in an annuity, and present value of the field.

You can have the periods section as a sum of dateB-dateA...


"Davis" wrote:

What's the easiest way to compute the annual percentage rate on a given cell.
I typically multiply the principal amount by the interest rate/divide by
365/and then multiply by the number of days since the loan was made. Is
there an easier way to do this by use of one of the date/time functions in
Excel?

Thanks.