View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe User[_2_] Joe User[_2_] is offline
external usenet poster
 
Posts: 905
Default how I can calculate EAR with continuous compounding?

"salman" wrote
Subject: how I can calculate EAR with continuous compounding?


Assuming you mean effective annual rate, the Excel formula is:

=EXP(A1)-1

where A1 contains that nominal annual rate, e.g. 1% or 0.01.