I have an Access 2002 db that uses the NPer function to calculate
remaining periods for an amortization function. The NPer function
works fine, except with the following criteria: Rate = 7.5/12, Payment
= -880, PV = 140800. These numbers represent a interest only loan.
That is, the payment will only pay the interest each month. Whenever
this statement is run (NPER(.075/12,-880,140800)) an Error 5: Invalid
Procedure Call or Argument". Has anybody else run into this issue?
Any help will be greatly appreciated.