Comments Off on Spreadsheet Formulas: Calculating Home Payments

Spreadsheet Formulas: Calculating Home Payments

2008
02.22

For a lot of homebuyers, calculating a prospective mortgage payment is an online experience. For example, a search on Google for “mortgage calculator” returns 39 million options.

Some people, however, prefer to plan on their local hard drive using spreadsheets. For these people, the hardest part is often figuring out what formulas to use.

Interest Only Payments

The spreadsheet formula for principal + interest home loan payments

Home loans with interest only payments are much more simple to calculate than amortizing loans.

Using the graphic at right as a guide, enter your loan size and your interest rate into two separate spreadsheet cells.

Then, create a third cell and input the following formula that calculates the “Monthly Payment”. The formula is:

= (Loan Size) * (Interest Rate) / 12

Principal + Interest Payments

Spreadsheet showing P+I formula

For a home loan with (principal + interest) payments, the formula is a little bit more complicated than with an interest only home loan.

Using the graphic at right as a guide, enter your loan size, your interest rate and the duration of your home loan into three separate spreadsheet cells.

Then, create a fourth cell and input the following formula that calculates the “Monthly Payment”. The formula is:

= – PMT(Interest Rate/12, Loan Term in Months, Loan Size)

For additional spreadsheet formulas and more in-depth reporting, explore your software’s “Help” feature to see what you can find.

Related Articles:

Mark Taylor | Arizona Home Loans | Blarming | Will You Listen to Me | Arizona Short Sales | Arizona Foreclosures | Arizona FHA Loans | Arizona USDA Loans | Arizona HUD Homes | Ariona VA Loans | Fix My Broken Credit | Arizona Mortgage | Arizona Short Sale | Power Ranch Bank Owned Homes

Your Reply

You must be logged in to post a comment.