need a function to calculate a mortgage payment

[Guest]

Does anyone have a function to calculate a amortized mtg payment. I tried to
use the pmt function, and it came out all wrong. Have tried many different
iterations of the numbers, and they still do not come out to be same as my
Loan Officer Point software indicates the answer should be.

I need to put this function calulation in an excel spreadsheet.

Thanks

 

[Lotus123]

Thing to keep in mind with functions like PMT. Cash outflows have
negative sign ;cash inflows have a positive sign. As such, the resul
of a typical PMT formula will give you a negative number...and that i
okay.

So, if you have a mortgage payment on a 30 year $100,000 loan at 5
interest, you could calculate the payment as follows:

=PMT(0.05/12,30*12,100000)
NOTE - The 12's are to make everything calculated monthly instead o
yearly.

The answer is $536.82 per month. If that still seems off, then i
could be because the Loan programs wants the payment due at th
beginning of the month instead of the end of the month. If that is th
case, try the formula like this:

=PMT(0.05/12,30*12,100000,0,1)...the 1 at the end tells Excel th
payment will be made at the beginning of the month instead of the en
(and as such, slightly less interest).

Hope that helps