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

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

--
Kind regards,

Niek Otten

"Monty" <[email protected]> wrote in message news:[email protected]...
> 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