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

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


.

On Tue, 15 Feb 2005 09:04:58 -0800, "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.

Thanks


.


Or just divide PV/NPER (Loan amount divided by the number of periods in the
loan).


--ron

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?