Calculating loan payoff (with multiple disbursements).

[HUDAV847]

I am using Excel 97 SR-1

I am trying to use a function (I don't know which one to use) that will
calculate a loan payoff. The problem is that there were multiple disbursements
made. I want to use a single interest rate to calculate the payoff as of
today's date. (I know how to convert dates into integers.)

Here are the disbursements:

10/09/02 -300.00
11/12/02 -450.00
12/12/02 -460.00
11/13/03 - 20.00

I want to use an interest rate of 5% and calculate the payoff as of today's
date.

Can anyone help?

Thanks in advance!