I need a formula to calculate the payments based on loan amount, interest
rate and term of the loan. This is for mortgage payments
I need a formula to calculate the payments based on loan amount, interest
rate and term of the loan. This is for mortgage payments
"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
Try PMT(), read up on it.
Originally Posted by Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks