Mortgage calculations

J

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
 
B

Bruno Campanini

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

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
 
M

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 payment
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

APR Fee Calculation 1
Variable interest rate loan calculations- PLEASE HELP!!! 1
Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geome 0
First row where a cell is zero 2
PMT function and 1st payment partway through a period 3
Computing mortgage APR 2
mortgage payment calculation 6
credit intrest on intrest 1

Top