Loan Table templates allowing for payments in advance

[emc]

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

 

[Fred Smith]

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.