ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how I can calculate EAR with continuous compounding? (https://www.excelbanter.com/excel-worksheet-functions/247324-how-i-can-calculate-ear-continuous-compounding.html)

Salman

how I can calculate EAR with continuous compounding?
 


Jarek Kujawa[_2_]

how I can calculate EAR with continuous compounding?
 
what do you mean by "EAR"?
Earnings at risk?
could you be more specific?
also provide a sample of your data

On 3 Lis, 09:34, salman wrote:



Joe User[_2_]

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.



All times are GMT +1. The time now is 03:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com