View Single Post
  #1   Report Post  
Dan Patrick
 
Posts: n/a
Default Calculating number of periods when payment amount changes

I'm working on a plan to pay off my mortgage early. Each year I plan to
increase the amount I am paying by a fixed amount. For example, this year I
will pay $800. Starting next year I will pay $850, the year after that, $900,
and so on.

I know the NPER function to calculate the number of periods given a rate,
fixed payment, and present value.

How can I calculate the number of periods required to pay off the loan when
the payment is changing, assuming the timing and amount of the change are
known?

Thanks for your help.