On Jul 28, 5:16 pm, jack in need of assistance <jack in need of
wrote:
I would like to be able to enter varying interest rates throughout the
life of a mortgage... I need to display the historical data i.e. paid in
principal to-date, paid in interest to-date, etc.

So what exactly is your question: (a) how to design such an
amortization schedule from scratch; or (b) how to modify an existing
(MS) template? Or is your question something else altogether?

If you know the mechanics of designing an amortization schedule,
varying the interest rate is really not difficult. The requirements
you describe above are simple running totals. Do you perhaps need
help in, for example, how you would recompute the payment?

Well, I'm fishing. Happy to help. But please be more specific.