simple mortgage calculator with extra payments

In the first place, the Total Payment (principal + interest) now decreases to $396,277.94.Therefore, let’s see it in action.Īt this time, the monthly payment remains the same at $1791.08 while the extra, recurring payments and the loan details are shown in the Summary table. In this case, you’ve chosen to pay $500 for the rest of the loan period. So, you want to add an extra bi-monthly recurring payment starting from the 24th period. Now, for the second case, you’ve already made 20 payments, moreover, your monthly income has gone up. Read More: Multiple Loan Amortization Schedule Excel TemplateĬase-2: Amortization Schedule with Regular Extra Payment (Recurring Extra Payment) Just like that, your amortization schedule is complete, it’s that simple!

📃 Note: In addition, the orange numbers denote those periods for which you should have cleared your payments. Then, the Total Period of the loan consists of 20 years or 240 months.Next, the Total Interest Paid over the maturity of the loan is $179,858.64.First and foremost, the Total Payment (principal + interest) is $429,858.64.Here, the monthly payment is $1791.08 and you’ll find the additional loan details in the Summary table. So, just enter the above information in their respective cells and the amortization schedule will be generated, as shown in the picture below. Finally, the Payment Frequency is Monthly.įurthermore, you want to know what your monthly payment will be.Fourth, the Payment Type involves paying at the End of the Period.Third, the Annual Percentage Rate ( APR) consists of 6%.Second, the Loan Term spans over 20 years.Now, let us consider the following scenario, where you took a home loan (or for any other purpose) with the following details: Therefore, without further delay, let’s explore them one by one.Ĭase-1: Amortization Schedule with Regular Payment (PMT) Amortization Schedule with Irregular Extra Payment (Irregular Extra Payments).Amortization Schedule with Regular Extra Payment (Recurring Extra Payment).Amortization Schedule with Regular Payment (PMT).Indeed, this article will help you to pay off your mortgage in 3 diverse ways: are self-explanatory.ģ Ways to Calculate Amortization Schedule with Irregular Payments Lastly, other terms such as the Extra Amount You Plan to Add, Extra Payment (Recurring) Pay, and Extra Payment Starts from Payment No. In contrast, in some countries like Canada, though payment is monthly, interest compounding may be semi-annually. Simply put, if your payment frequency is monthly, then your interest is also compounded monthly. Interest Compounded: In general, it is equal to the payment frequency. This would lead to gradually lower monthly payments.6. Rates are extremely high and a person believes that the rates are gradually going toĭecrease over time. 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).Īnother reason an adjustable rate mortgage might be desirable is if the interest 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 home is purchased during a period in which interest rates are extremely low, you might expect the rates to gradually increase.

This means that your monthly payment can change! After that, the interest rate can adjust at a frequency of once per year. A 5/1 ARM means the interest rate remains fixed for 5 years (60 months).

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). What is an Adjustable Rate Mortgage (ARM)? You can also edit the interest rate to be used for calculating the interest each month. The actual payment should only be the principal+interest portion (the spreadsheet does not track fees or escrow). When you enter the Actual Payment, the extra payment column is calculated for you. The date the payment is received or paid is just for reference (interest is not prorated based on the date paid). In this new version (added ), columns have been added for basic payment tracking.

Simple mortgage calculator with extra payments