Thread
:
Can excel calculate a loan payment with a balloon at the end?
View Single Post
#
3
Posted to microsoft.public.excel.misc
Wilma
external usenet poster
Posts: 14
Can excel calculate a loan payment with a balloon at the end?
"Fred Smith" wrote:
Yes it will. Use the PMT function, as in:
=pmt(intrate/12,years*12,loan,-balloon)
--
Regards,
Fred
"Darren @ Vermeer" <Darren @
wrote in message
...
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?
Reply With Quote
Wilma
View Public Profile
Find all posts by Wilma