Loan Calculator w/Extra Payments
- If you want to calculate how much a mortgage payment will be on a $200,000 mortgage at 4.25% interest for 360 months, you would enter:
Now, let's say you would like to make extra monthly principal payments of $116.12 (to round the payment to $1100) for the next 10 years starting in July of 2018. You'll enter:
- 200000 (or 200,000) for Loan Amount
- 360 for Months
- 4.25 for Interest Rate (Compounded Monthly)
- Press the Payment button, and you'll see that your payment would be $983.88. You will pay about $154,196.69 in interest over the life of this loan. Make sure that the month and year of your first payment is reflected in the first payment due field (in this case -June 2015).
- Monthly for how often extra principal payments will be made.
- 116.12 for the extra payment amount
- Select July and 2018 as the first extra payment date
- Select July and 2028 as the date to which the last extra payment will be made. (June will be the last extra payment.)
- Press the View Amortization Schedule button, and you'll see that your mortgage will be paid in 326 months (instead of 360 months) and you'll pay about $134,652.34 in interest (instead of $154,196.69).
- In this next example, let's say you took out a 30 year (360 months), $200,000 mortgage in May of 1996 (first payment due June 1996) at 7.5% interest. Your required payments are $1398.43, yet you have been making monthly payments of $1500 (which you intend to continue) with the excess going to principal. Recently, you have received an inheritance and have decided to apply an additional $25,000 to your mortgage principal in Jan 2014. When will the mortgage be paid in full?
- 200,000 for the Loan Amount
- Leave the Months field blank
- 7.5 for Interest Rate (Compounded Monthly)
- 1500 for Payment
- Select May 1996 for when the first payment was due.
- Press the Months button, and you'll see that you'll pay $1500 for 287.58 months before your mortgage will be paid in full. You'll pay about $231,365.95 in interest over the life of this loan.
- Select One Time Only
- 25000 extra payment
- Select Jan and 2014 for when you'll make the extra payment
- Just change this field to any YEAR AFTER the One Time Only payment will be made.
- Now, press the View Amortization Schedule button. You'll see that your mortgage will be paid in just 263 months (instead of 288 months) and you'll pay just $219,436.93 interest (instead of $231,365.95). You'll make your final mortgage payment in March of 2018!
So with the extra monthly payment of $101.57 and a one-time-only payment of $25,000 you'll save about $84,000 and 8 years of monthly payments! - YEAH!!!
I welcome your links to MyCalculators.comTo link to THIS page, please copy the following HTML code and paste it into your page.
<a href="https://www.mycalculators.com/ca/loancxpsm.html" title="Loan Calculator with Extra Payments" target="_top">Loan Calculator with Extra Payments |- MyCalculators.com</a>It will appear on your page as: Loan Calculator with Extra Payments |- MyCalculators.com