Loan amortization schedule

Is there a template for a Loan amortization Schedule where I can change the
interest rate each time "prime" changes and there is only one payment on June
1st of each year for 6 years

Create an Amortization Schedule in Microsoft Excel
----------------------------------------------------------------

You can try this web site listed under “Excel tip”, type in the heading above.

Sorry but that’s the best I can do.

Matt