ARM Loan CalculatorDownload a free ARM calculator for Excel that estimates the monthly payments and amortization schedule for adjustable rate mortgages. This spreadsheet is one of the only ARM calculators that allows you to also include additional payments. The monthly interest rate is calculated via a formula, but the rate can also be input manually if needed (i.e. overwriting the cell formula).
Note: This spreadsheet is meant for educational purposes only. We believe the calculations to be correct, but do not guarantee the results. Please consult your financial advisor or lending institution before making any final financial decisions. What is an Adjustable Rate Mortgage (ARM)?There are many types of ARMs, but this spreadsheet provides a way to calculate estimated payments for a Fully Amortizing ARM (the most common type of ARM). As an example, consider a "5/1 ARM". A 5/1 ARM means the interest rate remains fixed for 5 years (60 months). After that, the interest rate can adjust at a frequency of once per year. This means that your monthly payment can change! If a home is purchased during a period in which interest rates are extremely low, you might expect the rates to gradually increase. If a person knows they are going to sell a home after 7 years, then a 5/1 or 7/1 ARM might be desirable. If a person is going to own a home for more than 10 years, an ARM can be risky! Because they are risky, adjustable rate mortgage loans often have lower initial interest rates (which is why people seem to like them). Another reason an adjustable rate mortgage might be desirable is if the interest rates are extremely high and a person believes that the rates are gradually going to decrease over time. This would lead to gradually lower monthly payments. SEE ALSO: Amortization Calculator (web-based) Simple Interest Amortization Auto Loan Calculator Balloon Payment Loan Calculator Extra Payment Mortgage Calculator Amortization Schedule (with optional extra payments) Amortization Formulas in Excel, Amortization Calculation Home Ownership Expense Calculator REFERENCES: Adjustable Rate Mortgage Calculator, One of the Financial Calculators at http://www.dinkytown.net Adjustable Rate Mortgages Without Negative Amortization, One of "The Mortgage Professor's Calculators" at http://www.mtgprofessor.com | ||||
|
Excel Templates
> Invoice
> Mortgage
|
| © 2005 Vertex42, LLC All rights reserved. | ARM Loan Calculator for Excel |