View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beanman Beanman is offline
external usenet poster
 
Posts: 1
Default How do I compute effective yield in Excel when there is a balloon

The CUMIPMT and CUMPRINC always result in too long an amort period so loan
fee is not fully amortized by maturity.