Loan Table templates allowing for payments in advance
 

Is there a loan amortitization template to allow for payments in advance? The
templates I have come across seem to calculate in arrears. I use Microsoft
Office Excel 2003

Thank you

Loan Table templates allowing for payments in advance
 

You can easily adjust for payments in advance. If you borrow $100,000 with
payments (in advance) of $2500/month, you've really borrowed only $97,500.
So simply deduct your first payment from the principal, then use the
template.

Regards,
Fred.

"emc" wrote in message
...
Is there a loan amortitization template to allow for payments in advance?
The
templates I have come across seem to calculate in arrears. I use Microsoft
Office Excel 2003

Thank you