Home Articles Forums Gallery Marketplace Videos

WoodCentral Forums

Knowledge You Can Build On — Est. 1998

Reach the woodworkers who ACTUALLY BUY

Calculating Mortgage Payments

Posts

Calculating Mortgage Payments

#1

Moses Yoder

Calculating Mortgage Payments

Moses Yoder

How do I calculate mortgage payments? Say I borrow $100,000 for 20 years, what would the formula be to figure out what the monthly payment is? Perhaps there are websites with a calculator on them that you could point me to. This is for a very important project that if it works out you will hear all the sweet details.

Re: Calculating Mortgage Payments

#3

Re: Calculating Mortgage Payments

Hal

The formula is:

i/1-(i/(1+i))n. If you want monthly payments, divide the annual rate by 12. "n" is the number of months of the term of the loan. I don't know of any way to show it on this machine, but n is an exponent; i.e., the term (i/(1+i)) is raised to the "nth" power. You need a calculator with this capability to do the equation. Good luck. Hal

Re: Calculating Mortgage Payments

#4

Re: Calculating Mortgage Payments

Jerry Nicholson

Microsoft Excel, OpenOffice, and Gnumeric spreadsheet programs all have numerous financial functions, including mortgage calculations, built in. Doing this kind of stuff in spreadsheets allows you to easily calculate "what ifs", like "what happens to the monthly payment and total amount paid in if I reduce the payment period from 30 to 25 years". Clue: Not much increase in the monthly payment, considerable reduction in the total paid.

Jerry

Re: Calculating Mortgage Payments

#5

Kneale Brownson

Free software I use *LINK*

Kneale Brownson

Is available from


Freeware

Re: Calculating Mortgage Payments

#7

Jim DeLaney, Austintown, Ohio

Re: Calculating Mortgage Payments

Jim DeLaney, Austintown, Ohio

Moses,

I emailed you an Excel file that does what you want.