PPMT formula that generates equal payments
 

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?