Shaun,

You need to use your template twice - once with 8% for 13 years and your original amount
($2,500,000), then again with that loan's ending balance after 12 months($2,385,956.43) with 10% and
12 years as the rate and length.

HTH,
Bernie
MS Excel MVP


"Shaun" wrote in message
...
I am using a Amortization Schedule template from Microsoft Office online.
While this template is helpful for cases of fixed rate of interest over the
period, I was looking for a template which would allow for variable rates of
interest.
My current loan amount is 2500000.
Annual Interest Rate for first 12 months is 8% and for the rest period would
be 10%. Loan period 13 years, Number of payments per year 12.
Please help me out here.