car loans
 

if i know the loan amount say 22,000, the APR 10.49%, the loan is for 36
months, but on month 36 i have a balloon amount of 14,500 left to pay. how do
i calculate the monthly payment and the amount of interest i have paid over
the period before the balloon amount is to be paid

car loans
 

=PMT(10.49%/12,36,22000,14500) and
=IPMT(10.49%/12,36,36,22000,14500)

--
Kind regards,

Niek Otten

"Monty" wrote in message ...
if i know the loan amount say 22,000, the APR 10.49%, the loan is for 36
months, but on month 36 i have a balloon amount of 14,500 left to pay. how do
i calculate the monthly payment and the amount of interest i have paid over
the period before the balloon amount is to be paid