How to Calculate Monthly Payments - Posted by Ryan Cook

Real Estate Investing
1

Posted by Chris on February 09, 2000 at 19:05:15:

I come up with $228.26 per month(principal and interest).

PV=$9,000
I/Y=10
N=48

$228.26

Buy a financial calculator and check these links out:

http://www.creonline.com/m_comput.htm

http://www.creonline.com/b-119.htm

There are plenty of downloadable financial calculators.
One of those is:

-Chris

2

How to Calculate Monthly Payments - Posted by Ryan Cook

Posted by Ryan Cook on February 09, 2000 at 18:46:34:

I just found this site two days ago… and I have read just about every article I have found… You Guys are great… But I’m still confused about how you calculate the monthly payments on a property… let’s say that you have a property that sells for $10,000 … with $1,000 down for 48 months at 10% int… what would the monthly payment be with the interest… and how do you go about making the actual calculation…

Thanks for your time

3

Formula to Calculate Monthly Payment - Posted by Dave T

Posted by Dave T on February 09, 2000 at 22:45:48:

Monthly PMT = LoanAmount/((1-(1/(1+rate)^n))/rate)

Where rate is the monthly interest rate (divide the annual rate by 12) and n is the number of payment periods. The ^ means that the term (1+rate) is raised to the power of n.

While you don’t necessarily need a financial calculator to compute the monthly payment amount, you will at least need a calculator capable of raising a number to a power to use this formula.

4

Re: How to Calculate Monthly Payments - Posted by T Jent

Posted by T Jent on February 09, 2000 at 20:50:40:

Get an Amortization Booklet, available at any bookstore for a few bucks. You can look up payments at any amount, interest rate and term instantly. Financial calculators will do the same thing.

5

Re: How to Calculate Monthly Payments - Posted by Glenn OH

Posted by Glenn OH on February 09, 2000 at 19:38:36:

In excel
=PMT(annual % rate/12,#months,-principal)

From there you could also do an amortization table.

6

Re: How to Calculate Monthly Payments - Posted by Chris

Posted by Chris on February 09, 2000 at 19:09:30:

Ryan-

You may also want to head over to the Cash Flow Forum section of this site. There is a lot of good info over there.

-Chris