| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mortgage Spreadsheet | Excel Discussion (Misc queries) | |||
| Calculations based on PivotTable information | Excel Discussion (Misc queries) | |||
| looping through a set of calculations | Excel Worksheet Functions | |||
| Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
| time interval calculations in excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
