View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Compound interest and repayments on personal loan

Errata ....

I wrote:
If 10.4% is the nominal rate, try the following with 360 or 365:
=FV(10.4%/365, 365,, -1) - 1


Ah, simply 10.4%/365. The FV() above would be the APR.
Klunk!