Loan Table templates allowing for payments in advance

E

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
 
F

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.
 
Top