Creating Loan Amortization table for Variable Rate Mortgage

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.
Loan-Amortization-Schedule-2010-.xlsx
Mike McLoughlinAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

puppydogbuddyCommented:
see this link for free mortgage calc templates:
                  http://www.vertex42.com/ExcelTemplates/
                        (scroll down to page 2)
Mike McLoughlinAuthor Commented:
I can't find it. Can you give me the exact link to the variable Rate Mortgage template? Thanks!
puppydogbuddyCommented:
here is the direct link to the adjustable rate mortgage template:
                  http://www.vertex42.com/ExcelTemplates/arm-calculator.html

Reiterating the instructions, page down 2 or 3 pages until you come to the page that has Loan Calculators  and Mortgage Calculators  a little more than half way down the page.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mike McLoughlinAuthor Commented:
Thanks!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.