View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default How do I compute effective yield in Excel when there is a balloon

What formula are you using?
Give us an example of what you want solved, including the answer you are
looking for.

Regards,
Fred.

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