=-PMT(0.05625/12,360,260000)-0.05625/12*(260000*(1-(1-(1+0.05625/12)^17)/(1-(1+0.05625/12)^360))-25000)

Perhaps we could merge Excel's PMT function into your excellent equation
from above.

= r * (((r + 1) ^ n * s) / ((r + 1) ^ 360 - 1) + xp)

Here's the vba version if the op wishes to follow...

Sub Demo()
'// Dana DeLouis
Dim r, n, s, xp

r = 0.05625 / 12
s = 260000
xp = 25000
n = 17

Debug.Print _
r * (((r + 1) ^ n * s) / ((r + 1) ^ 360 - 1) + xp)

' 418.144224788268
End Sub

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"Dave Dodson" wrote in message
ups.com...
=-PMT(0.05625/12,360,260000)-0.05625/12*(260000*(1-(1-(1+0.05625/12)^17)/(1-(1+0.05625/12)^360))-25000)

Dave