Mortgage calculations
I need a formula to calculate the payments based on loan amount, interest
rate and term of the loan. This is for mortgage payments |
Mortgage calculations
"Jeff" wrote in message
... 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 whe pmt = payment pv = present value nper = number of payments rate = rate of interest Bruno |
Mortgage calculations
Try PMT(), read up on it. Jeff Wrote: I need a formula to calculate the payments based on loan amount, interest rate and term of the loan. This is for mortgage payments -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=507497 |
All times are GMT +1. The time now is 09:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com