View Single Post
  #1   Report Post  
Harraman@Bangalore
 
Posts: n/a
Default 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.