Sorry I figured it out. Use a interest rate of zero!
-----Original Message-----
Does anyone know if its possible to get equal payments
out
of the PPMT formula. That is, its set up to generate an
annuity repyament profile. I am wondering if I can set
it
up with inputs that will generate equal principal
payments. If not I will use an If Statement to do it.
Thanks
.
|