car loans

[Guest]

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

 

[Niek Otten]

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