The Quick Formula to Determine Your House Payment (2024)

    Trending Categories:
  • Building Credit
  • Credit 101
  • Credit Cards
  • Credit Repair
  • Investing
  • Personal Finance
  • >>
    • Taxes
    • Loans

Legal DisclosureAdvertiser Disclosure

Blog Home > Loans > Mortgages > How to Determine Your House Payment: The Quick Formula

PublishedDecember 7, 2017 | 13min. read

Scott Sheldon

Scott Sheldon is a senior loan officer and consumer advocate in S... Read More

1 comments

  • The Quick Formula to Determine Your House Payment (4)
  • The Quick Formula to Determine Your House Payment (5)
  • The Quick Formula to Determine Your House Payment (6)
  • When you’re shopping for a house and considering a mortgage loan, establishing what you can afford for house payments can be a lengthy process. You have to run calculations, get updated payment scenarios from your mortgage company, and determine whether or not you can qualify.

    With all these moving parts, we hope it comes as a relief to hear there’s a simpler way to calculate a home payment. This simple solution will be a huge help in a competitive market that doesn’t allow for extended number crunching.

    Terms to Know

    Before we get into the nitty-gritty, it will be helpful to know these two key terms when using our easy house payment formula.

    1. House Payment or PITI

    PITI is an initialism used to reference the four factors that influence your monthly house payment:

    • Principle is the amount borrowed, specifically how much of your loan you’re scheduled to pay off each month.
    • Interest is how much it costs to use your loan, and your monthly payment is based on your interest rates.
    • Taxes refer to the property taxes rolled into your monthly house payment and are sometimes called an escrow or impound account.
    • Insurance is the amount of the mortgage payment that goes toward hazard and fire insurance.

      Get matched with a personal loan that’s right for you today.

      Learn more The Quick Formula to Determine Your House Payment (7)

      " + ""); $(msgname).delay(chatDelay).fadeIn(); $(spinner).delay(chatDelay2).hide(1); $(msginner).delay(chatDelay3).fadeIn(); setTimeout(onRowAdded, chatDelay); setTimeout(onRowAdded, chatDelay3); chatDelay = chatDelay3; }); function amOneAd2Clear() { $(".amone-2-chat-message-list").html(""); }; setTimeout(amOneAd2Clear, 13000); setTimeout(amOneAd2Loop, 13000); }; amOneAd2Loop(); }();

      2. Debt-to-Income Ratio (DTI)

      Important for determining how easily you’ll be able to pay off your debts, the DTI is the percentage of your total monthly debt against your monthly income. In math terms, it looks like this:

      (PITI + monthly liabilities) ÷ monthly income = DTI

      Most lenders prefer your DTI stays at or under 45%, so it’s important to consider your other monthly liabilities alongside your PITI when getting a mortgage.

      The Basic House Payment Calculations Most Lenders Won’t Share

      Now that you’re familiar with PITI and DTI, you’re ready for this simple truth: for each $100,000 you borrow, expect a monthly mortgage payment, or PITI, of $725.

      It’s true! In most cases, your principal, interest, property taxes, and home insurance for $100,000 will come out to about $725 each month. Here’s a handy table for reference:

      Amount BorrowedApproximate PITI
      $100,000$725
      $200,000$1,450
      $300,000$2,175
      $400,000$2,900
      $500,000$3,625

      You can easily add half of $725 (that’s $362.50) if you’re trying to calculate for an extra $50,000. Or you can divide the loan amount by $100,000 and multiply the result by $725 to get the estimated PITI for your loan.

      The Ins and Outs of Calculating PITI

      Let’s look at an example. Say you want to buy a $350,000 home. You want to know whether the payment is affordable and whether you’ll meet your lender’s debt ratio thresholds.

      Pretend you already have a 20% down payment ready, which is $70,000 for a $350,000 home. So in total, you’ll be borrowing $280,000. Divide that by $100,000 and you get 2.8. Using this information, the basic house payment formula will look like this:

      $725 x 2.8 = $2,030

      To spell it out, we know that when you borrow $100,000, your PITI will be about $725 per month. When we divide $280,000 by $100,000, we get 2.8. Similarly to how multiplying $100,000 by 2.8 will result in the full loan amount, multiplying $725 by 2.8 will give us the total PITI amount. So the total PITI would be $2,030 per month.

      The Ins and Outs of Calculating DTI

      Once you’ve calculated the PITI, make sure you’ve got a debt-to-income ratio a lender will approve of. Remember, the highest DTI most lenders will allow is 45%. Continuing with our example and using an income of $4,750, here’s how to find the DTI for a $2,030 PITI if you have no other monthly liabilities:

      $2,030 ÷ $4,750 = 42.74%

      As you can see, you simply divide the PITI by your income. In this case, the result is 42.74%, which is low enough to possibly qualify for a loan.

      The Application of Monthly Liabilities

      Remember to include any other monthly liabilities you have when you calculate your DTI. Let’s see if you can still reasonably afford the house with hypothetical monthly liabilities.

      Pretend you have a car lease payment of $300 a month and credit card payments of $80 a month. This changes our previous DTI formula like so:

      ($2,030 + $300 + $80) ÷ $4,750 = 50.74%

      With those debts, you would have a 50.74% DTI, which means you likely wouldn’t qualify for that large of a loan. That’s a rather different situation, so don’t forget to include your monthly liabilities when calculating DTI.

      Personalizing Your DTI

      Your monthly income and expenses may be very different from our hypothetical scenario. Try plugging in your PITI with the formula below to get your personal DTI, and make sure it’s below 45%:

      (PITI + monthly liabilities) ÷ monthly income = DTI

      Remember, even if your DTI is below 45%, you need to consider your lifestyle and other living costs when deciding on a home. Are you willing to be house poor for a large mortgage, or will you be just as happy with less home and more spending money each month? The choice is up to you!

      Factors Beyond the Formula

      Our formulas for PITI and DTI are best for a solid estimation, but they’re not exact for every unique situation. Here are some other factors that will affect your monthly house payments:

      • Private mortgage insurance (PMI) comes into play when you have a down payment under 20%. PMI helps lenders offset the risk of you defaulting on the mortgage.
      • Large down payments, on the other hand, will positively influence your borrowing power.
      • Assets and reserves need to be disclosed to most lenders, and you’ll need two months or more of PITI in the bank to meet their requirements.
      • Credit scores can influence interest rates, and if your score is below 620, you may not qualify for a home loan. Every month, check your credit scores for free on Credit.com to see where you stand.

      If you’re thinking of buying a home or are currently preparing to purchase one, check out some of our other mortgage tips and tricks.
      Image: Hemera

      Previous Post

      « 10 Things to Know Before Getting a Credit Card

      Next Post

      The Widow or Widower’s Guide to Social Security Benefits »

      You Might Also Like

      Credit Union vs. Bank Mortgage: Which Should You Choose?

      Learn more about credit union mortgage options. Use this credit u... Read More

      December 13, 2023

      Mortgages

      How Much Cash Do You Really Need to Buy a Home?

      Are you ready to buy a home? It’s an exciting—and stressfulâ€... Read More

      June 7, 2021

      Mortgages

      The Lenders Giving Borrowers Second Chance Loans

      Brenda Woods didn’t want to move and leave the garden she h... Read More

      December 15, 2020

      Mortgages
      The Quick Formula to Determine Your House Payment (2024)

      FAQs

      The Quick Formula to Determine Your House Payment? ›

      For example, if your interest rate is 6 percent, you would divide 0.06 by 12 to get a monthly rate of 0.005. You would then multiply this number by the amount of your loan to calculate your loan payment. If your loan amount is $100,000, you would multiply $100,000 by 0.005 for a monthly payment of $500.

      What is the formula for finding monthly payment? ›

      The formula is: M = P [ i(1 + i)^n ] / [ (1 + i)^n – 1], where M is the monthly payment, P is the loan amount, i is the interest rate (divided by 12) and n is the number of monthly payments.

      What is the rule of thumb for calculating a mortgage payment? ›

      Lenders call this the “front-end” ratio. In other words, if your monthly gross income is $10,000 or $120,000 annually, your mortgage payment should be $2,800 or less. Lenders usually require housing expenses plus long-term debt to less than or equal to 33% or 36% of monthly gross income.

      What is the Excel formula for mortgage payment? ›

      Use the PMT function in Excel to create the formula: PMT(rate, nper, pv, [fv], [type]). 1 This formula lets you calculate monthly payments when you divide the annual interest rate by 12, for the number of months in a year.

      What formula do you use for mortgages? ›

      Mortgage payment formula

      Monthly interest rate: Lenders provide you an annual rate so you'll need to divide that figure by 12 (the number of months in a year) to get the monthly rate. If your interest rate is 5 percent, your monthly rate would be 0.004167 (0.05/12=0.004167).

      What formula do you use for monthly payments? ›

      Divide the interest rate you're being charged by the number of payments you'll make each year, usually 12 months. Multiply that figure by the initial balance of your loan, which should start at the full amount you borrowed.

      How do I calculate a mortgage payment manually? ›

      If your loan amount is $100,000, you would multiply $100,000 by 0.005 for a monthly payment of $500. A simpler calculation may be first multiplying the loan amount of $100,000 by the interest rate of 0.06 to get $6,000 of yearly interest, then dividing that $6,000 by 12 to get your monthly payment of $500.

      How much house can I afford if I make $36,000 a year? ›

      On a salary of $36,000 per year, you can afford a house priced around $100,000-$110,000 with a monthly payment of just over $1,000. This assumes you have no other debts you're paying off, but also that you haven't been able to save much for a down payment.

      How much house can I afford if I make $70,000 a year? ›

      The home price you can afford depends on your specific financial situation—your down payment, existing debts, and mortgage rate all play a role. Most experts recommend spending 25% to 36% of your gross monthly income on housing. For a $70,000 salary, that's a mortgage payment between roughly $1,450 and $2,100.

      What is the mortgage payment on a $150 000 house? ›

      A 30-year, $150,000 mortgage at a 7% fixed interest rate will be about $998 per month (not including property taxes or mortgage interest), while a 15-year mortgage at the same rate would cost about $1,348 monthly.

      How to make a home loan calculator in Excel? ›

      1. Enter the loan amount (₹500,000) in one cell, the annual interest rate (12%) in another cell, and the loan tenure (36 months) in a third cell.
      2. In the cell where you want to display the EMI, input the following formula =PMT(B2/12, B3, -B1)
      3. B2 refers to the cell containing the annual interest rate.

      How to calculate monthly mortgage payment in Google Sheets? ›

      Creating a Mortgage Calculator in Google Sheets

      First, open a new Google Sheets document. Next, input the necessary details such as loan amount, interest rate, and loan term. Then, use the PMT function to calculate monthly mortgage payments.

      How to calculate monthly payment? ›

      How to Calculate Monthly Loan Payments
      1. If your rate is 5.5%, divide 0.055 by 12 to calculate your monthly interest rate. ...
      2. Calculate the repayment term in months. ...
      3. Calculate the interest over the life of the loan. ...
      4. Divide the loan amount by the interest over the life of the loan to calculate your monthly payment.

      What happens if I pay two extra mortgage payments a year? ›

      Making additional principal payments will shorten the length of your mortgage term and allow you to build equity faster. Because your balance is being paid down faster, you'll have fewer total payments to make, in-turn leading to more savings.

      How much would a 200k mortgage cost? ›

      For a $200,000, 30-year mortgage with a 6% interest rate, you'd pay around $1,199 per month. But the exact cost of your mortgage will depend on its length and the rate you get.

      How to calculate monthly pay? ›

      First, to find your annual pay, multiply your hourly wage by the number of hours you work each week and then multiply the total by 52. Now that you know your annual gross income, divide it by 12 to find the monthly amount.

      What is the formula for monthly installment payment? ›

      The equation to find the monthly payment for an installment loan is called the Equal Monthly Installment (EMI) formula. It is defined by the equation Monthly Payment = P (r(1+r)^n)/((1+r)^n-1). The other methods listed also use EMI to calculate the monthly payment.

      How do you calculate monthly amount? ›

      Multiply your weekly wage by 52 (the number of weeks in a year), and then. Divide the result by 12 (the number of months in a year).

      What is the PMT formula for monthly payments? ›

      Example
      DataDescription
      FormulaDescription
      =PMT(A2/12,A3,A4)Monthly payment for a loan with terms specified as arguments in A2:A4.
      =PMT(A2/12,A3,A4,,1)Monthly payment for a loan with with terms specified as arguments in A2:A4, except payments are due at the beginning of the period.
      DataDescription
      8 more rows

      Top Articles
      Latest Posts
      Article information

      Author: Virgilio Hermann JD

      Last Updated:

      Views: 5971

      Rating: 4 / 5 (61 voted)

      Reviews: 92% of readers found this page helpful

      Author information

      Name: Virgilio Hermann JD

      Birthday: 1997-12-21

      Address: 6946 Schoen Cove, Sipesshire, MO 55944

      Phone: +3763365785260

      Job: Accounting Engineer

      Hobby: Web surfing, Rafting, Dowsing, Stand-up comedy, Ghost hunting, Swimming, Amateur radio

      Introduction: My name is Virgilio Hermann JD, I am a fine, gifted, beautiful, encouraging, kind, talented, zealous person who loves writing and wants to share my knowledge and understanding with you.