I am looking for a loan schedule which allows for a residual

  • Thread starter Loan Schedule with residual
  • Start date
L

Loan Schedule with residual

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

Louise

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
 
N

Network Capital

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
 
Top