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

[Darren @ Vermeer]

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?

 

[Fred Smith]

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

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

 

[Wilma]

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

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