When amortising a loan based using an IRR rate, the total interest paid fall short.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello,

I need to calculate an effective interest rate for a customer for a
loan that is receiving regular, additional deposits that are not paid
by the customer.

The customers repayment is calculated using xls PMT function at a
retail interest rate. The extra deposits reduce the term/nper and the
total interest paid by the customer below the retail rate to a lower,
effective interest rate and it is the lower effective rate is that I
am attempting to derive.

I have used =IRR(J22:J382,-M12/12)*12 to calculate the effective p.a.,
interest rate for monthly cashflows and the answer is within the range
I would expect it to be.

However when I apply the IRR to calculate the actual interest paid
using xls PMT function, i.e. =(PMT(N21/12,J21,J22)*J21)+J22 the actual
interest paid is lower than it is when summed manually.

I have tested each of these formulas using a loan amortization
schedule that does NOT involve the extra repayments and the results
contra, so I have misunderstood the handling of the extra payments,

Does anyone have any suggestions as to where I am going wrong?

Thanks,

Mick
.

Relevant Pages

  • Re: Warrantee issue ?
    ... Rob's customer has already paid for a *finished* drum, ... Maybe the guy wanted to drill it and finish it himself even? ...
    (rec.music.makers.percussion)
  • Re: PayPal postage and special delivery
    ... paid for the stamps so ... And all this in front of a busy lunchtime queue. ... utterly pointless label for *every* item of mail. ... The customer gets ratty because the PO ...
    (uk.people.consumers.ebay)
  • Re: Yea for the RIAA!
    ... RIAA is looking for;-) ... version in 1974, I bought the 1984 release on CD, I bought ... I also have paid for the Pulse ... I'm not a normal music customer. ...
    (rec.audio.opinion)
  • euro1net fiasco
    ... that according to euro1net we will be told about refunds etc ... I paid by debit card and have some protection under the visa rules, ... If euro1net does not come back on, can anyone recommend a broadband ... customer for telephone) after the line is released - however my ...
    (uk.telecom.broadband)
  • Re: Warrantee issue ?
    ... Rob's customer has already paid for a *finished* drum, ... Maybe the guy wanted to drill it and finish it himself even? ...
    (rec.music.makers.percussion)