how do I include advance payments in the PMT function
 

Looking for forumla to accept advance paymnets to calculate correct I%

how do I include advance payments in the PMT function
 

Unless they are constant pre-payments that can be included in the formula, it
is best to create an amortization table.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Razzle Dazzle" wrote:

Looking for forumla to accept advance paymnets to calculate correct I%