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