I need to convert a Excel Function to an ASP (VBScript) function and need some help.
I have found some posts that help but none that take into account a Residual value or FV.
B17 = Interest Rate = 7.95
B9 = Term in years = 5
B7 = Finance Amount before Residual = 25000
B10 = Residual Amount = 14000
MONTHLY = PMT((B17/12),B9*12,-B7,B10,0)
MONTHLY Should equal $315
What would the VBscript equivilant be?
Your help would be great.