In the attached Excel Loan Amortization Schedule I want to add a column which excel will use to calculate the interest for a loan that is subject to variable rate interest. I want to compare interest cost scenarios for the next ten years. The Loan Amortization Template works for a fixed rate mortgage. I would like to also set up a loan amortization schedule for a variable rate mortgage and a mixed rate mortgage where a portion of the loan is fixed and another portion is variable. It would b much appreciated if someone could add the formulas I need to use to a new spreadsheet and upload it as an example. Thank you.