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)"
Trending in Your Area
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