How to Calculate a Mortgage PITI Payment

by Steve Lander
Spreadsheets help you solve loan problems.

If you're going to have a mortgage with an escrow account, your monthly payment gets divided four ways. Since it covers your principal, your interest, your property tax and your homeowners insurance, it's referred to as a PITI payment. To calculate it, you use a spreadsheet program to figure out the PI payment, then you estimate your TI payment. While it's hard to predict exactly how your lender will calculate your escrow TI payment, you can estimate the highest that it is likely to be and, with any luck, you'll get a pleasant surprise.

Use the PMT, which is an abbreviation for payment, function in your spreadsheet to solve for your principal and interest payment based on the length of your loan, the amount of the loan and your interest rate. For example, the command that will solve for the payment for a $225,000, 30-year loan at 5.25 percent interest would be "=pmt(5.25%/12,30*12,-225000)" in Excel or Google Spreadsheets or "=pmt(5.25%/12;30*12;-225000)" in Apache OpenOffice Calc. Entering the command will cause the spreadsheet to display the correct monthly payment -- $1,242.46. When you enter the command, leave out the quotation marks, and change the numbers to reflect your particular loan.

Add your annual property taxes together with your annual homeowners insurance premium. For instance, if your annual insurance premium is $1,050 and your annual tax payments are $1,825, your combined cost would be $2,875.

Divide the combined cost by 12 to find your monthly tax and insurance payment. If the annual cost is $2,875, the monthly cost would be $239.58.

Add your principal and interest payment to your estimated tax and insurance payment to find your total PITI payment. In this example, $1,242.46 plus $239.58 would give you a combined payment of $1,482.04.

About the Author

Steve Lander has been a writer since 1996, with experience in the fields of financial services, real estate and technology. His work has appeared in trade publications such as the "Minnesota Real Estate Journal" and "Minnesota Multi-Housing Association Advocate." Lander holds a Bachelor of Arts in political science from Columbia University.

Photo Credits

  • Stockbyte/Stockbyte/Getty Images
bibliography-icon icon for annotation tool Cite this Article