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.

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.