Hi. I think you could do this:
Calculate the Present Value of the $5000 based on the interest rate. Subtract that number from $100000. This gives you the present value of the loan. Now calculate the loan based on that number.
Joe
>Renoir,
>
>Thanks for the info. Unfortunately the equation won't work because the residual value cannot be subtracted from the principal up front. The residual is actually the FV of the loan and it has to take into effect all of the interest and payments made. Excel has a formula that works: PMT(rate,term,PV,FV). I was hoping the VFP would have a similar formula.
>
>Thanks for your time though,
>
>Richard
Joseph C. Kempel
Systems Analyst/Programmer
JNC