Home Mortgage Calculation

An Excel file that teaches how to perform Home Mortgage Calculation operation.

Excel Professional Home Mortgage Calculation

The loan amount, interest rate, and term are entered into the table. The monthly installment amount is calculated using a formula. The principal and interest rate are shown separately. The total repayment table is generated automatically. The graph shows the decrease in debt.

Hope it is useful.