Formula help

  • Thread starter Thread starter ~Jeff~
  • Start date Start date
J

~Jeff~

I want to calculate the monthly mortgage payment in my spreadsheet. The
interest rate is fixed

Cell values:

A4 = principle
A5 = interest rate
A6 = years of loan
A7 = monthly payment

I can do the calculation by hand, but can't make a formula .

The formula can be found on the following website:
http://www.mortgageassistanceusa.com/calculators/formula.html

The formula to use is for United States mortgage calculations

Thanks in advance,
 
One way:

A7: =PMT(A5/12,A6*12,-A4,0)

This assumes that the interest rate is the annual rate
 
I tried this way but the cell equals: #VALUE!

Here is the current cell values:

A4 = 100000
A5 = 4.25 (interest rate)
A6 = 30 (years)
 
I can't replicate that.

With A5=4.25%, the formula returns 491.94

If A5 = 4.25, instead, then the formula should be modified to

=PMT(A5/1200,A6*12,-A4,0)




~Jeff~ said:
I tried this way but the cell equals: #VALUE!

Here is the current cell values:

A4 = 100000
A5 = 4.25 (interest rate)
A6 = 30 (years)

--
~Jeff~
[Microsoft Windows XP Pro,Office 2000]
JE McGimpsey said:
One way:

A7: =PMT(A5/12,A6*12,-A4,0)
Click to expand...
Click to expand...
 
Back
Top