| **Navigation:**  [[templates.htm|Templates]] > Guide to all Templates > [[additional libraries and templates.htm|Additional Libraries and Templates]] > Finance Library >====== CONTINT (continuous compounding interest) ====== | [[compint compound interest .htm|{{btn_prev_n.gif|Previous page}}]][[additional libraries and templates.htm|{{btn_home_n.gif|Return to chapter overview}}]][[days360 days difference based on 360 day year .htm|{{btn_next_n.gif|Next page}}]] | | || **CONTINT**(//principal//,//rate//) | **CONTINT** | Computes total continuously compounded interest. | | //principal// | A numeric constant or variable containing the beginning balance, initial deposit, or loan. | | //rate// | A numeric constant or variable containing the //applied interest rate// for the given time frame. | **CONTINT **computes total continuously compounded interest based on a principal amount (//principal//) and an applied interest rate (//rate//). The returned amount includes the original principal plus the interest earned. Applied interest rate may be calculated as follows: PeriodicRate = AnnualInterestRate / (PeriodsPerYear * 100) AppliedRate = PeriodicRate * TotalPeriods **Return Data Type:**     DECIMAL **Internal Formulas:** {{contint.jpg|CONTINT.jpg}} **Example:** **PeriodicRate = AnnualInterestRate / (PeriodsPerYear * 100) ! Setup Variables** **ActualRate  = PeriodicRate * TotalPeriods** **ContinuousInterestAmount = CONTINT(Principal,ActualRate)   ! Call CONTINT**