User Tools

Site Tools


contint_continuous_compounding_interest_.htm
Navigation:  Templates > Guide to all Templates > Additional Libraries and Templates > Finance Library >====== CONTINT (continuous compounding interest) ====== Previous pageReturn to chapter overviewNext 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

Example:

PeriodicRate = AnnualInterestRate / (PeriodsPerYear * 100) ! Setup Variables

ActualRate  = PeriodicRate * TotalPeriods

ContinuousInterestAmount = CONTINT(Principal,ActualRate)   ! Call CONTINT

contint_continuous_compounding_interest_.htm.txt · Last modified: 2021/04/15 15:57 (external edit)