Mortgage calculations

[Jeff]

I need a formula to calculate the payments based on loan amount, interest
rate and term of the loan. This is for mortgage payments

[Bruno Campanini]

"Jeff" <[email protected]> wrote in message
news:[email protected]...
>I need a formula to calculate the payments based on loan amount, interest
> rate and term of the loan. This is for mortgage payments

Excel Formula =PMT() (see Help)


Math Formula:
pv * rate
pmt = -------------------------
1
1 - ------------------
(1 + rate) ^ nper

where:
pmt = payment
pv = present value
nper = number of payments
rate = rate of interest

Bruno

[Morrigan]

Try PMT(), read up on it.

I need a formula to calculate the payments based on loan amount, interest
rate and term of the loan. This is for mortgage payments