In Spencer’s Advanced Amortization Model, you have either the option of holding the mortgage payment static or making the mortgage payment dynamic (i.e. re-calculating / re-amortize monthly) based on the interest-calc method.
To choose a dynamic payment type, simply toggle the value in cell F16 to ‘Dynamic’. You’ll then see the monthly mortgage payment in column G will adjust by period.