View Single Post
  #27   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default How do I caluclate an Annual Percentage Rate in Excel?

Errata...

On Jul 26, 2:06 am, I wrote:
First, it appears that the dinkytown calculator treats the starting
interest rate plus margin as the (lifetime) interest rate cap.


Correction: It treats the current index plus margin as the lifetime
rate cap.