G Guest Feb 1, 2006 #1 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
B Bruno Campanini Feb 1, 2006 #2 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
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 Feb 1, 2006 #3 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...
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...
