How to Calculate Mortgage Interest Using an Amortization Table

Interest is an important component of a mortgage amortization table.
i Creatas/Creatas/Getty Images

Interest is one of the key components of a mortgage amortization table. A typical amortization table shows your balance at the beginning of the month, your monthly mortgage payment, interest charged during the month, the amount of mortgage principal paid off during the month and your mortgage balance at the end of the month. Calculating interest is a simple process requiring only a calculator and the appropriate formula.

Calculating Interest

Step 1

Make sure you have the mortgage rate, and not the annual percentage rate (APR). Lenders use the mortgage rate divided by 12 to calculate your monthly interest charges and your total monthly payment. The APR is the effective annual interest rate resulting from the mortgage rate divided by 12. For example, if the mortgage rate is 6 percent, the monthly rate is 0.5 percent (6 percent divided by 12), and the APR will be 1.005^12 - 1 or 6.17 percent approximately.

Step 2

If you have only the APR available, convert it to the mortgage rate by using (1+i)^(1/12) - 1, where i is the APR. If your APR was 4.07415 percent for example, the resulting mortgage rate would be (1.0407415)^(1/12) - 1 or 4.0 percent.

Step 3

Divide the mortgage rate by 12.

Step 4

Multiply the mortgage balance by the mortgage rate divided by 12. This is the interest charged for the month.

Step 5

Subtract the interest charge from the monthly mortgage payment. This is your principal amount paid for the month.

Step 6

Subtract the principal amount paid from the mortgage balance. This is your new mortgage balance at the end of the month.

Step 7

Repeat Steps 4 to 6 for every month you wish to create an amortization table.

the nest

×