# How Do I Calculate Paying Down the Principal on a Mortgage?

by Grant D. McKenzie

Paying additional principal can save money over the life of a mortgage loan.

Enter the initial amount of the loan, the monthly percentage rate -- the annual percentage rate (APR) divided by 12 -- and the term of the loan in months in three adjacent cells in your spreadsheet program. Calculate the monthly payment in a nearby cell. Example: \$500,000 30-year loan at 6 percent APR Cell A1 = "500000" (loan value) Cell B1 = "=0.06/12" (APR converted to monthly interest rate) Cell C1 = "=30*12" (loan term converted to months) Cell A3 = "=-PMT(B1,C1,A1)"

### How to Run PEX Tubing to a Toilet

Running PEX tubing to a toilet is a great way to.

• ### How to Get Plunger Marks Off a Toilet

Getting plunger marks off a toilet will require you to.

• ### How to Replace a Flush Valve Assembly on a.

Replacing a flush valve assembly on a toilet is.

### How to Unclog a Toilet With Boiling Water

Unclogging a toilet with boiling water is a relatively.

Source: homeguides.sfgate.com

Category: Credit