Hi, I am doing something wrote when using NPER and PMT
I calculate nper(0.035/12, 100, 10000) which equals -87.9 which means I'll payoff the $10000 loan in 87.9 months by paying $100 every month.
Then I calculate pmt(0.035/12, 87.9, 10000) which equals $-129.14
Since I use the same 87.9 number of months in the PMT function, I would expect to get $100 as the payment amount, as I used in the NPER function.
Can you tell me what I'm doing wrong??
Bookmarks