ExcelMonkey wrote...
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.

Yes, but can you then determine what the total loan payments would be
including interest?