Creating Loan Amortization table for Variable Rate Mortgage

Mike McLoughlin
Mike McLoughlin used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
see this link for free mortgage calc templates:
                  http://www.vertex42.com/ExcelTemplates/
                        (scroll down to page 2)

Author

Commented:
I can't find it. Can you give me the exact link to the variable Rate Mortgage template? Thanks!
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.

Author

Commented:
Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial