software

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

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