How to Calculate Mortgage Interest

PDF download Download Article
PDF download Download Article

The interest on a loan is the amount of money you pay to a lender in addition to your principal (the amount that you borrowed). Interest is typically provided as a percentage, such that the interest rate is a given fraction of the principal. A mortgage loan is a type of loan used to finance the purchase of a property. You can calculate interest paid on a mortgage loan using the interest rate, principal value (property price), and the terms of the loan (the duration and number of payments). This can be done in a number of ways, depending on what information you have and your personal preference.

Method 1
Method 1 of 3:

Calculating Interest Quickly and Easily

PDF download Download Article
  1. There is a variety of online calculators that will find your monthly payment and interest paid with the simple input of a few pieces of key information. Try searching for "mortgage loan calculator" using your preferred search engine. Usually, you'll have to input details of your loan, like the number of years, annual interest rate, and value of your principal. Then, simply hit "calculate" and the provided readout should tell you anything else you need to know. [1]
    • This can also be a useful way to compare mortgage plans. For example, you may be deciding between a 15-year loan at 6 percent or a 30-year loan at 4 percent. The calculator will help you easily see that, despite the higher interest rate, the 15-year loan is a cheaper option.
    • Keep in mind that online calculators often advertise rates that are much lower than what you can actually get. Therefore, it is best to get rates from an actual lender rather than relying on online mortgage calculators.
  2. Similar to the quick method above, this one will allow you to calculate the total interest you will pay on your loans, assuming you already know your monthly payment. However, here you will be multiplying your monthly payment by the number of payments to arrive at a total amount paid over the life of the loan.
    • Start by finding your monthly payments either on a recent bill or on your loan agreement.
    • Then, multiply your monthly payment by your number of payments.
    • Subtract your principal from the total of your payments. This number will represent the total amount you will pay in interest over the life of your loan.
    • For example, imagine you are paying $1,250 per month on a 15-year, $180,000 loan. Multiply $1,250 by your number of payments, 180 (12 payments per year*15 years), to get $225,000. Your total interest paid would then be $225,000 - $180,000, or $45,000.
    3. Advertisement
Method 2
Method 2 of 3:

Calculating Interest Using a Spreadsheet Program

PDF download Download Article
  1. Mortgage interest can be easily found using your chosen spreadsheet program. This function, in all major spreadsheet programs (Microsoft Excel, Google Spreadsheet, and Apple Numbers), is known as CUMIPMT, or the cumulative interest payment function. [2] [3] It combines information like your interest rate, number of payments, and principal to arrive at an amount for total interest paid over the life of the loan. You can then divide this information to find the amount of interest paid each month or annually.
    • For simplicity, we will be focusing on Microsoft Excel's CUMIPMT function here. The process and inputs will likely be identical or very similar for any other program you are using. Consult the help tab or customer service if you have any problems using these functions.
  2. You can use the cumulative interest payment function to determine your interest paid. Start by entering =CUMIPMT( into your spreadsheet. The program will prompt you for the following information: (rate, nper, pv, start_period, end_period, type).
    • rate here means your monthly interest rate. Again, this will be your annual interest divided by 12 and expressed as a decimal. For example, a six percent annual rate would be expressed as 0.005 here (6%/12=0.5%=0.005).
    • nper stands for "number of periods" and is asking for your total number of payments. Like before, this will be the term of your loan in year multiplied by 12 for monthly payments.
    • pv means "present value." Input your principal (amount borrowed) here.
    • start_period and end_period represent your timeframe for calculating interest. To calculate interest over the life of the loan, enter 1 for start_period and your value for nper into end_period .
    • type refers to when in each period your payments are made; 0 for the end of the month and 1 for the beginning of the month. In most cases, you should use 0.
    • Input the information, close the function with a ")" at the end, and press enter to receive your answer.
  3. The CUMIPMT function will return an amount that represents the total interest you will pay on your loan. To find the interest paid each month or year, simply divide this amount by either the number of payments or the number of years on your loan, respectively.
    • This number will also be expressed as a negative number. This doesn't mean you entered your information incorrectly, but simply that the program represents interest as an expense and therefore, a negative number. Multiply by -1 if this helps you understand and use the figure.
    4. Advertisement
Method 3
Method 3 of 3:

Calculating Mortgage Interest Manually

PDF download Download Article
  1. In order to calculate interest paid on a mortgage loan, we will calculate the monthly payment and then use the simple method from method 1 above to calculate interest. The monthly payment equation can be represented as follows: . These variables represent the following inputs:
    • M is your monthly payment.
    • P is your principal.
    • r is your monthly interest rate, calculated by dividing your annual interest rate by 12.
    • n is your number of payments (the number of months you will be paying the loan) [4]
  2. You will need to input your principal, monthly interest rate, and number of payments in order to find your monthly payment. This information can be easily found in your loan agreement or from a quoted loan estimate. Check the information again to be sure of its accuracy before using it in calculations.
    • For example, imagine you have a $100,000 mortgage loan with 6 percent annual interest over 15 years. Your input for "P" would be $100,000. For "r," you would use your monthly interest rate, which would be 0.06 (6 percent) divided by 12, or 0.005 (0.5 percent). For "n" you would use your total number of payments, one for each month in fifteen years, which would be 12*15, or 180.
    • In this example, your complete equation would look like this:
  3. Simplify your terms by doing the first step in the order of operations, which is adding the 1 and "r" inside the parentheses on the top and bottom of the equation. This is a simple step that will make your equation look much less complicated.
    • After this step, your sample equation would look like this:
  4. The result of the previous step must now be raised to the power of "n." Keep in mind that only the figures inside the parentheses will be raised to this power, not the "r" outside of it or the -1 at the end.
    • After this step the sample equation would look like this:
  5. Here, you should multiple "r" times the result of the last step on the top (the numerator) and subtract 1 from your result on the bottom (the denominator).
    • The same equation would look like this after this step:
    • In the example, your equation would now be:
  7. This will give you your monthly loan payment.
    • In the example, this would be ($100,000)*(0.008439), or $843.90. This represents your monthly payments.
  8. With this information, you can now calculate total interest paid and interest paid each month. Both will allow you to compare different amounts of interest you might pay with different loans and see which one is right for you.
    • Find monthly interest paid by dividing "P" by "n" and subtracting this number for your monthly payments, "M."
    • Find total interest paid by multiplying your monthly payment "M" by "n" and then subtracting "P."
    9. Advertisement

Calculating Mortgage Interest Glossary, Calculator, Practice Problems, and Answers

Expert Q&A

Search
Add New Question
  • Question
    If a mortgage payment is due on March 1, is the interest charged for the month of March or is it for the previous month of February?
    Ryan Baril
    VP, CAPITALPlus Mortgage
    Ryan Baril is the Vice President of CAPITALPlus Mortgage, a boutique mortgage origination and underwriting company founded in 2001. Ryan has been educating consumers about the mortgage process and general finance for almost 20 years. He graduated from the University of Central Florida in 2012 with a B.S.B.A. in Marketing.
    Ryan Baril
    VP, CAPITALPlus Mortgage
    Expert Answer
    Interest is charged in arrears, so the interest paid on your March 1 payment was accrued in February.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 4
  • Question
    How much can I add to my mortgage payment to reduce time?
    Ryan Baril
    VP, CAPITALPlus Mortgage
    Ryan Baril is the Vice President of CAPITALPlus Mortgage, a boutique mortgage origination and underwriting company founded in 2001. Ryan has been educating consumers about the mortgage process and general finance for almost 20 years. He graduated from the University of Central Florida in 2012 with a B.S.B.A. in Marketing.
    Ryan Baril
    VP, CAPITALPlus Mortgage
    Expert Answer
    Any additional payment you make on your mortgage above and beyond your monthly minimum will help reduce your interest paid and time to satisfaction. Just be sure to include “apply excess to principle” on the check that contains the extra payment.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 4
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Calculate Mortgage Payoff
      How to
      Calculate Mortgage Payments
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Pay off Someone Else's Mortgage
      How to
      Add Someone to Your Mortgage
      How to
      Remove a Name from a Mortgage Without Refinancing
      How to
      Calculate an Escrow Payment
      How to
      Assume a Mortgage
      How to
      Talk to Mortgage Lenders
      How to
      Remove a Lien
      Advertisement

      References

      1. ↑ https://www.bankrate.com/calculators/mortgages/mortgage-payment-calculator.aspx
      2. ↑ https://support.google.com/docs/answer/3093211?hl=en
      3. ↑ https://www.apple.com/mac/numbers/compatibility/functions.html
      4. ↑ https://www.mtgprofessor.com/formulas.htm

      About This Article

      Article Summary X

      To calculate mortgage interest, start by multiplying your monthly payment by the total number of payments you'll make. Then, subtract the principal amount from that number to get your mortgage interest. For example, if you're paying $1,250 dollars a month on a 15-year, $180,000 loan, you would start by multiplying $1,250 by 15 to get $225,000. Then, you would subtract $180,000 from $225,000 to get $45,000, which is the total mortgage interest. To learn the formula for manually calculating mortgage interest, scroll down!

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 428,846 times.

      Reader Success Stories

      • Tsietsi Makua

        Apr 29, 2018

        "I have always heard other people talking about paying an extra amount toward their mortgages to assist with saving ..." more
      More reader stories Hide reader stories
      Share your story

      Did this article help you?

      Advertisement