View Single Post
  #2   Report Post  
ExcelMonkey
 
Posts: n/a
Default

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


.