Can excel calculate a loan payment with a balloon at the end?

I�m trying to use excel to calculate a loan payment under the flowing
parameters; some number of equal consecutive monthly payments followed by a
residual or �balloon� due at the end of the term. Will excel do this and if
so how?

Yes it will. Use the PMT function, as in:

=pmt(intrate/12,years*12,loan,-balloon)

--
Regards,
Fred


"Darren @ Vermeer" <Darren @ Vermeer@discussions.microsoft.com> wrote in message
news:4C43592A-A238-440C-ABCB-3D90171A9A0E@microsoft.com...
> I'm trying to use excel to calculate a loan payment under the flowing
> parameters; some number of equal consecutive monthly payments followed by a
> residual or "balloon" due at the end of the term. Will excel do this and if
> so how?