When you use the pmt function there is an optional argument for fv which is
future value. Set that to your balloon payment as it is the amount of the
loan that remains outstanding at the end of the loan period.
--
HTH...

Jim Thomlinson


"Dommerdog" wrote:

I'm looking for a loan amortization template which will calculate monthly
payments taking into account a final balloon payment. Does anybody have one
of these?