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

Does anyone know the formula to calculate semi-annual interst only payments
with a balloon in 10 years? 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.