Financial Modeling Tutorials
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Present Value of an Annuity Formula
- Future Value of Annuity Due Formula
- Maturity Value
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- Advantages and Disadvantages of NPV
- Mutually Exclusive Projects
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Break Even Analysis
- Breakeven Analysis Examples
- Break Even Chart
- Benefit Cost Ratio
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Payback Period Advantages and Disadvantages
- Profitability Index
- Feasibility Study Examples
- Cash Burn Rate
- Interest Formula
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Growth Rate Formula
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Compounding
- Compounding Formula
- Compound Interest
- Compound Interest Examples
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Discounting Formula
- Rule of 72
- Geometric Mean Return
- Geometric Mean vs Arithmetic Mean
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- EWMA (Exponentially Weighted Moving Average)
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Relative Change
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- APR vs APY
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Correlation Examples
- Coefficient of Determination
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Standard Deviation Examples
- Effect Size
- Sample Size Formula
- Volatility Formula
- Binomial Distribution Formula
- Multicollinearity
- Hypergeometric Distribution
- Exponential Distribution
- Central Limit Theorem
- Poisson Distribution
- Central Tendency
- Hypothesis Testing
- Gini Coefficient
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- Z Score Formula
- Z Test vs T Test
- F-Test Formula
- Quantitative Research
- Histogram Examples
Related Courses
Continuous Compounding calculates the Limit at which the Compounded interest can reach by constantly compounding for an indefinite period of time thereby increasing the Interest Component and ultimately the portfolio value of the Total Investments
Continuous Compounding Formula (Table of Contents)
Continuous Compounding Formula
The formula for continuous compounding is:
Example of Continuous Compounding Formula
Let us analyze some of the instances:
If an initial investment of $1,000 is invested at 8% interest per year with continuous compounding, how much would be in the account after 5 years?
- P = $1,000, r= 8%, n= 5 years
- FV = P * e ^{rt} = 1,000 * e ^{(0.08) (5) }= 1,000 * e ^{(0.40)} [Exponent of 0.4 is 1.491] = 1,000 * 1.491^{ }
- = $1,491.8
Let us compute the effects of the same on regular compounding:
Annual Compounding:
- FV = 1,000 * (1 + 0.08) ^ 1 = $1,080
Semi-Annual Compounding:
- FV = 1,000 * [(1 + 0.08/2)] ^ 2
- = 1,000 * (1.04) ^ 2
- = 1,000 * 1.0816 = $1,081.60
Quarterly Compounding:
- FV = 1,000 * [(1 + 0.08/4)] ^ 4
- = 1,000 * (1.02) ^ 4
- = 1,000 * 1.08243
- = $1,082.43
Monthly Compounding:
- FV = 1,000 * [(1 + 0.08/12)] ^ 12
- = 1,000 * (1.006) ^ 4
- = 1,000 * 1.083
- = $1,083
Continuous Compounding:
- FV = 1,000 * e ^{0.08}
- = 1,000 * 1.08328
- = $1,083.29
As it can be observed from the above continuous compounding example, the interest earned from continuous compounding is $83.28 which is only $0.28 more than monthly compounding.
Another example can say a Savings Account pays 6% annual interest, compounded continuously. How much must be invested now to have $100,000 in the account 30 years from now?
4.9 (1,067 ratings)
- FV = PV * e^{rt}
- PV = FV * e – ^{rt}
- PV = 100,000 * e ^{– (0.06) (30)}
- PV = 100,000 * e ^{– (1.80)}
- PV = 100,000 * 0.1652988
- PV = $16,529.89
Thus, if an amount of $16,530 (rounded off) is invested today, it will yield $100,000 after 30 years at the given rate.
Another instance can be if a loan shark charges 80% interest, compounded on a continuous basis, what will be the effective annual interest rate?
- Interest rate = e ^{0.80} – 1
- = 2.2255 – 1 = 1.22.55 = 122.55%
Recommended Courses
Explanation of Continuous Compounding Formula
The continuous compounding formula determines the interest earned which is repeatedly compounded for an infinite time period.
where,
- P = Principal amount (Present Value)
- t = Time
- r = Interest Rate
The calculation assumes constant compounding over an infinite number of time periods. Since the time period is infinite, the exponent helps in a multiplication of the current investment. This is multiplied by the current rate and time. Despite a large number of investments, a difference in total interest earned through continuous compounding excel is less as compared to traditional compounding which will be looked into through continuous compounding example.
Use of Continuous Compounding Formula
The importance of continuous compounding formula is:
- Rather than continuous compounding of interest on a monthly, quarterly or annual basis, continuous compounding excel will effectively reinvest gains perpetually.
- The effect of allows the continuous compounding of interest amount to be reinvested thereby allowing an investor to earn at an exponential rate.
- This determines that it is not only the principal amount which will earn money but the continuous compounding of interest amount will also keep on multiplying.
Continuous Compounding Calculator
You can use the following Continuous Compounding Calculator
P | |
r | |
t | |
Continuous Compounding Formula = | |
Continuous Compounding Formula = | P x e^{(r x t)} = | |
0 * e^{(0 * 0) = } | 0 |
Continuous Compounding Formula in Excel (with excel template)
Let us now do the same example of Continuous Compounding Excel.
This is very simple. You need to provide the two inputs of Principle Amount, Time and Interest rate.
You can easily calculate the ratio in the template provided.
Continuous Compounding Example – 1
You can easily calculate the ratio in the template provided.
Let us compute the effects of the same on regular compounding:
As it can be observed from the continuous compounding example, the interest earned from this compounding is $83.28 which is only $0.28 more than monthly compounding.
Continuous Compounding Example – 2
Continuous Compounding Example – 3
Recommended Articles:
This has been a guide to Continuous Compounding formula, its uses along with practical examples. Here we also provide you with Continuous Compounding Calculator with downloadable excel template. You can refer following articles as well –
- Compounding Quarterly Formula
- Matrix Multiplication Excel Formula
- Compound Journal Entry Definition
- What is the Effective Annual Rate (EAR) Formula?
- What is the Effective Annual Rate (EAR)?
- Simple Interest Formula – Examples
- Simple Interest
- Net Present Value Formula
- Payback Period Formula
- IRR vs NPV
- 250+ Courses
- 40+ Projects
- 1000+ Hours
- Full Lifetime Access
- Certificate of Completion