Allow me your email address and shall forward as an attachment a spreadsheet
which calcualtes payments in advance or arrears and makes allowance for
residual or balloon payments. From there it generates an amortization
schedule. regards

"Loan Schedule with residual" wrote:

All of the loan amortisation tables in Excel assume a nil balance at the end
- I am looking for one which allows a balance at the end, ie: a residual.