Hi
Would the PMT function work for this, as you are able to specify 'fv' -
future value. This is the balance left at the end of the loan.

HTH.
Louise

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