View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Formula to calc. semi-annual int. only pmt. with balloon in 10 yr

On Jan 2, 3:06*pm, tmac wrote:
Does anyone know the formula to calculate semi-annual interst only payments
with a balloon in 10 years?


If the payment is truly "interest only", then the payment is simply
the balance of the loan times the applicable interest rate. For semi-
annual payments, the "applicate interest rate" is the annual rate
divided by two.

For example, for an interest-only loan of $10,000 at 5%, the semi-
annual payment is 10000*5%/2, which is $250. After 10 years, you
would have paid $60,000 in interest (total payments), and your last
payment would be $10,000 in addition to the interest ($250).


I thought it was IPMT, but it does not appear
correct. I thought the interest payment would remain the same for each
semi-annual payment until the principal balloon payment is made in year ten.