How do I calculate loan balances when payments are missed?

[Guest]

I would like to have a template for a Loan Amortization Schedule that would
allow manual entry of the payment date and amount (if any). The program would
recalculate the balance accordingly.

 

[Guest]

You can search office online. This is one set of results with the term "loan"
http://office.microsoft.com/en-us/results.aspx?Scope=TC&Query=loan

 

[Guest]

I need to restate my request. I need a template for a loan amortization
schedule that will allow manual entry of the payment date and amount (if any)
when the actual date of payment or payment amount is DIFFERENT than the
schedule provides. If a payment is made three months late, for example, the
program would recalculate the additional interest and add it to the loan
balance. Sorry for the inconvenience!