Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pmt function in Excel does not return correct monthly payment amou
annual int rate = 5.75
number of months = 360 principle - 320000 PMT answer = (103,667.97) This is not correct. Can someone advise correct format for computing this payment amount. Seesm straight forward. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UDF and Calculation tree | Links and Linking in Excel | |||
Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
Excel IF function for text | Excel Worksheet Functions | |||
Missing function in Excel 2003 | Excel Discussion (Misc queries) | |||
MS Excel Function - Networkdays | Excel Worksheet Functions |